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

Note - information

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.

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

  2. Move to the E-Banking tab.

  3. In the Sage Bank Feeds section, select Enable.

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

  1. Open Roles.
  2. Right-click the role name and choose Features.

  3. To allow a user to enable Sage bank feeds, ensure that they have access to:

    Cash Book > Advanced > Amend Bank Account Details

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

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.

Note - information

Bank feeds rules are not migrated and will need to be set up again for your bank feeds in Sage 200.