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.
Note: PDF preview and export are only supported for up to 8 columns.
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 COA 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.
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. Can I rename group-level rows in the Balance Sheet template?
Yes, click on the group row and rename accordingly.
Q8. What is the decorator function in Template Style for?
Turning on decorators for Template styles adds a horizontal line on top of the report.
Q9. What is the uppercase function in Fonts for?
Turning on uppercase converts all text in the report to uppercase.
Q10. Can I add a logo to my Balance Sheet Template?
Yes, go to Template Settings > PDF > Add a logo
Logo file should only be up to 1mb with min width: 120px and min height: 60px
Q11. Can I change the display currency?
Yes, to change the display currency, click the base currency.
The report will be converted from base currency to display currency at the exchange rate on report date. If there're multiple periods, all periods will be converted at the same exchange rate.
Q12. What is the dynamic string in the PDF Date Title for?
You can use the dynamic string for dates to configure your date title according to your preferred format.
Q13. Can I add another group within a group row?
Yes, you can add sub-groups within a group row.
Q14. My account is not appearing in my Balance Sheet template, what do I do?
Check your COA to ensure the account type is included in the Balance Sheet report.
Q15. 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.
Q16. How do I combine accounts into one row or one group?
You can combine multiple accounts into a single group row or group.
To select multiple accounts:
Press Cmd/Ctrl + Left Click: Select specific accounts individually.
Press Shift + Left Click: Select a range of accounts.
Then from the action tab, choose to combine into a single row or a group.
Q17. How do I split combined accounts?
You can split a combined account row or group by selecting the row and from the action tab, select split accounts or remove group.
Q18. How do I hide an account row with zero balance?
Yes. Select the row and check Hide Row if Zero Balance.
Q19. 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.
Q20. What happens when I update a Balance Sheet template?
Changes apply automatically. For previously downloaded reports, redownload them to apply updates.
Q21. Can I have more than one template for different situations?
Yes, you can create multiple Balance Sheet Templates to cover different report situations.
Q22. If I add a new account to my COA, will it automatically show up in my template?
Yes, any new account added to your COA will automatically appear in your Balance Sheet template based on the criteria you’ve set for your groups.