Register Bank Account

This document explains how you register different types of bank accounts for the company and its divisions, employees, suppliers, and customers.

Outcome

  • All bank accounts with which the company directly or indirectly works are registered.
  • Each bank account record contains detailed information about the account and the accounting string to use when transactions are posted to this account. When applicable, conditions for how drafts are remitted to this account are also defined.
  • Division-specific variants (where the difference usually consists of another bank account indicator only) are also registered for supplier accounts, when needed.

Use the registered information to control which bank accounts to use for managing customer payments, supplier payments and payroll, for example.

A division-specific account for a specific supplier always has precedence over a general account for the same supplier. This means that it is automatically proposed when you process EDI payments and manual bank transfer: 'Supplier Invoice. Record' (APS100), 'Supplier Invoice Batch. Open' (APS450), 'Payment Proposal. Open' (APS130), 'Supplier Payment. Enter Manual' (APS120), and 'Accounts Payable. Change Separate Invoice' (APS201).

The bank account table, CBANAC, is updated.

Before you start

  • Languages must be defined in 'Language. Open' (CRS010).
  • Currencies must be defined in 'Currency. Open' (CRS055).
  • The company's chart of account must be defined in 'Accounting Identity. Open' (CRS630).
  • If you want to specify a banking region to further identify the bank and you do not group the bank per area or state, such a region must be defined in 'Banking Region. Open' (CRS843).
  • A set of up to five user-defined fields must be defined in 'Bank Account Indicator. Open' (CRS072).
  • For bank accounts that are the company's own account, a bank must be defined in 'Bank. Open' (CRS690).
  • If you want to connect additional fields with values to the bank account, the fields must be created first in 'Bank Account Field. Create Additional' (CRS083). For each field you define a name, the length of the field and whether it is numeric or alphanumeric. You might need such additional fields when creating a bank file, for example.
  • You have defined access to banks and bank accounts at field or function level separately in the following programs: 'Field Group. Open' (SES100), 'Field Group. Connect Authority' (SES010) and 'Function. Connect Authority' (SES003).

Follow These Steps

Define Basic Values

  1. Start 'Bank Account. Open' (CRS692/B).

    If you are a central user, all accounts are displayed. If you are a local user, these accounts are displayed:

    Account types 1 = 'Company's account', 4 = 'Customer account' and 5 = 'Other account holder': All accounts in your own division and at the central level

    Account types 2 = 'Customer account' and 3 = 'Supplier account': All accounts, regardless of division.

  2. If your company is a multiple unit company and you want only one division displayed at a time, press F3 to open the P panel and select the 'Display one division' check box. Press Enter.

  3. On the B panel, select sorting order 1 or 5.

    Sorting orders 2–4 are used for sorting and reviewing purposes only.

  4. Enter the bank account type, account holder (cannot be entered for account type 1), division (depending on the account type), account ID, and bank account indicator. Click Create.

  5. On the E panel, enter the required values based on the descriptions in the Parameters to Set table. Press Enter.

Define Division-Specific Variants of Supplier Bank Account (Optional)

  1. In (CRS692/B), select option 12 = 'Bank per div' for a bank account of type 3.

  2. In (CRS692/G), enter the division and bank account indicator (required values). Press Enter.

    The E panel is displayed containing all values proposed from the original bank account record: Priority, status, bank account name, indicator fields, bank number, branch ID and banking region.

  3. On the E and F panels, review and adjust any of the proposed values, when needed. Press Enter to return to the B panel.

    In (CRS692/B), the division-specific variant is displayed together with the original record.

Connect Additional Fields for Bank Account

  1. On the E panel, enter a value. Press Enter and repeat the procedure for each additional field.

  2. If you need to store additional information and the standard fields in (CRS692) are not sufficient, select option 11 = 'Value/Account' for the bank account in (CRS692/B).

    You can need such additional fields, for example, when national regulations require additional information to be included in a bank file.

  3. In 'Bank Account. Connect Additional Field' (CRS693/B), press F4 in the 'Bank account field' field and select the field to connect. Click Create.

Parameters to Set

Bank Account

Program ID/Panel

