How to Match UPI and Cash Payments in a Jewellery Shop

It is closing time. The cash drawer says one thing and the scheme register says another. The UPI app on the shop phone shows five credits today, four of them for the same amount. One is from a name you do not know. No member in your register is called that.

Every jeweller who takes both UPI and cash payments knows this evening. The way out is simple to say. Give every payment a proof the moment it arrives, a receipt number for cash and a UPI reference number for UPI. Write that proof on the register line. Then check the drawer and the UPI list against the day's entries before you lock up.

This guide is for shops that already run a scheme. If you are still planning one, read our guide to what a gold saving scheme is and how it runs first.

Why is it hard to match UPI and cash payments in a jewellery shop?

It is hard because the money sits in two places and the record sits in a third. Cash is in the drawer, UPI is in the bank, and the entry is in the register. Nothing joins the three unless a person joins them. In a scheme there is one more problem: most payments are for the same amount.

I saw this while building our scheme software with a working jewellery store. The trouble did not come from careless staff. It came from four things special to a scheme counter.

Every instalment looks the same

In normal sales, amounts differ. A bill for a chain and a bill for a ring are easy to tell apart in the bank statement. In a scheme, a large share of your members pay the same instalment, say ₹2,000 as an example. Ten credits of ₹2,000 look exactly alike. The amount tells you nothing about who paid.

The payer is often not the member

The member is the wife. The payment comes from the husband's phone, or the son's. The name in your UPI list belongs to someone who is not in your register at all. If you match by name, you will either guess or give up.

One payment can cover several slots

A member who holds three slots sends one payment for all three. Your register has three lines. Your UPI list has one credit. They will never match line for line.

Cash leaves no trail of its own

A UPI payment leaves a record in the bank even if your staff forget it. Cash does not. If the receipt is not written when the notes are handed over, the only record is someone's memory. Unrecorded cash is one of the six places a manual scheme leaks money, and it is the hardest one to find later.

How do you match a payment, step by step?

You match a payment in five steps: money arrives, you catch the proof, you write the entry, you check at closing, and the entry is matched. The first three steps happen at the counter, in under a minute, while the customer is still there. The last two happen once, in the evening.

Step 1: Money arrives

It comes in one of three ways. Cash across the counter. UPI at the counter, when the customer scans your QR code. Or UPI sent from home, when nobody from the shop is watching. The third kind needs the most care.

Step 2: Catch the proof

For cash, the proof is a numbered receipt with a carbon copy. The rule is that no scheme cash goes into the drawer until the receipt is written.

For UPI, the proof is the UPI reference number. Every UPI payment carries one. Apps show it under slightly different labels, such as reference number, UTR or transaction ID. Here is the counter detail that matters most: read the number from the shop's own phone or app, not from the customer's screen. Her screen shows what her app says. Your proof is the credit on your side.

Most gaps begin at this step. A staff member sees a green tick on the customer's phone, says thank you, and writes the entry without a reference. At closing, that entry cannot be told apart from any other payment of the same amount.

Step 3: Write the entry

Write the register line at once, not later. It needs the member number, the slot, the month paid for, the amount, the mode, and the proof. If you are setting up the book, our guide to the columns a gold scheme register needs shows the full page. If you keep the scheme on a computer, add a mode column and a proof column to your gold scheme Excel sheet.

For a payment that covers several slots, write one line per slot and put the same UPI reference on every line.

Step 4: Check at closing

At closing you ask two questions, one for each kind of money.

• Cash: does the scheme cash in the drawer equal the total of today's cash receipts?
• UPI: does every credit on the day's UPI list have a register line with the same reference, and does every UPI line in the register have a credit?

The UPI question has to be asked in both directions. One direction finds money with no entry. The other finds an entry with no money. We have a separate guide on the daily collection sheet and the five minute closing check, so here I will stay with the matching itself.

Step 5: Entry matched

When the money, the proof and the register line all agree, tick the line. It is matched. Whatever is left goes on the open list. There are only two kinds of open item.

• Money without an entry. A credit in your UPI list that no register line claims. Usually a payment sent from home.
• An entry without money. A register line with no credit or no cash behind it. Usually a wrong reference, a payment that failed, or a payment sent to a different number.

Every open item gets a date and the name of one person who will solve it. An open list with no names on it is only a list of worries.

Which proof goes with which payment mode?

Each payment mode has its own proof and its own place to check. Cash is proved by the numbered receipt and checked against the drawer. UPI is proved by the reference number and checked against the shop's UPI list. Card, bank transfer and cheque each have their own slip or number and are checked against the bank.

Two rows need a short note. Card money usually reaches the bank later than the day the card was used, and it may arrive as one sum for many payments. Ask your bank or card machine provider how yours is settled, then match the card machine's day report first and the bank credit second. A cheque is not money until it clears, so mark the line as not cleared until the bank shows it.

A worked example: one evening at closing

All names and amounts here are made up to show the method. The instalment is ₹2,000.

The register shows nine scheme entries today. Five are cash and four are UPI. The shop's UPI list shows five credits: four of ₹2,000 and one of ₹6,000.

