Open Forum

Expand all | Collapse all

Aged A/R & Balance Sheet do not match

  • 1.  Aged A/R & Balance Sheet do not match

    Posted 16 days ago
    Historical aged A/R report total does not match the balance sheet.  I've tried running the remove paid transactions routine, and there was no change.  I've tried using the reconcile to G/L routine, and while it also shows out of balance the amount the reconcile routine shows differs from the out of balance between the aged report & the balance sheet.

    Any ideas on how to locate the variance and/or the cause of the variance?  We are having this issue every month and up to this point had been posting a journal entry to make the two balance.

    We think it is related to voiding invoices because when we void invoices , we get a message saying the transaction did not originate in receivable management, and the void will post to receivable management and the general ledger only.

    Any recommendations are appreciated.

    Rikki


    ------------------------------
    Rikki Simmons
    Birkman International, Inc.
    ------------------------------


  • 2.  RE: Aged A/R & Balance Sheet do not match

    GOLD CONTRIBUTOR
    Posted 16 days ago
    Rikki,

    Here is a strategy...  find the month in the past where they did match.  Then, work forward month by month finding why they don't match.  The reconcile-to-GL is a good tool for finding the offending transaction(s).

    Good luck!

    Chris

    ------------------------------
    Chris Donnelly
    Sr Mgr of Info Systems and Financial Reporting
    Healthmark Industries
    ------------------------------



  • 3.  RE: Aged A/R & Balance Sheet do not match

    SILVER CONTRIBUTOR
    Posted 16 days ago

    Try running the reconciliation program in the finance module for A/R.

    Jeff

     

    Sent from Mail for Windows 10

     






  • 4.  RE: Aged A/R & Balance Sheet do not match

    SILVER CONTRIBUTOR
    Posted 16 days ago
    You might want to run the GL distributions report from AR - I've seen it where a typo would happen and either the AR account wouldn't be selected or someone debited and credited the same account.  i.e. Invoice entered - debit and credit went to sales and zero to AR account.  This would make the invoice appear on the aging but not in the GL

    ------------------------------
    Deanne Rasmussen
    ePlanPartners
    Houston TX
    ------------------------------



  • 5.  RE: Aged A/R & Balance Sheet do not match

    TOP CONTRIBUTOR
    Posted 16 days ago
    This KB article will be helpful:

    Information about differences when you reconcile General Ledger to Payables Management or to Receivables Management in Microsoft Dynamics GP



    ------------------------------
    Lou Spevack
    American Council on Education
    Washington DC
    ------------------------------



  • 6.  RE: Aged A/R & Balance Sheet do not match

    TOP CONTRIBUTOR
    Posted 15 days ago
    Please feel free to review my blogs on balancing the GL to the RM/PM subsidiary modules.
    https://dynamicsgptipsandtraps.wordpress.com

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



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