Tuesday morning, monthly review. The sales spreadsheet says last month was the best of the year. The bookkeeper’s file says revenue was flat. The job tracker shows three projects running over budget that don’t appear anywhere else. The owner looks at all three, sighs, and makes the call on instinct. Again.
That scene plays out in businesses across Brisbane every month, and the owners involved are usually sharp operators. The problem is never intelligence. It’s that six spreadsheets built by six people for six purposes will never agree, and once the numbers stop agreeing, people stop using them.
How a business ends up with six spreadsheets and no answers
Reporting sprawl happens by accretion, not by decision. Nobody sits down and designs six conflicting spreadsheets. Each one gets built to answer a single question at a single moment, and then it never gets retired.
The pattern we keep seeing goes something like this. The owner builds a cash flow sheet during a rough patch in year two. The sales manager builds a pipeline tracker because the accounting file doesn’t show quotes. The bookkeeper exports something from Xero each month because that’s what the accountant wants. An ops person builds a job costing sheet after a project blows out. Someone in marketing keeps their own tab of ad spend. Then a bank asks for a forecast, so a sixth file appears.
Each file made sense when it was created. Five years on, they overlap, contradict each other, and depend on one person remembering to update them. When that person is on leave, the number simply doesn’t exist that week.
Why do all my reports show different numbers?
Reports disagree because they define the same word differently, pull data at different times, and rely on manual updates that drift. It is almost never a software problem, which is why buying new software rarely fixes it.
Take the word “sales”. In one spreadsheet it means quotes accepted. In the accounting file it means invoices raised. In the bank feed it means cash received. All three are legitimate numbers. All three will be different in any given month, sometimes by a lot, and nobody in the meeting can say which one the conversation is actually about.
Timing does the rest of the damage. One file was updated Friday, another gets refreshed monthly, a third hasn’t been touched since the last BAS. Compare them side by side and you’re comparing three different points in time as though they were one.
Then there’s the quiet killer: manual re-keying. Every time a number is copied from one file to another by hand, there’s a chance it’s wrong, and no way to trace it back. We reviewed a business recently where the same customer appeared under three spellings across three files, so their revenue was split three ways and no report showed who the biggest client actually was. The owner had been wrong about it for two years.
What deciding on gut feel actually costs
The cost shows up in two places: the hours spent rebuilding reports, and the decisions made without them. The second is bigger, but the first is easier to count, so start there.
A conservative illustration with round numbers:
- Someone spends half a day a week reconciling and updating reports. Call it 4 hours.
- Over 48 working weeks, that’s roughly 190 hours a year.
- At a loaded cost of $60 an hour, that’s around $11,400 a year.
And that buys you reports nobody trusts. The dearer cost is what happens next. When no report is believed, the loudest voice in the room wins. Pricing stays where it was because nobody can prove which jobs lose money. A quietly profitable service line gets starved because the revenue sheet undercounts it. Underperformance hides for quarters, because by the time it shows up in the accounting file, the damage is months old.
Gut feel isn’t worthless. An owner’s instinct, built over years, is real information. But gut feel calibrated against good numbers is judgement. Gut feel used because the numbers are unusable is guessing with confidence.
What fixing it looks like
Fixing reporting sprawl means agreeing on definitions, picking one source system for each type of number, and building one view on top of it. In that order. Most owners try to start with the dashboard, which is starting at the end.
Agree the definitions first. Get the people who use the numbers in a room and settle what “sales”, “margin” and “pipeline” mean. This takes an afternoon and an argument. Have the argument once, write the answers down, and every future report inherits them.
Name one source per number. Revenue lives in the accounting system. Pipeline lives in the CRM or job system. Hours live in the time tracker. Any spreadsheet holding a number that already lives somewhere else gets retired, not maintained in parallel.
Build one view on top. A single dashboard or weekly report that pulls from those sources, ideally automatically. It doesn’t need forty charts. Eight to twelve numbers the owner actually acts on beats a wall of graphs nobody reads.
Here’s the practical difference, side by side:
| Six spreadsheets | One reporting layer | |
|---|---|---|
| Where numbers live | Copies everywhere, no master | One source system per number |
| Definitions | Different in every file | Agreed once, written down |
| Updates | Manual, whenever someone remembers | Automatic or on a fixed schedule |
| Time to answer “how did we go?” | Hours of reconciling | Minutes |
| What happens in meetings | Debate about whose number is right | Debate about what to do |
That last row is the whole point. The meeting changes from arguing about the numbers to arguing about the business.
Where to start without a six-month project
Start by listing every recurring report and killing the duplicates. That costs nothing and usually removes a third of the sprawl in a week.
Then pick the one decision you make most often on gut feel. For a trades business it’s usually pricing. For a wholesaler, stock. For a services firm, which clients to keep. Build one clean, trusted number for that decision alone, prove it works for a month, then extend the same approach outward.
One thing we’d say from sitting inside these projects: resist the urge to keep the old spreadsheets running “just in case”. Parallel systems are how you got here. The old files stay as archives, not as living documents, or within three months you’ll have seven spreadsheets instead of six.
Questions owners ask us about messy reporting
Do I need new software to fix conflicting reports?
Usually not. Most small businesses already own the systems they need, typically an accounting package and a job or CRM system. The fix is definitions, discipline and one connected view, and new software without those just produces prettier disagreement.
What is a single source of truth in plain terms?
A single source of truth means every number in the business has exactly one place it officially lives, and every report pulls from that place. If two reports show revenue, they both draw from the same system with the same definition, so they can’t disagree.
How long does fixing reporting take in a small business?
A focused version, covering the eight to twelve numbers that drive decisions, typically takes weeks rather than months. The definitions workshop is an afternoon; connecting the sources and building the view is the longer part, and it depends on how clean the underlying systems are.
Can I keep using spreadsheets at all?
Yes, spreadsheets are fine for analysis and one-off modelling. The problem starts when a spreadsheet becomes the permanent home of a number that also lives in a proper system, because from that day the two copies drift apart.
Should I hire a data analyst instead?
For most businesses under a few million in revenue, a full-time analyst is premature. The initial fix is a project, not a headcount, and once it’s built the ongoing effort is small enough for existing staff to run.
Which numbers should a small business track weekly?
Cash position, sales booked, sales invoiced, gross margin on recent work, and pipeline or forward bookings cover most businesses. Add one or two numbers specific to your model, such as utilisation for a services firm or stock turns for a wholesaler, and stop there.
If your reports argue with each other
This is the bread and butter of our operations work: dashboards, definitions, cash flow and the plumbing underneath them, with growth and legal advisors down the hall when a reporting question turns into a pricing or contract question. If your monthly meeting starts with a debate about whose spreadsheet is right, get in touch and we’ll have a look at what you’re working with. The first conversation is just that, a conversation.