+1 480 485 7373
Microsoft Teams
Begin with the question someone needs answered
Before picking a tool, write down the question and who asks it. A controller asking why gross margin fell last month needs drill-down to the ledger. A warehouse lead asking what ships today needs a live list, not a monthly report. Then a board member asking how this year compares with last year needs a clean summary, probably on one page. The same data serves all three, but the right delivery is different each time.
Three further questions narrow the choice. How often do people need the answer, and must it be exact to the cent or just directional? Will the person asking build it, or do they want it delivered? Answer those and the table below usually points to one or two options.
Every option for reporting in Business Central, compared
Matching each Business Central reporting option to a team
Close and statements
Financial reporting for statements and budget comparisons, standard reports for aging and reconciliations, analysis views where dimensions matter.
- ✓Financial reporting
- ✓Standard reports
- ✓Analysis views
Daily lists and exceptions
Filtered list pages saved as views, analysis mode for quick counts, and a few role center tiles for items that need action today.
- ✓Saved list views
- ✓Analysis mode
- ✓Role center cues
Trends and one-page summaries
Power BI dashboards for trends across months and companies, backed by financial statements that tie out to the ledger.
- ✓Power BI
- ✓Financial reporting
- ✓Scheduled report delivery
Business Central reporting layouts: RDLC, Word and Excel
Every Business Central report has a dataset, which defines the data it pulls, and one or more layouts, which define how that data looks. Layouts can be RDLC, Word or Excel. Word layouts suit documents like invoices and statements because they are easy to brand and adjust. Excel layouts suit analysis reports because users get a workbook with the data on one sheet and their own formulas and pivots on others.
Users with the right permissions can add and choose layouts from the Report Layouts page without any development, which covers a large share of requests such as a new logo, different columns on a statement, or a customer-specific invoice design. When the data you need is not in the report's dataset at all, a layout change cannot help; that is where a report extension or a new AL report comes in.
Across every option for reporting in Business Central, the job queue can also schedule reports and deliver them as files. That ends the habit of someone running the same report by hand every Monday.
Signs you have outgrown the built-in tools
- ✓The same export and spreadsheet rebuild happens every week
- ✓Leadership wants trends across several companies in one view
- ✓Figures need blending with data from a CRM, payroll or ecommerce system
- ✓Report requests queue up because only one person can build them
- ✓Different departments quote different numbers for the same metric
- ✓Large reports time out or slow the system during working hours
Reporting questions from Business Central users
What is the best reporting tool in Business Central?
There is no single best tool; the right one depends on the question. Financial reporting handles statements, analysis mode handles exploration, and Power BI handles trends. So most companies use three or four options together, rather than one. Problems start when you stretch one tool to cover everything.
What happened to account schedules?
They still exist, under the name financial reporting. Microsoft renamed the feature and split row definitions from column definitions, so you can reuse each. Existing account schedules carried over, and the concepts are the same.
Do we need Power BI if we have Business Central?
Not always; many smaller companies report well with the built-in tools and Excel. Power BI earns its place when you need dashboards, trends, several companies in one view, or data from other systems. Microsoft publishes ready-made Power BI apps for Business Central as a starting point. Check Microsoft's pricing page for viewer licenses.
Can users build their own reports without a developer?
Yes, for a large share of everyday needs. Trained power users can handle saved list views, analysis mode, financial reporting, Edit in Excel and layouts. You need a developer when no page exposes the data or when calculations are complex. Training two or three power users usually cuts the report request queue sharply.
Why do our reports show different totals from the trial balance?
Usually because they read different data, apply different filters, or use different date logic. An inventory report may value stock differently from the ledger until adjust cost runs. A sales report may exclude credit memos or use shipment dates. Across every option for reporting in Business Central, tracing one mismatch end to end normally reveals a filter, not a fault.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.