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 many doors you have, the basics of setting up your REI Hub Portfolio are the same. In this guide, we’ll introduce you to REI Hub and the various components and concepts the system is comprised of. As you read through, keep an eye out for links to additional resources providing more context in specific areas.

Successful and efficient bookkeeping is built on a strong foundation. In addition to the specifics presented here, also remember the fundamental value of a dedicated bank account and accounting software for your real estate investments!

Let’s get started!

First, a note on Portfolios. In REI Hub, the portfolio is the top level of the reporting structure. Properties live underneath the portfolio, and units live underneath properties (if applicable). Some reports, like the Balance Sheet, are best viewed at the portfolio level. Most reports, including the Net Income (or Profit and Loss), are also available at a Property-by-Property and Unit level.

Generally speaking, a portfolio will correspond to a legal entity. Most separate businesses need fully separate books and, thus, their own portfolio. This is especially the case when multiple partners/investors are involved, and a Balance Sheet is required to file a tax return. The main exception is if all your properties are either in your name or held in single-member LLCs for asset protection. In this case, there are no other beneficial owners or legal entities with individual filing requirements, so everything is a pass-through that flows through to your personal tax return (on the IRS 1040 Schedule E).

So, with only one tax return involved, you’re generally in the clear to keep all your properties in just one portfolio. Your portfolio is also relevant to your day-to-day bookkeeping. Overhead or any transaction for your rentals that is not directly attributable to an individual property can instead be booked at the portfolio level of your account. View these transactions on the Net Income by Property report in the ‘None Assigned’ column. Each portfolio carries its own subscription (and a free trial!). You can add and manage multiple portfolios from one set of REI Hub log-in information. Access for additional users is also segmented at the portfolio level.
​

Your Bookkeeping Start Date defines the period of time that REI Hub’s records should be considered definitive. You will be prompted to select a Bookkeeping Start Date as a part of the initial setup. To view or edit your Bookkeeping Start Date after setup, visit the Portfolio Settings Page in the right-hand menu.

Setting a Bookkeeping Start Date is also an essential part of transitioning from one accounting system to another. With a Bookkeeping Start Date in place, you can set Opening Balances based on the Closing Balances in your previous accounting system.

You can choose any date as your Bookkeeping Start Date. The most commonly chosen date is January 1 to align with a new calendar year.

If you choose a date other than January 1, you will need to make a summary entry for year-to-date revenues and expenses or reference those numbers to prepare your annual tax return.
​

As you may expect for real estate investing accounting software, properties are the basic reportable item in REI Hub (and function similar to a ‘class’ in generic accounting software). When setting up a new portfolio, the first thing you do is create a property. Taking your rental business transactions and categorizing them by property and account (revenue, expense, or otherwise) is the central bookkeeping task required of real estate investors.

A property can be just one unit (like a condo or single-family home) or a multi-unit (like a duplex or apartment building). Units are the lowest reporting element in REI Hub as the layers start largest with Portfolio > Property > Unit. Your REI Hub subscription plan is based on the number of units (also referred to as doors) in your portfolio.

If you’re not sure if you should set up a property as a single or multi-unit, consider what kind of reports you want to be able to generate. If you have a single-family home, but you rent it by the room and want to see your income split by room, you need to set it up as a multi-unit property. Similarly, if you have a large property with a detached guest cottage but rent it all out to just one person, you should set it up as a single-unit property.

Adding your bank and credit card accounts to the REI Hub system helps you see where your funds are and track their flow through your business. In REI Hub, you can create your accounts as either linked accounts or manual accounts.

Linked Accounts utilize secure data providers to connect to your financial institution and automatically import your transaction record. We recommend linking all accounts that are primarily used for your real estate investments. Using a dedicated business account is the best foundation for successful bookkeeping, and linking that account to your accounting software is the best way to ensure you don’t miss booking expenses and maximize your tax deductions!

After an account has been linked, you can view the imported transactions on your import feed. Access the import feed from either the banking page or directly on the left side menu. Imported transactions include the date, amount, description, and originating account. These imported transactions need to be ‘booked’ by adding the appropriate expense or revenue account to become an official part of your records and reports.

Manual Accounts have no direct connection to your bank, so transactions must be added manually or uploaded via Excel. Manual accounts work well for bookkeeping in batches with uploading or for accounts with very few transactions.

If you choose not to create any bank or credit card accounts in REI Hub, the default account for payments and deposits is owner funds. You can think about owner funds as your personal money. When you book an expense paid by owner funds, the outcome is the same as making an owner contribution to a business checking account and then paying the bill from that account. Investors can still keep accurate books using exclusively owner funds, but you lose many of the double-checks and automation that using designated rental accounts provides.

In terms of transitioning over from another accounting system, if that bank or credit card account exists in your previous system and is still in use, it should be created in REI Hub as well.
​

There are two types of transactions in the REI Hub system. Imported Transactions are what comes in from a linked account (or bank export upload), including the date, amount, description, and originating account. They are a data source—they are not part of your actual financial records or reports yet.

In order to add an imported transaction to your records, you need to ‘book’ it by adding the additional information needed for complete bookkeeping. This means specifying the type of transaction (expense, revenue, loan payment, etc.), the relevant account (e.g., repairs for an expense, rent for a revenue), and the property in which it applies. All the information we have is prefilled, and there is a drop-down for every other field with the available options, making it easy!

