The simplest invoice numbering system for a one-person freelancer is a prefix for the financial year followed by a running number, such as 2526-001, 2526-002 and so on, with a new series starting each April. Keep every number unique and in order, record each invoice in a log, store the PDF in a folder for the year, and once a month check there are no gaps.
What should an invoice number look like?
- A year code for the April to March financial year, so 2025-26 becomes 2526.
- A hyphen, then three digits that count up: 001, 002, 003.
- No spaces and no slashes, because slashes cause trouble in file names.
- Never reuse a number, even for a cancelled invoice.
Short numbers are easier to quote on a call and to match in a bank narration. If you are registered under GST, ask your CA what your invoice number series must look like, including its length and when it restarts, because those details are set by rules that change and apply to your registration.
How do I keep an invoice log?
One sheet is enough. Use a row per invoice with these columns:
| Column | What goes in it |
|---|---|
| Number | 2526-004 |
| Sequence | The plain number part, 4 (used for gap checks) |
| Date | Date issued |
| Client | Who it went to |
| Amount | Total invoiced in ₹ |
| Status | Draft, Sent, Part paid, Paid or Cancelled |
| Paid so far | Total received against it |
| Bank reference | The narration or reference seen on your statement |
The outstanding amount is Amount minus Paid so far. Say invoice 2526-004 is for ₹45,000 and the client pays ₹20,000 first and ₹25,000 later. After the first payment, the outstanding figure is ₹25,000; after the second it is zero and the status changes to Paid.
How do I check no number is missing?
Put the plain sequence numbers in column B from B2 down. Then two cheap checks:
- Count of missing numbers: =MAX($B$2:$B$100)-COUNT($B$2:$B$100)
- Flag the gap in column H: =IF(B3-B2<>1,"Gap after "&B2,"") filled down from H3
Suppose you have issued numbers 1, 2, 3, 4, 6, 7 and 8. MAX is 8, COUNT is 7, so one number is missing, and the gap formula in the row for 6 reads Gap after 4. Check whether 5 was issued and lost, or cancelled and not logged. A cancelled invoice should stay in the log with the status Cancelled and its PDF kept, not deleted.
How should I file the PDFs?
Use a folder per financial year and keep sent and paid files apart:
- Invoices/2025-26/Sent for those awaiting payment.
- Invoices/2025-26/Paid for settled ones.
- Invoices/2025-26/Cancelled for withdrawn ones.
Name each file number first, then client, then date: 2526-004 ClientName 2025-11-12. When payment arrives, move the file from Sent to Paid and update the log on the same day. Keep a copy of the folder in a second place such as another drive.
What should I do when a client asks for a correction?
Do not edit the sent PDF. Issue a corrected invoice or a credit note as your CA advises, give it the next number, and note in the log which invoice it replaces. The old record then still shows what was originally sent.
Keeping it separate from your spending records
Invoices record money coming in; an expense tracker records money going out. SpendixAI does not do invoicing, so keep this log in your sheet and use SpendixAI for the spending side, such as business purchases uploaded from a statement.
Month-start checklist
- Run the missing-number check.
- Move paid invoices to the Paid folder.
- Match each bank credit to an invoice reference.
- Chase anything past its agreed payment date.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


