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

Eliminating "Paid" bills from the A/P ledger

I create a bill to track an o/s payable. I pay the bill. The expense flows into QBO from banking institution and is matched to the o/s payable. Now I have two line items in the A/P ledger. One for the original bill and one showing it's been paid.  Is there a way to clear "Paid" line items from A/P ledger so I'm viewing only those bills which are truly outstanding? 

4 Comments 4
JessT
QuickBooks Team

Eliminating "Paid" bills from the A/P ledger

Hi CT,

 

If you paid the bill, it shouldn't show on your Accounts Payable account anymore. Just to clarify, are you looking at your Accounts Payable (A/P) account in the Chart of Accounts, or you're looking at the A/P section in your General Ledger report? Then, when you say "two line items in the A/P ledger" you mean two transactions, right?

 

You can undo the bank transaction that flows in the A/P ledger. Then, match it to the bill payment transaction to remove the duplicate transaction.

  1. Go the Banking and choose Banking.
  2. Click the Reviewed tab and find the transaction.
  3. Click on Undo.
  4. Go back to the For Review tab and find the transaction.
  5. Match it to the bill payment transaction.

Please let me know how it goes.

Anonymous
Not applicable

Eliminating "Paid" bills from the A/P ledger

I'm looking at the Accounts Payable account in the Chart of Accounts where there are two line items pertaining to the same transaction. The first line item is Type Bill and the second Type Bill Payment. 

Anonymous
Not applicable

Eliminating "Paid" bills from the A/P ledger

My goal is to pull up all unpaid bills regardless of when I entered them or when they were due. 

HoneyLynn_G
QuickBooks Team

Eliminating "Paid" bills from the A/P ledger

Hello there, @Anonymous.

 

I appreciate you coming back to us for additional support and providing extra details. Allow me to join this thread and share more insights.

 

The A/P Register's transaction list setup is the first line (Bill) and second (Bill Payment). To achieve your goal, we can run a report to show all unpaid bills.

  1. Click Reports.
  2. On the Search field, enter Unpaid Bills.

 

That should do it. You also have the option to customize the report, CT.

 

Keep me posted if there's anything else you need about reports. I'm still here to help you further. Wishing you all the best!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up