Trial Balance
The Trial Balance workbook provides a detailed view of your general ledger balances for a selected period. It includes Opening Balance and Ending Balance, along with period activity shown as Debit and Credit. This format is commonly used to validate that debits and credits are in balance, support account reconciliations, and review account movements in one place.
Selection page
When you open the workbook, the Selection Page appears. It lets you choose what you want to see before the trial balance loads. The Run As Date and Reporting Book fields are required (shown in grey) and must be completed before you can confirm. All other filters are optional and help you narrow the results.
- Run As Date – (mandatory) the "as of" date for the trial balance.
- Reporting Book – (mandatory) the primary reporting book used for balances.
- Adjustment Book
- Location – (required for multi-currency) select a single location to avoid mixing currencies.
- Department
- Project
- Customer
- Vendor
- Item
- Product Line
- Class
- Warehouse
- Project Type
- CustomerType
- Vendor Type
- Employee Type
- Employee
Trial Balance
The report lists each account and shows balances and activity for the selected period.
- Opening Balance: account balance at the start of the period you're reporting on (balance carried forward into the period).
- Debit: total debits posted to the account during the period. In general, debits increase assets and expenses, and decrease liabilities and equity.
- Credit: total credits posted to the account during the period. In general, credits 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 shows the key dates and settings it used to generate the Trial Balance (as-of date, comparison periods, books, and any filters). Review these values to make sure they match your selection. If something looks incorrect, return to the Selection Page, adjust your choices, and open the workbook again. Only the blue cells can be edited and all other values come from the selection page.
| Report 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, the workbook combines the Reporting Book and Adjustment Book results 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 (Location, Department, Project, etc.), you can choose whether to include sub-dimensions. Turn this on when you want the selection to include all child values under the dimension you chose (for example, a parent department and all of its sub-departments). If a dimension doesn't show a sub-dimension toggle, it means there is no hierarchy available for that dimension in Sage Intacct.