cancel
Showing results for 
Search instead for 
Did you mean: 
Claudia11
Level 2

Negative bill displayed in the Pay Bills window

I have problem trying to pay a bill, quickbooks doesn't allow pay negative bills, the reason it become negative was when I made a mistake, I have this Bill is a big amount and normally I pay every month part of the bill but not the whole bill, and last month I didn't change the amount to pay and it selected the whole amount by defauilt, so I create the check for the whole amount by mistake and after that I deleted the paymentcheck and the bill become negative, now what I do is just print a check in order to the vendor, but I can't pay the bill like before. I don't know how to fix it. I really apreciate if somebody could help me to find the solution.

I attached the screen with the error

24 Comments 24
Anonymous
Not applicable

Negative bill displayed in the Pay Bills window

I'd try Rebuilding your data file from the File | Utilities menu.  Rebuild will fix balances due on AR and AP transactions.

FritzF
Moderator

Negative bill displayed in the Pay Bills window

Thanks for posting in the Community, @Claudia11.

 

Allow me to chime in for a moment and help make sure that this is taken care of.

 

I agree with @Anonymous. The rebuild and verify data utilities are QuickBooks built-in diagnostic and repair tools that comb through, repair, and notify you of data damage within the file.

 

You can also check out this article for the detailed steps on how to run these tools: Resolve data damage on your company file.

 

That should help fix the error that you're getting. Please let me know how it goes by leaving a comment below. I'll be here if you need further assistance. Have a good one.

Claudia11
Level 2

Negative bill displayed in the Pay Bills window

Thank you I will try to do that and I let you know if that was fixed

Claudia11
Level 2

Negative bill displayed in the Pay Bills window

Thank you for your answer, I will try to do it, I will let you know if I could fixed

Claudia11
Level 2

Negative bill displayed in the Pay Bills window

It doesn't fix the problem I still having in 

Vendor window, the balance is $199,016.09, which is correct

when I click "Pay bills" then in the Pay Bills window show the list of all the bills and they are ok, just that one show the negative amount -$365,086.61, and doesn't allow select it to make the payment.

The Balance at vendor window is correct, we already made $180,000 on payments, the original amount of the bill was $379,016.09, so it is correct the balance.

I don't know how it can be fix, thank you if anybody could help me.

 

Anonymous
Not applicable

Negative bill displayed in the Pay Bills window

Welcome back to our forum, @Claudia11,

 

I appreciate you letting us know the outcome of the troubleshooting. I want to make sure this negative bill issue gets resolved.

 

Since the recommended steps did not resolve the negative amount, you can delete and recreate the bill. Before making the changes, I'd recommend creating a backup copy of the company file.

 

Let's pull up an Unpaid Bills Detail report to locate the negative amount. Here's how:

  1. Click the Reports menu.
  2. Choose Vendors & Payables.
  3. Select Unpaid Bills Detail.
  4. Update the report date.
  5. Double click the bill with the negative balance.
  6. Right-click on the transaction and click Delete Bill.

Once done, recreate the same bill and apply the payment. That should get you on the right track, @Claudia11.

 

Thanks for your time today. Please let me know how it goes. I'll be more than happy to help you if you need further assistance. Have a great day!

Sydney104
Level 1

Negative bill displayed in the Pay Bills window

Good evening Jen_D;

I had the same issue and the rebuild didn't work but removing and re-entering did :) 

Thanks

Sydney104
Level 1

Negative bill displayed in the Pay Bills window

I ran into the same problem and the rebuild didn't work but the delete and re-enter did!

Thanks :smileyhappy:

Claudia11
Level 2

Negative bill displayed in the Pay Bills window

Thank you for your answer, I am afraid to delete it an re-enter the bill, I have many other payments made since 2014 every month! what happen with those payments made every month? they are linked with the bill.

The problem started this year, so I have only 3 checks written without a linked to the bill

 

Anonymous
Not applicable

Negative bill displayed in the Pay Bills window

Hi, @Claudia11.

 

Thanks for getting back. Allow me to chime in and help share additional information about deleting and recreating the bill with the negative amount.

 

Since you've already tried rebuilding your data file, the only way to resolve this is to delete the bill with the negative amount and recreate it. You'll just need to make sure to create a backup copy of the company file first as suggested by my colleague @Jen_D.

 

Creating a backup copy will ensure your data is protected against accidental data loss.

 

You can always ask assistance from our live support so they can help you through the process. They'll be able to access your account in a secure environment and you can work together using their screen-share tool. 

 

Here's how you can get in touch with them:

 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks Version.
  4. On the Contact Us page, click a topic.
  5. Click on the Start a Message button to see the support number.

Let me know how it goes. I'll be on the lookout for your reply and help you further if you have additional questions about the negative bill. 

Claudia11
Level 2

Negative bill displayed in the Pay Bills window

