Some of my suppliers show different amount on the suppliers tab than the amount when i make payment or when i check their balance in the Suppliers details Report
Thanks for providing the screenshot, GWE1.
Aside from using the Suppliers Details report, let's try running the Accounts payable aging detail report.
Then, check if the amount matches from your report into the Supplier's tab. If not, you can review the vendors' bills and payments transactions if there are correct, modified or changed.
For more details about the Aging report, you can check out this article: How to get your Aging Reports to match.
Please reply to this post if you have additional questions.
Thank you for your replay,
but it doesn't solve the fact that the Open Balance 3,252.58 written on the suppler is wrong it should be 3,135.33 even when i make Payment it shows the correct amount on how much i should actually pay, and when i pay all due bills it shows the deference like screenshot below and in the report you mentioned it shows no data.
This problem happens for couple of suppliers not just one
Thanks for coming back.
As I've checked the screenshots, the amount on some bill payments (cheque) are larger than the actual bill. That's the reason there's a discrepancy on the vendor balance. For example, the Bill on 17/09/2018 for 2,416.99, the applied payment was 2,417.00. The overpayment will be carry over to to next bill.
There's no need to make some changes unless the transactions are incorrectly entered.
If you have more questions, please let us know.
The usual reason why there would show an open amount but no overdue amount would be if there is an unapplied payment or credit note.
The easiest way to check this is to click into that supplier and to the right of the word action there is a cog,if you click on that you can see some columns to tick,if you put a tick in the status column and then click the cog again to close that pop up. You should be able to see a transaction for that amount that shows unapplied in the status column. That should be the transaction that is causing the discrepancy.
Let us know how you get on
Thanks for sharing your screenshots, GWE1.
I looked into the attached screenshots and can see that bills and its payments are applied. In this regard, I recommend reaching out to our email support team. They can look into your transactions created and will help you fix it.
Always know the Community is always around to help you with your questions.