Quoted vs invoiced as a bridge, not a number

Ask a finance director how much a job is worth and you will usually get a confident number. Ask how much of it is still to bill and the confidence drops. The two figures are meant to be connected, yet in many businesses they sit in different reports that were never built to agree.

The commonest cause is a quiet one: what "quoted" actually means.

The problem: one job, three times the money

A client asks for a price. You send a quote. They re-price the scope, so a second version goes out. The scope moves again and there is a third. Nobody deletes the earlier versions, because they are part of the audit trail and, frankly, because nobody wants to.

Now add up "quotes raised" on that project. If the report simply sums every numbered quote, a job that was only ever worth one quote reads as three. Against that inflated figure, the amount invoiced looks small, and the gap looks like work still waiting to be billed. It is not. It is the same job, counted three times.

A single headline number cannot fix this, because the error is in the definition rather than the arithmetic. What fixes it is a walk: a short sequence of lines, each of which answers a question you already ask, and which ends at the figure you actually care about.

The walk

Take an illustrative job: a £50k quote, re-quoted twice. These figures are round numbers for explanation, not anyone's real data.

• Quoted, gross: £150k. Every quote raised on the project, all three versions.
• Less superseded or lost: £100k. The two earlier versions that were replaced. Anything formally lost goes here too.
• Still standing: £50k. What was actually agreed to, or is still live. This is the figure to hold the job against.
• Less with the client, not yet accepted: nil. A quote that still stands but has not had a yes is pipeline, not work to bill. In this example the client has accepted, so the line is nil.
• Less invoiced to date: £30k. What has already been raised.
• Less scheduled to invoice: £10k. Invoices already in the diary for future dates.
• Still to bill: £10k. What remains once everything above is taken off.

Read down the list and each line is a question a finance director would put to a project lead. What did we actually agree? What is still waiting on a yes? What have we raised, and what is already scheduled? The answer to the last question, £10k, is the one that drives the order book and the next conversation with the client.

Why it starts from gross

It is tempting to begin at "still standing", since that is the cleaner number. Resist it. Starting from £50k and then deducting the superseded £100k a second time would double-count the deduction and leave you with a negative figure for a perfectly healthy job.

Starting from gross does something more useful. It puts the superseded value on the page. Nothing is quietly dropped. If a project carries £100k of replaced quotes, you can see that, and you can ask whether a client who re-prices twice is telling you something about how the job was scoped.

The walk has to close

The second rule is that the bridge must add up. Quoted, less each deduction in turn, must land exactly on still to bill. If it does not, something has been counted twice or has gone missing between two reports.

This is the cheapest control in the whole exercise. A bridge that closes tells you that the quotes, the invoices and the schedule are all being read on the same basis. A bridge that does not close tells you, before the board does, that two of your reports disagree. It is worth building the check in rather than relying on someone to notice. The column order is the arithmetic, and keeping it fixed is what stops a new column being added without the total still tying.

Negative still to bill is a signal

Most of the time still to bill is positive: accepted work not yet invoiced. Occasionally it goes negative. That means you have invoiced, or scheduled, more than the quote that stands.

Treat that as information rather than as an error. In professional services it usually means scope has crept beyond what was priced and nobody has issued a revised quote. The work is being done and billed, but the paperwork has not caught up, so the client has not formally agreed to the extra. A negative line prompts the right conversation early, while it is still a re-quote and not a dispute.

What to do on Monday

You do not need new software to try this. Pick your five largest live projects and build the walk by hand.

1. List every quote raised on each project, with its status.
2. Separate the ones that still stand from those replaced or lost.
3. Take off anything not yet accepted.
4. Take off what has been invoiced, then what is scheduled.
5. Check the walk closes. If it does not, find out why before you trust any total.

Expect at least one job to surprise you, in either direction.

If you would like help getting from reports that disagree to a bridge that closes, we would be glad to talk it through. You can book a 30-minute discovery call, or start with our free Business Insight Assessment to see how well your business can see itself today.