Dukaan Udhaar Khata & Stock Register with Mahendra Singh Deora

A digital udhaar khata and stock register for kirana stores and small shops. Write each credit sale ("Udhaar diya") or payment ("Jama mila") on one line and every customer's running balance updates by itself. The Reminders sheet lists everyone who owes you, biggest first, shows money pending for more than 30 days in red and gives a one-click WhatsApp reminder link with a ready message and your UPI ID. Track stock in and out with low-stock alerts, note the day's cash and UPI sales, and see everything on a colourful Dukaan Dashboard with a 14-day sales chart. Works in Excel and Google Sheets (free on your phone too). No macros, no app, no monthly fee.

Kaagaz wali udhaar diary ab Excel mein! Grahak ko udhaar diya to ek line likho, paise mile to ek line, aur har grahak ka baaki apne aap update hoga. Reminders sheet batayegi kisse kitna lena hai. 30 din se purana udhaar laal (red) dikhega, aur ek click mein WhatsApp reminder message ready! Maal aaya, maal gaya, sab Stock register mein, aur stock kam hote hi "Low – order karo" alert. Roz ki cash + UPI bikri likho aur Dashboard par dukaan ka poora haal dekho. Excel aur Google Sheets dono mein chalega.