How to track jobs from quote to paid without a spreadsheet nobody updates
A job moves through about nine stages between the first call and the money landing, and most lost income leaks out between two of them. This guide gives you the stages, the document that proves each one, what to chase and three numbers worth checking weekly.
To track jobs from quote to paid, give every job one record and move it through fixed stages: enquiry, site visit, quote sent, accepted, scheduled, in progress, done, invoiced and paid. Each stage should be marked by a document or event you can point to, not by memory. Then look once a week at every job that has sat in one stage too long, and chase it.
That's the whole system. It works on a whiteboard, in a notebook or in software, as long as there is one place to look. The point isn't the tool. A one- to five-person business rarely loses money on the work itself; it loses it on the quote nobody followed up, the finished job nobody invoiced, and the invoice nobody chased.
The stages, and what marks each one
A stage is only useful if you can tell for certain whether a job has reached it. That's why each stage below is tied to a document or an event.
| Stage | Marked by | Next move | Chase if stuck for |
|---|---|---|---|
| Enquiry | A call, text, form or email, logged with the customer's name and number | Reply and book a visit or ask for photos | 1 working day |
| Site visit | A booked visit, then your notes and photos | Write the quote | 2 days after the visit |
| Quote sent | A quote with a number, a total and an expiry date | Wait for acceptance | 3 to 4 days |
| Accepted | The customer's written acceptance, and any deposit | Agree a date | 2 days |
| Scheduled | A date in the calendar, confirmed to the customer | Order materials, send a reminder | Until the date |
| In progress | A work order or job sheet | Finish, and log any changes | Past the planned end |
| Done | Sign-off, photos or a completion note | Invoice | Same day |
| Invoiced | An invoice with a number and a due date | Wait for payment | The due date |
| Paid | The payment, and a receipt | Ask for a review, file the record | Nothing to chase |
Two stages can be skipped for small work. A call-out repair might go straight from enquiry to scheduled, with the price agreed on the phone. Don't skip the documents that matter for money: the acceptance, the invoice and the receipt.
Where the money leaks
Watch three gaps in particular.
Quote sent to accepted
Quotes go quiet because the customer forgot, is comparing, or needs someone else to agree. A follow-up three or four days after sending recovers a surprising share of them, and an expiry date gives you a reason to send it. Whether the quote was opened tells you which message to send. The guide to quotes customers accept online covers the follow-up schedule.
Done to invoiced
This is the gap owners underestimate. You finish at 5pm, you're tired, and the invoice waits until Sunday night, or until next month. Every day a finished job goes uninvoiced is a day added to how long you wait for the money, and a day for the customer's memory of good work to fade. Aim to invoice the same day, ideally from the job itself before you leave.
Invoiced to paid
Most late payers aren't refusing. They need a reminder, an easier way to pay, or the invoice sent to the right person. A reminder before the due date and another just after it handles most of these. The wording is in overdue invoice reminder wording, and making payment a single tap is covered in getting paid by link.
Three numbers worth checking weekly
You don't need a dashboard. These three figures, worked out once a week or once a month, tell you where to look.
- Quote win rate. Quotes accepted divided by quotes sent, over the same period. If it drops, look at your follow-ups and your prices before you look at your marketing.
- Days from done to invoiced. The average gap between finishing and invoicing. This one is entirely in your control, and the target is zero.
- Days to paid. The average gap between invoice and payment. Compare it with your stated terms. If your terms are 14 days and customers average 31, your reminders aren't working.
If you want one figure for the health of your receivables, use days sales outstanding (DSO). The usual formula is: money owed to you at the end of a period, divided by your credit sales for that period, multiplied by the number of days in the period. Credit sales here means work invoiced rather than paid on the spot.
DSO = (amount owed at month end ÷ invoiced sales in the month) × 30
A plumber who invoiced $24,000 in June and was owed $9,600 on June 30 has a DSO of (9,600 ÷ 24,000) × 30 = 12 days. If that creeps up to 20 over a few months with no change in terms, customers are paying later, and you'll feel it in the bank before you see it anywhere else.
A worked example: one week of jobs
A three-person electrical firm starts Monday with these jobs on the board:
| Job | Stage on Monday | Value | Days in stage |
|---|---|---|---|
| Kitchen rewire, Patel | Quote sent | $6,200 | 6 |
| EV charger, Moreno | Accepted, $400 deposit paid | $1,750 | 1 |
| Fuse board swap, Clarke | Done | $1,100 | 4 |
| Outdoor lights, Huang | Invoiced, due last Friday | $880 | 17 |
| Office sockets, Ridge Dental | Scheduled for Thursday | $2,300 | 5 |
The Monday review takes ten minutes and produces four actions:
- Patel: six days with no answer on a $6,200 quote. The log shows it was opened twice, so the owner calls instead of texting, and learns the customer wants to drop the garage circuit. A new version at $5,600 is accepted on Wednesday.
- Moreno: accepted yesterday. The owner offers two dates, the customer picks next Tuesday, and the job moves to scheduled.
- Clarke: finished four days ago and never invoiced. That's $1,100 the business hasn't even asked for. The invoice goes out within the hour, and it's paid on Friday.
- Huang: three days overdue. A polite reminder with the pay link goes out, and the customer pays that evening.
Ridge Dental needs nothing yet except a reminder on Wednesday. By Friday, two stuck jobs worth $1,980 have been paid, and the biggest quote of the week is accepted. None of that needed new customers. It needed someone to look at the board.
One record per customer
Keep every job's documents together under the customer they belong to: the enquiry, the quote and its versions, the acceptance, the work order, any change orders, the invoice, the payment and the receipt. When a customer rings in a year asking what was done to their fuse board, you want one place to look, not three apps and a glove box.
It also matters for tax. In the US, the IRS says you should keep records for as long as they may be needed for any tax law, which is generally three years from filing and longer in some cases, such as six years if income was substantially under-reported. In the UK, sole traders must keep records for at least 5 years after the 31 January submission deadline of the relevant tax year. The IRS recordkeeping page lists the supporting documents it expects, including invoices and receipts. Check the rules that apply to you; this is general information, not tax advice.
Choosing how to track it
Any of these can work. Pick the one you'll actually keep up to date.
- A whiteboard with columns. Visible, cheap and impossible to ignore in a shared workshop. Weak when you're on site, and it keeps no history.
- A spreadsheet. One row per job, one column per stage date. Good for working out the three numbers. Easy to let slide, because updating it is a separate chore.
- Software that updates itself. The best tracking is the kind you don't do by hand: the quote being accepted moves the job, the invoice being paid moves it again. That's less to forget on a busy week.
Whatever you choose, the weekly review is what makes it work. Put it in the calendar for the same time each week, and look only at jobs that have sat too long in one stage.
Common mistakes
- Tracking leads but not finished work. Most systems are built to win jobs. The uninvoiced finished job is where small firms quietly lose the most.
- Stages without evidence. "Accepted" should mean a written yes, not a handshake you half remember.
- Chasing everything equally. A $6,000 quote and a $90 call-out don't deserve the same effort. Sort by value within each stage.
- Losing the deposit in the paperwork. Show it on the final invoice, and make sure the balance is what you ask for.
- No expiry on quotes. Open-ended quotes clutter the board for months. Close them out when they expire.
- Splitting one customer across tools. If the quote is in your email and the invoice is in your accounts app, nobody can see the whole job.
- Skipping the receipt. It closes the job for the customer as well as for you, and it's the first thing an accountant asks for.
On Programmable, each page you send is kept on the customer it was sent to, so their quotes, work orders, invoices and receipts sit together. Home shows what's waiting on you and what's waiting on the customer, such as a quote not yet opened or not yet accepted, along with money owed. Money shows what's owed, what's overdue and what's been paid recently. An accepted quote turns into an invoice with the same lines, and there are templates for the work order, the receipt and an order status page customers can check themselves.
Questions
What stages should a small trade business track?
Enquiry, site visit, quote sent, accepted, scheduled, in progress, done, invoiced and paid. Small call-outs can skip a stage or two, but never the acceptance, the invoice or the receipt.
How do I calculate days sales outstanding?
Divide the amount customers owe you at the end of a period by what you invoiced in that period, then multiply by the number of days in the period. Watch the trend more than the single figure.
How quickly should I invoice after finishing a job?
The same day if you can. Every day between finishing and invoicing adds a day to how long you wait for the money.
How long should I keep job records?
It depends on where you are. In the US the IRS generally means at least three years, and longer in some cases. UK sole traders keep them at least five years after the 31 January deadline. This is not tax advice.