Register Bank Account
Use this procedure to 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), 'Suppl Payment Proposal. Open' (APS130) or 'Suppl Payment Proposal. Open' (APS630), 'Supplier Payment. Enter Manual' (APS120), and 'Accounts Payable. Change Separate Invoice' (APS201).
The bank account table, CBANAC, is updated.
Before you start
Before you start, you must meet these prerequisites:
- Define languages in 'Language. Open' (CRS010).
- Define currencies in 'Currency. Open' (CRS055).
- Define the company's chart of account in 'Accounting Identity. Open' (CRS630).
- To specify a banking region to further identify the bank and you do not group the bank per area or state, you must define such a region in 'Banking Region. Open' (CRS843).
- Define a set of up to five user-defined fields in 'Bank Account Indicator. Open' (CRS072).
- For bank accounts that are the company's own account, you must define a bank in 'Bank. Open' (CRS690).
- 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 must 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.
- Define the access to banks and bank accounts at field or function level separately in the programs 'Field Group. Open' (SES100), 'Field Group. Connect Authority' (SES010), and 'Function. Connect Authority' (SES003).
Follow these steps
Define basic values
- 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.
- 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.
- On the B panel, select sorting order 1 or 5.
Sorting orders 2–4 are used for sorting and reviewing purposes only.
- Specify 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.
-
On the E panel, specify the required values based on the descriptions in the Parameters to Set table. Press Enter.
Define division-specific variants of supplier bank account
This step is optional.
-
On (CRS692/B), select option 12 = 'Bank per div' for a bank account of type 3.
-
On (CRS692/G), specify 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.
-
On the E and F panels, review and adjust any of the proposed values, if required. 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
- On the E panel, specify a value. Press Enter and repeat the procedure for each additional field.
- To store additional information and the standard fields in (CRS692) are not sufficient, select option 11 = 'Value/Account' for the bank account on (CRS692/B).
You may need such additional fields, for example, when national regulations require additional information to be included in a bank file.
-
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 |
Description |
---|---|---|
(CRS692/B) |
Bank account type |
The field indicates the category to which the bank account belongs. Required. These are the alternatives:
|
(CRS692/B) |
Account holder |
The field indicates 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 field indicates the division for which the bank account is valid. These are the account types and divisions:
|
(CRS692/B) |
Bank account ID |
The field indicates a user-defined five-position numeric or alphanumeric ID for an account. Required. |
(CRS692/B) |
Indicator |
The field indicates 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 field indicates 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 Specify 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 field indicates the status of the bank account. This field is required. These are the alternatives:
|
(CRS692/E) |
Bank account name |
The field indicates a description of the account, which is displayed on (CRS692/B). This field is required. |
(CRS692/E) |
Bank number |
The field indicates 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 field indicates the ID of a branch registered in 'Bank Branch. Open' (CRS691). This field is optional. |
(CRS692/E) |
Banking region |
The field indicates the ID of the region in which the bank/bank account is situated. This field is 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. For 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). These are the alternatives:
|
(CRS692/E) |
User-defined fields 1–5 |
The field indicates 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 (APS130) or (APS630). 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. This field is optional. |
(CRS692/E) |
Bank fee payment |
The field indicates who is required the transfer fees, that is, the bank fees for remitting or transferring payments to foreign suppliers electronically. These are the 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.
(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 field indicates the transfer type, which shows how a foreign supplier payment is transferred. These are the alternatives :
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 |
Description |
---|---|---|
(CRS692/E) |
Bank accounting string |
The field indicates the company's accounting string to be reserved for posting transactions on the bank account. This field is required. |
(CRS692/E) |
Currency |
The field indicates the currency for which the bank account is reserved (required). The currency is used as selection criteria in these cases:
|
Definitions for remittance of customer payment documents
Program ID/Panel |
Field |
Description |
---|---|---|
(CRS692/E) |
Remittance method |
The field indicates 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 can 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. These are the alternatives for Checks:
These are the alternatives for Drafts:
|
(CRS692/E) |
Number of days |
The field indicates 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 specify a value in this field, it overrides the corresponding value for risk cancellation on 'Customer Group. Open' (CRS145/E). You can 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 specified 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 field indicates the maximum amount allowed for discounted drafts for which the customer risk has not been canceled using this bank account. This field is 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 on (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 field indicates 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 field indicates the maximum amount allowed for redeeming a draft on the due date using this bank account. This field is 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 on (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 field indicates the fee that the bank charges for redeeming a draft on its due date. This field is optional. See the comment for the 'Fixed bank fee for discounting draft' field. The bank fee can be defined for the bank on 'Bank. Open' (CRS690/F) instead. It is then proposed here but can be changed. |
(CRS692/E) |
Discount rate |
The field indicates 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 field indicates the minimum number of days for which the bank will deduct interest if you discount a draft before its due date. This field is 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 field indicates 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 on (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 field indicates 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 on (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 |
The field indicates 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 field indicates the language in which the document itself should be printed, for the sake of the bank. |
Specification for customers
Program ID/Panel |
Field |
Description |
---|---|---|
(CRS692/F) |
Payment method AR |
The field indicates the payment method to use when remitting direct debit invoices in 'Bank Remittance. Open' (ARS300) or 'Remit Direct Debit and Factoring. Open' (ARS410). 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 |
Description |
---|---|---|
(CRS692/F) |
Employee bank account type |
The field indicates 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. These are the alternatives:
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 |
Description |
---|---|---|
(CRS692/F) |
Financial institution |
The field indicates 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 |
The field indicates an ID of a branch of the financial institution. |
(CRS692/F) |
Code list qualifier |
The field indicates a fixed identification code for the code list used. This list explains the values specified in the 'Financial institution' or 'Branch number' fields. |
(CRS692/F) |
Code list agent |
The field indicates a fixed responsible agency code, that is, a code that identifies who is responsible for the code list used. |
(CRS692/F) |
IBAN number |
The field indicates 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 field indicates the account number of the holder of the account. This is the account to which the company bank refers when sending the payment.
Note: If neither this account number nor the IBAN number is specified, 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 field indicates the customer number of the supplier at the financial institution. |
(CRS692/F) |
Bank EDI agreement number |
The field indicates 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 |
Description |
---|---|---|
(CRS692/F) |
Transfer type |
The field indicates how a foreign supplier payment is transferred. These are the alternatives:
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 |
The field indicates who is required to pay the bank fees for remitting, transferring, payments to foreign suppliers electronically. These are the alternatives:
(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 specified 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). |