One common question from new users is how mortgage payments are reflected on reports in the REI Hub system. The loan payment template helps automate the breakdown of a mortgage payment into its component principal, interest, and escrow (if applicable) pieces.

Of these three pieces, only the interest component is immediately visible on the Net Income (Profit & Loss) or Schedule E reports. Depending on your selection when creating the loan account, you can find it under either the mortgage interest or other interest expense accounts. The IRS considers interest a deductible expense, so it is immediately reflected on profit and loss-focused reports.

The principal paydown for a loan is not displayed on the Net Income (P&L) statements. Loan repayment is not considered an expense when it comes to your taxes or when calculating profitability. The principal paydown is on the Cash Flow or Balance Sheet reports.

If your loan is escrowed, the monthly escrow contribution won't show on the P&L since it is an estimate and not a direct expense (and therefore, the IRS doesn't allow it to be used as a deductible expense).

The actual property tax and insurance expenses that correspond to your escrow contributions will show on the P&L, but these escrow expenses have to be entered manually since they are not coming out of a linked bank account.

Our Tax Review process helps ensure that you don't forget to enter these (and other easily missed) transactions.

Use the Operating Cash Flow reports to see your standard income and expenses with principal paydown, interest expenses, and escrow contributions.

The Operating Cash Flow reports show NOI, plus principal paydown and escrow contributions in a digestible format (but omit fixed asset purchases and manual journals, as this report is intended to show normalized operating cash flow).

​

​

​