Financial reports
Where: Accounting → General ledger, Trial balance, Balance sheet, Profit and loss. Who: the report's permission (see Access) and access to the business units you report on.
All four reports read posted journals only. Drafts never appear.
Run a report
- Open the report from the menu.
- Under Report parameters, enter:
| Field | Reports | Example |
|---|---|---|
| From date | General ledger, Trial balance, Profit and loss | 2026-11-01 |
| Through date (inclusive) | General ledger, Trial balance, Profit and loss | 2026-11-30 |
| As of date | Balance sheet | 2026-11-30 |
| Business unit | All four | All business units, or one unit |
| Account | General ledger only | 1100 Accounts Receivable, or all |
- Select Run report. The Report totals appear first, then the detail tables.
"Choose valid dates with the from date on or before the through date." means the dates are missing or in the wrong order.
Which report answers which question
The examples below all use Bright Home Supplies, November 2026. The journals behind them are listed in the worked example.
General ledger
Every posted line in the period, grouped by account, with a running balance.
| Column | Meaning |
|---|---|
| Posting date | Accounting date of the journal |
| Journal transaction | Link to the journal (opens Journal lookup) |
| Reference | What created the journal |
| Account | Code and name |
| Debit, Credit | The line amount on its side |
| Running balance | Balance after this line, in the account's normal direction |
Example: account 1100 Accounts Receivable, November:
| Date | Reference | Debit | Credit | Running balance |
|---|---|---|---|---|
| 03 Nov | SALES_INVOICE INV-0042 | 327.60 | 327.60 | |
| 10 Nov | PAYMENT_ALLOCATION PAY-0007 | 200.00 | 127.60 | |
| 24 Nov | PAYMENT_ALLOCATION PAY-0011 | 127.60 | 0.00 |
Totals: debit 327.60, credit 327.60, closing balance 0.00.
Trial balance
For each account: the period's debits and credits, and the closing balance on its debit or credit side. The report says whether total debits equal total credits.
Example: November:
| Account | Debit | Credit | Closing debit | Closing credit |
|---|---|---|---|---|
| 1000 Current Assets | 327.60 | 150.00 | 177.60 | |
| 1100 Accounts Receivable | 327.60 | 327.60 | ||
| 2010 Accounts Payable | 150.00 | 150.00 | ||
| 2200 Accruals | 45.00 | 45.00 | ||
| 4000 Sales Revenue | 327.60 | 327.60 | ||
| 5000 Cost of Goods Sold | 150.00 | 150.00 | ||
| 5100 General Expenses | 45.00 | 45.00 | ||
| Total | 1,000.20 | 1,000.20 |
Balanced: yes. A trial balance that does not balance should never happen; report it to support.
If you also have the Reports module and reports.view, the page shows the scoped trial balance:
opening balance before the from date, the period's movement, and the closing balance, all in base
currency. Otherwise you see the period-only version above.
Profit and loss
Revenue less expenses for the period.
- Revenue accounts count credit minus debit.
- Expense accounts count debit minus credit.
- A Revenue account with a debit balance (such as
4100 Sales Returns) reduces total revenue.
Example: November:
| Section | Account | Amount |
|---|---|---|
| Revenue | 4000 Sales Revenue | 327.60 |
| Total revenue | 327.60 | |
| Expenses | 5000 Cost of Goods Sold | 150.00 |
| Expenses | 5100 General Expenses | 45.00 |
| Total expense | 195.00 | |
| Net profit | 132.60 |
With the Reports module and reports.view, the page adds a Monthly profit and loss table
(Month, Revenue, Expense, Net).
Balance sheet
What the organisation owns (assets), owes (liabilities) and the owners' stake (equity), on one date.
Example: as of 30 November:
| Section | Account | Amount |
|---|---|---|
| Assets | 1000 Current Assets | 177.60 |
| Total assets | 177.60 | |
| Liabilities | 2200 Accruals | 45.00 |
| Total liabilities | 45.00 | |
| Equity | 0.00 | |
| Total equity | 0.00 | |
| Server balance status | Unbalanced |
This screen does not add the current period's profit to equity. Assets 177.60 = liabilities 45.00
plus the November profit of 132.60, which is still in the revenue and expense accounts. Until a
year-end closing journal moves the profit to 3100 Retained Earnings, the screen shows Unbalanced.
The balance sheet in the Reports module (Reports → Accounting → Balance sheet) adds a line Current earnings (unclosed revenue less expense) to equity and shows the same date as balanced:
| Equity | Amount |
|---|---|
| Current earnings (unclosed revenue less expense) | 132.60 |
| Total liabilities and equity | 177.60 |
Currencies
All lines in one report must share a currency. If your books include documents in more than one currency, the trial balance and profit and loss stop with "Report cannot combine different currencies". Use the Reports module versions, which work in base currency throughout.
Exports
These screens show results on the page. To export to Excel or PDF, or to schedule a report, use the Reports module, which offers the same accounting reports.
Next: Receivables.