cancel
Showing results for 
Search instead for 
Did you mean: 

Reply to message

View discussion in a popup

Replying to:
Senior Explorer **

Re: How to create a Profit and Loss report that shows YTD, budget and previous year comparison?

I don't think there is a way to automatically get that in the format you are looking for.  You can create the Profit & Loss Budget vs. Actual for a two year period, which puts all the data in one spreadsheet and would line up the rows.  But the columns would be in date order, (not current year/month next to prior year month).  You would still need to reorder the columns by cutting and pasting them, and then add a difference formula for the year over year data, but the formatting would already be there, simplifying the task. 

 

That's a difficult answer, but if you open the report and enter dates 05/01/2018 to 04/30/2019, you will see what I mean.  

 

If anyone else has the answer, I'm interested!