Identify and remove duplicate transactions from a bank account with a Yodlee feed

If your Yodlee feed has imported duplicate transactions, delete these transactions manually to ensure that your statement balance in Xero is accurate. First, check your statement balance, then run the Reconciliation Report to identify and delete duplicates.

Check your bank account

There are 2 quick ways to check if there are errors with your imported statements.

Compare balances

Compare your Statement Balance in Xero to your online banking balance. If these don't match, it's likely you have duplicate transactions imported.

Compare your statement balance in Xero to the balance your bank shows

Your feed must be up to date to compare balances. If your bank has multi-factor authentication, make sure you refresh your feed first.

Refresh a Yodlee feed or give other users refresh access

Check your imported statements

If you have overlapping statements imported into Xero, this may affect the accuracy of your statement balance. To check:

  1. Go to Accounts, then click Bank Accounts.
  2. Next to the bank account you want to check, click Manage Account.
  3. Click Bank Statements.
  4. Look for a statement that has a date range that covers dates that have already imported.

View all or individual bank statements

Identify and delete duplicate transactions

You can run the Reconciliation Report to identify and delete duplicate transactions (either individual statement lines or whole statements).

  1. Go to Accounts, then click Bank Accounts.
  2. Next to the bank account you want to check, click Manage Account.
  3. Click Reconciliation Report.
  4. Click the Bank Statement tab.
  5. Select the date range, then click Update.
  6. Look through the statement. If you spot a duplicate transaction, click the date in the Date imported into Xero column.
    • To delete a statement line, select the checkbox next to the transaction, then click Delete.
    • To delete a whole statement, scroll to the bottom of the statement, then click Delete Entire Statement.