Skip to content
English
  • There are no suggestions because the search field is empty.

Trial Balance Report

The Trial Balance Report provides a summary of all ledger accounts, displaying the total debit and credit balances for a selected period.

Step by Step Guide: 

1. Go to ACCOUNTING > General Ledger > General Ledger Statements and Reports.

2. - Locate and expand the Trial Balance & Summary Reports section.

  • Click on Trial Balance Report to open the report selection page.

3. Enter Report Parameters

On the Trial Balance Report Selection page, configure the following options:

  • Accounting Year & Month – Select the period for which the report is needed.
  • Show Sub GL Account Detail – Check this box if you want to include sub-ledger details.
  • Currency Selection – Choose between Office Home Currencies or Convert to Selected Currency.

4. Apply Filters

  • Entity Selection – Select an entity to auto-populate linked offices.
  • Office Selection – Choose specific offices or enable Separate Report for Each Office.
  • Include Inactive Offices – Check this option if required.

5. Generate & Export the Report

  1. Click Preview to generate the Trial Balance Report on-screen.
  2. Select Excel to download the report in a structured format for further analysis.
  3. Click Print if a hard copy is needed.

6. Understanding the Trial Balance Report

The Trial Balance Report provides an overview of all active ledger accounts, ensuring that total debits match total credits. It is used to identify discrepancies before preparing financial statements.

Key Sections of the Report

  1. Account Number & Name – Lists all GL accounts in numerical order.
  2. Debit & Credit Columns
    • Current Month Debit/Credit – Displays transactions posted within the selected month.
    • Year-to-Date Debit/Credit – Summarizes transactions for the entire accounting year.
  3. Total Balances – The final row should balance, ensuring financial accuracy.

Tip: - If an agency uses custom fields on GL accounts, these will be included in the Excel export format.

  • If the total debits and credits do not match, review journal entries for errors before closing the books.Tip!