Disconnect your current feed – document your existing rules

Before you disconnect your bank feed we recommend you make notes of any bank rules you have set up as you'll need to set up these again after you reconnect.

 To check your rules:

• Log into Sage 200
• Open Cash Book > Utilities > Bank Feeds Rules
• Highlight the rule and click edit
• Note down the details

  NOTE: Due to issue 8250 if you have over 100 rules you will need to note down the first 100 rules, delete them and then the remaining rules will be available for you to view. This issue has been addressed in our 2023 R1 release.

Disconnect your current bank feed :

• Log into Sage 200
• Open Cash Book > Cash Book Accounts > Amend Bank Account Details (or select the account from the Bank Account List, highlight the bank and select Amend Account from the menu bar)
• Move to the E-Banking tab.
• Select Disable
• The bank account status will change to Disabled.

 TIP:  To disable Sage Bank Feeds, you must have user access to amend the Cash Book Account.  

  CAUTION: If you are using Sage 200 Professional 2022 R1 or earlier you will need to perform an additional step in the company database via SQL – these steps must only be performed by a Sage Business Partner, and you should backup your data before doing so:

Within CBCloudBankAccount Table the field LastTransactionDownloadID needs to be set to 0 against the relevant bank account.

 NOTE: Where you are using HSBC you will need to disconnect within HSBC – you can do this by following these instructions.

Reconnect your bank feed
To onboard again with Sage Bank Feeds, follow the steps below:

  TIP:  To enable Sage Bank Feeds, you must have user access to amend the Cash Book Account. 

• Open Cash Book > Cash Book Accounts > Amend Bank Account Details (or select the account from the Bank Account List, highlight the bank and select Amend Account from the menu bar)
• Navigate to the E-Banking tab.
• In the Sage Bank Feeds section, select Enable.
  • In the Bank Feeds, select your Country
• Click Other banks, then enter your bank name and select the relevant option
• Follow the remaining steps in the wizard – this includes selecting the date you want transactions to be downloaded from your bank. 

You've now set up your Bank feed connection! 

Set up your bank feeds rules:

If your bank authorised the connection straight away during setup, you're now ready to start using Bank feeds. 

Once your connection is authorised you can set up your bank feeds rules as part of your bank reconciliation process. 

Doing your first bank reconciliation after migrating your feed

When you open bank feeds, if you previously cleared transactions reappear in the transaction from your bank list, it’s easy to resolve. 

For transactions that need Bank Feeds Rules re-created; you can create the rule when adding a new transaction. For further help please consult the in-product help files.

For transactions that do not need Bank Feeds Rules created, simply match the transactions as normal.

Correct or reverse a duplicate transaction, if reconciled in error

If you've already matched and processed a transaction, please see the guidance below for your version of Sage 200 on how to unreconcile and reverse the duplicate postings:

Sage 200 Professional

• Correct a customer payment/receipt 
• Correct a supplier payment/receipt 
• Correct nominal payments/receipts 
• How to unreconcile cash book transactions 

Disconnect your current feed – document your existing rules

Before you disconnect your bank feed we recommend you make notes of any bank rules you have set up as you'll need to set up these again after you reconnect.

 To check your rules:

• Log into Sage 200
• Open Settings > Cash Book / Nominal Ledger > Bank Feeds Rules
• Highlight the rule and click edit
• Note down the details

Disconnect your current bank feed :

• Log into Sage 200
• Open Cash Book > Cash Book Accounts > Amend Bank Account Details (or select the account from the Bank Account List, highlight the bank and select Amend Account from the menu bar)
• Move to the E-Banking tab.
• Select Disable
• The bank account status will change to Disabled.

 TIP:  To disable Sage Bank Feeds, you must have user access to amend the Cash Book Account.  

 NOTE: Where you are using HSBC you will need to disconnect within HSBC – you can do this by following these instructions.

Reconnect your bank feed
To onboard again with Sage Bank Feeds, follow the steps below:

  TIP:  To enable Sage Bank Feeds, you must have user access to amend the Cash Book Account. 

• Open Cash Book > Cash Book Accounts > Amend Bank Account Details (or select the account from the Bank Account List, highlight the bank and select Amend Account from the menu bar)
• Navigate to the E-Banking tab.
• In the Sage Bank Feeds section, select Enable.
  • In the Bank Feeds, select your Country
• Click Other banks, then enter your bank name and select the relevant option
• Follow the remaining steps in the wizard – this includes selecting the date you want transactions to be downloaded from your bank. 

You've now set up your Bank feed connection! 

Set up your bank feeds rules:

If your bank authorised the connection straight away during setup, you're now ready to start using Bank feeds. 

Once your connection is authorised you can set up your bank feeds rules as part of your bank reconciliation process. 

Doing your first bank reconciliation after migrating your feed

When you open bank feeds, if you previously cleared transactions reappear in the transaction from your bank list, it’s easy to resolve. 

For transactions that need Bank Feeds Rules re-created; you can create the rule when adding a new transaction. For further help please consult the in-product help files.

For transactions that do not need Bank Feeds Rules created, simply match the transactions as normal.

Correct or reverse a duplicate transaction, if reconciled in error

If you've already matched and processed a transaction, please see the guidance below for your version of Sage 200 on how to unreconcile and reverse the duplicate postings:

Sage 200 Standard / Sage 200 for Education

• Correct a customer payment/receipt 
• Correct a supplier payment/receipt 
• Correct nominal payments/receipts 
• How to unreconcile cash book transactions