cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The QuickBooks Community will be unavailable for approximately 1 hour beginning at 10:00 PM PDT on Wednesday, August 14th for database maintenance. All community forums will be unavailable during maintenance but feel free to browse our Support articles for help in the interim.
user04773
Level 3

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 in 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 Online is being used. 

Thank you

2 Comments 2
GlinetteC
Moderator

Reports for property owner, profit & loss and financing activities

I've got a way how you can get those data in one report, user04773.

 

The option to run and create a report to see the list of your income, expenses, and financing activities in one report is unavailable. 

 

What you can do, is, pull up two different reports, export them into Excel, then combine them to get the data needed.

 

You can run the Profit and Loss report for income and expenses. Then, pull up the Balance Sheet report for your liability and assets activities.

 

To export reports:

 

  1. Go to Business overview and select Reports (Take me there).
  2. Search for the report you want to export.
  3. Select the Export icon at the top. Then select Export to Excel.

 

In addition, check these articles to learn more about what you can do with basic reports to get the data that matters to you most:

 

 

I'll be here to keep helping if you need more help with reports or other QuickBooks issues.

user04773
Level 3

Reports for property owner, profit & loss and financing activities

So you charge me $360 per year (as of October 2022) and I can't get a report that shows all activity without also buying excel and putting in all the manual labor of exporting, importing and adjusting the calculations manually?  Not only that but you want to me to spend another $275 per year, just to be able to split the report into months columns.  

 

Your greed will be your undoing.  Fix your product within 30 days, otherwise I'm going to create a competitor. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us