Easy Office
LCI Learning

Debtor analysis statement

This query is : Resolved 
Profile Image

Profile Image

(Querist)
01 November 2011 Please provide me a debtor ageing analysis for the period upto june and upto Sept
Profile Image

Ram Avtar Singh

Profile Image

Ram Avtar Singh (Expert)
01 November 2011 see by this link in tally

http://www.tallysolutions.com/website/CHM/TallyERP9/05_REPORTS/Management_Information_System_(MIS)_Reports/02_Display_Receivables/Ageing_Analysis_Report.htm
Profile Image

Ram Avtar Singh

Profile Image

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"
Upgrade to CAclubindia Pro. Subscribe Now!

Profile Image

Ram Avtar Singh

Profile Image

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

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries



Live Budget News and Updates

Trending Online Classes

view all classess
Let's Talk Money: You've Worked Hard for It, Now Make It Work for You
Click here for more bestsellers


Answer Query



Quick Links