Udhar bookkeeping without a second notebook

Udhar bookkeeping goes wrong when sales live in one book and collections in another. Keep both on the same customer. Credit sales increase remaining amount. Confirmed payments reduce it. Notes and reminders sit beside the balance so the next visit is not a memory test. That is the whole method. A second notebook is how “I paid you in June” becomes unanswerable in August.

One customer, one remaining due

Write the sale as line items: who, what, qty, rate, due date. When money comes in, hang the payment on those items, not on a running total you keep in your head. Remaining due is then a server-side fact. If you keep a paper total and an Excel total and an app total, you will believe whichever one is kindest today. Pick one book. Export CSV if you need a copy for the accountant. Do not type the same sale in three places.

Cash confirmed is paid. UPI is pending until you open the screenshot. That pending state is bookkeeping, not distrust. A transfer that never landed is the classic paper fight. The khata should still show the due until you tap confirm, and a declined attempt should stay in history so you are not accused of “eating” a payment you never received.

Villages and routes

If you collect by village, group the customer list that way. If you collect by walking a route, store a location and start from the nearest overdue name. Neither requires a full CRM. You need a filter and a map pin, not a pipeline. The shops that fail udhar bookkeeping are not the ones without software. They are the ones whose Thursday round is a memory of who lives on which lane.

Import once

If the old khata is Excel, download the bulk template, fill the open dues, and import. After the first import, stop maintaining the spreadsheet as a second source of truth. A second import is a new set of sales. It will not “sync edits” back from the sheet. Names that appear twice in the same village merge. Put a last name or a village on the second Ramesh so he does not vanish into the first.

Public shop pages, if you turn them on, show a catalog and a call button. They never show balances. Udhar stays between you and that customer after they sign in with the mobile you already have. That split is the difference between a shareable catalog and a leaked khata.