Field

The field indicates …

(CRS692/B)

Bank account type

… the category to which the bank account belongs. Required.

Alternatives

01 = Company's bank account

02 = Customer's bank account

03 = Supplier's bank account

04 = Employee's bank account

05 = Other account holders.

(CRS692/B)

Account holder

… the ID of the person to whom the account belongs. The ID can be a supplier number, customer number, employee number, or other account holder number. Depending on the bank account type, a list of valid IDs is displayed by pressing F4 in this field. If the account is the company's own bank account, that is of type 01, an account holder cannot be entered. Otherwise this is a required value.

(CRS692/B)

Division

… the division for which the bank account is valid.

Account Types and Divisions

01 = Division is required information.

02 = Division is not used (company level).

03 = Division is not used (company level). However, variants of a supplier account with different indicators can be defined for each division.

04 = Division is required.

05 = Division is required.

(CRS692/B)

Bank account ID

… a user-defined five-position numeric or alphanumeric ID for an account. Required.

(CRS692/B)

Indicator

… a set of user-defined fields. Required. By defining the names of up to five fields in the desired language in (CRS072), you can tailor which information to register for an account based on local or legal requirements. The fields are displayed on the E panel.

(CRS692/E)

Bank priority

… the priority of the bank account, from 01 to 99. Required. The priority is then displayed in (CRS192/B) and used to identify which account to select when the supplier etc. has several accounts.

Example

You enter a supplier invoice in 'Supplier Invoice. Record' (APS100) that should be paid by bank transfer. On the F panel, the bank with the highest priority for the supplier in (CRS692) is then automatically proposed.

(CRS692/E)

Status

… the status of the bank account. Required.

Alternatives

10 = Preliminary

20 = Definite

30 = Blocked/expired.

(CRS692/E)

Bank account name

… a description of the account, which will be displayed in (CRS692/B). Required.

(CRS692/E)

Bank number

… the ID of a bank registered in 'Bank. Open' (CRS690). This is required information only if the account is the company's own account.

(CRS692/E)

Bank branch ID

… the ID of a branch registered in 'Bank Branch. Open' (CRS691). Optional.

(CRS692/E)

Banking region

… the ID of the region in which the bank/bank account is situated. Optional.

Banking regions, officially defined, are used in France and Spain, but somewhat differently. Originally they were established when representatives from banks all over the country had to meet in person to physically exchange and cash payment documents.

France – Check Handling

The banking regions are used to calculate the value date, that is, the date when the money is available in the company's account.

Example: If I remit a customer check to the company bank in Paris and the customer's bank is in the same banking region, the value date is today's date plus two bank days. However, if the customer's bank is in Lyon, the value date is today's date plus seven bank days.

These value dates automatically update the company's cash flow planning.

Spain – Draft Handling

The fee charged by the company's bank for discounting or collecting a draft varies in Spain, depending on where the customer's bank is located. If it is in the same banking region, the fee is lower.

When to Use

To simplify the company bank's handling of the payment documents, you can select to use banking regions when creating a remittance proposal in 'Bank Remittance. Open' (ARS300).

Alternatives:

0 = No

1 = Yes, and print in banking region order. One remittance statement will be printed per banking region.

2 = Yes, and only within the company's own banking region.

3 = Yes, and only outside the company's own banking region.

(CRS692/E)

User-defined fields 1–5

… the fields defined for the indicator you selected on the B panel. Required. The information entered in these fields is also printed when you create a payment proposal in 'Supplier Payment Proposal. Open' (APS130).

If the indicator is to be used for creating a German DTAZV file for foreign payments, the fifth field can be reserved for the bank account to which fees are debited by the bank. Optional.

(CRS692/E)

Bank fee payment

... who is required the transfer fees, that is, the bank fees for remitting or transferring payments to foreign suppliers electronically.

Alternatives

00=Bank fees are shared (SHA). The remitter pays the fees that cover the costs of the remitter's bank. The payment beneficiary pays the fees charged by the beneficiary's bank.

01=Remitting party pays all fees (OUR). The remitter pays the fees covering the costs of both the remitter's bank and the beneficiary's bank.

