The Quote Pipeline Audit
You can produce the Quote Pipeline Audit from a client’s QuickBooks export in under an hour — and read a quote pipeline the way you read a balance sheet.
Why open estimates are where the cash hides
An estimate that never became an invoice is one of two things: unfinished revenue, or bad news nobody delivered. Most books carry months of both, and the owner feels it only as a mood — “we’re busy but cash is tight.” You can show it as a number: the open-pipeline value, aged. That number is the fastest advisory conversation-starter in the book, because it comes from the client’s own data, it is not a benchmark or an opinion, and nobody has ever put it in front of them. It is also, usefully, not anybody’s fault — which is what makes it safe to raise.
Getting the export
You need the estimate history, not the invoice history — this is the step people get wrong first. Twelve to twenty-four months, because a shorter window turns a pattern into an anecdote and a longer one drags in a business that no longer exists. If your client is on Desktop rather than Online the report has a different name but the same shape; export whatever lists estimates with dates, amounts, customers, and status.
The four findings, and what each one is telling you
The report gives you four things. Read them in this order — the value leads because it earns the meeting, and concentration closes because it turns the meeting into an action. The one people under-read is conversion: it is reported by count and by dollars separately, and the gap between those two numbers is where the real diagnosis lives.
Read the data-quality note before you read anything else
The tool tells you what it could not compute and why — a missing status column, undated estimates, rows it dropped. This is not a footnote, it is the first thing to read, and it is the thing that keeps you honest in the room. If there is no status column, you have no conversion number, and saying one out loud anyway is how an advisor gets caught. It is also a finding in itself: a book whose estimates carry no status is a book where nobody is tracking outcomes, and that is worth saying kindly.
Read the report before your client does
Run it, then sit with it for ten minutes and decide which finding leads. It is not always the biggest number — sometimes the aging curve or a single concentrated customer is the more useful door. Know what you expect the owner to say, and know which finding you will fall back to if the headline lands flat. The first time you read the report should never be in front of somebody.
Put your name on it
The report is white-labeled because the insight is yours. You knew the mess was there — the tool just counted it. Put your firm name on it and print. Worth knowing precisely, because a client will ask and you should be able to answer without hedging: their file never uploads. The whole thing computes in your browser and the data never leaves your machine, which is a privacy claim you can demonstrate rather than assert.
- In QuickBooks Online, open Reports and search “Estimates by Customer.”
- Set the date range to the last 12–24 months so the pattern is real.
- Use the export icon → Export to Excel / CSV.
- Drop that file into the audit tool. The file isn’t uploaded — it’s read on your device.
On QuickBooks Desktop the report has a different name but the same shape — export whatever lists estimates with dates, amounts, customers, and status.
Now do it
Reading this module does not complete it. These do — and they are what certification is issued against.
Progress saves in this browser only — nothing is sent to a server. Certification is reviewed personally, so the checklist is your working memory, not the credential.