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:

WhatJobTypical format
Invoice template spreadsheetRaise invoices, reuse client details, track paid / due / overdue, print or save as PDFExcel or Google Sheets (working file)
PDF-only / Word invoiceOne-off nice-looking PDF; weak for a running log of many invoicesPDF, Word or Google Docs
Accounting softwareBank feeds, automated filing, multi-user bookkeeping; overkill if you only need invoices + a logCloud 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):

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

NeedExcel (.xlsx)Google Sheets
Working offline / weak Wi-FiStrongNeeds a connection (or offline mode set up first)
Sharing with a bookkeeperOneDrive / email copiesShare a link; both edit live
Client drop-downData Validation → ListData → Data validation → Dropdown
Print or PDF for the clientFile → Print / Save as PDFFile → Download → PDF or Print
UK £ and DD/MM/YYYYFormat cells / regional settingsFile → 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-0012Example Client A12 May 2026450.00Paid
INV-2026-0013Example Client B3 Jun 2026280.00Due within 7 days
INV-2026-0014Example Client C20 May 2026120.00OVERDUE

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)

  1. Sheet 1 — My Details: your name / trading name, address, email, bank sort code and account, payment terms default, VAT registration status.
  2. Sheet 2 — Clients: client name, address, default payment terms. Name this list for a drop-down.
  3. 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.
  4. 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".
  5. Sheet 5 — Summary: SUMIF / COUNTIF for outstanding, overdue, paid this tax year (6 April–5 April).
  6. 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

What is (and is not) in the UK Invoice Template & Tracker

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.