Excel will not tell you when a number is wrong.
It recalculates, it never complains, and it looks exactly the same on the day it starts lying to you. The workbook that prices your jobs was built by someone who has left. This is the job that finds out what it is getting wrong.
Excel
Google Sheets
Xero exports| A | B | C | D | E | |
|---|---|---|---|---|---|
| 3 | Job | Client | Sale | Cost | Margin |
| 4 | J-1041 | Ashcroft | 4,200 | 2,860 | 1,340 |
| 5 | J-1042 | Weald & Co | 1,880 | 1,145 | 735 |
| 6 | J-1043 | Ashcroft | 6,400 | 4,010 | 2,390 |
| 7 | J-1044 | Halden | 2,750 | 1,600 | 1,4001 |
| 8 | J-1045 | Weald & Co | 3,120 | 2,090 | 1,030 |
| 9 | J-1046 | Pryor Ltd | 980 | #N/A2 | – |
| 10 | J-1047 | Ashcroft | 5,600 | 3,340 | 2,260 |
| 11 | J-1043 | Ashcroft | 6,4003 | 4,010 | 2,390 |
| 12 | J-1048 | Halden | 1,450 | 905 | 545 |
| 13 | Total | 9 jobs | 32,780 | 19,960 | 12,090 |
Worked example on a demonstration workbook · no client file or client name appears on this site
Three faults, and only one of them looks like an error.
The broken lookup announces itself. The other two sit there looking like perfectly ordinary numbers, and those are the ones that cost money for months.
Someone typed over the formula. Every other row recalculates. This one never will. Measured
Visible, at least. But the total below it silently treats the gap as nothing, so the margin reads better than it is. Measured
J-1043 is on rows 6 and 11. Real revenue, counted twice, feeding every report built on this sheet. Measured
Every pound in the report carries a label saying where it came from.
It is easy to write "this is costing you £40,000 a year" and impossible to check. So every figure is tagged with how I got it. If a finding does not fit one of these three, it gets no number.
I found the error and did the arithmetic.
A fault in your actual file, with the difference computed. Open the workbook and check it yourself in a minute.
You told me the time it takes.
Your hours on a task, priced at what that time costs. It rests on your estimate, so it is labelled that way.
What one named failure would cost.
One named thing going wrong, costed. Never a prediction, never added to the measured total.
What the £300 actually buys.
Two to three hours on your file, then a written report you own. Always paid. A free audit is a sales call. You pay for this one, so it can tell you not to buy anything.
The real one, with the tab called "old" and the colour code only you understand. Do not tidy it first. The mess is the evidence.
Formulas traced, hardcoded overrides found, lookups tested, duplicates matched, and every place the workbook depends on one person remembering something.
Findings ranked by what they cost, each tagged Measured, Observed or Scenario, each with the cell reference so you can check my working.
Fix it yourself with the report in hand, or have me rebuild it. Commission within 60 days and the £300 comes off the price.
And if the file turns out to be sound, you still pay. The two to three hours happened either way, and you get the report either way. Put plainly: if I find nothing, you have saved £300 and you should not hire me.
This is the report itself. Read it before you buy one.
A worked example of the full £300 audit, run end to end on an invented joinery firm. Four workbooks, three findings that matter, and every figure carrying the cell reference so the working can be checked. Nothing is summarised or held back for a paid version, because there is no paid version of this document that looks any different.
- 4 workbooks reviewed
- 8 risks, each cell-referenced
- 3 findings that matter
Five pages. No client data appears in it, and it prints to A4 exactly as it appears on screen.
Updated: monthly, first working day
WHERE THE NUMBERS COME FROM Data tab: pasted from the accounts export
Calcs tab: do not type in the grey columns
IF SOMETHING LOOKS WRONG Check row count on Data vs Report first
Duplicates: filter column A for repeats
Every workbook I rebuild leaves with a README tab.
The thing that actually breaks a spreadsheet is not a formula. It is that the person who built it knew things they never wrote down, and then they left.
The audit report goes to you. This goes in the file, and stays there. The first tab explains the workbook in plain English: what it is for, where each number comes from, what never to type over, and what to check first when it looks wrong. Your next hire picks it up without ringing anybody.
Included as standard · not an extra line on the quote
And if you want it rebuilt, not just diagnosed.
Most people take the report and fix it themselves, which is a perfectly good outcome. If you would rather it were done properly once, this is that job. Fixed price, quoted from the audit, never hourly.
You already know what is wrong and what it costs, because the audit said so with cell references. The quote prices the fixing of exactly those things. No discovery phase, no surprises.
Live links instead of pasted values. Lookups that survive a moved column. Input validation so a wrong rate cannot be typed. One authoritative file instead of four in circulation.
Every figure the new file produces is reconciled against the old one, and the differences are explained. Where they disagree, you are told which is right and why.
The README tab below, written for whoever picks it up next. You own the file outright. No add-in, no subscription, nothing to keep paying me for.
£750 to £2,000, fixed, quoted before any work starts. A single broken workbook sits at the lower end; a set of files that feed each other sits at the upper. The £300 audit fee comes off in full if you commission within 60 days. And if the honest answer is that the sheet should stop being a sheet, I will say so — that is the automations or dashboard conversation, and it is a different price.
Where this usually leads.
Send me the spreadsheet you're least sure about.
Twenty minutes on a call first, so you know what you are buying. Then £300, fixed, and you find out what it has been getting wrong.
Book an intro call£300 fixed · credited in full against a rebuild within 60 days