Bahi khata likhna mushkil nahi hai. Ek customer ke liye ek page, har entry ki date, kitna udhar diya, kitna paisa mila, aur har baar naya balance. Bas itna hi.
Mushkil tab hoti hai jab entries chhoot jaati hain, balance galat jud jaata hai, ya customer kehta hai "maine to de diye the". Is guide mein hum ek simple format dekhenge, ek poora example, aur woh galtiyan jo sabse zyada hoti hain.
Bahi khata mein kya likhna zaroori hai
Har entry mein char cheezein honi chahiye:
- Date: entry kis din hui.
- Vivaran (detail): kis cheez ka udhar, ya kis tarah paisa mila (cash, UPI).
- Udhar ya jama: customer ko saaman ya paisa diya (udhar), ya customer ne paisa diya (jama).
- Balance: ab customer ke upar kitna baaki hai.
Agar in chaar mein se ek bhi missing hai, to baad mein hisab milana mushkil ho jaata hai.
Step 1: Har customer ka alag page banaye
Ek page par ek hi customer. Upar customer ka naam aur phone number likhein. Aise do customers ki entries mix nahi hongi, aur "Ramesh ka kitna baaki hai" ka jawab ek hi page se mil jaayega.
Agar customer ka pehle se kuch baaki hai, to page ki pehli line mein pichla baaki (opening balance) likhein. Wahin se aapka hisab shuru hoga.
Step 2: Columns banaye
Ek page par yeh columns rakhein:
| Date | Vivaran | Udhar (aapne diya) | Jama (aapko mila) | Balance |
|---|
- Udhar wale column mein woh likhein jo aapne customer ko saaman ya paisa diya.
- Jama wale column mein woh likhein jo customer ne aapko diya.
- Balance mein har baar naya total likhein, taaki aakhri line dekhte hi baaki dikh jaaye.
Step 3: Har entry usi din likhein
Entry usi din likhein jis din lena-dena hua. Hafte ke end mein yaad se likhne par amount aur date dono galat hone ka khatra rehta hai. Chhoti entry bhi likhein, kyunki chhoti entries hi sabse zyada bhoolti hain.
Step 4: Balance kaise nikalein
Formula simple hai:
Naya balance = pichla balance + udhar − jama
Jab aap udhar dete hain, balance badhta hai. Jab customer paisa deta hai, balance kam hota hai.
Poora example
Ramesh Sharma ka page. Pichla baaki ₹1,200 hai.
| Date | Vivaran | Udhar | Jama | Balance |
|---|---|---|---|---|
| 01 Oct | Pichla baaki | ₹1,200 | ||
| 03 Oct | Ration ka saaman | ₹450 | ₹1,650 | |
| 07 Oct | Cash mila | ₹1,000 | ₹650 | |
| 12 Oct | Saaman | ₹300 | ₹950 | |
| 20 Oct | UPI se mila | ₹500 | ₹450 |
Check karne ke liye totals jodiye: pichla baaki ₹1,200 + udhar (₹450 + ₹300 = ₹750) − jama (₹1,000 + ₹500 = ₹1,500) = ₹450. Aakhri balance bhi ₹450 hai, yaani hisab sahi hai.
Mahine ke end mein ek baar aise hi totals jod kar dekhna achhi aadat hai.
Sabse common galtiyan
- Balance column chhod dena. Phir har baar poora jodna padta hai.
- Date na likhna. Customer kehta hai "mera to pichle mahine ka de diya tha", aur aapke paas koi date nahi hoti.
- Udhar aur jama ek hi column mein likhna. Plus aur minus mil jaate hain.
- Customer ka page doosre ke saath share karna. Ek page par ek hi naam.
- Kaata hua ya mita hua page. Galti ho jaaye to line ko cross karke neeche nayi entry likhein, mitaayein nahi.
Agar customer kam hain, to bahi khata theek hai
Kam customers aur kam lena-dena ho to kagaz ka bahi khata bilkul kaam karta hai. Dikkat tab aati hai jab customers badh jaate hain: page dhoondhna, balance jodna, aur reminder dena sab haath se karna padta hai.
Aise mein aap yahi format BahiQo mein bhi rakh sakte hain. Customer ke saath You Gave (udhar) aur Payment Received (jama) entries likhi jaati hain, aur balance har baar apne aap nikalta hai. Aap pehle se likhe hue customers ko CSV se import bhi kar sakte hain, aur customer ko PDF statement WhatsApp par bhej sakte hain. Detail ke liye digital bahi khata kya hai padhein.
Dhyan dein: App aapke liye entries likhta nahi hai. Lena-dena aapko hi darj karna hota hai. App sirf balance, due date aur statement ka kaam sambhalta hai.
Kagaz par hi chalana hai to hamara free bahi khata format PDF aur Excel mein download kar sakte hain.
Aksar poochhe jaane wale sawal
Bahi khata mein jama aur udhar ka matlab kya hai?
Udhar woh hai jo aapne customer ko diya ya jo customer ne le liya aur abhi paisa nahi diya. Jama woh hai jo customer ne aapko diya. Balance dono ka antar hai.
Kya main bahi khata Excel mein likh sakta hoon?
Haan, kar sakte hain, lekin Excel mein formula ya sort galat ho jaaye to balance bigad jaata hai. Dono ka comparison yahan padhein.
Customer paisa na de to kya karein?
Date ke saath poori entry rakhein aur customer ko statement bhejein. Tarike udhar vasooli guide mein diye hain.
Kya BahiQo free hai?
Account banana aur ledger entries likhna free hai.
