Create or amend a bank account

Find this screen

Open: Cash Book > Create and Amend Accounts > Create Bank Account.

Open: Cash Book > Create and Amend Accounts > Amend Bank Account Details.

How to

Add a bank account

  1. Enter a Code for this bank account.

  2. Add a Description of the bank account, to help your colleagues identify it.
  3. Enter the bank account's basic details. This will include:
    • The Account number and Sort code for the account.

      Note: If you are creating a bank account to represent an account that is not an actual bank account, for example: petty cash or a credit card, enter 00-00-00 into the Sort Code field.

    • The Account name as detailed on the account.
    • The Account type.

      • You will usually select a Current or Deposit account.
      • If the account is to be used exclusively for Invoice Payments, use Sage Invoice Payments.
      • If you are using Supplier Payments, the type is fixed as a Supplier Payments account.
    • The Account currency in which it operates.
    • The Overdraft limit amount.
    • If you are making payments from this account using e-Banking, then you must enter the IBAN and BIC/Swift number.

  4. Choose the nominal accounts for posting this bank's transactions to the nominal ledger. These must be posting nominal accounts.

    1. Bank account: By default this shows the nominal account set up for bank accounts in Default Nominal Accounts screen.

      If you are using more than one bank account in Sage 200cloud, we advise you to create a separate nominal account for each bank account you set up in Sage 200cloud, and select it here.

    2. Bank charges: By default, this shows the nominal account set up for bank charges in Default Nominal Accounts screen.

      If you have more than one nominal account to record your bank charges, select the appropriate account here.

      If you use Invoice Payments, your payment provider's fees will be posted to this account.

    3. Exchange Differences: For foreign currency bank accounts, this shows the nominal account set up for exchange differences in Default Nominal Accounts screen.

      If you have more than one nominal account to record exchange differences, select the appropriate account here.

    Note: If no default nominal accounts have been defined, or you don't select nominal accounts for your bank account here, then Sage 200cloud will post the transactions to the Suspense account.

  5. Go to the Contacts tab to add the full name and address of the branch that holds the account. You can also add an email address for a contact at the bank who can assist with issues or questions that arise on the account.

Add a memo

Add attachments

Set up Sage bank feeds

If you want to use Sage bank feeds, you will need to enable this service for the bank account.

  1. Move to the E-Banking tab.
  2. In the Sage Bank Feeds section, select Enable.
  3. Follow the steps to set up Sage bank feeds.

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.

For more information, see Set up Sage bank feeds.

View bank feed rules

Click Bank Feed Rules to view or delete rules that have been set up for this bank account.

  • To view a rule, select the rule and click View.
  • You can choose whether you want to approve transactions that will be created by this rule before they are posted.
    • If you want to review transactions for a bank feeds rule, turn on Review before posting.
    • If you don't want to review transactions for a bank feeds rule, turn off Review before posting.
  • To delete a rule, select the rule and click Delete.

For more information, see Bank feeds rules.

Set up e-Banking

Note: If you are making payments from this account using e-Banking, then you must enter the IBAN and BIC/Swift number on the Account Details tab.

  1. Sign up to your bank's e-Banking service. Once you have done that and installed their tool you can configure Sage 200cloud.
  2. Install the Sage 200cloud e-Banking component. This sets up Sage 200cloud to send the required files to your bank.

    Open: Tools > Installers > Install eBanking components.

  3. Download and install the required plug-in for your bank from the Sage website: Sage e-Banking compatible banks.

  4. Go to the E-Banking tab for the bank account in Sage 200cloud.

    You can do this when you create a new bank account, or amend an existing one.

    Open: Cash Book > Bank account List > New Account | E-Banking.

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

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

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

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

Set up Supplier Payments

If you are going to use Supplier Payments, you will need to create or select a Cash Book account to use with Supplier Payments.

