Skip to main content
September 23, 2022
Solved

MTD Comparison

  • September 23, 2022
  • 1 reply
  • 0 views

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

Best answer by Giovann_G

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.

1 reply

BigRedConsulting
September 23, 2022

What do you want to compare your MTD expenses to?

KM402Author
September 23, 2022

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

Giovann_GAnswer
September 23, 2022

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.