Skip to main content
C
Cindy316
April 19, 2024
Question

Clear Old Vendor Bills Already Paid

  • April 19, 2024
  • 1 reply
  • 0 views

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.

1 reply

Rainflurry
Rainflurry
April 19, 2024

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

    J
    Jelayca V
    April 19, 2024

    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: Check, Credit Card, Online Bill Payment, Online Bank Payment, Cash, Debit or ATM card, PayPal, or 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. 

    C
    Cindy316Author
    April 23, 2024

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

    Terms & ConditionsAccessibility statement