It is half past four on the last Friday of the month, and in the back office of a kitchen fittings supplier in Leeds the office manager is doing what she does every month. She exports the sales ledger from the accounts package.
She downloads a takings summary from the till system. Then she opens the spreadsheet, the one with tabs going back to 2021, and starts copying figures across, checking each column against the bank feed as she goes. By seven o’clock on Monday morning there will be a tidy one-page report waiting on the meeting room table: turnover by product line, debtors over sixty days, wages as a share of sales.
This routine works. It has worked for years. The directors trust the numbers because they know precisely how they were put together, and the business has grown steadily on the back of decisions made around that Monday table. Nothing about the ritual deserves criticism. It does, however, deserve a second look, because the several hours of skilled attention it consumes every month have become optional in a way they were not five years ago.
The data is already there
Small firms in the UK now hold more usable information about their own trading than at any point in their history. The accounts package records every invoice and payment. The till logs every sale, down to the minute. Payroll, stock, website orders and delivery schedules all sit in software of one kind or another, each system dutifully accumulating a record of how the business actually behaves.
What happens next is where the opportunity sits. The Department for Science, Innovation and Technology published its UK Business Data Survey 2026 in June, and it found that while 86 per cent of UK businesses handle digitised data, only 25 per cent analyse that data to draw insight from it. Put another way, much of the value already sitting inside those systems goes unused, and a firm that starts using it gains ground that few of its rivals are even contesting.
Where the spreadsheet strains
None of this means abandoning Excel, and it certainly doesn’t mean the spreadsheet was a mistake. For a generation of owners it has been the most flexible business tool ever made, and many of them know it inside out. The monthly report described above exists because somebody capable built it, and it has answered real questions month after month for years.
The strain shows in three places. First, the re-keying: every figure copied by hand from one system into another is a figure that can be mistyped, and the checking needed to catch those slips often takes longer than the copying itself. Second, version confusion: once “March report v3 FINAL” and “March report v3 FINAL amended” both exist on the shared drive, an hour can disappear into working out which one the meeting actually saw. Third, and most costly, the finished report describes last month. A pricing problem that appears in the first week of April stays invisible until the second week of May, by which time it has been running for five weeks. These are the classic signs of when a business outgrows Excel for reporting, and they say more about the growing complexity of the firm than about anyone’s skills.
What a live report changes
The alternative is a live report: a single dashboard connected directly to the accounts package and the till data, refreshed automatically on a schedule, and visible to everyone who should see it. There is one version of the numbers. Nobody re-keys anything. The Monday routine shrinks from an afternoon of assembly to a few minutes of reading, and the questions asked in the meeting change character, from “are these figures right?” to “why did trade counter sales dip on Thursdays?”
For many small firms the tool for this job is already paid for. Power BI, Microsoft’s business intelligence software (software that turns raw company data into charts, reports and dashboards), is included in or available alongside many Microsoft 365 subscriptions, sitting a few clicks from the Outlook and Excel licences the business already runs on. It’s hardly a niche product either: Microsoft reported in September 2025 that Power BI and its wider Fabric platform had passed 30 million monthly active users. Ready-made connectors, the links that pull data from one system into another, exist for the common UK accounts packages and till systems, so joining the data to the dashboard is largely a matter of configuration rather than custom development.
The skills step is smaller than it looks
The honest obstacle is confidence. A study by Qlik covering more than 7,000 executives and employees found that just 11 per cent of employees feel fully confident in their data literacy, meaning their ability to read, interpret and question data. Small firms feel this more sharply than large ones, because there’s no analytics department down the corridor to lean on.
Hiring a data specialist rarely makes sense for a fifteen-person firm. The more practical route is to train the person who already owns the numbers, because they bring something no outside analyst could: they know what the figures mean, which customers sit behind the debtor balance, and why February looks strange every year. Structured training closes the gap faster than many people expect. Red Eagle Tech, a London-based Microsoft Solutions Partner that has trained more than 200 professionals, runs a two-day Power BI masterclass delivered live online, with no prior experience needed and a format built around producing real reports rather than sitting through theory. Two days is a modest investment against a task that currently absorbs several hours every month, indefinitely.
One report, one person, one quarter
The way to start is deliberately narrow. Pick the single report that gets rebuilt by hand every month, the one whose assembly takes the most patience, and make that the whole of the first project. Choose the person who currently builds it, book their training, and give them the time to reproduce that one report as a live dashboard before the quarter ends. Resist the urge to add extra charts or new measures on the first pass; matching the old report exactly is what earns the directors’ trust in the new numbers.
Run the two side by side for a month if it helps, then let the spreadsheet version retire with the respect it has earned. If the Leeds office manager starts in September, she can walk into the first Monday meeting of December carrying the same one-page report the directors have read for years, produced in four minutes instead of four hours, and current to the previous evening’s till close. That is the whole ambition for the quarter, and it is enough.
