Forum Discussion

RodneyPollen's avatar
RodneyPollen
Contributing User
9 months ago

Customer Statement balance due incorrect.

Hi,   My Customer Statement Balance Due is incorrect. I've attached screenshots of the Customer Statement and Receivables Reconciliation. We've recently upgraded from AR v19.6 so we're still adju...
gavin12345's avatar
gavin12345
Ultimate User
9 months ago

Hi RodneyPollen 

 

If you look at the top of the Receivables Reconciliation, it states that the transactions are show in ZMW (not USD). The Statement is however in USD - you should be able to format the statement to show that all values are in USD. 

 

The receivables recon report is always shown in local currency as far as I know - however I don't use multi currency much. The Orig Currency column shows the currency code the transaction was recorded in, even though the amts displayed are in local currency.

 

Multiple currency support in AR2023 is a little 'half-baked' IMHO.

 

Regards

Gavin

  • RodneyPollen's avatar
    RodneyPollen
    Contributing User
    9 months ago

    Hi Gavin,

     

    Thanks for the fast response.

     

    There are two issues:

    1. On the Statemet - the customer Total Amount Due (40,870.51) does not agree with the final statement balance (50,338.15)

    2. The Receivables Account  is out of balance.

     

    1. My primary concern is the Statement balance that has the missleading bottom line.

    All the transaction are showing and all the invoice terms are consistant (14 days) and they are showing in the right currency.

     

     

    Any idea why its missing a random $9,467.64?

     

     

    • gavin12345's avatar
      gavin12345
      Ultimate User
      9 months ago

      Hi RodneyPollen 

       

      Thanks for clarifying the issue - take a look at the first few posts here - MYOB needed to run a script on the file to fix the issue (a payment was not showing due to bug in software).  Other than seeing the numbers don't add up, there is not enough info provided to identify cause. You will need to look at the History on all invoices to see where the discrepancy comes from.

       

      You cannot tell if your Receivables Reconciliation is out of balance as you are looking at one Supplier only. Generate same report for all suppliers to see if the register total matches the account.

       

      Regards

      Gavin

    • Earl_HD's avatar
      Earl_HD
      MYOB Moderator
      9 months ago

      Hi RodneyPollen,

      Thank you so much for your post and for the detailed information with a screenshot. I'm sorry to hear that you were having issues with your Costumer Statement balance. I really appreciate your patience and understanding about this issue, and I do apologize for the delayed response.

      Thank you gavin12345 for providing a solution. In addition, please have a look at this Help Article on Receivables out of balance. You'll find a number of reasons for receivables being out of balance listed along with the steps to take to resolve those scenarios

      Feel free to post again, we're happy to help.
      Regards,
      Earl

Related content