Skip to main content

Run Financial Reports

Every report reads the same posted ledger, so they agree with each other and with the trial balance, and update the moment a document posts. Find them under Financial Reporting, where report pages also share a tab bar under their header.

A transaction counts on the posting date of its journal, and the whole of the last day is included. "Cash" means the same everywhere: cash in hand, petty cash, undeposited funds, card-clearing and every bank account.

The reports​

ReportMenuWhat it tells you
Trial balanceFinancial ReportingWhether debits equal credits (within 0.01)
Income statement (P&L)Financial ReportingGross, operating and net profit, with margins
Balance sheetFinancial ReportingWhat you own, owe and are worth on a date
Statement of Cash FlowsFinancial ReportingHow your cash position changed
Monthly trendFinancial ReportingThe income statement month by month
Financial healthFinancial ReportingLiquidity, margin and cash-cycle ratios
Budgets, Budget vs actualFinancial ReportingA twelve-month plan and how the ledger tracks
Notes to the accountsFinancial ReportingSupporting detail behind the statements
General ledger, Cash bookGeneral Ledger & CoAWhat moved in each account; cash movements
COGS accuracy, Gross margin (sales)Financial ReportingInventory costing versus sales (needs Inventory and Sales)
Audit trailGeneral Ledger & CoAFinance-related audit log entries
Day book, Account movement summaryReports (top bar) → Ledgers & accountingEvery ledger line in date order; opening, debits, credits and closing per account
Customer balances, Supplier balances, Unapplied advancesReports → Ledgers & accountingWho owes what against credit limits; advances not yet applied
Cheque register, Bank reconciliation statusReports → Ledgers & accountingIssued and received cheques with post-dated and bounced flags; reconciliation differences
Recurring transactions, Opening balance vouchers, Accounting periodsReports → Ledgers & accountingWhat runs next; whether opening entries balance; which periods are open or locked

Run the income statement​

  1. Open Income statement (P&L).
  2. Pick From and To, or a quick range (default: year to date).
  3. Under Compare with, choose Previous period or Same period last year. Every line then shows the change and a green or red chip.
  4. Optionally pick a cost center, when cost centers are on. Opening balances from the chart are left out of a cost-center view.

It reads in steps: revenue, cost of sales, gross profit, operating expenses, operating profit, other income and expenses, and net profit, each with its percentage of revenue. If an account sits in the wrong section, change its sub type under Transaction accounts.

Run the balance sheet​

  1. Open Balance sheet.
  2. Pick As of, or Last month end, Last quarter end or Last year end, and optionally a comparison date.

Balances include every posting up to that date. Profit not yet closed to retained earnings shows under equity as Current earnings (not yet closed to retained earnings). The header shows Balanced when assets equal liabilities plus equity, otherwise the difference, so run the trial balance. Tiles show total assets, liabilities, equity, working capital and the current ratio.

Monthly trend and financial health​

  • Monthly trend: pick the last month and 3, 6, 12 or 24 months. You get a column per month, a net-profit chart, gross margin per month, the best month and average monthly revenue.
  • Financial health: pick a period. Cards give Liquidity, Profitability and Cash cycle and leverage ratios with a plain explanation and last year's figure, and tiles add cash, receivables, payables and cash runway. Colours are rules of thumb, not industry benchmarks, and a ratio shows n/a when it would divide by zero.

Export, print and drill down​

  • Excel downloads a real spreadsheet with numbers kept as numbers.
  • Print / PDF prints a clean copy; choose Save as PDF in the print dialog.
  • Click any account or amount to open its general ledger for the same dates.

Check the trial balance​

Debits and credits should match to within 0.01. If they do not, look for drafts, failed postings or one-sided lines in the journal entry viewer for the dates involved. The balance sheet is cumulative as of the chosen date, so compare it with the trial balance for the same date.

Next step​