Why can I see duplicate lines on the bank side of the unmatched tab?

This article covers duplicate lines on the bank side of the Unmatched tab in Bank Reconciliation, and how to remove the duplicated transaction.

---

Why duplicate lines appear in bank reconciliation

Duplicate lines on the bank side of the Unmatched tab usually mean the same transaction has entered iplicit more than once. This can happen for a few reasons:

• A bank feed provider has sent the same transaction twice, so it appears twice on the bank statement and twice in the bank reconciliation
• A bank statement file, such as a CSV, has been imported more than once, duplicating every transaction in that file
• A transaction has been entered manually as well as imported, so both versions appear in the bank reconciliation.

---

How to remove a duplicate transaction from bank reconciliation

1. Search for Bank Transactions using the search bar
2. Use the filters to find the duplicated transaction
3. Check the Bank Statement column - if the transaction is assigned to a statement, the statement reference is shown; if it is blank, the transaction is not assigned to a statement and can be deleted directly from the Bank Transactions screen
4. If the transaction is assigned to a statement, navigate to that statement and unlock it if it is locked
5. Highlight the duplicated transaction and select 'Delete' - do not select 'Unassign'
6. If the duplicated transaction is the only one on the statement, delete the statement itself, using 'Delete' rather than 'Unassign'.

Deleting the transaction from the statement automatically removes it from the bank reconciliation.

From Transactions Screen: 

From Statements Screen: 

---

If your bank account uses Bank Feeds

1. After deleting the duplicated transaction from the statement, go to Bank Feeds
2. Locate the same transaction - it now appears grey instead of green
3. Highlight it and select 'Ignore in statements'.

This prevents the transaction from being re-imported into future statements, so it does not reappear in bank reconciliation.

If transactions are missing rather than duplicated, this may also be caused by bank feed timing - see 'How to manually add missing transactions to a populated bank statement'.