aging workbook

  • Thread starter Thread starter mlouie
  • Start date Start date
M

mlouie

I need to create an a/r aging workbook using the following information:

Col A Acct #
Col B Name
Col C Date
Col D Beg Bal
Col E Charges
Col F Payments
Col G New Bal

I've tried pivot tables, queries, but my problem is that except for Beg
Bal, the Charges, Payments, and New Bal change each month. I've tried
setting up a workbook with Beg Bal @ the 1st of Jan., but I need
something that will help me apply new charges and payments, equaling a
new balance, then calculate aging in 30, 60, 90, etc. buckets. Hope
I'm stating this clearly enough.

Any help will be greatly appreciated :)
 
thanks for the link - I'll give it a try to see if the worksheet will
work for us.
mlouie
 
sorry I haven't responded - have been out of the office. Thanks for the
link - the previous file sorta worked but I'm looking forward to
exploring the most recent file. Again, thanks. I'll keep you
informed.
 
PY and Associates

thanks for the AR aging workbook - I've experimented with several
different scenarios using this file as a basis and believe I'm getting
somewhere. again, THANKS :)
mlouie
 
Back
Top