Booking your annual expenses from escrow

Booking your annual expenses from escrow

Some mortgages include an escrow component where you pay the mortgage servicer extra every month, and then they pay property tax and insurance out of that escrow account. 

REI Hub's Loan Payment Template feature helps you break down your monthly mortgage payment into its principal, interest, and escrow components on an ongoing basis.  The escrow component of your mortgage payment is a transfer, not a direct expense.  It is funding the escrow account associated with your loan with a monthly approximation of what your mortgage servicer thinks the annual escrow expenses will be. 

The IRS requires you to report your actual expenses, not your estimated expenses.  Therefore, you can't just report the escrow transfers as property tax or insurance expenses, and instead must enter the actual expenses.

Since these expenses are paid out of your escrow account, you will not have an imported transaction from your operating bank account to cue you to book these expenses.  So if you have an escrowed mortgage, don't forget to book your escrow expenses!  

These instructions allow you to book your escrow expenses directly out of the escrow account you have been funding with your mortgage payments.

To book your property tax and insurance expenses from your escrow account:

1) Click Add Any Transaction from the Portfolio Dashboard



You can also click Add Transaction from the Booked Transaction page

2) Select Escrow Expense from the Other column



3) Fill out the fields as appropriate



The 'Expense Account' field should be Taxes or Insurance as appropriate.  Choose the Escrow Account that is associated with the loan for the property in question.

4) Click Save Transaction

And you're done!  You will now see the expenses being reflected in your Net Income/ Schedule E reports, as well as your escrow account balances reducing on the Balance Sheet.

5) Reach out to us with questions or for assistance!


    • Related Articles

    • Portfolio Level Expenses

      Some expenses or transactions do not apply to just one property, but to your entire portfolio.  Sometimes called overhead, these transactions are referred to as Portfolio level expenses in REI Hub.  Any transaction can be booked to the Portfolio ...
    • Booking an imported transaction

      After you have linked a bank account to REI Hub, or uploaded transactions from Excel, you are able to view a feed of your imported transactions.  The act of 'booking' a transaction means that you are categorizing and adding that transaction to your ...
    • Booking a manual transaction

      You may want to add a transaction manually if you choose not to link your bank accounts, or if the transaction involves an account not typically used for your real estate business. To book a transaction manually 1) Click on Add Transaction The Add ...
    • Tax time double-check: easily missed deductions

      Alright, this is it.  The moment we’ve all been preparing for, why you’re thinking about a Lowes trip ten months ago, and the biggest reason you’ve been diligently keeping your books all year (or feverishly in the last week). Tax time.  The due date ...
    • About the Tax Review

      Have you been getting ready for tax time, but aren't quite sure if you are missing anything?  Would you like a quick double check of your books to see if you can find any more deductions? The Tax Review is a fast and easy way to double check your REI ...