Four Revenue Stream w/ COGS on One TTM report

jpetersonvp · ‎August 30, 2024

I am in the process of creating a month's end report that will show me my 4 revenues streams that I track, and their associated COGS on the same Excel exportable TTM Profit and Loss report. Each rev. stream and it's COGS at the top of the report, so I can clearly present each stream's gross margin at our month's end meeting.

I have put the revenues into classes, but it only shows each class on a separate report, so I will have to import into an Excel file to centralize the information. I'm looking to automate the process to make month's end more smooth.

Any insight? I am happy to rearrange my Chart of Accounts or implement other methods to track as long as in the end it's as simple as possible each month.

Henock K · ‎August 30, 2024

Hi jpetersonvp,

Welcome to the Community. It's important you're able to get the support you need so that you can get back doing what you love. QuickBooks Online is a great program that gives you the ability to easily track your sales and expenses. I'd be glad to help.

If you have put revenue into classes and added classes in transactions, you can use the Profit and Loss by Class Report. This report will provide you with a COGS based on classes (revenue) which you can also export to Excel. To access this report, you can click on Report on the left navigation menu > Select Profit and loss by class report > Adjust the report period if necessary and click on Run report. You can also click the export icon to export it to Excel if necessary.

I also encourage you to speak with an accounting professional for their expertise and best course of action. If you don't have an accountant, you can find one near you by clicking on My Accountant on the left navigation menu> and then Find a pro to help.

Let me know if you have questions, I'll be happy to help.

jpetersonvp · ‎September 03, 2024

Thank you for the reply. Can QBO display this report as a trailing twelve month profit and loss? Or, can it only be displayed month to month?

JamesM4 · ‎September 03, 2024

Hello jpetersonvp. Thanks for reaching out to us here. At this time, the option available is the month to month. I can see the benefit of being able to display the report as a trailing twelve month P&L and I encourage you to send feedback about this to our engineers. You can send feedback by clicking on the Gear icon and looking for Feedback. In the meantime, feel free to ask other questions. I'm here to assist.

Topics

Training

Community

Resources

Four Revenue Stream w/ COGS on One TTM report