Back to templates
Finance & Invoicing
Professional Invoice Tracker for Excel
An all-in-one Excel workbook that helps UK small businesses stay on top of every invoice they send. Log invoices, watch payment status update automatically, and get a real-time dashboard of income, VAT owed and outstanding balances — without any accounting software.
One-time payment
£10
What's included
- Live dashboard showing income, outstanding and overdue totals
- Automatic VAT (20%) calculation on every line
- Colour-coded status: Paid, Pending, Overdue
- Client and invoice number tracking with sortable filters
- Matching printable invoice template with your branding
- Works offline in Excel — no cloud subscription required
Perfect for
- Freelancers and consultants tracking multiple clients
- Tradespeople managing weekly invoicing and VAT
- Small agencies replacing spreadsheets with one clean system
Frequently asked questions
Do I need Excel?
Yes — the tracker uses Excel formulas. It also opens in Google Sheets, though some formatting may differ.
Can I customise the VAT rate?
Yes. The VAT cell is editable so you can switch to 0%, 5% or a custom rate.