Ok Thank you, I need to figure out how it was created, I think it was entered like Journal Entry, and I need to review old record to see how it was created.

I have a question, What happen with the payments made for that bill, if I delete the bill?

Thank you.

JonpriL
Moderator

Negative bill displayed in the Pay Bills window

Thank you for the response, @Claudia11!

 

Allow me to join in to this thread, share a few insights, and help convert your bill payment into a credit.

 

To start, your bill's payment will become a floating transaction once you delete the bills for it.
 
Thus, it creates a credit or unapplied payment that you can pay for future bills or to your recreated bills.

 

With this, here's how you can apply a credit to your unpaid bills:

  1. Go to Vendors.
  2. Select Pay Bills.
  3. Choose one of your unpaid bills.
  4. Hit Set Credits.
  5. Under the Credits tab, select a credit.
  6. Click Done.
  7. Select Pay Selected Bills.

This way, your unapplied bill payments will be applied as a credit to your unpaid bills.

 

In addition, here's an article you can read to learn more about bills payment: Pay Bills in QuickBooks Desktop.

 

It'll be always my pleasure to help if you have any other questions about your bills and bills payment. Have a great day!

LewisOil
Level 1

Negative bill displayed in the Pay Bills window

I tried to delete to the "unpaid" bill but it requires a password from when the journal entry was created (back in 2010) before I even worked here.  How do you get around that?

asalazar2
Level 1

Negative bill displayed in the Pay Bills window

This could potentially be an issue of Target Chaining. 

The most common ways of identifying this issue:

  • Open the Unpaid Bills report and look for old bills that are unpaid but should be paid
  • Open the Vendors > Pay Bills screen and check for unpaid bills
  • In the Chart of Accounts, check if the Accounts Payable account is extremely negative
  • Open the Profit & Loss report and check for large balances in Uncategorized Income or Expense
  • Open the Vendor Balance Detail and look for negative balances and/or bills showing under No Name

It is a current limitation in QuickBooks, not a bug. QuickBooks was designed for Small to Mid sized Businesses and this issue only occurs after the file has reached 2 GB or has over a million targets.

Make sure the Cache has been set correctly. 

If possible, restore a backup from BEFORE this happened, typically you should have a backup created right before the rebuild.

If you do, perform the following on your system where Quickbooks is Installed. This should prevent the target chaining issue from happening.


Browse to the respective QBW.INI file stored in

 

ProgramData: C:\ProgramData\Intuit\QuickBooks Version\


Add the following:
[DBSERVEROPTIONS]
InitialCache=4096M
MaxCache=0


Save the Ini File. 
Be sure Quickbooks is closed out completely as well. 
Restart Quickbooks.

You should be able to see what your current Cache is by clicking F2 and pulling up the Product Information window. Your current Cache will be in the bottom left hand corner. You want this to say "Unlimited". 

3973Acc
Level 1

Negative bill displayed in the Pay Bills window

We have a negative bill in the pay bills window that was created by JE in a previous year.  I have tried to create a bill to offset, but I cannot click on the negative balance to offset the invoice. -So that did not work. 

I tried a JE.  That did not work either. 

Rebuild did not work either. 

Please let me know if there is any other way to resolve this.  We are running Desktop Contractor 21.0.

Candice C
QuickBooks Team

Negative bill displayed in the Pay Bills window

Greetings, @3973Acc

 

Thanks for joining in on this thread. It's always great to see a new face here in the Community. 

 

Since you're unable to offset the negative bill in the pay bills window, I suggest consulting with your accountant to see what the best options are. They'll be able to give you the advice you need for your business.

 

Let us know how the conversation goes when speaking with your accountant. We want to ensure you get this taken care of as soon as possible. Have a great day!

LewisOil
Level 1

Negative bill displayed in the Pay Bills window

I'm not sure what this in regards to?

JessT
Moderator

Negative bill displayed in the Pay Bills window

Hi there, LewisOil!

 

I've read the entire thread and your post 2 years ago. If your question is still related to the negative bill that you couldn't delete because it belongs to a closed period, we can do some steps about it.

 

Aside from running the verify and rebuild utilities, which is appropriate for cases like this, you can ask your admin user to set a new closing date password. This way, you can use it when deleting the bill. However, please back up your company file and ask for advice from your accountant first to be sure your books are correct.

 

Set a new closing date password:

 

  1. From the Company menu, select Set Closing Date.
  2. Select Set Date/Password.
  3. Enter a Closing Date and Closing Date Password.
  4. Select OK to close the window.

 

If you have a different question, please provide more details. The QuickBooks Team is always available to continue helping you.

VM15
Level 2

Negative bill displayed in the Pay Bills window

I also read the entire thread from 2 years ago to find a solution for a same issue I am facing. 
I have an unpaid bill from a closed period( 5 months ago) that I want to get rid of. I do not want to delete it because I do not want to disturb the previous Financial Reports. I want to know if there is an alternative way to handle this. Any help is appreciated.

