What Is Payment Reconciliation? Simple Guide for Jewellers

The draw is tomorrow evening. A member calls to say she paid on the twelfth and wants to be sure her slot is in. Your register shows her month as blank. Your bank statement has a credit on the twelfth for the right amount, but the name on it is her son's. Your staff remember nothing. You now have three records of one payment, and none of them agree.

That evening is what payment reconciliation is for. Reconciliation is checking that three lists agree: what you wrote, what the customer holds, and what the money says. It sounds like an accountant's word. In a gold scheme it is the owner's job, once a month, in a fixed order, before reminders go out and before any draw is held.

This guide stays on the idea and the monthly routine, and it is written for a jewellery shop in any country. If the scheme itself is new to you, start with how a gold saving scheme runs from joining to redemption and come back.

What is payment reconciliation?

Payment reconciliation is checking that three lists agree. The first is your register, where the shop writes each payment. The second is the receipts you gave, the customer's copy of the same record. The third is the money itself: the cash in the box, the credits on the bank statement and the payments in the shop's payment app. When all three agree, the month is reconciled.

Most guides on this subject describe two lists, the book and the bank. That is enough for a shop that sells rings. It is not enough for a scheme, and this is the first thing we learned building our scheme software hand in hand with a working jewellery store. In a scheme the customer keeps a record too. Her receipts or her passbook page are a list of what she believes she paid, and at maturity she will compare it with yours. If your register and your bank agree with each other but not with her receipts, the month only looked reconciled.

Each list can be wrong on its own. It is very hard for all three to be wrong in the same way. That is the whole idea. When they disagree, the gap is one of two kinds: money with no entry, or an entry with no money. Everything else is a payment sitting on the wrong member, slot or month.

Why does a gold scheme need reconciliation more than a normal shop?

A scheme needs it more because of four things a normal sales counter does not face. The instalments are all the same amount. The person paying is often not the member. One payment can cover several slots. And two events every month, the reminders and the draw, depend on knowing exactly who has paid.

Take the amounts first. When most of your members pay the same instalment, ten credits on the bank statement look identical. The amount confirms that the right sum arrived. It cannot tell you who sent it. Only the reference number can, and only if someone wrote it down. The counter habits behind this are covered in our guide on matching UPI and cash payments each day, and they are the same in any country, whatever your payment app is called.

Now the two events. A reminder sent to a member who has already paid is the most expensive message a shop can send. It costs nothing to send and a great deal in trust. And a draw held from an unreconciled list can leave out a member who paid but was not written. In a kitty, where one slot is picked each month, that is a dispute you cannot settle afterwards. Reconcile first. Then remind. Then draw.

How do you reconcile scheme payments every month?

You reconcile in seven steps, in a fixed order: set the cut off, gather the three lists, compare the totals, match line by line, write the gap list, solve and sign off, and only then send reminders and hold the draw. The order matters more than the speed.

1. Set the cut off. Decide the last day and time that belongs to this month, and write it down. A payment sent at night on the last day belongs to one month or the other, never both.
2. Gather the three lists. The register for the month. The receipt book, or copies of every receipt given. The money: the cash count, the bank statement to the cut off, and the payment app's list.
3. Compare the totals. Add the register lines. Add the receipts. Add the cash plus the credits. Write the three totals side by side.
4. Match line by line. For each register line, find its receipt number in the book and its proof in the money. Cash is matched to the count. Digital payments are matched by reference number, never by amount and never by the payer's name. Tick every line found in all three places.
5. Write the gap list. Everything not ticked goes on one page: the date, the amount, which kind of gap it is, and the name of the one person who will solve it. A gap list without names is a list of worries.
6. Solve and sign off. When each item has an explanation, two people sign the page. After that, nothing on the month is changed. A correction is a new line with a date, not a rubbed out old one.
7. Then remind, then draw. Reminders go only to members whose month is truly blank after step six. The eligible list for a draw is taken from the signed month, not from memory.

The daily closing check keeps all of this small. If you already run a five minute check on the day's collections, the monthly reconciliation is mostly adding up work already done. If you do not, month end is where you meet every mistake of the last thirty days at once.

A worked example: one month reconciled

Every name, number and amount here is an example, in your own currency. The scheme has forty members. The instalment is 1,000. Cut off is the last day of the month at closing time.

The register shows thirty eight members paid, so the register total is 38,000. The receipt book shows thirty nine receipts, one cancelled with a line through it and kept in the book, so thirty eight valid receipts, 38,000. The money is in two parts. The cash count shows 20,000 against twenty cash receipts. The bank statement and payment app show nineteen credits of 1,000, which is 19,000. The money total is 39,000.

Two lists agree at 38,000. The money says 39,000. The difference is exactly one instalment, so before matching a single line you know you are most likely looking for one payment received and never written. Money with no entry.

Matching by reference finds it in a minute. Eighteen credits are ticked against register lines. The nineteenth, dated the twelfth, has no line, and the name on it is not a member. The shop phone has a message from a member, sent the same day, with her member number. Her son paid from his account. A line is written with today's date and the reference number, a receipt is sent to her, and the register total becomes 39,000. The gap is explained.

