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
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
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"
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
- CG Tax On residential property
- Post Office RD Interest
- Applicable TDS for Purchase of Flat from NRI
- Eway bill for machinery reparing
- Claiming exemption of perquisite for employee-owned car under New Tax Regime in ITR-2
- Under construction property in ITR
- Gift of mutual fund units to daughter
- Upload Level ValidationITR3Category of Defect B/D
- NRI ITR2 account in 2025-26 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.
- Reporting of STCG on Property in ITR
- ITR-4 vs ITR 5
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
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
