Set up e-Banking or bank feeds (CB account)

Find this screen

Open: Cash Book > Cash Book Accounts > Amend Bank Account Details | E-Banking

Open: Cash Book > Bank Account List > Amend Account | E-Banking

 

Use the E-Banking tab to set up the bank account with either:

  • The Sage bank feeds service.
  • The Sage e-Banking service.

Bank feeds

You can use the Sage bank feeds service to:

  • Download transactions from an online bank account.
  • Automatically create transactions in Sage 200c for your bank transactions that you download, by using bank feeds rules (Sage bank feeds only).
  • Reconcile your downloaded bank transactions with those in Sage 200c.

This reduces the time that you spend entering transactions, simplifies your bank reconciliation and ensures your accounts are up to date and accurate.

Set up Sage Bank Feeds

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.

  2. Move to the E-Banking tab.
  3. In the Sage Bank Feeds section, select Enable.

    Note: You can't set up Sage bank feeds for a cash book account that has uses Supplier Payments.

  4. Follow the steps to in the Sage Bank Feeds wizard. This is where you enter the details of your bank account.

  5. When you've finished, you will need to download a form to print and complete. This authorises Sage Bank feeds to connect with your bank account. You can either:

    • Post the form to the address listed in the form, which may be to your bank or Sage.
    • Fax the form to the number provided in the form, which is a secure electronic fax mailbox.

    Tip: If you forget where you saved the form, the PDF file is saved in the Attachments tab for this cash book account.

  6. Wait a few days for your bank to receive and process your request, then come back to check the status of your bank account.

    Once your bank has authorised your application, the status will change from Pending to Active and you can start using Sage bank feeds to download transactions.

Set up Sage Bank Feeds Rules

This feature is only available from Sage 200c Professional Winter 2017 version onwards.

Bank feeds rules help make data entry and bank reconciliation even easier.

When you reconcile your bank transactions, if the downloaded bank transaction is missing from Sage 200c, you have to create these transactions in Sage 200c.

You can use bank feeds rules to automatically create transactions in Sage 200c for your bank transactions that you download from Sage bank feeds. This saves you time entering transactions, and helps you reconcile your bank accounts more efficiently and reduce errors.

Bank feeds rules look for certain details in the downloaded bank transaction, and then create the matching transaction in Sage 200c. For example, if you make regular payments to a particular supplier, you could set up a rule to that matches that supplier's name as it appears in your bank transactions, and then create a corresponding payment to that supplier account in Sage 200c.

When you download bank transactions from Sage bank feeds, your bank feeds rules check all the bank transactions, and then create any corresponding transactions in Sage 200c.

Bank feeds rules can be set up to create customer receipts and payments, supplier payments and receipts, and nominal transactions.

e-Banking

E-banking is a service provided by your bank. If you subscribe to your bank's e-banking service, you can use this with Sage 200c to reconcile your bank account, pay your suppliers and pay VAT to HMRC.

Before you start

You must subscribe to the e-Banking service for your bank and this must also be compatible with Sage e-Banking.

The Sage e-Banking component and the component for your bank's e-Banking service must be installed with Sage 200c desktop app. See How to set up e-Banking.

Set up this bank account to use e-Banking

Open: Cash Book > Cash Book Accounts > Amend Bank Account Details | E-Banking

Open: Cash Book > Bank Account List > Amend Account | E-Banking

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

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

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