Skip to content
logo Knowledgebase

Bank feeds - Duplicate transactions v29.2 and above

Created on  | Last modified on 

Summary

What to do if your bank feeds transactions have downloaded to Sage 50 Accounts more than once following an issue with the bank feed

Description

When you open Bank feeds, if previously cleared transactions reappear in the Transactions from your bank list, you can flag the duplicates as ignored, or, if you've posted a duplicate as a transaction in error, you can delete the transaction from the audit trail.  

Resolution

Are you using bank feeds rules with this connection?

 

▼No

Ignore transactions

  1. Click the Bank Feeds module on the left.
  2. Select the Bank Feeds in question and click Open.
  3. Select the duplicate transactions and click Ignore.
  4. Click Close.

 TIP: To select a range of transactions, press and hold the Shift key, then click the first and last transaction in the range. 

 

▼Yes

Ignore transactions

  1. Click the Bank Feeds module on the left.
  2. Select the Bank Feeds in question and click Open.
  3. Select the duplicate transactions and click Ignore.
  4. Click Close.

 TIP: To select a range of transactions, press and hold the Shift key, then click the first and last transaction in the range. 

Using Bank Feeds Rules - Approval required

If you are using Bank Feeds Rules and you have rules that require approval before transactions are posted, you can reject the pending transaction in Approvals.

 TIP: If you're unsure if your bank feeds rules require approval, you can check this in Bank feeds > Manage rules > Review Before Posting column.

  1. Click Bank Feeds,
  2. Click Open on the feed in question, then click Bank feeds approval.
  3. Ensure only the duplicate transactions you want to reject are selected, then click Reject.
  4. You should then also mark the transaction as ignored within Bank feeds. For help with this, please refer to the section Mark the duplicate transaction as ignored above.

Using Bank Feeds Rules - No approval required

If you're using Bank Feeds Rules and you have rules that are set to post transactions without approval, these rules may have posted duplicate automatic transactions. If this is the case, you should delete those transactions by following the steps in the section above.

 TIP: In the Transactions module, automatic bank feeds transactions show BF:RULE: auto in the User Name column.

 

Delete the duplicate transaction if created

 TIP: To help you identify duplicate transactions, you can use the Accounts audit option. Read more > 

  1. Click Transactions, then select the transactions you want to delete and click Delete.
     NOTE: When you apply a search that only returns one result, the Delete or Edit option can be disabled. As a work around, instead of using a search or filter, use the Find option. Read more > 
  2. Click Delete, then click Yes.
    If the transaction is VAT reconciled, when the message 'Do you wish to reverse this transaction?' appears, click Yes.
  3. When a message appears advising the transaction is bank reconciled, click Yes.  

Depending on the status of the transaction, it is either deleted or reversed. For more information about correcting transactions, please refer to our corrections guide >