cancel
Showing results for 
Search instead for 
Did you mean: 
MALang
Level 1

Net Income By Class & Month

Hello Experts!

 

Thanks in Advance for your help. 

 

I'm wondering if there is an already built report that would give me Net Income by Class & Month. Please see below example, and I have attached it as well. 

I do not need to see any of the other P&L accounts and their balances - I just want the final net income number.

If there is not an already built report, can someone point me in the right direction of creating my own custom report?

 

Net Income by Class & Month
ClassJan '21Feb '21 Mar '21 Total YTD 
123      100.00      500.00      900.00   1,500.00
321      200.00      600.00   1,000.00   1,800.00
951      300.00      700.00   1,100.00   2,100.00
159      400.00      800.00   1,200.00   2,400.00
Monthly Total   1,000.00   2,600.00   4,200.00   7,800.00

 

Thanks for your help!

Kind Regards, 

11 Comments 11
Rubielyn_J
QuickBooks Team

Net Income By Class & Month

It's a pleasure to have you here, @MALang. Let me provide some ideas about generating Net Income by Class & Month report in QuickBooks Desktop.

 

We can run the Profit & Loss report to show your business' final net income number. Then we can add some filters to manifest the information you want on the data. 

 

Here's how:

 

  1. Go to the Reports menu.
  2. Select the Company and Financial tab.
  3. Choose the Profit and Loss by Class report. 

    pl3.PNG
  4. Click the Customize Report button.
  5. Select the date and under Columns, put a checkmark next to Year-To-Date
  6. Lastly, click OK.

    pl2.PNG

 

To further customize, you can export this to Excel. From there, you can add some columns and rows to add the details you want in the report. 

 

I'm also adding this article to guide you tailored the Net income report: Customize reports in QuickBooks Desktop.

 

Moreover, you may consider reading this resource to help you memorize reports in QuickBooks: Create, access, and modify memorized data. It includes steps on how to set up, edit and delete this report.

 

Keep in touch if you have other questions about creating reports in QuickBooks. I'll be happy to assist you more. Have a pleasant day.

BigRedConsulting
Community Champion

Net Income By Class & Month

Yes, you can create a custom report like your example.

 

1. Start on the Reports menu and pick Custom Reports | Summary

2. When the Modify Report window appears, select or enter the date range.

3. Then set Display Columns by to Month and Display Rows by to Class.

4. On the filters tab, verify that the Account filter is "All Income/expense accounts", which seems to be the default.

5. Optionally, on the Header/Footer tab, give the report a title that describes it.

 

The Display tab should look like this:

 

Capture.JPG

 

Your report will look something like this:

Capture2.JPG

 

Rubielyn_J
QuickBooks Team

Net Income By Class & Month

Hi, @MALang.

 

Hope you’re doing great. I wanted to see how everything is going about generating Net Income by Class & Month report concern you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

 

Looking forward to your reply. Have a pleasant day ahead!

osparkelo
Level 2

Net Income By Class & Month

Can you run a P&L by Class for YTD and have each month listed separately within each Class?  The rows would be Accounts (Chart of Accounts) and the columns would be Class, but within the class, each month listed separately.  So P&L by Class, by Month.  Is that possible?

Kevin_C
QuickBooks Team

Net Income By Class & Month

I can see how this functionality would be beneficial to your business, osparkelo.

 

If you're using the QuickBooks Desktop program, you can follow the suggested steps above to run the Profit & Loss by Class and export it to Excel to customize further.

 

On the other hand, the option to customize the Profit & Loss report by class each month isn't currently available if you're using QuickBooks Online (QBO).

 

I know how important to have a functionality that can add columns to customize the Profit and Loss by Class report to show the amounts monthly. While this is unavailable in QBO, I'd recommend sending feedback to our Product Development Team. They can review your suggestions and might make some adjustments in the next update. Let me show you how:

 

  1. Sign in to your QBO company.
  2. Go to the Gear icon.
  3. Choose Feedback.
  4. Enter your product comments in the description box.
  5. Click Next to submit.

 

In the meantime, you'll want to consider customizing the Report period by month of the Profit & Loss report by Class and exporting it to an Excel file one at a time.

 

Furthermore, here are some articles that will help you streamline the reporting process in QuickBooks Online:

 

 

Keep me posted if you still have questions or concerns about managing your reports in QBO. I'll be here to lend a helping hand. Stay safe!

colsen531
Level 1

Net Income By Class & Month

I would like to use these features, but my modify report box does not have the following options:

Display Rows by or

Display Columns For

We are using Enterprise 2021 Contractor.  Do we need a different version to see these options?

 

 

 

 

jamespaul
Moderator

Net Income By Class & Month

Hello, colsen531.

 

The Display Rows by or Display Columns For is available in QuickBooks Enterprise 2021 Contractor Edition. Either option is found by pulling up the Custom Summary Report. From the Reports menu, click on Custom Reports, then select Summary. 

 

I would like to further help you with your reports. What specific report data are you trying to build? Knowing this option would help me come up with a resolution. 

 

Looking forward to your reply. 

Proflutzy
Level 1

Net Income By Class & Month

Is this possible in QuickBooks Online? This would be soooo useful to me and save a ton of excel hi-jinks to get to the same output

RCV
QuickBooks Team
QuickBooks Team

Net Income By Class & Month

Thanks for joining the thread, Proflutzy.

 

If you are referring to running the Profit and Loss by class with monthly net income for each month, then that option is unavailable in QuickBooks Online (QBO). However, we can run the Profit and Loss by Class in QuickBooks Online (QBO) Plus and Advanced version and export them to Excel. From there, you can calculate and add each class's net income for each specific month by hand.

 

Before running the report, let's make sure we turn on the class tracking feature. Let me guide you on how: 

 

  1. Go to Reports on the left menu.
  2. Enter Profit and Loss by Class in the search field.
  3. Click the Customize button.
  4. Under Filter, choose Class.
  5. Tap the Class drop-down and choose the parent's class or classes.
  6. Press Run report
  7. At the top of the report, select the Export icon. Then select Export to Excel.
  8. Save the file somewhere you can easily find, like your Downloads folder or your desktop.

 

You can check out this article for the steps and details: Export your reports to Excel from QuickBooks Online. For more details about running reports by class, refer to this article: Run reports by class in QuickBooks Online. To learn more about utilizing classes in the program, check out these guides:

 

 

These resources will guide you through personalizing reports and saving their current customization:

 

 

If you ever come across any more concerns or ideas about managing your financial reports, you're always welcome to reach out. I'm here to help you and address any questions you may have.

cmobley62
Level 1

Net Income By Class & Month

Thanks I have been trying to get this down all day.

MorganB
Content Leader

Net Income By Class & Month

This is great to hear, cmobley62. I'm so glad you found the answers you were looking for here in the Community. You know where to come if you ever need a hand again in the future. Take care!

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

Need to get in touch?

Contact us