Skip to main content
K
kelly31
September 26, 2019
Question

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

  • September 26, 2019
  • 2 replies
  • 0 views

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 

2 replies

K
Kc29655
September 26, 2019

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!

K
kelly31Author
September 26, 2019
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
K
Kathoff
May 28, 2020

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!

Kristine Mae
Kristine Mae
May 29, 2020

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.

K
Kathoff
June 3, 2020

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.

Terms & ConditionsAccessibility statement