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. 

I also agree. I think it's ridiculous there's not even a way to customize a report to show this. I understand the moderator  stating there are 3 reports - P&L, Cash flow, and Balance sheet that all show different aspects of the business, I GET THAT. But why isn't there an option to modify a report to show TOTAL MONEY IN AND TOTAL MONEY OUT. It is simple accounting and simple math that shows where your total money went in a given period. It is utterly frustrating this isn't an option. 

@bop88 

"But why isn't there an option to modify a report to show TOTAL MONEY IN AND TOTAL MONEY OUT. It is simple accounting and simple math that shows where your total money went in a given period. It is utterly frustrating this isn't an option."

Reports > Transaction Detail by Account.  Add a filter(s) to see only the transactions posted to your bank account(s).  Positive amounts are cash in, negative amounts are cash out. 

Unfortunately, this report doesn't give you the option to categorize all of the income and expenses into categories.

This is basically just one big receipt. I'm looking for a P&L like report that includes ALL transactions. 

We are here to help you run the report you need in QuickBooks Online (QBO), Bop88. 

We can pull up and run the Profit and Loss Detail report to show all the categories you need. Here's how:

1. Click Report in the left panel.
2. On the search box, look for the Profit and Loss Detail and click to open the report.
3. You'll see all the details you need in the report.

Then, customize the report to get the specific categories you need. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use.

We can also run a Transaction List by Date report to show all your money-in and money-out transactions for each month. Let me guide you on how:

1. Go to Reports from the left menu panel.
2. Enter the Transaction List by Date report under the search section.
3. Modify the Report period and other Columns, Filter, Group by, and General options to specify transactions in the report.

In addition, you may run a Statement of Cash Flows report that shows all operating and financing activities made from your account. For more detailed data, you can filter the Display columns by dropdown to Months.

If you need to combine the two reports into one, we can export them to Excel. This helps you modify the report and show all the report data you need. You can follow the steps and details in this article: Export your reports to Excel from QuickBooks Online.

Moreover, you can refer to this article that will guide you through the process of downloading and exporting your data efficiently: Export reports, lists, and other data from QuickBooks Online.

You can always get back in the Community space if you have further questions related to QuickBooks like running reports and handling transactions. We'll be more than willing to help, Bop88.

@bop88 

"Unfortunately, this report doesn't give you the option to categorize all of the income and expenses into categories."

Have you tried running a report just on your bank account(s)?  Go to your Chart of Accounts and click the down arrow to the right of 'View register'.  Click on 'Run report'.  From there you can filter any way you want.  You can include any bank account(s) and just income and expense categories and over any period you want.  It will show you the beginning balance, net change in the account, and ending balance.  

It's a bit confusing because your original question was how to get a report that shows total cash in and total cash out and now you're asking to organize that report by income and expense accounts.  I'm not trying to be difficult but the problem with that is that many transactions affect cash in/cash out and are not items of income or expense.  For example, credit card payments and the principal portion of loan payments are common transactions that reduce your cash but are not expenses.  

I am the original poster under a new username.  For anyone still looking to get this information the image attached is the easiest way I've found to do it.  Basically go to a Cashflow Report and then click the top line number.  This top line number takes you to the P&L Report that is included in (BUT NOT VISIBLE FULLY) within the cash flow report.  

For QuickBooks employees, what we're all looking for here is a single report that shows all the lines from both the P&L Report and all the lines from the Cash Flow Report in a single Report.