Reads a Backup & Export JSON from the accounts app. Nothing is sent anywhere and nothing is written back — this tool only reads.
Drop your backup JSON here, or click to choose a file
Client & period
Running costs to include▸
Open to choose which costs count.
Ticked categories are read from your transactions for the period. Set an amortise span in months for one-off payments that cover a longer stretch (e.g. ACS over 60). Leave at 1 for pay-as-you-go costs. Allocation of these to the client is by job-count share.
Category
Payments
In period
Amortise (mo)
Your own cost entries
For anything not in the transactions, or where the transaction pattern skews it. Accountant paid in scattered instalments — untick "Accountancy Fees" above and add it here as an annual figure. ACS — untick "ACS Assessments" above, add it here, choose Spread over 60 and it divides across 5 years. Annual pro-rates ÷12×months; spread divides your figure across N months from its start. Labels show on the export.
Label
Amount £
Basis
In period
Wages▸
Off — no staff wages switched on.
Off by default — your own drawings are not a business cost, so nothing here counts until you switch a person on. Toggle on only genuine staff wages you want allocated to this client by job-count share.
Person (from transactions)
Paid in period
Allocated to client
Result
Rate estimator — what the same work would have billed
Reprices the jobs you actually did in this period at a higher base rate, scaling the whole ladder in proportion (so the additional-time increment moves too, the way your Apr-2026 change did). Based on reconstructed hours — exact for ladder-priced work, approximate for fixed-quote jobs.
Year-by-year — this client
Each trading year (from your first invoice date, anniversary to anniversary) for the selected client, on the current cost settings above.
Materials
Materials charged on invoices, kept separate from labour. Where a line had materials built into its price, the recorded materials figure is split back out. Compared with the business's Parts and Materials bank spend for the same period.
This client vs the rest — over time
Where your time went (share of jobs) against where your money came from (share of income), each year. When a side's income share sits below its job share, they pay less per job than the rest of your work — and the other side pays more.
Payment behaviour
How this client actually pays — because fast, clean payment is worth real money, and slow payment or repeated chasing is a hidden cost the rate alone doesn't show.
Job types & parts
Reads the wording of every job line (and each £-amount in written-up invoices) and counts what the work was — burners, pumps, 3-port valves, services and so on. Mentioned = the part appears in the job. Changed = a change word (replaced, changed, chgd, fitted, new, swpd…), or the part simply named on a breakdown (e.g. "not lighting spark gen" — shown as assumed). Not counted when it says checked / cleaned / reset / recharged / quoted / needs. Where it can't tell (e.g. "pump noisy") it asks you. Click a row to see the actual job text behind the count.
Keyword editor
Each keyword is a rule for every job, past and future. Leave Files into on Auto and the tool puts it in the closest built-in type, or pick one yourself. Changes save as you go — in this browser, and to Supabase when you're signed in.
Activity & recency
When this client last gave you work, and whether their volume is rising, steady or falling over recent months — the early-warning signal a year-end view misses.
HGS Local Ltd — Client Analysis · read-only · labour hours are reconstructed from the pricing ladder, so they're estimates, not recorded times.