Question

Creating single report for expenses + draws

Forum|Forum|7 years ago
April 20, 2019
2 replies
21 views

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.

QuickBooks Online

Kristine Mae

Moderator

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:

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

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

F

frustrated_owneAuthor

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.

Rustler

Level 15

start with the cash flow statement and customize from there

F

frustrated_owneAuthor

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?

A

Anonymous

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 up

Login with SSO

Let's get you signed in

Login with SSO