Open Forum

Expand all | Collapse all

AR Trial Balance is off

  • 1.  AR Trial Balance is off

    Posted Dec 06, 2018 11:53 AM
    We posted a payment to client A in March.  Two months later discovered it should have been posted to  client B.
    The Original payment was voided from client A and a new payment entered for client B- seemed pretty smooth.
    The AR Trial balance is showing an amount due for client A and the total AR Trial Balance does not match the GL by this amount.  the inquiry screen for client A does not show anything balance due.
    I have run Check links with no positive results.
    Any suggestions?

    Connie Miller
    Finance Manager
    Portage MI

  • 2.  RE: AR Trial Balance is off

    Posted Dec 06, 2018 01:29 PM
    Have you tried to run the Sales - Utilities - Reconcile on this customer?  There are 5 different types in there but you can restrict it to your Customer A to see if it resets the summary record and the outstanding doc amounts.
    In the Options, you can choose to Print Report without choosing Reconcile just to see the before and after effects you'll find if you DO choose Reconcile.
    In the range, choose your customer A.
    If customer B is also off, you can run for it afterwards.

    Lisa Simpson
    Emergence Corporation
    Hamilton Bermuda

  • 3.  RE: AR Trial Balance is off

    Posted Dec 07, 2018 09:37 AM
    I suggest reprinting the void journal and checking the void date and the posting date.  If they are in different periods it can cause an EOM variance.

    Lou Spevack
    Systems Accountant | Dynamics Credentialed Professional
    American Council on Education
    Washington DC

  • 4.  RE: AR Trial Balance is off

    Posted Dec 12, 2018 12:13 AM
    In my experience Lou Spevak is correct. If you know what the difference is, and it is a recent transaction, I would like wait a week or two, this could be a problem that will fix itself as the transaction exits to the history files.

    Another common situation that causes timing differences is discounts.

    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