Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Rainflurry
Level 15

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

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

bop88
Level 2

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

Yes I understand principle loan payments are not considered an expense by Quickbooks. But for my purposes as a business owner, it is considered an expense. I want to be able to look at my profit and loss and see all of my "expenses" including loan payments because to me, it is an expense (money I didn't earn or get to keep, it's money I had to spend) 

bop88
Level 2

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

Unfortunately, your solution still does not provide any principle loan payments as an expense. Therefore, it still does not show Total Money In and Total Money Out. 

Rainflurry
Level 15

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

@bop88 

 

As a business owner myself, I understand exactly what you're saying.  This scenario is exactly why I went back to school for accounting.  I didn't understand how a business could make a healthy profit but have no cash to distribute to pay my personal income tax.   

 

"I want to be able to look at my profit and loss and see all of my "expenses" including loan payments because to me, it is an expense (money I didn't earn or get to keep, it's money I had to spend)"

 

That's the exact purpose of the Statement of Cash Flows report.  It tells you what profit the business made and then shows you what items affected your cash balance (loan principal payments) that are not accounted for on the P&L.  

  

ama310
Level 1

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

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 !

NerbynMaeI
QuickBooks Team

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

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. 

ama310
Level 1

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

I hear you and have been on tech support with the same question with no solution from within QB Online.  I created my own MANUAL WORKAROUND VIA EXCEL for Monthly Report.

 

1.  Turn on Locations and identify your transaction within the proper accounts such as Petty Cash, Checking, etc.

2.  Generate and print your Profit & Loss report with Locations:  Include Petty Cash and Bank transactions.  

This report will print each in a separate column.

 

3.  EXPORT report to Excel.

4.  Open Excel.

5.  In Petty Cash column under REVENUE, Manually add 2 LINE ITEMS:

Opening PC Balance (Fill in amount manually) 

PETTY CASH:  (Fill in amount manually transferred to PC).

 

6.  Adjust your formulas to include these additions. 

Balances will coincide exactly with Bank Statement and PC reconciliations.

 

7.  In Bank / Checking column, under EXPENSES, Manually add TRANSFER to Petty Cash

8.  (Manually) add the amount transferred in the month.

 

Not perfect, but it gives me what I want to see all in one place.

Chris J
Level 1

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

I've been battling this exact issue ever since i started using QBO and it's incredibly frustrating that there still seems to be no resolution to what feels like a very simple request. I realize the software is written mostly for accountants, but not all business owners are accountants. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us