Sign inStart free
  1. Home
  2. Guides
  3. How to track jobs from quote to paid without a spreadsheet nobody updates

How to track jobs from quote to paid without a spreadsheet nobody updates

Updated November 6, 2026

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.

StageMarked byNext moveChase if stuck for
EnquiryA call, text, form or email, logged with the customer's name and numberReply and book a visit or ask for photos1 working day
Site visitA booked visit, then your notes and photosWrite the quote2 days after the visit
Quote sentA quote with a number, a total and an expiry dateWait for acceptance3 to 4 days
AcceptedThe customer's written acceptance, and any depositAgree a date2 days
ScheduledA date in the calendar, confirmed to the customerOrder materials, send a reminderUntil the date
In progressA work order or job sheetFinish, and log any changesPast the planned end
DoneSign-off, photos or a completion noteInvoiceSame day
InvoicedAn invoice with a number and a due dateWait for paymentThe due date
PaidThe payment, and a receiptAsk for a review, file the recordNothing 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.

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:

JobStage on MondayValueDays in stage
Kitchen rewire, PatelQuote sent$6,2006
EV charger, MorenoAccepted, $400 deposit paid$1,7501
Fuse board swap, ClarkeDone$1,1004
Outdoor lights, HuangInvoiced, due last Friday$88017
Office sockets, Ridge DentalScheduled for Thursday$2,3005

The Monday review takes ten minutes and produces four actions:

  1. 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.
  2. Moreno: accepted yesterday. The owner offers two dates, the customer picks next Tuesday, and the job moves to scheduled.
  3. 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.
  4. 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.

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

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.

Templates for this

Put this into practice today

Start free. Add your logo and colours, say what you need, and send the link.

Start free