Solved

Listing of Checks & Bills they paid

Forum|Forum|1 year ago
February 27, 2025
3 replies
248 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?

QuickBooks Desktop

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:

Click on the Reports menu.
Select Transactions List by Vendor.
Choose your desired date range.
Tap on the Customize option.
In the filter tab, click on Payment Method. Then select Check.
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!

Tori B

Answer

QuickBooks Team

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:

Click on the Reports menu.
Select Transactions List by Vendor.
Choose your desired date range.
Tap on the Customize option.
In the filter tab, click on Payment Method. Then select Check.
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!

E

eljac9

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

M

Mirriam_M

QuickBooks Team

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:

Go to the Vendors menu at the top.
Choose Bill Tracker.
Click the PAID tab at the top.
Filter the Date to the month that you need.
Select the Bills.
In the Batch Actions dropdown menu at the bottom, choose Print Selected.
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:

Go to the Reports menu at the top.
Choose Accountant & Taxes, then select Transaction Detail by Account.
Click the Customize Report button at the top left.
On the Filters tab, search for Transaction Type and select Bill Payment (or "Bill" depending on which date you are tracking).
Search for Date and set it to This Month.
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.
Click OK and then Print.

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

Sign up

Login with SSO

Let's get you signed in

Login with SSO