02=Beneficiary is charged all fees, including those of the remitter's bank.

(SHA=Shared. OUR=Our party pays. BEN=Beneficiary pays.)

Usage in Germany

This field is displayed if check digit method 08 is selected for the bank account indicator connected to the bank account. The value is used in the electronic DTAZV file for foreign payments (German market modification).

The bank account and the bank account for the bank fees can be different ones than the bank account used to carry out the payment to the supplier. If the bank fee account and the payment account are not the same, the ID of the bank fee bank account must be entered in company-defined field 5 in (CRS692).

Usage in Sweden

This field is displayed if check digit method 35 or 37 is selected for the bank account indicator connected to the bank account. The value is used in the electronic SE-BGU and SE-PGU files for foreign payments (Swedish market modification).

Usage in Switzerland

This field is displayed if country code CH is entered for the bank account indicator connected to the bank account. The value is used in transaction types TA830 (optional), TA832 (optional) and TA836 (mandatory) in the electronic CH-DTA file for foreign payments (Swiss market modification)

(CRS692/E)

Bank fee payment

... the transfer type, which shows how a foreign supplier payment is transferred.

Alternatives

00=Normal payment transfer.

10=Express payment: payment transfer with high priority.

11=Quick payment in euros (German: EUE=Eilzahlung in Euro)

13=EU/EEA payment: Foreign payments to another state in the European Economic Area (EEA, comprising the EU countries, Norway, Iceland, and Liechtenstein) in euros or in another currency of an EEA state.

20=Check payment (only valid for Germany).

Comment on Transfer Type 13

This transfer type is used for payments lower than EUR 50,000, together with the IBAN number and SWIFT (BIC) code of the beneficiary. It is used to verify that a) an IBAN number is entered for the supplier bank account in (CRS692), b) a SWIFT code is entered for the bank of the supplier's bank account in (CRS690), and c) that value 00 (transfer fees are shared) is selected in the 'Bank fee payment' field in (CRS692). EU/EEA payments are always transferred as normal payment (transfer type 00) by the M3 e-Collaborator.

Usage in Germany

The field is displayed for the bank account in (CRS692) when check digit method 08 is selected for the bank account indicator in (CRS072). Note that if the transfer amount exceeds EUR 50,000, M3 e-Collaborator automatically replaces this transfer type with transfer type 00. The value is used in the T22 field in the electronic DTAZV file for foreign payments (German market modification).

Usage in Sweden

The field is displayed for the bank account when check digit method 35 or 37 is selected for the bank account indicator. Only values 00, 10 and 13 are valid. The transfer type is used in the electronic SE-BGU and SE-PGU files for foreign payments (Swedish market modification).

For the Company's Bank Accounts Only

Program ID/Panel

Field

The field indicates …

(CRS692/E)

Bank accounting string

… the company's accounting string to be reserved for posting transactions on the bank account (required).

(CRS692/E)

Currency

… the currency for which the bank account is reserved (required). The currency is used as selection criteria in the following cases:

  • When supplier payments are automatically identified and allocated to specific bank accounts when you create a payment proposal in 'Payment Proposal. Open' (APS130). This is defined in 'Bank Account Connection. Open' (APS090).
  • When bank quotas are applied to allocate certain payments to specific bank accounts, as defined in 'Bank Quota. Open' (APS030).

Definitions for Remittance of Customer Payment Documents

Program ID/Panel

Field

The field indicates …

(CRS692/E)

Remittance method

… the type of remittance of customer checks/drafts for which the bank account is reserved. Optional. If a value is entered in this field, it overrides the remittance method selected for the payment type in 'Payment Type. Open' (CRS072).

You are able to define the method here because you need a permit from your bank to discount drafts. If the bank is not willing to discount drafts, you can reserve the account for redeeming drafts on the due date instead.

Alternatives – Checks

0 = Not used for bank remittance

1 = For checks manually cashed.

Alternatives – Drafts

1 = For drafts remitted for collection on the due date

2 = For drafts remitted for discount before the due date

3 = For drafts remitted both for collection and discount.

