Invoice Number Generator
Invoice numbers feel trivial until an accountant asks why two invoices share a number. A consistent scheme costs nothing to set up.
Pick a scheme you will still understand in three years
The most durable pattern is a short prefix for the entity or year, a separator, and a zero-padded sequence: INV-2026-0001. The padding matters because it keeps the numbers sorting correctly in a spreadsheet; without it, invoice 10 files before invoice 2. Avoid reusing numbers across years and avoid inserting a number in the middle of a run - if you need to correct an invoice, issue a credit note instead.
Keep the list with the invoice tracker
Generating numbers is the easy part. The harder part is knowing which ones have been paid, which are overdue and which client they belong to. A tracker with issue date, due date and paid date turns that from memory into a column you can sort.
Questions
- Can I restart the sequence each year?
- Yes - include the year in the prefix and start again at 0001.
- Should the number be on the invoice itself?
- Always. It is the reference both sides will use in any dispute or audit.
- What if I skip a number?
- Leave the gap. A missing number is far easier to explain than a duplicate.