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:

3 thoughts on “How to Create a Multi-Year P&L in QuickBooks

  1. When I attempt this QB for the period between 7/1/18 and 2/27/20, QB (Desktop) creates one column that’s an entire FY (7/1/18-6/30/19) and another column that is between 7/1/19-2/27/20).

    What I’m looking to do is create a report that provides a YTD comparison between current and previous fiscal years (7/1/18-2/27/19 and 7/1/19-2/27/20 as an example). This doesn’t seem to accomplish this for me. Any guidance would be appreciated.

    • Hi Andrew,

      Yes, since you have gaps between the reporting periods (2/28/19 through 6/30/19 not included anywhere), I don’t think QB will know how to do that. You could, however, run two separate reports for those two reporting periods, export them to Excel, and merge them into one spreadsheet. Thanks for your question.


Leave a reply

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> 


This site uses Akismet to reduce spam. Learn how your comment data is processed.