cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

One of my supplier's open balances is higher than the total of their unpaid bills

My A/P for the supplier agrees with the total of the unpaid bills and also agrees with the statement of account from their accounts department. However, the amount showing as "open" on their supplier page is much higher and I cannot find why this has happened or how to fix it. It doesn't seem to be affecting the A/P ageing 

6 Comments
Highlighted
Level 2

One of my supplier's open balances is higher than the total of their unpaid bills

Hi there, kelly!

Let me share some important information with you.

In QuickBooks Online (QBO), the open balance section on your supplier screen composes of the total amount of bills/payments as well as the overdue that was created on that specific supplier. 

The overdue balance, on the other hand, are bills that was reached the set due date.

Based from your screenshot, it stated there that there were four (4) open and three (3) over due bills. Let's go ahead and check the supplier balance report and see if they are the same. 

Also, let's make sure that the bills that need to be paid are marked as paid. This will then organize the report on your QBO account accordingly.

Please refer on this link for more information: https://community.intuit.com/articles/1503073-customize-vendor-reports

Keep me posted if you have any questions or clarifications. I'm ready to help!

Highlighted
Level 1

One of my supplier's open balances is higher than the total of their unpaid bills

Hi Kareen
Thanks for the reply. However, with regard to this vendor I only have 2 open bills for them, and only part of the one invoice is overdue. The total of these two open(unpaid) bills is less than the “open” amount that is showing on the top right hand of the vendor’s page. There are no other unpaid bills and no unapplied payments or credits ....i.e. nothing that should be “open”.
I have run all the accounts payable reports and vendor balance summary reports and these amounts all agree with the sum of the two unpaid bills and NOT with the amount that is showing as open on the vendor’s page.
I have no other vendor in any of the companies that I work on that has this issue and I am flummoxed.
If you have any other input, I would really appreciate it.
Thanks
Kelly
Highlighted
Level 2

One of my supplier's open balances is higher than the total of their unpaid bills

Hello @kelly,

Let's go ahead and try to run the Supplier Balance report to get the total amount of the correct open bills.

Subtract the correct open bill to the amount showing on the Supplier screen. Then, look for a transaction which is closer to that amount and try to delete and recreate.

This visual error is usually caused by transactions that were edited multiple times and haven't been saved properly. Thank you!
Highlighted
Level 1

One of my supplier's open balances is higher than the total of their unpaid bills

Hi, Kareen
Thanks again for the help. I have done as you suggest (there were a couple of transactions which were for the amount that is causing the issue). I deleted and recreated, but I am still showing an incorrect supplier open balance. I really don't know what is causing this. Is there anything else that I can try?
Thanks
Highlighted
Level 1

One of my supplier's open balances is higher than the total of their unpaid bills

Have you been able to resolve this? I have the same issue and can't find the problem.

Highlighted
Moderator

One of my supplier's open balances is higher than the total of their unpaid bills

Hello, @Beremp. Thanks for joining this thread.


The issues impacting supplier's open balance amount on supplier page have been resolved. With this, kindly run the supplier balance reports to view the correct open balance.

 

However, if the issue persists, I recommend contacting our Customer Support team as they have the necessary tools to pull up your account and get to know the root cause of this issue. 

 

Here's how to contact the Customer Support Team:

  1.     Click the Help icon on the top right.
  2.     Click Contact Us button at the bottom.
  3.     Enter a short description about your concern.
  4.     Click on Let's talk.
  5.     Choose the method on how you'd be connected to support.

If you have any follow up questions, please let me know. I'm here for you. Have a great day.