Multi-period invoicing in Desktop

Glad to have you here in the Community, @SofiaPetersonCPA. I'd be delighted to help share information on how to pull up the reports you needed.

You can run the Transaction List by Customer report. This report gives you the transactions your company had with each of its customers. Let me show you how.

1. Click Reports at the top menu.
2. Select Customers & Receivables, and click Transaction List by Customer.
3. Click the Customize Report button located in the upper left-hand corner.
4. Tap the Display tab, and put a checkmark beside the Terms column.
5. Click the Filters tab, and select Invoice from the Transaction Type drop-down list.
6. On the same tab, click Terms and select the terms to be included in the report.
7. Click OK.
8. Change the Date and click Refresh.

Also, for the AP Vendor Bills, you can run the A/P Aging Summary and A/P Aging Detail report.  The A/P Aging Summary Report will show you how much you owe each vendor. While The A/P Aging Detail Report will show you all the invoices you have received from vendors along with the total amount you owe.

1. Select Reports from the top menu bar.
2. Go to Vendors and Payables.
3. Select A/P Aging Detail or A/P Aging Summary.
4. Click the Customize Report button.
5. Click the Filters tab, and select Invoice from the Transaction Type drop-down list.
6. Set the desired reporting date.

You can export the two reports to an Excel file, so you can compare the two reports and get the details you want. See this article for more details: Export reports as Excel workbooks in QuickBooks Desktop.

We can memorize this report to save its current customization settings. You can also efficiently manage your expenses and accounts payable by customizing any vendor reports in the software. To learn more about this process, visit this article: Customizing Vendor Reports. 

I encourage reading our Reports Guide to learn more about how QuickBooks populates the data in your reports.

Let me know if there's anything else you need about managing your reports in QuickBooks Desktop. I'm always right here to help. Take care always. 

Thanks @JoesemM for your response. Unfortunately, it did not address my issue. Let me try to explain better with an example.

My client issues a customer invoice dated December 2020 for 12 months of service for January – December 2021 totaling $120,000. They bill the whole annual fee and get paid in advance. Now they want to run reports showing monthly revenue. So they want to be able to run a report for January 2021 showing $10,000 revenue. How can we accomplish that without too much re-work? We don’t want to have to break each invoice into 12 smaller monthly ones, nor download the info to Excel and manually allocate the amount to each month covered by the invoice. My client has over 1,000 of these annual invoices.

Can we customize fields and put the beginning and ending dates/months? Or?

Thanks for coming back to us, @SofiaPetersonCPA.

I'm here to ensure you're able to pull up a report that shows the monthly revenue. This way, you can keep track of your sales and monitor your business growth.

In QuickBooks Desktop, we can run the Profit and Loss or Sales by Customer Summary report. The Profit and Loss report will also show your income, expenses, and net profit or loss over a specific period.

Here's how:

1. Go to the Reports menu.
2. Hover over Company & Financial, and then select Profit and Loss Standard.
3. Enter the date range.
4. Click the Shows Columns drop-down arrow, and then choose Month.

To pull up the Sales by Customer Summary report:

1. Select Reports from the top menu bar.
2. Hover over Sales, and then choose Sales by Customer Summary.
3. Enter the date range.
4. Select the Shows Columns drop-down arrow, and then choose Month.

You can also visit this article to be guided in personalizing and designing your reports: Customize reports in QuickBooks Desktop.

If I can be of any additional assistance, please don't hesitate to let me know by leaving a comment below.

Thanks for your response; however, it does not address my question. I know how to run reports. The issue is that the transaction is booked one time in one month but the client wants to see portions of it in several months. I think we've come up with a work-around that's faster than creating invoices for each month. We've added custom fields on the invoice. We can then run a report to Excel and write formulas based on those fields. It's a lot faster and more accurate than the alternatives. Thanks.

Thanks for sharing this solution, although it is very odd this is not an option within quick books with so many companies doing what you do - eg any SaaS company that books annually or companies providing annual support contracts!!

 I’m guessing that requires you to export at a transactional level and then aggregate for reporting purposes all in Excel?  Or have you managed to customise a report that aggregates in QB at some common level? 

Thanks for joining in on this thread, Steve_A.

Let me add some additional info about the report.

For now, we're unable to run monthly reports showing the invoice amount spread out over the payment term. You'll want to manually export the report to Excel. Otherwise, send this suggestion to our product developers. They'll review this idea and might consider updating it in the future.

Here's how:

1. Go to Help > Send Feedback Online > Product Suggestion.
2. Enter your feedback request and click on the Send Feedback button.

To learn more about the reports and how you can memorize, customize, or export them, please feel free to read these articles:

• Understand reports
• Create, access and modify memorized reports
• Export reports as Excel workbooks in QuickBooks Desktop

You're always welcome to post a reply on this thread if there's anything else you need. We'll be around to help. Take care and stay safe.