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.
RB301
Level 2

Reports for property owner, profit & loss and financing activities

I 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

4 Comments 4
Mark_R
Moderator

Reports for property owner, profit & loss and financing activities

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.

RB301
Level 2

Reports for property owner, profit & loss and financing activities

Thanks

Is this option available in QBO?

Or with an app?

JonpriL
Moderator

Reports for property owner, profit & loss and financing activities

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:

 

  1. Go Help.
  2. Select Send Feedback Online,
  3. Click Product Suggestion.
  4. Under Product Area, choose Reports.
  5. Enter a few words describing how you wanted to customize a report showing all your financing activities.
  6. Select Send Feedback.
  7. Click Close window.

 

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!

RB301
Level 2

Reports for property owner, profit & loss and financing activities

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.

 

 

 

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

Need to get in touch?

Contact us