Ledgerlight Studio
Clean, UK-ready templates that do the boring bits for you

How to Track Freelance Invoices and Payments in the UK

Updated 2026-11-09

Why tracking invoices matters for UK freelancers

Keeping a clear record of every invoice you send does more than just help you get paid on time. It gives you a single source of truth for:

Choose the right tool: a spreadsheet works

A spreadsheet is a flexible, low-cost way to organise invoice data. While a spreadsheet alone is not MTD-compatible software, it can sit alongside any bridging solution you might need for the MTD deadline. The key is to set it up once and then use it consistently.

Step-by-step: recording each invoice

  1. Create a master sheet - label columns for:
  2. Invoice number
  3. Client name
  4. Date issued
  5. Due date
  6. Amount (£)
  7. Status (Sent, Paid, Overdue)
  8. Payment received date
  9. Notes (e.g., late-fee applied)
  10. Enter the invoice as soon as you send it - filling in the date issued and due date prevents later guesswork.
  11. Assign a unique reference - a simple numbering system (e.g., INV-2024-001) makes it easy to locate an invoice when you need to follow up.
  12. Link to your bank - if you use a separate column for the payment reference, you can match incoming payments to the correct invoice quickly.

Step-by-step: monitoring due dates and reminders

  1. Add a conditional format - colour-code the "Due date" column so that dates within 3 days appear amber and overdue dates appear red.
  2. Set up a reminder column - use a formula such as =IF(TODAY()>[Due date],"Send reminder","") to flag invoices that need action.
  3. Schedule a weekly review - block 15 minutes each Monday to filter the sheet for any rows marked "Send reminder" and email the client.
  4. Record the reminder - add a note with the date you sent the reminder; this creates a paper trail should you need to claim a late-fee later.

Linking your records to tax deadlines

The UK tax year runs from 6 April to 5 April the following year. check GOV.UK for the current rules. Your total invoice income for the year feeds into the Self Assessment (SA) return, which must be filed online by 31 January after the end of the tax year. check GOV.UK for the current rules.

If your qualifying income from self-employment exceeds £50,000 in the 2024-25 tax year, you will need to start using MTD from 6 April 2026. The threshold drops to £30,000 for 2025-26 (MTD from 6 April 2027) and £20,000 for 2026-27 (MTD from 6 April 2028). check GOV.UK for the current rules. While a spreadsheet alone does not meet the MTD requirement, you can export the data to a compatible software package when the deadline approaches.

FAQ

Q1: Do I need to track every tiny invoice? A: Yes. HMRC expects you to keep records of all income, and a complete invoice log makes the Self Assessment process smoother.

Q2: Can I use a free spreadsheet programme? A: Absolutely. Google Sheets, Microsoft Excel Online or LibreOffice Calc all support the formulas and formatting described above.

Q3: What if I'm already using accounting software? A: The spreadsheet can act as a backup or a quick-look view. You can also import the CSV export from most accounting packages into the sheet.

Q4: How often should I reconcile my spreadsheet with my bank? A: At least once a month, ideally when you receive your bank statement, to ensure all payments are correctly recorded.

Save time with a ready-made tracker

If you prefer not to build the sheet from scratch, the Freelance Invoice & Payment Reminder Tracker is a pre-designed spreadsheet that follows the structure outlined above. For a one-off price of £9 it saves you the setup time and includes colour-coded alerts, a built-in reminder flag and a summary tab that totals your income for the tax year. It's an optional shortcut for anyone who wants a tidy, ready-to-use solution.

Want the shortcut? The ready-made template does this for you.

See the template