Invoice Tracker Spreadsheet (Paid, Due & Overdue)
Original price was: £4.49.£3.59Current price is: £3.59.
See who owes you, what is overdue and what has been paid at a glance. Status and days late update automatically.
- Instant download after checkout
- One-off payment — no subscription
- Card, Apple Pay & Google Pay — secure checkout
- Works in Excel, Google Sheets & Apple Numbers
Description
Late payments hurt cash flow most when you lose track of them. Log each invoice once and this tracker shows its status every day: due, part paid, overdue or paid, with the overdue total front and centre.
What’s inside
- 500 invoice rows with client, dates, terms and amounts
- Status worked out from today’s date
- Colour coding: red overdue, amber part paid, green paid
- Invoiced, paid, outstanding and overdue totals
Who it’s for
Freelancers and small businesses sending more than a handful of invoices a month.
A worked example
You send invoice 041 for £1,200 on 1 October on 14-day terms, so it falls due on 15 October and shows as due. On 16 October it turns red and joins the overdue total. When £600 arrives, record the payment and it turns amber as part paid, with £600 still outstanding.
The figure to watch is the overdue total at the top. If it grows month after month, your terms or your chasing need tightening.
Questions before you buy
Is this the same as bookkeeping?
No. It tracks what clients owe you. For profit and your tax return, pair it with a cash book or expense tracker.
When should I chase?
The day after the due date. A short, friendly reminder that day gets paid far more often than one sent weeks later.
Can I add interest?
For business clients, yes. The Late Payment Interest Calculator works out statutory interest and compensation for each overdue invoice.
What you get
- .xlsx file with live formulas: opens in Microsoft Excel (Windows and Mac), Google Sheets and Apple Numbers
- Print-ready A4 PDF preview
- How to use tab and README with step-by-step instructions
- Figures checked against GOV.UK and HMRC guidance (October 2026)
A tool to keep you organised, not tax or legal advice. Rules and rates can change, so check gov.uk or ask an accountant if unsure.



