cancel
Showing results for 
Search instead for 
Did you mean: 
Cindy316
Level 1

Clear Old Vendor Bills Already Paid

Hello. I’m new at this agency. I need to clear out all the old bills (already paid) showing on the AP Aging Report.

Bills were entered through AP module, Db expense accounts. Some payments were made via ACH, debit, or credit card on the vendor websites not through QBDT. And the payments were entered as journal entries, Db AP and Cr either credit or debit account.  

To zero out a bill paid via credit/debit account and payment was entered as a journal entry like I’ve mentioned above, I clicked on Set Credits, and applied the credit to the bill. On the bottom of the Pay Bills screen, under Method, in the box, there are Scheduled Online Payment, Check, and Credit Card. Since we don’t have any *credit or debit account* set up in QB, I couldn't choose Credit Card so I had to choose Check instead and clicked Pay Selected Bills.  The bill is taken off from the AP Aging report and in G/L it’s showing Bill Pmt-Check in the Type column. I’m not sure if I did it correctly and its showing Bill Pmt-Check in G/L is acceptable since it was actually paid via credit/debit.  

 

*We have a G/L credit account and it's reconciled, but I don't think we have the credit account set up and connected to the bank. 

I don't have a full access under Accounting Tools to use Fix Unapplied Vendor Payments and Credit. I'm wondering if using it would be different and better than using the method above. 

 

Thanks in advance for sharing your insights.

7 Comments 7
Rainflurry
Level 13

Clear Old Vendor Bills Already Paid

@Cindy316 

 

"Bills were entered through AP module, Db expense accounts. Some payments were made via ACH, debit, or credit card on the vendor websites not through QBDT. And the payments were entered as journal entries, Db AP and Cr either credit or debit account."

 

What do you mean by "A/P Module"?  Are you entering bills by going to Vendor > Enter Bills or clicking the Enter Bills icon on the home screen?  When you pay bills in QB, you should use Pay Bills (either click the Pay Bills icon on the home screen or go to Vendor > Pay Bills) and not a journal entry.  When you use Pay Bills, QB creates the journal entry that you're entering (debit A/P, credit payment account), but it also applies the payment to the bill and closes it out.  You're doubling your work by making a journal entry and then applying it to the bill.  Pay Bills does that in one entry.  All of your questions seem to be as a result of the unnecessary journal entry you're creating so, unless you must use a journal entry to pay bills for some reason, this hopefully answers your other questions.      

Jelayca V
QuickBooks Team

Clear Old Vendor Bills Already Paid

I appreciate the detailed information you've shared, Cindy. I'm here to ensure that this will be addressed promptly.

 

As Rainflurry mentioned, when you're using QuickBooks to pay bills, it's important to use the Pay Bills option and not the Journal Entry (JE) option to clear it. This is because paying bills with this feature does two things: it creates a JE and it applies the payment to the bill, closing it out. This simplifies the process by eliminating the need to create a JE and then apply it to the bill separately. 

 

To link or apply the JE payment to the bill using the Pay Bills feature, here's how: 

 

  1. Hover over to the Vendors menu, then select Pay Bills.
  2. Choose the accounts payable account from the dropdown and check the boxes of the bills you want to pay.
  3. Apply any Discounts or Credits that you want to use.
  4. Enter the date you paid the bill.
  5. Choose your payment method from the list: CheckCredit CardOnline Bill PaymentOnline Bank Payment, CashDebit or ATM cardPayPalor EFT.
  6. Click Pay Selected Bills.
  7. If you have more bills to pay, click Pay More Bills. Otherwise, click Done

 

If you're experiencing issues or have questions about paying bills in QuickBooks, it's crucial to understand that this can be a result of the unnecessary JE you're creating. Unless you have a specific reason for using a JE to pay bills, it's best to stick with the Pay Bills to streamline your workflow and ensure that your finances are accurate and up-to-date.

 

Furthermore, paying bills is part of your usual accounts payable workflow in QuickBooks Desktop (QBDT). For more information on vendor-related transactions and workflows, you can refer to this article: Account Payable Workflow.

 

If you have further questions about bills in QBDT, please don't hesitate to reach out to us. The Community is always available to help. Keep safe. 

Cindy316
Level 1

Clear Old Vendor Bills Already Paid

Rainflurry - Thanks for you insight!!!

 

I'm new here. My boss asked me to clean up the A/P mess. The previous bookkeeper used Enter Bills to enter bills; some of those old bills are still hanging out there because she made the payments via credit or debit card on the vendor websites and booked the payments as journal entries. We still don't have any credit or debit card set up in QB. Do you know the correct way to clear out those old bills? Thank you so much and have a nice day!

Cindy316
Level 1

Clear Old Vendor Bills Already Paid

Hmm I don't see my reply...Let me try again.

 

Rainflurry - Thanks for your insight!!!

 

I'm new here. My boss asked me to clean up the A/P mess. The previous bookkeeper used Enter Bills to enter bills; some of those old bills are still hanging out there because she made the payments via credit or debit card on the vendor websites and booked the payments as journal entries. We still don't have any credit or debit card set up in QB. Do you know the correct way to clear out those old bills? Thank you so much and have a nice day!

Rainflurry
Level 13

Clear Old Vendor Bills Already Paid

@Cindy316 

 

Clear the old bills by going to Pay Bills.  When you click on a bill, in the box below, you should see credits available.  If you don't see credits available, then the journal entry didn't debit A/P for that vendor.  To apply the payment created by the journal entry, click on 'Set Credits' and apply them.  That's it. 

Cindy316
Level 1

Clear Old Vendor Bills Already Paid

Thanks Rainflurry. I did all that...But what about the Method? Please read the paragraph below from my original post. What I really wanted to know is what to do so I could choose Debit Card or Credit Card instead of Check under Method because the payment was made either with a debit or credit card.  Perhaps we need to have the credit and debit cards set up in QB then we can choose??? Thank you.

 

"To zero out a bill paid via credit/debit account and payment was entered as a journal entry like I’ve mentioned above, I clicked on Set Credits, and applied the credit to the bill. On the bottom of the Pay Bills screen, under Method, in the box, there are Scheduled Online PaymentCheck, and Credit Card. Since we don’t have any *credit or debit account* set up in QB, I couldn't choose Credit Card so I had to choose Check instead and clicked Pay Selected Bills.  The bill is taken off from the AP Aging report and in G/L it’s showing Bill Pmt-Check in the Type column. I’m not sure if I did it correctly and its showing Bill Pmt-Check in G/L is acceptable since it was actually paid via credit/debit."  

Cindy316
Level 1

Clear Old Vendor Bills Already Paid

Thanks Jelayca. It looks like I wasn't clear enough. Sorry, but your reply doesn't appear to answer my question.  

Need to get in touch?

Contact us