it is showing a negative on my aging report but when I go to payables it is not there when I run report on that vendor It is now there

Check your date entered on your bill. If it is in the future it will cause it to show up on your AP report even though it has in fact been paid.

"Open the bill payment check > uncheck the bill it paid > then re-cehck it" I tried this and it didn't work. any other suggestions to zero out my open balance showing up on A/R report?

Thx for responding but you took my question out of context... I have payments applied to the invoice directly yet on my A/R report the invoice still shows with the balance as if there is no payment linked to it. I tried unchecking and rechecking and logging out of QB after doing so and logging back in after and my report still shows the customer's invoice with a balance on the A/R report. Please suggest a remedy.

"Let's review that a 0 balance on the report means things are not applied to each other.

The request to Zero Out a balance means you Do Not Already have the offset or something that needs to be applied to it. Having a balance means it is waiting for you to Deal with it. Having a Zero Balance, but showing on the report, means things did not get Linked to each other, so the Math of the balance for the name is Zero.

These are two completely different conditions.

If you have an AP balance that you want to Offset, a positive balance or Bill is offset with a Bill Payment or a Vendor Credit. A negative AP balance means you have no Bill entered."

If you have this problem, double check your dates. The year for the date of payment was the wrong year. now the A/R has zero balance after fixing this.

You posted about AR in a topic for AP. The tasks are Different.

My Bill Pay Screen shows bills already paid in past years. How do I remove them from this screen without changing the financials?

Open the bill payment check > uncheck the bill it paid > then re-cehck it

Worked perfectly! Thank you for this!

Thank you for posting this. What if the bill was paid through general journal entries rather than an actual bill payment check? There is no way to uncheck/recheck the payment that I am aware of.

Using JE for AP is always the problem. They are not proper for managing AP. There is nothing on that JE you cannot put on a Vendor Transaction = Bill or Credit or Bill Payment.

I think I have a similar problem--should I save after unchecking and then recheck?  Is it just something weird that hangs it up in the system?  Also--this crrossed years there was a partial payment in 2015 and the balance paid in 2016.  Not sure if that matters.  Thanks!

Checking and Unchecking will Relink the transactions, and if there was only a partial amount, you still want that Partial Amount to be fully linked.

I have unchecked and rechecked the bill but the bill payment is still showing open in A/P aging. These are all for bills that were paid directly through bill pay. Thoughts?

I've been working with a file that has a negative AP for a vendor name, and it turned out to be an entry in the JE, which is why you never post to AP manually and you don't use JE for AR and AP, and not where Names might be needed.

"any other suggestions to zero out my open balance showing up on A/R report?"

Let's review that a 0 balance on the report means things are not applied to each other.

The request to Zero Out a balance means you Do Not Already have the offset or something that needs to be applied to it. Having a balance means it is waiting for you to Deal with it. Having a Zero Balance, but showing on the report, means things did not get Linked to each other, so the Math of the balance for the name is Zero.

These are two completely different conditions.

If you have an AP balance that you want to Offset, a positive balance or Bill is offset with a Bill Payment or a Vendor Credit. A negative AP balance means you have no Bill entered.

Reference this post in my new post. Please.

Just to understand this relationship. Why shouldn't we use JE for AP or AR? This should be natural in accounting. Could you explain the relationship between the AP module, the vendor names and the effects on the G/L? 

 

I am trying to clear some small AP vendor balances and I need some help. 

I originally created a journal entry and adjusted the balances to $0. But then I noticed that even if the amount was at $0 the bill still appeared as over 90 days on my aging. I reversed the entry as I thought there had to be another way. I also tried a vendor credit but again the amount keeps showing in 90 days and over. As I keep reading I find that I was doing it originally right and all I was needing was to check the credit on the pay bill section but now as I posted and reversed the entry It does not appear on the pay bill section to select the credit.

 

How can I write off these payables correctly and take them out of my AP Aging?

Hi, I've been trying your fixes for this error, and sadly no success.  I enter the bill.  It appears correctly in the pay bills window.  I pay the bill, the vendor now has zero balance.  However, the invoice has magically reappeared in the pay bills window.  There is no balance owing in the vendor home page, and no balance owing in the AP summary.  There are no credits to apply.

 

