Why three places become a problem
Most small businesses start with whatever is to hand. Enquiries arrive in someone's inbox. Quotes are Word or Excel files saved in a shared folder. Invoices come from the accounting package. Each tool works on its own.
The trouble is the hand-offs. A price agreed in an email is typed into a quote. The quote is typed into an invoice. If the job changed along the way, someone has to remember. Every re-type is a chance to drop a line, use last year's rate or pick the wrong VAT rate.
The other cost is visibility. When the enquiry, the quote and the invoice live in different places, nobody can answer simple questions without digging. Which quotes are waiting for a reply? Which finished jobs haven't been billed? Who owes us money and when did we last chase them?
This guide sets out a simple way to keep the whole journey on one record. It works whether you use a CRM, an accounting package or a well-kept spreadsheet.
The principle: one customer, one trail
The idea is simple. Every enquiry, quote, order and invoice should hang off the same customer record and link to each other. You should be able to start at any document and walk forwards or backwards through the job.
That gives you three things:
- No re-keying. Each document is created from the one before it, so lines and prices carry across.
- One history. Anyone picking up the customer sees what was asked, what was quoted and what was billed.
- Clear gaps. A won quote with no invoice, or an invoice with no payment, stands out.
Step 1: log every enquiry as a lead
A lead is an enquiry you might turn into work. Log it the day it arrives, even if it looks small. Give it four things:
- The customer. Find them first. Only create a new record if they're genuinely new, to avoid duplicates.
- A rough value. A guess is fine. It lets you see what's at stake.
- An owner. One named person, not "the team".
- A next step with a date. "Call Tuesday to arrange a site visit" is a next step. "Follow up" is not. A lead without a dated next step is the one that goes quiet. If you only adopt one habit from this guide, make it this one.
Step 2: quote from the lead, not from a blank page
When you're ready to price the work, start the quote from the lead. The customer, contact and job are already known, so you're only adding lines.
Some habits that save trouble later:
- Use a product or price list for things you sell often, so the same item has the same price on every quote.
- Write service lines in plain words. The customer should understand each line without a phone call.
- Show VAT clearly if you're VAT-registered: the net amount, the VAT and the total.
- Set a valid-until date. Material prices move. A quote that lasts for ever is a risk.
- Number every quote in its own sequence, so you can refer to "Q-0118" without confusion.
If the customer asks for a change, issue a revised quote rather than overwriting the one they already have. You want to be able to see what was sent, and when.
Step 3: treat "won" as a trigger
The moment a customer says yes is when most re-typing happens. Make "won" do the work instead.
When a quote is accepted:
1. Mark it as won, so it leaves your list of open quotes.
2. Create the order or job from the quote, carrying every line across.
3. Confirm to the customer in writing what you've agreed to do and for how much.
When a quote is lost, record why. Price, timing and "went with someone else" are the usual reasons. Over a few months, the reasons tell you more than the win rate does.
Step 4: invoice from the order
When the work is done, raise the invoice from the order. The lines, prices and customer details should copy across. Only change what actually changed on the job.
Before you send it, check the things that cause disputes:
- the customer's legal name and billing address
- the description of each line
- the VAT rate on each line, if you're registered
- the payment terms and the due date
- how to pay you
If you've agreed a deposit or stage payments, record each one against the invoice as it arrives. The balance should always be visible without a calculator.
Step 5: link payments back to the invoice
An invoice isn't finished until it's paid. Whoever records payments, whether in the CRM or in your accounting software, should make sure the invoice shows as paid in the place your team looks.
This matters more than it sounds. If sales can't see that a customer has paid, they may chase a customer who settled last week. That's an awkward call and an easy one to avoid.
If you correct an invoice after it's sent, raise a credit note rather than editing the original. Your records and the customer's copy then still agree.
Step 6: check the numbers regularly
With everything on one trail, a regular check takes minutes. Ask four questions:
1. Which leads have no next step, or an overdue one?
2. Which quotes have been out for more than a week without a reply?
3. Which won jobs are finished but not yet invoiced?
4. Which invoices are overdue, and when were they last chased?
Each answer should be a filtered list, not an afternoon of digging. If it takes longer than that, the trail has a gap. Find where documents are being created outside the system and close it.
Doing this with software
You can run this method with spreadsheets if you're disciplined about links and numbering. It gets harder as the team grows, because each person keeps their own copy.
A CRM that includes quoting and invoicing does the linking for you. Beagle CRM is one option, built for UK small businesses: you can see [how quotes, orders and invoices share one record in Beagle](/quotes-invoices-and-crm).
Whatever you choose, test it against the six steps above. Can you start a quote from a lead? Does a won quote become an order without re-typing? Does the invoice carry the lines across? Can everyone see what's been paid? If the answer to each is yes, you've got one trail.
A short checklist
- Every enquiry is a lead with an owner, a value and a dated next step.
- Quotes start from the lead and are numbered, dated and revised, not overwritten.
- Won quotes become orders without re-typing. Lost quotes record a reason.
- Invoices are raised from orders, with VAT and terms checked before sending.
- Payments and credit notes are recorded against the invoice.
- A weekly check covers stale leads, unanswered quotes, unbilled work and overdue invoices.