cancel
Showing results for 
Search instead for 
Did you mean: 
bengw1218
Level 2

How do you eliminate bills on the Pay Bills tab without affecting accounts payable?

How do you eliminate bills on the Pay Bills tab without affecting accounts payable?

Solved
Best answer November 29, 2023

Best Answers
Kevin_C
QuickBooks Team

How do you eliminate bills on the Pay Bills tab without affecting accounts payable?

Thanks for getting back into this thread and providing details of what you've done so far, @bengw1218. Let me lay out some information regarding your concern about handling unapplied credits in QuickBooks Online (QBO).

 

One of the possible reasons that it still showed up in your Accounts Payable (A/P) Detail report after paying/linking them is that the date of the Journal Entry is not the same as the date on your credits.

 

To sort this out, you can update the Journal date to the same date as the credits by pulling up the A/P detail report. Here's a sample screenshot for your visual reference:

 

To make sure that the correct credit and journal entry are linked properly, we can use the expense or check option instead of the pay bills window.

 

If the issue persists, can you please share a screenshot of how it showed up in your A/P Aging Detail report? And how did you link the credit to the journal entry?

 

Additionally, you can customize your vendor reports in QBO to show the correct data for each company. Then, you can use this resource as a reference if you want to export your reports to Excel: Export your reports to Excel from QuickBooks Online.

 

I'd love to know how it goes after performing the steps above, as I want to ensure this is resolved for you. Just leave a comment below, and I'll get back to you. Goodbye for now, and have a great day ahead!

View solution in original post

6 Comments 6
ArielI
QuickBooks Team

How do you eliminate bills on the Pay Bills tab without affecting accounts payable?

Hello, @bengw1218.

 

Let me share with you the quickest way to delete a bill. 

 

Please be reminded that creating and deleting a bill will affect accounts payable. If you don't mind me asking, can you tell me why you want to delete a bill?

 

Furthermore, let me share some simple steps to delete bills. Here's how: 

 

  1. Go to Expenses, then select Expenses.
  2. Locate the bill to delete.
  3. In the Action column, select Delete from the dropdown menu.
  4. When prompted, select Yes to confirm that you want to delete the bill.

 

If you need help with deleting a bill, you can always refer to this article: Delete a bill in QuickBooks Online.

 

For future reference, if you need to recreate deleted transactions in QBO, you can use the Audit Log report. Check out this article for detailed steps: Use the audit log to re-enter deleted transactions. 

 

I am always here to help you with any concerns you have regarding deleting bills in QuickBooks. Take care! 

bengw1218
Level 2

How do you eliminate bills on the Pay Bills tab without affecting accounts payable?

I tried this but the items were not under any expense. I first ran the report of ap detail and these were all credits showing, I than made journal entry which got them off the report but put them on the pay biils tab. I tried paying them with credits but that just put them back on the ap detail report.

Kevin_C
QuickBooks Team

How do you eliminate bills on the Pay Bills tab without affecting accounts payable?

Thanks for getting back into this thread and providing details of what you've done so far, @bengw1218. Let me lay out some information regarding your concern about handling unapplied credits in QuickBooks Online (QBO).

 

One of the possible reasons that it still showed up in your Accounts Payable (A/P) Detail report after paying/linking them is that the date of the Journal Entry is not the same as the date on your credits.

 

To sort this out, you can update the Journal date to the same date as the credits by pulling up the A/P detail report. Here's a sample screenshot for your visual reference:

 

To make sure that the correct credit and journal entry are linked properly, we can use the expense or check option instead of the pay bills window.

 

If the issue persists, can you please share a screenshot of how it showed up in your A/P Aging Detail report? And how did you link the credit to the journal entry?

 

Additionally, you can customize your vendor reports in QBO to show the correct data for each company. Then, you can use this resource as a reference if you want to export your reports to Excel: Export your reports to Excel from QuickBooks Online.

 

I'd love to know how it goes after performing the steps above, as I want to ensure this is resolved for you. Just leave a comment below, and I'll get back to you. Goodbye for now, and have a great day ahead!

bengw1218
Level 2

How do you eliminate bills on the Pay Bills tab without affecting accounts payable?

This worked to clear everything except for one vendor. I had several entires that i was able to clear but when I ran AP detail there was still something left. When I drilled down on the the amount the detail didn't match the summary.   137.22. ???? When I try to fix this nothing changes.

MarkAngeloG
QuickBooks Team

How do you eliminate bills on the Pay Bills tab without affecting accounts payable?

Hi there, @bengw1218.

 

I can help you clear a credit from your Accounts Payable Aging Detail, but I need your cooperation for more details. May I ask how you recorded the journal entry linked to the bill? If you have used journal entries to clear the vendor credit, I recommend consulting your accountant to ensure you are debiting/crediting the correct accounts.

 

Also, the total open balance of -137.22 means you still have a credit left to apply to any unpaid bill. In the meantime, you can click the total available credits and review the amounts applied to a payment. Ensure that your credit is distributed to each bill correctly to clear the credit from the report.

 

Furthermore, It's best to consult your accountant regarding this situation since you're dealing with journal entries.

 

After dealing with everything, you can customize your reports in QuickBooks Online and use filters only to show specific details.

 

Let me know if you have further questions about eliminating bills from the Accounts Payable report. I'd be glad to assist you further. 

bengw1218
Level 2

How do you eliminate bills on the Pay Bills tab without affecting accounts payable?

This was cleared by issuing a bill with the oldest date on it.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us