cancel
Showing results for 
Search instead for 
Did you mean: 
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
Best answer January 27, 2020

Best Answers
RenjolynC
QuickBooks Team

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

You can customize the report to add the Customer:Job, J_P_A,

 

When you run the Custom Transaction Detail report, you have the option to add a name column and filter it to the Customer:Job.

 

Here's how:

  1. Go to Reports > Custom Reports > Transaction Detail.
  2. In the Modify Report window, select the Display tab.
  3. Type Name in the Columns field. Make sure it has a check mark.
  4. Go to the Filters tab, and type Name.
  5. Select Name and choose All customers/jobs from the drop-down menu.
  6. Click OK.

Please see this sample screenshot below:

 

 

You can also use the article on how to customize reports in QuickBooks Desktop.

 

Let me know if there's anything else you need about QuickBooks Desktop reports. Thanks.

View solution in original post

4 Comments
Ashley H
QuickBooks Team

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

Good morning, @J_P_A. Thanks for reaching out to the Community. 

 

You can use the Custom Summary and Custom Transaction Detail reports to create specialized reports in QuickBooks. These reports use different combinations from the Display and Filters tab in the Modify Report window. You could build a Custom Report, but just remember that this may be subject to accounting and programming limitations, your permissions in the data file, and how you have the transactions documented in your books.

 

I recommend running a Custom Transaction Detail report. This report lists individual transactions, showing each account involved in a transaction on a separate line. Here's how to run this report:

  1. Go to the Reports menu.
  2. Select Custom Reports, then Transaction Detail.

 

Here's an article for more information on Custom Reports in QuickBooks.

 

Let me know if this works for you. I'm always here to lend a helping hand. Happy Friday!

J_P_A
Level 2

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

Awesome! 

 

I assign transactions to each property using a Customer:Job. I don't see a way to add that column to this report. Am I just missing it? I think that would be necessary for me to be able to sort transactions based on each property.

 

Is there another (preferred) way to associate transactions with a particular property?

RenjolynC
QuickBooks Team

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

You can customize the report to add the Customer:Job, J_P_A,

 

When you run the Custom Transaction Detail report, you have the option to add a name column and filter it to the Customer:Job.

 

Here's how:

  1. Go to Reports > Custom Reports > Transaction Detail.
  2. In the Modify Report window, select the Display tab.
  3. Type Name in the Columns field. Make sure it has a check mark.
  4. Go to the Filters tab, and type Name.
  5. Select Name and choose All customers/jobs from the drop-down menu.
  6. Click OK.

Please see this sample screenshot below:

 

 

You can also use the article on how to customize reports in QuickBooks Desktop.

 

Let me know if there's anything else you need about QuickBooks Desktop reports. Thanks.

View solution in original post

J_P_A
Level 2

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

Perfect! Thanks so much for the help! It seems obvious now :-)

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us