(CRS692/E)

Number of days

… the standard number of days from having remitted a draft to the bank until the customer risk can be automatically canceled in 'Customer Risk Cancellation. Create' (ARS330). Optional. If you enter a value in this field, it overrides the corresponding value for risk cancellation in 'Customer Group. Open' (CRS145/E).

You are able to define this number here because you might want to extend the number of days, depending on where the bank is located or the regularity of the mail services.

Example

A French company uses a bank in the Antilles that is located overseas. The distance can cause a delay when mail is sent stating that certain drafts were rejected. The number of days entered for the customer group is in this case eight days. For this particular bank account, however, the company decides to add a couple of days until the risk is canceled.

(CRS692/E)

Maximum discountable amount

… the maximum amount allowed for discounted drafts for which the customer risk has not been canceled using this bank account. Optional. This amount is usually negotiated with the bank every year. In reality it functions as a kind of credit limit, since discounting a draft means that the company obtains a loan from the bank. The draft is used as security, but until the payment is actually made there is a risk that it will be rejected.

When you create a bank remittance proposal in 'Bank Remittance. Open' (ARS300) for this bank account, an automated check is made to verify that the total of the discountable drafts to remit and the already discounted, not overdue amount in (CRS692/F) is lower than the maximum discountable amount specified in this field. If the totals are higher than the maximum amounts, the drafts are included in the error report (ARS306PF).

Example

The maximum amount is 1,000,000. You have already discounted drafts to a value of 900,000 and want to discount another draft of 200,000. However, this draft will be included in an error report when creating the bank remittance proposal in 'Bank Remittance. Open' (ARS300). This means that you will have to wait until the risk is canceled for any of the previous drafts (minimum amount to be canceled: 100,000) before you can remit the draft to that specific bank account.

(CRS692/E)

Fixed bank fee for discounting draft

… the fee that the bank charges for discounting a draft before its due date. Optional. If you specify that charges should be calculated when a remittance proposal is created in 'Bank Remittance. Open' (ARS300), the values entered here and in the 'Fixed collection charge' field are used for the calculation. The estimated charges are then printed on the proposal for information purposes. However, no transactions are created.

The fixed discount charge can also be defined for the bank in 'Bank. Open' (CRS690/F). It is then proposed here but can be changed.

(CRS692/E)

Maximum collection amount

… the maximum amount allowed for redeeming a draft on the due date using this bank account. Optional. Compare the explanation for the 'Maximum discountable amount' field.

When you create a bank remittance proposal in 'Bank Remittance. Open' (ARS300) for this bank account, an automated check is made to verify that the total of the drafts to remit for collection in the proposal and the already collected amount with customer risk in (CRS692/F) is lower than the maximum collectable amount in this field. If the totals are higher than the maximum amounts, the drafts are included in the error report (ARS306PF).

(CRS692/E)

Fixed bank fee for collecting draft

… the fee that the bank charges for redeeming a draft on its due date. Optional. See also the comment for the 'Fixed bank fee for discounting draft' field.

The bank fee can be defined for the bank in 'Bank. Open' (CRS690/F) instead. It is then proposed here but can be changed.

(CRS692/E)

Discount rate

… one of the following, depending on the payment class:

Payment Class 4 (Bill of Exchange/Draft)

This is the interest rate the bank uses when you discount a draft. The interest is then deducted from the draft amount, based on how many days before the due date that the draft was discounted.

Payment Class 6 (Factoring)

This is the fee charged by the factoring company, expressed as a percentage of the total invoice amount. When you create a remittance statement in (ARS300), the fee is automatically calculated and posted using accounting rule AR75–192 (transaction code 21).

(CRS692/E)

Minimum number of days for interest

… the minimum number of days for which the bank will deduct interest if you discount a draft before its due date. Optional.

Example

If you discount a draft five days before the due date, the bank will nevertheless deduct interest for ten days, set as the minimum number of days.

(CRS692/F)

Discount not overdue

