Migrate from one bank feed provider to another
Summary
Description
The steps below are specific to staying with your current provider, but moving to a newer type of feed.
We wrote to customers recently to let them know that they need to migrate to a newer feed prior to their current connection being discontinued before:
- 4 November 2023 for HSBC
- 30 November 2023 for the other banks
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
CAUTION: If your company didn't receive an email communication, these steps don't apply to you.
Resolution
Disconnect and reconnect your bank feed
To migrate your bank feed you need to disconnect your current feed and reconnect. Select your version to see the steps.
TIP: To check your version open Sage 50 Accounts and click Help then About.
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
To set up your Sage Bank Feed again, follow the steps in our Set up bank feeds guide.
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.
To find out more about how to do this, read Create and manage automated Bank feeds transactions.
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. See the Set up your bank feeds rules section above for more information.
For transactions that do not need Bank Feeds Rules created, simply match the transactions as normal. Find out more about Using Bank feeds here.
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 feeds.
- Next to the required bank account click Open.
- 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 feeds.
- Next to the required bank account click the settings cog.
- Click Disconnect Bank feeds and click Yes.
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
To set up your Sage Bank Feed again, follow the steps in our Set up bank feeds guide.
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.
To find out more about how to do this, read Create bank rules in v29.2 and above.
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. See the Set up your bank feeds rules section above for more information.
For transactions that do not need Bank Feeds Rules created, simply match the transactions as normal. Find out more about Using Bank feeds here.
Need something else?
Visit the Help Centre to find more guides and information about Bank Feeds.
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
Solution Properties
- Solution ID
- 230608131822823
- Last Modified Date
- Tue Jan 16 11:44:52 UTC 2024
- Views
- 0