Skip to main content
F
FlyOverLand
February 12, 2021
Question

Vendor center shows open balance that should be zero

  • February 12, 2021
  • 1 reply
  • 0 views

In the vendor center for a particular vendor, when showing all transactions, some transactions show an open balance that is not part of the actual vendor balance shown in the list of vendors. 

 

If I select to show open balance rather than all transactions, the transactions are not listed and the open balance does match the vendor list on the left.

 

Some (not all) of the transactions are deposits for funds received from vendor. Deposits do not normally show up in the vendor transaction list, and I am not sure why these particular ones do. 

 

The transaction has been applied/offset by other transactions and it does not appear in pay bills, either as a bill or an available credit.

 

I do not believe this is actually causing any problem in balances, but I do use the open balance column in the vendor center to monitor open vendor transactions, and it is confusing to see an open balance that is not truly open.

 

I have verified data and my file reports no problems.

 

Any way to clear the reported open balance in the vendor center?

1 reply

MaryLurleenM
MaryLurleenM
February 12, 2021

Verify data is a good way to identify errors, FlyOverLand.
 

Let's troubleshoot next using the QuickBooks File Doctor. Here's how:

  1. From the tool hub, select Company File Issues.
  2. Select Run QuickBooks File Doctor. It can take up to one minute for the file doctor to open. Note: If the QuickBooks File Doctor doesn't open, search for QuickBooks Desktop File Doc and open it manually.
  3. In QuickBooks File Doctor, select your company file from the drop-down menu. If you don’t see your file, select Browse and search to find your file.
  4. Select Check your file (middle option only) and then Continue.
  5. Enter your QuickBooks admin password and then select Next.

The scan time depends on your file size. In most cases, it can take up to 5 minutes. Once the scan finishes, open QuickBooks and your company file. The scan may say it was unsuccessful even if it fixes your issue.

 

Check this article to learn more: Fix company file and network issues with QuickBooks File Doctor.

 

I'll be here if you have other questions. 

F
FlyOverLandAuthor
February 14, 2021

Hi MLM,

 

I finally got a chance to do that and it did not change anything.

 

The File Doctor reported no problems, and left the transactions unchanged.

 

One thing I neglected to mention earlier is that the confusing transactions showing an open balance have a blank aging days, which is somewhat helpful in recognizing them, but I'd still prefer not to see an open balance that does not need any action.

 

Thanks for the suggestion.

R
ReyJohn_D
February 14, 2021

Thanks for the additional details, @FlyOverLand.

 

I'll help you get rid of the open vendor balance in QuickBooks Desktop.

 

Based on your original post, I can see that the open balance doesn't match the vendor list on the left. The usual cause of this incorrect amount is a transaction error. To isolate this, you can run a Vendor Balance Detail report.

 

Here's how to do it:

 

  1. Select the Vendors menu, and then Vendor Center.
  2. Choose the vendor with open balance discrepancies.
  3. Go to the Transactions tab on the right.
  4. Select Balance Details from the Show drop-down.
  5. You can also use the Filter by and Date drop-down arrows to narrow the transaction list further.
  6. Click View as a Report from the Run Reports drop-down.
  7. Review the transactions.

 

If the balance is too high, you may have paid a bill using a check instead of going through the Pay Bills window. To fix this, please refer to bill shows as unpaid after writing a check article at this link.

 

If the balance is too low, you may have entered the wrong amount in a transaction. You can look for the bill or bill payment in the Vendor Balance Detail report and then edit it.

 

To learn more about this, please head to this link: Adjust the current balance for a vendor.

 

Also, QuickBooks Desktop will automatically create a bill for the vendor if you've entered an amount in the Opening Balance field. This can cause balance issues. To remove this, you'll have to open the bill and delete it.

 

Lastly, you can pull up other vendor-related reports to know and settle your payables. To achieve this, navigate through the Reports menu. Then, select one from the Vendors & Payables section.

 

I'm still up and running if you need help with handling vendor transactions or anything else related to QuickBooks. Take care!

Terms & ConditionsAccessibility statement