Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
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 February 27, 2025

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

3 Comments 3
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! 

eljac9
Level 1

Listing of Checks & Bills they paid

I have used the calendar display of bills paid and the date

 

Is there a means of printing a report based on that format for a full month

 

Elmer

Mirriam_M
QuickBooks Team

Listing of Checks & Bills they paid

Hi there, Elmer.

 

At this time, QuickBooks Desktop (QBDT) doesn't have an exact report that based on the calendar view format for you to print. While the calendar is great for viewing, in the meantime, you can use the Bill tracker for a more interactive list that you can print.

 

Here's how:

 

  1. Go to the Vendors menu at the top.
  2. Choose Bill Tracker.
  3. Click the PAID tab at the top.
  4. Filter the Date to the month that you need.
  5. Select the Bills.
  6. In the Batch Actions dropdown menu at the bottom, choose Print Selected.
  7. Follow the onscreen steps.

 

You can also run the Transaction List by Date report that lists all the bills for the full month but in a more standard report format.

 

Here's how:

 

  1. Go to the Reports menu at the top.
  2. Choose Accountant & Taxes, then select Transaction Detail by Account.
  3. Click the Customize Report button at the top left.
  4. On the Filters tab, search for Transaction Type and select Bill Payment (or "Bill" depending on which date you are tracking).
  5. Search for Date and set it to This Month.
  6. On the Display tab, ensure the Date, Name (Vendor), and Amount columns are checked. You can change the Total By dropdown to Day or Week to mimic the chronological flow of a calendar.
  7. Click OK and then Print.

 

If you need anything else, feel free to reach out. We’re here to help you.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us