Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello. 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.
"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.
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:
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.
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!
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!
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.
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 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."
Thanks Jelayca. It looks like I wasn't clear enough. Sorry, but your reply doesn't appear to answer my question.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.