cancel
Showing results for 
Search instead for 
Did you mean: 
Paul C1
Level 2

Can I create a P&L report that compares 2019 spending by category with 2020 YTD, and that calculates 2020 YTD as a percentage of 2019 spending?

I'm trying to use a custom P&L report to show 2020 YTD expenses compared to 2019 expenses, as a percentage of 2019.  Any way to do this in customized reports?  thanks....Paul

Solved
Best answer March 17, 2020

Best Answers
vpcontroller
Level 11

Can I create a P&L report that compares 2019 spending by category with 2020 YTD, and that calculates 2020 YTD as a percentage of 2019 spending?

@Paul C1  

@Michael K 

 

You can click the "Compare another period" report header and select % change or $ change or more you want. See the attached screenshot below for reference.

Hope this helps!

 

Profit and Loss comparison with percentage and dollar change.png

 

 

View solution in original post

4 Comments 4
Michael K
Moderator

Can I create a P&L report that compares 2019 spending by category with 2020 YTD, and that calculates 2020 YTD as a percentage of 2019 spending?

You're in the right place, @Paul C1.

 

You can run a Profit and Loss Comparison report to compare 2019 and 2020, however showing them as a percentage isn't supported at this time. To run the comparison report, follow these quick steps.

 

  1. Go to Reports on the left menu.
  2. Using the search box towards the top right of the reports screen, search for Profit and Loss Comparison.
  3. Change the date range you'd like to compare to the previous year and hit the Run Report button.

 

That's it! For more information on customizing your reports further, you can check out: Customize reports in QuickBooks Online

 

Shoot me a reply if you have any other questions. I'm determined to be your number one resource for QuickBooks Online. Have a wonderful day!

Paul C1
Level 2

Can I create a P&L report that compares 2019 spending by category with 2020 YTD, and that calculates 2020 YTD as a percentage of 2019 spending?

Thank you Michael.  I already have a custom report that shows 2019 next to 2020 YTD.  Are you saying that I cannot add a column that calculates the percentage?

vpcontroller
Level 11

Can I create a P&L report that compares 2019 spending by category with 2020 YTD, and that calculates 2020 YTD as a percentage of 2019 spending?

@Paul C1  

@Michael K 

 

You can click the "Compare another period" report header and select % change or $ change or more you want. See the attached screenshot below for reference.

Hope this helps!

 

Profit and Loss comparison with percentage and dollar change.png

 

 

Paul C1
Level 2

Can I create a P&L report that compares 2019 spending by category with 2020 YTD, and that calculates 2020 YTD as a percentage of 2019 spending?

Thank you!!!!  

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us