Aging Analysis Reports using Excel Pivot Tables - How To

In this free Excel tutorial we are learning how to do conduct aging analysis using Excel Pivot Tables in few very simple steps.

Using Excel Pivot Tables allows us to make flexible reports that can be customized in few clicks and help you make important accounting and managerial decisions quickly.

In this tutorial, we will start with simple customer/supplier data with invoices to do aging or ageing analysis and quickly get a full functional aging report of our customers/suppliers invoices.

Read more about aging analysis in Excel:

Like | Follow:

!! Get FREE Excel CORE BOOK:

#MSExcel #AgingAnalysis #ExcelforAccountants

[chikwaz]

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 YouTube subscriber.

[excelexcellence]

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

[ashokanselliah]

Really excellent video. Hugely helpful

[isranim]

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

[oyewolejidesunday]

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

[lakshmipathiganesan]

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.

[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.

[bhavanipasam]

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

[gopeshsaha]

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

[laurenceernestramirez]

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

[LCJ-gvoj]

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

[smconsulting]

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.

[jyothicrafts]

good explanation but video is not clear...