Q1. How do I create a new Trial Balance template?
Go to Settings > Templates > Reports > Accounting Tab, then click New Template (Trial Balance).
Alternatively, in Reports > Trial Balance, click the template selector (top right) and choose New Template.
Q2. What settings can I customize in my Trial Balance template?
The Trial Balance template has three tabs: General, PDF, and Actions.
General: Edit template name, baseline period, header, and footer.
Note: Dates in the template are relative to today. When the report runs, the baseline period autofills the reporting dates based on the run date.
PDF: Customize template style, font, header, and footer for PDF version of the report.
Template style: Choose different styles from Classic, Balanced, Modern, and Uniform
Font: Choose different fonts from Figtree, Inter, Lato, and Roboto
Header: Edit title position, headline (choose either company name or report title is printed first), report title, date title, and add a logo.
Footer: Turn on/off legal name and page number.
Note: PDF preview and export are only supported for up to 12 columns.
Actions: Specific actions you can do when you click on an element in the template.
Q3. What is the decorator function in Template Style for?
Turning on decorators for Template styles adds a horizontal line on top of the report.
Q4. What is the uppercase function in Fonts for?
Turning on uppercase converts all text in the report to uppercase.
Q5. Can I add a logo to my Trial Balance 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
Q6. What columns are supported in the Trial Balance template?
The Trial Balance template supports the following columns:
Comparative: Compare by previous days, months, quarters, or years, and adjust display order.
Adjustable:
Account Code (locked)
Account Name (locked)
Account Type
Status
Debit (PHP)
Credit (PHP)
Account Currency
Debit (Source)
Credit (Source)
Note: Account Code and Account Name columns are locked. Debit and Credit columns cannot be hidden. (Source) pertains to the org’s default currency.
Q7. 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.
Q8. How do I select/hide/arrange columns in the Trial Balance template?
To add comparative columns, click Compare (beside the baseline period date).
To show or hide columns:
Click the column icon at the top right of the template.
In the panel, you’ll see two lists: Hidden Columns and Selected Columns.
To show a column, move it from Hidden Columns to Selected Columns.
To hide a column, hover over it in the Selected Columns list and click the hide icon.
Note: Debit and Credit columns cannot be hidden.
To arrange columns:
Click the column icon at the top right of the template.
In the Selected Columns list, hover over a row and drag it to your preferred position.
Note: Account Code and Account Name are locked and cannot be moved.
Q9. How do I duplicate a Trial Balance template?
Go to Settings > Templates > Reports, hover over the template, click the three-dot icon, and select Duplicate.
Q10. What happens when I update a Trial Balance template?
Changes apply automatically. For previously downloaded reports, redownload them to apply updates.