Appearance
Run a financial report
FinanceReportsRun a reportPermission:
finance.report.viewAlso known as
- trial balance
- TB
- profit and loss
- P&L
- income statement
- balance sheet
- cash flow statement
- general ledger detail
- GL detail
- account statement
The report viewer runs one Finance report with its filters and shows the result as a statement: headers, accounts, subtotals and totals, with every amount in the entity's base currency. Select a row to drill down to the ledger and from there to the journal entry or source document.
Run a report
- Open the report from FinanceReports.
- Set the filters (the report shows only the ones it uses):
| Filter | Used by | What it does |
|---|---|---|
| Period | most reports | From and to dates. Default: fiscal year start to the end of the selected period (or today). |
| As of | Balance sheet, aging and register reports | The balance date. |
| Compare with | Profit and loss: Previous period or Previous year; Balance sheet: a second date | Adds comparison columns. |
| Budget | Budget vs actual (required: "Choose a budget.") | The budget version to compare. |
| Account | General ledger detail, Account statement | One account. |
| Party | Account statement | Customers or Vendors, then the name (instead of an account). |
| Journal, Status | Journal listing | One journal; Posted (default) or All. |
| Dimension, Value | P&L, balance sheet, trial balance, GL detail, cash flow, budget vs actual | Restrict to one cost centre, department, project or segment. |
| Include zero balances | Trial balance | Show accounts without balance or movement. |
- The report runs as you change filters. The header shows the entity, currency and Generated time.
- Select a row to drill down: an account row opens General ledger detail for that account and period; a ledger line opens its journal entry or source document.
- Select Export CSV or Export PDF to download the result with the same filters.
What each report contains
| Report | Contents |
|---|---|
| Trial balance | Per account: opening, debit, credit, closing debit/credit. P&L accounts restart each fiscal year; earlier results roll into retained earnings. |
| General ledger detail | Per account: opening balance, every posted line with a running balance, closing balance (up to 5,000 lines). |
| Profit and loss | Revenue, cost of sales, gross profit, operating expenses, operating income, other income and expenses, net income, % of revenue. |
| Balance sheet | Current and non-current assets and liabilities, equity including retained earnings and current-year earnings. |
| Cash flow (indirect) | Net income, working-capital changes by the accounts' cash-flow category, investing, financing, cash at start and end. |
| Account statement | One account or one customer/vendor: opening, lines in document and base amounts, running balance. |
| Journal listing | Journal entries with their lines. |
| Budget vs actual | Budget, actual, variance and variance % per account, flagged favourable or not. |
| Tax report | Taxable amount and tax per tax code; output, input, net payable. |
A warning banner above the table explains when a statement does not balance or a filter is incomplete. "No figures for these filters." means the range has no posted lines.
Differences by role
- All Finance reports need Permission:
finance.report.view.
