How to Track Invoices: A Practical Guide
An invoice tracker is the register of every invoice your business issues to customers, what was billed, to whom, for how much, and whether it’s been paid. Unpaid invoices are the most common reason healthy businesses run out of cash: the work was done, the invoice was sent, and then nobody followed up. The tracker makes that impossible to ignore, because every outstanding invoice sits in one visible list with its age and status.
This guide covers outgoing (sales) invoices. The tracker is a working document, updated as invoices are issued and paid, not a month-end report. Finance, sales, and management all read from the same list.
Note: invoicing requirements (what must appear on an invoice, tax treatment, payment terms) vary by jurisdiction. Check your local regulations on invoice contents and record retention.
When to Use This
Open the tracker as soon as the business issues its first invoice, and record every invoice from that point on. The discipline that matters is completeness: if an invoice exists, it’s in the tracker. The moment invoices start living in email threads and personal spreadsheets, you lose the single view that makes follow-up work.
Update it in real time, log an invoice the day it’s issued, mark it paid the day payment arrives. A tracker updated in a monthly batch is a history lesson; a tracker updated daily is a management tool. The person who issues the invoice should be responsible for logging it, so nothing falls between two people’s desks.
Use the tracker’s ageing view to drive your credit control routine. Sort or filter by days overdue, and work the list oldest-first every week. Invoice INV-2041 to Brightline Services for $3,200, issued 12 March, 45 days overdue, that’s a phone call today, not an entry to admire.
How to Fill It Out
Section 1: Invoice identification. Invoice number (sequential, never reused), issue date, and customer name exactly as it appears on the invoice. Sequential numbering with no gaps is important, gaps make auditors and tax authorities ask questions, so if an invoice is cancelled, keep the number in the tracker marked “cancelled” rather than deleting it.
Section 2: Amounts and terms. Invoice total, currency, tax amount if applicable, payment terms (e.g. “Net 30”), and the calculated due date. Record the amounts as invoiced, don’t net off expected discounts or round. If the customer is entitled to a 2% early-payment discount, note the discounted figure separately so the expected receipt is clear.
Section 3: Status. Current status for each invoice: Issued, Sent, Paid, Partially paid, Overdue, Disputed, or Written off. Statuses must be mutually exclusive and always current, an invoice is either overdue or it isn’t. Add the date the status last changed, so “Overdue since 18 April” carries more weight than a vague “overdue.”
Section 4: Payment details. Date paid, amount received, payment method, and reference (bank reference, cheque number). For partial payments, record each receipt as a separate line and keep a running outstanding balance per invoice. “$1,200 received 20 April against $3,200 invoice, $2,000 outstanding” tells the full story at a glance.
Section 5: Follow-up log. Date, action taken (reminder email, phone call, statement sent), who did it, and the customer’s response or promised payment date. This is the section that turns the tracker into a collection tool. “Called 25 April, accounts payable says payment run Friday” is actionable; an empty follow-up column on a 60-day-overdue invoice is a management failure.
Section 6: Notes and disputes. Anything that affects payment: goods returned, credit notes issued, pricing disputes, the customer claiming they never received the invoice. Record the credit note number and amount, and link it to the original invoice. Disputed invoices need their own follow-up rhythm, a dispute ignored for two months becomes a write-off.
Common Mistakes
1. Invoices logged late or not at all. An invoice issued but never entered in the tracker is an invoice nobody will chase. The person issuing the invoice logs it immediately, make that a rule with no exceptions, and audit for completeness monthly by reconciling the tracker against issued invoice numbers.
2. Stale statuses. The tracker says “Issued” but the invoice was paid three weeks ago, or it says “Paid” when only half arrived. Inaccurate statuses make the whole tool untrustworthy, and people stop using tools they don’t trust. Update status the same day anything changes.
3. No follow-up routine. A beautiful tracker that nobody works is decoration. Assign one person to run the overdue list weekly, with escalating actions: friendly reminder at 7 days overdue, firm call at 21 days, management involvement at 45, formal demand or collection at 60+. The tracker supports the routine; it doesn’t replace it.
4. Writing off without approval. Bad debts quietly written off by whoever maintains the tracker hide real problems, a disputed invoice written off as “uncollectable” might have been winnable. Write-offs need documented approval from a manager or director, with the reason recorded.
Who Needs to Sign Off
The accounts or admin staff member maintains the tracker day to day. The finance manager or owner reviews the overdue list weekly and approves escalations. Write-offs and credit notes above a set threshold (e.g. $500) need director approval, recorded with the reason. Disputed invoices stay visible to the sales lead responsible for the customer relationship.
How Often to Review and Update
Update daily as invoices are issued and payments arrive. Run the overdue follow-up routine weekly without fail, pick a day and protect it. Reconcile the tracker against the accounting system and bank receipts monthly. Review the template annually: add fields the business has started needing (purchase order references, project codes) and remove ones nobody uses. If more than 10% of revenue is sitting over 60 days overdue, the problem is your credit terms or your follow-up, not the tracker, review both.
Download the free Invoice Tracker template.
Disclaimer: this guide is general information, not financial, tax, or legal advice. Invoicing requirements, tax treatment, and debt-collection rules vary by jurisdiction. Always check your local regulations and consult your accountant about invoicing and record-keeping.