How do I create a DETAILED Profit and Loss statement? The detail s I need are the individual transactions within a category. I can only seem to run a P&L showing totals.

Hi there, @John.

Creating a detailed Profit and Loss report in QuickBooks Online is easy. And I'll be happy to guide you. 

Here's how:

1. On the left of your QuickBooks Online (QBO), click Reports.
2. Select the Profit and Loss Detail report under the Business overview section.
3. Modify the reporting period to a specific month.
4. Click Run report.

To learn a bunch of ways to run and customize your reports, refer to these articles:

• Customize reports in QuickBooks Online
• Memorize reports in QuickBooks Online
• Run reports in QuickBooks Online

If you want to export your report to Microsoft Excel in the future, here's a detailed guide you can check: Export your reports to Excel from QuickBooks Online.

Please let me know if you need further assistance with running your reports in the way your business needs. I'm always here to assist. Have a wonderful day.

Thank you!  However, under "Business Overview" I do not have an option for "Profit and Loss Detail".  Please see attached.

I'd like to know the QuickBooks Online (QBO) version you're using, @johnzaffarano.

Some reports are not available in other QBO version. Profit and Loss Detail report is available in QBO Essentials, Plus, and Advanced. The Simple Start plan doesn't have the Profit and Loss Detail report.

Here is an article about the reports available for each QBO version: Reports included in your QuickBooks Online subscription.

If you want to upgrade your subscription to have this report, check this article as your reference for the detailed process: Upgrade or downgrade your QuickBooks Online subscription.

After upgrading, you can then run the Profit and Loss Detail report. To customize your report, check this article: Customize reports in QuickBooks Online.

Let me know if you have additional question about running reports. I'm always here to help. Have a great day.

It's version 5.1.0. Please see attached.

When I click on "check for updates", I receive the message I am up to date and there are no other updates at this time.

Not all reports show in some QuickBooks Plan, @johnzaffarano.

I apologize for the confusion. When I said version, what I mean QuickBooks plan. I recommend checking your subscription as Profit and Loss Detail report is not available in Simple Start.

Here's how:

1. Go to the Gear icon at the top.
2. Choose Account and Settings.
3. Select Billing & Subscription.

Also, I'd like to know if you are using QuickBooks Online Desktop app, as shown in your screenshot. If so, that can be the reason why some of the reports are not showing even if you are not using the Simple Start plan.

Since the QuickBooks Online Desktop app is discontinued, I suggest logging in to your QuickBooks Online account using supported browser. You can then run the report.

Let me know if you have questions about running the report. I'm always here to help. Have a great day.

I am having the same problem. I am using Quickbooks Online Plus. How do I check to see if I have desktop edition? I've tried everything else.

I took over the use from someone else at our non profit and they are unavailable to show me anything they did in the past. Any help would be greatly appreciated.

Thanks

I'd be happy to welcome you here at the forum, @AFSLB. Thank you for joining our growing community. Allow me to impart some thoughts to help clear some confusion.

While QuickBooks Desktop is an accounting program that is installed locally and has a yearly subscription price structure, QuickBooks Online is an accounting application that is hosted online under the software as a service" concept.

Naturally, when you take over from someone else at a non-profit and they are unavailable to show you anything they did in the past. Both are separate platforms.

You may utilize this article to learn some of the differences between the two versions: QuickBooks Online vs. Desktop.

You can visit this article to know how to get the most out of your financial reports: Customize reports in QuickBooks Online.

Feel free to reply to this post if you need further assistance. Have a great day ahead!

It is extremely obnoxious that QBO does not allow all QBO plans access to the Profit & Loss Detail report. That is one of the most basic and essential reports that a business needs. QBO is just trying to milk more money out of us. It is obnoxious. 

This is a discusting practice. This is a basic report that should be available on all versions. Quickbooks is going down hill. 

But I have QBO Advanced, which means I should have this option and I do not. Please advise. I've been trying to find this for months.

Thank you for joining the conversation, Operrra.

You're right that the Profit and Loss Detail report should be available in QuickBooks Online Advanced, as it is the premium product in all online versions.

I can see that my colleague, Mirriam, has already provided the correct steps to run the said report and added a few related references as well. At this point, we'd better have your QBO company checked by our QBO Advanced Support. This way, we will know why Profit and Loss Detail is not available to you.

1. Go to Help and choose the Search tab.
2. Click Contact Us at the bottom.
3. Enter something like Profit and Loss detail is not available in my list of reports and click Continue.
4. Choose Callback, Appointment, or Chat.

You can also check about creating custom reports in QuickBooks Online Advanced for your additional reference.

I'm only a comment away if you need more assistance with reports. Take care and have a good one.

I found out how to do this by accident in the basic plan. I ran a regular p&l for the year, then went to the total at the bottom under net income and clicked on it, and it took me straight to a p&l detail report. I agree it's annoying it's not easily available for users but I hope this helps you!

I found out how to do this by accident in the basic plan. I ran a regular p&l for the year, then went to the total at the bottom under net income and clicked on it, and it took me straight to a p&l detail report. I agree it's annoying it's not easily available for users but I hope this helps you!

Thank you!  I ended up upgrading to the next level of QB and was able to detail but good to know your tip. Much appreciated!

• go under REPORTS 
• generate "Profit and loss" report 
• go all the way down - and click on the last number on the P&L report - net profit number 
• system will generate detail P&L 

Hi Miriam,

I need to run the same report - DETAILED P&L - but it is no longer showing under Business Overview. Please let me know how I can generate this report. Thank you, Neil

Welcome to the Community, @neilcwm

I understand that generating the Profit and Loss report is crucial for understanding our revenue and expenses. Allow me to assist you in locating the Detailed Profit and Loss report in your Business Overview. 

You can generate the report by subscribing to QuickBooks Essentials, Plus, or Advanced. If you've subscribed to Simple Start, you will need to upgrade to the higher version of QBO to view the said report.

If you already use the supported subscription and the report is not visible, we can help you troubleshoot this problem. We can use these keyboard shortcuts to access the incognito and private modes easily: 

• Google Chrome: Ctrl + Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Microsoft Edge: Ctrl + Shift + P
• Safari: Command + Shift + N

Alternatively, you can use the search bar on your Reports page to search for the Profit and Loss Details.

In addition, you can check this article for more information about reports available in each plan in QBO: Reports included in your QuickBooks Online subscription.

In case you want to personalize your reports in QBO, you can refer to this article for guidance: Customize reports in QuickBooks Online.

Feel free to comment below if you have further questions regarding the profit and loss report. The Community space is always here to help you.

Thanks for the tip on how to find the detail.   I tried it and it worked and then I saved the customized report.

I suppose since Intuit knows about this now they will cripple it.   Detail P&L is absolutely essential for tax preparation and defense of income and deductions.   Crippling QB is greedy and exploitive.

I am looking at WAVE as an alternative.   Ive use QB since the mid nineties but I hate it now.

it looks like they closed that loophole.

Ok. After making 3 QBO support calls (they can't figure it out), and 2 hours of my time.  I found a work around.  Not perfect but beats manually modifying 10,000 Excel rows. 

Good for identifying any mis-categorized transaction from the Profit and Loss Report.

NOTE: only works if you click on the "Total Expenses" line. 

Steps:

1) Run the normal Profit and Loss Report

2) Click on the amounts on the "Total Expenses" line item.

3) Click Group By at the top and click "Clear all"

4) Click Save As so it'll be a customized report.

5) Optional.  Click "Columns" if you want to hide,show, reorder columns.