Ageing Analysis in Excel Using IF Formula & PivotTables | Accounts Receivable Report

[@IvanCortinas_ES]

Excellent tutorial Chester. Thanks for your telling it so well.

[@Liyan-s4d]

Thanks for sharing. It's clear & helpful.

[@ramcacpa]

Really Good Explanation and Easy to understand Thanks

[@makeupwow11]

Thank you. It’s really good and easy to understand.👍👍👍👏

[@EleftheriosIoannidis-n2n]

Very good tutorial. Thank you

[@economiaustm716]

Thank you for the tutorial, it helped so much

[@patirawongsom3510]

Thank you, it's very helpful

[@rickytelavika7211]

in the detail work sheet, how could I include comments, contact person ands number, date time called customer

[@GoClimbUp-t7n]

Thank you so much for this vedio, really saved my ass** for Monday presentation .

[@mahaboobbasha5993]

Thanks for sharing this video, could you please explain once how does it work data model in pivot table.

[@smitachafekar6592]

Thanks alot❤

[@faizajawaid-x6n]

i have aging days for SKU "X". i bought this sku 3 times in last 80 days. first time 5, second time 10, 3rd time 7 units. now i have total quantity of 17. my aging return time is under 90 days. how i will calculate aging

[@seanain1]

Thank You Sir

[@subashsharma2231]

if payment receive earlier what to do

[@marcoscardona3191]

Hello can you explain why is that the days overdue is 101? Thank you.

[@nitishdhawan1297]

The due date is 5 june so as on september it is 101 days due

[@mangalapradeep2006]

Thank you sir

[@thegreatmarvinoliveros]

What if accounts have several credit terms apart from 30 days.

[@jacktan3163]

You can have a separate table with the customer and credit terms. Then use xlookup or vlookup to get the respective credit terms and apply it to the due date formula depending on the condition that is the customer. Easier way is to add one column for credit terms to hold this information instead. I have in fact something else, what if you also want to show partially paid invoices or invoices (only from a cerain date onwards) that have been paid in the same table.

[@2klatte]

Thanks, understand that the spilled array won’t let you create a table, but you didn’t address what how to fix the data in order to map the data into a pivot table…..

[@rebeccasamuel4064]

thank you

[@rickytelavika7211]

I actually want to design the same kind of report where by I could have it accessible to my staffs

[@finmatrixparadigm7904]

Fantastict

[@vipin_rahul]

Thanks

[@sunracemangesh]

Team...need your help ..I am working on formula for ageing bucket... Here formula is taken from approved date ( Column B) ... Now If there is no approved date then need to take the created date ( column A). I tried isblank but not able to go ahead .. Request if can help please