Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I need to create a report that will give me the quantity of bills per month using the bill date. It would be nice if it could display the columns OR rows by month with just the number of invoices for that month.
It's my priority for you to run the report you need in QuickBooks Desktop, tlbarton.
We can run the Transaction List by Vendor report and customize it to show the Billed Date, Quantity, and all the bills on a monthly period. Let me show you how:
If you need to add and modify columns to come up with the report data you need, just click the Excel button. then, choose Create New Worksheet to export the report. You can check out this article to learn how to customize vendor reports in QuickBooks Desktop: Customize vendor reports. You might also want to memorize reports in QuickBooks Desktop. This way, you do not have to go through the customization process again.
Feel free to visit our Reports page for more insights about managing your company's financial report in the software.
We're always available to help you. You're welcome to post again if you need anything else in managing your bank register. Have a great day.
Thank you - I'll try this :) Have a great weekend!!
Please let us know how it goes, @tlbarton.
As my colleague mentioned, we are always here whenever you have questions or concerns. Take care, and have a wonderful weekend!
Unfortunately QB doesn't really have reports that will show you the counts of transactions. However, if you create a report that lists the transactions, one row per transaction, then you can export it to Excel in order to add formulas to arrive at those counts.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here