Freelancer Client-Ops Spreadsheet: Invoice, Expense and UK Tax Tracker (2026–27)

Stop wondering who owes you money.

This is the operating system for your freelance finances. One spreadsheet that tracks your clients, invoices, expenses and UK tax set-aside, with the arithmetic done for you.

What it does

• Dashboard. Total invoiced, received, outstanding and overdue at a glance, plus a live tax set-aside figure.
• Invoices. Due dates calculate themselves from each client's payment terms. Overdue days tick up automatically. Anything due within 7 days gets flagged amber.
• Expenses. Category dropdowns and a receipt tracker, so January does not hurt.
• Tax Summary (UK 2026–27). Cash-basis profit and an illustrative 20% set-aside, with a quarterly breakdown and payment-on-account dates.
• Clients. Your rate card and payment terms in one place, feeding the invoice automation.

Also included

• An 11-page quick-start guide: 15-minute setup, the invoicing workflow, three numbers worth knowing (debtor days, client concentration, effective day rate), three copy-paste chase emails, what UK late-payment law actually gives you, the quarter-end routine and the weekly five-minute check.
• Works in Excel and Google Sheets.
• Free updates. Buyers get new versions by email.

Who it is for: UK freelancers, contractors and sole traders who want to stop running their business from memory.

Who it is not for: limited companies needing full statutory accounts, or anyone wanting automated bank feeds. This is a tracker, not accounting software.

No income promises. No HMRC-approved claims. Just arithmetic.

FAQ

Is this accounting software?

No. It is a well-built spreadsheet tracker. It will not file your tax return, but it will make that job (or your accountant's) much easier.

Does it work in Google Sheets?

Yes. Upload the .xlsx to Google Drive and open with Sheets. Every formula is supported in both.

What if tax rules change?

The 20% set-aside is illustrative, not advice. Buyers get updated versions free if the workbook changes.

Can I get a refund?

Digital products cannot be returned once downloaded. If the file is broken or not as described, reply to your receipt email and we will make it right.