| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel exits unexpectedly or hangs the second time I open workbook | Excel Discussion (Misc queries) | |||
| Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
| keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
| Find a value in a workbook and return the worksheet name | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Hybrid Mode
