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

Creating single report for expenses + draws

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.

5 Comments 5
Kristine Mae
Moderator

Creating single report for expenses + draws

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:

  1. Open the Profit and Loss report.
  2. Click the Export icon.
  3. Choose Export to Excel

If you have other questions, we're just here to answer them. 

Rustler
Level 15

Creating single report for expenses + draws

start with the cash flow statement and customize from there

frustrated_owne
Level 1

Creating single report for expenses + draws

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.

 

frustrated_owne
Level 1

Creating single report for expenses + draws

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?

Anonymous
Not applicable

Creating single report for expenses + draws

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.

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

Need to get in touch?

Contact us