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.
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.
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.
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.
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.
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).
Yes, you can add sub-groups within a group row.
Check your Chart of Accounts to ensure the account type is included in the Balance Sheet report.
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.
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.
Yes. Select the row and check Hide Row if Zero Balance.
Go to Settings > Templates > Reports, hover over the template, click the three-dot icon, and select Duplicate.
Changes apply automatically. For previously downloaded reports, redownload them to apply updates.
