Sage 200 Professional & Standard - What steps must I take to migrate from one bank feed provider to another?

Summary

This article outlines the steps to follow when migrating from one bank feed type to another.

Description

The steps below are specific to staying with your current provider, but moving to a newer type of feed.

We wrote to customers on 19th June to let them know that they need to migrate to a newer feed prior to their current connection being discontinued. It applies to the following banks:

Bank of Scotland
Cashplus
Lloyds
Natwest
Royal Bank of Scotland
HSBC – please note there is an additional step that applies to this bank only

NOTE:

If you did not receive a communication these steps do not apply to you.

Resolution

Sage 200 Professional

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

Sage 200 Standard / Sage 200 for Education

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.