Trial Balance

The Trial Balance is the place to check that all the Accounting Transactions balances.

A Trial Balance shows the movement of values between Balance Sheet and Income Statement accounts. The Opening option is used for Real Accounts that are only updated once annually, e.g., Retained Earnings. With this option, the Trial Balance is only populated with the Opening Balance as at the start of the Financial Year.

Discover Trial Balance

Get Started

The Trial Balance module is a fixed module that needs to be added to the Main Menu or/and to the Tile menu using Main Menu > Setup > Menu Manager.

User Access needs to be granted in Main Menu > Setup > Settings > Users > Accounting > Trial Balance - Access Allowed.

Trail Balance Interface

Navigation

Main Menu > Accounting > Trial Balance > View

  1. Report - This allows you to filter the data displayed in the data grid by Report.
  2. Date Filter - The Date Filter allows you to select a Financial Year followed by a range of Months (Periods) in the Financial Year. The Financial Year filter will automatically be populated to include the dates of all the Ledger Transactions. The Periods filter will be populated according to the Setting: Financial Year - Starting Month in Accounting Setups.
  3. Filter - This allows you to select what is shown in the data grid - this is used for Reporting or Output purposes.
    • All - This shows all the Trial Balance records.
    • Income Statement - This shows only Income Statement records.
    • Balance Sheet - This shows only Balance Sheet records.
  4. Show all - This allows you to view all the Trial Balance accounts, even if there is no movement against them. By default, only Accounts with values in them are displayed.
  5. Balance - This shows the Balance. If the Trial Balance is out of balance, this value will display in red.
  6. Balance Summary - This shows the total balance for the Account.
  7. Menu - The Menu button provides the following additional functionality:
    • Conditional Formatting - This allows you to add Excel-inspired Conditional Formatting parameters. The Conditional formatting is set at runtime and will persist if the grid is saved. Formatting includes colour highlights, bars and icons based on the cell value. You are able to add Conditional Formats to specific fields, like: All, Opening, Debit, Movement, Category, Credit or the Current Selection.
    • Rebuild - This will Rebuild the Trail Balance ensuring all records are current and accurate.
    • The Trail Balance module has three views:

a. View Categories (see below)

b. View Accounts

c. View Transactions

a. Categories View

The Categories view sorts the report by Categories.

Navigation

Main Menu > Accounting > Trial Balance > Menu > View Categories > View

  1. Report - This shows what Accounting Report the Account is linked to - Balance Sheet or Income Statement.
  2. Category - This shows which Accounting Category the Account is linked to.
  3. Opening - This shows the Opening Balance.
  4. Movement - This shows what values have moved through the Account.
  5. Debit - This shows the total Debits against the selected Account for the selected date period. This can be set-up in Main Menu > Setup > Accounting Setups > Categories > Type.
  6. Credit - This shows the total Credits against the selected Account for the selected date period.
  7. Balance - This shows the total balance for the Account.

b. Accounts View

The Accounts view displays a list of Accounts and their corresponding balances.

Navigation

Main Menu > Accounting > Trial Balance > Menu > View Accounts > View

  1. Account Group - This shows what Account Group this record is linked to.
  2. Account - This shows what Account this record is linked to. By double-clicking on an Account will open the Ledger.

c. Transactions View

The Transactions view displays all the Transactions that make up the Trial Balance.

Navigation

Main Menu > Accounting > Trial Balance > Menu > View Transactions > View

  1. Contra Account - This shows the Contra Account.
  2. Type - This shows the Type of Transaction.
  3. No. - This shows the Transaction number.
  4. Trans Date - This shows the Date when the Transaction was created.
  5. Company - This shows the Company linked to the Transaction.
  6. Item - This shows the amount of Items.
  7. Reference - This shows the reference for the Transaction.

Note

When VAT is included in the Trial Balance, the rounding of VAT amounts may cause the Trial Balance to be out of balance by a few cents.

For more on how to setup Account Categories for Trial Balance, click here.