This article explains how to generate a trial balance report in d6. A trial balance displays a list of ledger accounts with the total amounts of all transactions posted on each general ledger account, and must balance to R0.00.

Reports > Finances > Transactions: Trial Balance

What is a trial balance?

A trial balance displays a list of ledger accounts with the total amounts of all transactions posted on each general ledger account. Each of these general ledger accounts contains the detailed transactions which represent the amounts. In d6, there are a few additional options available on the trial balance which are not available in other accounting systems.

How do I generate a trial balance?

1. Choose whether you want to generate the report to a date or for a period. Note that with a period, the opening balances are not included.

2. Enter the date or dates you want to generate the report for.

3. Choose whether you want to see only balance columns or debit, credit, and balance columns.

4. Choose whether the profile control accounts should be consolidated.

5. Choose the account under which projects should be included either the project control account which reflects on the balance sheet or the profit/ loss account which reflects on the income statement.

6. Choose whether to show accounts or projects with a zero balance.

7. Choose whether to print the balance sheet and income statement separately.

8. Click the generate button to show the report. The report will be generated as a PDF document. You will need Adobe Acrobat Reader to view this document. If you need an excel version you can use our audit tool for this.

Important notes

• Date vs period: Generating to a date includes opening balances, while generating for a period does not.

• Consolidated profiles: When profile control accounts are consolidated, they are grouped together for a simpler view.

• Zero balances: You can choose to show or hide accounts and projects with a zero balance.

Frequently asked questions

Where do I find the trial balance report in d6?

Navigate to Reports > Finances > Transactions: Trial Balance.

What is the difference between generating to a date and for a period?

Generating to a date includes opening balances in the report. Generating for a period excludes opening balances and only shows transactions within that period.

What format is the trial balance report generated in?

The report is generated as a PDF document. You will need Adobe Acrobat Reader or a compatible PDF viewer to open it. If you use the audit tool you can extract an excel version.

Why does my trial balance not balance to R0.00?

If your trial balance does not balance, there may be transactions that have not been correctly posted or journals that are incomplete. Review recent transactions and ensure all entries have matching debits and credits. It can also be that your GL account active date is incorrect.