Batch Report for Bills Being Paid

I have heard from several clients that they would like to print a list of the bills being paid before the checks are cut (or just cut). What you can currently do in QuickBooks is run through your AP Aging Report or your Unpaid Bills report so you know what’s outstanding. But many times, the business owner would like to actually see what bills are being paid before the checks are cut or have a report showing what bills were just paid. Unfortunately QuickBooks does not have a built-in report to do this. (As an aside, you can send a request to Intuit that they work on this by clicking on Help and Send Feedback. They do listen to this feedback so the more people they hear from the higher up the list that request goes). But back to the topic at hand.

Here’s a workaround solution; not ideal, but will probably work for most of you.

  • Click on Reports>Custom Transaction Detail.
  • Set the date to Today. If you do more than one batch, this is where this workaround falls short. But for many of you this will be all that you need.
  • In the list of columns below, I would recommend that you put a checkmark by the Entered/last modified space if you do more than one batch.
  • You can Total By either Vendor or simply leave it at Total Only.
  • I would sort by Vendor (if you have not totaled by vendor)
  • On the Filters tab, I would select your checking account for the Account instead of all accounts.
  • For Transaction Type select Bill Payment

For printed status ( you’ll need to scroll down to find this)  select To be printed. (If this report is for after the bills were paid, then you would select Printed.)

You can customize this report further to change what columns you see.

If you will want this frequently, then I would memorize the report. If you want to give this report a name other than Custom Transaction Detail then I would click on Modify Report then Header/Footer and then change the report name.

One other comment with memorizing reports, I suggest you use the date from the drop-down list rather than manually keying in the date that you want to use. This way the report will move forward with you. Otherwise you will always have to go in and change that date.

I’d love to hear how this works for you!

This entry was posted in Business Finance, QuickBooks and tagged , , , , . Bookmark the permalink.

6 Responses to Batch Report for Bills Being Paid

  1. Will says:

    At what point in the selection process do you run this report?

  2. Before you print the checks but after you’ve selected the bills you want paid.

  3. Will says:

    I’m using QB 2013. So I select an invoice with a checkmark,, at this point the report is blank. If I click on Pay Selected Bills the system wants a check number which I assign. I can’t run the report now as it won’t let me and anyway the payment been recorded in the register. What am I missing?

  4. You can change the setting from assign check number to “to be printed”. Then after reviewing the report, you can either click the Print Checks icon on the Home page or click on File>Print Forms>Checks.

  5. John says:

    It appears this report creates a list of checks cut, not neccesarily a list of bills paid that day. A particular check could have paid 3 bills.

    Do you know how to get a list of just the bills paid, and not the actual checks?

  6. You can run a Find report and filter for:
    Account: A/P
    Transaction Type: Bill
    Paid Status – Closed
    Entered/Modified – the date you paid

Leave a Reply

Your email address will not be published. Required fields are marked *