Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am looking to create a report that combines business expenses with owner's draws to generate a statement of the real cash flow of the business in a given period. I am specifically looking for a breakdown by account -- essentially a P&L + Draws report -- which is why the Cash Flow statement report is not useful.
Is there a way to do this? I tried using filters but had no success.
I am using QBO Plus.
Hello there, Frustrated_owne.
We're unable to add the owner's draw on the Profit and Loss report since it's an equity account. It will only show on the Balance Sheet. I suggest exporting the Profit and Loss report, then add the owner's draw amount manually.
Here's how to export:
If you have other questions, we're just here to answer them.
start with the cash flow statement and customize from there
Kristine,
Thanks for replying. I know that the P&L report does not include equity accounts, I was just trying to describe the effect of what I was looking for.
I want a break down of all expense accounts and draws so that I can see the effective cash flow BUT with individual accounts. The cash flow statement is closest to what I want but all it shows is "net income", not individual accounts contributing to net income.
I thought Quickbooks reporting was supposed to be fully customizable. If you can help, please let me know how to get what I am looking for.
Thanks for replying Rustler.
I may be doing it wrong, but I can't seem to customize the Cash Flow Statement to show individual accounts contributing to the net income line. It shows the Owner's draw accounts fine, but doesn't give me a way to show the details going into net income.
Any ideas sir?
Hello, frustrated_owne.
Customizing the cash Flow statement to show each income account contributing to the net income is unavailable. Cash flow only measures your cash on hand. This is the reason why it only shows the net income (income after all expenses). Unlike Profit, it refers to the difference between revenue and cost over a period of time that’s why individual accounts are showing in the Profit and loss report.
As a workaround, you can export Cash Flow to Excel together with the Profit and Loss so you can add individual accounts (Please refer to the steps provided by my colleague above).
Drop by again if you have other questions about QuickBooks.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here