Free bahi khata format (PDF and Excel)
Ek simple bahi khata format jo har dukan ke kaam aaye: ek customer ka ek page, udhar aur jama alag columns mein, aur har entry ke baad balance. PDF print karke haath se bharein, ya Excel mein balance apne aap nikalwayein.
Free. No sign-in needed.
Format mein kya hai
Har page par ek customer ka khata hai: Page ke upar customer ka naam, phone number aur pichla baaki likhne ki jagah hai. Neeche ek total line hai jahan aap mahine ke end mein udhar, jama aur balance jod sakte hain.
| Date | Vivaran (detail) | Udhar (aapne diya) | Jama (aapko mila) | Balance |
|---|---|---|---|---|
| Pichla baaki |
Kaise bharein
Poora samjhaya hua example bahi khata kaise likhe guide mein hai.
- Customer ka naam aur phone number likhein.
- Agar pehle se kuch baaki hai to pehli line mein pichla baaki likhein.
- Har entry usi din likhein: date, kis cheez ka, aur amount.
- Udhar diya to Udhar column mein, paisa mila to Jama column mein likhein.
- Har entry ke baad naya balance likhein: pichla balance + udhar − jama.
Excel version mein balance kaise nikalta hai
Excel file mein balance formula pehle se laga hai. Aap khud banana chahein to: Phir E4 ko neeche ki rows tak kheench dein. Har naye udhar par balance badhta hai, har jama par kam hota hai. Seedha tareeka =E3+C4-D4 bhi chalta hai, bas beech mein koi row khaali nahi chhodni. Kai customers hain to har customer ke liye alag sheet rakhein, aur ek Summary sheet mein har sheet ka aakhri balance jodein. Excel mein customers badhne par yeh sambhalna mushkil ho jaata hai. Dono tareeke ka comparison yahan padhein.
| Cell | Kya hai |
|---|---|
E3 | Pichla baaki (opening balance) |
C4 | Udhar |
D4 | Jama |
E4 | =$E$3+SUM($C$4:C4)-SUM($D$4:D4) |
Print karne ke tips
- A4 par print karein. Excel mein page ko Landscape karna aasan rehta hai.
- Ek customer ek page. Page bhar jaaye to naya page lein aur pehli line mein pichla balance likhein.
- Pen se likhein. Galti ho to line cross karein aur neeche nayi entry karein.
Customer ko statement dena ho to
Customer ko apna baaki dikhana ho to is page ki photo ya PDF bhejna kaafi nahi hota. Ek saaf statement ka format customer statement format mein diya hai.
Jab kagaz ya Excel kam padne lage
Customers badhne par page dhoondhna, balance jodna aur reminder dena sab haath se karna padta hai. Isi liye BahiQo hai: ek free digital bahi khata jisme har customer ke You Gave aur Payment Received entries likhne par balance apne aap nikalta hai. Pehle se likhe hue customers ko CSV se import kar sakte hain, aur PDF statement WhatsApp par bhej sakte hain. BahiQo bahi khata app dekhein · Download karein
Dhyan dein: App lena-dena aapke liye nahi likhta. Entries aapko hi darj karni hoti hain. App balance, due date aur statement ka kaam sambhalta hai.
Common questions
Kya yeh format free hai?
Haan. PDF aur Excel dono free download hain, aur kisi sign-in ki zaroorat nahi.
Kya main is format mein apni dukan ka naam daal sakta hoon?
Haan. Excel file mein upar header badal sakte hain. PDF ke liye blank jagah chhodi gayi hai.
Udhar aur jama mein kya antar hai?
Udhar woh hai jo aapne customer ko diya, jama woh hai jo customer ne aapko diya. Balance dono ka antar hai.
Kya main apna purana khata app mein laa sakta hoon?
Haan, customers aur entries ko CSV file se import kar sakte hain.