How to track customer payments in a small shop

Write the name, the goods, the amount, and the due date in the same place you will later write the payment. That is the whole method. A customer payment tracker is just that habit with less arithmetic. Paper works until the page tears, the ink smears, or the only person who can read the handwriting is not in the shop. The tracker does not replace trust. It records it so you can collect without an argument.

One row per credit sale

Do not keep a running total on paper and a list of items in your head. Record the sale as line items. When money comes in, attach it to those items. Remaining due is then a fact, not a negotiation. If Ramesh took rice and oil on Tuesday and paid ₹500 on Friday, the khata should still show which line the ₹500 hit. A single scribbled total cannot answer that, and that is the conversation you have on the 20th of the month.

New customers need a name, a village if you collect by village, and the mobile you already call them on. That number is how they sign in later to see their own dues. It is also how you send a pay link. A customer with no phone is still a valid khata line. They just cannot pay from WhatsApp.

Verify UPI, do not assume it

Ask for a screenshot and mark the payment pending until you confirm. Declined attempts stay in history. That is how you stop the “I already paid” loop. Cash you can confirm at the counter. UPI you confirm from the photo. A ledger that treats “sent” as “paid” will fight you every week.

Collect on a schedule

Walk the largest dues first. Use a pay link for people who will not visit. Call the rest. Tracking without collection is diary-keeping. The public calculators (interest, late fee, EMI) are for the number you quote before anyone opens an account. The signed-in book is for tomorrow’s first sale and the payment that should hang off it. Export CSV when the accountant asks. Do not start a second Excel khata after you have imported once.