What you'll do: build a report the standard reports don't give you, for example monthly sales per branch or top 10 suppliers, save it, and run it whenever you need it.
Before you start:
- Your subscription package must include the Report Builder. It is marked Beta: it is still being improved and some reports may not work as expected yet.
- Your role needs View report builder & run reports, and Create report templates to build your own.
Create a report
Section titled “Create a report”In the sidebar, open Reports & Analytics → Report Builder → Create Report. The Create a Report page opens.
Start in one of three ways:
- pick a quick template, such as Branch sales monthly, Top 10 customers by purchases, Sales vs purchases, Expenses by category or P&L scorecard (more under Browse templates, then Use this template);
- or choose a measure under Or pick a measure to start from right away: and press Build this report;
- or, if the AI assistant is available, type what you want to know (for example Purchases per supplier last month).
1 Create Report · 2 Browse templates Shape the report:
- Time period: the dates it covers;
- Group by (Add dimension...): for example by branch, month or customer;
- Filters → Add a filter: choose the field (Select field...), the condition (Comparison / condition type) and the Required value, then Add;
- Add something: Compare with last year, Show top 10, Percentage of total, Running total, Moving average (3 periods), Net profit or a Pivot table.
Watch the live preview. Switch it between All view, Charts & KPIs and Data table. Undo and Redo step back and forth.
Type a name in Report name… and press Save report.
Run, export and find your reports
Section titled “Run, export and find your reports”Open Reports & Analytics → Report Builder → Report Builder. Report Templates lists the reports: Favorites, Personal, Shared and System. Search, or switch between List view and Grid view.
Open a report to run it. The Run Report page shows the results, charts and pivot tables.
1 Report Templates · 2 Search Export it with Export CSV, Export Excel (XLSX), Print or Export PDF. For a very large report use Export (large): Hala prepares the file and tells you when it is ready.
Use Pin to sidebar to put a report you use often in the menu, Share to share it with colleagues, and Clone to copy it. System templates can't be changed: use Clone to Edit.