Trial Balance
The Trial Balance workbook shows general ledger balances for a selected period, including Opening Balance, Debit, Credit, and Ending Balance. It is one of the most fundamental reports in financial close, used to confirm that debits and credits are in balance, support account reconciliations, and review how individual accounts moved during the period. Because it works at the account level, it is also a reliable starting point when investigating discrepancies or validating posted transactions before closing a period.
Selection page
When you open the workbook, the Selection Page appears before the trial balance loads. Run As Date and Reporting Book are required fields and must be completed before you can proceed. All other filters are optional and help you narrow the results.
- Run As Date – the "as of" date for the trial balance. (required)
- Reporting Book – the primary reporting book used for balances. (required)
- Adjustment Book
- Location – select a single location to avoid mixing currencies. (required for multi-currency)
- Department
- Project
- Customer
- Vendor
- Item
- Product Line
- Class
- Warehouse
- Project Type
- CustomerType
- Vendor Type
- Employee Type
- Employee
Trial Balance
The report lists each account with its balances and activity for the selected period.
- Opening Balance: account balance at the start of the reporting period, carried forward from the prior period.
- Debit: total debits posted to the account during the period. Debits generally increase assets and expenses, and decrease liabilities and equity.
- Credit: total credits posted to the account during the period. Credits generally decrease assets and expenses, and increase liabilities and equity.
- Ending Balance: balance at the end of the period, calculated as Opening Balance + Debit - Credit.
Parameters
The workbook displays the key dates and settings used to generate the trial balance, including the as-of date, books, and any active filters. Review these values to confirm they match your selection. If something looks incorrect, return to the Selection Page, adjust your choices, and reopen the workbook. Only blue cells are editable. All other values come directly from the selection page.
| Setting | Description |
|---|---|
| Reporting Book | The main book used to calculate balances. Set on the selection page. |
| Adjustment Book | Optional adjustment book. Set on the selection page. |
| Combine Reporting and Adjustment | When enabled, combines the Reporting Book and Adjustment Book into a single set of balances. |
| Statistical Accounts | Controls whether statistical (non-financial) accounts are included. These accounts don't represent GL transactions and often store quantities or other operational values used for reporting. Options: Exclude (default), Include, Only. |
For each dimension filter such as Location, Department, or Project, you can choose whether to include sub-dimensions. Enable this option when you want the selection to cover all child values under the selected dimension, for example a parent department and all of its sub-departments. If a sub-dimension toggle is not available, it means no hierarchy exists for that dimension in Sage Intacct.