Sage 200 - How to set up and use e-Banking
Description

This guide includes:

Compatible banking software
To enable e-Banking
Enabling supplier online payments
Creating a payment file for your banking software

Note: The options available are dependant upon the component chosen for your relevant banking software.

For a list of supported banks and their components, please click here

Cause
Resolution
Compatible banking software
A full list of supported banks can be found in our guide. Read more

To enable e-Banking

Click on Tools then Installers, and Install eBanking components. This will prepare the application so that the e-banking components can be used.
When the installation has completed, restart the Sage 200 application.
This only applies to Sage 200 Professional.

Go to your Bank Account List, highlight the Cash Book account that the payments will be made from and click Amend Account, then in here, click the E-Banking tab.

Select the correct name of the banking service in use from the E-Banking service drop-down list.
If the component for your banking software is not listed, please refer to our guide on how to download and install individual banking components.
Depending on the banking component chosen, you can choose to process Payments only, Bank Reconciliation only, or both. For some components, only one of these options may be available. For more information regarding File Locations... button, please refer to the next section.

Enabling supplier online payments

To enable Sage 200 to create payment files for your suppliers, you must complete the following:

  • Purchase Ledger > Utilities > Ledger Set Up > Ledger Settings > Options tab > select 'Electronic Bank Payments'. This enables the functionality.
  • Select the Payment Groups tab also in Ledger Settings. You will need to set up one or more payment groups that supports electronic payment.
  • Enable E-Banking in the Cash Book, by setting up the Cash Book account you intend to use for electronic banking. Select Cash Book > Amend Account Details > E-Banking tab > File Locations.

    When using e-Payments, a file is created for import into your banking software. This file can be:

    • Stored in the default directory, C:\ - The e-Payment, and e-Reconciliation files are stored here by default. If you wish for the files to be stored here, then no further action is required.
    • Stored in a common directory - You can store the files in the same, common directory. By default this is set to C:\, but can be changed to an alternative destination folder via the browse option in the Configuration window.
    • Stored in a directory separate to the e-Reconciliation files - If you prefer to keep the e-Payment files separate from your e-Reconciliation files, you can use the Override Common Directory option from the Configuration window. By selecting this check box, you enable the Statement Reconciliation Services and the Payment File Options areas. Both of these areas contain Directory fields, displaying the folder where the import or export files are located.

      Note: The information required to configure the e-Banking option depends on the bank type you choose from the drop-down list. Some of the following options may not be available due to the banking software selected.


    SettingExplanation
    Common directoryDisplays the directory where the electronic payment and statement files are held. C:\ appears by default. To amend this, enter the path to the data or use the Browse option to locate the directory.
    Override common directoryTo use the common directory for e-Payments and e-Reconcile, select the check box. If this option is selected the Statement Reconciliation Service and Payment file options directories must be completed.
    Statement Reconciliation ServiceDisplays the directory where the statement files from your banking software are held, before importing into E-Reconciliation. C:\ automatically appears. To amend this enter the path to the data or use the Browse option to locate the directory. The file extension can also be entered, this ensures only files with that extension appear on the Import window.
    Payment file optionsDisplays the directory, file name and extension of the file that is used by the e-Payments option for your on-line Banking software. To amend this enter the path to the data or use the Browse option to locate the directory. The default file name consists of the File Identifier, today's day and month and the file extension. If a File Identifier is not entered the file name is the complete date including year, for example 01092013.

Creating a payment file for your banking software

To create a payment file, select Purchase Ledger > Period End Routines > Payment Processing > Generate Payments. This will create a payment file including payments for accounts set to use a Payment Group for e-Banking.

When completing the criteria and selecting OK, you will be presented with the Payment Confirmation screen. You can also select the Show Details to show details of all payments included in the file:

When pressing OK, the next screen is presented, allowing you to enter any additional details required for your payment file. The exact screen will vary according to the particular banking service.

paymentoptions

Note: These details are provided by the bank or the users own preference where necessary.

The Save As screen is presented next. The save location will default to either the Common directory specified earlier or, if the 'Override common directory' setting is enabled in the Cash Book, the directory for 'Payment file options' will be used instead.

saveas


[BCB:19:UK - Sales message :ECB]
Steps to duplicate
Related Solutions