If I tick and untick the bill to apply the payment to in the payment screen, the amount owing somehow doubles.

 

This has not happened to any other payable invoices.

Thanks for reaching out to us here in the Community, @Wray.

Based on the information provided, it looks like the transaction is damaged. To resolve the issue, let’s delete and recreate the bill and bill payment.

Before proceeding, it’s always a good idea to create a backup copy of the company file. Next, open the Unpaid Bills Detail Report and double-click the bill to see the complete details.

 

Please note of the Date, Check Number and Amount. You'll need the following information when creating the transaction.

 

Now, let’s go ahead and remove it. Here’s how:

 

1. On the Bill page, choose the Edit menu to select Edit Bill.
2. In the Delete Transaction window, hit the OK button to confirm the process.
   

 

To delete the bill payment check:

 

1. Open the transaction.
2. Choose the Edit menu then pick Delete Bill/Bill Pmt-Check.
3. Click OK to confirm the action.
   

The following article provides detailed information when to void or delete a transaction: Bill or bill payment check.

 

Next, re-enter the bill and bill payment check using the same information from the original transaction. However, if none of these suggestions work, run the Rebuild and Verify Data utility tools to detect any issues in your company file and to correct it.

 

Here's how to rebuild:

 

1. Go to the File tab to select the Utilities menu, and then choose Rebuild Data.
   
2. When the QuickBooks Desktop Information window opens, hit the OK button.
3. Follow the on-screen instructions to create a backup copy.
4. Click on OK once you see the following message “Rebuild has completed”.

To verify the data:

 

1. Go to the File tab to select the Utilities menu, and then choose Verify Data.
   
2. Once you see receive this message “QuickBooks detected no problems with your data”, click the OK button.
   
3. If the tool finds an issue with your data, you’ll be prompted to Rebuild Now or View errors.
4. Hit OK and continue performing the troubleshooting steps.

For detailed instructions, go directly to the Review Last Verify/Rebuild section to continue. Click here to view the steps.

For future reference, check out the following article: A paid bill or invoice shows on report or window of open transactions.

Stay in touch if you have any other concerns or questions. Please know I’m always ready to help you. Have a good one.  

 

Thank you for your suggestions.  Unfortunately the rebuild and verify utility showed no errors.   I tried changing the transaction date to 20 years ahead, and change it back.  That also did not clear the error.   Other transactions are not showing any problems at all.  I have deleted and re created this item a number of times.   I post a partial payment, and the correct balance owing shows in the Pay Bills window.   I can post partial payments until only $1 is owing, and the correct outstanding amount shows in the pay bills window.  But as soon as I pay the remaining amount, suddenly the entire invoice is showing as payable again.  But only in the pay bills window, not in the vendor list or the AP summary.   There are no unapplied credits linked to the invoice.

 

It is very strange.

 

 

Hi there, @Wray.

 

I appreciate you going through the steps provided by my colleague above, Let's try to check if there are Checks or Journal Entry link to that bill. I'm here to guide you how.

 

A bill that is linked to a check or journal entry will still show as payable in the pay bill window. To check:

1. Open the vendor profile of your vendor.
2. Click View as a Report under the Run Report drop-down menu.
3. Click Customize Report.
4. In the Filters tab, select Transaction Type.
5. Choose Multiple Transaction Types and select Check and Journal then click OK.
6. Click OK again to run the report.

If the report shows a journal entry that is linked to that bill, I suggest reaching out to your accountant for further assistance on why the Journal was created.

 

If there is a check link to that bill, you'll have to remove the check and pay the bill or link the check to the bill. You can refer to this article for the detailed steps: Bill Shows as Unpaid After Writing a Check.

 

I'm also adding these articles that can help guide you in your future tasks:

• Record vendor prepayments or deposits for prepaid parts or services
• Record a vendor refund in QuickBooks Desktop

If you have other concerns or questions, don't hesitate to reach out to us. We're always here to help.