Rose-A
Moderator

Negative bill displayed in the Pay Bills window

I know a method for getting rid of those unpaid bills in QuickBooks Desktop, VM15.

 

To balance your financial data, we can create a journal entry for the current period and link the transaction to your unpaid bills. I recommend consulting with an accountant if you are unsure which accounts to debit and credit.

 

Here's how to create journal entry with sample screenshots:

 

  1. Click Company at the top menu bar and choose Make General Journal Entries.
  2. Fill out the fields to create your journal entry. Make sure your debits equal your credits when you’re done.
  3. Hit Save & Close.

 

After that, you can use the journal entry to pay off any outstanding bills. We can follow the steps in this article: Pay bills in QuickBooks Desktop.


You can also read the following article: Expenses and vendors. This will provide us with links to help us manage your company's expenses and other vendor transactions.


I'm always available if you have any further questions or concerns. I wish you and your company continued success! 

MHJ17
Level 2

Negative bill displayed in the Pay Bills window

Maybe I'm missing something, but nothing in this thread has worked. I have a vendor with a zero balance that shows on the AP aging report. First of all, I'm not sure why that would even happen, but more importantly, that vendor shows up in PAY BILLS with a negative bill amount. You cannot select it because of this, so there is no way to apply a credit to it and zero it out. There were JE's done in previous periods that created this negative bill. We have ran verify data and rebuild data multiple times with no results & no changes. Creating yet another JE will not help because the bill is still showing up as negative in PAY BILLS. How do you fix this?

Heide DC
QuickBooks Team

Negative bill displayed in the Pay Bills window

Thanks for joining the thread, MHJ17. Let's navigate together to figure out your aging reports in QuickBooks Desktop.

 

Rebuilding your file will not work because this is not a data issue. You may have made a bill that has triggered the balance report. If possible, please provide us with screenshots of both the bill and the journal entry that you created. This will help us find the appropriate solution to resolve the issue.

 

If you're unable to offset the negative bill in the pay bills window, I suggest consulting your accountant for the best course of action. They'll be able to provide you with the advice you need for your business.

 

In the meantime, we can do these steps to set a new closing date password. By doing this, please note that creating a backup of your company file ensures your books are corrected.

 

Here's how to set a new closing date password:

 

  1. From the Company menu, choose Set Closing Date.
  2. Select Set Date/Password.
  3. Enter a Closing Date and Closing Date Password.
  4. Click OK to close the window.

 

Additionally, please check these links which will show you how to fix customer and vendor balances, as well as AR and AP balance issues:

 

 

If you have additional concerns about your pay bills, feel free to reply below. I'm always here to assist you.

MHJ17
Level 2

Negative bill displayed in the Pay Bills window

Accessing the closed period is not an issue, deleting or changing JE's is an issue. Several JE's were created for prior periods in lieu of entering individual transactions when we switched to QBs in 2020. These JE's created a bill with a negative balance due. A negative bill in PAY BILLS can not be selected. Every suggestion made we have tried without solving the issue, so the negative bill will just sit in PAY BILLS. The vendor in question has a zero balance due and was made inactive, but still shows up on the aging report. Why do the aging reports show inactive vendors/customers at all?

Changing the JE will mess up that period (Nov 2019) and every period thereafter, so that is not an option. Verify & rebuild data shows no issues. I am an accountant and I've consulted other accountants. This is not an accounting issue, it's a QB's issue. JE's created a NEGATIVE BILL TO PAY, but a negative bill cannot be selected in the PAY BILLS WINDOW!   A lot of other users seem to have this same issue, so maybe QBs needs to research how and why this is happening at all. 

If anyone else has figured out how to clear this, please let me know!

JamesAndrewM
QuickBooks Team

Negative bill displayed in the Pay Bills window

It seems like you've encountered challenges with QuickBooks regarding negative bills and inactive vendors affecting aging reports. I'm here to help you connect with the best person that can help you.

 

Since you've already consulted with other accountants and explored various suggestions without success, it is best to connect with our QuickBooks Desktop Support, as it may require assistance from our Customer Care Team. Contact them for further guidance. They also have tools like screen sharing, guiding you through the process and identifying the cause of this issue.

 

Here's how you can reach them:

 

  1. Open QuickBooks.
  2. Go to the Help menu at the top.
  3. Select QuickBooks Desktop Help.
  4. Type Contact Us in the search box. Then, click on Contact Us at the bottom.
  5. Select the way you wish to connect with support.

 

Please refer to this article for additional details: Contact QuickBooks Desktop Support.

 

You can utilize this article for future reference: Customize reports in QuickBooks Desktop.

 

For additional QuickBooks-related concerns, don't hesitate to post them here in the Community. We're always available and willing to lend a hand to your queries. Have a great day ahead.

Need to get in touch?

Contact us