+ Reply to Thread
Results 1 to 7 of 7

aging workbook

  1. #1
    Registered User
    Join Date
    05-04-2006
    Posts
    4

    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

  2. #2
    PY & Associates
    Guest

    Re: aging workbook

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

    "mlouie" <mlouie.27aykm_1146778806.593@excelforum-nospam.com> wrote in
    message news:mlouie.27aykm_1146778806.593@excelforum-nospam.com...
    >
    > 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. #3
    PY & Associates
    Guest

    Re: aging workbook

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

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


    "mlouie" <mlouie.27aykm_1146778806.593@excelforum-nospam.com> wrote in
    message news:mlouie.27aykm_1146778806.593@excelforum-nospam.com...
    >
    > 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. #4
    Registered User
    Join Date
    05-04-2006
    Posts
    4

    aging workbook

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

  5. #5
    PY & Associates
    Guest

    Re: aging workbook

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

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

    "mlouie" <mlouie.27cdyn_1146845405.9155@excelforum-nospam.com> wrote in
    message news:mlouie.27cdyn_1146845405.9155@excelforum-nospam.com...
    >
    > 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. #6
    Registered User
    Join Date
    05-04-2006
    Posts
    4

    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.

  7. #7
    Registered User
    Join Date
    05-04-2006
    Posts
    4

    Thumbs up 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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1