Duplicate bank feed transactions

On 17 November 2025, we switched our bank feeds to use a more modern process for better reliability and performance. However, it has also caused an issue where some customers now have duplicate transactions.

To fix the issue, you can use SQL scripts to hide the duplicate transactions. If you’re not comfortable using SQL scripts, you can hide them manually or ask your partner to run the scripts for you.

Your data is safe. Balances won’t change unless you approve or match the duplicate transactions. Once you hide the duplicates, you won’t get them again.

More bank feeds help

• Reapplying for BNZ bank feeds

• Missing bank feed transactions

Using SQL scripts to hide duplicates

SQL scripts let you manage a large number of duplicate transactions in bulk. Before getting started:

• You need access to Microsoft SQL Server Management Studio (SSMS) or an equivalent tool.

• If you’re unsure how to access your database, contact your MYOB consultant or support partner.

Run the SQL scripts

1. Run the Select/show problem transactions script. This script lists all transactions that appear to be duplicates based on matching details like amount, date, and description:

   SQL

   SELECT duplicate.*
   FROM BANKFEEDS_TRANSACTIONS AS duplicate
   INNER JOIN BANKFEEDS_TRANSACTIONS AS original
   ON duplicate.BANKFEED_BANKACCOUNT_SEQNO = original.BANKFEED_BANKACCOUNT_SEQNO
   AND duplicate.AMOUNT = original.AMOUNT
   AND duplicate.ANALYSIS = original.ANALYSIS
   AND duplicate.DESCRIPTION = original.DESCRIPTION
   AND duplicate.FIT_ID <> original.FIT_ID
   AND duplicate.OTHER_PARTY = original.OTHER_PARTY
   AND duplicate.PARTICULARS = original.PARTICULARS
   AND duplicate.REF_NO = original.REF_NO
   AND duplicate.TRAN_CODE = original.TRAN_CODE
   AND duplicate.TRANSACTION_DATE = original.TRANSACTION_DATE
   AND duplicate.TEXT_FIELD = original.TEXT_FIELD
   AND original.SEQNO < duplicate.SEQNO
   AND original.MATCHED <> 'H'
   AND duplicate.MATCHED <> 'Y'
   AND duplicate.TRANSACTION_DATE > '20250701'

2. Check the output to confirm that the transactions listed are duplicates and safe to hide.

3. Run the Update and hide problem transactions script. This script marks duplicates as hidden in the database.

   SQL

   UPDATE duplicate
   SET duplicate.MATCHED = 'H'
   FROM BANKFEEDS_TRANSACTIONS AS duplicate
   INNER JOIN BANKFEEDS_TRANSACTIONS AS original
   ON duplicate.BANKFEED_BANKACCOUNT_SEQNO = original.BANKFEED_BANKACCOUNT_SEQNO
   AND duplicate.AMOUNT = original.AMOUNT
   AND duplicate.ANALYSIS = original.ANALYSIS
   AND duplicate.DESCRIPTION = original.DESCRIPTION
   AND duplicate.FIT_ID <> original.FIT_ID
   AND duplicate.OTHER_PARTY = original.OTHER_PARTY
   AND duplicate.PARTICULARS = original.PARTICULARS
   AND duplicate.REF_NO = original.REF_NO
   AND duplicate.TRAN_CODE = original.TRAN_CODE
   AND duplicate.TRANSACTION_DATE = original.TRANSACTION_DATE
   AND duplicate.TEXT_FIELD = original.TEXT_FIELD
   AND original.SEQNO < duplicate.SEQNO
   AND original.MATCHED <> 'H'
   AND duplicate.MATCHED <> 'Y'
   AND duplicate.TRANSACTION_DATE > '20250701'

4. Review which transactions were hidden. If a transaction was incorrectly hidden, you can unhide it in MYOB Exo Finance, like any other hidden transaction. It’s also a good idea to review hidden transactions occasionally to ensure accuracy.

Keep the duplicate with the highest transaction number

Exo Business uses the highest transaction number to identify the latest valid record. For example, let’s say a customer has three duplicate transactions: #1001, #1002 and #1003. You would keep transaction #1003 and delete the duplicates #1001 and #1002.

Manually hiding duplicates

Hiding a transaction does not delete it, but it won’t appear on the Bank Reconciliation screen and it will be excluded from rules and future processing.

1. In Exo Finance, go to Transactions > Bank Feeds.

2. Select an Account.

3. If the BankFeeds Transaction Entry screen opens, close it.

4. Use the Date Filter to make it easier to find the duplicate transactions.

5. To sort the transactions and easily find duplicates:

   • Use the Date Filter.

   • Click on Withdrawals and Deposits columns, which sorts by amounts.

   • Hold the Shift key and click on the header.

Quickly selecting multiple transactions

Click a transaction, then hold the Shift key and click the last transaction you want to select. This selects all the transactions between the first and last.

6. When you find a duplicate transaction, right-click on it and choose Hide Transactions.

   Hiding a transactions automatically updates the total at the bottom of the screen.

   After hiding all duplicates, you can create rules and post to the GL as usual.

Viewing hidden transactions

To view hidden transactions on the Bank Feeds screen, set the Display Transactions dropdown to Hidden.