How do you get a report that shows total money in, and total money out each month, including financing activity?

Let me make it up to you by sharing a workaround on how you can get the data needed on a report, user04773.

Liabilities don't show on the P&L report. You may consider exporting the report. Re-open and double-click the Interest Expense of your P&L to narrow the details to that on that account. Then export it.

I encourage memorizing this report to save its customization settings.

Also, you can personalize and add the info that matters the most to your business using the Customize feature.

I'll be here to continue helping if you have any other questions or concerns about reports.

That does not show transfers, so you still are NOT getting a picture of total money out.  How on earth is this so hard to do?  How is anyone else using quickbooks as an accounting tool if you can't simply know how much money is coming in and going out each month?  I cannot be the only person in the world who wants to know total in and total out. 

I appreciate you getting back to us, user04773.

You might want to run and customize the Transaction List by Date report. This report will show all your money in and out transactions for each month.

Here's how to generate the report:

1. Click Reports in the left panel.
2. Search for Transaction List by Date.
   
3. We can see the Transfer, Expense, Check, and other money in and out transactions in the report.
   

I recommend customizing the report to get the specific details you need. We can also memorize it to save its current customization settings. It serves as our record and helps us quickly access it for future use. 

Let me know how it goes by leaving a reply below, user04773. I want to ensure you're able get the report you need. Have a good one.

@user04773 

Under Reports, run a cash flow statement, click 'Customize', select your date range (report period), select 'Months' under the columns pull-down menu, click 'Run report'.  That will give you cash flow by month and account as well as split it between operating, investing, and financing activities.

I suppose this gives you total money in and total money out, but I wouldn't know because it doesn't even give a total money in or total money total.  It's just a list of transactions.   Much less a list of totals by category per month.  So it doesn't show me the fundamental question which every single business in the world has.   How much did I make/spend on x last month, or the month before and so on?   x = any category.   x = any debt payment, x =-any income. 

This is already addressed in the original question and does not give you spending by month, nor by category.  It only gives you balance changes.  So any accounts that aren't balance carrying accounts (like "contract labor" are not included)

from original post...

If you run a cash flow statement it only shows account balance changes for the given time period and can't be shown as monthly totals. So you can't compare cash flow of september to cash flow for october NOR can you see what you spent on any category.

I hit reply and left a response, but it didn't seem to match my reply to your comment, and my reply is down below.   Quickbooks seems to have a hard time getting anything to actually work. 

@user04773 

What are you wanting to know - how much the business made or the change in your cash flow?  These are different financial statements and are two distinctly different metrics.  There is a difference between what the business makes (that's a P&L) and your cash flow (Statement of Cash Flows) for any given period.  Your screenshot is a profit & loss statement.  That shows the net income of the business (what it made).  That can be vastly different from cash flow.  If you want to see your change in cash for a period, run a Statement of Cash Flows.  It will show you the change in cash for the period (in vs. out) and it provides a net total.

I want to know total money in and total money out by category, by month, and include financing activity.  If you go to a bank they want to know what you're spending every month AND that INCLUDES how much you are spending (ie. transferring) to debt service (liabilities).  They want know principle AND interest payments, and everything else you're spending money on, and how much income is coming in.   I also want to know this because that is the only way to get a proper budget of monthly income and expenses.  

I don't know how much more clear I can get?  I want profit and loss with debt service included.  Just like the screen shot shows. 

Did you ever get an answer to your question?! I can't seem to figure this out and need the same information.

I appreciate you joining the thread, @housealconstruction. I am glad to welcome you here in the Community forum.

I'd want to help you, but I need more information to properly comprehend your concern and offer the best solution. Could you please tell me what kind of report you're searching for? You may also send us screenshots or other types of information. We will be truly thankful.

Always remember that we're open 24/7. That said, you can post any QuickBooks concern here in the Community. We're happy to help at any time. Take care always.

No, there is no report that does what I want.  However you can come close, with a "cash flow" report, once you realize that the top line of the cash flow report is the total from the P&L report.  So there is no way to see them all together at once, but you can click the total on the "Net Income" line at the top to see what is included in that number. 

@user04773 

Between an income statement (P&L), balance sheet, and cash flow statement, that gives your bank everything they need.  If they can't figure it out from those three statements, the issue is with the bank, not QB. 

The bank was an example of who would need the information.  Just because I can print 3 reports to get to it, doesn't mean it's easy and readily available.  I don't know if you're a shill for QBO or something, but not sure why you feel the need to attack me because I want to easily see information in a format that I like to see it in. 

usero4773 - I need the same report and its is infuriating that I can't easily run a report that shows what is coming in and going out each month. I see that on a P&L my quarterly tax payments don't show up, owner draw doesn't show up... how hard can it be for QB to create something so simple and needed? I just need to know what's coming in and going out each month without showing to download and combine 3 reports...!!!!!

Hello there, SouthernMade. 

I understand the efficiency of having three reports in one transcript. However, please know that you'll need to pull up other reports for you to see other information as well since there is certain info that only a specific statement can show.

Since the tax payments are currently unavailable in the P&L report, you can run a report named Transactions List by Date and adjust it according to your preference. 

Here's how: 

1. Go to the Report menu located at the left navigation panel.
2. Type Transaction List in the search bar and choose Transaction List by Date. 
3. To customize, press the Columns menu. 
4. Tick the columns that you'd want to show up in your report. 
5. Press Filter and choose in the Filter dropdown what transaction you see.
6. Once done, press close it. 

You can view this material to learn more about reports and how to customize them according to your needs: Customize reports in QuickBooks Online using a modern view.

Furthermore, you can export and print your report by accessing this website: Export reports, lists, and other data from QuickBooks Online. 

If you have more questions about QBO, you can enter them in the comment section and we'll ensure to help you in any way we can. 

Why is this so hard for everyone to understand this simple request. Why can't there be one report that shows all cash out and cash in for a period??? Client's want to know this! Why should we mess around trying to put 3 reports together when you have developers working on stuff everyday! There are so many old issues which never get worked on, but they continue to change things that are not broken. Please don't respond with "Give Feedback" - I already do and nothing changes. 

@Alicia

"Why can't there be one report that shows all cash out and cash in for a period??? Client's want to know this! Why should we mess around trying to put 3 reports together when you have developers working on stuff everyday!"

@SouthernMade 

"I see that on a P&L my quarterly tax payments don't show up, owner draw doesn't show up... how hard can it be for QB to create something so simple and needed? I just need to know what's coming in and going out each month without showing to download and combine 3 reports...!!!!!"

With all due respect, and I don't mean to offend, you need to understand the Statement of Cash Flows.  That is THE report that shows you/your clients their change in cash for a period.  Most importantly, it reconciles the income/loss from the business to the change in cash for the period.  That is what you/your clients need to understand.  If you want to see cash in/cash out, run a Journal report (Reports > Journal) and filter by the bank/cash accounts you want included.  Debits = cash in, credits = cash out.  It's not necessary to run 3 reports and compile anything.