Open: Settings > Customers and Suppliers > Supplier Payments Setup.

  • If you don't already have a Cash Book account, click Add to create a new account.
    1. Enter the Account number and Sort code of your Supplier Payments account.
    2. The account will be given a default Account name of Sage Payments E-Account, which you can change.
    3. The Account currency will be set to Pounds Sterling and cannot be changed.
    4. Finish off creating the account record.
  • If you have already created a Cash Book account for Supplier Payments, select it from the list.

    The Account Type for this account will be set to Supplier Payments.

    Note: You cannot select a cash book account to use with Supplier Payments if it is currently set as your Default Bank Account. If you cannot select a cash book account for this reason, you can change your Default Bank Account by using Settings > Cash Book / Nominal Ledger > Cash Book Settings.

Set up Invoice Payments

Once you've connected with your payment provider, you'll need to set up a new bank account in Sage 200cloud for use with Invoice Payments.

The bank account will be used exclusively for Invoice Payments, and must have an Account type of Sage Invoice Payments. You can't use this bank account for Bank Feeds or E-Banking services.

  • If you will send invoices in multiple currencies, we strongly recommend that you set up an individual balance (or wallet) for each currency with your payment provider, and that you also set up a corresponding bank account for each currency in Sage 200cloud.
  • We recommend that you set the primary currency for your payment service provider to be the same as your base currency in Sage 200cloud.

See Set up Invoice Payments.

Hide or show a bank account

You might hide a bank account when you're no longer using the account, or have created a new account that you don't want to be used yet.

This removes the bank account from lists and helps prevent the account being selected by mistake.

  • To hide the bank account, set the Active Status to Hidden.
  • To show a hidden bank account, set the Active Status to Active.

    Note: To edit the account, use Cash Book > Create & Amend Accounts > Amend Bank Account Details.

See About hiding bank accounts.


Useful info

Creating bank accounts

You can set up a bank account to represent any type of account you pay into and make payments from. For example you could set up bank accounts within Sage 200cloud to represent:

  • Actual bank accounts
  • Credit cards
  • Petty cash.

As you set up a bank account in Sage you must provide information in the Sort Code field. For some of the accounts you are setting up there will be no sort code, for example, petty cash accounts and credit cards. When this is the case simply add the sort code 00-00-00.

About bank feeds

Use the bank feeds service to download your bank transactions to Sage 200cloud, 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.

About e-Banking

With e-Banking you can:

  • Perform automatic statement reconciliation.
  • Pay your suppliers electronically.

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

  • Pay your VAT Return electronically.

Maintaining bank account details

Once a bank account has been set up you must perform all further maintenance on the Amend bank account screen.

There are a couple of amendments you are not allowed to perform to an existing bank account and circumstances when Sage 200cloud will not allow you to delete a bank account's details.

What you can't change on an existing bank account
  • The identifying code given to the bank account once its details have been saved.
  • If transactions have been posted to the bank account you will not be able to change the bank account's currency.
When you can't delete a bank account

You cannot delete a bank account's details if the bank account:

  • Has had a transaction posted against it.
  • Is currently linked to Merchant services.
  • Is being used to make your online VAT payments.

Setting a default bank account

The first base currency bank account created is automatically assigned as the default bank account. As you create more bank accounts, select the account you want to use as default, using the cash book settings.

Go to:

Settings > Cash Book / Nominal Ledger > Cash Book Settings

  1. Click Edit.
  2. Select the bank account you want to set as the default.
  3. Click OK.

About hiding bank accounts

You might hide a bank account when you're no longer using the account, or have created a new account that you don't want to be used yet.

This removes the bank account from lists and helps prevent the account being selected by mistake.

You can check which bank accounts are hidden and who changed their status, by using the Accounts not Active report.


Fix it

There are no nominal accounts to link to

  • Nominals must be set up before you come here.
  • To set these up go to: Nominal > Create & Amend Accounts > Create Nominal Accounts.

The currency in which the bank account operates was missing from the list

  • Currencies must be set up before you can select them here.
  • To set these up go to: Settings > Organisational and Financial > Currencies & Exchange Rates.

My bank e-Banking service is not displayed in the list

You must have installed the Sage e-Banking Service component first

Open: Tools > Installers > Install eBanking components.


What happens when I

Save the details of a bank account?

When you save its details your bank account becomes available for use on the system.

Remember that once you have saved a bank account's details you cannot add to, or amend its details on the Create bank account screen. If you want to add or change anything you'll have to go to the Amend bank details screen.