Go to **ACCOUNTING &gt; General Ledger &gt; General Ledger Statements and Reports**.

Expand the **Trial Balance & Summary Reports** section.

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

### **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.

###

### **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.

### **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.

## **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.

- 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.

Accountabilityone

The Monthly Trial Balance Report provides a summary of account balances across different months within a selected accounting year. It helps finance teams ensure that total debits and credits are balanced before generating financial statements. This report is essential for verifying financial accuracy, reconciling accounts, and tracking monthly changes in financial positions