Open Forum

Expand all | Collapse all

A/P and A/R Aged reports not matching Balance Sheet

  • 1.  A/P and A/R Aged reports not matching Balance Sheet

    Posted 6 days ago
    Good Morning:

    We repetitively have an issue with the A/P and A/R aged reports not matching the balance sheet balance.  I've tried running the reconcile to general ledger routine.  While the A/R and A/P module are out of balance with the general ledger balance overall, the beginning and ending amounts are out of balance by the same amount which indicates everything was posted to both sides.  Are there any ideas on why this could be happening?  Any recommendations on how I can locate which entries are the issue?

    Any help is appreciated.

    ------------------------------
    Rikki Simmons
    Birkman International, Inc.
    ------------------------------
    GPUG Summit - Post


  • 2.  RE: A/P and A/R Aged reports not matching Balance Sheet

    GOLD CONTRIBUTOR
    Posted 6 days ago
    Hi Riki,

    You could probably start with this one:

    Information about differences when you reconcile General Ledger to Payables Management or to Receivables Management in Microsoft Dynamics GP
    https://support.microsoft.com/en-sg/help/866570/information-about-differences-when-you-reconcile-general-ledger-to-pay




    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    Chantilly VA
    ------------------------------

    GPUG Summit - Post


  • 3.  RE: A/P and A/R Aged reports not matching Balance Sheet

    Posted 5 days ago
      |   view attached
    Hi @Rikki Simmons - Depending on your version of GP, you may be able to use the Reconcile to GL window in Financial Routines.

    GP will assign a Reconciliation Number, which you can save and reuse. Enter the date range, select a module to reconcile (AP, AR, Bank Rec, Inventory) from the drop-down, and enter the control account(s). Select a location to save the Excel file that will be generated and click the Process button.

    An Excel file will be created and will open with header and footer balancing info, along with three main sections - Unmatched, Potentially Matched, and Matched.

    I would run this for a fiscal period at a time, starting with the first period you were out of balance.

    Hope this helps!

    Jeff



    ------------------------------
    Jeff Pfershy
    Sr Business Analyst
    BluJay Solutions Inc
    Holland MI
    ------------------------------

    GPUG Summit - Post


  • 4.  RE: A/P and A/R Aged reports not matching Balance Sheet

    SILVER CONTRIBUTOR
    Posted 5 days ago
    We have become experts at this here. Check these items:

    1. Make sure all batches have been posted.
    2. Run by document date rather than GL date. If you get different totals it is because you have a document with a different GL posting date.
    3. Check your AR account and make sure there are no GL entries instead of the just the RM and SJ entries.
    4. Look for a distribution account as the AR account which in effect puts it in the subsidiary account but not the GL.

    Hope that helps you.

    ------------------------------
    Jeff Strait
    Ideal Deals, LLC dba Ideal Aluminum Products
    St. Augustine FL
    ------------------------------

    GPUG Summit - Post


  • 5.  RE: A/P and A/R Aged reports not matching Balance Sheet

    TOP CONTRIBUTOR
    Posted 5 days ago

    Let me echo, make sure ALL batches are posted.  This has bitten us too many times.  For us, VOIDS do not post through automatically.

    Make sure that nothing is posted directly to the CONTROL account in the general ledger.  Everything needs to go through the modules' sub-ledger.  

    Use the modules' Reconciler, on a month by month basis.  I have found that will identify all variances that can be corrected.  Now that we have finally gotten all reconciled, it is easier.  They only thing that is throwing AP out is when the distribution is "jacked with" to take the PAY type out.  



    ------------------------------
    Thomas Hill
    Staff Accountant
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------

    GPUG Summit - Post


  • 6.  RE: A/P and A/R Aged reports not matching Balance Sheet

    Posted yesterday

    Thank you to all that provided suggestions!

     

     

     

    Rikki Simmons
    Senior Accountant

    Birkman International, Inc.
    3040 Post Oak Blvd., Suite 1425
    Houston, TX 77056
    office   (713) 331-5626

     




    GPUG Summit - Post


  • 7.  RE: A/P and A/R Aged reports not matching Balance Sheet

    TOP CONTRIBUTOR
    Posted yesterday
    I have written several blogs on balancing the RM/PM subledgers to the GL:
    https://dynamicsgptipsandtraps.wordpress.com/

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida / Supervalu
    Sunrise FL
    ------------------------------

    GPUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role