Skip to main content
P
PMG Entertainment
January 29, 2021
Question

Incorrect Balance showing on Vendor Screen

  • January 29, 2021
  • 1 reply
  • 0 views

I set up a very simple company in QuickBooks 5 years ago.  I'm currently using the 2018 version.

Last week when I received a payment (of $250) for an outstanding invoice (of $250), instead of bringing the outstanding balance to $0, it shows on the main vendor screen a negative amount(-$250), and it is now doing this will all of the outstanding invoices I have!  I think it's some sort of bug in the system. 

There are several issues:

1. I did nothing differently in how I create the invoices or receive the payments

2. I double checked everything to make sure I recorded everything correctly

3. When I run the outstanding balance report for those vendors it shows a zero balance (which is correct)

4. I've updated the 2018 with any fixes that are available

 

Please help!

1 reply

MariaSoledadG
MariaSoledadG
January 30, 2021

Let's get your balance to show up correctly on your customer screen, PMG Entertainment.

 

You can use the resort list tool in QuickBooks to fix any odd or unusual behavior in your transactions. To do this, you can follow the steps below:

  1. From the Edit menu, select Find.
  2. Select the Advanced tab.
  3. From the Filter list, select Name.
  4. Select the Name ▼ dropdown, then press Ctrl+L on your keyboard.
  5. Select the Include Inactive checkbox. If it's grayed out, there are no inactive names.
  6. Select the Name ▼ dropdown, then select Re-sort List.
  7. Select OK.
  8. Close and reopen your company file.

Please read this article for more information: Re-sort Lists in QuickBooks Desktop. If it doesn't fix the problem, you can also use the verify and rebuild tool to fix any data issues.

 

Once fixed, you might want to add and match transactions that you've already entered in QuickBooks.

 

Fill me in if you have questions about an invoice, We'll always be right here to help you anytime.

P
PMG EntertainmentAuthor
January 30, 2021

Thank you for your reply, unfortunately that did not correct the problem.

I've attached some screenshots of the issue - the following vendors have issues:

 

1st screenshot

Mario Ricardo Calderon - Vendor Screen Shows a -$750 balance, real balance is +$250

Thomas McGuire - Vendor Screen Shows a -$475 balance, real balance is + $225

Paris Rose - Vendor Screen Shows a -$250 balance, real balance is $0

Valerie Rose Koeningsberg - Vendor Screen Shows a -$225 balance, real balance is $0

 

2nd screenshot

Dan Hill - Vendor Screen Show a -$25 balance, real balance is $+$475

Brian Dyer - Balance is CORRECT

Erin Chase - Balance is CORRECT

Jeffrey Allegue - Balance IS CORRECT

 

I need to attach the Vendor Balance Report that shows the correct amounts in a separate reply because it's only allowing one attachment at a time.

 

Once again, this issue just started last week when I received in some payments - I have changed NOTHING in my process. 

 

 

 

Terms & ConditionsAccessibility statement