If you are moving to REI Hub from another accounting system or have already filed taxes on one or more of your rental properties, you may need to enter Opening Balances into REI Hub. An opening balance entry sets the account balance and allows you to keep accurate records without having to recreate detailed transaction histories.
Opening balances will be used most commonly with loan and bank accounts.
Some important things to know:
Setting opening balances is essential to maintaining an accurate Balance Sheet report. Your balance sheet will not properly reflect your portfolio without the opening balances set.
The Balance Sheet tracks the book value of all business assets and liabilities, as well as the capital contributions and distributions of owners and profits that you have reinvested. It will always balance according to what is known as "the accounting equation": Assets = Liabilities + Owner's Equity.
REI Hub uses the account 'Autobalance' for opening balances. For example, an opening balance entry for a loan would credit the loan account and debit Autobalance.
If you are transitioning bookkeeping systems anytime OTHER than January 1st, Revenue and Expense accounts also need a summary entry (an opening balance) for activity between January 1st and the day before your bookkeeping start date.
To Enter an Opening Balance in REI Hub
1) Click the 'Add Transaction' button at the top of the left-side menu
2) Select the Opening Balance transaction type
Opening balance transactions should always be entered for the day before your current bookkeeping period begins.
If your bookkeeping period begins January 1, 2024, you will select December 31, 2023, as the date for your opening balance entries. December 31 will auto-populate in the Opening Balance transaction type.
If you already have a Bookkeeping Start Date (which you can edit from Portfolio Settings), the system will automatically default the date to the day before.
3) Select the Account and enter the amount
Loan Accounts: For a loan account, use the balance of your loan after your December payment and before your January payment so we have an accurate year-end balance to start our loan amortization.
Bank Accounts: For bank accounts, enter the balance as of December 31 of the prior year. This gives us an accurate year-end balance on which we can base the book balance, which will populate as an asset on the balance sheet.
Property Basis: For property basis on past acquisitions or recent acquisitions, you'll want opening balances for land, buildings, the loan account, and accumulated depreciation (if applicable).
Revenue and Expense Accounts: If your bookkeeping start date is the beginning of the calendar year, you do not need to enter opening balances for Revenue and Expense Accounts (as they are reported annually).
4) If desired, click Add Line to enter multiple opening balances at once
The number of opening balance entries you need to make will depend on when you transition bookkeeping systems and what data you track.
Autobalance will be automatically reflected when you enter the balance amount!
5) Click Save Opening Balance
View, edit, or delete opening balance transactions from the Booked Transactions page. Use the Filter to narrow your search by date, account, or transaction type.
Still have questions? Reach out to our Support Team via email at [email protected] or call us at (888)939-6865.