… the total amount of discounted drafts for which the customer risk is not canceled. This value, which is automatically displayed, is calculated and compared to the value in the 'Maximum discount amount' field in (CRS692/E). The value is updated when creating a bank remittance statement in 'Bank Remittance. Open' (ARS300) and when canceling the customer risk in 'Customer Risk Cancellation. Create' (ARS330).

(CRS692/F)

Collected amount with risk

… the total amount of drafts collected on the due date and for which the customer risk is not canceled. This value, which is automatically displayed, is calculated and compared to the value in the 'Maximum collection amount' field in (CRS692/E). The value is also updated in (ARS330) and (ARS330), the same way as for the previous field.

(CRS692/F)

Number of document lines

… how many lines can be printed either on check or payment specification, including supplier address and column headings. The text is defined per language in 'Document Text. Open' (CRS940). The language defined for the supplier in 'Supplier. Open' (CRS624/E) controls which text is used.

Note: If transfer method 3 (electronic payment, non-EDIFACT format) is selected for a payment method for bank transfer, the field indicates how many additional text lines are available or accepted by the bank in the German payment file. If the number of positions required for the text is larger than the number of positions available in the file, a separate payment specification with payment details is printed. The payment file itself will then only contain a reference to this specification. For German banks, we recommend six document lines for local payments (DTAUS) and four lines for foreign payments (DTAZV).

(CRS692/F)

Language

… the language in which the document itself should be printed, for the sake of the bank.

Specification for Customers

Program ID/Panel

Field

The field indicates …

(CRS692/F)

Payment method AR

… the payment method to use when remitting direct debit invoices in 'Bank Remittance. Open' (ARS300). An unpaid direct debit invoice does not have a bank account connected to it. As a result, the account must be assigned to each invoice when the proposal for the remittance bank report is created. This is an automated procedure. The first bank account for each customer with a defined payment that is found is automatically selected as the bank account to use.

Note: The selection is not based on the priority of the account. If the customer has several accounts, you should only enter a payment method for one account. Only accounts with status 20 (Definitive) are included in the selection. This field is only displayed for account type 2.

Specification for Employees

Program ID/Panel

Field

The field indicates …

(CRS692/F)

Employee bank account type

… the bank account of the employee that should be used for the different types of payroll runs. This field is only displayed for accounts of type 4. Required.

Alternatives

1 = Payroll account (for regular payroll runs, for example once a month, for example)

2 = Travel claim account (for runs reserved for travel claims, for example once a week)

3 = Partial run account (for advance payments, for example)

