Help Center › Reports
Read the Trial Balance
See the debit and credit balance of every ledger, check that your books balance, and export or open any ledger.
The Trial Balance lists every ledger with its debit or credit balance. If total debit equals total credit, your books are in balance.
Before you start
- Record your transactions and ledger opening balances. See Ledger opening balances.
- The report starts with the financial year selected on the Dashboard.
Steps
- Open Reports > Trial Balance.
- Check the From and As on dates. They start at the first and last day of the financial year selected on the Dashboard.
- Change either date if you need a different period. The report reloads on its own.
- Look at the summary strip. It shows Total Debit, Total Credit, and either Balanced (green) or Difference with the amount (red).
Change the view
- Click Tree (with sub-totals) to see groups and sub-groups nested, each with its own sub-total.
- Click Flat (legacy) to see each ledger under its main group, with Opening, period Debit / Credit and Closing columns.
- The app remembers the view you chose on this device.
Find a ledger
- Type part of the ledger name or code in Search.
- The list shows only matching ledgers. A chip shows how many matched out of the total.
- Click the x on the chip to clear the search.
Open a ledger (drill-down)
- Switch to Flat (legacy) view.
- Click a main group row to open or close it. Use the Expand All and Collapse All icons at the top to open or close everything.
- Click any ledger name. Its ledger report opens for the same dates.
Export or download
- Click the Export icon (download arrow) to save an Excel file. The file follows the view on screen.
- Click the Download PDF icon to save a PDF of the full tree with sub-totals.
- Click Refresh to reload the figures after you post new entries.
Fields
| Field | What it means |
|---|---|
| From | Start of the period. Balances before this date appear as Opening in the flat view. |
| As on | Last date included in the report. |
| Opening | Balance before the From date. |
| Closing | Opening plus the period movement. |
| Stock-in-hand (computed FIFO) | A line the app adds itself. It is your stock value worked out from stock movements. You cannot open it. |
Common problems
- The strip shows Difference instead of Balanced — total debits and total credits do not match for the chosen dates. Switch to Flat (legacy) and click the ledgers to find the entry that causes it. Ledger opening balances are not the cause: any gap there is moved to the Opening Balance Equity ledger.
- Some entries are missing — check the dates. When you change a date yourself, the report covers exactly those dates, even across financial years. When you do not, it follows the Dashboard financial year.
- No data for selected date. — nothing is posted in this period. Check the dates.
- No accounts match your search. — clear Search or try fewer letters.
- Financial year not found — the financial year selected earlier no longer exists. Pick a year again on the Dashboard.
- Clicking a ledger does nothing — drill-down works only in Flat (legacy) view.
Related
More in Reports
Read the Profit & Loss statementSee gross profit from the trading account and net profit after indirect income and expenses, for any period.Read the Balance SheetSee what your business owns and owes on any date, and check that assets equal liabilities plus profit.Receipt & Payment and Cash Flow reportsSee all money that came into and went out of your cash and bank ledgers, and the cash flow split into operating, investing and financing.View a ledger reportSee every entry in one ledger with a running balance, open any entry to edit it, and export the ledger to Excel or PDF.