cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
DClark5
Level 2

Listing of Checks & Bills they paid

Is there any way to get a report in QB Desktop Enterprise that either lists the checks for a date range that includes the Bills that they paid?
Or conversely, a report that lists all the bills in a date range and the check number that paid it?
If not in QB, any suggestions on 2 reports to export to Excel that I can use a VLookup formula to match up the bills & checks?

Solved
Best answer 4 weeks ago

Best Answers
Tori B
QuickBooks Team

Listing of Checks & Bills they paid

Hey there, @DClark5

 

How are today? I hope all is well. 

 

You can run a Transaction List by Vendor report, filtering by the desired date range and ensuring the Payment Method is set to "Check" to only display paid bills with check numbers. 

 

Here are some steps to run the report:

 

  1. Click on the Reports menu. 
  2. Select Transactions List by Vendor. 
  3. Choose your desired date range. 
  4. Tap on the Customize option.
  5. In the filter tab, click on Payment Method. Then select Check
  6. Hit Run Report

 

That should do the trick. For more information about customizing reports, check out Customize Reports in QuickBooks Desktop

 

Please don't hesitate to let me know if you have any additional questions or concerns. I'm happy to help. Have a good one! 

View solution in original post

1 Comment 1
Tori B
QuickBooks Team

Listing of Checks & Bills they paid

Hey there, @DClark5

 

How are today? I hope all is well. 

 

You can run a Transaction List by Vendor report, filtering by the desired date range and ensuring the Payment Method is set to "Check" to only display paid bills with check numbers. 

 

Here are some steps to run the report:

 

  1. Click on the Reports menu. 
  2. Select Transactions List by Vendor. 
  3. Choose your desired date range. 
  4. Tap on the Customize option.
  5. In the filter tab, click on Payment Method. Then select Check
  6. Hit Run Report

 

That should do the trick. For more information about customizing reports, check out Customize Reports in QuickBooks Desktop

 

Please don't hesitate to let me know if you have any additional questions or concerns. I'm happy to help. Have a good one! 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us