Thank you for the additional information, @Mollymoo1.
At this time, consolidating data into one report, such as in your scenario, isn't available. As a workaround, you can consider exporting each report with all the data you need to an Excel file. Then, manually consolidate them from there. Here's how:
- Click the Reports from the left menu.
- Open each report you want to consolidate.
- In the report, click the Export icon and select Export to Excel.
- Then, manually consolidate your data from the Excel file.
I'm adding this article for more guidance: Export reports, lists, and other data from QuickBooks Online.
As always, you can visit our QuickBooks Community help website for tips and related articles for your future references.
Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day!
