A near-real-time financial picture means you know on Tuesday what last week made. Not to the second, and not on a screen full of flashing dials: it means the few numbers that run your business (margin by job, contract or customer, cash coming in and going out, work done but not yet invoiced, and labour cost against revenue) are up to date to within a day or a week, instead of arriving three or four weeks after month end. For most growing businesses, weekly is enough and daily is a bonus. Getting there is less about buying a dashboard and more about making sure each number is captured once, in one agreed place, so it can be reported without someone rebuilding it by hand.
What "near real time" realistically means
Near real time means the delay between something happening and you seeing its effect on the numbers is short enough to act on. In practice:
- Daily for the things that change fast and that you can act on the same week: hours worked, jobs completed, orders shipped, cash received.
- Weekly for margin, work in progress and labour cost against revenue. One week of data is enough to spot a contract going wrong while there's still time to fix it.
- Monthly stays the rhythm for the formal accounts, tax and the board pack. This doesn't replace the accountant's month end; it stops month end being the first time you find out.
Why is weekly enough? Because most decisions an owner or operations manager makes (re-price a contract, have a word with a supervisor, chase a slow-paying customer, move a crew) happen on a weekly cycle anyway. A number that refreshes every minute but is wrong is worse than one that refreshes every Monday and is right.
What goes in the picture
Keep it short. The useful version fits on one page and usually covers:
- Margin by job, site, contract or customer: what you earned against what it cost you, for each unit of work you actually manage. Business-wide profit hides the one contract that's losing money.
- Cash coming in and going out: what's in the bank, what customers owe and how overdue it is, and the big payments due in the next fortnight (payroll, suppliers, tax).
- Work done but not yet invoiced: jobs finished, hours worked or goods delivered that haven't become an invoice yet. This is money you've earned and can't collect until someone bills it.
- Labour cost against revenue: for most service, trade and production businesses, labour is the biggest cost and the one that drifts quietly.
Add one or two of your own if you must, but past five or six, nobody reads it.
Why most businesses only see it after month end
They turn up late for the same handful of reasons, and none of them is that the accountant is slow.
The same information is typed in more than once. The supervisor approves a timesheet in one app, the office types the hours into payroll, then someone types them again onto the invoice. That's double entry (the same information typed into two or more systems). Each retype takes time, so it gets batched up until month end, and each one is a chance for the numbers to drift. Our page on eliminating double data entry covers this pattern.
Information stops before it reaches where it's needed. The job card says the work is done, but the finance team doesn't hear about it until the paperwork comes back. The production run used more ingredients than planned, but that only shows up at the next stocktake. Information stuck in one system or spreadsheet, invisible to the rest, is what people call data silos. We explain them in why your systems disagree.
The systems disagree. The job system says a contract made money; the accounts say it didn't. Before anyone can report, someone has to work out which one is right. If that sounds familiar, see when your systems give different numbers.
Everyone waits for the accounts. Because the operational numbers can't be trusted on their own, the business waits for the bookkeeper and accountant to reconcile everything. We cover what that costs in can't see job profit until it's too late.
Notice that none of these are fixed by buying a reporting tool. A dashboard sitting on top of retyped, disagreeing data just shows you the wrong answer faster.
What it looks like on a Monday morning
Here's what a near-real-time picture looks like in a few different businesses. These are illustrations, not client stories.
- Commercial cleaning: on Monday you can see last week's margin for every contract, because the hours worked and the hours billed come from the same approved timesheet.
- Trades and field service: on Monday you can see every job completed last week that hasn't been invoiced, because the technician closing the job is what triggers the invoice draft.
- Wholesale distribution: on Monday you can see margin by customer for last week, including freight and the rebates you've promised, because the landed cost of stock and the selling price come from the same records.
- Food production: on Monday you can see what each production run actually cost against the recipe, because the ingredients used and the hours on the line are recorded at the run, not worked out at stocktake.
- Labour hire: on Monday you can see the margin on every placement last week, because the pay rate, the charge rate and the approved hours all come from one timesheet. A placement where the award rate went up but the charge rate didn't shows up straight away.
In every case the trick is the same. The number isn't calculated by someone at month end; it falls out of the work being recorded once, properly, at the point it happens.
What has to be true first
Two things have to be in place before any of this works.
One agreed home for each number. Customers, jobs, hours, prices and invoices each need one place that's treated as right, with everything else taking its copy from there. That's what a single source of truth means (one place everyone takes the number from). Our plain-English guide to a single source of truth goes through how to decide where each piece of information lives.
Capture it once. If hours are typed into three systems, they'll be in three states of correctness. The information needs to be entered once, as close to the work as possible, and flow from there.
Neither of these needs a big new system. For many businesses it's a matter of agreeing who owns what and connecting the systems they already run, whether that's a job management app, a stock system, a payroll system and the accounts in Xero, MYOB or something else.
Steps to get there, simplest first
1. Pick the three to five numbers that matter. Ask what you'd want to know every Monday. Write them down.
2. Agree the definitions. "Margin" means different things to sales, operations and finance. Does it include overheads? Travel time? Freight? Rebates? Agree one definition for each number and write it down.
3. Fix how the data is captured. For each number, trace where the underlying information is first entered and where it's retyped. Remove the retyping. This might be as simple as a setting in your job or timesheet app, or a standard connector between two systems. Be honest here: often the fix is a process change, not software.
4. Connect and report. Once the information is captured once and flows between systems, build the weekly report from it so it refreshes itself. This is where reporting tools such as Power BI earn their keep, but only after steps 1 to 3.
One honest point: a good weekly spreadsheet built from clean data beats a flashy dashboard on bad data. If you get steps 1 to 3 right and someone spends half an hour every Monday pulling the figures into a spreadsheet, you have a near-real-time picture. Automating the report is the last step, not the first. Our business process improvement guide covers the process side, and combining your business data into one dashboard covers the reporting side once the data is ready. If you run a construction business, the Monday morning report for builders gives a version tailored to jobs and claims.
When it's worth getting help
You can usually do steps 1 and 2 yourselves over a couple of meetings. Steps 3 and 4 get harder when several systems are involved, when the same information lives in more than one place, or when the reporting needs to pull from operations and accounts together. That's the work our business intelligence and reporting service does: connecting the systems, capturing data once and building reports that match the accounts.
New to some of these terms? Our plain-English glossary explains them in a sentence or two each.
Frequently asked questions
What is a near-real-time financial picture?
It's an up-to-date view of the few numbers that run your business, such as margin by job or customer, cash, unbilled work and labour cost, refreshed daily or weekly instead of waiting for month-end accounts.
Do I need real-time reporting for a small or growing business?
Usually not second-by-second. Weekly is enough for most decisions, with daily figures for fast-moving things like hours, orders and cash received. What matters is that the numbers are right and arrive while you can still act on them.
Why can't I see my profit until the month-end accounts?
Usually because information is retyped between systems, gets stuck in one system or spreadsheet, or the systems disagree, so everyone waits for the accountant to reconcile it. Fixing how the data is captured is what shortens the wait.
Do I need a dashboard tool like Power BI?
Not to start. A weekly spreadsheet built from clean, agreed data is a near-real-time picture. A dashboard tool helps once the data is captured once and flows between systems, because then the report can refresh itself.
If you'd like to know on Tuesday what last week made, book a free initial chat. We'll talk through which numbers matter for your business and where they're getting held up.