cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Paid bills show as unpaid in the Pay Bills window

Hello,

In the A/P Aging Reports, I have one vendor showing an open balance.  When I look at detail, there is a Bill and a Bill Payment that match the open balance.  When I click transaction history for the bill payment, it shows it was applied to the bill.  The bill (which is marked paid) shows the bill payment in its history.  Everything agrees.  No open balance shows in Vendor Center, only in A/P Aging.

To further investigate, I found the transaction in the A/P register and ran a Quick Report on the Vendor.  Sure enough, it shows the Bill, marked paid, followed by the Bill Payment, which is strangely marked "Unpaid," thus showing an open balance.  This bill payment check has cleared, and from all I can see in transaction history, was applied to the bill.  

To experiment, I selected a check from the vendor in the Pay Bills screen, and sure enough, a credit for the amount in question is displayed.

Something is out of whack - any help?



Solved
Best answer 05-06-2019

Accepted Solutions
Community Manager

Re: Paid bills show as unpaid in the Pay Bills window

When bills, which are already paid, show as unpaid in the Pay Bills window, or, in this case, the A/P Aging Report, check if there are available credits (from unapplied bill payments, recorded credits, or journal entries to the Accounts Payable account) that should be applied to those bills. Another possible issue, though less likely occurrence, is transaction damage.

Before proceeding with the recommended solutions below, use Vendor QuickReports to verify if the bill showing as unpaid is actually paid.

  1. From the Vendors menu, select Vendor Center.
  2. Right-click the vendor of the bill in question, and select QuickReport.
  3. Set the date of the report to All.
  4. Find and double click the bill that shows in the Pay Bills window.

If the bill was paid, select History (or press Ctrl+H) to see the details of how it was paid. If not, proceed with the solutions below.

 

Check and apply available credits

 

Important: This solution applies if there is available credit balance that came from unapplied bill credit, payment, or a journal entry to Accounts Payable.

 

  1. From the Vendors menu, select Pay Bills.
  2. Select the bill in question, then select Set Credits.
  3. Go to the Credits tab and see if there are available credits.
  4. If a credit exists, select the credit and click Done.
  5. Select Pay Selected Bills.

If after following the steps in this solution and the bill still appears unpaid in the Pay Bills window or Unpaid Bills Detail Report, the transaction might be damaged.

 

Troubleshoot damaged bill payment or bill

Solution 1: Edit the transaction

  1. Create a backup of the company file.
  2. For reference, take note of the important information of the bill payment check like Date, Amount, and Vendor Name.
  3. Change the date of the bill payment check.
    1. Open the bill payment check associated with the bill.
    2. Change the date to 10 years in the future.
    3. Select Save & Close.
    4. Re-open the bill payment check and change the date back to its original date.
    5. Select Save & Close.

If the bill still shows as unpaid, proceed to solution 2.

Solution 2: Delete and re-enter the bill payment check and bill

  1. Create a backup of the company file.
  2. Delete the bill payment check.
    1. From the Unpaid Bills Detail report, double-click the payment check.
    2. Take note of the Date, Check Number and Amount.
    3. On your keyboard, press Ctrl+D to delete the transaction.
    4. Select OK to confirm the action.
    5. Close the currently displayed check.
  3. Delete the bill.
    1. From the Unpaid Bills Detail report, double-click the bill.
    2. Take note of the Date, Reference Number, Accounts, Items and Amount.
    3. On your keyboard, press Ctrl+D to delete the transaction.
    4. Select OK to confirm the action.
    5. Close the currently displayed bill.
  4. Re-enter the bill and bill payment check using the same information from the original transaction.

Note: If the bill payment check has been cleared, a mini-reconciliation is necessary.

20 Comments
Not applicable

it is showing a negative on my aging report but when I go...

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
Established Member

Check your date entered on your bill. If it is in the fut...

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.
Not applicable

"Open the bill payment check > uncheck the bill it 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?
Not applicable

Thx for responding but you took my question out of contex...

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."
Not applicable

If you have this problem, double check your dates. The ye...

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.
Established Community Backer ***

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

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

My Bill Pay Screen shows bills already paid in past years...

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

