In this guide 6 sections
Numbers repeat or skip because of series setup, cancellations and edits, and a series runs per branch, per financial year and per document type. Fix the series first. Block deletion, keep cancelled numbers on record and log every edit, so any gap can be explained to an auditor or a trustee.
A number belongs to a series, not to the software
Every receipt or invoice number is the next value in a series defined by four rules: a prefix, a branch, a financial year and a document type. One changed rule starts a new counter.
A temple may run one series for seva receipts and another for donations, a school runs a fee series per campus, and a PG separates rent from deposit. Trouble starts when two people create separate series for the same purpose, because both begin at 1 and the same number then appears twice on different pages.
Why numbers repeat
Repeats come from three places. A series was reset at the wrong time such as mid year, two branches share a prefix, or a draft was deleted and the counter reused its number.
Offline entry causes another kind. A clinic desk working through a network drop may issue numbers from a local counter and sync later, so two desks without reserved blocks hand out the same number.
Check the series master first. Read the prefix, the reset rule and the last number used for each branch and year, and compare them with the numbers printed on the newest receipts.
- Series reset in the middle of a year
- Two branches sharing one prefix
- Deleted drafts releasing their number
- Offline desks issuing numbers without a reserved block
- Old and new series both open for the same document
Why numbers skip
A skip is usually a cancelled receipt. The cashier typed the wrong amount, cancelled the slip and issued a new one, so the cancelled number now sits as a hole in the sequence.
A hole can be acceptable. A receipt marked cancelled, with a reason, a user and a time, explains itself, while a missing number with no trace looks exactly like a hidden receipt.
Edits cause quieter gaps. If editing a saved receipt creates a new number instead of updating the old one, the first number is orphaned and nobody can say where it went.
Set the rules so a gap can be explained
Decide that no receipt may be deleted. A wrong receipt is cancelled, keeps its number and carries a listed reason, and the corrected receipt gets a fresh number that refers back to the cancelled one.
Turn on an audit trail. It should record who created, edited, printed and cancelled each document, and a reprint marker makes a duplicate copy look like a copy instead of a fresh receipt.
Limit who can cancel. A clerk requests the cancellation and a manager approves it, so both names appear on the record next to the reason and the time of the change.
- One series per branch, year and document type
- Cancel with a reason, never delete
- Corrected receipt refers to the cancelled one
- Reprints marked as duplicate copy
- Audit trail of every create, edit and cancel
Review the series at every month end
Print a number register for each series showing first number, last number, count issued and count cancelled, because the arithmetic must close at month end. Issued minus cancelled equals live receipts.
Ask your accountant about numbering rules for your kind of body and place, since rules differ for trusts, schools, clinics and rental businesses. Software only follows what you set.
Number series register
One sheet lists every series on its own line, with columns for series name, prefix, branch, year, first number, last number, count issued, count cancelled and reviewer initials. Underneath sits a table of cancelled numbers. Each row holds the reason, the user and the replacement number, so every gap carries its own explanation at month end.
Open a blank worksheet to printQuestions owners ask
Is a gap in receipt numbers always a problem?
Not if it is explained. A cancelled receipt with a reason, a user and a time is a normal record, whereas an unexplained gap with no trace is the real problem.
Can I renumber receipts to close a gap?
Avoid renumbering. Renumbering breaks the link between the printed copy the payer holds and your record, so keep the original number and cancel it with a reason instead.
Should the series restart each financial year?
Often yes. Put the year in the prefix, and confirm with your accountant what applies to your organisation and place before you reset any counter.
What if two counters issue receipts at once?
Use one shared counter in the system. Alternatively give each desk its own prefix, because two desks on the same prefix with separate local counters will eventually repeat a number.