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.