Monthly Trial Balance Report

The Monthly Trial Balance Report provides a summary of account balances across different months within a selected accounting year.

Step by Step Guide: 

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

2. Expand the Trial Balance & Summary Reports section.

Click Monthly Trial Balance Report to open the report selection page.

3. Enter Report Parameters

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

• Accounting Year – Select the accounting year for the report.
• From Month – Choose the starting month for the trial balance.
• Alternative Accounting Year End – Select an alternative year-end if applicable.
• Show Sub GL Account Detail? – Check this box to include sub-ledger account 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

• Click Preview to generate the Monthly Trial Balance Report on-screen.
• Select Excel to download the report for further analysis.
• Click Print for a hard copy if needed.

6. Understanding the Monthly Trial Balance Report

The Monthly Trial Balance Report provides an overview of active ledger accounts across multiple months, ensuring financial accuracy and account reconciliation.

Key Sections of the Report

• Account Number & Name – Displays all GL accounts in numerical order.
• Opening Balance – Shows the balance of each account at the start of the selected period.
• Monthly Debit/Credit Columns – Displays monthly transactions affecting each account, covering January through December.
• Total Balances – Ensures that total debits and credits match, confirming financial accuracy.

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