Tax and GST

The bill book check: finding gaps in invoice numbers at month end

A two-minute month-end check of your bill book or invoice list to find skipped, cancelled or missing numbers and note the reason for each.

Editorial illustration for The bill book check: finding gaps in invoice numbers at month end

At month end, run through your bill numbers in order and list any number that is missing. For each gap, find the cause: cancelled and kept, still in the book unused, given to a customer but not recorded, or lost. Write one line against every gap. It takes about two minutes and keeps your numbering clean.

Why do gaps matter?

Invoice numbers run in a series. A missing number is an unanswered question for you, your CA or anyone who reads your books later. Most gaps are innocent: a cancelled bill, a torn page, a number skipped when two staff members used two books. The problem is not the gap but a gap with no note.

How do you run the check?

  1. Take the month's first and last bill numbers.
  2. Write all the numbers in between in a column, or open your invoice list and sort it by number.
  3. Tick each number against the book or the list.
  4. Circle every number with no matching bill.
  5. For each circled number, find the carbon copy, the cancelled bill or the explanation, and write a one-line note.
  6. If a number cannot be found, say so in the note and ask who last had the book.

A worked example: bill numbers 301 to 360

Say a shop's bill book runs from 301 to 360 in a month. That is 360 minus 301 plus 1, so 60 numbers in all. On checking, 58 bills are present and two numbers are missing.

Missing numberWhat was foundNote written
318Carbon copy found in the book, marked cancelled, wrong customer nameCancelled on the 9th; replaced by 319
344No copy in the book; staff member remembers giving it for a quick saleOriginal handed over; amount traced to cash sale on the 21st; copy written from memory and marked as such

So 58 live bills plus 2 explained gaps accounts for all 60 numbers. The first gap is routine. The second is a reminder to give the carbon copy discipline to every staff member.

What if two books run side by side?

Shops with two counters sometimes use two books with separate series, for example one starting with A and one with B. Check each series separately. Do not run two books under the same numbers, since the same number would then identify two bills.

Who should do the check?

Ideally someone who does not write the bills. If you write them yourself, do it after a break, with fresh eyes. In a shop with staff, tell them the check exists and what it looks for; it improves care without any accusation. Ask each person to hand in the carbon copy of any bill they cancel.

What if you use software?

Billing software usually numbers automatically, but gaps can still occur when an invoice is deleted rather than cancelled. Sort the invoice list by number and scan down the column. Look for a jump of more than one. Do not renumber old invoices to close a gap; add a note instead.

What should the monthly record show?

  • First and last number for the month.
  • Count of live bills and count of cancelled bills.
  • Each gap and the explanation.
  • Initials and the date of the check.

Do the same check on the sale totals: add the bills and compare with the cash book and your bank deposits. If you import the bank statement into SpendixAI, you can compare the month's credits with the bill total from one place. If the totals differ, look at the gaps first.

Before the new book starts

When a book is finished, write the first and last number on the cover and file it with the month's records. Start the next book in sequence, and never throw away a finished book.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports