Late payments disrupt cash flow more often than weak sales. An invoice and payment tracker gives you one place to see what you issued, what is due, and what still needs a polite follow-up — without pretending the spreadsheet sends invoices or collects money on its own.
This guide covers the fields worth tracking and a practical workflow for staying on top of customer balances.
Fields for an invoice and payment tracker
| Field | Purpose |
|---|---|
| Invoice number | Unique ID matching your accounting or invoicing tool |
| Customer / client | Who owes the balance |
| Invoice date | When you issued the invoice |
| Due date | When payment is expected under your terms |
| Amount | Total invoiced |
| Paid amount | Sum of payments received |
| Balance | Amount − paid (usually a formula) |
| Status | Draft, sent, paid, partial, overdue |
| Payment date | When money arrived — blank until paid |
| Notes | PO numbers, reminders sent, disputes |
How this differs from invoicing software
Invoicing tools create PDFs, send emails and sometimes accept card payments. A tracker spreadsheet records the outcome: what you sent and whether it was paid. You might use both — software to issue, spreadsheet to monitor — or issue invoices manually and log them here.
Do not claim a static spreadsheet “sends reminders” unless you have connected automation elsewhere. The value is organised follow-up, not delivery mechanics.
Statuses that keep the list actionable
Use a small set of statuses everyone understands: sent (awaiting payment), partial (some paid), paid (closed), overdue (past due date with balance remaining). Review overdue rows weekly.
When a partial payment arrives, update paid amount and leave status as partial until the balance is zero. Closing too early hides outstanding debt.
Overdue follow-up organisation
- Sort by due date to see the oldest unpaid invoices first
- Note the date of your last reminder in the notes column
- Agree standard payment terms upfront and reflect them in due dates
- Escalate politely — short, factual emails referencing invoice number and balance
- Hand persistent issues to your accountant or legal adviser if appropriate
Pairing with cash-flow planning
Expected payments from open invoices belong on your cash-flow view even before they land. That prevents you from committing to large expenses based on “almost paid” assumptions.
Track write-offs or bad debt separately rather than deleting rows — you may need the history for accounts or tax discussion with a professional.
Example: an Edinburgh design agency on net-30 terms
A two-person agency invoices clients on net-30 after project milestones. They issue PDF invoices from their accounting tool but maintain a spreadsheet tracker because it surfaces overdue rows faster than digging through sent folders.
Each invoice row includes client name, project code, invoice date, due date and amount. When a client pays half to unlock the next phase, status moves to Partial and the balance column shows what remains. The notes field records “Reminder sent 12 June — accounts payable on holiday until 20th”.
At month-end they sort by balance descending and see that one corporate client consistently pays at day 45 despite net-30 terms. That insight drives a conversation about deposits on future work — a business decision the tracker made visible without a collections agency.
Suggested follow-up schedule for overdue invoices
| Days overdue | Action | Notes to record |
|---|---|---|
| 1–7 | Friendly reminder email referencing invoice number | Date sent, contact name |
| 8–14 | Second reminder; offer to resend invoice or confirm receipt | Any client reply or dispute flag |
| 15–30 | Phone call or formal chaser; pause new work if terms allow | Agreed payment date if negotiated |
| 31–60 | Final written notice; consider stopping deliverables | Senior contact involved? |
| 60+ | Discuss with accountant; consider debt recovery options | Do not delete row — mark status clearly |
UK payment terms, late payment and record-keeping
There is no single legal payment term for all UK B2B contracts — you agree terms with each client and state them on the invoice. Net 14, net 30 and payment on receipt are common. Larger clients often impose their own purchase-order process; your due date column should reflect the date on the invoice, not when you hope they feel generous.
The Late Payment of Commercial Debts legislation allows statutory interest on qualifying B2B late payments in many cases. This guide does not provide legal advice; if chronic late payers threaten cash flow, speak to a solicitor or debt adviser about your options while keeping the spreadsheet history intact.
For consumer sales, different rules apply — this tracker suits B2B and invoiced trade work more than retail card checkout. If you mix both, use separate tabs so retail “paid immediately” rows do not clutter your receivables view.
Deposits, milestones and credit notes
Project businesses often invoice in stages — thirty percent on sign-off, seventy on delivery. Use one row per invoice rather than one row per project so balances stay precise. Link rows with a shared project code in the notes column; filter by that code to see total billed and total outstanding for one job.
Credit notes reduce what a client owes but should not disappear from history. Add a row with negative amount or a dedicated “Credit note” column referencing the original invoice number. Status moves toward Paid only when net balance reaches zero.
Retainers and recurring clients benefit from a “Next invoice due” column — the fifteenth of each month, for example — so you generate invoices proactively instead of discovering gaps when cash feels thin.
Weekly invoice tracker review
- Update payment dates for anything that cleared in the bank since last review
- Sort by due date and flag new overdue rows
- Send reminders for invoices crossing your first follow-up threshold
- Confirm partial payments adjusted balance and status correctly
- Add newly issued invoices the same day they are sent — not at month-end
- Cross-check open balance total against your cash-flow forecast tab