If you have ever found two invoices with the same number or mysterious gaps in your series, you already know why this matters.

Numbering is where Excel collapses and software quietly shines.

This guide shows how to set up invoice numbering the right way and what to do when you make a mistake.

Generate a legally compliant, highly professional invoice in under 60 seconds.
No signup required to start. No credit card. Just type, send, done.

Pick a human-readable, future-proof pattern

Use a prefix, location, year, and running number: 'INV/JPR/25-26/0042'.
Keep it short enough to type but descriptive enough that staff can say it on a call without confusion.
Decide up front whether you want a single series or different series for exports, credit notes, etc.
Document this choice in a 2-line policy so everyone in your team uses the same rule.

Let software, not humans, control the counter

Your invoicing tool should auto-increment the last used number for each series.
Nobody should be able to manually type over invoice numbers once created.
If two users try to create invoices at the same time, the backend should still guarantee unique numbers.
When you switch tools mid-year, import the last number and continue — do not restart at 1.

Never delete an issued invoice from history; instead, issue a credit note to nullify it if needed.
If an invoice number was reserved but never actually sent, keep it and mark it as 'void' for audit clarity.
Your CA prefers to see continuous series with explicit voids than perfect-looking but faked sequences.
In Invwow, a 'Void/Cancel with credit note' action can keep numbering clean without manual hacks.

Pick a human-readable, future-proof pattern

Use a prefix, location, year, and running number: 'INV/JPR/25-26/0042'.

Keep it short enough to type but descriptive enough that staff can say it on a call without confusion.

Decide up front whether you want a single series or different series for exports, credit notes, etc.

Document this choice in a 2-line policy so everyone in your team uses the same rule.

Let software, not humans, control the counter

Your invoicing tool should auto-increment the last used number for each series.

Nobody should be able to manually type over invoice numbers once created.

If two users try to create invoices at the same time, the backend should still guarantee unique numbers.

When you switch tools mid-year, import the last number and continue — do not restart at 1.

Handling cancellations and errors without breaking the series

Never delete an issued invoice from history; instead, issue a credit note to nullify it if needed.

If an invoice number was reserved but never actually sent, keep it and mark it as 'void' for audit clarity.

Your CA prefers to see continuous series with explicit voids than perfect-looking but faked sequences.

In Invwow, a 'Void/Cancel with credit note' action can keep numbering clean without manual hacks.