Invoice template spreadsheet UK: Excel and Google Sheets with a payment tracker
An invoice template spreadsheet (or UK invoice template Excel / Google Sheets file with an invoice tracker) is the working workbook where you raise invoices, pick clients from a list, set VAT, and log paid, due and overdue amounts. This UK guide compares a spreadsheet to a PDF-only invoice and to full accounting software, shows the sheets that match a ready Invoice / Invoice log / Summary layout, covers Excel vs Sheets, and includes a free DIY method. Sample rows below are made-up. It is not legal, tax or financial advice. For the statutory fields every UK invoice must show, use our what to include on a UK invoice guide first — this page is about the spreadsheet/template workflow, not the legal wording rules.
Spreadsheet vs PDF-only vs accounting software
UK searches for "invoice template" mix three different jobs. Use the right tool:
| What | Job | Typical format |
|---|---|---|
| Invoice template spreadsheet | Raise invoices, reuse client details, track paid / due / overdue, print or save as PDF | Excel or Google Sheets (working file) |
| PDF-only / Word invoice | One-off nice-looking PDF; weak for a running log of many invoices | PDF, Word or Google Docs |
| Accounting software | Bank feeds, automated filing, multi-user bookkeeping; overkill if you only need invoices + a log | Cloud subscription (Xero, FreeAgent, QuickBooks, etc.) |
A spreadsheet sits in the middle: reusable like software for invoices and chasing, without a monthly fee. Day-to-day income and expense books are a separate job — see our sole trader bookkeeping spreadsheet UK guide and the UK Sole Trader Bookkeeping & Self Assessment Tracker (£6.95).
What sheets a UK invoice template spreadsheet needs
A practical layout matches the same shape as the UK Invoice Template & Tracker (£4.95):
- Invoice: your business details, client picked from a drop-down (address and payment terms fill in), up to 12 line items, subtotal, VAT and total due, bank details, payment reference, due date and a late-payment note.
- VAT options: 20%, 5% or 0%, or "Not VAT registered" so non-registered sole traders are not forced into VAT lines.
- Invoice log: every invoice with status (paid, due within 7 days, OVERDUE), days late and tax year.
- Summary: outstanding, overdue, paid this tax year, average days to pay and totals by client.
- Clients list and My Details settings so you type your bank and address once.
- Start Here guide tab.
For what must appear on the face of the invoice itself (unique number, names, addresses, supply date, amounts, VAT where relevant), follow what to include on a UK invoice — that guide cites GOV.UK; this page only describes the spreadsheet structure.
Excel vs Google Sheets for invoices
| Need | Excel (.xlsx) | Google Sheets |
|---|---|---|
| Working offline / weak Wi-Fi | Strong | Needs a connection (or offline mode set up first) |
| Sharing with a bookkeeper | OneDrive / email copies | Share a link; both edit live |
| Client drop-down | Data Validation → List | Data → Data validation → Dropdown |
| Print or PDF for the client | File → Print / Save as PDF | File → Download → PDF or Print |
| UK £ and DD/MM/YYYY | Format cells / regional settings | File → Settings → Locale: United Kingdom |
A common UK workflow is to build in Excel, then upload the .xlsx to Google Drive so you can edit on a phone. The UK Invoice Template & Tracker (£4.95) ships as .xlsx for that reason.
Example invoice log rows (made-up)
The rows below are a made-up example for an imaginary sole trader. They are illustrative only — not real clients, amounts or advice.
| Invoice no. (example) | Client (example) | Date (example) | Total £ (example) | Status (example) |
|---|---|---|---|---|
| INV-2026-0012 | Example Client A | 12 May 2026 | 450.00 | Paid |
| INV-2026-0013 | Example Client B | 3 Jun 2026 | 280.00 | Due within 7 days |
| INV-2026-0014 | Example Client C | 20 May 2026 | 120.00 | OVERDUE |
In a real file, OVERDUE rows and days-late figures help you chase politely before you escalate — see the late-payment section on what to include on a UK invoice for the GOV.UK interest and recovery-cost rules (this page does not repeat them).
How to make an invoice template spreadsheet yourself (free DIY)
- Sheet 1 — My Details: your name / trading name, address, email, bank sort code and account, payment terms default, VAT registration status.
- Sheet 2 — Clients: client name, address, default payment terms. Name this list for a drop-down.
- Sheet 3 — Invoice: invoice number, date, supply date, client (data-validated), line description / qty / unit price, subtotal, VAT rate choice, VAT amount, total due, due date, bank details pulled from My Details. Print or export PDF for the client.
- Sheet 4 — Invoice log: copy each sent invoice number, client, date, total, due date; status = IF paid date filled "Paid", ELSE IF due date − TODAY() ≤ 7 "Due within 7 days", ELSE IF overdue "OVERDUE".
- Sheet 5 — Summary: SUMIF / COUNTIF for outstanding, overdue, paid this tax year (6 April–5 April).
- Keep a copy of every PDF you send, and log the payment date when money lands (cash basis).
Prefer not to build the drop-downs, VAT options and overdue formulas yourself? The UK Invoice Template & Tracker (£4.95) already includes Invoice, Invoice log, Summary, Clients, My Details and Start Here for UK sole traders and freelancers.
DIY vs ready template vs sole-trader bookkeeping tracker
- DIY (free): the steps above in a blank Excel workbook or Google Sheet. Best if you enjoy formulas and only send a few invoices a month.
- Ready invoice template & tracker: the UK Invoice Template & Tracker (£4.95) (£4.95) when you want Invoice + log + Summary + client drop-down and VAT options already set up.
- Bookkeeping tracker: the UK Sole Trader Bookkeeping & Self Assessment Tracker (£6.95) for income, expenses and mileage by tax year — pair it with invoices so paid amounts land in the books. See sole trader bookkeeping spreadsheet UK.
- January filing: deadlines and payments on account live on the Self Assessment 31 January checklist, not on this page.
What is (and is not) in the UK Invoice Template & Tracker
- Included in the UK Invoice Template & Tracker (£4.95): Invoice sheet (business details, client drop-down with address and payment terms, up to 12 lines, subtotal, VAT and total due); VAT optional at 20%, 5% or 0%, or Not VAT registered; bank details, payment reference, due date and late-payment note; Invoice log with status (paid, due within 7 days, OVERDUE), days late and tax year; Summary (outstanding, overdue, paid this tax year, average days to pay, totals by client); Clients list; My Details; Start Here guide. Excel .xlsx / Google Sheets upload. UK edition (£ GBP, DD/MM/YYYY). Digital download for personal use or use within your own organisation. AI-assisted with an original brief.
- Not included: it is not legal, tax or financial advice. Nothing physical is posted. Please do not resell or share the file. It does not file Self Assessment, connect to HMRC, or replace accounting software. For statutory invoice fields, use what to include on a UK invoice. For income and expense columns, use the UK Sole Trader Bookkeeping & Self Assessment Tracker (£6.95) / bookkeeping guide.
More: what to include on a UK invoice · sole trader bookkeeping spreadsheet UK · Self Assessment 31 January checklist · event budget and VAT calculator
Free tools for this
Frequently asked questions
What is an invoice template spreadsheet?
A working Excel or Google Sheets workbook where you create invoices (often with a client drop-down and VAT options), print or save them as PDF, and keep an invoice log of paid, due and overdue amounts. It is different from a one-off PDF or Word invoice and from full accounting software.
Is an invoice spreadsheet the same as accounting software?
No. A spreadsheet helps you raise invoices and track who has paid. Accounting software usually adds bank feeds, automated categorisation and sometimes filing links. Many UK sole traders start with a spreadsheet and only move to software when volume or Making Tax Digital rules require it — check GOV.UK for MTD eligibility.
Can I make a UK invoice template in Excel or Google Sheets?
Yes. Use My Details and Clients sheets, an Invoice sheet with a data-validated client drop-down and VAT rate choice, an Invoice log with paid/due/OVERDUE status, and a Summary of outstanding totals. Or start from a ready UK template such as our UK Invoice Template & Tracker.
What VAT options should a UK invoice spreadsheet have?
If you are VAT-registered, support the rates you actually use (commonly 20% standard, sometimes 5% reduced, and 0%). If you are not registered, a clear "Not VAT registered" option avoids fake VAT lines. Only VAT-registered businesses can issue VAT invoices — see our what to include on a UK invoice guide.
How do I track unpaid invoices in a spreadsheet?
Keep an Invoice log with invoice number, client, date, total, due date and a status column (paid when a paid date is entered; due within 7 days; OVERDUE when past due). A Summary sheet can total outstanding and overdue with SUMIF. Chase politely before escalating.
DIY invoice spreadsheet or a ready template?
DIY suits you if you are happy building drop-downs, VAT formulas and overdue status. A ready template such as our UK Invoice Template & Tracker (£4.95) suits you if you want Invoice, log, Summary, Clients and My Details already set up for Excel and Google Sheets.
How does an invoice template pair with sole trader bookkeeping?
Raise and chase invoices in the invoice workbook; when payment lands (cash basis), add an income row in your bookkeeping spreadsheet with the invoice number. Our sole trader bookkeeping spreadsheet UK guide shows the income columns; product 14 is a ready tracker.
What is included in the UK Invoice Template & Tracker?
Invoice sheet with client drop-down, up to 12 lines, VAT options 20%/5%/0%/Not VAT registered, bank details and due date; Invoice log with paid/due/OVERDUE status; Summary; Clients; My Details; Start Here. Excel .xlsx for Google Sheets upload. UK edition in £ with DD/MM/YYYY. Digital download; not legal, tax or financial advice; nothing is posted.
Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.