Set up Sage bank feeds
Sage bank feeds is a secure service that you can use to download your bank transactions to Sage 200, to help you reconcile your bank account.
This reduces the time that you spend reconciling your bank transactions, and ensures your accounts are up to date and accurate.
Sage bank feeds is a completely free service - you don't need a subscription, and there are no fees.
How it works
Sage bank feeds connects to your bank and downloads details of the transactions from your bank account into Sage 200.
Once downloaded, you can match them to the existing transactions in Sage 200, or create new transactions in Sage 200 if something is missing. This means that transactions in your live bank account are reflected in Sage 200. Sage 200 will remember which transactions you have matched, ready for your next bank reconciliation.
Changes for Open Banking
Open Banking (PSD2) is a secure way for you to share financial information from your bank with companies like Sage that offer banking and payment apps and is designed to give you greater control over your financial data.
If your bank does not comply with this standard, you will not be able to use Sage bank feeds.
Supported banks
To check if your bank is supported, follow the steps to Enable Sage bank feeds.
If you find that your bank is not supported, you can request that your bank is added during this process.
Supported Sage 200 versions
Sage bank feeds is supported on these versions of Sage 200 Professional:
-
2020 R1, and all later versions.
-
Summer 2018 RM.
-
Summer 2017 RM.
Before you start
To complete the registration, you will need to know:
-
Your bank name, type of account, the account number and IBAN number.
-
A contact email address for your organisation, in case we need to contact you.
Enable Sage bank feeds
You can't set up Sage bank feeds for a cash book account if:
-
The cash book account already uses Supplier Payments (Sage Salary and Supplier Payments).
-
The cash book account is set up for reconciliation using e-Banking, with E-Banking functions set to either Bank reconciliation only or Both payments and bank reconciliation.
You can still use e-Banking to generate payments for suppliers, if E-Banking functions is set to Payments.
Open: Cash Book > Cash Book Accounts > Amend Bank Account Details.
-
Choose the cash book account that you want to set up for Sage bank feeds.
Note: To enable Sage bank feeds, you must have user access to amend the cash book account. See User access for Sage bank feeds.
-
Move to the E-Banking tab.
-
In the Sage Bank Feeds section, select Enable.
-
Follow the steps in the Sage Bank Feeds wizard. This is where you enter the details of your bank account.
-
You might be asked to enter your contact email address, if you have not used the service before.
-
Choose your country and your bank. If you can't see your bank, select Other Banks and search for your bank.
If you still can't find your bank after a search, select the Can't find your bank? to request that we add your bank.
-
Sign in to your bank. The steps are different for each bank, and you may need to enter your online banking credentials.
Note: Your bank account must be set up with permission to use bank feeds, otherwise you may not be able to sign in or connect to your bank. You should contact your bank if you are unsure how to set these permissions.
-
Choose the historical Start date when you want to start downloading transactions from, then select Process.
The transactions you can download may be restricted by your bank.
-
User access for Sage bank feeds
You may want to control user access for who can set up a bank account, and who can reconcile transactions.
Open: System Administration.
- Open Roles.
-
Right-click the role name and choose Features.
-
To allow a user to enable Sage bank feeds, ensure that they have access to:
Cash Book > Advanced > Amend Bank Account Details
-
To allow a user to download and reconcile transactions, ensure that they have access to:
Cash Book > Advanced > Amend Cash Book Account Details
Cash Book > Advanced > Bank Feeds Download Transactions
Cash Book > Advanced > Bank Feeds Reconciliation
Troubleshooting
This might be because:
-
You don't have user access to amend the cash book account. See User access for Sage bank feeds.
-
If you are creating a new bank account, you will not see these options until you first Save and Close the account. Once you have closed the account, open it again by amending the account, and you will now see the option to enable Sage bank feeds on the E-Banking tab.
If the Enable option is disabled, this might be because Supplier Payments is already enabled for this account. You can only use one of these services with a cash book bank account.
After sending your completed form to your bank, you may need to wait a few days for the bank to process your request.
Once your bank has authorised your request, the status will change from Pending to Active and you can start using Sage bank feeds to download transactions.
If bank feeds has stopped working, first check our Service Status (opens in a new tab) to see if there is a problem with the service.
If you can't you can't get bank feeds working again, you might need to refresh your signature key. This will reset the link between your Sage 200 company and the bank feeds Sage service. See Cash Book Settings.
If you want to change the email address that you used to enable bank feeds for this account, please contact our support team.
This email address is used if you need to refresh your signature key for bank feeds.
From Sage 200 Professional version 2024 R2 onwards, the bank feeds and Invoice Payments services will use the same contact email address.
You may experience problems setting up bank feeds if your firewall is blocking access our servers.
When you try to enable bank feeds, you may see this message:
-
"An unexpected error occurred setting up your account in Sage Bank Feeds. Please try again later."
To resolve this, we recommend that you set up your firewall to allow access to these URLs using HTTPS:
-
www.sagetokenservice.com (client and server)
-
eu.sagebankdrive.com (client and server)
When you set up bank feeds for particular banks, you will be asked to provide the sign in details for your bank account. These details will expire after a period of time, and you will be asked to Authenticate your account by entering your sign in details again.
To authenticate your bank account:
-
Choose the bank account which is enabled for bank feeds.
Open Cash Book > Cash Book Accounts > Amend Bank Account Details, or select the account from the Bank Account List.
-
Move to the E-Banking tab.
-
Select Authenticate.
Note: This is only available if your bank account requires authentication.
-
Enter the details required for your bank account.
After you authenticate your bank account, you may have to wait several hours before you download new transactions for this account.
Only disable bank feeds if you definitely want to stop using it with this cash book account. When you disable bank feeds, this will permanently cancel your bank feeds account linked to this cash book account. If you decide to use bank feeds again later, you will have to repeat the setup process.
-
Choose the bank account which is enabled for bank feeds.
Open Cash Book > Cash Book Accounts > Amend Bank Account Details, or select the account from the Bank Account List and click Amend Account.
-
Move to the E-Banking tab.
-
In the Sage Bank Feeds section, select Disable.
The bank account status will change to Disabled.
When you set up bank feeds, you contacted your bank and gave your consent to transfer your banking data to Sage. If you definitely want to stop using bank feeds with this bank account, you should contact your bank and instruct them that you no longer want to use this service.
Your bank feeds account will be cancelled automatically if it is inactive, and the bank or aggregator will be informed to stop sending data to Sage.
-
Bank feeds accounts which have been in a Pending state for 6 months will be automatically cancelled.
Your account would be Pending if transactions have not yet been received from the bank. This may happen if you do not complete the authorisation process with the bank, or your application was rejected by the bank.
-
Active bank feeds accounts with no new transactions for 12 months will be automatically cancelled.
This may happen if you:
-
Do not download transactions for 12 months.
-
Have cancelled your bank feed directly with the bank (without informing Sage).
-
Have cancelled your Sage subscription.
-
Note: You will not receive any notification if your account is cancelled due to inactivity, but it will be possible to reconnect your account again if required.
Migrate Sage bank feeds from Sage 50 Accounts
If you have previously used bank feeds in Sage 50 Accounts, you can continue to use bank feeds in Sage 200.
The migration process will depend on the versions of Sage 50 Accounts and Sage 200 that you are using.
Bank feeds rules are not migrated and will need to be set up again for your bank feeds in Sage 200.
-
You must disable Sage bank feeds in Sage 50 Accounts v30.1 before you migrate your data to Sage 200 using the migration tool.
-
Do not use the Migrate option in Sage 200 Cash Book Settings to migrate your account settings.
After you have migrated your Sage 50 Accounts data to Sage 200 using the migration tool, you will need to enable Sage bank feeds in Sage 200.
If you have already set up bank feeds in Sage 200, this will be replaced with the account details that you used for Sage 50 Accounts.
-
When you migrate bank feeds from Sage 50 Accounts:
-
You will download and save a migration key file (*.json).
-
You will choose a password for the migration key.
-
You will receive an email (sent to the account used to set up Bank Feeds), which will ask you to authorise the migration.
You must follow the instructions in the email to authorise the migration, before you can continue.
-
-
In Sage 200:
Open: Cash Book > Utilities > Cash Book Settings.
-
In the Migrate Sage Bank Feeds section, enter your migration key Password.
-
Select Migrate, and browse to the migration key file (*.json) that you created from Sage 50 Accounts.
-