Customer Statement balance due incorrect.

Question

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 adjusting to AR Premier 2023.7.0 multicurrency issues.

All the transaction seem normal and payment terms on all invoices ate set to 14 days.

Please help

Rodney

Statement.jpg

Receivables Reconciliation Detail.jpg

Earl_HD · Answer

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

gavin12345 · Answer

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

RodneyPollen · Answer

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?