Batch Report for Bills Being Paid

Finance

  • Author Monica Muir
  • Published November 19, 2011
  • Word count 410

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

Muir & Associates helps businesses use their Intuit products more efficiently and more effectively so businesses can focus on their business and make more informed decisions. We provide sales and support services. Monica Mitchell Muir has been helping businesses with their QuickBooks products since 1996.

http://www.muirassoc.com

http://muirassoc.com/blog/

Article source: https://articlebiz.com
This article has been viewed 419 times.

Rate article

Article comments

There are no posted comments.