Open the bill payment check > uncheck the bill it paid >...

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

Worked perfectly! Thank you for this!

Worked perfectly! Thank you for this!
Not applicable

Thank you for posting this. What if the bill was paid thr...

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.
Established Community Backer ***

Using JE for AP is always the problem. They are not prope...

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.
Established Member

I think I have a similar problem--should I save after unc...

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!
Established Community Backer ***

Checking and Unchecking will Relink the transactions, and...

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.
Active Member

I have unchecked and rechecked the bill but the bill paym...

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?
Established Community Backer ***

I've been working with a file that has a negative AP for...

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.
Established Community Backer ***

"any other suggestions to zero out my open balance showin...

"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.


Frequent Explorer **

Reference this post in my new post. Please.

Reference this post in my new post. Please.
Community Manager

Re: Paid bills show as unpaid in the Pay Bills window

When bills, which are already paid, show as unpaid in the Pay Bills window, or, in this case, the A/P Aging Report, check if there are available credits (from unapplied bill payments, recorded credits, or journal entries to the Accounts Payable account) that should be applied to those bills. Another possible issue, though less likely occurrence, is transaction damage.

Before proceeding with the recommended solutions below, use Vendor QuickReports to verify if the bill showing as unpaid is actually paid.

  1. From the Vendors menu, select Vendor Center.
  2. Right-click the vendor of the bill in question, and select QuickReport.
  3. Set the date of the report to All.
  4. Find and double click the bill that shows in the Pay Bills window.

If the bill was paid, select History (or press Ctrl+H) to see the details of how it was paid. If not, proceed with the solutions below.

 

Check and apply available credits

 

Important: This solution applies if there is available credit balance that came from unapplied bill credit, payment, or a journal entry to Accounts Payable.

 

  1. From the Vendors menu, select Pay Bills.
  2. Select the bill in question, then select Set Credits.
  3. Go to the Credits tab and see if there are available credits.
  4. If a credit exists, select the credit and click Done.
  5. Select Pay Selected Bills.

If after following the steps in this solution and the bill still appears unpaid in the Pay Bills window or Unpaid Bills Detail Report, the transaction might be damaged.

 

Troubleshoot damaged bill payment or bill

Solution 1: Edit the transaction

  1. Create a backup of the company file.
  2. For reference, take note of the important information of the bill payment check like Date, Amount, and Vendor Name.
  3. Change the date of the bill payment check.
    1. Open the bill payment check associated with the bill.
    2. Change the date to 10 years in the future.
    3. Select Save & Close.
    4. Re-open the bill payment check and change the date back to its original date.
    5. Select Save & Close.

If the bill still shows as unpaid, proceed to solution 2.

Solution 2: Delete and re-enter the bill payment check and bill

  1. Create a backup of the company file.
  2. Delete the bill payment check.
    1. From the Unpaid Bills Detail report, double-click the payment check.
    2. Take note of the Date, Check Number and Amount.
    3. On your keyboard, press Ctrl+D to delete the transaction.
    4. Select OK to confirm the action.
    5. Close the currently displayed check.
  3. Delete the bill.
    1. From the Unpaid Bills Detail report, double-click the bill.
    2. Take note of the Date, Reference Number, Accounts, Items and Amount.
    3. On your keyboard, press Ctrl+D to delete the transaction.
    4. Select OK to confirm the action.
    5. Close the currently displayed bill.
  4. Re-enter the bill and bill payment check using the same information from the original transaction.

Note: If the bill payment check has been cleared, a mini-reconciliation is necessary.

Experienced Member

Re: I've been working with a file that has a negative AP for...

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?

QuickBooks Team

Re: I've been working with a file that has a negative AP for...

Hey there, @iankairos,

 

I see that you've posted the same question twice, and the other one was already answered by my colleague Rasa-LilaM. Just in case you haven't been notified of the new response, here's the link: https://quickbooks.intuit.com/community/Transactions/Clearing-out-old-transactions-from-Accounts-Pay...

 

In order to keep the conversation streamlined, I'm going to ask that you post any responses there.

 

Feel free visit the Community for more questions and I'll be happy to answer them for you. I hope you have a great week ahead.