A journey with several stops
A job begins as an enquiry, becomes a quote, turns into an agreed project, passes through delivery and invoicing, and ends with payment. At each stop, something can go wrong: a quote that never gets a reply, an approval that drags, an invoice that is forgotten. Keeping a simple record of each job’s progress reveals the stops where time and money leak away.
The record need not be elaborate. A row per job in a table is enough.
The columns that matter
Give each job a row, and add columns for the date of the enquiry, the quote amount and date, the date it was accepted, the delivery date, the invoice date, the due date and the payment date. Add a column for notes. Eight or nine cells per job give a complete picture.
| Stage | Date | Amount | Notes |
|---|---|---|---|
| Quote sent | 3 Mar | 24,000 | Revised once |
| Accepted | 9 Mar | 22,000 | After discount |
| Delivered | 30 Mar | - | Two revisions |
| Invoiced | 31 Mar | 22,000 | Net 15 |
| Paid | 24 Apr | 22,000 | 9 days late |
What the dates reveal
The gaps between dates are the most valuable part. The days between quote and acceptance show how quickly clients decide. The days between delivery and invoice show your own promptness. The days between invoice and payment show the client’s habits.
If delivery-to-invoice is often long, you are delaying your own cash. That is the easiest gap to fix, since it depends only on you.
Patterns across many jobs
After ten or so jobs, averages become meaningful. Perhaps accepted quotes are often lower than the first figure, suggesting that you start too high or too low. Perhaps jobs from a certain source take far longer to be paid. These patterns guide where to spend effort.
- Quote-to-acceptance rate: what share of quotes become jobs
- Discount from quote to final: how much negotiation costs
- Invoice-to-payment time: how long cash takes to arrive
Forecasting from the pipeline
The same table can estimate future income. Quotes awaiting reply can be weighted by your typical acceptance rate, and accepted jobs can be placed in the months when they are likely to be paid. This is a rough forecast, but it is better than a feeling.
Treat the forecast as a range and keep spending based on received income, with the forecast used only for planning and for deciding when to look for more work.
Where stalls usually occur
In most small businesses, the largest delays come at two places: waiting for a client to decide, and waiting for payment after delivery. The first can be eased with a clear deadline on the quote. The second can be eased with prompt invoicing and a reminder rhythm.
A weekly scan of the table
Once a week, scan the table for jobs that have not moved for more than a set number of days. A reminder or a short message can restart them. Jobs that are quietly forgotten are one of the most common sources of lost income, and a weekly look catches them cheaply.
If a quote has had no reply after two follow-ups, mark it as closed. Keeping dead quotes alive inflates your sense of the pipeline.
Keep it light
If the table starts to feel like a chore, simplify it. The goal is awareness, not administration. Even three dates per job, quote, invoice, payment, provide useful insight, and the rest can be added later if it proves helpful.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

