Skip to main content
U
user04773
October 9, 2022
Question

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

  • October 9, 2022
  • 6 replies
  • 0 views

If you run profit and loss report it doesn't show financing activity (ie. transfers). So you don't get a picture of profit after debt service (ie. TOTAL MONEY OUT)

 

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.

 

It's infuriating that such a simple and what would seemingly be a pretty common need to know, is so ridiculously hard to figure out.   I mean any loan you apply for needs to know total money in and total money out INCLUDING debt service (not just "Interest Expense").   Ideally it would be the Profit and Loss report with Transfers to liability accounts in it's own section or in the expense section.

    6 replies

    G
    GlinetteC
    October 9, 2022

    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.

      U
      user04773Author
      October 9, 2022

      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. 

        Rose-A
        Rose-A
        October 9, 2022

        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.

        Rainflurry
        Rainflurry
        October 10, 2022

        @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.

          U
          user04773Author
          October 10, 2022

          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.

            H
            housealconstruction
            February 6, 2023

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

              S
              SirielJeaB
              February 6, 2023

              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.

              B
              bop88
              December 18, 2024

              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. 

                Rainflurry
                Rainflurry
                December 18, 2024

                @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. 

                B
                bop88
                December 18, 2024

                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. 

                U
                userDoozer
                December 18, 2024

                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.  

                 

                 

                Rainflurry
                Rainflurry
                December 18, 2024

                @userDoozer 

                 

                "...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."

                 

                There is no such report nor does there need to be.  The top line of the Statement of Cash Flows is the net income from your accrual basis P&L.  If you want to see them together, run an accrual basis P&L and a Statement of Cash Flows and split your screen, or print both.  

                A
                ama310
                February 19, 2025

                I totally understand your question.  Was on the phone with Tech Support today and as of now there is no option for this which to me is impractical !

                N
                NerbynMaeI
                February 20, 2025

                Looking for a simpler way to track your money in and out, especially when you need to factor in financing activities, and we heard your sentiments, AMA310. Allow me to discuss the step-by-step on how to send feedback in QuickBooks Online (QBO).

                 

                I appreciate your effort in reaching out to our live support team. I understand the importance of being able to generate a report that consolidates all your money-in and money-out entries along with their financing activities. While you may need to compile multiple reports to gather this information, I highly recommend providing your feedback on this matter, as QBO values user suggestions. Your input will be considered and could lead to meaningful improvements in the platform.

                 

                Here's how:

                 

                1. Sign in to your QuickBooks Online account.
                2. Go to the Gear icon and select Feedback.
                3. Type in your feedback and suggestions.
                4. Click Next to submit them.

                 

                You can also share your feedback directly through this link: Customer Feedback for QuickBooks Online.

                 

                Moreover, you may check out this valuable article to know more on how to personalize reports in QBO. Customize reports in QBO. 

                 

                Remember, the Community is always available if you need further assistance or have new questions about QuickBooks Online. We're committed to providing support whenever you require it. 

                Terms & ConditionsAccessibility statement