How to Build a Simple Invoice Tracking Spreadsheet

A practical guide to setting up a simple invoice tracking spreadsheet so you can see what is due, what is late and what has been paid without creating extra admin.

By Thomas Reed · Published 9 October 2026 · Updated 9 October 2026 · 10 min read

A simple invoice tracking spreadsheet will not run your finances for you, but it can give you a clear working record of what you have billed, what is still outstanding and what needs chasing. If you invoice irregularly, work with a modest number of clients or want a tidy record before moving to accounting software, a well-structured sheet can be a practical place to start.

The aim is not to build a perfect finance system. Our suggested practical approach is to create a reliable record that helps you avoid missed payments, reduce duplicated follow-up and keep your invoicing organised enough that you can make decisions with confidence.

Why a simple invoice tracking spreadsheet helps

When invoices are scattered across emails, bank statements and paper notes, it is easy to lose track of what you sent and when payment was due. That usually creates three problems:

• you forget to follow up on overdue invoices;
• you cannot quickly see which clients are paying on time;
• your records are harder to reconcile with the bank.

A spreadsheet addresses that by giving you one sortable list. You can scan it quickly, filter by client or status, and spot late payments before they become routine.

For UK businesses, there are also legal record-keeping and invoicing points to bear in mind. GOV.UK explains that if you sell a product or service in a business-to-business transaction where both you and the customer are registered for VAT, you need to give the customer an invoice by law. It also says the invoice must include certain information, including how much the customer needs to pay and when the customer must pay it: https://www.gov.uk/invoicing-and-taking-payment-from-customers.

What to include before you start

Before you open Excel, Google Sheets or another spreadsheet app, decide what information you will record for each invoice. Keep the list tight. If you add too many fields at the outset, the sheet becomes harder to maintain and people stop updating it properly.

Core fields to include

That list is enough for most small businesses. You can add extra fields later, such as purchase order number, payment method or project reference, but start with the information you will actually use.

Choose the simplest structure first

The simplest workable structure is usually the best place to begin:

• one tab for live invoices;
• one optional tab for archive or paid invoices.

If you only have a few invoices a month, you may not need a separate archive at first. But once the live sheet starts to feel crowded, moving paid invoices into an archive tab keeps the active list easier to read.

A live tab should contain invoices you still need to monitor. The archive tab can hold invoices that have been paid, cancelled or written off, with a clear status so you can trace what happened later if needed.

Set up the columns in a clear order

Put the most useful columns near the left so you can scan them quickly. A practical order is:

1. Invoice number
2. Client name
3. Issue date
4. Due date
5. Amount
6. VAT
7. Status
8. Paid date
9. Notes

This layout makes it easier to sort by due date, status and client name. It also keeps the key dates together, which matters when you are reviewing overdue payments or checking whether an invoice has slipped through the net.

Practical setup tips

• Freeze the top row so headers stay visible when you scroll.
• Use one row per invoice, with no merged cells.
• Format dates consistently.
• Keep number formats consistent for currency and VAT.

Use drop-down status options

Free-text status entries create avoidable confusion. One person types “paid”, another types “Paid today”, and soon filtering becomes unreliable. A drop-down list keeps entries consistent.

Use a short list such as:

• draft
• sent
• overdue
• paid
• part-paid

If you also cancel invoices occasionally, you can add “cancelled” as a separate status. The key is to keep the list small enough that everyone using the sheet understands it at a glance.

How to use the statuses

• draft — invoice prepared but not yet issued;
• sent — invoice issued and waiting for payment;
• overdue — due date has passed and no full payment has been received;
• paid — settled in full;
• part-paid — some money received, but balance remains outstanding.

Add formulas for totals, ageing and overdue flags

Formulas are what turn a list into a working tool. You do not need anything elaborate. A few basic calculations will usually be enough to save time and improve visibility.

Useful formulas to include

• Invoice total — if you track net and VAT separately, calculate the full amount due.
• Ageing — calculate how many days have passed since the issue date or due date.
• Overdue flag — show whether the invoice is late.

An ageing column helps you sort by how long invoices have been outstanding. For example, if the due date is in the past and the status is not paid, the invoice can be flagged as overdue. That makes it easier to prioritise reminders instead of checking each row manually.

Illustrative example: if an invoice was due last Friday and the status still says “sent”, your overdue flag can highlight it automatically. You then know it needs a reminder rather than another routine review.

Use conditional formatting to highlight problems

Conditional formatting means the spreadsheet changes colour or style when a rule is met. Used well, it lets late or unpaid invoices stand out immediately without you having to read every cell.

Simple rules worth using

• highlight invoices past their due date and not marked paid;
• highlight part-paid invoices in a different colour;
• use a calm neutral colour for paid invoices;
• optionally highlight invoices due soon so you can prepare reminders.

Keep the colour scheme restrained. Too many colours make the sheet harder to read, not easier. One clear warning colour for overdue items and one softer colour for paid items is usually enough.

