Skip to main content
D
DClark5
February 27, 2025
Solved

Listing of Checks & Bills they paid

  • February 27, 2025
  • 1 reply
  • 0 views

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?

Best answer by Tori B

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! 

1 reply

Tori B
Tori BAnswer
February 27, 2025

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! 

Terms & ConditionsAccessibility statement