Forum Discussion

Contributing User

2 years 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

Ultimate User

2 years 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
Contributing User
2 years 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
  Ultimate User
  2 years 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
  MYOB Moderator
  2 years 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