.svg)
Reporting with MS Dynamics 365 Business Central: what the ERP can do itself, where it hits its limits and how to fill the gap (2026)
Business Central is a full ERP — finance, logistics and manufacturing in one. A lot is possible, but rarely out of the box: reporting quickly runs through extensions, BI or a partner. How to put a management report on top of BC without that project.
.png)
Reporting with MS Dynamics 365 Business Central: the ERP reports per administration — a custom layout, cash flow statement and group picture come from Finstack, from EUR 39/month.
Reporting with MS Dynamics 365 Business Central: what the ERP can do itself, where it hits its limits and how to fill the gap
From the extension-and-BI project to a report that is simply there — dashboards, 2-way Excel sync and consolidation on top of Business Central.
TL;DR
MS Dynamics 365 Business Central is a full ERP with solid financial reports per administration — but a management report with a custom layout, budget comparison, KPI trends, cash flow statement and group picture is not there out of the box: it takes extensions, BI or a partner. A reporting tool on the data layer delivers that layer ready-made. Finstack connects Business Central directly — read-only, at transaction level — and consolidates it with Exact, AFAS or Twinfield where wanted, from EUR 39/month.
What can MS Dynamics 365 Business Central do for management reporting itself?
Business Central is Microsoft’s SME ERP: finance, purchasing, sales, inventory and manufacturing in one system. In the Netherlands you see it mostly at trading and manufacturing companies and at international groups — often as the package of a larger operating company or foreign entity, next to a Dutch package elsewhere in the group — the role in which BC returns further down this article.
The financial side delivers a solid base set per administration: a profit and loss statement and balance sheet, a trial balance, receivables and payables overviews with an aging analysis, and budgets at ledger level. Because the ERP also records the operation, a lot of data sits ready — from inventory levels to order positions — that comes in handy for broader reporting. For international entities, multicurrency naturally belongs to it.
And then the honest caveat, which sounds different at Business Central than at a compact package: a lot is possible, but rarely out of the box. A custom reporting layout, dashboards or a group picture require extensions from the Microsoft ecosystem, a BI setup or a partner who builds it. What you get to see therefore depends on what was once configured — and every change runs through that same channel.
For the core processes, that thoroughness is a strength; for steering information it becomes a brake. A management report — the seven fixed sections from the main article on the good management report, in a layout management understands, with comparisons against budget and last year, every month within 5-10 working days — should be managed by finance itself, not by a configuration project. Where exactly the limits sit is covered in the next section.
Where does Business Central hit its limits in management reporting?
Business Central hits its limits in management reporting at the same five points as every package — with as the BC-specific color that the solution within the ecosystem is a project every time.
The layout. The standard reports follow the chart of accounts. A custom reporting structure — a margin bridge, calculated lines such as an EBITDA line, the sequence management is used to — takes an extension or report builder, with the setup that comes with it.
The comparison. Recording budgets is possible, but the full setup — month and year-to-date next to budget, last year and a latest estimate, as the variance analysis asks for — is not there as standard.
The KPIs and the cash flow. A fixed KPI set with twelve-month trends is missing, and although options for cash flow insight exist, a full cash flow statement the way the management report asks for it is not there as standard — let alone consolidated.
Multiple administrations. Managing multiple administrations in one environment is possible, but an added-up group picture, cleaned of internal flows and converted to one currency, is not a standard feature — certainly not once other packages join the group; more on that further down.
Sharing. The report leaves the system as a PDF or export, and looking along structurally requires a BC license and authorization with far more visible than intended. You do not want to hand management, investors and the accountant an ERP login for a monthly report — and licenses are not free either.
The common thread: these are design choices of a broad ERP, not flaws. Business Central has to run the operation and the administration solidly, and it does. The reporting question deserves its own answer — without anything having to be rebuilt in the ERP.
A lot is possible in Business Central — so why a reporting layer?
Because the difference between “it is possible” and “it is there” is a project at Business Central: selecting or building an extension, setting up a BI environment, arranging authorizations, testing — and again with every change. For the ERP core processes that is a defensible investment; for steering information, which should move with the business, it is a structural brake and a lasting dependency on the partner or the BI specialist.
A reporting layer flips that ratio. The finance logic you would otherwise have to have built — a custom reporting layout, the budget comparison, the cash flow statement, consolidation with eliminations and currency conversion, click-through to the booking — ships as standard, and control sits with finance itself: adjusting a mapping is an action, not a change request to the partner.
And because the layer sits read-only on Business Central, nothing can go wrong with the source along the way: the ERP setup — often a serious investment — stays exactly as the partner built it. The operation notices nothing — and neither does the partner: nothing changes about their setup or responsibility.
That this is not a groups-only story holds here too: a business with a single BC administration puts a reporting layer on it as well, purely for the custom layout, the cash flow statement, the KPI trends and the sharing with stakeholders. And important: this is not either-or. Business Central remains the system where the operation and the administration run — the reporting layer only takes the financial figures out and turns them into steering information. How to approach that shift process-wise is covered in automating management reporting.
How do you connect Business Central to a reporting tool?
The connection between Finstack and Business Central runs through the official API and stands in a few clicks: select Business Central as a source, log in with the Microsoft account and confirm access — about 5 minutes of work per administration. No extension installation, no partner project: you arrange the access with your own Microsoft rights, in consultation with whoever manages the system.
The connection is read-only and works at transaction level. Finstack retrieves not just period balances but the underlying general ledger transactions with date, journal, contra account, description and currency — plus the chart of accounts and the open items. That detail is essential for reporting: it makes clicking through from a report figure to the source booking in Business Central possible, and it feeds the aging analysis and the customer-and-supplier overview. Writing back is not possible: bookings and operation stay entirely within the ERP.
The first synchronization pulls in the full history — not just the current financial year but the years before it, so trends and analyses work across the entire history — and after that the actuals refresh automatically every day, with a manual refresh at any moment: useful right before the reporting deadline or after a correction that needs to show immediately. The sync is as light for Business Central as a regular export.
Then comes the mapping: the BC accounts are linked to your own reporting or group chart of accounts — the layout management understands, in which administrations from other packages land on the same lines as well. The budget and the latest estimate live where they already live — in your own Excel or Sheets model — and sit next to the actuals through the 2-way sync. One-off work, typically within a day, managed by finance itself.
How do you report next: dashboards, Excel and sharing with stakeholders?
Reporting then runs along two equal roads — and most teams use both.
From the platform. The Finstack dashboards show the P&L, the balance sheet, the cash flow statement and the KPIs continuously current, in your own reporting layout and with every line clickable through to the source booking in Business Central. And working capital gets the insights the ERP does not deliver as standard: a direct cash flow overview, a customer-and-supplier overview, and the aging analysis — for a group across all administrations, in the group currency. All without an extension or BI project, and every change in the reporting is visible immediately for everyone with access.
In your own Excel or Google Sheets model. Through the 2-way sync, the actuals from Business Central refresh in the existing model in one click, next to the budget columns. The structure and formatting stay untouched — only the monthly export-and-paste work disappears. That works identically in Excel and Google Sheets.
Nor does it have to stay one structure: parallel reports — your own management layout next to the fixed template of an investor or bank — run simultaneously on the same figures; see parallel reporting for SME CFOs.
Sharing closes the chain. Management, investors and the accountant get access to the dashboards and reports through Finstack, with rights per user: every reader sees what is meant for them and can change or break nothing — and nobody needs a BC license for it. The question “where does this number come from?” is answered during the meeting with one click — without anyone having to enter the ERP.
Business Central in the group: next to other packages and currencies
Business Central rarely stands alone in Dutch groups. The common picture: a larger operating company or manufacturing entity on BC, the holding and smaller entities on Exact Online or AFAS, and sometimes a foreign entity with its own currency on top. For the group report that means three steps at once: adding up, eliminating and converting — a combination no package in the group can do itself.
Adding up alone is not enough. Management fees, recharged costs or internal deliveries — at manufacturing and trading groups often physical deliveries at transfer prices as well — sit in two administrations at once and count twice in a simple addition. Those intercompany flows have to be eliminated at group level, and foreign currencies converted consistently. What that group report looks like in substance is covered in management reporting for a holding company with multiple entities.
Finstack handles the processing side: every administration connects through its own package — Business Central next to Exact, AFAS, Twinfield, Xero or QuickBooks — is mapped to one group chart of accounts, multicurrency administrations convert automatically to the group currency, and the intercompany relations are recognized and eliminated automatically, from 1 to 50 entities, without setting up separate IC accounts. The group picture and per-entity figures come from one process, and the month-end close stays where it is — in the ERP, with the team that always did it.
For the deeper consolidation mechanics with Business Central — IC detection, reconciliation, eliminations in the consolidation layer — there is a dedicated deep-dive: consolidating with MS Dynamics 365 BC. This reporting article deliberately does not duplicate that; here the result counts — one group report in which the BC entity simply runs along.
What does reporting on top of Business Central cost and how fast are you live?
Finstack starts from EUR 39 per month for the first entity, with no implementation fees. The connection with Business Central is live in 5 minutes and the full setup — mapping to the group chart of accounts, dashboards, Excel sync — typically stands within a day. For an ERP where reporting otherwise quickly means an extension or BI project, that is the biggest difference.
Control then stays with finance: you adjust mappings and structures yourself, without a change request to the partner and without an invoice per adjustment. If you would rather hand off the setup entirely, you can opt for guided onboarding: the Finstack team then sets up the report together with you.
Set that against the alternatives. The Excel route costs export days every month. The extension and BI routes carry implementation and maintenance costs and a lasting dependency on partner or specialist — defensible for the operation, hard to justify for a monthly report. And switching ERPs is not on the table at all: Business Central usually represents a serious investment, and the operation runs well on it — that is what you want to keep. So the question is not Business Central or a reporting tool, but how many partner hours a monthly report should keep costing.
The payback period is practically the first month: the export days disappear immediately, and the report gains reliability and shareability at the same time. If an entity joins later, you simply connect it — the subscription grows with the structure, not the other way around. And the existing BI environment stays useful — for the operation. How this works for other packages sits in the overview of reporting solutions per accounting package.
Let the BI and extension investments in Business Central do what they are strong at — the operation — and keep the financial steering information on its own layer that finance manages itself. That way the two do not compete for the same setup budget.
Explore Finstack.
Free trial for 14 days.
Access to all features. No credit card required.
.png)
The 3 most common mistakes in reporting with Business Central
Three patterns we see again and again at Business Central users. Each costs time or trust; each is preventable with the right setup.
Starting an extension or BI project for every reporting wish
Having every new breakdown or KPI built by the partner or the BI specialist means waiting, costs and maintenance — so the report quietly goes stale. Steering information should be managed by finance itself: adjusting a mapping should be an action, not a project.
Mistaking the ERP report for the management report
A ledger report from Business Central shows the administration, but misses what management steers on: the custom layout, the budget comparison, the trends, the cash flow statement and the story. The reader drops off or draws their own conclusions — and the report loses its steering function.
Choosing a tool that only pulls trial balances
Some tools connect Business Central at trial-balance level: period balances only, no transactions. Then there is no click-through to the source booking, no aging analysis at group level and no clean intercompany elimination. For a report that has to be able to answer questions, transaction level is not a luxury but a requirement.
Frequently asked questions
Can't find your question? Let us know
Can I build a management report in Business Central?
To a limited extent. Business Central delivers solid financial standard reports per administration, but a custom reporting layout, full budget comparison, KPI trends, cash flow statement, group picture and sharing with stakeholders take extensions, BI or a partner. A reporting tool on the data layer delivers that layer ready-made on top of the ERP.
Why a reporting tool next to Business Central?
Because the difference between “it is possible” and “it is there” is a project at Business Central: extensions, BI setup or partner work, again with every change. A reporting tool ships the finance logic as standard — custom layout, budget comparison, consolidation, click-through — and puts control with finance itself.
Does Business Central have a cash flow statement?
Options for cash flow insight exist, once configured — but a full cash flow statement the way the management report asks for it is not there as standard, let alone consolidated across multiple administrations. A reporting tool on the data layer does deliver that, including a direct cash flow overview.
Can I use Business Central next to Exact, AFAS or Twinfield in one report?
Yes. Every administration connects through its own package and is mapped to one group chart of accounts; intercompany flows are recognized and eliminated automatically, from 1 to 50 entities. An operating company on Business Central simply runs along in the group report next to the other administrations.
How does the reporting handle multiple currencies?
Multicurrency administrations convert automatically to the group currency in the consolidation, consistently for the P&L and the balance sheet. The group report shows one picture in one currency, while every administration simply keeps booking in its own currency — without manual exchange-rate calculations in Excel.
How do I get figures from Business Central into Excel without manual work?
Through a 2-way sync: the actuals from Business Central refresh in the existing Excel or Google Sheets model in one click, next to the budget columns — the structure and formatting stay untouched. The monthly exporting and pasting disappears, and the model always reconciles with the ERP.
What does reporting on top of Business Central cost?
Finstack starts from EUR 39 per month for the first entity, with no implementation fees — no extension purchase or partner hours. The connection is live in 5 minutes and the full setup typically stands within a day, managed by finance itself. The payback period is practically the first month.
CFO turned Founder - Finstack
Sources and provenance
- Finstack — Integrations with MS Dynamics 365 BC and other packages: finstack.io/solutions/integrations
- Finstack — Reporting & insights (dashboards, Excel/Sheets sync): finstack.io/solutions/reporting-insights
- Finstack Help Center — Sources & connections (sync frequency, security, read-only): help.finstack.io
- Finstack — Pricing (from EUR 39/month): finstack.io/pricing
- Microsoft — Dynamics 365 Business Central product information: microsoft.com
Last reviewed: 28 July 2026 · Next review: October 2026
Consolidated reporting and forecasting.
