Good to see your post here, cassidyliz.
While there isn't a way to run a report nonsequential Profit and Loss report, you can run the report yearly then export each of them to Excel. From there you can merge the reports.
Here's how:
- Go to Reports and choose Company & Financials.
- Select Profit & Loss Standard.
- Click the Excel drop-down at the top of the report, then select Create New Worksheet or Update Existing Worksheet.
- In the Send Report to Excel window, choose what you'd like to do with the report.
- Select the Advanced button to see other available options for the exported report then select OK. To ensure the exported report will show Header information
If you are using a newer version of MS Excel and the exported report does not show header information, go to the Printing options section and make sure the On Printed report and screen option is selected.
-
Select the Export button. QuickBooks opens MS Excel. You can edit your data as needed.
More about importing and exporting files in QuickBooks Desktop can be found in this article: Import or export MS Excel files.
In case you encounter issues when exporting the report, you can visit this article for the steps on how to fix it: Fix export to Excel issues in QuickBooks Desktop.
Please leave a comment on this thread if you need anything else. We are always around to help you some more.
