TallyPrime me Outstanding Report Kaise Nikale – Bill-wise & Age-wise Guide
TallyPrime mein Outstanding Report ek bahut powerful feature hai. Isse aap clearly dekh sakte ho ki:
- Kis customer se kitna paise lena hai (Receivables)
- Kis supplier ko kitna paise dena hai (Payables)
- Kaunse bills overdue ho chuke hain
- Kitne din se payment pending hai (Age-wise)
Agar aap regular Outstanding Report nahi nikaalte to aapka cash flow control nahi rahega. Is article mein hum step-by-step seekhenge ki TallyPrime mein Outstanding Report kaise nikale, uske different types kya hain, practical examples, aur common problems ka solution.
Yeh guide beginners aur intermediate users dono ke liye useful hai.
![]() |
TallyPrime Outstanding Report – Bill-wise & Age-wise Complete Guide |
Outstanding Report Kya Hota Hai?
Outstanding Report ek aisi report hai jo batati hai ki aapke business ke pending payments kahan-kahan hain.
Do main types hote hain:
- Receivables (Sundry Debtors) – Customers se lene wale paise
- Payables (Sundry Creditors) – Suppliers ko dene wale paise
Iske alawa aap Age-wise bhi dekh sakte ho ki bill 30 din, 60 din, ya 90 din se pending hai.
TallyPrime me Outstanding Report Kaise Nikale (Step-by-Step)
Method 1: Simple Outstanding Report
- TallyPrime open karo
- Gateway of Tally pe jaao
- Display More Reports pe click karo
- Analysis & Verification select karo
- Outstanding pe click karo
Ab aapko options milenge:
- Receivables
- Payables
- Ledger-wise
- Group-wise
- Bill-wise
Method 2: Direct Path (Faster)
Gateway of Tally → Display → Statements of Accounts → Outstanding
Ya phir:
Gateway of Tally → Display More Reports → Statements of Accounts → Outstanding
Outstanding Report ke Different Types
1. Bill-wise Outstanding
Isme har invoice/bill alag-alag dikhta hai.
Sabse detailed aur useful report yahi hoti hai.
Kab use karein:
Jab aapko exact pata karna ho ki kaunsa bill pending hai.
2. Ledger-wise Outstanding
Isme party (customer/supplier) ka total outstanding amount dikhta hai.
Bill details nahi dikhte.
Kab use karein:
Jab sirf total lene/dene ka amount dekhna ho.
3. Group-wise Outstanding
Sundry Debtors ya Sundry Creditors group ka overall outstanding dikhta hai.
4. Age-wise Outstanding (Bahut Important)
Isme aap dekh sakte ho:
- 0–30 days
- 31–60 days
- 61–90 days
- 90+ days
Fayda:
Purane pending bills pe follow-up karna easy ho jata hai.
Bill-wise Outstanding Enable Kaise Karein?
Agar aapko Bill-wise report nahi dikh rahi to pehle yeh setting on karni hogi:
- Gateway of Tally → F11 (Features)
- Accounting Features pe jaao
- Maintain Bill-wise Details → Yes kar do
- Save karo (Ctrl + A)
Ab jab aap Sales ya Purchase voucher banayenge to Tally Bill Name aur Due Date poochega. Isse Bill-wise Outstanding sahi kaam karega.
Practical Example
Maan lo aapki company mein yeh pending hain:
| Party Name | Bill No. | Amount | Days Pending |
|---|---|---|---|
| Rahul Traders | INV-101 | ₹45,000 | 25 days |
| Rahul Traders | INV-108 | ₹30,000 | 55 days |
| Priya Enterprises | INV-95 | ₹60,000 | 80 days |
| Supplier - Amit | BILL-44 | ₹25,000 | 15 days |
Outstanding Report se aap dekhoge:
- Receivables Total: ₹1,35,000
- Payables Total: ₹25,000
- Age-wise mein Priya Enterprises ka bill 90 days ke qareeb dikhega → follow-up priority
Isse aap easily decide kar sakte ho ki pehle kisse recovery karni hai.
Outstanding Report Filters Kaise Use Karein?
Report open hone ke baad aap yeh filters laga sakte ho:
- F2 – Period change
- F12 – Configuration (Ageing analysis on/off, bill-wise details etc.)
- Alt + F5 – Detailed / Condensed view
- Party ke upar jaakar Enter dabane se uske saare pending bills dikh jaate hain
Pro Tip:
Ageing Analysis ko Yes rakhne se report bahut powerful ho jati hai.
Receivables vs Payables Report
| Report Type | Kya Dikhta Hai | Kab Use Karein |
|---|---|---|
| Receivables | Customers se lene wale paise | Recovery follow-up ke liye |
| Payables | Suppliers ko dene wale paise | Payment planning ke liye |
| Both | Lene aur dene dono | Overall cash flow samajhne ke liye |
Common Problems aur Solutions
| Problem | Solution |
|---|---|
| Bill-wise outstanding nahi dikh raha | F11 → Maintain Bill-wise Details → Yes |
| Ageing nahi aa raha | Report mein F12 → Ageing Analysis → Yes |
| Galat amount dikh raha hai | Pending invoices check karo, credit note adjust kiya hai kya |
| Party ka outstanding zero dikha raha | Bill-wise details voucher mein diya tha ya nahi check karo |
| Report empty aa rahi hai | Period sahi select kiya hai kya (F2) |
Outstanding Report se Related Important Tips
- Har hafte Outstanding Report nikaalo.
- 60+ days ke pending bills pe jaldi follow-up karo.
- Bill-wise system regularly use karo.
- Credit Note / Debit Note ko sahi se link karo taaki outstanding auto adjust ho.
- Large companies mein Cost Centre ke saath bhi Outstanding dekh sakte ho.
- Report ko Excel mein export karke team ko de sakte ho.
TallyPrime me Outstanding Report ke Advanced Options
- Group Outstandings – Multiple parties ka combined view
- Ledger Outstandings – Single party ka detailed view
- Age-wise Analysis – Days ke hisaab se sorting
- Negative Outstanding – Agar kisi party ka advance hai to wo bhi dikhta hai
- Export – Excel, PDF mein nikaal sakte ho
Frequently Asked Questions (FAQs)
Q1. TallyPrime me Outstanding Report kahan se nikale?
Ans: Gateway of Tally → Display More Reports → Analysis & Verification → Outstanding
Ya Display → Statements of Accounts → Outstanding.
Q2. Bill-wise Outstanding kyun nahi dikh raha?
Ans: F11 Features mein “Maintain Bill-wise Details” ko Yes karein.
Q3. Age-wise Outstanding kaise enable karein?
Ans: Outstanding Report open karke F12 dabayein aur Ageing Analysis ko Yes karein.
Q4. Receivables aur Payables mein kya farak hai?
Ans: Receivables = Customers se lene wale paise
Payables = Suppliers ko dene wale paise.
Q5. Kya Outstanding Report Excel mein nikaal sakte hain?
Ans: Haan. Report open karke Export option use karein.
Q6. Outstanding amount galat aa raha hai to kya karein?
Ans: Related sales/purchase vouchers, credit notes aur receipts check karein. Bill-wise linking sahi hai ya nahi dekhein.
Q7. Kya ek party ka alag se outstanding dekh sakte hain?
Ans: Haan. Ledger-wise Outstanding mein us party ko select karein ya report mein uske upar Enter dabayein.
Q8. 90 days se zyada pending bills kaise filter karein?
Ans: Age-wise Outstanding report use karein. Wahan 90+ days ka column dikhega.
Q9. Outstanding Report kitni baar nikaalna chahiye?
Ans: Kam se kam hafte mein ek baar. Behtar hai ki 2-3 din mein ek baar check karo.
Q10. TallyPrime me outstanding clear kaise hota hai?
Ans: Jab aap Receipt (customer se) ya Payment (supplier ko) voucher mein usi bill ko adjust karte ho to outstanding automatically clear ho jata hai.
Q11. Kya advance payment outstanding mein dikhta hai?
Ans: Haan, negative outstanding ke roop mein dikh sakta hai.
Q12. Mobile app se Outstanding Report dekh sakte hain kya?
Ans: TallyPrime Remote / TallyPrime Server setup ho to related apps se dekh sakte hain, lekin mainly desktop pe best detail milti hai.
Conclusion
TallyPrime ka Outstanding Report aapke business ke cash flow ko control karne ka sabse best tool hai. Bill-wise aur Age-wise reports regular use karne se aapko clearly pata chalega ki paise kahan phanse hue hain aur kisko pehle follow-up karna hai.
Yaad rakhne layak points:
- Bill-wise Details hamesha enable rakho
- Ageing Analysis on rakho
- Regular report nikaalo
- 60+ days ke bills pe special dhyan do
Agar aap yeh report discipline ke saath use karenge to aapka recovery system bahut strong ho jayega.
