Why the Payables with Tax report is out of balance but the Reconciliations report is not

Hi Nicole_P 

There are 2 bugs in the Payables with Tax report that affect accuracy - how gains/losses on foreign currencies are handles, and how finance charges are handled. As you do not use multiple currencies, you should look at the linked account for finance charges for a transaction connected with your discrepancy.

Perhaps check for future dated payments as well.

Regards

Gavin

Thanks Gavin, howeve it is not due to a finance charge. It is simply an invoice which is dated pre 30 June 2023 and paid in July 2023. The invoice shows on the payables reconciliation report but does not appear on the payables with tax report.

Hi Nicole_P 

Thank you for your post. 

May I know if you are using the latest version of the software, and does your file has multi-currency enabled?

And as per gavin12345 response to your post, As the files in live version with multi currency enabled, "Payables with tax' report does not show an out of balance amount by the "currency gain/loss amount". However, if you do not use multi currency, then it would be recommended to check on this Help Article:  Receivables,Payables or inventory out of balance. This articles contains more information and you can use this as reference. 

If you need further assistance with this. Please feel free to post again and we're happy to assist you. 

Thanks 

Cel

Hi Cel,

The client is on the most recent version and does not have multi-currency enabled. I am very familiar with determing the reason for a variance, however the there is no reason for this to be out of balance. The transation has been entered through purchases and the payment has been made the following month, yet it is not showing on the Payables with tax report, however the transactio nis on the payables reconcilation report.

Hi Nicole_P 

Thanks for getting back to us. 

The most frequent causes of payables with tax or exceptions for payables reconciliation being out of balance are incorrectly linked payables accounts and inappropriate accounts for tracking supplier deposits. However, because every user types a transaction differently, it is very difficult to say what would have caused the out-of-balance in your file. The transaction in issue needs to be thoroughly examined to determine the cause.

One way of identifying that would running both the reports future dated and checking if they return nil out of balance. You can also recap the transactions displayed in the exceptions report and check if the accounts in the recapped transactions match to your current linked accounts for purchases. I would also recommend going through a list of troubleshooting steps listed in the Help Article that can provide you more information and serves as your reference. You can also check on this help article LINK. 

Feel free to post again if you need further assistance. I am happy to help you.

If my response has answered your enquiry, please click "Accept as Solution" to assist other users find this information.

Thanks, 

Cel

Hi,

I have a client who has exactly the same problem.  The Payables with Tax report is out of balance when the Reconciliation report is not.  I have tracked to a series of invoices dated the 01/05/23 paid in June.  The issue is not isolated, it is running through into present time with fluctuating out of balance values.

Like you, the client does not have multicurrency activited, all linked accounts are correct.  No processing issues, I too am very familiar with reasons why out of balance amounts occur but no issue is evident.  At this point of time I think it is a unexplained gliche which needs investigation by MYOB.

Will let you know how I go.

Thanks Vanessa

Hi Romano,

Thank you for your post and welcome to the Community Forum.

Thank you so much for sharing your feedbacks. Your feedback is extremely important to us and will help us enhance our services to better meet your needs. Rest assured that we'll be raising this through the required team. It would be appreciated if you let us know how you go about the issue. 

Thank you,

Cel

Hi Romano,

We just wanted to follow up on your concern. May I know how you go about the issue? We simply wanted to ensure that we addressed the issue correctly. And if you need more support with this or in the future, please post again. Alternatively, you can send us a Private Message. We are delighted to assist you. 

Thanks, 

Cel