How to Track Udhaar (Khata) Digitally for Your Shop

Udhaar (khata) is how most Indian shops sell — the customer takes goods now and pays later. The problem is never the sale; it is remembering who owes how much. This guide shows how to track udhaar khata digitally: record each credit sale against a named customer, let a running balance do the maths, and use a simple ledger to collect your dues without awkward guesswork. No accounting background needed.

Why a paper udhaar diary starts to hurt

A paper khata works for the first few names. Then a page fills up, a payment gets noted on the wrong line, someone disputes “₹500 ya ₹700?”, and at month-end you are re-adding columns by hand. The money is real, but the record is fragile.

A digital khata fixes the three things a diary can’t:

• A running balance that’s always correct — every sale adds, every payment subtracts, automatically.
• One place per customer — their whole history on a single screen, not spread across three pages.
• A backup — the diary can’t be torn, soaked, or lost.

Set it up once: customers as “parties”

Instead of a page per person, you add each regular credit customer once as a party (their name, phone, and — if they are a registered business — their GSTIN). From then on, every udhaar sale you bill to that name lands in their account automatically. You do the setup once; the software does the tallying forever.

How to track udhaar khata digitally, day to day

The moment matters here. When you make an udhaar sale, you still create a normal bill — you just mark it unpaid (or partially paid) instead of cash. If your shop is GST-registered, that is a full tax invoice, and the GST is counted for that period even though the customer hasn’t paid yet (confirm the current rule on gst.gov.in or with your CA).

A worked example

Meena runs a provision store in Madurai, Tamil Nadu. Suresh, a regular, buys on udhaar. His first bill:

Tax Invoice   No: INV2026-27/0042   Date: 02/07/2026
Bill to: Suresh          Place of supply: Tamil Nadu (33)
-----------------------------------------------------------
Item          HSN    Qty   Rate    Taxable   GST    Amount
Cooking oil   1512   5 L   200     1,000.00  5%     1,050.00
-----------------------------------------------------------
              Taxable value:      1,000.00
              CGST (2.5%):           25.00
              SGST (2.5%):           25.00
              TOTAL:            ₹ 1,050.00   (UNPAID)

Because buyer and seller are both in Tamil Nadu, this is an intra-state sale, so the 5% splits into CGST 2.5% (₹25) + SGST 2.5% (₹25). If Suresh were in another state, it would be a single IGST 5% (₹50) line instead — the total is the same ₹1,050, but the tax routing differs. (Confirm the current rate for your items on cbic.gov.in.)

Now watch Suresh’s khata as the month goes on:

His closing balance is ₹1,000 — and you never added a single column. Each row just moved the balance up (a sale) or down (a payment).

Reading your dues at a glance

Once every udhaar sale and payment flows into parties, three quick views tell you everything a shopkeeper needs:

• Outstanding per customer — a live figure next to each name: green when they owe you, a dash when they’re settled.
• Receivables aging — how much each customer owes and how old the dues are, so you chase the oldest money first.
• A shareable statement — open a customer’s full ledger for any period and export it, so “here’s your account, please clear it” is a document, not an argument.

Collecting the money (without the friction)

Digital khata makes the follow-up calmer:

1. Sort by oldest/largest dues and start there — that’s where your working capital is stuck.
2. Send a gentle reminder with the exact balance and a statement, so there’s nothing to dispute.
3. Record the payment the moment it lands (cash or UPI). Part-payments are fine — the balance simply drops, and the leftover stays as their new dues.
4. Set a credit limit for customers who tend to run up a long tab, so you get a nudge before it grows.

Doing this with Yojika

Yojika is offline-first GST billing software for Indian small shops, and party dues are built in. You add each customer once, mark a bill as unpaid to record an udhaar sale, and Yojika keeps a running Outstanding balance for every party — netting sales, payments, and advances on its own. You can open any party’s full statement, export it to share, see receivables aging to know who owes you the most, set a credit limit, and flag a payment reminder — all on your own PC, so your khata stays private and works even when the internet doesn’t.

• See what’s included on the features page.
• Check simple, transparent pricing on the pricing page.
• Or download Yojika and try it free for 14 days.

New to computerised billing? Start with our guide to offline billing software for a retail shop, or set up your counter printer with thermal printer setup for billing.

This article is general information, not tax advice. GST rules and thresholds change — confirm the current position on gst.gov.in or with your CA.