How to enter a property sale in REI Hub

How to enter a property sale in REI Hub

This article details how to create a journal entry for a recent property sale and enter it into REI Hub.  Manual Journals are used for property purchases, sales, and refinances as these are all complicated transactions touching multiple accounts, and so cannot be templatized to the same degree as simple income or expense transactions.

If you work with a CPA, tax preparer. or tax preparation software, they may handle this transaction on your behalf, and you should be sure to provide them with your closing statement. Many financial professionals can also provide you with the journal entry after they have done it for you to enter into REI Hub. 

Make sure to have the closing statement from the property sale handy, as most values required will be pulled from it.  

How to make a property sale journal entry: 

1) Open a Manual Journal transaction

From the Portfolio Dashboard (or the Booked Transactions page) click the Add Any Transaction button:

And then select Manual Journal from the 'Other' column:

2) Fill out the base information

Enter the closing date and appropriate property.  Add a description of your choosing, such as 'Property Sale Journal.'

If you already have a fixed asset for this property where you entered a property purchase journal entry or fixed asset basis, select it from the dropdown.  If you do not currently have any fixed assets or basis information in REI Hub for the property in question, simply leave the fixed asset field blank.

3) Enter the debit lines 

The Debit lines will be:
  1. Your bank account receiving funds and the amount of those funds.  Owner Funds could be used alternatively if you are not tracking sale proceeds into your bank account.
  2. The loan account and the amount of loan payoff (assuming the property is financed).  This should zero out the loan account.
  3. Accumulated Depreciation in the amount of depreciation taken to date - this should zero out the Accumulated Depreciation account. 
    1. NB: If you have not been tracking fixed assets, property basis, and depreciation in REI Hub, you will omit this line.
  4. Expenses incurred in the sale process. These will be entered with the specific expense account (eg Insurance) and the amount, which will flow through to your Schedule E/ PnL and be deducted against income in the same year.
4) Enter the credit lines

The credit lines will be:
  1. A line for each fixed asset accounts (e.g Land, Buildings, Capital Improvements, etc) and the required amount to zero them out.
  2. Gain on sale - the effective sale price less the book value of assets.
  3. A line for any prepaid expenses (for example, if you paid the tax bill for the whole year before selling - you will get prorated credit for that 
If you have not been tracking fixed assets, property basis, and depreciation in REI Hub, the only credit line will be:
  1. Autobalance in the same amount as the debit half of the journal, to ensure the transaction balances.
5) Save the journal entry

Optionally add a file or image of the closing statement, and save the transaction.

6) Optionally match the deposit in your Import Feed

If you selected a linked bank account in the Debits, and entered the exact same amount as was deposited into your bank account, the REI Hub system will present a Match when you go to book that imported transaction (assuming the dates are both transactions are within +/- 7 days).  The Match will recognize that the Manual Journal and the imported transaction are part of the same transaction, and combine them without duplicating.

You can also simply Ignore the imported transaction if preferred.

7) Optionally mark the property as Inactive

After a property has been sold, you can mark it as inactive.  This will prevent it from displaying on the Properties page and in dropdowns, but preserves the financial information and reports. 

8) Reach out to us with any questions!

    • Related Articles

    • How to enter a refinance in REI Hub

      For many real estate investors, refinancing investment homes is a normal part of the process. Refinancing can help you take advantage of better interest rates for a lower monthly payment, or to pull cash out after the property has risen in value. ...
    • Accounting for flips in REI Hub

      Accounting for fix and flips in REI Hub is similar to rentals, but with a few key differences.  At the most basic level, you will add the property in question to the system, and assign transactions to it, just like the basics of rental property ...
    • REI Hub Overview and Getting Started Guide

      Ready to level up your bookkeeping with REI Hub? Great! Whether you just purchased your first investment property or your twentieth; REI Hub’s real estate and rental property accounting software will save you time, stress, and money! No matter how ...
    • Bank Reconciliation in REI Hub

      Reconciliation is an optional accounting process that enables you to compare your actual, real world bank balances with the balances in REI Hub.  Reconciliation assists in identifying any discrepancies and confirming that your records are complete, ...
    • Transitioning to REI Hub from another bookkeeping system

      Ready to take advantage of REI Hub's property accounting software, but aren't sure what's involved in making the switch from your current bookkeeping system?  You're in the right place! When transitioning accounting systems, the best practice is to ...