Filters and options in the Trial Balance report
Reference guide for all filtering and display options available in the Trial Balance.
Jul 11, 2026
Filter options
| Filter | Description | Default |
|---|---|---|
| As Of Date | Limit the report to a specific date or date range. The report shows account balances as of the end of that date. | Today's date |
| Account Type | Show only accounts of a specific type: Asset, Liability, Equity, Revenue, or Expense. Leave blank to show all types. | All types |
| Account Code | Filter to a specific account code or use wildcards to match patterns (e.g., "1*" for all accounts starting with 1). | All accounts |
| Show Zero Balances | Toggle on to include accounts with a zero balance; toggle off to hide them. | Off (hidden) |
| Department / Cost Center | (If enabled) Show accounts assigned to a specific department or cost center. | All departments |
Display options
| Option | Description |
|---|---|
| Currency | Show balances in the primary currency or convert to another currency (if applicable). |
| Decimal Places | Set the number of decimal places for balance amounts (typically 2 for currency). |
| Page Layout | Choose between portrait (vertical) or landscape (horizontal) layout for printing or export. |
| Sort By | Sort the report by Account Code, Account Name, or Debit/Credit balance. |
Exporting and printing options
| Option | Description |
|---|---|
| Export Format | Download as PDF, Excel (.xlsx), or CSV. |
| Include Notes | (If enabled) Include any notes or comments attached to accounts. |
| Summary Only | Show only the totals row, or include all account rows. |
Was this helpful?