Best Way to Track Customer Payments in 2026: Guide for Jewellers

It is the last week of the month. You have your record in front of you, the payment app open on your phone, and a small pile of counter slips. The money does not agree with the record, and the gap is about one instalment. Somewhere in a month of entries there is one wrong line, and nobody at the counter remembers which day it was.

The best way to track customer payments is not the fanciest tool. It is the method you will actually check every single day, matched to the size of your shop. A small scheme at one counter can run on a notebook or a careful Excel sheet. A growing scheme, many customers, or a second counter is where software earns its place. This guide shows you how to choose, and the one habit that makes any method work.

What is the best way to track customer payments?

The best method is the one that fits your shop and gets checked daily. A method nobody checks is worse than a simple one that is checked every evening. So the real choice is not notebook versus Excel versus software in the abstract. It is which of these you and your team will keep honest, day after day, as the scheme grows.

In a saving scheme the customer pays you for many months before buying anything. If you are new to how that runs, our guide to how a gold saving scheme works from joining to redemption walks through the full journey. Across all those months, the only thing the customer holds is your record. A record that is checked every day is one you can stand behind at maturity.

This is the point most tool comparisons miss. They score features. Your customer scores something simpler: does the shop always know what I have paid. That answer comes from a habit, not from a logo. Get the habit right, then choose the tool that makes the habit easy.

Why tracking is really three lists that must agree

Tracking a payment is not one job, it is three lists that must always agree: the money you hold, the proof from the method used, and your own written record. A payment is only tracked when all three match. Miss any one, and you have a receipt with no money, or money with no record, and a dispute waiting for month end.

Follow a single payment from the customer to the report and you can see where each list is created.

The customer pays, in cash or by a local payment method. You write the line while the customer is still there. You hand over a numbered receipt, so the customer holds proof that matches yours. You check the money in hand against the record and against the proof from the payment method. Only then does the payment reach the day and month totals. The word for keeping these lists in agreement is reconciliation, and our plain guide to what payment reconciliation means for a jeweller explains it without the accounting words.

The reason this matters is quiet. A grand total can be right while two methods are wrong. If a payment made by app is written down as cash, your total for the day is still correct, but your cash is short and your app money is over. That error hides in the total and only surfaces weeks later, across a month of lines, with no memory of the customer. The step by step method for catching it lives in our guide on tracking gold scheme payments daily with a five minute closing check.

Notebook, Excel or software: which fits your shop?

Choose by where your shop will be in a year, not only where it is today. A notebook or Excel suits a small scheme that one person can hold in their head at a single counter. Software becomes worth it once you have many customers, a second counter or branch, or payments arriving from home that no one sees at the counter.

The grid above sorts the choice by two things that actually change your work: how many customers you carry, and how many counters take money. A small shop with one counter can stay on paper or a spreadsheet for a long time, and there is no shame in that. The moment two counters collect for the same scheme, even a small one, you need one shared record, because two separate books never agree by themselves. Add many customers on top of many counters and you need software with staff roles, so each counter records its own payments and the owner sees everything in one place.

Moving up this grid mid scheme is possible, but moving early is easier. If you can already see a second counter or a busier scheme coming, it is calmer to set up the method that fits next year before the rush arrives.

How each method works, and where it fails

Every method can track payments. Each one fails in its own way, and knowing the failure is how you decide. A notebook fails silently, an Excel file fails when a second hand touches it, and the payment app fails because it never saw the cash.

A notebook or register works while one person keeps every line in their head. It has no way to send a reminder, there is only one copy, and every total is added by hand. Excel fixes the totals and lets you search, which is real progress, but it breaks the day a second person edits it or a formula gets typed over. The payment app is the trap: it is tempting to treat the app history as the record, but it only knows the payments that came through it, and it happily mixes your scheme money with ordinary sales.

Software is the method built for the job. It holds every payment in one list, adds the totals for you, sends receipts and reminders, and keeps a shared record across counters. The honest cost is a monthly fee and a calm setup. It is not the right answer for a shop that could run on one page and check it every night.

