Skip to main content
M
MALang
June 28, 2021
Question

Net Income By Class & Month

  • June 28, 2021
  • 3 replies
  • 0 views

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, 

    3 replies

    Rubielyn_J
    Rubielyn_J
    June 28, 2021

    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. 

    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.

     

    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
    BigRedConsulting
    June 29, 2021

    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:

     

     

    Your report will look something like this:

     

      C
      colsen531
      March 31, 2023

      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?

       

       

       

       

      J
      jamespaul
      March 31, 2023

      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. 

      Rubielyn_J
      Rubielyn_J
      June 30, 2021

      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!

      O
      osparkelo
      March 9, 2023

      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?

      K
      Kevin_C
      March 9, 2023

      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!

      Terms & ConditionsAccessibility statement