Search Knowledge Base Articles

Reports — User Guide

Reports — User Guide

Module: Accounting
Audience: Accountants, finance managers, administrators
Version: 1.0.0
Last updated: 2026-07-22

Overview

Accounting → Reports provides financial statements and operational listings — balance sheet, profit and loss, trial balance, general ledger, tax summaries, ageing reports, budget comparisons, and more. Each report opens with filters (usually a date range); results refresh automatically and can be exported to PDF or Excel.

Prerequisites

Role Typical permissions
Open the report list and run reports Accounting Reports → View

Posted transactions and a configured Chart of accounts are required for meaningful results. Budget reports also need budget data under Accounting → Budget.

Step-by-step: Open and run a report

  1. Go to Accounting → Reports.
  2. Expand a category (for example Business overview or Bookkeeping).
  3. Click the report name (for example Balance Sheet or Trial Balance).
  4. Set filters on the report page:
    • Date filter type — To date (as-of) or From date and to date
    • From date / To date — reporting period
    • Accounting method — Cash or Accrual (defaults from Setting → General)
    • Additional filters when shown (items, customers, account, budget, etc.)
  5. Click Filter if the report does not refresh automatically.

Expected result: The report body fills in below the filters with totals and detail rows.

Step-by-step: Export a report

  1. After the report has loaded, use the Print / PDF dropdown (top right of the filter row).
  2. Choose Export to PDF or Export to Excel.

Exports use your current on-screen filters and results.

Step-by-step: Account history from the chart of accounts

  1. Go to Accounting → Chart of accounts.
  2. For eligible accounts, click the history icon in the Options column.
  3. The Account history report opens with that account pre-selected.
  4. Adjust dates and click Filter.

Report categories (catalog)

Category What you will find
Business overview Balance sheet variants, profit and loss variants, cash flows, statement of changes in equity, custom summary
Bookkeeping Account list, general ledger, journal, trial balance, account history, recent transactions, transaction detail, bank reconciliation reports
Budget Budget overview, P&L budget vs actual, budget performance
Sales tax Tax detail, summary, and liability
Who owes you Accounts receivable ageing (summary and detail)
Sales and customers Deposit detail, income by customer summary
What you owe Accounts payable ageing (summary and detail)
Expenses and suppliers Cheque detail

Some report names in the codebase are not shown in the catalog (hidden from the menu). Use the links above for day-to-day work.

Settings that affect reports

Setting Location Effect
Accounting method Accounting → Setting → General Cash vs accrual — especially revenue and invoice timing
First month of financial year Accounting → Setting → General Default range on 12-month P&L and some budget reports
Base currency Setup → Currencies Currency symbol on reports
Warehouse items Warehouse module + items Optional item filter on some P&L and balance sheet reports

Common issues

Symptom Likely cause What to do
Cannot open Reports Missing View permission Request Accounting Reports → View
Empty or zero report No converted/posted transactions Convert transactions under Accounting → Transaction; post journal entries
Cash vs accrual mismatch Filter differs from expectation Match filter to Setting → General method
Budget report empty No budget loaded Create or import a budget
Bank reconciliation report empty No bank reconcile completed Use Accounting → Banking reconcile first
PDF columns cut off Wide report (e.g. A/R ageing) Use landscape PDF or export to Excel
Numbers differ from COA list Date range or method Align dates and cash/accrual with chart filters

Related features

  • Chart of accounts — balances and account history shortcut
  • Journal entry — manual GL activity in journal and GL reports
  • Transaction — automatic conversion feeds many reports
  • Budget — source data for budget reports
  • Banking — bank reconciliation summary and detail reports
  • Reconcile — GL account reconcile (separate from bank reconciliation reports)

Did you find this article useful?

Related Articles

  • Banking — User Guide

    Banking — User Guide Module: Accounting Audience: Accountants, bookkeepers, treasury staff Version: ...

  • Bills — User Guide

    Bills — User Guide Module: Accounting Audience: Accounts payable clerks, accountants Version: 1.0.0 ...

  • Budget — User Guide

    Budget — User Guide Module: Accounting Audience: Accountants, finance managers, administrators Versi...

  • Chart of Accounts — User Guide

    Chart of Accounts — User Guide Module: Accounting Audience: Accountants, finance staff, system admin...

  • Checks — User Guide

    Checks — User Guide Module: Accounting Audience: Accounts payable staff, bookkeepers, finance admini...