Business CentralPower BI

Five numbers every Business Central user should see every morning

IB

Izzy Bowers

Analytics Consultant

November 2026·5 min read
Traffic light showing red, amber and green against a night sky

Most Business Central users meet their numbers once a month, a week too late. Here are five worth seeing every morning, and how to put them on one page.

Why a morning number beats a monthly report

Most Business Central users live in the transactional screens and meet their numbers once a month, in a pack that arrives a week after the month has closed. By then the month is history. The teams who run tightest look at a small set of numbers every morning, not to replace the monthly pack but to catch the thing that is drifting while there is still time to act. You do not need a data warehouse to start. You need the right five numbers and somewhere to see them.

Cash position

Cash is the number that ends arguments. A simple daily view of cash in the bank, plus what is due in and out over the next few weeks, tells you more about the health of the business than almost anything else. Business Central holds the pieces. The value is in seeing them together, every morning, before the day’s decisions are made.

Overdue receivables

Every day an invoice sits unpaid is working capital you have lent out for free. A morning view of what is overdue, by how long and by customer, turns collections from a monthly panic into a daily habit. The number to watch is not just the total but the shape, because one large account slipping is a different problem from a general drift.

Sales against target

A running figure of sales this period against where you expected to be is the simplest early warning there is. Monthly, you find out you missed. Daily, you find out you are about to, while there is still a fortnight to do something. Pair it with last year for context, and you have a number that starts useful conversations rather than post-mortems.

Inventory that is not moving

Stock that does not sell is cash sitting on a shelf, and it is easy to miss because nothing alarms you about an item that simply does nothing. A morning view of slow and non-moving lines, and of anything about to run short, keeps both ends of the problem visible. For a lot of businesses this is the single biggest pool of trapped cash.

Margin, not just revenue

Revenue flatters. A deal can grow the top line and shrink the business if the margin is wrong. A daily read on gross margin, by product or customer where it matters, stops you celebrating sales that are quietly costing you money. It is the number that keeps revenue honest.

Getting there

None of these need a big programme. Business Central has the data, and a well-built Power BI model on top of it can surface all five on one page that refreshes overnight, ready before you are. The art is in getting the definitions right, so the margin number means the same thing to finance and sales, and the cash number can be trusted enough to act on. That is the part worth getting help with. If you would like these five on a single morning page for your own business, that is a good place to start a conversation.

Related reading

Business Central to Fabric in zero ETL steps: what the new mirroring preview means for BC customers

IB

Izzy Bowers

Analytics Consultant

Part of the Hopton Analytics team, delivering governed analytics programmes for UK mid-market organisations.

FAQs

Frequently asked questions

Get started

Ready to put this into practice?

Reading about better analytics is a start. Working with us is how it happens.

Book a free Data Assessment