Review the Trial Balance

Review account balances as of one date or compare two reporting dates.

Steps

1. Open Reports > Trial Balance.
2. As of Date opens by default with one Account column and one net Debit

or Credit balance per account, matching the standard three-column Trial Balance layout. Choose Comparison only when you need two dates.

1. Choose a Report Period. In As of Date, the shared toolbar shows From and To; To is the As of

date. The default To Date option ends today; a full-year option ends at year end. In Comparison, From and To are two complete as-of dates. Choose a preset or edit either visible date to select Custom Range, then select Apply.

1. Review the Debit and Credit balances and the report totals.
2. Select a nonzero Debit or Credit amount to open the existing **Transaction

Report** for that account. Hovering the amount shows an underline. The detail covers the applicable year start through the clicked reporting date, with a Beginning Balance and transaction-by-transaction running balances. In Comparison, each amount opens detail for its own date.

1. Use Back to Trial Balance to restore the original view, period and dates.
2. Use Download (Excel, PDF or CSV) or Print when required. The CSV follows the selected view.

Accounting Method

The current interface displays Accrual Basis and does not allow the Accounting Method selector to be changed. It presents the completed double-entry ledger, including posted Journal Entries and opening-balance counterparts. A cash-basis Trial Balance is not currently provided; compare a cash-basis report only with guidance from your Accountant.

Prior-year earnings

Asset, liability, and equity balances accumulate through the reporting date. Income and expense accounts show activity from the start of the current fiscal year through that date for incorporated Workspaces; sole proprietors use the calendar year. Earlier years' remaining net profit or loss rolls into Retained Earnings for corporations, or Owner's Equity for sole proprietors.

This rollover is calculated for the report and does not create a closing Journal Entry or change source transactions. Existing closing entries are included in the calculation, preventing their closed profit from being rolled over again. Each date in Comparison uses its own applicable year start. Retained Earnings detail includes the earlier years' remaining net profit or loss in Beginning Balance, along with applicable direct equity postings. Derived-only equity balances in legacy Workspaces without an underlying equity Category have no account transaction detail; zero values and totals are also not drilldown links. Income and expense accounts with a zero net balance are omitted from the single-date view; Comparison can retain them when the other date has a balance.

Included accounting activity

The report includes both debit and credit sides of applicable completed transactions and posted Journal Entry lines. Reversal entries offset reversed originals while both remain in the ledger history. An account opening balance has an equal opposite entry in Opening Balance Equity. Inactive accounts with history remain included.

Important boundaries

• Trial Balance remains an as-of report. From and To produce two complete

Trial Balances in Comparison; they do not filter the report to period activity.

• Both views offset Debit and Credit activity within each account and present

the remaining net balance on one side for each date. Comparison groups Debit and Credit under each date and keeps Account code and name together. These changes affect presentation and CSV columns, not postings or opening balances.

• CSV contains numeric monetary values; Excel and PDF display two decimal places and thousands separators. Comparison CSV

includes totals for both reporting dates.

• A balanced Trial Balance does not guarantee that every Category or tax treatment is correct.
• Accounts Receivable and Accounts Payable subledgers are not implemented in the current Journal Entry model.
• Use account detail and source documents to investigate unusual balances.

Related articles

• Review the General Ledger
• Review the Balance Sheet

Saved changes and report updates

A successful bookkeeping change reloads the currently open report. Other reports update when opened. Applied periods and filters remain selected; detail sorting and page size remain selected, with the page adjusted if fewer pages remain. If the report cannot reload after a successful save, refresh it without entering the transaction again. See Choose the right xBoox report for Category changes and split-transaction membership.

Report Period offers month, year (and eligible fiscal-year) presets and Custom Range. This Quarter and Last Quarter are not preset choices; use Custom Range for those dates.

Customize detail columns

In the transaction detail report, Customize appears before Refresh, Download and Print. Its first section is Columns. Choose columns, then Apply. Transaction Number and Name, where available, start hidden. Reset restores default choices in the draft; Cancel, Close, Escape or clicking outside discards the draft. Choices are remembered in this browser separately for each detail report. Detail downloads and printing respect the corresponding column choices without changing the report amounts or record scope.

Download formats

Trial Balance offers Excel, PDF and CSV for its As Of and comparison views. Debit and Credit remain numeric and use normal font weight. Comparison columns retain their respective snapshot dates. Formats do not change net debit/credit calculations, balance checks or ledger drilldown periods.

Excel data row height

Page-level Excel downloads use fixed-height data rows with automatic text wrapping off. Long Memo, Note, Description and account text remains fully stored in the cell. Widen the column or select the cell and use the formula bar to read it; fonts are not shrunk to fit. Column headings may wrap separately. This presentation rule does not alter amounts, records, CSV or PDF output. Settings Data Export is outside this update.

Excel titles, Workspace/period labels, scope notes and column headings are separate from fixed-height data rows: they wrap and receive additional row height as needed. Scope notes span the table width. Summary exports freeze the rows above the data without freezing the first column; detail exports also freeze the first identification column. The freeze line is an Excel viewing aid, not a printed border. Account columns remain text columns. Settings Data Export remains outside this update.

Report date controls

Corporations with valid fiscal settings default to This Fiscal Year to Date; other workspaces default to This Year to Date. Full-year choices remain available. Preset From and To dates are editable. Editing either date selects Custom Range, and Apply loads the complete range. Drilldown retains the selected dates and corresponding period label. Comparison drilldown uses the clicked column and Back restores the comparison settings.

Report table columns

Use the header divider to adjust column widths. The three-dot menu provides Sort Ascending, Sort Descending and Clear Sort (restore the default order), Manage Columns, and Reset Column Widths. Hide Column appears only for optional columns. Grouped statement rows sort among sibling accounts; section headings, account children and totals remain together. General Ledger keeps original running balances when display order changes. Column menus do not add filters or filter chips; report period and comparison controls remain available. Width and optional-column choices are remembered locally for each report layout.