Skip to content
logo Knowledgebase

Set up e-Banking

Created on  | Last modified on 

Summary

How to set up the e-Banking feature in Sage 50 Payroll.

Description

You can use e-Banking to create a payment file for your employees. You then upload this file to your compatible banking software, and the bank arranges the payments.

 NOTE: The e-Banking function doesn't support non UK banks that use IBAN and BIC numbers. If you need to pay these accounts, you must do this outside of Sage 50 Payroll.

Resolution

Download and install the e-Banking component

To get started, you must install the e-Banking component for your bank. Your software uses the component to format e-Banking files correctly for your bank.

  1. Go to our list of compatible banks at sage.co.uk/ebanking.
  2. Locate your bank from the list.
  3. Click Download plug-in to download the installer for this plug-in to your computer.
  4. Open your Downloads folder and locate the file you downloaded.
  5. Right-click this file, and click Run as administrator.
  6. Follow the on-screen prompts to complete the installation.

You've now installed the component that your software needs to export a payment file.

To complete your setup, continue to enter your bank details and configure e-Banking below.


Enter your bank details and configure e-Banking

Before you can generate any payment files, you need to configure e-Banking.

  1. On the navigation bar click Company, then click Settings.
  2. Click the Bank tab and enter your company's bank account details.
  3. Select the Enable e-Banking check box.
  4. On the Component list, click the required bank software.
  5. Click Config and complete the following options: 
    Common directory This displays the folder where your software creates the payment file by default. To amend this, enter your preferred path or click Browse, and browse to the required folder.

    If you specify a folder here, Sage 50 Payroll defaults to this location during the e-Banking process. Where required though, you can still save the file to a different location while you export it.

    File identifier Use this option to set part of the payment file name. You can enter a maximum of four characters and any letters are upper case. You can also change the file name during the e-Banking process if required.

    If you don't enter a File identifier, the file name generates using your computer system date. For example if your system date is 15 July 2017, the file name is 15072017.

    File extension

    The file extension that you need to use depends on your banks' requirements. Enter the file extension that your bank requires here. This is normally either TXT or CSV.

    Sage 50 Payroll defaults to this file extension at the end of the e-Banking process, although you can still change it if required. If you're unsure which type of file you need, follow our file formats for Sage 50 Payroll e-Banking files article. For any further support on file types, contact your bank.

    Example This shows an example of the payment file name which consists of the File identifier, your computer system date and the File extension.
  6. Click OK, then OK.

Next steps

You've now set up the e-Banking feature in your software. If you haven't already done it, set up your employees for e-Banking. Once that's done too, you're ready to create your e-Banking file to import into your banking software.