Skip to content

Financial reports

This guide covers TrackBooks' financial reports: the Trial Balance, Profit & Loss, Balance Sheet, Cash Flow Statement and Ratio Analysis, plus the sales, purchase and aging registers. All of them are built live from your posted transactions.

What this is

You don't prepare these reports in TrackBooks, you just read them. Every posted invoice, bill, payment, expense and journal feeds the ledgers in real time, and the reports render from those ledgers whenever you open them. The period comes from the date selector in the top bar, so change it there to see a different financial year or date range.

The three statements share the same controls: numbered buttons that expand the account tree to Summary, Groups or Detail (the Balance Sheet adds Sections), chevrons to open or close any single branch, an Include Zero Balances tick box, and Download PDF and Download Excel icons. Clicking an account name in any statement opens its ledger.

Before you begin

  • Role required: any role (View Only can read reports).
  • Find them under: Reports in the sidebar (the GST returns live there too).
  • Settings/flags: If the company has more than one GST registration, the statements show a scope dropdown. Pick one registration, Common (entity-level) for entries that belong to no registration, or the consolidated whole.

The three core statements

Trial Balance

Reports → Trial Balance lists every account in five columns: Particulars, Opening Bal., Debit, Credit and Closing Bal., grouped under their heads. The TOTAL row stays pinned while you scroll, and the green footer confirms Trial Balance is balanced (Debits = Credits). It's your fastest integrity check.

The full Trial Balance with its balanced footer

With more than one registration the screen shows one scope at a time: Consolidated (all locations + Common), a single registration, or Common (entity-level). The side-by-side comparison of registrations is an Excel file: on the consolidated scope use the Download GST location comparison (Excel) icon. That workbook carries the opening, debit, credit and closing columns for every registration and Common.

Profit & Loss

Reports → Profit & Loss shows income minus expenses for the period, ending in your profit or loss for the period. With several registrations, All locations + Common shows a matrix with one column per registration, Common and the consolidated total; pick a single registration to get the account tree instead.

The Profit & Loss statement

Profit & Loss for a four-registration company: one column per registration plus Common

Balance Sheet

Reports → Balance Sheet shows your financial position as of the end date of the selected period, in Schedule III format (Equity and Liabilities against Assets). The footer confirms Balance Sheet is balanced (Assets = Equity + Liabilities). The current-year profit from the P&L flows into Shareholders' Funds automatically.

The Balance Sheet

The export matches the screen

PDF and Excel downloads of the three statements mirror exactly what you expanded on screen. Open the groups you want your accountant to see, then download.

Cash Flow Statement

Reports → Cash Flow Statement shows where cash came from and went, in the indirect method: operating, investing and financing activities, from the beginning cash balance to the ending one. The Reconciliation Check line at the bottom proves that beginning plus net change equals ending cash. It is always prepared for the whole company, and it has no PDF or Excel download yet.

The Cash Flow Statement with its Reconciliation Check

Ratio Analysis

Reports → Ratio Analysis turns the Balance Sheet and P&L into liquidity, solvency, profitability and efficiency ratios for the whole company. Each row shows the value, the formula and the figures behind it; tick Show explanations to read what each ratio means. N/A means the denominator is zero or negative, or the period starts before your books do. The Balance Sheet and Profit & Loss buttons open the source statements for the same period. The Figures used in these calculations panel lists every amount that went in.

The Ratio Analysis report with explanations shown

Year to date, not annualised

With the Current Fiscal Year preset in the top bar the ratios run through today. Returns and turnover cover the selected period only and are not scaled to a full year. If the Balance Sheet does not balance for the date, the page says so; fix the books before you rely on the numbers.

Operational reports

  • Reports → Sales Report is your sales register: every posted invoice with its taxable value, CGST, SGST, IGST, total and payment status, under summary cards for Total Sales, Paid, Outstanding and GST Collected. Click a row to open the invoice.
  • Reports → Purchase Report is the purchase register. It lists posted bills and expenses together (expenses carry an Expense badge), with TDS and outstanding columns and an RCM marker on reverse-charge bills.
  • Reports → Receivables Aging and Reports → Payables Aging show who owes you, and whom you owe, bucketed by how overdue the amount is as of the date you pick with the date button at the top (Reset to Today clears it). Four cards lead the page: Net Receivable (or Net Payable), which is the gross outstanding less advances on the books, then Current, Overdue and 90+ Days. Each party row expands to list its invoices across the day buckets; click an invoice to open it. The buckets are configurable under Settings → Reports & Aging. These two reports download as Excel only.
  • Reports → Bank Recon Statement builds the statement for one bank account: choose the Bank Account and As of Date, click Generate, and read from Balance as per Books through the unmatched items to the statement balance. Use Print for a copy. Matching itself happens in Reconcile a bank statement.
  • Reports → Dimension Report analyses income and expenses by cost centre, project or any other dimension you have set up. See Financial dimensions.

The Receivables Aging cards and table

Drill into a ledger

Click any account name in the Trial Balance, P&L or Balance Sheet to open its ledger for the same period and scope. The ledger shows the Opening Balance and Closing Balance, every entry with a running balance, and Period Totals. Change the date range or the registration scope on the page, and use Export for Export as PDF or Export as Excel. The back arrow returns you to the report you came from.

The Office Supplies ledger with its Opening and Closing Balance and a running balance on every row

Cash and bank on the Dashboard

The Cash & Bank Balance card on the Dashboard shows the ledger balance of your cash and bank accounts at the end of the selected period, split into bank and cash, with the net flow for the period and a month-by-month chart of inflows, outflows and closing balance. A strip under the headline compares the statement balance with the books, for example "Bank statements show ₹0 vs books ₹3,44,084 — import or reconcile"; click it to open Banking → Cash and Bank Accounts.

The Cash & Bank Balance card on the Dashboard with its reconciliation strip

Tips & common issues

Use the view levels

Switch between the numbered presets to zoom from a one-line overview down to individual ledger accounts, or click a chevron to open just the branch you care about. Handy when a number looks off and you want to drill in.

Reports show posted data only

Drafts and in-review invoices and bills don't appear until posted. If a report looks low, check for unposted documents and confirm the period in the top bar is the one with your data.

Export for your accountant or filing

The statements and registers have Download PDF and Download Excel. The Trial Balance Excel is a common hand-off to an external auditor; the GST location comparison workbook is the one to send when the auditor wants each registration separately.


Last checked against TrackBooks on 24 October 2026.