Tax and GST

Recording credit sales to regular shop customers

How to record credit sales to regular shop customers: a customer-wise sheet for udhar, payments received and dues, with a weekly review.

Editorial illustration for Recording credit sales to regular shop customers

Keep one page or one sheet row per regular customer with four numbers: what they owed at the start, what you sold on credit, what they paid and what they owe now. Write every entry the same day and review the closing balances once a week. That is all an udhar record needs to stop dues from being forgotten.

What should each customer's entry contain?

  • Customer name and a phone number, so you can reach them.
  • Date of each credit sale, with the bill or slip number if you issue one.
  • The amount sold on credit, and what was bought if you want to settle a dispute later.
  • Date, amount and mode of every payment received (cash, UPI or transfer).
  • The running balance after each entry.

A worked example: a general store with six regular customers

Say a general store tracks six regular customers for one month. These figures are made up, but the method is real.

CustomerOpening dueCredit salesReceivedClosing due
Sharma ji₹1,200₹3,450₹2,000₹2,650
Verma₹0₹1,880₹1,880₹0
Gupta₹4,500₹2,100₹1,000₹5,600
Khan₹800₹1,250₹800₹1,250
Iyer₹2,300₹960₹2,300₹960
Patel₹0₹3,200₹1,500₹1,700

Each row works out as opening plus sales minus received; Sharma ji, for instance, is 1,200 plus 3,450 minus 2,000, which is 2,650. Across the six rows, opening dues total ₹8,800, credit sales ₹12,840 and receipts ₹9,480. So the total owed at month end is 8,800 plus 12,840 minus 9,480, which is ₹12,160. The closing column adds up to the same ₹12,160, which confirms the sheet is consistent.

How do you review it every week?

  1. Sort the sheet by closing due, largest first.
  2. Look at the top three and decide who to remind, and how: a polite message, a visit, or a word when they next come in.
  3. Look for customers whose dues rise every week without any payment. Those need a conversation about a limit.
  4. Check that every received amount is also in your cash book or bank statement, so the same rupee is not recorded twice.
  5. Write the date of the next reminder beside each name.

How do you set a limit without upsetting anyone?

Decide a limit for each customer privately, based on how reliably they pay, and tell them kindly when they approach it: Gupta ji, the account has come to ₹5,600, could you clear some this week? Most people respond well to specifics. Write down what was agreed, such as a date by which they will pay.

What if a customer disputes the amount?

Disputes are easier when entries are dated and slips exist. Show the customer the dated lines and compare with their own memory or slips. If you find a mistake on your side, correct it with a new line and a note rather than overwriting the old figure. If the customer is simply late, that is a reminder, not a dispute, so keep the tone friendly and the record plain.

What about festival months?

Credit often rises before festivals and wedding seasons, and collection slows after. Review twice a week in those periods, and avoid carrying dues across the financial year end without a note, because the April to March accounts will show them as receivables.

Small habits that help

  • Give a slip for every credit sale so that the customer's and your record can be compared.
  • Never write dues only in your head or only on loose paper.
  • Keep a single book or sheet per shop, not one per staff member.
  • Ask your CA how long-overdue dues should be shown in your accounts.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports