It is the last week of the month. You sit down with the register, the payment app on your phone and a bundle of card slips. The total is short by ₹3,000, which is an example amount, but you know the feeling. Somewhere in thirty days of entries there is one wrong line. Nobody at the counter remembers which day it was.
The fix is to track payments on the day they happen. Keep one daily collection sheet, write every payment on it before the customer leaves, and run a short closing check before the shutter comes down. A mistake found the same evening has only a few possible causes. This guide shows the sheet, the check and the weekly and monthly routine.
What does it mean to track gold scheme payments daily?
Tracking gold scheme payments daily means that every instalment received today is written down today, with its proof, and checked against the real money before the shop closes. You end each day with three totals, one each for cash, UPI and card, and each total agrees with what is in the pouch, the app and the card machine.
In a saving scheme the customer pays you for many months before buying anything. If you are new to how that works, our guide to how a gold saving scheme runs from joining to redemption explains the full journey. Across all those months, the only thing the customer has is your record. A record that is checked every day is one you can stand behind.
Daily tracking does not replace your register or ledger. It feeds them. The daily sheet shows one day across all members. The member record shows one member across all months. You need both views, and the daily one comes first.
What goes on a daily collection sheet?
A daily collection sheet has eight columns: Receipt no., Member no., Slot, Month, Amount, Mode, Proof and Taken by. The date and the counter go at the top of the page. Every scheme payment gets one line, in the order it was received. Under the last line you write three totals: cash, UPI and card.
The sheet below shows the first four payments of one day. All entries are examples.
Here is what each column is for.
- Receipt no. The number on the receipt you gave. The numbers must run in order down the page.
- Member no. The number you gave the customer when they joined. Names repeat, numbers do not.
- Slot. The slot this payment is for. A member with two slots gets two lines, as M-014 does on the sheet.
- Month. The month of the scheme being paid for. On the sheet, M-031 is paying for Month 6 in advance while the others pay for Month 5.
- Amount. What you received, in figures.
- Mode. Cash, UPI or card.
- Proof. Where the money can be found. For cash, the scheme pouch. For UPI, the last digits of the reference. For card, the last digits of the slip.
- Taken by. The staff member who took the payment.
If you have read our guide on keeping a gold scheme register with the right columns, you will see that the sheet is close to a register page. The difference is the Proof column and the three totals. If your register already has a dated heading for each day, that day's block can be your daily sheet. Add the proof and the totals and you are done. If you work in a spreadsheet, the payments tab in our Excel sheet format for gold schemes becomes the daily sheet when you filter it by today's date.
Three rules at the counter
The sheet only works if it is filled in at the right moment. Three rules cover it.
- Write the line before the customer leaves. Not on a slip, not in your head, not at night. The sheet is the first place a payment is written, and nothing is copied into it later.
- Take proof from your side. For UPI, look at your own app or sound box, not the customer's screen. For card, keep the slip.
- Keep scheme money apart. Scheme cash goes into its own pouch, not the sales drawer. If you can, use one QR code only for scheme payments.
How do you run the five minute closing check?
Run five checks in the same order every evening: receipts in order, cash matches the pouch, UPI and card match, nothing left unexplained, and two people sign. On a normal day this takes about five minutes, because you are checking one day of lines and everyone who took a payment is still in the shop.
- Receipts in order. Read the first and last receipt number on the sheet. Count the lines. If the numbers run from R-0412 to R-0420, there must be nine lines. A gap means a receipt was given and not written, or spoiled and not marked.
- Cash matches the pouch. Add the cash lines. Count the cash in the scheme pouch. The two must be equal.
- UPI and card match. Find each UPI line in your payment app and each card line in the machine's report. Then go the other way. Look for any scheme payment in the app that has no line on the sheet.
- Nothing left unexplained. If something does not match and you cannot find why tonight, write it on the sheet as an open item: the amount, the mode and what you know. Do not guess and do not adjust.
- Two people sign. The person who closed signs. The owner or manager signs after looking at the totals. One person should not collect, close and approve alone.
After the check, update each member's record from the sheet. In a paper shop that is the member's page in the kitty ledger, which holds one member's payments month by month. Then file the sheet by date. The full close, with the ledger and filing, takes longer than five minutes. The check itself should not.
A worked example: one evening at the counter
Take a Tuesday. All figures here are examples. The instalment is ₹3,000 per slot. The sheet has nine lines, receipts R-0412 to R-0420. Five lines say cash, three say UPI and one says card. So the sheet totals are ₹15,000 cash, ₹9,000 UPI and ₹3,000 card.
Check one passes. Nine receipts, nine lines, no gap.
Check two fails. The pouch holds ₹12,000. It is short by ₹3,000, exactly one instalment.
Check three explains it. The payment app shows four scheme payments today, not three. One of them has no UPI line on the sheet. Staff 2 remembers at once. The customer opened her purse, changed her mind and paid by phone. The line was written as cash out of habit.
The fix takes a minute. Strike the wrong line so it can still be read, write the correct line below it with the same receipt number, the mode as UPI and the reference in the Proof column, and initial both. The totals are now ₹12,000 cash, ₹12,000 UPI and ₹3,000 card. Check four has nothing to record. Check five, both sign.
Notice what would have happened at month end. The grand total for the day was always right, ₹27,000. Only the split was wrong. At month end you would see cash short and UPI over, across a full month of lines, with no memory of a customer who changed her mind. This is why a correct total is not enough. Each mode has to match on its own. The step by step method for that is in our guide on matching UPI and cash payments in a jewellery shop.
What should you check daily, weekly and monthly?
Check the money every day, the bank and the unpaid slots every week, and the scheme as a whole every month. The daily check catches wrong entries. The weekly check catches money that was written down but never arrived, and members who are falling behind. The monthly check catches slots that are short or paid twice.
| When | What to check | Who does it | What it catches |
|---|---|---|---|
| Every day | Receipt numbers, cash against the pouch, UPI and card against the app and the machine | Counter staff close, owner or manager signs | A missing or wrong entry while everyone still remembers |
| Every day | Open items carried from earlier days | The person who closes | A small question before it becomes an old one |
| Every week | Daily totals against the bank and UPI statement | Owner or a second person | Money that was written down but never arrived |
| Every week | Slots due this month that have not paid | Owner or manager | Late payers while a polite reminder still works |
| Every month | Total received against total due, slot by slot | Owner, with the accountant | A slot that is short or has paid twice |
| Every month | A few member records against the receipts those members hold | Owner | Payments posted to the wrong member or slot |
The weekly list of unpaid slots matters more than it looks. A customer who is a few days late needs only a polite reminder. A customer who is two months behind needs a difficult conversation. If late payers are a regular problem in your shop, our guide on stopping late payments with a clear due date and grace period covers the rules to set.
The last monthly row is the one owners skip. Pick a few members, ask to see the receipts they hold, and compare them with your record. A payment posted to the wrong slot will pass every daily check, because the money is real and the totals agree. Only the member's own receipts will show it.
Tell us what you have in mind. We turn AI prototypes and fresh ideas into shipped, scalable products, from India, for the US and UK.
How do you record payments that do not fit neatly?
Write what really happened, on the day you learned of it, and use the Proof column for the detail. Most daily tracking breaks on a handful of awkward cases, not on normal payments. Decide the rule for each one in advance, so every staff member handles it the same way.
- Paid from home after closing. Make it the first job of the morning. Open the payment app, find anything that arrived overnight, and enter it on the new day's sheet. Note in the Proof column that it was paid the previous night.
- Paid to the owner's personal number. This is the payment most likely to be forgotten. Either stop accepting it, or send the details to the counter the same day so it gets a line and a receipt.
- Several months paid in advance. Write one line per slot per month. Three months in advance is three lines, so the Month column stays true.
- One person pays for a relative. The line goes under the member number of the slot being paid for. Write who paid in the Proof column.
- Less than the full instalment. Write the amount you actually received. Whether your scheme accepts part payments is a rule you set, but the sheet must show the real figure.
- Money you cannot identify. A UPI payment with no name you recognise is an open item. Write it down and ask. Do not give it to the most likely member.
Common mistakes in daily payment tracking
- Tracking only cash. Many shops count the drawer and trust the app. Digital payments go wrong too. They are just quieter about it.
- Trusting the grand total. As the worked example shows, the total can be right while two modes are wrong.
- 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.
- Skipping the check on busy days. Festival days and due dates are when most payments arrive and most errors happen. Those are the days the check matters most.
- One person does everything. When the same person collects, closes and signs, nobody else has looked at the sheet.
Each of these looks small on the day. Together they are a large part of why a manual gold scheme quietly loses money without any single loss showing in the accounts.
How do you know your daily tracking is working?
You know it is working when the closing check is short, open items are rare and cleared within a day or two, and the month end holds no surprises. You do not need anyone else's figures for this. Measure your own shop for one month with three simple counts.
- Minutes. Write the start and end time of the check at the bottom of each sheet.
- Open items. Count how many you raised and how many days each one stayed open.
- Month end differences. Count how many things the monthly check found that the daily check missed.
If the minutes keep growing, the sheet is telling you something. Either lines are being written late, or scheme money is mixed with sales money, or the scheme has grown past what one page can hold. To see the whole cost of running the scheme by hand, use the one week time log in our guide to measuring the time a manual gold scheme takes.
What a daily sheet cannot do
Be honest about the limits. The sheet checks only what was written. If cash is taken with no receipt and no line, all five checks will pass. What catches that is the customer. A customer who expects a numbered receipt every time will ask when one does not come.
The sheet also does nothing for the customer. It does not send a receipt, show a balance or remind anyone that a payment is due. And it is one counter's view. With two counters or two branches you have two sheets, and someone has to join them.
Do you need software to track payments daily?
No, not if you have one counter, most payments come across it, and the closing check passes in about five minutes. In that shop a paper sheet or a spreadsheet does the job. Software becomes worth it when many payments arrive from home, when you have more than one counter or branch, or when open items keep carrying over.
I build software, and I still say this. A small scheme with a disciplined sheet is in better shape than a large scheme with a tool nobody checks. The software does not run the scheme, trust does. Also, daily tracking is not needed on days with no payments. Write "Nil" on the sheet, sign it and go home.
When the scheme does outgrow the page, the daily habit carries over. We built GoldKitty, our gold scheme software, hand in hand with a working jewellery store, and the daily list in it follows the sheet you already keep. Cash, counter UPI and in app payments land in one list. Every payment gets a numbered receipt, in sequence, with no gaps. The receipt is mirrored to the customer on WhatsApp, even if they do not use the app, so the customer becomes your second check. The owner's dashboard shows collections and overdue slots each morning.
GoldKitty is modular. It is set up for each shop according to its country and its offer, and payments run through local payment gateways. It does not have a published price. Pricing is given after a demo on your own scheme. It is one of the products appico builds and maintains.
Our take
Most payment problems in a gold scheme are found late because nobody looked on the day, not because they are hard to find. One sheet, five checks and two signatures will change that.
Start tonight. Rule the eight columns, write today's payments and run the five checks. Do it for one month and measure the three counts above. If the page is coping, stay with it. If it is not, you can see your own scheme's daily collections in one list in a demo, on your own numbers. Either way, your customers get what they are paying for every month: a record that is right.
Frequently asked questions
How do I track gold scheme payments daily?
Keep one daily collection sheet for each day. Write every scheme payment on its own line before the customer leaves, with the receipt number, member number, slot, month, amount, mode and proof. Before you close, run five checks: receipts in order, cash matches the pouch, UPI and card match, nothing left unexplained, and two people sign.
What is a daily collection sheet in a gold scheme?
It is one page that lists every scheme payment the shop received on one day, in every mode. Cash, UPI and card payments sit on the same page, each with its own proof. At the end of the day the sheet gives you three totals, one for each mode, which you check against the cash pouch, the payment app and the card machine.
Which columns should a daily collection sheet have?
Eight columns are enough: Receipt no., Member no., Slot, Month, Amount, Mode, Proof and Taken by. Write the date and the counter at the top of the page. The Proof column is the one most shops leave out. It holds the last digits of the UPI reference or card slip, or a note that the cash is in the scheme pouch.
How long should the daily closing check take?
On a normal day the check itself should take about five minutes, because you are only checking one day of lines. If it keeps taking much longer, treat that as a sign. Either payments are being written late, scheme money is mixed with sales money, or the scheme has grown past what a paper sheet can handle.
What should I do if the cash does not match the sheet?
Find the reason the same evening. First check whether a line marked cash was really paid by UPI or card. Then look for a payment written twice or a receipt with no line. If you still cannot explain the difference, write it on the sheet as an open item with the amount and date. Never change a line just to make the totals agree.
How do I record a UPI payment made after the shop has closed?
Enter it first thing the next morning, before the first customer. Open your payment app, find anything that arrived after closing, and write each one on the new day's sheet. In the Proof column, add the reference and a note that it was paid the previous night. Then issue the receipt and send it to the customer.
Can I track gold scheme payments daily in Excel?
Yes. Use the same eight columns in a payments tab and filter by today's date to see the day's sheet. Excel adds the three totals for you, which removes one source of error. It still depends on someone typing every line correctly, and it cannot check the payment app or send a receipt to the customer.
Do I need software to track payments every day?
Not always. If you have one counter, most payments come across it, and your closing check passes in about five minutes, a paper sheet or Excel is doing its job. Software earns its place when many payments come from home, when you have more than one counter or branch, or when open items keep carrying over.
How does GoldKitty help with daily payment tracking?
In GoldKitty, cash, counter UPI and in app payments land in one list, so the day's collections are already in one place. Every payment gets a numbered receipt in sequence with no gaps, and the receipt is mirrored to the customer on WhatsApp. The owner sees collections and overdue slots on the dashboard each morning. Pricing is given after a demo on your own scheme.
Are there rules on how long a jeweller must keep payment records?
Saving schemes are regulated, and the rules differ by country and by state. This guide is about good daily habits, not law. Ask your own adviser or chartered accountant which records your scheme must keep and for how long, and file your daily sheets to match what they tell you.
“Disciplined, committed, over-delivers. Three years in, I would re-hire any day.”
“A factory of ideas.”
“A fantastic-looking and performing website.”
Talk to the team, we reply within 24 hours, and the first consultation is free.
Start a conversation →