Forum Discussion
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.
- Celia_B10 months agoMYOB Moderator
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
- Nicole_P10 months agoContributing Partner
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.
- Celia_B10 months agoMYOB Moderator
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