Fix duplicate bank connections

Automatic bank transaction imports are part of Wave’s Pro Plan. Learn more about Wave’s plans or how to subscribe.

 

If your bank account was connected more than once to import transactions, causing duplicates on your Transactions page, follow the steps below to fix it.

Review your Connected Accounts page to turn off imports or delete duplicate accounts

To make sure you only have the bank connections you need for transaction imports:

  1. On the left-side menu, click Banking > Connected Accounts to find a list of your bank connections.
  2. Toggle off Automatically import transactions into...for any unneeded accounts.
    Screenshot_2021-02-17_at_2.39.22_PM.png
  3. Toggle on imports for any bank or credit card accounts you need transactions from and assign them to the correct account in your Chart of Accounts.

    If you toggle imports on for any account, ensure that you select Edit date to select the date to import from. Choose the day after your most recently imported transaction to prevent more duplicates. You can find this information on your Transactions page or in your Chart of Accounts. For example, if your last imported transaction was on February 4th, 2023 then select February 5th, 2023 to start importing from.

  4. If you have an entire connection duplicated (multiple bank or credit card accounts under one bank connection), then you can also delete the connection you no longer want by clicking the trash can icon at the top right of the connected account.

If your connected bank account is used for online payments or payroll, you'll need to update the account you want to use for that feature before you can delete the connection. Learn how in Update your payout account or Update your payroll funding account.

Review your Chart of Accounts and rename the duplicate account

Next, you'll want to locate any asset or liability (credit card) accounts in your Chart of Accounts that were created for the duplicate connection. Renaming the unneeded account to mark it as a duplicate will help you to locate it more easily in filters and in the final step when you archive it.

  1. On the left-side menu, click Accounting > Chart of Accounts and locate the duplicate accounts. Checking and Savings accounts will be under the Assets tab while credit card accounts will be under the Credit Cards and Liabilities tab.

    Screenshot_2021-02-17_at_2.40.09_PM.pngScreenshot_2021-02-17_at_2.40.22_PM.png
  2. Determine which account is still connected to your bank connection. This will likely be the one with the latest imported transaction date. You need to retain this account for your accounting.
  3. Edit the unneeded account by clicking the pencil icon next to its name.
  4. Rename the account to something that will indicate it's a duplicate which will make it easier to filter for in the next step.
    Screenshot_2021-02-17_at_2.46.57_PM.png

Review your Transactions page to delete or move duplicates

Now you will need to remove any imported transactions from your unneeded accounts. This may mean moving your transactions from one account to another to ensure all your transactions for a bank or credit card account are in one place. Alternatively, you can also bulk delete your transactions if you don't need the account at all. To either bulk delete, or move all your transactions from one account to another:

  1. On the left-side menu, click Accounting > Transactions.
  2. Filter for your unneeded account using the Account dropdown menu at the top (this will be the account you renamed in the previous step.)Screenshot_2021-02-17_at_2.47.24_PM.png
  3. Click Select All to bulk select all transactions that have loaded on the page.
  4. To move the transactions into the correct account, click Edit and change the Account field to the currently connected account.

    To permanently delete your transactions, use the Delete button instead of the Edit button after selecting the transactions.

  5. Repeat this process for all transactions in the account until you have no transactions left.
  6. If more than one account was duplicated, repeat the process for all duplicated accounts.

If you need help bulk editing or deleting your transactions, see How to use bulk actions on transactions.

Archive duplicate accounts under your Chart of Accounts

Once you've moved or deleted all the transactions from the unneeded accounts, you can now archive them in the Chart of Accounts. This will also remove the account from the drop-down menu in the Transactions page.

  1. Head back to Accounting > Chart of Accounts and click the pencil icon next to your unneeded account.
  2. Select the checkbox next to Archive Account.
  3. Click Save.
    Screenshot_2021-02-17_at_2.51.00_PM.png

This should make the account disappear completely from Wave as long as there are no associated transactions. Once you've completed this for all duplicate accounts, you're done!