Let’s say you want to create a Profit and Loss report in QuickBooks to report multiple years, with each year in its own column, and the total in the last column. You can easily customize a P&L in QuickBooks to give you this report.

Start with a default P&L report by clicking Reports / Company & Financial / Profit & Loss Standard. It will display the report.

Now change the date ranges to encompass the years you want.

In this example, we are selecting three years to report

Now click the control to the right of “Show Columns”. The default will be “Total Only”. Change it to “Year”.

Click the Refresh button in the upper right of the screen, and you’ll have your multi-year, multi-column P&L.

Where else in QuickBooks would it be helpful to you to show multi-column, multi-period reporting?

Please follow and like us: