aging workbook
 

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 :)


--
mlouie
------------------------------------------------------------------------
mlouie's Profile: http://www.excelforum.com/member.php...o&userid=34137
View this thread: http://www.excelforum.com/showthread...hreadid=539072

aging workbook
 

Pay a service provider to do it for you is simplest please

"mlouie" wrote in
message ...

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 :)


--
mlouie
------------------------------------------------------------------------
mlouie's Profile:
http://www.excelforum.com/member.php...o&userid=34137
View this thread: http://www.excelforum.com/showthread...hreadid=539072

aging workbook
 

Please see if the attached file is close to what you want

http://www.savefile.com/files/3363566


"mlouie" wrote in
message ...

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 :)


--
mlouie
------------------------------------------------------------------------
mlouie's Profile:
http://www.excelforum.com/member.php...o&userid=34137
View this thread: http://www.excelforum.com/showthread...hreadid=539072

aging workbook
 

thanks for the link - I'll give it a try to see if the worksheet will
work for us.
mlouie


--
mlouie
------------------------------------------------------------------------
mlouie's Profile: http://www.excelforum.com/member.php...o&userid=34137
View this thread: http://www.excelforum.com/showthread...hreadid=539072

aging workbook
 

We believe this file is what you want.
Please modify for your own need.

http://www.savefile.com/files/1886240

"mlouie" wrote in
message ...

thanks for the link - I'll give it a try to see if the worksheet will
work for us.
mlouie


--
mlouie
------------------------------------------------------------------------
mlouie's Profile:
http://www.excelforum.com/member.php...o&userid=34137
View this thread: http://www.excelforum.com/showthread...hreadid=539072

aging workbook
 

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.


--
mlouie
------------------------------------------------------------------------
mlouie's Profile: http://www.excelforum.com/member.php...o&userid=34137
View this thread: http://www.excelforum.com/showthread...hreadid=539072

aging workbook
 

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


--
mlouie
------------------------------------------------------------------------
mlouie's Profile: http://www.excelforum.com/member.php...o&userid=34137
View this thread: http://www.excelforum.com/showthread...hreadid=539072