Report Builder
Build your own reports over your accounting data โ no formulas, no spreadsheets. Pick what to group by (rows and columns) and what to add up (values), optionally filter and set a date range, then click Run. The numbers come straight from your ledger and always match the standard reports.
Think of it as a pivot table over your books. You drag categories โ accounts, months, parties โ into rows and columns, choose which figures to total, and the builder tallies your ledger into a neat grid. Unlike a spreadsheet, you can click any number to see the exact transactions behind it, and the totals always agree with your official reports.
01What you see on the screen
Two cards: BI Report Builder (three pick-lists โ Rows, Columns, Values โ plus date range, sort, filters, and Run/Save/Export buttons) and Saved Reports (your saved reports, each with Load and delete).
02The controls
| Control | What it does | Choices |
|---|---|---|
| Rows | Things listed down the left โ each value becomes a row. | Account, Account type, Party, Cost centre, Month, Quarter, Year, Document type, Currency. |
| Columns | Things spread across the top โ each value becomes a column. | Same list as Rows. |
| Values | The numbers calculated in each cell. | Net (DrโCr) โ the default โ plus Debit, Credit, Count. |
| Date from / to | Limits the report to postings in this range. | Any dates; "to" includes the whole day. |
| Sort by + direction | Orders the rows, biggest or smallest first. | Any measure/dimension; Descending or Ascending. |
| Filters | Narrows to just what you want (Field + Operator + Value). | equals, not equals, is any of, contains, > < โฅ โค. |
03The buttons
| Button | What it does |
|---|---|
| โถ Run report | Builds the grid from your picks (needs at least one Row or Column). |
| ๐พ Save | Names and stores the report to reuse later. |
| โฌ Export CSV | Downloads the report as a spreadsheet, ending with a TOTAL row. |
| Click a value | Drill-through โ opens the individual ledger postings behind that exact cell. |
| Load / โ | Reopen or delete a saved report. |
04Build a simple report (expenses by month)
- Open the Report Builder tab.
- Under Rows, pick Account type (or Account for individual accounts).
- Under Columns, pick Month.
- Leave Values on Net (DrโCr).
- Set the Date from/to for the year.
- Click ๏ผ Add filter: Field = Account type, Operator = equals, Value = Expense.
- Click โถ Run report โ a row per expense category, a column per month, with subtotals and a grand total.
- Click any number to drill through, or ๐พ Save it as "Expenses by month".