Invoice numbering that survives an audit
A dull subject that decides whether anyone can trust your books. If your invoice numbers have gaps, duplicates or restarts, you cannot prove what you billed — and neither can your accountant, your auditor or FIRS.
Every figure below is hypothetical. The pattern is not.
Nobody has ever been excited about invoice numbering. It is also the single cheapest control in a business, and the first thing anyone examining your records will test — because it is the one property of your books that can be checked without trusting a word you say.
What the sequence proves
A gapless run of numbers proves one specific, valuable thing: the set of invoices you are showing is the complete set.
If your invoices run 1041, 1042, 1043, 1044, there is no room between them. If they run 1041, 1042, 1044, then 1043 exists somewhere and is not in front of the person looking. Maybe it was cancelled properly. Maybe it was raised, paid in cash, and never entered. The sequence cannot tell them which — but it tells them to ask, and that is the entire function.
Without a reliable sequence, no examination of your books can distinguish between "that is all of them" and "that is all of them that you chose to show me." Nothing else in your records fixes that.
The four ways it breaks
Duplicates. Two people issuing from the same range, usually because one is working from a book and one from a spreadsheet. Now two different invoices claim to be 1043, and the customer who paid one has a receipt for a document you cannot match.
Gaps with no explanation. Someone spoils an invoice and bins it. The number vanishes. Six months later nobody can say whether 1043 was a mistake or a sale.
Restarts. Numbering resets each January, or each new invoice book, and suddenly you have three invoices numbered 001 in the same set of accounts.
Deletions. The most damaging, and the most common in spreadsheet-based systems. A row is deleted rather than reversed, and the invoice ceases to have ever existed — including on the copy the customer is holding.
The rules
One sequence, one issuer. If invoices come from more than one place — two branches, two people, a book and a system — give each its own prefix and keep the sequences separate: LAG-1043, IB-0207. Never let two sources draw from one range.
Never reuse, never renumber. A number is spent the moment it is issued, including if the invoice was wrong.
Never delete — cancel. A wrong invoice stays in the sequence, marked cancelled, with a reason and a date. It appears in the records at zero value. The number is accounted for, which is the whole point. This is exactly the same discipline as never silently editing a stock figure, from when your dip doesn't match your books.
Correct with a credit note, not an edit. If an invoice has already gone to the customer, the fix is a separate credit note referencing the original, not a quiet amendment. The customer holds a copy of the original; if yours no longer matches theirs, you have created a dispute rather than resolved an error.
Date order should follow number order. Invoice 1044 dated before 1043 is a small thing that makes an examiner slow down and look harder at everything else.
Why this is worth caring about beyond compliance
Three reasons, and only the third is about tax.
You cannot reconcile without it. Matching payments to invoices depends on invoice identities being unique and stable. Most "we cannot work out which invoices this payment covers" problems are numbering problems wearing a disguise.
Disputes need a reference. The delivery note references the invoice, the payment references the invoice, the credit note references the invoice. If the identity is unreliable, so is every document that points at it — see a delivery note that survives a dispute.
It is the first thing tested. By an auditor, by a bank assessing you for facilities, by a buyer doing diligence, and by FIRS. VAT obligations in particular assume you can produce a complete and ordered set of invoices for a period. A business that cannot is not necessarily in trouble — but it has lost the ability to demonstrate that it is not, which in practice is the same position.
If your numbering is already a mess
Do not go back and renumber history. Renumbering issued invoices is worse than the original problem, because customers hold copies of the old ones.
Instead:
- Draw a line at a date. From here, one sequence, one issuer, no deletions.
- Start clearly past the highest number ever used. If the mess reached 1043, start at 2000. The jump is obvious and explainable, which is far better than an ambiguous overlap.
- Write down what happened, once. A short note in your records saying the sequence was reset on this date and why. An unexplained discontinuity invites suspicion; an explained one is just a fact.
- Reconcile the old range as best you can and stop. Perfect reconstruction of a broken history is not achievable and not worth the month it would take.
The goal is not a spotless past. It is that from a known date forward, your records can be trusted — and that anyone checking can establish it in ten minutes without taking your word for anything.