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

The steps below are specific to Yorkshire or Clydesdale bank when migrating to Virgin , if you are experiencing issues with a different feed please consult your Sage Business partner at your earliest convience.

Disconnect from Yorkshire or Clydesdale Bank

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:

1. Log into Sage 200
2. Open Cash Book > Utilities > Bank Feeds Rules
3. Highlight the rule and click edit
4. 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:

1. Log into Sage 200
2. 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)
3. Move to the E-Banking tab.
4. Select Disable
5. The bank account status will change to Disabled.

 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. 

Reconnect your bank feed to virgin
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. 

1. 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)
2. Navigate to the E-Banking tab.
3. In the Sage Bank Feeds section, select Enable.
4. In the Bank Feeds, select your Country
5. Click Other banks, then enter Virgin and select the relevant option
6. 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! 

Next steps

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 feed rules, using the details you captured earlier. 

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 not flagged by the bank feeds rules, from within your Bank Feeds transaction screen, select the transaction(s) and then you can flag the duplicated as ignored. 

For transactions flagged by bank feeds rules, when you click to download transactions a Bank Feeds Approval screen may pop up, where you can select to Approve or Reject as required. 

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