Debtor analysis statement
This query is : Resolved
01 November 2011
Please provide me a debtor ageing analysis for the period upto june and upto Sept
Ram Avtar Singh
(Expert)
01 November 2011
see by this link in tally
https://www.tallysolutions.com/website/CHM/TallyERP9/05_REPORTS/Management_Information_System_(MIS)_Reports/02_Display_Receivables/Ageing_Analysis_Report.htm
https://www.tallysolutions.com/website/CHM/TallyERP9/05_REPORTS/Management_Information_System_(MIS)_Reports/02_Display_Receivables/Ageing_Analysis_Report.htm
Ram Avtar Singh
(Expert)
01 November 2011
formula for excel is
=LOOKUP(TODAY()-C7,{0,31,61,91;"0-30","31-60","61-90","90-120"})&" days"
=LOOKUP(TODAY()-C7,{0,31,61,91;"0-30","31-60","61-90","90-120"})&" days"
Ram Avtar Singh
(Expert)
01 November 2011
Download file from this link
https://www.caclubindia.com/share_files/agewise-sundry-debtors-in-excel-24299.asp
https://www.caclubindia.com/share_files/agewise-sundry-debtors-in-excel-24299.asp
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
- How to get money back from delisted company
- ITC not to be taken in accounts & GSTR-3B
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