Now the part only the third list catches. Every total agrees at 39,000, and the month could be signed. But when the receipts are matched to the register, one receipt for member M-017 is found against a line for member M-071. The staff member wrote the number backwards. The totals are right, and one member is shown as paid twice while another is shown as unpaid. Without the receipt check, M-071 gets a reminder she did not deserve, and M-017 is left out of the draw. Two lists said the month was fine. The third said it was not.

What does a month that matches look like?

A month that matches is not a month with no mistakes. It is a month where every mistake was found by the shop, written down, and explained before the customer noticed. The two columns below show the same month handled two ways.

Read the last line on each side. Both shops took the same payments and made similar mistakes. On the left, the customer finds the mistake, often at maturity, when it is hardest to fix. On the right, two people checked and signed the month before any customer could. That is the reason to reconcile at all. It is not for the accountant. It is so the customer never has to prove she paid, which is why a member with a passbook that shows every instalment rarely calls the shop in doubt.

Reconciliation words in plain language

Your bank, your accountant and any software you look at will use a handful of words for all this. None of them is difficult once it is put in shop language. The table below lists the ones you will meet.

Settlement is the word that trips up most owners the first time. A card payment taken on the last day of the month may reach your bank days later, and as one sum for many payments. Ask your bank or card provider how yours is settled, and match the card machine's report first and the bank credit second. A payment that has not settled is not a gap. It is a line waiting for its money, and it goes on the gap list with the expected date next to it.

Mistakes jewellers make when reconciling

• Matching by amount or by the payer's name. In a scheme the amounts are the same and the payer is often a husband or a son. Match cash by receipt number, digital payments by reference number, and always by member number.
• Changing a line to make the totals fit. A forced match hides the problem until the customer finds it. Write the gap on the list instead.
• Reconciling after the draw. The draw must be held from a signed month, or a member who paid can be left out with no honest way to fix it afterwards.
• Skipping the receipts. Two lists that agree feel finished. The third list is the one that finds a payment on the wrong member.
• Treating an excess as good news. More money than entries means a member paid and was not written, and she will find out at the worst moment. It is one of the six ways a manual scheme loses money without showing a loss in the accounts.
• Mixing scheme cash with sales cash. A shortage in one hides behind an excess in the other. The counter rules in our guide on stopping cash mistakes at the counter keep the two apart.

What reconciliation cannot do

Reconciliation finds differences. It does not find agreement that is wrong. If a payment is written on the wrong member and that member's receipt was written wrongly too, all three lists agree and the mistake survives. The only defence is the customer herself, which is why her receipt must carry the member number, slot, month and receipt number, and why she should get it the moment she pays. Our guide on sending a receipt to the customer's phone at once covers the how.

And it cannot replace your adviser. Rules on which records a scheme must keep, and for how long, differ by country and state. Ask your own accountant or legal adviser what applies to your shop. The routine above is good practice, not legal advice.

When is monthly reconciliation not worth the effort?

A monthly reconciliation is always worth doing, but not always worth doing for long. If one trusted person takes every payment and the gap list is empty on most evenings, the monthly check is a short piece of adding up and a signature. Do it, sign it, and move on.

What is not worth it is chasing a tiny difference for hours. If a small gap in the cash count cannot be explained after a fair search, write it on the gap list as short or over, sign the month, and watch whether it comes back. A gap that returns every month is a habit at the counter. A gap that never returns was a bad evening.

You also do not need software to reconcile. A register, a numbered receipt book, a bank statement and the seven steps are enough for a small scheme. Software earns its place when one of these becomes true:

• Two or more people, or two branches, take scheme payments, so the register and the money live in different places.
• Many members pay from home, and credits with no entry appear every week.
• The monthly check takes so long that the draw is held before it is finished.
• Customers question their balance more often than you would like.

What software changes, and what it does not

I will speak only for our own product. In GoldKitty, our gold scheme software, cash recorded at the counter, counter payments and payments made inside the member app land in one reconciled list, so the register and the money are no longer kept apart. Every payment gets a numbered receipt in sequence with no gaps, sent to the customer on WhatsApp as well, so the third list is created at the same moment as the first. The draw uses a frozen eligible list, and overdue slots sit out until dues clear, which is only fair if the list was reconciled first.

What software cannot do is count your cash box or read your bank statement. Someone still has to confirm the money is there. GoldKitty is modular, set up for each jeweller according to their country and their offer, with payments through local payment gateways integrated according to that market's banking guidelines. Whatever your local payment methods are called, the three lists stay the same three lists.

Our take

The software does not run the scheme, trust does. Reconciliation is where that trust is kept, because it turns a customer's payment into a record nobody can argue with, on her side and on yours. A month reconciled and signed before the draw is a month where no member has to prove she paid.

Start this month, by hand. Fix a cut off, gather the three lists, compare the totals, match by proof, keep the gap list, and sign. If the list stays short, you need nothing more. If it grows every month, or the check is not finished before the draw, bring last month's gap list to a private demo on your own scheme's numbers and ask to see each item handled in front of you. Before any real member is moved over, we run mock collections and a mock draw end to end, because payments are the trust core of the business. If your shop needs more than a scheme tool, you can see the other products we build.

Frequently asked questions