Skip to content
logo Knowledgebase

Bank feeds - Duplicate transactions v29.1 and below

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, don't worry, it's easy to resolve this. 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?

▼No

Mark the duplicate transaction as ignored

  1. Click Bank accounts.
  2. Click the relevant bank account, then click Bank feeds.
  3. Select the duplicate transactions, then click Ignore.

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

    Image

 

▼Yes

Mark the duplicate transaction as ignored

  1. Click Bank accounts.
  2. Click the relevant bank account, then click Bank feeds.
  3. Select the duplicate transactions then click Ignore.

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

    Image

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 >

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.

 

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 accounts, then click Bank feeds approval.
  2. Ensure only the duplicate transactions you want to reject are selected, then click Reject.

    Image

  3. 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.