Bank Reconciliation in REI Hub

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, accurate, and reliable.  Many real estate investors reconcile their accounts on a monthly basis, but any time period can be selected.

Some key takeaways from this article:
  1. Reconciliation lets you confirm that your real world bank balances align with the balances in your accounting software
  2. Only reconcile an account after you have booked (not ignored) all transactions in the time period and think everything is accurate
  3. Reconciliation only looks at account balances; it does not help identify incorrectly categorized transactions (e.g. a Loan Payment inadvertently booked as an Expense)
How to perform a reconciliation in REI Hub:

1) Prior to running the reconciliation:
  1. Determine the bank account or credit card and date range you wish to reconcile
  2. Ensure that all transactions have been booked (and not Ignored) for that account and date range
  3. Pull a bank statement for the desired time period showing starting balance, ending balance, and transactions
2) Navigate to the Banking page, and click on the name of the account you are reconciling.

3) Click on Reconcile Account

4) Enter the statement Start Date and End Date

5) Enter the Statement Starting Balance

If the Statement Starting Balance matches the balance in REI Hub, you will immediately go to the next step and be asked to enter in 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.  In order to address the discrepancy, you may need to exit the current reconciliation process so that you can reconcile an earlier period or look further into the computed balance in REI Hub.

Optionally, you can choose to automatically add an adjusting journal entry so that the balance in REI Hub matches the Statement Starting Balance.  You can also choose to proceed with the current reconciliation without addressing the balance discrepancy.  

While these options are available, the best practice is to fix the discrepancy before proceeding with reconciliation.

7) Enter the statement Ending Balance

7) 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, and 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.

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

9) Contact us with any questions!

    • Related Articles

    • 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 ...
    • The Bank and Credit Card Account Register Page

      The account register page for bank and credit card accounts is the central hub for that account. From it, you can edit account details, run reconciliations, and view recent transactions and running balances. While there are many ways to access and ...
    • 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 ...
    • Uploading transactions from bank exports

      REI Hub offers three different ways to add transactions.  You can link an account to have transactions imported automatically, you can add transactions manually one by one, or you can upload transactions downloaded from your bank or credit card- ...