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

Profit and Loss show the Percentage of Income and expenses YTD instead of the percentage based on the month

In 2018 QB Pro desktop: Can you show the Percentage of Income and expenses YTD instead of the percentage based on the month

8 Comments 8
Anonymous
Not applicable

Profit and Loss show the Percentage of Income and expenses YTD instead of the percentage based on the month

Yes, but only by creating a report where the date range is YTD.

CS
Level 2

Profit and Loss show the Percentage of Income and expenses YTD instead of the percentage based on the month

If you have a current month column  and a current year column;

it shows the percentage of the current month.

I would like it to show the current year and/or both.

 

The report has:  current month     YTD     Percentage of income (for current month)

 

Would like:   current month     YTD    Percentage of income (for YTD)

 

CS
Level 2

Profit and Loss show the Percentage of Income and expenses YTD instead of the percentage based on the month

The report format for the profit and loss is:

current month     YTD        % (it shows % of current month)

 

Would like it to show % of YTD (or both).

Do you know if that is possible?

 

 

 

IamjuViel
QuickBooks Team

Profit and Loss show the Percentage of Income and expenses YTD instead of the percentage based on the month

It's great to have you here again, @cs.

 

I'd be delighted to help walk you through in customizing your Profit and Loss report to display the data that will suit your business needs.

 

With QuickBooks Desktop, you can create an array of Profit and Loss reports that you can access and filter to show only the information you want. Yes, it'ss possible to generate a Profit and Loss YTD Comparison report to show the % of income and expenses.

 

Here's how:

  1. Go to Reports.
  2. Choose Reports Center.
  3. Under Company and Financial tab, choose Profit and Loss YTD Comparison.
  4. Click the Customize Report.
    1. Under Date, choose This Fiscal Year or Custom (Jan. 1, 2019 - December 31, 2019).
    2. Choose either Accrual or Cash on the reporting method.
    3. In the Display columns by section, choose Total Only.
    4. Put a check mark on the following in the Add subcolumns for.
      • Year-To-Date
        • % of YTD
      • % of Row
        • % of Income
      • % of Column
        • % of Expense 
    5. Click OkSlide1.JPG
  5. Hit Refresh.

Slide2.JPG

That should do it! This should get you going in generating a Profit and Loss YTD Comparison by %.

 

Keep me posted on how things work on your end. I’m always here to help you in preparing your income and expense reports. Have a great ahead!

DanaLynnEA
Level 2

Profit and Loss show the Percentage of Income and expenses YTD instead of the percentage based on the month

Can you reorder the columns?

 

I would like to show:

 

Current Month       % of Income         YTD Amount             YTD % of income.

 

 

Also, can you explain what % of column and % of row mean?

JasroV
QuickBooks Team

Profit and Loss show the Percentage of Income and expenses YTD instead of the percentage based on the month

Hi there, @DanaLynnEA.

 

The option to re-order the columns in the Profit & Loss YTD Comparison report in your QuickBooks Desktop is currently not possible. However, you can export the report to MS Excel file. From there, you can re-order the columns of the report. Let me guide you how:

 

  1. Open your Profit & Loss YTD report.
  2. Select Create New Worksheet form the Excel drop-down arrow. 1.png

Here's an article for more detailed steps: Export Report from QuickBooks Desktop to Microsoft Excel.

 

Also, the % column and % row shows you the percent your gain or loss. As this report summarizes your income and expenses.

 

I've also added this article for reference in case you want to learn how to customize reports in QuickBooks Desktop: Customize Reports in QuickBooks Desktop.

 

If you have other concerns or questions, feel free to leave a comment below. I'm always here to help.

DanaLynnEA
Level 2

Profit and Loss show the Percentage of Income and expenses YTD instead of the percentage based on the month

Thanks JasroV for your quick response.  Too bad we can not reorder the columns in QBDT since my client is not very savvy in Excel.  But I can guide her on that. 

 

For the YTD Column, can this be represented as a % of the YTD Income?  Clicking on the % of Income give the percentages for the current month in relation to the % of Income.  We also want to know the YTD amount as a % of the YTD Income.

 

 

JaneD
Moderator

Profit and Loss show the Percentage of Income and expenses YTD instead of the percentage based on the month

Good day, DanaLynnEA.

 

The option to show the YTD amount as a % of the YTD Income of the report hasn't been made available in QuickBooks Desktop.

 

This report summarizes your income and expenses for this month and compares them to the current fiscal year. This will also tell whether you're operating at a profit or loss.

 

The intermediate lines in the report also show subtotals for each income or expense account in your Chart of Accounts. The last line shows your net income (or loss) for the month and the fiscal year to date.

 

Here's an article for future reference: Understand reports.

 

We're always looking for ways we can make the software better for all users. By sharing your idea here in the Community, our app developers are pushing the envelope to improve the product's features to meet your needs.

 

In this case, let me share this directly to our engineers for review. From there, they may be able to include this in the future updates.

 

For now, I suggest checking out regularly for any updates and enhancements through this link: The QuickBooks Blog.

 

I'll also update you here once this feature becomes available in QuickBooks Desktop.

 

Please let me know if you have any follow-ups or other questions. I'm always here to help. Wishing you the best.

Need to get in touch?

Contact us