Aging Analysis Reports using Excel Pivot Tables - How To

[@chikwaz4500]

Hassan , thanks for the good work, I like the way you combine the excel formulas to solve a business problem. Also your voice is clear and the pace is good. I am now one of your KZbin subscriber.

[@thomasdilushan1180]

Thanks Man! Saved a lot of time.

[@excelexcellence4238]

Very well explained. Helped me in a much bigger way. Thank You for this creation. Highly recommended to subscribe. Smooth teaching.

[@HasaanFazal]

Glad it helped :)

[@shivamrai162]

Good one man, learnt alot

[@joelmessmer6594]

Great explanation, really helpful!

[@ashokanselliah9571]

Really excellent video. Hugely helpful

[@HasaanFazal]

Really happy for you. :)

[@elangoelango1975]

Thanks very useful

[@MB-xc6kv]

So helpful!! Thank you!!

[@satheshk26]

Thanks bro, Helpful

[@mbeemxs]

nice, thank you

[@giccsarl9968]

Thank you, really helpfull

[@HasaanFazal]

Glad it helped!

[@hamzawaheed47]

Excellent Thank You!

[@HasaanFazal]

Glad it was helpful :)

[@mohammedashraf3368]

Thanks a lot

[@madhun8092]

Can u do show this in power query too

[@bhavanipasam3882]

Can u pls text the vlookup formula which u used The video is having very less resolution

[@bindujashwani]

What is the formula if I have to use for a particular Date and not today.as my sales date is changing every day.

[@isranim]

What if need to make it on year wise rather in days??

[@HasaanFazal]

With the same approach as discussed in the video you just need to add as many days. For example for 0-1 year it is 360 or 365 days. For 1-2 years it will be 720-730 days (twice of 360-365 days) Let me know if you have more questions.

[@isranim]

@@HasaanFazal thanks for your prompt response. It's working fine with suggested approach.

[@HasaanFazal]

@@isranim most welcome. glad it helped.

[@oyewolejidesunday8006]

Very insightful video. Excellent report.. how can iget the formula for the =Vlookup(if)(today)(date).. help me with the remaining formula pls🙏

[@danielc4698]

Same here, the first part of the formula works then the rest doesnt, it might be a problem on the settings of excel.

[@sagheerabbas7127]

=VLOOKUP(IF(TODAY()>[@date],TODAY()-[@date],0),statusmsg,2,TRUE)

[@laurenceernestramirez4022]

Sir please can you give me the vlookup and if formula? I can seen it clearly. Thanks in advance

[@gopeshsaha5701]

When a customer made a payment then what will be the coulumn head and how we calculate in aging analysis?

[@HasaanFazal]

The aging analysis essentially contains unpaid invoices only. If an invoice is paid it will not appear in this schedule or simply removed from the list. And the payment received will be recorded in the respective accounts.

[@LCJ-gv3oj]

I need the amount to be collected now along with this wht shud i do ?

[@HasaanFazal]

All the amounts that are past due are actually collectibles. Aging is done to know how many days have passed since they aren't paid. Are you asking to know the total? All the amounts of columns other than "not due" are collectibles.

[@LevinCJ]

@@HasaanFazal thank you

[@lakshmipathiganesan6332]

Thanks for sharing the ageing analysis. One observation is the vlookup formulae you used is unreadable and my request is wherever you use formulaes, please see that you enlarge the screen so that the formulae are visible.

[@pandharinathjoshi6565]

Good sir

[@s2mconsulting986]

I just add another column where I work out the number of days, and then do a Grouping on the number of days with intervals of 30.

[@shambhum1829]

Please zoom the videos

[@nitinnasik1]

Unable to apply the formula

[@HasaanFazal]

Please share the error you are getting

[@bhavanipasam3882]

Hi

[@jyothicrafts5794]

good explanation but video is not clear...

[@HasaanFazal]

Thanks for watching. Would like to know what's not clear in the video?

[@danielc4698]

@@HasaanFazal I type exactly the same formula as you and the complete formula does not work.