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 me Outstanding Report Kaise Nikale Bill-wise Age-wise Guide

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:

  1. Receivables (Sundry Debtors) – Customers se lene wale paise
  2. 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

  1. TallyPrime open karo
  2. Gateway of Tally pe jaao
  3. Display More Reports pe click karo
  4. Analysis & Verification select karo
  5. 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:

  1. Gateway of Tally → F11 (Features)
  2. Accounting Features pe jaao
  3. Maintain Bill-wise DetailsYes kar do
  4. 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 NameBill No.AmountDays Pending
Rahul TradersINV-101₹45,00025 days
Rahul TradersINV-108₹30,00055 days
Priya EnterprisesINV-95₹60,00080 days
Supplier - AmitBILL-44₹25,00015 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 TypeKya Dikhta HaiKab Use Karein
ReceivablesCustomers se lene wale paiseRecovery follow-up ke liye
PayablesSuppliers ko dene wale paisePayment planning ke liye
BothLene aur dene donoOverall cash flow samajhne ke liye

Common Problems aur Solutions

ProblemSolution
Bill-wise outstanding nahi dikh rahaF11 → Maintain Bill-wise Details → Yes
Ageing nahi aa rahaReport mein F12 → Ageing Analysis → Yes
Galat amount dikh raha haiPending invoices check karo, credit note adjust kiya hai kya
Party ka outstanding zero dikha rahaBill-wise details voucher mein diya tha ya nahi check karo
Report empty aa rahi haiPeriod sahi select kiya hai kya (F2)

Outstanding Report se Related Important Tips

  1. Har hafte Outstanding Report nikaalo.
  2. 60+ days ke pending bills pe jaldi follow-up karo.
  3. Bill-wise system regularly use karo.
  4. Credit Note / Debit Note ko sahi se link karo taaki outstanding auto adjust ho.
  5. Large companies mein Cost Centre ke saath bhi Outstanding dekh sakte ho.
  6. 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.

Previous Post
No Comment
Add Comment
comment url