Appearance
Reports catalogue
Also known as
- reports
- report list
- report builder
- ad-hoc report
- query
- run report
- export to Excel
- export PDF
- CSV
- schedule
Every module ships ready-made reports: the trial balance and the aged receivables in Finance, stock valuation in Inventory, win rate in Sales and around a hundred more. They all live in one catalogue under
ReportsAll reports, run with the same parameter bar and export to CSV, Excel or PDF. When no reportfits, build your own from a dataset in the report builder.
Find and run a report
- Open ReportsAll reports.
- Type part of the name, description or module in Search reports (or press / first).
- Select the report. The report page opens with its parameters.
- Fill in the parameters. Required ones are marked; Entity left empty means All entities.
- Select Run report.
The results appear under the parameters with a Total row for the money and number columns, the number of rows and the time it was generated. When the report has a text column and amounts, the Table and Chart tabs let you see the figures as a bar chart.
Export a report
- Run the report.
- Select Export and choose the format:
| Format | What you get |
|---|---|
| CSV | A comma-separated file of every row, for any tool. Percentages are plain numbers. |
| Excel workbook | An .xlsx file with typed columns (numbers, money, dates). |
| A printable document with the report name, parameters and totals. |
The export runs the report again with the same parameters, so it always matches what you see.
Reports by module
| Module | Reports |
|---|---|
| Finance | Account statement, Accounts payable aging, Accounts receivable aging, Balance sheet, Bank reconciliation, Budget vs actual, Cash flow (indirect), Cash forecast (13 weeks), Consolidated balance sheet, Consolidated profit and loss, Consolidated trial balance, Deferred revenue, Depreciation schedule, Fixed asset register, General ledger detail, Journal listing, Profit and loss, Revenue waterfall, Tax report, Trial balance |
| Sales & CRM | Backlog, Commission statements, Margin by item, Open orders, Pipeline by stage, Quote-to-order conversion, Returns rate, Sales by customer, Sales by item, Sales by month, Sales by rep, Target attainment, Win rate |
| Inventory | ABC analysis, Consignment stock, Dead stock, Expiry, Lot traceability, Movement summary, Reorder suggestions, Stock ledger, Stock valuation |
| Procurement | Contract expiry, Maverick spend, Open purchase order lines, Purchase price variance, Requisition aging, Spend by category, Spend by vendor, Vendor performance |
| Manufacturing | Capacity load, MRP exceptions, Production output, Scrap by item, Where used, Work in progress, Work order cost variance |
| People | Certification expiry, Headcount by org unit, Headcount plan vs actual, Hires, leavers and attrition, Leave balances, Payroll by component and month, Payroll register |
| Assets | Critical spares stock, Fleet cost per km, Fleet expiries, Lifecycle cost (TCO), PM compliance, Reliability (MTBF / MTTR), Work order costs |
| Quality | CAPA register, Calibration schedule, HACCP monitoring log, Inspection summary, NCR register, Supplier quality scorecard |
| Supply chain | Forecast accuracy (MAPE), Forecast vs actual by month, Freight cost by carrier, In transit, Landed cost summary, On-time in-full by carrier |
| Service | Agent performance, Contract entitlements, SLA performance, Technician utilisation, Warranty expiry |
| Projects | Project profitability, Project WIP and revenue, Resource utilisation, Unbilled work |
| Compliance | Attestation status, Audit trail, Control effectiveness, SoD violations by rule |
| Planning | Budget vs actual vs forecast, Close status, Scenario P&L |
| Analytics | KPI alert history, Report usage, Saved ad-hoc report |
| Platform | Audit activity, Items by category |
Some modules also show their reports inside the module with extra tools: the financial statements in
FinanceReports drill down from a balance to the ledger lines and compare periods (seeFinance reports), and Sales & CRMAnalytics charts the sales figures.
Build your own report
The report builder queries a dataset (journal entries, sales order lines, stock movements, inspections …) with the columns, filters, grouping and sort you choose.
- Open ReportsReport builder.
- Pick the Dataset.
- Under Columns, tick the columns you want and order them with the arrows.
- Under Filters, select Add filter, pick a column, a condition (is, is not, contains, greater than, at least, less than, at most, is one of) and a value.
- To total by a column, pick it in Group by under Group and summarise and choose an aggregate for each number column (Sum, Average, Count, Minimum, Maximum). Without aggregates each group shows a count.
- Under Sort, pick the column and the direction.
- Check the Preview, then select Export CSV or Save as report.
A report you save here appears at the top of the catalogue under Saved reports.
Saved reports are stored on the server, so they follow you to another computer; shared ones are listed for everyone who may run them, and a saved report can be placed on a dashboard (see Dashboards and KPIs). Saving needs the Manage reports permission.
Schedule a report by email
- Open AnalyticsSchedules and select New schedule. The Schedule a report dialog opens.
- Under Report, choose A saved report (one saved in the analytics report builder) or A catalogue report with default parameters, then pick the report.
- Pick When: Every day at 07:00, Weekdays at 07:00, Every Monday at 07:00, First day of the month at 07:00, or Custom… for your own timing.
- Pick the Format (PDF, Excel workbook or CSV) and type the Recipients' email addresses.
- Leave Active on and select Schedule report.
Each run is emailed to the recipients with the report attached. See Schedules and Notifications and email.
Permissions
| What | Permission |
|---|---|
| See the catalogue and run reports | Permission: reports.view plus the module's own report permission (for example Permission: finance.report.view, Permission: sales.report.view, Permission: inventory.report.view) |
| Saved reports and schedules on the server | Permission: reports.manage |
| KPI alerts | Permission: analytics.alert.manage |
A report you may not run is left out of the catalogue. Report data also respects your access: a finance report run by someone without finance permissions is refused.
Limits and gotchas
- The builder preview and its Export CSV cover the first 200 rows. For larger extracts use a catalogue report's Export, or Data export.
- Reports read the posted figures: draft documents do not appear in financial reports.
- Amounts are in each entity's base currency unless the report has a currency parameter; consolidated reports translate to the group currency (see Legal entities and currencies).
- Dates follow your organisation's date format; exported files use ISO dates (
2026-10-31).
