Trial Balance

Overview

A Trial Balance is a financial report used in accounting to verify that all the debit entries have matching credit entries.
This document lists all the accounts from the general ledger with their balances at a specific date.
By default, the layout follows the Chart of Accounts.

Settings

User Settings

Note

The defaults are the values for new databases and new users. Your database may have different values.

Setting	Description	Default
Accounting: Accounting Reports - Access Allowed	Yes or No.	No
Accounting: Enable Override on Trial Balance Errors	Yes or No. Yes shows the Override Trial Balance error checkbox on a ledger entry with debits and credits that do not balance (see Trial Errors Tutorial).	No

General Settings

Setting	Description	Default
Reports > Reports: Show company name in header	Yes or No.	No

Default View

Buttons Explained

Button	Description
Reset	Resets the Data Filters to default.
View	Generates a trial balance based on the data filters.
Output	Output PDF documents. Options include Print, Preview and Email.
Menu	Export Email Excel: Opens an email message with the report attached in .xlsx format. Export Grid: Generates a report in .xlsx format and lets you select a save location. Layout Save Grid Restore Grid Restore Default Grid (All Users)

Data Filters Explained

Filter	Description
Financial Year	Generates a report for the financial year selected.
Period	Filters the data to only include the selected start and end periods.
Show all Checkbox	If checked, the report shows all the accounts, even those with zero balances.
Order by Account No.	Sorts the report by the account numbers (codes) if they are used.

Fields Explained

Field	Description
Balance	The difference between the Debit and Credit columns. The Balance must be zero. If the balance is not zero, see Trial Errors.
Field Chooser (*)	Use to add or remove columns to the report.
Type	Displays whether the account appears on the Statement of Financial Position or Statement of Profit or Loss.
Category	The account's category as per the Chart of Accounts.
Group	The account's group as per the Chart of Accounts.
Sub-Group	The account's sub-group as per the Chart of Accounts.
Account	The account's description.
Account No.	The account number (code).
Opening	The balance at the end of the previous financial period. Only applicable to accounts on the Statement of Financial Position.
Movement	The change during the period selected.
Debit	Lists the totals of all accounts with debit balances.
Credit	Lists the totals of all accounts with credit balances.
Total	Displays the debit and credit balances in a single line. Credits are negative numbers.
Menu (...)	Click it once to show the eye icon, then click the eye icon to open the Detailed Ledger (or double-click the entry).

Output Templates

For the data available on output templates, see Output Data Pipelines.