Migrating Bank Feeds in Sage 200 and Sage 50 – The Steps
Sage wrote to users in June to let them know that they were making changes to how some customers access their banking data from across our product range. Sage are encouraging customers to do the migration as soon as possible. All of the feeds outlined will be disabled by 30 November 2023, HSBC accounts will be disabled no later than 4th November.
Customers were asked to complete a short migration exercise, ahead of switch off dates, to connect to our new style feeds (where available) for the following banks:
- HSBC (personal, business and net accounts)
- Lloyds/Bank of Scotland (business, personal and commercial acocunts)
- Natwest/RBS
- Cashplus
In a very small number of cases, due to the nature of the account that is held with the bank, customers will lose access to their banks. This primarily applies to some HSBC CIIorM, DBB Loan & Mortgages, HSBCnet Loan Mortgage & Savings Accounts.
Below are the steps for how you can migrate from one bank feed provider to another in both Sage 200 and Sage 50.
Migrate from one bank feed provider to another in 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.
Migrate from one bank feed provider to another in Sage 50
The following steps are for version 29.0 or below.
Make a note of your bank feed rules
Before you disconnect your bank feed, we recommend you make notes of any bank rules you have set up as you need to set up these again after you reconnect.
To check your rules:
- In Sage 50 Accounts, click Bank Accounts
- Select the bank account you require, then click Bank Feeds
- Click Manage Rules, then select the rule you want to view
- Click Edit and note down the information
Disconnect your current bank feed
- Click Bank accounts.
- Double-click the required bank account.
- Under the Sage Bank Feeds section of the Account Details tab, click Disable Sage Bank Feeds. Tip: Don’t worry if you see an option to reconnect, you have still disconnected the bank feed.
- Click Save.
Note: If you are using an HSBC Bank Feed, you need to disconnect the feed in HSBC, for more information see these instructions.
Reconnect your bank feed
- Click Bank accounts, click the bank record you want to connect to your bank, then click Bank feeds.
- In the Bank Feeds window, select your Country, then in the list of popular banks, click your bank.
- Click Next, click Sign in then follow the on-screen instructions to connect to your bank. These steps are unique to your bank and may include entering your online banking credentials.
- Next, in Start date select the historical date from which you want to start downloading transactions, then click Process. Note: The date must be in the last 90 days and may need to be later depending on your bank.
- A window appears either confirming the connection, or providing any further authorisation steps required by your bank.
- To complete the setup, click Finish.
You’ve now set up your Bank feed connection!
Set up your bank feeds rules
Once the account has been connected, you can set up the rules again to automatically process transactions based on criteria you define.
Your first bank reconciliation after migrating your feed
When you open bank feeds, if you’ve previously cleared transactions and they 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 transactions that do not need Bank Feeds Rules created, simply match the transactions as normal.