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, accurate, and reliable.

Some Important Things to Know

Many real estate investors reconcile their accounts monthly, but any time period can be selected.
When reconciling, start with the oldest time period first. If you start with a more recent time period, all the transactions in that statement and earlier are included to be reconciled. The earlier transactions will not have the ability to be unselected.
Only reconcile an account after you have booked all transactions for the period and believe everything is accurate. Accounts with unbooked or ignored transactions typically cannot be successfully reconciled.
Reconciliation only looks at account balances; it does not help identify incorrectly categorized transactions (e.g., a Loan Payment inadvertently booked as an Expense)

If desired, after reconciling all your accounts through a given date, you can optionally choose to set or update the 'Bookkeeping Close Date' field in the Portfolio Settings page.

This will block journal entries or transactions being entered or changed before the selected date. This feature is designed to help prevent accidental or inadvertent changes after you have completed your bookkeeping for a time period. Setting a bookkeeping close date is not a requirement and has no impact on your reporting.

To Reconcile Bank Accounts in REI Hub

1) Book all transactions for the bank account

Determine the bank account or credit card and the date range you want to reconcile.
Ensure that all transactions have been booked (and not Ignored) for that account and date range.
Pull a bank statement for the desired time period showing starting balance, ending balance, and transactions.
- Optionally, export the account register from REI Hub if you want to be able to view it in Excel or print it out to directly compare to the bank statement.

2) From the Banking page, click on the 'View Account Register' button of the account you want to reconcile

3) Click on Reconcile Account

4) Enter the statement Start Date and End Date

5) Enter the Statement Starting Balance

6) Adjust balances if necessary

If the Statement Starting Balance matches the balance in REI Hub, you will immediately go to the next step and be asked to enter the Statement Closing Balance.
If the Statement Starting Balance does not match the balance in REI Hub, the system will notify you and present the Statement Starting Balance and the total balance in REI Hub. To address the discrepancy, you may need to exit the current reconciliation process so that you can reconcile at an earlier time or look further into the computed balance in REI Hub.
Optionally, you can automatically add an adjusting journal entry so that the balance in REI Hub matches the Statement Starting Balance.
- Adjusting Journal entries are usually only done once. You can also proceed with the current reconciliation without addressing the balance discrepancy.
- While these options are available, the best practice is to fix the discrepancy before reconciling.

7) Enter the statement Ending Balance

8) View the Balance Summary and choose which transactions to mark as reconciled

By default, all transactions in the statement period and earlier are included and checked to be reconciled. Unchecking a transaction will impact the Reconciled/ REI Hub balance. If a transaction is unchecked, it will not be considered reconciled at this time, but it will be included in the next reconciliation.
When the balances match, or you have included or excluded transactions to your satisfaction, click Save and Finish. This will complete the reconciliation process.

9) Reconciled transactions will now appear with an R on the bank register page

Tips for Reconciling Bank Accounts in REI Hub

In checking accounts, the running balance (displayed on the far right of the Account Register) should not be negative. If the running balance is consistently negative for weeks or months, or if your ending balance is negative, this means an earlier transaction was miscategorized. You'll want to unbook the transaction and rebook it appropriately. Check out the REI Hub transaction types and scopes article for more assistance on booking transactions.
Use the Filter button at the top of the Account Register page to view only the date range you're reconciling. As aforementioned, reconciliation only looks at balances, not at how the individual transactions are categorized. If your balances do not align, then you will want to go through each transaction within that date range to make sure it appears on your statement and is booked correctly. Optionally, you can export this filtered data to an Excel file, where you can highlight transactions that appear on your statement and make the comparison process simpler.