SALE EXTENDED 70% OFF QuickBooks for 3 months*   Ends 12/8

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll

Reply to message

View discussion in a popup

Replying to:
J_P_A
Level 2

Report showing Net Cash Flow Including Principal, Interest, and Expenses

I have been trying to find a way to monitor cash flow both monthly and annually for real estate properties. Principal payments are being tracked as a decrease  to the long term liability account. Interest is tracked as an expense.

 

I believe that is the usual arrangement, but it makes tracking actual cash flow difficult. That is, for each property, I would like a single report showing how much was received in rent/lease/payments vs how much was paid out in expenses/principal. Basically, I want to be able to quickly see which properties are cash flow positive each month (as well as annually), on a single report. I know I can work this out from the P/L and the balance sheet, but it would be much easier if there was a way to automate that process.

 

The Statement of Cash Flows is close, but not exactly what I'm looking for because it includes the initial increase to the long term liability account when the mortgage is taken out. I also don't see a way to split this out by property (job).

 

Am I overlooking the report to do this?

Solved

Need to get in touch?

Contact us