The REI Hub system allows you to merge one account into another, transferring all the existing transactions into the new account and removing the old one. This is most commonly done in two scenarios:
When you have two versions of the same bank or credit card account, you need to consolidate them into one. This can be necessary when a linked account loses its connection with the data provider, necessitating the creation of a new linked account with an active data provider connection, or if you want to transition from using a manual account to a linked account.
When you want to re-assign transactions from one sub-account to another, you can merge from one sub-account to another. For example, if you had a Cleaning Supplies sub-account of the default expense account Supplies but decided you would rather have those transactions in a sub-account nested below Cleaning and Maintenance, you can merge from one sub-account to another. This precludes you from needing to edit each individual transaction.
The REI Hub team is happy to merge accounts on your behalf—just let us know at [email protected] or call us at 888-939-6865. Or feel free to follow the process below to do it yourself!
To Merge Bank Accounts
From the Banking page, click the edit pencil next to the name of the old account - the one with the inactive connection. You must start the merge process from the 'old' account with existing transactions and merge it into the 'new' account.
Click the 'Merge' button at the bottom right. A message will pop up notifying you how many transactions will be modified and asking you to select what account to merge the transactions into.
Select the newly imported version of the same account.
If there are unbooked imported transactions in the older account, check the box to 'Also transfer unbooked imported transactions.' This is important to make sure your unbooked transactions move as well.
Click 'Merge and Delete Account' and confirm.
This consolidates the old and new versions of the accounts. From the banking page, you should now only see the one version. Repeat as necessary for any other accounts.
If you see an error message that says, 'These accounts contain imported transactions for an overlapping date range,' this means transactions in the new account are part of a date range that already exists in the old account. To make sure there are no duplicate transactions, open two windows with the old account on one side and the new account on the other, and remove any duplicate transactions from the new account. Once this is complete, you should be able to merge the bank accounts without an error message. If it continues to populate, please reach out to our support team with an explanation of the accounts you're trying to merge and the suspected date ranges that are overlapping.
To Merge Accounts Within the Chart of Accounts
Click the Edit button from the existing account you wish to merge into the new one. You must start the merge process from the 'old' account with existing transactions and merge it into the 'new' account.
Click the 'Merge' button at the bottom right. A message will pop up notifying you how many transactions will be modified and asking you to select what account to merge the transactions into.
Select the new destination sub-account.
Click 'Merge and Delete Account' and confirm.
Please note: you can only merge custom-created accounts, not default accounts.
This consolidates the two sub-accounts. You will now only see the new one from the chart of accounts page.
Still have questions? Reach out to our Support Team via email at [email protected] or call us at (888)939-6865.