Thanks for posting in the Community, Dawn.
I recommend running the Project Profitability Summary report and customizing it to exclude those closed projects.
Here's how:
- In the left menu panel, go to Reports.
- Type Project Profitability Summary under the Find Report field.
- Hit Customize, then click Filter dropdown.
- In the Project Status portion, select In progress.
- Click Run report.
For more details about personalizing reports, feel free to check this resource: Customize reports in QuickBooks Online.
Also, you can refer to this article if you want to generate your report: Export your reports to Excel from QuickBooks Online.
Visit us again if you have any other questions or concerns about generating reports. I'm always here to help you achieve your goals.