Monday 8 January 2018

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 Sage is run you 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 Sage 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.Sage Customer Support Phone Number 

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 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, that I would memorize the report. If you want to give this report a name other than Custom Transaction Detail than I would click on Modify Report then Header/Footer and that change the report name.

One other comment with memorizing reports, I suggest you use that 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 Sage products since 1996.

Sage Customer Support Phone Number If you desire to develop Sage distant availability or hosting, you may also wish to get Sage Help, and you will find out Qualified Sage advisors that could set up availability and also help to get your guides to be able.


No comments:

Post a Comment