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 nowI am looking for a report for a property owner that should show income and expense and financing activities on one report.
Meaning, the owner pays mortgages each month which are split in 3. Principal, which is a Liability, Escrow which is also a liability or asset and interest expense.
When you run a P&L, it shows all income and expense, so the interest expense shows up on the report but the principal and escrow payment not.
When you run a cash flow statement the financing activities shows up but only net income, so you don't see income and expenses.
Any idea how to get one report to show it all?
BTW QuickBooks desktop is being used.
Thank you
I've got your back, @RB301.
At this time, the option to generate liability, assets, income, and expense activities in one report aren't available. You can consider running two different reports to produce such information.
For the income and expense activities, you can run the Profit and Loss report. Then, pull up a Balance Sheet report for the liability and assets activities.
I'm adding this article to learn more about customizing reports: Customize reports in QuickBooks Desktop.
Should you need any additional assistance running reports in QuickBooks Desktop, you can leave a comment below. I'll be sure to get back to you.
Thanks
Is this option available in QBO?
Or with an app?
Let me help share information about creating your report, @RB301.
As of the moment, there isn't an integrated way to pull up and create a report to see the list of your income, expense, and all financing activities all at once. It's best to customize the reports shared by my colleague and export them in a new Excel worksheet.
This way, you're now able to combine all your financial activity in one document. Learn more about customizing and exporting a report:
Meanwhile. the Online version of QuickBooks also has the same feature in terms of utilizing a report with QuickBooks Desktop. And all our integrated applications only allow the tracking of your transaction, reporting is not included.
While the option is not yet available, I'd recommend letting our product developers know about this by sending a feature request. Let me show you how:
I'm adding a couple of articles below that'll allow you to dive in deeply and understand your report:
Don't hesitate to post again here if you have other questions or concerns with QuickBooks reporting and navigations. I'm always around happy to help. Stay safe and have a good one!
Thanks so much for your response.
A colleague mentioned the following idea, I am wondering if this could work in the long run.
Instead of the principal and escrow to be a liability account, have it as an expense account, this way it shows on the P&L. End of the year correct it with a general journal entry or change the account to a liability account.
What are your thoughts.
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