After everything has been saved, the imported transaction is now a booked transaction. Booked transactions are your financial records and become the information all of the reports pull from. You can consider the booked transactions page (on the left-side menu under transactions) to be the general ledger. As REI Hub is a double-entry accounting system, each booked transaction has at least one credit and debit.

Want to save a ton of time? You can automatically book imported transactions using transaction matching rules based on the description or amount.

All transactions that are added manually to the system are automatically booked transactions. Linked accounts and/or uploading transactions are a time-saving convenience but are not required to fully keep your books in REI Hub.

Similar to bank and credit card accounts, adding loans allows you to track the flow of funds through your business, as well as things like principal paydown and estimated equity. Before you can book a loan payment, you must first create a loan account.

Loan accounts in REI Hub encompass both mortgage and non-mortgage loans. Creating a loan automatically adds it to your chart of accounts as a liability account. If it is an escrowed loan, the escrow account is also automatically added to the chart of accounts as an asset account.

The loan payment template helps you automatically break down regular loan payments into their components of principal, interest, and escrow (if applicable).

Loan accounts are not electronically linked in the same way as bank and credit card accounts, as loan payment transactions are typically already imported from the bank account side.
​

Many real estate investors utilize property managers or property management software that can receive funds and/or pay expenses on behalf of the property owner. While this can be a great help, it also carries the potential to complicate your bookkeeping and accounting. REI Hub offers property management accounts to accurately reflect the flow of funds through these accounts in your portfolio.

Property management accounts function as a clearing account between the tenant and your rental checking account. After creating a property management account in REI Hub, you will see it available as a payment account and a deposit account. This means that you can book both revenues and expenses directly to the property management account and then subsequently book the distribution from property management to your bank account.

Handling transactions from your property manager or property management software in this fashion reflects what has happened in real life and makes accounting for net deposits, delayed payouts, and property managers who keep a running balance from month to month much easier.

If your property manager uses Appfolio, you can directly upload your statement into REI Hub for net income transactions to be created. If your property manager uses another management software, you can enter that information into our universal property management statement uploader.

Booking transactions to your property management account instead of one of your bank accounts does not impact your tax liability. A property manager receiving rent on your behalf is acting as your agent and is the same thing as you directly receiving that rent in the eyes of the IRS.

All of the above being said, property management accounts are optional in REI Hub, even if you have a property manager or property management software.

Fixed assets (also known as capital expenses) are your depreciable items, including the investment property itself and the capital improvements you make to it. These non-operational costs are not written off against income in a single year but are instead recovered over a preset period of time through depreciation. For example, residential rental property is depreciated on a 27.5-year timeline, while appliances are depreciated on a much shorter 5-year timeline. Read more details from the IRS here.

If you have basis and accumulated depreciation information in your old accounting system and want to transfer it over, you need to first create fixed assets in REI Hub. You should create separate fixed assets for each property and any tracked capital improvements (a kitchen renovation, a roof replacement, etc.) that you are currently depreciating.

After the fixed asset has been created, enter the transactions that comprise the asset. For transitioning accounting systems, you will use the opening balance transaction type to set balances for accounts like buildings (depreciable basis), land (non-depreciable basis), and accumulated depreciation. More on that below!

Fixed Assets created during your current accounting period (like a recent property purchase) will be handled slightly differently than those being transitioned over from your previous system. To properly enter a recent property purchase, a journal entry should be created based on the closing statement. This entry sets the property basis and also reflects transactions that flow through to your operational P&L. An ongoing renovation might require a series of capital improvement transactions as bills are paid.

After creation, you’ll depreciate fixed assets over their useful life, lowering their recorded value in your books. Most investors record a single annual depreciation entry for each asset.

If you are not currently tracking your fixed asset information, check with your tax preparer to see if they are doing so on your behalf. That’s OK as fixed assets is an optional feature in REI Hub. You can easily keep your operational income and expenses in REI Hub without tracking fixed assets. However, fixed assets are essential if you want the full records of your investments in one location and the ability to create a balance sheet for your portfolio.

REI Hub’s default expense accounts exactly match the IRS Schedule E expense categories for the shortest possible distance between booking expenses and getting ready for tax time. The default revenue, asset, liability, and equity accounts also include the basics of what you’ll need and can be easily expanded upon if desired.

If you are transitioning from another accounting system, ensure your chart of accounts matches up. If you have accounts in your previous system that do not currently exist in REI Hub, you may need to create those accounts or decide how you’ll classify their transactions moving forward.

Updating your chart of accounts is easy to do. Sub-accounts are supported and are especially recommended for additional expense accounts if you plan to use REI Hub’s automatic Schedule E report.
​

In addition to the bookkeeping and accounting features already discussed, REI Hub also offers several organizational features. These can potentially be linked to your finances (like the mileage tracker) but typically are more oriented towards the additional record keeping often required or desired by real estate investors and rental property owners.

REI Hub provides a variety of reports to help you interpret your investment property performance. Most are traditional financial reports, like the Net Income (or Profit and loss), Operating Cash Flow, and Balance Sheet. Some are more returns-oriented, like the Net Operating Income. Finally, we also offer an automated tax-focused report for Schedule E investors.

Take note that REI Hub’s reports all show actual numbers based on the transactions booked into the system for the given date range. Compared to proformas or anticipated steady-state income and expenses, you can expect to see significantly more fluctuation in your actual numbers, especially early on in an investment’s life cycle!
​

Hopefully, this overview has been helpful in understanding how to get set up in the REI Hub system. If you would like some direct assistance getting started or have any questions at all, please reach out! We actually like to talk about bookkeeping and accounting and we would be happy to assist you.