Reports overview
Find the right report, run it with the shared filter bar, export it, and know which setups must be in place before the figures can be trusted.
Before you start
- Set up the chart of accountsEvery report reads the chart of accounts. Statement Mapping and Cash Flow Mapping decide where each account appears on the statements.
- Close a periodMonth, quarter, year to date and fiscal year periods come from your fiscal years. Create them first.
- Enter opening balancesBalances carried in from your old system are the starting point of every balance sheet, trial balance and ledger.
- Set up dimensionsOnly if you want to filter reports by department, project or another dimension.
- Set up your company profileThe company name at the top of each report is your organisation's name.
All reports live under Reports in the menu on the left. They read the general ledger, which WbizManager fills every time a document posts (an invoice, a bill, a payment, a journal and so on). Running a report never posts anything and never changes your books.
Your role needs the view reports permission to see the Reports menu. Budget vs Actual by Month also needs the budget report permission, and the Asset Report and Disposal Report need the fixed asset report permission.
Which report answers which question
| Question | Report | Guide |
|---|---|---|
| What do we own and owe on a date? | Statement of Financial Position | Statement of Financial Position |
| Did we make a profit this month or year? | Statement of Profit or Loss & Other Comprehensive Income | Statement of Profit or Loss |
| Do debits equal credits? What is each account's balance? | Trial Balance, Trial Balance (Comparative) | Trial Balance |
| What went through one account? | General Ledger | General Ledger |
| Where did the cash come from and go? How did equity move? | Cash Flows, Changes in Equity | Cash flows and changes in equity |
| Who owes us, and for how long? Whom do we owe? | Customer Aging, Vendor Aging | Customer and vendor ageing |
| Does the customer (vendor) list agree with the ledger? | Customer Balances, Vendor Balances, Receivables and Payables Reconciliation, Unapplied Receipts | Customer and vendor balances |
| How much VAT do we pay or reclaim? | VAT Return | VAT Return |
| What withholding tax was deducted? Do the tax accounts tie up? | WHT Receivable, WHT Payable, Tax Summary | Withholding tax and tax summary |
| What posted, who posted it, what was reversed? | Journal Register, Cash and Bank Book, Reversals and Adjustments | Control reports |
| What are our foreign currency balances worth today? | Foreign Currency Balances, Unrealised FX | Currency reports |
| How is the business doing at a glance, by project, against budget? | Finance KPIs, Profit or Loss by Dimension, Budget vs Actual by Month, Sales, Purchases and Expenses | Management reports |
| What are our assets worth? What was sold? | Asset Report, Disposal Report, Depreciation Schedule | Fixed asset reports |
Stock reports (Activity, Valuation, Reorder and Near Expiry) are not here: they are under Inventory › Inventory Reports.
Steps
Open Reports
In the menu on the left, select Reports. The menu lists every report. Groups such as Financial Statements, Management Reports or Tax Reports open when you select them.
- The Reports menu: every report, grouped.
- The tabs across the top: a shortcut to the eight most used reports.
- The cards on the Reports page: the same eight reports. Use the menu for the others.
Choose the filters
Most reports share one filter bar. Nothing runs until you select Run, so you can set every filter first.
- Period: Month, Quarter, Year to date, Fiscal year or Custom dates.
- A date in the period (for Year to date it's called Up to): any date inside the period you want. With Custom dates you get From and To instead.
- Options of this report, here the extra columns of the Statement of Profit or Loss.
- More Filters opens a second row.
- Dimension Type and Dimension Value: only postings tagged with that value are counted.
- Add dimension adds another pair. A posting must match every pair.
- Run prepares the report.
- Export to Excel downloads exactly what is on screen. It stays grey until you run the report.
Read the warnings
A yellow box above the figures means the report found something in your setup it had to guess. Read it before you trust the figures. The most common ones:
The warning says What to do …could not be classified as current or non-current… Set the subclasses in Chart of Accounts › Statement Mapping: see set up the chart of accounts. …profit or loss groups could not be classified… The same, for revenue and expense groups. No account is classified as cash… Classify the bank and cash accounts as Cash in Cash Flow Mapping. No Transfer of Net Profit account is designated… Turn on Use as Transfer of Net Profit account on your retained earnings account. No account sits under "Cash and Cash Equivalents"… The Cash and Bank Book and Finance KPIs look for a group with exactly that name in the chart of accounts. Export
Select Export to Excel. The file carries your organisation's name and the same filters as the screen. Some reports also have Export CSV next to their table. The older screens (Trial Balance, General Ledger, Statement of Financial Position, Asset and Disposal reports) have an Export button above the table that saves what you see, including the columns you chose.
Amounts and signs
- Amounts are in your base currency unless a column says "document currency".
- On the newer reports, negative amounts are in brackets and red: (1,000.00).
- The older screens have a Negative values box: choose Cr, - or () for how negatives look.
Who sees reports
Reports are for finance and management. Staff without the reports permission don't see the Reports menu.