How to Track Jobs and VAT-Ready Quotes for UK Tradespeople

Updated 2026-11-08

1. Why a clear tracking system matters for small-scale tradespeople

Running a cleaning, decorating, tutoring or dog-walking business often means juggling quotes, job notes and invoices manually. Without a single source of truth you can: - Lose track of which quote turned into a paid job. - Miss deadlines for tax returns or VAT records. - Spend extra time reconciling bank statements. A structured spreadsheet can bring everything together in one place, reducing errors and freeing up time for the work you love.

2. Core elements to include in your job-tracking sheet

A practical sheet should capture three main areas: 1. Quote details - client name, service description, quoted amount (including VAT if you're VAT-registered), date issued and expiry. 2. Job progress - start date, key milestones, notes on work completed, any additional charges. 3. Payment status - invoice number, date sent, amount received, outstanding balance.

These columns give you a quick overview of the pipeline from prospect to paid invoice.

3. Setting up the spreadsheet - step by step

Create three tabs - Quotes, Jobs and Payments. This keeps data tidy and makes it easier to use lookup formulas.
Add consistent headings - use the same client reference across all tabs so you can link records with simple VLOOKUP or XLOOKUP functions.
Include a VAT column - if you are VAT-registered, calculate VAT at the appropriate rate (check GOV.UK for the current rules). Use a formula like =QuotedAmount*0.20 for 20% VAT, but adjust if the rate changes.
Set up conditional formatting - highlight rows where the payment status is "Overdue" in red, and "Paid" in green. This visual cue helps you spot issues at a glance.
Add a summary dashboard - use pivot tables or SUMIF formulas to show total quoted value, total invoiced, and total outstanding each month.
Back-up regularly - store a copy on a cloud service and keep a local backup. This protects you against data loss.

4. Linking quotes to invoices and payments

When a quote is accepted, copy the reference to the Jobs tab and create an invoice entry in the Payments tab. Use the spreadsheet's lookup functions to pull the quoted amount and VAT automatically, reducing manual entry errors.

5. Staying on top of tax obligations

Tax year runs from 6 April to 5 April (check GOV.UK for the current rules). Your profit figures from the Payments tab feed into your Self Assessment return.
Self Assessment deadline - the online return and any tax due must be filed by 31 January after the end of the tax year (check GOV.UK for the current rules).
Making Tax Digital (MTD) for Income Tax - if your qualifying self-employment or property income exceeds £50,000 in the 2024-25 tax year, you will need to use HMRC-compatible software from 6 April 2026 (check GOV.UK for the current rules). A spreadsheet alone does not meet the MTD software requirement, but it can be used alongside bridging software. Keeping accurate records throughout the year makes completing your tax return far less stressful.

6. Practical tips for day-to-day use

Update daily - enter new quotes as soon as they are sent and mark payments when they hit the bank.
Review weekly - glance at the dashboard to see any overdue invoices and follow up promptly.
Archive completed jobs - move rows to an "Archive" tab after a job is fully paid and the tax year is closed. This keeps the active sheet fast.

FAQ

Q: Do I need separate software for VAT if I'm VAT-registered? A: HMRC requires you to keep digital records of VAT-related transactions. A spreadsheet can form part of your record-keeping, but you must ensure it meets the digital record standards (check GOV.UK for the current rules).

Q: How often should I back-up my spreadsheet? A: Regular backups - at least once a week - are advisable to protect against accidental loss.

Q: Can I use this sheet if I'm not VAT-registered? A: Yes. Simply omit the VAT column or set the rate to 0%.

7. Using a ready-made template to save time

If building a spreadsheet from scratch feels daunting, a pre-designed Trade Quote & Job Tracker (UK VAT Ready) template can give you a fully structured file in minutes. It includes the three tabs, built-in VAT formulas and a dashboard, letting you focus on your work rather than spreadsheet set-up. Priced at £9, it's a low-cost shortcut for anyone who wants a polished, ready-to-use solution.