How to set up e-Banking

Install e-Banking

The Sage e-Banking component and the component for your bank's e-Banking service must be installed.

You need to install the required components on all PCs that will be using the service.

Install the Sage e-Banking component

To install the component from the Sage 200 desktop:

1. Select Tools > Installers > Install eBanking components.
2. Click Install.

Note: Alternatively, you can install the e-Banking component from the installers folder on your server, by running C:\Sage\Installers\Sage 200 EBanking\Setup.exe.

Install the e-Banking service for your bank

1. Visit this page to check which banks are compatible with e-Banking:

   Sage e-Banking compatible banks (opens in a new tab).

2. Find your bank and the e-Banking service you use. Click Download plug-in.
3. You'll need to close and re-open the Sage 200 desktop app to see your e-Banking Service in the list.

Set up bank accounts to use e-Banking

Open: Cash Book > Bank Account List > New Account

Open: Cash Book > Bank Account List > Amend Account

1. Move to the Online Banking tab (previously E-Banking) for the bank account.

2. Select the E-Banking service you will be using.

   Note: You will only see your bank listed here if you have downloaded and installed the plug-in for your bank.

   

3. Choose the tasks you will be using with e-Banking from the E-Banking functions list.

   • Payments if you want to pay your suppliers via e-Banking.

   • Bank reconciliation only.

   • Both payments and bank reconciliation if you want to make the most of it and do both.

   Note: Not all banks support all functions. If you can't see a function in the list, it's not supported by your bank.

4. Files for e-Banking are saved to your user Documents folder by default. To change this, click File Locations.

   Set e-Banking file locations

   1. Click File Locations.

   2. To choose the folder for your e-Banking files, select your Common directory.

   3. To specify separate locations for statement reconciliation (that come from your bank) and payment files (that you will send to your bank), select Override Common Directory.

   4. In the Statement Reconciliation Service section, click Browse to select the folder where Sage 200 will look for statement files for reconciliation.

      If your incoming bank statement files will have a specific file extension, enter it in the File extension field.

   5. In the Payment file options section, click Browse to select the folder where Sage 200 will save the payment files for you to send to your bank.

      Output payment files are named according to the date they are produced. You can add a prefix to the file name by entering a File identifier field. You can add a file extension in the File extension field. The example field shows what the file name will look like.

Set up supplier accounts to use e-Banking

If you want to pay your suppliers via e -banking, each supplier account must belong to a payment group that uses an Electronic payment method, and your must use the Generate payments feature to pay your suppliers.

You can create a single payment group for all suppliers that you pay via e-Banking or you can use separate groups. You might want separate groups if you do your payment runs at different times, or want to use a mixture of printed or emailed remittances.

Note: You cannot pay foreign suppliers through e-Banking.

Open: Purchase Ledger > Purchase Accounts > Amend Account Details

1. Select the supplier.

2. Move to the Payment tab.

3. Choose a Payment group that uses an Electronic payment method, either:

   • Electronic Payment
   • Electronic Payment Remittance (Paper)
   • Electronic Payment Remittance (Email)

Tip: You can change the labels for the payment groups to make them more meaningful for your business in the Supplier settings.

Set up your VAT return to pay HMRC via e-Banking (UK only)

Open: Nominal Ledger > Utilities > Ledger Set Up > Nominal Ledger Settings | VAT submissions

1. Select Enable online VAT payments (UK only).

   The bank details for the HMRC are entered automatically. Do not change these unless you have received notification from HMRC.

2. Select the bank account to pay the VAT from. The VAT payment defaults to this bank account.
3. Choose a nominal account to post the VAT payment to.