9 = Transaction account (for specific pay elements or transfers between the employee's accounts).

Uses

The connection between the bank account and the payroll run is done in 'Payroll Run Instruction. Open' (PRS200). The appropriate account is then automatically selected at the payroll run.

The values for Definitions for Electronic Bank Transfer are normally only used for the electronic remittance of payment orders in a batch file. This means that they are primarily intended for account types 1 and 3, although they can also be used for other accounts with electronic distribution. The definitions are according to UN/EDIFACT standard (United Nations Directories for Electronic Data Interchange for Administration, Commerce and Transport), in PAYMUL format (Multiple Payment Order Message).

Definitions for Electronic Bank Transfer (Optional)

Program ID/Panel

Field

The field indicates …

(CRS692/F)

Financial institution

… an identification of the bank or other financial institution to which the company bank should send the payment. To identify this institution, the name is used in combination with two codes: a code list qualifier and a code list agent.

Example

Financial institution: BANKUS. Code list qualifier: 25 (Bank identification). Code list agent: 5 (ISO – bank identifier code).

(CRS692/F)

Branch number

… an ID of a branch of the financial institution.

(CRS692/F)

Code list qualifier

… a fixed identification code for the code list used. This list explains the values entered in the 'Financial institution' or 'Branch number' fields.

(CRS692/F)

Code list agent

… a fixed responsible agency code, that is, a code that identifies who is responsible for the code list used.

(CRS692/F)

IBAN number

… a bank account that is used for electronic payments as an IBAN number. This is a unique bank account number in the international payment exchange, based upon and compliant with the ISO standard 13616. It is defined in the ECBS Standard EBS204.

The IBAN can consist of up to 34 alphanumeric characters. The first two characters identify the country in which the account is held. The next two digits are the check digits. They validate the complete IBAN. The final part of the IBAN is the domestic account number, which in most cases consists of the account number itself, the number that identifies the bank and the branch, and one or more check digits. For some countries an extra bank identifier is included. The IBAN should be entered without the leading designation IBAN and without blanks. Example of French IBAN: FR1420041010050500013M02606. The IBAN is validated against the MOD 97–10.

(CRS692/F)

Account number at financial institution

… the account number of the holder of the account. This is the account to which the company bank refers when sending the payment.

Note that if neither this account number nor the IBAN number is entered, and the bank account indicator selected uses check digit method 8 for Germany, the bank number must be entered on the F panel.

(CRS692/F)

Customer number at financial institution

… the customer number of the supplier at the financial institution.

(CRS692/F)

Bank EDI agreement number

… the number of the company's agreement with the bank controlling the EDI transfer.

Market-Specific Values for Electronic Foreign Payments

Program ID/Panel

Field

The field indicates …

(CRS692/F)

Transfer type

... how a foreign supplier payment is transferred.

Alternatives

00 = Normal payment transfer

10 = Express payment: payment transfer with high priority

11 = Quick transfer in euros (German: EUE = Eilzahlung in Euro)

13 = EU/EEA payment: Foreign payments to another state in the European Economic Area (EEA, comprising the EU countries, Norway, Iceland and Liechtenstein) in euros or in another currency of an EEA state.

20 = Check payment (only valid for Germany).

Transfer type 13: This transfer type is used for payments lower than EUR 50,000, together with the IBAN number and SWIFT (BIC) code of the beneficiary. It is used to verify that a) an IBAN number is entered for the supplier bank account in (CRS692), b) a SWIFT code is entered for the bank of the supplier's bank account in (CRS690), and c) that value 00 (transfer fees are shared) is selected in the 'Bank fee payment' field in (CRS692). EU/EEA payments are always transferred as normal payment (transfer type 00) by the e-Collaborator.

Comment on usage in Germany: The field is displayed for the bank account in (CRS692) when check digit method 08 is selected for the bank account indicator in (CRS072). Note that if the transfer amount exceeds EUR 50,000, M3 e-Collaborator automatically replaces this transfer type with transfer type 00. The value is used in the T22 field in the electronic DTAZV file for foreign payments (German market modification).

Comment on usage in Sweden: The field is displayed for the bank account when check digit method 35 or 37 is selected for the bank account indicator. Only values 00, 10 and 13 are valid. The transfer type is used in the electronic SE-BGU and SE-PGU files for foreign payments (Swedish market modification).

(CRS692/F)

Bank fee payment

... who is required to pay the bank fees for remitting – transferring –payments to foreign suppliers electronically.

Alternatives

00 = Bank fees are shared (SHA). The remitter pays the fees which covers the costs of the remitter's bank. The payment beneficiary pays the fees charged by the beneficiary's bank.

01 = Remitting party pays all fees (OUR). The remitter pays the fees covering the costs of both the remitter's bank and the beneficiary's bank.

02 = Beneficiary is charged all fees, including those of the remitter's bank.

(SHA=Shared. OUR=Our party pays. BEN=Beneficiary pays.)

Comment on usage in Germany: This field is displayed if check digit method 08 is selected for the bank account indicator connected to the bank account. The value is used in the electronic DTAZV file for foreign payments (German market modification).

The bank account and the bank account for the bank fees can be different ones than the bank account used to carry out the payment to the supplier. If the bank fee account and the payment account are not the same, the ID of the bank fee bank account must be entered in company-defined field 5 in (CRS692).

Comment on usage in Sweden: This field is displayed if check digit method 35 or 37 is selected for the bank account indicator connected to the bank account. The value is used in the electronic SE-BGU and SE-PGU files for foreign payments (Swedish market modification).

Comment on usage in Switzerland: This field is displayed if country code CH is entered for the bank account indicator connected to the bank account. The value is used in transaction types TA830 (optional), TA832 (optional) and TA836 (mandatory) in the electronic CH-DTA file for foreign payments (Swiss market modification).