Q1. How do I create a new Balance Sheet template?
Go to Settings > Templates > Reports > Accounting Tab, then click New Template (Balance Sheet).
Alternatively, in Reports > Balance Sheet, click the template selector (top right) and choose New Template.
Q2. What settings can I customize in my Balance Sheet template?
Balance Sheet template has three tabs: General, PDF, and Actions.
General: Edit template name, baseline period, header, sorting, and footer.
PDF: Customize layout, header, and footer for PDF version of the report.
Actions: Perform specific functions on a selected column or row.
Q3. What columns are supported in the Balance Sheet template?
Comparative Periods: Choose date range, comparison type (day/month/quarter/year), and display order.
Variance: Show changes between two columns (amount or %). Multiple allowed.
Year-to-Date: Show totals from start of year to selected period. Multiple allowed.
Account Code: Display Chart of Account codes. Only one allowed.
Q4. How do I add or delete columns in the Balance Sheet template?
By default, only the baseline period column is shown.
To add columns:
Click Compare to add additional period columns.
Hover over a column line to add Year-to-Date or Account Code columns.
Hover over a column line and add Variance once at least two comparison periods are available.
To delete a column, click the column, then under Actions, select Delete Column.
Q5. What are the different types of rows in the Balance Sheet template?
Accounts that are included in the Balance Sheet template are grouped into Group-level Rows (bold texts) and Child-level Rows (normal texts).
Group-level Rows represent a group of accounts where you can:
Rename the group.
Show or hide group totals.
Hide the group if all child rows are hidden.
Set account criteria to define which accounts are included.
Set negative balance rules.
Child-level Rows represent individual account rows where you can:
Create new account groups.
Set negative balance rules.
Group selected accounts together by choosing Create New Account Group (accounts below will be grouped under it).
Text Rows allow you to insert custom text and can be added to both group and child levels.
Q6. How do I add or delete rows in the Balance Sheet template?
To add a Group Row, hover over a row line and click +Account Group. Enter the group name and account criteria.
To add a Text Row, hover and select +Text Row (available for both group and child levels).
Q7. How do I add a group within a group row?
Yes, you can add sub-groups within a group row.
Q8. My account is not appearing in my Balance Sheet template, what do I do?
Check your Chart of Accounts to ensure the account type is included in the Balance Sheet report.
Q9. What is the Negative Balance rule and how do I use it?
The Negative Balance rule defines what happens when an account amount falls below zero. Rules can be applied at both the Group-level Row and Child-level Row.
Group Row Rules
Choose conditions such as “if accounts are negative” or “if the entire group is negative.”
Move negative balances to another group or convert them to positive values.
Child Row Rules
When an individual account is negative, you can move it to a selected group.
Note: Account-level (child row) rules take precedence over group-level rules. Check for conflicts when both are applied.
Q10. How do I combine accounts into one group row?
Yes. You can combine multiple accounts into a single group row.
To select multiple accounts:
Press Cmd/Ctrl + Left Click: Select specific accounts individually.
Press Shift + Left Click: Select a range of accounts from the first to the last row.
Q11. How do I hide an account row with zero balance?
Yes. Select the row and check Hide Row if Zero Balance.
Q12. How do I duplicate a Balance Sheet template?
Go to Settings > Templates > Reports, hover over the template, click the three-dot icon, and select Duplicate.
Q13. What happens when I update a Balance Sheet template?
Changes apply automatically. For previously downloaded reports, redownload them to apply updates.