Financial reports

Where

Reports → Financial Reports

Plan

All plans

Permission

Reporting → Financial Report

These are the same reports as under Financials

Trial Balance, Balance Sheet, Profit & Loss, Receivables Aging and Payables Aging appear in two places in the menu — here, and under Financials → Financial Statements. They are the same screens, with the same columns and the same figures.

The only difference is the plan. Under Financials they need Professional; here under Reports they need only Standard. If you are on Standard you will see them in this menu and nowhere else.

The two aging reports are also worded differently: Receivables Aging here, AR Aging there. Same report.

The thirteen

Report	What it answers	Plan
Financial Summary	eight headline numbers, runs by itself	Essential
Top Debtors	who owes you most	Essential
Top Creditors	who you owe most	Essential
Cash Account Balances	what is in each cash and bank account	Standard
Trial Balance	every account, debits against credits	Standard
Balance Sheet	what you own and owe on a date	Standard
Profit & Loss	whether you made money over a period	Standard
Receivables Aging	how overdue each customer is	Standard
Payables Aging	how overdue you are with each supplier	Standard
Cash Flow Statement	where the cash went	Professional
Cost Centre P&L	budget against actual per cost centre	Professional
nav.arControlReconciliationReport	do the customer balances match the books	Professional
nav.apControlReconciliationReport	do the supplier balances match the books	Professional

The last two have no English name in the menu, and their page headings and three of their column headings are raw internal names too. They are the most visibly unfinished screens in the app — but the figures are right.

Before you trust any of these

Unconfigured posting profiles make these reports empty, not wrong-looking

Every figure on Trial Balance, Balance Sheet, Profit & Loss, Cash Flow, Financial Summary and Cash Account Balances comes from your accounting entries.

If your posting profiles are not set up, sales still complete and stock still moves, but nothing reaches the books. Your Profit & Loss will be blank for a month in which you sold plenty.

The two aging reports and Top Debtors/Creditors are the exception — they read the customer and supplier balances directly, so they keep working. That is exactly why they can disagree with the accounts.

Date boxes that are ignored

Every report in this group displays the same date controls, but most of them do not use both ends.

Report	What the dates do
Profit & Loss, Cash Flow, Trial Balance	both dates used properly
Balance Sheet, Cash Account Balances, Receivables Aging, Payables Aging, both reconciliations	only the End date — it is the “as at” date, and the Start date does nothing
Top Debtors, Top Creditors, Cost Centre P&L	neither date does anything — always as of now

A balance sheet from 1 January to 31 March is not a first-quarter balance sheet; it is your position as at 31 March.

How to run a Profit & Loss

1. Go to Reports → Financial Reports → Profit & Loss.
2. It opens on This month. Choose another period or type your own dates.
3. Narrow to one Location if you want.
4. Click Run report.

You get Total revenue, Total cost of sales, Gross profit, Total expenses, Operating profit, Total other income and Net profit, then the full statement. Negative figures appear in red brackets.

Accounts with no movement are left out, and an empty section is skipped entirely.

The section headings are missing their English text

On Profit & Loss you will see REPORTS.FINANCE.PROFITANDLOSS.REVENUE and three similar headings; on the Balance Sheet, REPORTS.FINANCE.BALANCESHEET.ASSETS, …LIABILITIES and …EQUITY. The statement below each heading is correct.

Balance Sheet

Retained Earnings is shown as an equity line with no account code. Your profit to date is folded in there, because profit accounts are never closed off. It appears both as a tile and inside the Equity section — it is one figure, not two.

Run it with an End date

With no end date the report is as at today but the “As of” tile is hidden, so neither the screen nor the exported PDF says what date it represents. Always set the End date before you send one to anyone.

Financial Summary

It opens and fills itself in with no date range, giving Revenue, Expenses, Net profit, Cash balance, Receivables, Overdue receivables, Payables and Overdue payables.

Two traps on this one page

“Cash balance” becomes “cash movement” the moment you set a date range. Opened with no dates it is your true balance; with This month chosen it is the cash that moved this month. The tile name does not change.

The four receivables and payables tiles ignore the Location filter. Filter the page to one branch and those four are still company-wide.

Aging

Receivables Aging buckets what each customer owes into Current, 1–30, 31–60, 61–90 and 90+ days, measured against the End date.

An invoice with no due date is aged from the day it was raised

So a brand-new invoice with no due date can appear in an overdue bucket immediately. Set due dates.

Customers who owe nothing, or who are in credit, are left off entirely.

The tiles at the top are the authoritative totals for the whole report; the footer row follows whatever you typed in the search box.

The two reconciliation reports

These answer one question: do my customer balances agree with my accounts?

1. Open Reports → Financial Reports → the entry reading nav.arControlReconciliationReport.
2. It runs by itself.
3. Look at the Status tile. An empty table with a good status is the result you want — only customers who disagree are listed.

A difference means the customer’s debt exists in one place and not the other. The usual cause is a sale that completed while posting profiles were unconfigured: the customer owes you, and the aging report knows it, but the books never recorded it.

A “Control accounts: 0” tile means the report cannot work

That means no posting profile maps a receivables or payables account at all. The accounting side is empty, so every customer with a balance shows as a problem. Fix the posting profiles first.

Cost Centre P&L

This report does not read your transactions

It reads budget lines. The Budget, Actual and Variance columns are all three typed in by hand when the budget was created — nothing recalculates Actual from what was actually posted.

So it is empty unless someone has built a budget with cost centres on its lines, and even then it compares two numbers a person entered. It is a place to record your plan against your own estimate, not a report on your ledger.

It also has no date filter at all.

Cash Flow Statement

It classifies cash by what the money moved against, not by the categories an accountant would use: movements against asset accounts count as Investing, against liabilities and equity as Financing, everything else as Operating.

Transfers between two of your own cash accounts disappear, deliberately.

Opening cash is zero unless you set a Start date, which makes Closing cash look wrong if you clear the range.

Two more things

Every amount is your main currency, converted from foreign documents at the rate recorded on each one. No currency symbol is printed.

Cancelled documents are reversed rather than removed, so they net to zero in the accounts rather than vanishing.

Related

• Setting up your books — posting profiles
• Financial reports under Financials
• Sales analytics — why the trading view differs