If you run layaway or a payment plan rather than a monthly scheme, the same rules apply. The tracking of instalments over time is the same idea, which is why our guide to what jewelry layaway software does for a store reaches the same three lists, and why moving jewelry layaway off spreadsheets solves the same problems in a different name.

A worked example: the month that would not match

Take a real shape of problem, with counts used as examples. A shop tracks its scheme in a notebook. At month end the cash is short by one instalment, and the owner spends an evening on it. The daily habit was missing, so the search is across thirty days.

The cause turns out to be small. One afternoon, a customer opened her purse, changed her mind, and paid by the app instead of cash. The staff member, out of habit, wrote the line as cash. The day total was right, so nothing looked wrong that evening. The error only became visible a month later, as cash short and app money over.

Now run the same day with the three lists checked before closing. The staff member counts the cash against the cash lines and finds it short by one instalment. The app shows one more payment than the record has lines. Within a minute the wrong line is corrected, the mode changed to the app, and the proof reference added. The month end holds no surprise, because the error was caught on the day, when only a few things could have caused it. That is the whole case for a daily check, in one story.

Common mistakes in tracking customer payments

• Tracking only cash. Many shops count the drawer and trust the app. Payments made by app go wrong too. They are just quieter about it.
• Trusting the grand total. The total can be right while two methods are wrong. Match each method on its own.
• Forcing a match. Changing a line so the totals agree hides the problem and makes the record false. An honest open item is better than a tidy page.
• Mixing scheme money with sales. When scheme payments share a drawer or a code with ordinary sales, you can never tell the two apart at month end.
• One person does everything. When the same person collects, records and approves, nobody else has looked at the record.
• Copying later. A payment written on a slip now and copied into the record at night is a payment waiting to be lost.

Each of these looks small on the day. Together they are a large part of why a manual scheme quietly loses money without any single loss ever showing in the accounts.

When you do not need software to track payments

You do not need software if you have one counter, most payments come across it, and your closing check passes quickly every evening. In that shop, a notebook or an Excel sheet is doing the job, and adding a tool would only give you something else to maintain. Buy software to solve a real pain, not to feel modern.

I build software, and I still say this plainly. The software does not run the scheme, trust does. A small scheme with a disciplined record is in far better shape than a large one running a tool nobody checks. If your method is being checked and your customers always get a receipt they can hold, you are already tracking well.

Software earns its place at the point the habit gets hard to keep by hand. That is when payments arrive from home between visits, when a second counter or branch collects for the same scheme, or when unexplained differences keep carrying into the next month. At that point the tool is not a luxury, it is what lets the habit survive your own growth. To close a month quickly once the scheme is larger, our guide on closing monthly accounts fast in a jewellery shop shows the routine that keeps month end calm.

How do you know your tracking is working?

You know it is working when the closing check is short, unexplained differences are rare and cleared within a day or two, and month end holds no surprises. You do not need anyone else numbers to judge this. Measure your own shop for one month with three simple counts.

• Minutes. Write the start and end time of your closing check each day. A check that keeps growing is telling you the method is straining.
• Open items. Count how many differences you could not explain on the day, and how many days each one stayed open.
• Month end surprises. Count what the monthly review found that the daily check missed. The aim is zero.

If the minutes keep climbing and open items keep carrying over, that is your signal to move up the grid, whether from paper to Excel or from Excel to software. Let your own record tell you when, rather than a calendar.

Our take

The best way to track customer payments is the one you will keep honest every day, sized to your shop. Start with the simplest method that fits, write every payment as it happens, give a numbered receipt, and match the three lists before you close. Add software only when the habit gets hard to hold by hand.

We built GoldKitty, our gold scheme software, hand in hand with a working jewellery store, so the daily list inside it follows the record a shop already keeps. Cash, counter payments and in app payments land in one matched list, every payment gets a numbered receipt with no gaps, and the customer gets that receipt even without the app. GoldKitty is modular, set up for each shop by its country and its offer, with payments running through local payment gateways integrated to that market rules. It has no published price, so pricing is given after a demo on your own scheme. It is one of the products appico builds and maintains. If your record is straining, you can see your own payments in one matched list in a demo, on your own numbers.

Frequently asked questions