Decide how to handle part-payments, credit notes and cancellations

This is where a simple sheet can become messy if you do not decide the rules in advance. The aim is to record exceptions without breaking your main tracking method.

Part-payments

If a client pays part of an invoice, record the amount received and update the status to part-paid. You can either add a separate column for the amount paid or keep the original invoice total and write the part-payment in notes. A separate paid amount column is usually easier to manage if part-payments happen often.

Credit notes

If you issue a credit note, do not overwrite the original invoice amount without a trace. Keep a note of the credit note reference and the amount adjusted. That way you can still see what was originally billed and why the balance changed.

Cancellations

If an invoice is cancelled before payment, mark it clearly as cancelled rather than deleting the row. Deleting records can make later reconciliation harder and may leave gaps in your invoice numbering.

A simple rule of thumb

Keep the original invoice row intact wherever possible. Add fields or notes to explain what changed, rather than replacing the original record with a different story.

Build a weekly review routine

A spreadsheet only helps if you keep it current. Our suggested practical approach is to set a weekly routine so updating it becomes part of your normal finance process rather than a task you delay until month-end.

A practical weekly checklist

• check which invoices are due or overdue;
• send reminders for late invoices;
• update statuses after payments arrive;
• reconcile payments against bank records;
• move paid invoices to the archive tab if you use one;
• note any disputes, part-payments or promised payment dates.

Reconciliation simply means checking the spreadsheet against your bank account so the records match the money received. This is where a tidy invoice sheet pays off: you can confirm whether a payment relates to the correct invoice instead of guessing from a bank reference.

Useful habit: review the sheet at the same time each week. If you handle it on the same day as your bank check, you are less likely to let old invoices drift for another week.

Keep the spreadsheet manageable

A good invoice tracker should make your work easier, not become another file you dread opening. A few practical controls will stop it drifting into chaos.

Version control

If more than one person may edit the sheet, agree how you will avoid conflicting versions. Use one master file rather than emailing copies back and forth. If you need to make a major change, save a dated version first so you can return to it if needed.

Backups

Back up the file regularly. Cloud storage can help, but you should still know where the most recent usable copy is kept.

Access permissions

Limit edit access to the people who actually need it. If everyone can change formulas or delete rows, errors become more likely. A small team may only need one person responsible for updates, with others able to view the sheet if necessary.

When to move to accounting software

A spreadsheet is often fine while your invoice volume is manageable and your payment process is relatively simple. You should think about accounting software when:

• you are issuing more invoices than the sheet can comfortably handle;
• you need automated reminders or payment links;
• you want tighter links between invoicing, VAT and bookkeeping;
• more than one person needs to work on the records at the same time;
• you spend too much time maintaining the sheet instead of using it.

GOV.UK also sets out responsibilities for company records if you run a limited company, and says directors are responsible for keeping company records even if day-to-day tasks are delegated: https://www.gov.uk/running-a-limited-company. That makes accurate, accessible invoice records part of sensible day-to-day control, not just admin.

Example: a simple setup for a small service business

Suppose you run a small consultancy and invoice a handful of clients each month. Your live tab might include the invoice number, client name, issue date, due date, amount, VAT, status, paid date and notes. You set a drop-down status list, add a formula that flags overdue invoices and use conditional formatting to highlight any row where the due date has passed and the status is still sent.

On Friday morning, you open the sheet, review the overdue rows, send reminders and check your bank statement against the paid invoices. At the end of the month, you move all paid rows into the archive tab. You now have a live working list that stays readable without becoming overcomplicated.

Key takeaways

• Start with one live tab and, if needed, one archive tab.
• Keep the columns in a fixed order so you can sort and filter easily.
• Use drop-down statuses to avoid inconsistent entries.
• Add only the formulas you will actually use.
• Use conditional formatting to make overdue invoices visible at a glance.
• Agree rules for part-payments, credit notes and cancellations before they happen.
• Review the sheet weekly and reconcile it against bank records.
• Move to accounting software when the spreadsheet starts creating more work than it saves.

FAQs

Do I need a separate sheet for each client?

Usually not. A single master sheet is easier to search, sort and maintain. You can always filter by client name when needed.

Should I record net and VAT separately?

If VAT matters for your business, keeping net and VAT separate is often useful. If your invoicing is very simple, you may still be able to work with one total and a VAT column, but choose a format you can keep up to date.

What is the most important field?

Due date and status are usually the most useful for chasing payments. Without them, the sheet does not tell you what needs attention next.

Can I delete old paid invoices?

It is better to archive them than delete them. Keeping a record helps with questions later and makes your numbering sequence easier to follow.

Sources and further reading

• GOV.UK: Invoicing and taking payment from customers
• GOV.UK: Running a limited company

Next step: open a blank spreadsheet and build the header row first, then add the status drop-down and one overdue rule before you enter your first invoice.