How to sort a client's year of receipts

It arrives in a paper bag, a shoebox or a Mr DIY plastic bag tied at the top. Twelve months of a client’s receipts, invoices, petrol slips, bank statements still in their envelopes, a few personal Watsons receipts, and one parking ticket from 2023. The boss says “everything is inside”, and the deadline is next month.

Someone at the firm now has to turn that bag into something the books can be written from. Most firms do it the same way every year: empty it on a table, start picking up pieces, and hope. It takes days, and the mistakes show up later as a missing supplier invoice or a receipt keyed twice.

There is a better order to do it in. None of this needs software. It just needs doing in the right sequence, so each piece of paper is handled as few times as possible.

Before you start: set up the table

Clear one table and keep it for this client until you finish. Mixing two clients’ bags on one table is how a receipt ends up in the wrong file.

You need:

the client’s bank statements for the whole year (ask for them first if they’re not in the bag)
twelve envelopes or folders, one per month, plus a few labelled by type (see below)
a phone or scanner within reach
a sheet of paper or a spreadsheet for the “missing” list

Step 1: rescue the faded ones first

Go through the bag once, quickly, only looking for thermal receipts: petrol, convenience stores, POS slips, parking. Anything already going pale gets photographed or scanned now, before anything else happens to it. Every hour on a warm table makes it worse.

Don’t sort, don’t read, don’t key. Just capture the ones at risk. If one is already blank, put it aside and note the rough date and shop if you can guess it. It goes on the missing list later. More on why this happens in why thermal receipts fade.

Step 2: sort by type, not by date

The instinct is to sort by date straight away. Don’t. Sort by type first, because each type is handled differently and has its own natural order. Five piles:

Bank statements. These are the spine of everything that follows.
Supplier invoices and bills. Purchases, utilities, rent, phone, insurance.
Receipts for payments. Small cash and card receipts: petrol, meals, hardware, parking.
Sales documents. Copies of invoices or receipts the client issued, pay-in slips, payment advice from customers.
Everything else. Payroll records, loan letters, contracts, statements from suppliers, and anything you’re not sure about.

Personal items (groceries, the family holiday, school fees) go into a separate envelope marked personal, to confirm with client. Don’t throw them away. Ask.

Step 3: sort each pile by month

Now each pile goes into month order. Within a month, rough date order is enough. You don’t need it perfect, you need to be able to find a document when a bank line points you to it.

Staple multi-page invoices together before they get separated. If a supplier has sent a statement of account, keep it with that supplier’s invoices: it tells you which invoices you should have.

Step 4: use the bank statement as the spine

This is the step most firms skip, and it’s the one that saves the most time. Take the bank statement for January and go down it line by line. For each payment out and each deposit in, find the document behind it in January’s piles.

Found it: tick the bank line, and write the statement date on the document or clip them together.
Can’t find it: write the date, amount and description on the missing list.
Document with no bank line: probably cash, a card on another account, or a different month. Put it aside in a no bank match pile.

Do this for all twelve months. It is a rough version of the matching you’ll do properly at reconciliation, but done now it turns “any more receipts?” into a specific list. For the full method, see the bank reconciliation statement guide.

Step 5: send the missing list once

When all twelve months are done, send the client one list, not twelve messages. Dates, amounts and the description the bank shows:

14 Mar · RM86.40 · card payment, PETROL STATION JLN AMPANG
22 Jun · RM1,200.00 · IBG transfer to TAN ENTERPRISE

A specific line jogs a client’s memory far better than “please send all receipts”. Give them a date to reply by. Whatever comes back gets the same treatment: captured, sorted into its month, ticked.

Step 6: capture, then key

Only now does data entry start. Everything is in month and type order, matched to the bank, with the gaps listed. Whoever keys it works through one pile at a time without hunting.

This is also the point to capture every document if you haven’t already, so there is a clear, searchable copy for the 7 years the records must be kept. See how long to keep receipts in Malaysia.

A made-up example

Say a client’s bag holds about 600 pieces of paper for the year, and the bank statements show 420 payment and deposit lines. After sorting and matching, 380 bank lines have a document and 40 don’t. Of the 600 pieces, 35 are personal and 25 are duplicates or statements of account. The remaining 540 are the business documents to key: 380 matched to the bank, and 160 cash or card items with no bank line on this account.

The client gets one list of 40 lines. That is a conversation the boss can finish in an afternoon, instead of a month of “any more?”.

Make next year’s bag smaller

The real fix is not sorting faster. It is getting the paper monthly, so there is never a year’s worth in one bag. LHDN’s ruling for companies already expects entries to be recorded within 60 days of the transaction (Public Ruling 4/2000, paragraph 3.3.1), which a once-a-year bag can’t meet. Ideas for getting clients there are in spread the year-end rush and getting client receipts without the monthly chase.

Where AccPilot fits

AccPilot does steps 1 to 4 for you once the paper is captured. Your staff photograph or scan the bag (or upload up to 50 files at a time), and a photo with several receipts on it is split into separate documents. AccPilot reads the vendor, date, amounts, tax and line items, marks each document Ready or Check with the reason, and matches the client’s bank statement lines to the documents. The lines with no document become the chase list. Then you export one clean Excel that imports into your accounting software, and every document stays searchable for 7 years.

The judgement stays with your firm: what is personal, what a strange transfer was, how to post it. AccPilot takes away the sorting and the ticking so that judgement starts on day one, not day four.

To see it on one of your clients’ bags, book a free demo and bring their receipts along.