How to run an unpaid vendor bill report for jobs that were paid? Quickbooks Desktop

Hello Andriy1,

Thank you for connecting with us! You can run a Transaction Detailed Report and filter it for AP accounts as well as the Open Status. Also, you could filter the transaction type to Bills. Here's how to run that report:

1. Go to Reports, then Custom Report, and select Transaction Detail.
2. Select Customize report.
3. Enter the Report Date Range.
4. Under the Columns area, make any adjustments.
5. Go to the Filters tab and make adjustments as needed. 
6. Select OK.

Let me know if that is more efficient for you.  I'm always here whenever you need help with QuickBooks Desktop reports. Stay safe, and have a good one!

Hi Sasha,

I followed your instructions, thank you, but that's not quite what I meant.

How do I setup the report so that it shows all unpaid bills but only on jobs/invoices where payment was received/paid?

Thanks for coming back, Andriy1.

We can run the Transaction List by Vendor report to show all unpaid bills where the payment was received and paid. Here's how: 

1. Go to Reports, then Vendors & Payables.
2. Choose Transaction List by Vendor.
3. Click Customize report.
4. Enter the Report Date Range.
5. Tap Filters.
6. Enter Paid Status in the search field and choose Open.
7. Enter Transaction Type in the search field and choose Multiple Transaction Type and select Bill and Payments.
8. Enter Payment Method in the search field and choose from the list.
9. Press OK.

If you need to export the report to Excel to manually add the inactive accounts, just follow the steps below: 

1. Click the Excel drop-down from the top menu, then Create New Worksheet.
2. Tap Export.
3. Tap the Excel drop-down, then Create New Worksheet.
4. Press Export. 

Here's an article you can refer to for more details about exporting reports as Excel workbooks in QuickBooks Desktop. For additional information about the available reports you can run in QuickBooks Desktop and how to use them, here's a resource you can read: Understand reports.

Should you have additional questions or need further help, please let me know by adding a comment below. I'll be more than happy to answer them for you. Have a nice day!