table-columnsTrial Balance

Review debit and credit totals by account for a given period to verify the books are in balance.

Accessing the report

Go to AccountingTrial Balance. The report defaults to Last year, By month. Use the date picker to select any period, and the entity dropdown to filter by entity.

The date picker includes presets for common ranges: this/last month, this/last quarter, this/last year, month/quarter/year-to-date, last 12 months, and last 30/60/90 days.


Report structure

The Trial Balance lists every account in your Chart of Accounts with activity during the selected period. Each row shows the account, total debits, total credits, and net balance. The totals row at the bottom confirms whether debits equal credits across all accounts.


Filters

The Trial Balance supports filtering by date range, entity, class, subclass, and counterparty.


Columns

Use the column selector to control how the report is broken down:

  • Total only — Single total column

  • By month / By quarter / By year — Period-based breakdown


Drilling down

Click any line item to drill into the General Ledger filtered to that account and date range. From there you can see the individual transactions and journal entries behind the balance.


Ledger basis

If your client has both cash and accrual ledgers configured, use the ledger basis dropdown to switch between Cash and Accrual. The selected basis is shown in the report footer.


Export

Export the Trial Balance as .xlsx from the download menu in the top right.


Creating journal entries

Click Create journal entry in the top right (or ⌥+N) to record adjustments directly from the report.

Journal Entries

Last updated

Was this helpful?