Aging Report

A

Abdul Shakeel

I ve worksheet with
Supplier Name
Inv No.
Inv Date
Amount
I wmant to make an aging report, could it possible with pivot table
 
F

Fred Smith

By aging report, I assume you mean you want columns for 30, 60, 90+ days
overdue.

To do this in a pivot table, first create extra columns for the invoice age.
While you are at it, I'd also create a column called 'Age' which is the
number of days overdue. This makes aging simpler and might come in handy in
the future. Your columns would then include something like:

Age: =today()-InvDate
Current: =if(age<30,amount,"")
30-59: =if(and(age<60,age>=30),amount,"")
etc.

Now you can pivot the columns easily.

Regards,
Fred
 
Top