How to reconcile Accounts Payable

Discussion in 'Microsoft Accounting' started by Richard, Nov 14, 2006.

  1. Richard

    Richard Guest

    My general ledger A/P account does not match the historical A/P Aging. The
    same goes for my A/R. Can anyone help me figure this out?
     
    Richard, Nov 14, 2006
    #1
    1. Advertisements

  2. Richard

    SumCPA Guest

    It might help if you described how you created the balances. Were they
    migrated from another program? If so, were individual invoices and bills
    added or were the customer and vendor opening balances entered as a single
    dollar amount? Are both the general ledger report date and the Aging
    reports' dates all set to the same date? I'm really curious how this
    happened!

    "Richard" wrote:

    > My general ledger A/P account does not match the historical A/P Aging. The
    > same goes for my A/R. Can anyone help me figure this out?
     
    SumCPA, Nov 15, 2006
    #2
    1. Advertisements

  3. Richard

    RICHARD Guest

    I have the A/P - A/R defualts set at "Batch entry". The report dates are set
    the same. I posted all batches from the A/P and A/R modules. This situation
    just happen prior month. I have been trying to figure this out for the last
    week.

    In the past 5 months, my A/P and A/R balance to my G/L. Therefore, the
    problem happened in October. I have tracked down a few Audit trails that did
    not post to the G/L. I am in the process of figuring out what accounts did
    the entries post.

    I am having a problem with my A/P month ending aging report and my month end
    A/P G/L account. The balances are off. I have some entries not posted to
    the G/L and some not in the A/P module. Therefore, I am trying to reconcile
    the A/P Aging vs. the A/P G/L. I am trying to find out what happen and how
    to fix it.

    This is the same issue with My A/R vs. my G/L.

    I REALLY NEED HELP FINDING OUT WHAT POSTED TO THE G/L AND WHAT DID NOT.
    I really need some help with this. My CFO needs financial two days ago for
    the board meeting. It does not look good that I cannot correct this issue.
    HELP. LOL

    I am looking at and have ask for help creating a smartlist call A/P
    transactions and A/R transactions. Then I will be able to manually track
    each day posting to the individual modules.



    "SumCPA" wrote:

    > It might help if you described how you created the balances. Were they
    > migrated from another program? If so, were individual invoices and bills
    > added or were the customer and vendor opening balances entered as a single
    > dollar amount? Are both the general ledger report date and the Aging
    > reports' dates all set to the same date? I'm really curious how this
    > happened!
    >
    > "Richard" wrote:
    >
    > > My general ledger A/P account does not match the historical A/P Aging. The
    > > same goes for my A/R. Can anyone help me figure this out?
     
    RICHARD, Nov 16, 2006
    #3
  4. Richard

    SG Guest

    RICHARD wrote:
    > I have the A/P - A/R defualts set at "Batch entry". The report dates are set
    > the same. I posted all batches from the A/P and A/R modules. This situation
    > just happen prior month. I have been trying to figure this out for the last
    > week.

    <******snip******>
    >
    > I am looking at and have ask for help creating a smartlist call A/P
    > transactions and A/R transactions. Then I will be able to manually track
    > each day posting to the individual modules.


    I almost didn't know what you were talking about until I saw the
    reference to "smartlist". That's a Great Plains reference, not an
    Office Accounting reference. You are either using Small Business
    Manager or some other Great Plains product. Either way, I think you
    are in the wrong newsgroup.

    -----
    SG
    http://sba2006.blogspot.com
     
    SG, Nov 17, 2006
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Prominc
    Replies:
    0
    Views:
    530
    Prominc
    Aug 19, 2003
  2. Ed Freeman, Recruiter

    Accounts Payable Specialist, Alpharetta, GA to $37K

    Ed Freeman, Recruiter, Aug 18, 2004, in forum: Accounting
    Replies:
    0
    Views:
    535
    Ed Freeman, Recruiter
    Aug 18, 2004
  3. Ed Freeman, Recruiter

    Accounts Payable Specialist, Alpharetta, GA to $34K

    Ed Freeman, Recruiter, Dec 2, 2004, in forum: Accounting
    Replies:
    0
    Views:
    515
    Ed Freeman, Recruiter
    Dec 2, 2004
  4. John Dann
    Replies:
    4
    Views:
    2,965
    Laura
    Apr 11, 2005
  5. yankitwizzy

    Are are liability accounts payable accounts

    yankitwizzy, Feb 20, 2012, in forum: General Accountancy Discussion
    Replies:
    1
    Views:
    1,098
    bklynboy
    Feb 21, 2012
Loading...

Share This Page