Trial Balance
1. Overview
The Trial Balance report in Sumo Ledger generates a summary of all account balances for a selected period, displaying debit and credit totals for each account. It is used to verify that total debits equal total credits across the ledger, which is a fundamental check in double-entry accounting.
Navigation: Reports > Trial Balance
URL: https://las.ledger.raralabs.dev/trialbalance/list
2. Report Filters
The Trial Balance report provides the following filters:
| Filter | Description |
|---|---|
| Select Date | A date range picker (e.g., 2026-06-13 to 2026-07-13) that defines the reporting period. |
| Reporting Groups | A dropdown to select a reporting group (e.g., default_reporting_group). This scopes the report to accounts within that group. |
| Asset | A dropdown to filter by asset type (e.g., defaultNpr, Points). |
| Owner | A text field to filter by account owner. |
| Visible Columns | A multi-select dropdown to choose which columns are displayed in the report. Defaults to all items selected. |
| Aggregate Data | A checkbox that, when enabled, aggregates balances across sub-level accounts. Enabled by default. |
| Cash Only | A checkbox that, when enabled, shows only cash-based entries (excludes accruals). Disabled by default. |
Generating the Report
After setting your filters, click "Get Report" to generate the trial balance.
3. Report Output
The report displays a table with account-level debit and credit totals. The exact columns depend on the Visible Columns selection but typically include account names, debit totals, and credit totals.
A TOTAL row at the bottom sums all debits and credits. In a balanced ledger, total debits should equal total credits.
Exporting
Click "Export Data (.xlsx)" to download the trial balance as an Excel spreadsheet for offline analysis or archival.
4. Best Practices
- Run the trial balance at the end of each reporting period to verify that the books are balanced.
- Use Reporting Groups to scope the report to specific fiscal periods or organizational segments.
- Enable Aggregate Data for summary views and disable it when you need to see individual subaccount breakdowns.
- Export to Excel for formal reporting or when you need to share the trial balance with auditors or management.
- Investigate any imbalance immediately. If total debits do not equal total credits, review recent postings and journals for errors.