Trial Balance

Settings

User Settings

Navigation: Main Menu > Setup > Settings > Users (tab).

• Accounting: Financial Statements - Access Allowed: Options include Yes or No.

Default View

Buttons Explained

• View

  • Generates a report according to the selected Data Filters.

• Output

  • Output PDF documents. Options include 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)

Data Filters Explained

• Financial Year: Select a Financial Year.

• Period: Select Start and Ending Months within the selected financial year.

• Report: A dropdown list with custom-created reports.

• Filter: Select All, Statement of Profit or Loss or Statement of Financial Position to only show balances for accounts that appear on those statements.

• Show all Accounts checkbox: Tick to show all accounts, including those with zero balances.

• Order by Acc No. checkbox: Tick to order by Account Number (if account numbers are in use).

• Radio buttons:

  • Accounting: Select to display a conventional accounting Trial Balance.

  • Categories: Select to display the balances of the respective accounting Categories.

  • Transaction: Select to display a list of transactions and their balances.

Fields Explained: Accounting

• Report: Displays whether the account appears on the Statement of Profit or Loss (Income Statement) or the Statement of Financial Position (Balance Sheet).

• Category: Displays the accounting Category the account belongs to.

• Account Group: Displays the main account names where there are sub-accounts.

• Account: Displays the Account Names.

• Acc No.: Displays the Account Number.

• Opening: Displays the Opening Balances (i.e. balances from the previous financial year).

• Movement: The net effect of all the transactions in that account for the selected period.

• Debit: The Debit balances of all the accounts.

• Credit: The Credit balances of all the accounts.

Fields Explained: Categories

• Report: Displays whether the account appears on the Statement of Profit or Loss (Income Statement) or the Statement of Financial Position (Balance Sheet).

• Category: Displays the accounting Categories.

• Opening: Displays the Opening Balances (i.e. balances from the previous financial year).

• Movement: The net effect of all the transactions in that category for the selected period.

• Debit: The sum of all the Debit balances in that category.

• Credit: The sum of all the Credit balances in that category.

Fields Explained: Transaction

• Report: Displays whether the account appears on the Statement of Profit or Loss (Income Statement) or the Statement of Financial Position (Balance Sheet).

• Category: Displays the accounting Category the account belongs to.

• Account Group: Displays the main account names where there are sub-accounts.

• Account: Displays the Account Names.

• Acc No.: Displays the Account Number.

• Contra Account: The Account for the other side of the transaction.

• Contra Acc. No.: The Account Number of the contra account.

• Type: A code indicating the source Transaction Type.

• No. The auto-generated Transaction Number.

• Trans Date: The Date entered for the transaction.

• Period: The Period into which the transaction was posted.

• Company: The Name of the Customer or Supplier.

• Item: The Item Number of the transaction.

• Reference: The Reference typed into the original transaction.

• Debit: The Debit balance of a transaction.

• Credit: The Credit balance of a transaction.

• Menu (...):  Shortcut to display the original transaction.

Related Topics

• Tutorial: Trial Balance