Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy now
"...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.
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)
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.
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.
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 !
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:
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.
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here