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!

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

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.

I am having the same issue. I ran the Vendor Open Balance report and figured out that one vendor had a check posted and a couple invoices were deleted which made it look like an over payment. I re-posted the invoices and re-applied them to the check and now it balances. However, I have another vendor that is off by $1.96. I ran the open balance report and it is not showing where I would be off by that amount. This is driving me nuts!

Good job for checking the balance report, Kathoff. It'll help us know if there's a vendor balance.

In the report, you can try to change the period or dates. This will help us view more transactions.

Although, if you're still unable to see any balance, this unusual behavior might be caused by some browser hiccups. We'll perform some basic steps to fix this.

Let's start with logging in to your account through a private browser. This is the best spot to isolate web issues. These are the shortcut keys:

• Google Chrome: press Ctrl + Shift + N 
• Mozilla Firefox: press Ctrl + Shift + P
• Internet Explorer: press Ctrl + Shift + P
• Safari: press Command + Shift + N

If you're unable to see any balances or off, go back to your regular browser and clear its cache. This refreshes the program.

Also, you can use a different browser like Google Chrome or Mozilla Firefox.

If you're still encountering the same issue after trying the steps, I'd suggest reaching out to our customer care support. This way, an agent can take a better look at this. Follow the steps provided by MirriamM on how to get in touch with us.

The Community is open 24/7. Please know we're just around to help you.

Thank you. I am actually on QuickBooks Desktop. I went into the Vendor Pay and paid all the bills that were open for that vendor and then went back to the vendor screen and it is still showing that I have a $1.96 balance. I ran the Open Balance Report with the dates as All and it is blank. I am not sure where this is coming from.

Hello Kathoff,

Aside from the Open Balance report you mentioned, we can pull up and customize a different one. Here's how to do it:

1. Click Reports at the top and select Vendors & Payables > Vendor Balance Detail.
2. Click the Customize Report button and go to the Display tab.
3. Go to the COLUMNS section and add the Paid column.
4. Go to the Filters tab and search Preferred Vendor.
5. Select the specific vendor and click OK.

This report should show you which bill or transaction that is still open causing the $1.96 balance. You can settle it from there.

Let me know how this goes so we can further help you. Have a great day!

I have the same issue with the Vendor Center showing an open balance but no reports or transactions to show where the balance comes from. I have tried all the suggestions in this string of emails but have not found a solution. Any more suggestions?

I couldn't find a fix but after about a week it was back to normal. I do run multiple currencies so that may have been the issue. You could try to revalue your currency.

Hello there, @Byrd28.

Making sure that your suppliers' balance is accurate is essential for organized bookkeeping. Let's generate and customize your Transaction List by Supplier. This way, we'd be able to determine where the open balance is coming from.

1. Go to the Reports menu.
2. Scroll down to the Expenses and Suppliers section.
3. Select the Transaction List by Supplier.
4. Click the Customise button.
5. Set the Report Date Range to This Year.
6. From the Rows/Columns section, mark the following tick box:
   • Date
   • Transaction Type
   • No.
   • Memo/Description
   • Account
   • Amount
   • Open Balance
7. Expand the Filter section.
8. Pick the name of the supplier that displays a higher open balance than the total of Unpaid Bills.
9. Click the Run Report button.

Also, you can look into is your list of journal entries. Do you have any journal entries tied to the supplier? This may be impacting the open balance. The journal entry must include the Accounts Payable (A/P) in the ACCOUNTS column.

Lastly, you can follow the suggestions shared by, @Beremp.

Keep me posted if you have other questions about managing your vendor's balance. I'm always here to help.