cancel
Showing results for 
Search instead for 
Did you mean: 
KM402
Level 3

MTD Comparison

Is there a report to see a P&L Month-to-Date Comparison? I want to compare my expenses my month

Solved
Best answer September 23, 2022

Best Answers
Giovann_G
Moderator

MTD Comparison

Hello, KM402.

 

The Profit and Loss report can be customized to display columns by month and include a percentage column for expense or income. I'll show you how.

 

  1. Go to the Reports menu, then Company & Financial.
  2. Select Profit & Loss Standard.
  3. Enter the correct report period.
  4. Click Customize Report button.
  5. Choose Month under the Display columns by dropdown.
  6. Checkmark the box for % of Income or % of Expense in the Add subcolumns for field to add percentage column.
  7. Once done, hit OK

 

Refer to this article for more details on customizing reports: Customize reports in QuickBooks Desktop.

 

Do you plan to make use of your report outside of QuickBooks? If this is the case, you can export your report to Excel. For a comprehensive guide, see this link: Export reports as Excel workbooks in QuickBooks Desktop.

 

If you have further questions, let us know. We're always here to help you.

View solution in original post

4 Comments 4
BigRedConsulting
Community Champion

MTD Comparison

What do you want to compare your MTD expenses to?

KM402
Level 3

MTD Comparison

I want to compare a few months, to see when and where the expenses were more, and what percent more.

Giovann_G
Moderator

MTD Comparison

Hello, KM402.

 

The Profit and Loss report can be customized to display columns by month and include a percentage column for expense or income. I'll show you how.

 

  1. Go to the Reports menu, then Company & Financial.
  2. Select Profit & Loss Standard.
  3. Enter the correct report period.
  4. Click Customize Report button.
  5. Choose Month under the Display columns by dropdown.
  6. Checkmark the box for % of Income or % of Expense in the Add subcolumns for field to add percentage column.
  7. Once done, hit OK

 

Refer to this article for more details on customizing reports: Customize reports in QuickBooks Desktop.

 

Do you plan to make use of your report outside of QuickBooks? If this is the case, you can export your report to Excel. For a comprehensive guide, see this link: Export reports as Excel workbooks in QuickBooks Desktop.

 

If you have further questions, let us know. We're always here to help you.

BigRedConsulting
Community Champion

MTD Comparison

Well, you can compare two MTD months at a time, but not three.

 

To do this,

- Run a standard Profit & Loss report and select This Month To Date as the date range (if it's not the default).

- Then click Customize Report and select Previous Period on the Display tab as well as the $ Change and % Change options.

 

 

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

Need to get in touch?

Contact us