In QBO Is there a way to get a Detailed P&L report by month? I can do one or the other, but when I try to customize the reports to do both in one report, I do not see an option in either report to have the detailed P&L listed down the page with the Months across the top. Thanks
I'm here to share some information about running a Profit and Loss report.
When you pull up the said report, it will break down the transactions by account. Customizing it to show by month is unavailable.
However, I have a workaround that you may want to consider. You can run the Profit and loss report by month and export it to an Excel file. This way, you can have the data broken down per month.
You can transport it by clicking the Export icon.
I've also added this reference for more information about customizing reports: Modify reports in QuickBooks Online.
That should do it, ecocpa. Let me know if you need help in modifying the report or if you have other QuickBooks concerns. I've got your back!
Hi there, @ecocpa. Allow me to chime in and help you get the report you need.
The Profit and Loss Detail report in QuickBooks Online only displays a detailed insight of all your income and expense transactions for a certain period. I'd suggest exporting a monthly report and combining them in spreadsheets.
Once done, combine them in one spreadsheet. To learn a bunch of ways to customize your reports in QuickBooks Online, refer to these articles:
Please let me know should you need further assistance with customizing your reports in the way your business needs. I'm always here to assist. Have a wonderful day.
Why is it that quickbooks hasn't developed the option to show the report by month? The workaround does work but seems unnecessary unless Quickbooks is actually unable to make simple improvements in reporting...
I'm consistently surprised by the lack of what seems to be basic functionality... And then even more surprised that it's still relatively one of the better ones in class...
Welcome to the Community! I appreciate you joining in on this thread about a detailed Profit and Loss by month.
This isn't the impression we want to leave you with. We can see how beneficial this could be for you and your business.
I recommend submitting feedback so our Product Developers can consider adding this as an option in the near future. They take the time to review every request and try to add them in the next available update if possible.
If you have any other concerns about reporting, don't hesitate to come back. We're always here to have your back. Happy Wednesday!
Hi there, @shellianne.
Let me share insights about running reports in QuickBooks Online (QBO).
The Profit & Loss by Detail report is available for QBO Essentials, Plus, and Advanced. If you’re using a Simple Start version, then, the report isn’t accessible. This is due to certain reports that are only available for a particular version of the product.
Nonetheless, you’ll want to consider upgrading your subscription to obtain your data in one report. On the other hand, we can customize the other type of P&L or other financial reports available in your subscription to extract details and export this into an Excel file. After that, you can collate this into one.
Here’s how you can customize your report:
You can repeat the same steps to the other reports you want to get some data from. Once you have these reports in front, you can click the Export icon on the report page to transport this into your spreadsheet. From there, you can start collating the data you have collected.
Moreover, you can utilize the memorize report feature in QBO to save your previous customization.
Let me know if you have more concerns about running reports. The Community always has your back. Have a good one!
This is because QuickBooks is basically a monopoly. They don't have any incentive to invest in creating features that users really need. As you use QuickBooks, you'll notice more and more basic functionality that is just completely missing. They just keep raising the prices, and forcing everyone onto a subscription model. Their standard response is to ask you to "suggest it to the developers". How many of those "suggested" features are actually developed? How long does it take them? Or is it just a waste of your time?
Given they are the supposed "market leader", I am continually appalled by the lack of basic functionality, especially considering how expensive it is. I spend over $2K a year on QuickBooks and it's just so limited, but there are few other choices out there.
Our team was forced to migrate to QBO from Desktop 2020 as they discontinued support for the 2020 product.
QBO is a terrible piece of SaaS software. It is so limited compared to Desktop (which was pretty poor to start with). Aligned to several other of the user comments, it is appalling how the Intuit programmers have a complete disregard for maintaining the features that customers need. What a scam!