Business Central is a brilliant system of record and a poor analytics tool. Why finance keeps ending up in Excel, and the pattern that gets them out.

Business Central runs your business. It should not run your reports.

Business Central is very good at one job and quietly bad at another, and most finance teams are paying for the gap without naming it. It runs the business beautifully: it keeps the ledgers straight, enforces the rules, posts the transactions, and tells you the truth about a given company in a given period. Ask it an analytical question, though, and the strain shows at once. Trends across several years. A comparison across companies. Sales blended with something that does not live in Business Central at all. It fights you, and the workaround is always the same: someone exports to Excel, and the real reporting happens there.

For more on this, see our Business Central analytics work. It is also worth reading alongside rebuilding Wasabi's Microsoft estate if the topic is new to you.

The faster straw

The usual fix makes it worse. A Jet-style add-in pulls Business Central data live into a spreadsheet, the immediate pain eases, and the underlying problem gets a fresh coat of paint. The analysis is back in a spreadsheet, refreshed by hand, understood in full by one person, and disagreeing with the next person's copy by Friday. You have not escaped the spreadsheet. You have given it a faster straw.

This is not a fault to fix inside Business Central, and no amount of extra account schedules will fix it. It is a transaction system being asked to be an analytics platform, which is asking a delivery van to win a race. The answer is not more reports inside the tool. It is to get the data out into a model built for questions, and report there.

The pattern that works

Leave Business Central to be the system of record, which it is excellent at. Extract its data on a schedule into a separate analytics store, and let people interrogate the copy. Never point a report straight at the live database: analytical queries are heavy, and they will slow the system everyone relies on to take orders and post invoices. In the online product you cannot do it anyway, which is the platform saving you from yourself.

Then model it properly, because it is an analytics estate now and deserves to be treated as one. Do not mirror Business Central's table structure, which is shaped for transactions and is exactly the wrong shape for analysis. Build a star schema: a sales or ledger fact, clean dimensions for customer, item and the chart of accounts, an agreed calendar.

Two details that decide whether finance trusts it

Two things separate a Business Central model finance leans on from one they ignore. Bring across the dimensions, the global and shortcut dimensions they already use to slice the ledgers, because that is how the business actually thinks about its numbers. Drop them and you have taken away the very cuts finance relies on every day. And if you run more than one company, consolidate them, so the group can be seen as a group rather than a stack of separate reports that someone adds up by hand.

One more, and it is the one people skip. The financial reports and account schedules in Business Central encode real logic: how the profit and loss is grouped, what nets against what. Rebuild that from the definitions, with finance in the room, not by guessing from the ledger. Guess it and the numbers will not tie back to the accounts, and a number that does not reconcile to finance is a number nobody will ever trust again.

Something to check this week

Find your most-used Business Central report and ask where the real work happens. If the honest answer is that someone exports it to Excel and the decisions get made there, that is your signal. The reporting has already left Business Central. It is just living somewhere ungoverned, and you are one resignation away from losing it.

This is the heart of how we build Power BI and data platform work on top of Business Central: get the data out cleanly, model it for questions, and bring the finance logic across with finance in the room. The full version, including the supported export routes and the traps, is in our Beyond Business Central guide. Keep using Business Central for what it is brilliant at. Just stop asking it to do the job it was never built for.

If any of this sounds familiar, talk to us about your data.

Related reading

• What is worth adopting from a Power BI release, and what to ignore
• Your Power BI Report Is Slow. Power BI Is Probably Not The Problem.
• Three jobs, one dashboard, none of them done well