1. Cash first. The receipt book shows five receipts in sequence, with no number skipped. Five times ₹2,000 is ₹10,000. The scheme cash in the drawer is ₹10,000. Five ticks.
2. UPI by reference. Three of the four UPI entries have a reference written next to them. Each one is found in the UPI list. Three ticks.
3. The entry with no reference. The fourth UPI entry has the member number but no reference. The staff member looked at the customer's phone and wrote nothing. There is one ₹2,000 credit left in the list, and the time fits. He remembers the customer because it was this afternoon. He writes the reference on the line. One tick. At month end, nobody would remember.
4. The credit with no entry. The ₹6,000 credit is from a name that is not in the register. Nobody at the counter took it. It goes on the open list as money without an entry.
5. Solving the open item. The shop phone has a message from a member who holds three slots. Her husband paid from his account. Three register lines are written, all with the same reference, and three receipts are sent to her. Three lines of ₹2,000 equal the one credit of ₹6,000.

The open list is empty and the shop can close. Without that message, the item would stay open, and the first job tomorrow would be one phone call.

Should you match every day or at month end?

Match every day. The work is the same either way, but on the same evening it covers only a few payments, staff still remember each customer, and a gap can be fixed with one call. At month end it covers a whole month of equal amounts, and the person who finds the gap is often the customer.

Look at the last line on each side. When the shop finds the gap, it is a small job. When the customer finds it, she is at your counter saying she paid, and she is asked to prove it. Even if you settle it in her favour, she will remember being doubted. Matching is a trust job before it is an accounts job.

The word your accountant uses for all this is reconciliation. It only means checking that the money received and the entries written agree with each other.

How do you measure matching in your own shop?

You measure it by counting your open items every evening for one week. No outside figure can tell you how well your shop matches payments. Your own count can, and it takes one line on a page each day.

At closing, write three things:

1. How many credits had no entry.
2. How many entries had no money or no proof.
3. How many of yesterday's open items are still open.

After a week, read the page. If the first count is the biggest, your trouble is payments sent from home. If the second is the biggest, your trouble is at step two, at the counter. If the third keeps growing, nobody owns the open list. Each answer points to a different fix.

Mistakes to avoid when you match payments

• Matching by amount. In a scheme the amounts are the same. The amount confirms the sum. It cannot tell you the member.
• Matching by name. The payer is often a family member. Use the member number and the reference.
• Trusting the customer's screen. A screenshot is a clue. The credit on the shop's side is the proof.
• Taking scheme payments on personal numbers. If customers pay to the owner's own number or a staff member's phone, those credits are in a list the counter cannot see. Use one shop UPI ID for scheme payments and print it on the QR code.
• Mixing scheme cash with sales cash. Keep scheme cash in its own tray or pouch inside the drawer. Counting is then one step, not a calculation.
• Writing over a wrong entry. Strike it with one line so it can still be read, and write a new line below. A record that was changed quietly is a record nobody trusts.
• Forcing the total to fit. If the drawer is short, write the gap on the open list. Do not adjust a line to hide it.

There is one habit that prevents more unmatched credits than any other. Ask every customer who pays from home to send a short message with her member number after paying. If her app lets her add a note to the payment, ask her to type the member number there too. As you collect more instalments without phone calls, more money arrives when nobody is watching, and this habit matters more each month.

When do you not need software to match payments?

You do not need software if your scheme is small, one person takes every payment, the closing check is short, and your open list is empty on most evenings. A register, a numbered receipt book and the five steps above are enough until that changes.

Software starts to earn its place when one of these becomes true:

• Two or more people, or two branches, take scheme payments.
• Many members pay from home, and credits with no entry appear every day.
• The closing check takes so long that staff begin to skip it.
• Your weekly count of open items keeps growing.

If you are not sure where your shop stands, our comparison of paper, Excel and software places each one by the size of the scheme.

What software does, and what it cannot do

I will speak only for our own product. In GoldKitty, our gold scheme software, cash, counter UPI and in app payments land in one list. Staff record cash and counter UPI on the admin panel. A payment made inside the member app is recorded against that member as it is paid, so there is no name to guess. Every payment gets a numbered receipt in sequence with no gaps, and the receipt also goes to the customer on WhatsApp. A member with several slots pays one combined amount, and each slot keeps its own record.

Now the limits. Software cannot count your drawer. Someone still has to check that the cash is there. It cannot see a payment sent to a personal number. And it cannot decide your rules. Rules about accepting cash and running saving schemes differ by country and state, so confirm yours with your own CA or legal adviser. GoldKitty is modular for this reason. It is set up for each jeweller according to their market and offer, and payments use local payment gateways integrated according to that market's banking guidelines.

If your shop needs something no ready product covers, you can also look at the other products we have built and talk to us from there.

Our take

The software does not run the scheme, trust does. Matching is where that trust is kept or lost, because it is the moment a customer's payment becomes a record nobody can argue with. A member who sees every instalment in her gold scheme passbook, with the same receipt number you hold, has no reason to doubt you.

So start tonight, by hand. Catch the proof, write the line, check at closing, and keep the open list. Count your open items for a week. If the count stays low, you need nothing more. If it keeps growing, bring that page to a private demo on your own scheme's numbers, and ask to see each open item handled in front of you. Before any real member is moved over, we run mock collections from start to finish, because payments are the trust core of the business.

Frequently asked questions