Business

Tracking a job from quote to final payment

Every freelance job has a path from first enquiry to money in the account. Recording each step shows where jobs stall and where cash gets stuck.

Editorial illustration for Tracking a job from quote to final payment

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.

StageDateAmountNotes
Quote sent3 Mar24,000Revised once
Accepted9 Mar22,000After discount
Delivered30 Mar-Two revisions
Invoiced31 Mar22,000Net 15
Paid24 Apr22,0009 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports