Sage 200 Professional - What steps must I take to migrate from Yorkshire/Clydesdale bank feed to Virgin?

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

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

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.

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:

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