| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Pay a service provider to do it for you is simplest please
"mlouie" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > 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 > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Please see if the attached file is close to what you want
http://www.savefile.com/files/3363566 "mlouie" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > 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 > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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 |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| aging | =?Utf-8?B?cmluYQ==?= | Microsoft Excel Worksheet Functions | 2 | 23rd Oct 2006 05:50 PM |
| Please, need help with A/R aging | Jim Evans | Microsoft Access Queries | 4 | 15th Feb 2006 05:05 AM |
| Macros for the AR Aging Workbook template? | =?Utf-8?B?VXJzdWxh?= | Microsoft Excel Worksheet Functions | 0 | 15th Sep 2005 08:52 PM |
| 00-30/31-60/61-90/Over-90 Aging | Gary B | Microsoft Access Queries | 16 | 15th Jul 2005 11:06 AM |
| AR Aging | Melody | Microsoft Access Queries | 2 | 8th Mar 2004 07:51 PM |
