Trial Balance

Overview

The Trial Balance displays a list of all the accounts with their respective debit or credit balances. It is the first step in the financial statement preparation process, highlighting potential errors or discrepancies.

Navigation Example

Main Menu > Accounting > Financial > Menu (button) > Trial Balance

Buttons Explained

Button Description
ViewGenerates a Trial Balance according to the selected filters.
OutputOutputs the Trial Balance in PDF format. The output options are Print, Preview and Email.
Menu
  • Reset Data Filters: Resets any changes to the data filters.
  • Hide decimal values: Toggles showing or hiding decimal values.
  • Views
    • Dashboard
    • Statement of Profit or Loss
    • Statement of Financial Position
    • Trial Balance
  • Layout & Grids
    • Email Excel
    • Export Grid
    • Save
    • Save (All Users)
    • Restore Default (All Users)

Filters Explained

Filter Description
Financial YearA dropdown list of available financial years for selection.
PeriodSelect Start and Ending Months within the selected financial year.
ReportA dropdown list with custom-created Accounting Reports.
FilterSelect All to display all the accounts. Select Profit or Loss or Financial Position to only show balances for accounts that appear on the respective statements.
Show all AccountsA checkbox. If checked, all the accounts appear, including those with zero balances.
Order by Acc No.A checkbox. If checked, accounts are ordered by Account Number (if account numbers are used).
Radio buttons
  • Accounting: Displays a conventional Trial Balance.
  • Categories: Displays the balances per accounting category.
  • Transaction: Displays a list of transactions for the selected period.

Accounting View Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
ReportDisplays whether the account appears on the Statement of Profit or Loss (Profit or Loss) or the Statement of Financial Position (Financial Position).
CategoryThe accounting category the account belongs to.
Account GroupDisplays the main account names if an account has sub-accounts.
AccountDisplays the Account Names.
Acc No.Displays the Account Number.
OpeningDisplays the Opening Balances (that is, balances from the previous financial year).
MovementThe net effect of all the transactions in that account for the selected period. Net credit movements appear as negative numbers.
DebitThe Debit balances of all the accounts.
CreditThe Credit balances of all the accounts.
Menu (...)A context menu with the following options:
  • Add Financial Statements Notes: Opens an interface allowing a note to be entered. The note can be viewed and edited from the Dashboard.
  • View Detailed Ledger: Opens the selected account's detailed ledger.

Categories View Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
ReportDisplays whether the account appears on the Statement of Profit or Loss (Profit or Loss) or the Statement of Financial Position (Financial Position).
CategoryThe applicable accounting category.
OpeningDisplays the Opening Balances (that is, balances from the previous financial year).
MovementThe net effect of all the transactions in that category for the selected period.
DebitThe sum of all the Debit balances in that category.
CreditThe sum of all the Credit balances in that category.
BalanceThe debit (positive) and credit (negative) balances with a total at the bottom.

Transaction View Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
ReportDisplays whether the account appears on the Statement of Profit or Loss (Income Statement) or the Statement of Financial Position (Balance Sheet).
CategoryDisplays the accounting category the account belongs to.
Account GroupDisplays the main account names if an account has sub-accounts.
AccountDisplays the Account Names.
Acc No.Displays the Account Numbers.
Contra AccountThe Account for the other side of the transaction.
Contra Acc. No.The Account Number of the contra account.
TypeA code indicating the source Transaction Type.
No.The Transaction Number.
Trans DateThe Date entered for the transaction.
PeriodThe Period into which the transaction was posted.
CompanyThe name of the Customer or Supplier.
ItemThe sequential number allocated to each item on a transaction.
ReferenceThe transaction's reference field.
DebitThe amount that was debited.
CreditThe amount that was credited.
Menu (...)Shortcut to display the original transaction.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.