Originally published on the NuWay Biz Solutions blog.
✦ Cover image: Made with ChatGPT — we're transparent about AI. See the exact prompt on the original post.
You know your business, and you wanted one screen that finally showed it to you straight. Real profit by job. Which channels actually make money. The number you'd bet a new hire on, in one place, not scattered across six apps that each hold a slice. So you did the reasonable thing. You got a dashboard.
And it showed you six numbers that don't agree. Sales say one thing, the bank says another, the profit-per-job figure either looks wrong or won't pull at all. It's tempting to decide the dashboard was a waste of money.
It wasn't. A dashboard was the right instinct. You just skipped the part that makes one work.
A dashboard is a window onto your data, not a fix for it
This is the piece the software ads leave out. A dashboard, or a full BI tool, doesn't create the truth about your business. It displays whatever data sits underneath it. Feed it clean, connected, reconciled numbers and it gives you a crisp, trustworthy view. Feed it six disconnected apps whose numbers were never reconciled, and it does exactly what it's built to do: it shows you the disagreement, faster and in nicer colors.
So a better screen won't help you, because the data foundation under it was never built. That's the whole thing, and it's the same reason your AI stalled out if you've tried that: point either one at a mess and it faithfully reflects the mess back at you. The real work lives in the data, which is what we mean by data-readiness.
A dashboard is only ever as honest as the data feeding it. Fix the data and the same dashboard starts telling the truth.
Why the six numbers disagree in the first place
≈36 apps at companies under 50 people (Okta, 2024)
Start with how many places your money actually lives. Even the smallest companies, the ones with fewer than fifty people, run about thirty-six different apps, according to Okta's look at 18,000 businesses. So six is the polite version of this. And those apps disagree for concrete, unmagical reasons, which is worth seeing clearly, because it's exactly what a dashboard cannot fix on its own.
The same job is "Job #4021" in your field app and "the Smith kitchen" in your books, so nothing lines them up. One system counts a sale the day you invoice it, another the day the money lands, so the same week shows two revenue figures. The labor for a job lives in one tool and the materials in another, and no one ever joined them, so "what did we actually make on that job" isn't a number anywhere. Point ten dashboards at that and you get ten renderings of the same confusion.
It gets worse every time a number is copied by hand between tools, because people get simple data entry wrong somewhere between one and five percent of the time. We walked through that number in the last piece, and the errors compound, so a figure that passes through six hand-touched steps has six chances to drift. None of that is a visualization problem. It's a foundation problem.
✦ Made with ChatGPT — we're transparent about AI. See the exact prompt on the original post.
The number that isn't anywhere yet
An owner who tracks profitability job by job described the real frustration, and it isn't ignorance. She knows her business cold. But getting true per-job profit meant combining the labor from one tool with the materials from another by hand, every month, long after the jobs were done. The number she needed most wasn't hiding in a report she hadn't opened. It didn't exist yet in any single place, because nothing had connected the two systems that held its halves.
What actually gets you one trustworthy screen
Your instinct was right. You just need to build the thing that feeds it. Four steps, and only the third one waits on the calendar.
📊 This section has an interactive graphic — see the full version on the original article.
Connect the sources into one place. Stop asking six apps to each keep their own tally. Pipe them into a single home so the data actually sits together. For a lot of small businesses that home is the system most of your money already lands in, your accounting tool or your point-of-sale. For more complex ones it's a small warehouse that connectors feed. Either way, the move is the same: one place, not six.
Align them so they agree. This is the unglamorous step that does the real work, and it's the one nobody sells you. Getting the tools into one place isn't enough if they still call the same customer three different names and count revenue two different ways. Aligning means deciding, once, that a customer is one customer, a job is one job, and a dollar of revenue is counted the same way everywhere, then making every source follow that. Skip this and your shiny new central dashboard shows the same disagreement it always did.
Reconcile it to your books. Tidy isn't the same as true. Once the data is connected and aligned, you tie it back to your reconciled, closed books, so the picture on the screen matches the money that actually moved. This is where the accounting close earns its keep, as one step in the foundation rather than the whole story. A bookkeeper described her own monthly reconcile as "the actual accounting work takes maybe half a day", and turning it into a report her client could trust took another four days, because reconciling waits on late-arriving fees, refunds, and unpaid invoices. That's the one step that lags the calendar, and it's normal.
Now show it. With the data connected, aligned, and reconciled, the dashboard finally does the job you hired it for. One centralized view, one version of revenue, real profit sliceable by job and by channel, the number you'd put your name to. The tool didn't change. What changed is that it now has something honest to display. And the same clean foundation is what any AI you try next will stand on, which is the whole point.
Is your data ready for the screen you want?
Before you buy or build anything, it's worth a blunt self-check. This is what "ready" actually looks like under a dashboard that tells the truth.
- [ ] Every tool that touches money feeds into one central place
- [ ] The same customer or job has one identity across tools, not five spellings
- [ ] Revenue is counted the same way everywhere (on invoice, or on payment, but consistently)
- [ ] Labor, materials, and fees for a job can actually be joined into one figure
- [ ] The central numbers tie back to your reconciled, closed books
- [ ] You can get "profit by job" or "profit by channel" without rebuilding a spreadsheet
Tick five of these and your data is genuinely ready. A dashboard built on it will tell the truth, and so will anything you point at it next, including AI.
How big a build you actually need
How much you build depends entirely on how tangled your money is, and most owners over-buy here. The goal is a screen you trust, not a project we get to sell you.
If you're a genuinely simple business, one bank account, one sales platform, no inventory and no unpaid invoices sitting out, you don't need a dashboard or any of this. Your books are basically current, so a good bookkeeper and your P&L already give you the honest view. For everyone past that point, there are two sane paths, and the difference is complexity, not ambition.
Consolidate. The light path.
- Most of your money already lands in one system
- A handful of sources, one or two sales channels
- That system's built-in reporting becomes your dashboard
Build a BI layer. The heavier path.
- Money genuinely lives across several channels that don't reconcile
- You need profit sliced by product, channel, and job
- A real BI tool, fed by connectors, on a small warehouse
Most small businesses live on the left. The multi-channel seller, running Shopify and Amazon and a marketplace and ad platforms at once, is the clearest case for the right: no single tool can reconcile that, so the BI layer is doing genuine work, not adding shine. Either way, own the foundation you build. Plenty of owners handed their books and their data entirely to an outside service and got locked out overnight when it failed. Rent the labor if you like. Keep the central place, and the login, yours.
That's the whole shape of it. A dashboard was always the right idea, just pointed at data that wasn't ready. Connect your sources, align them, reconcile them to your books, and the same screen that showed you six arguments starts showing you one answer.
One question, six apps
Pick a single question you'd love a screen to answer: profit on last month's biggest job, or which channel actually paid off. Now try to answer it with the tools you already have, and count how many you have to open and cross-reference by hand. That count is the size of your data-readiness gap. It's also exactly the gap a dashboard can't close for you until the data underneath it is connected.
Getting a business to one trustworthy screen, so the dashboard tells the truth and whatever you point at your data next actually works, is the work we do. If you're tired of six apps that won't agree, tell us what you're running on and we'll tell you honestly how big a build it really needs, which is usually smaller than you'd think.
Practical AI. Clear process. Real business value.
— Brian, NuWay Biz Solutions
Top comments (0)