Banking and Cash Management > Banking Setup
  
Banking Setup
Define Bank Account Formats
Use Bank Account Format Maintain (25.11.4) to view an international account number format to apply to the bank accounts you create. You can also define new number formats, which must comply with the banking system of the country in which you are doing business, or with your customer or supplier banking systems.
Account number formats consist of segments of characters of specific lengths. For example, a standard Italian bank account number consists of a single check character, followed by 5 characters for the bank code, 5 characters for the branch code, and 12 characters for the account number. A valid Italian account number is, therefore:
1 22222 33333 444444444444
You define account numbers in two areas:
• On the Banking tab of the GL account for your bank. Bank accounts must be assigned a valid account number and linked to a payment format in Bank Payment Format Link in order to be used in customer and supplier payments.
• On the Banking tab of customers and suppliers. You enter the account number of your own bank and also the account number of the customer and suppler in order to set up automatic payment processes for customers and suppliers.
In both cases, you must select a bank account format and enter an account number. The number you enter is validated against the format you select, both for the number of characters in each segment and for the sequence of segments.
A number of formats are supplied with the system; these cannot be deleted.

System-Supplied Bank Account Formats
 
Bank Account Format Code
Format Description
Format
NL
Dutch Bank Account Format
10-digit account number. When there are 9 digits, the system inserts leading zeros to complete the number. Check digit validation.
IT
Italian Bank Account Format
23 digits. 1 check character (CIN), 5- digit bank code (ABI), 5-digit branch code (CAB), 12 alphanumerical account number. Check digit validation.
FR
French Bank Account Format
23 digits. 5-digit bank code, 5-digit branch code, 11 alphanumeric account number, 2 check digits. The account number can only contain characters from the ranges 0-9 and A-Z. Check digit validation.
ES
Spanish Bank Account Format
20 digits. 4-digit bank code, 4-digit branch code, 2 check digits, 10-digit account number. Check digit validation.
DE
German Bank Account Format
18 digits. 8-digit branch code (Bankleitzahl) followed by a 10-digit account number (Konto). If one of the segments has less than the specified number of digits, the system inserts leading zeros to complete the number.
CZ
Czech Bank Account Format
20 digits. 6-digit prefix, 10-digit account number, 4-digit bank code.
BE
Belgian Bank Account Format
12 digits. 3-digit bank code, 7-digit account number, 2 check digits. Check digit validation.
AU
Australian Bank Account Format
15 digits. 6-digit BSB (Bank/State/Branch), 9-digit account number.
AT
Austrian Bank Account Format
16 digits. 5-digit branch code (Bankleitzahl), 11-digit account number (Konto). If one of the segments has less than the specified number of digits, the system inserts leading zeros to complete the number.
IBAN
International Bank Account Format
A generic international bank format used frequently by European banks. This format has one segment of a maximum of 40 characters.
IBAN account numbers start with two characters, indicating the ISO country code, followed by two numeric check digits (IBAN check) and followed by the domestic bank account number in a single string (without any separation characters for the segments).
XX
No Validation
No restriction.
All preloaded formats, except the IBAN and XX formats, validate the account number entered. The NL, IT, FR, ES, and BE formats, however, also apply check digit validation to the account number you enter. Check digit validation is used by banks as an additional security feature to validate numbers. The validation usually consists of a calculation within the number itself. For example, the check digit validation for Belgian account numbers is as follows:
• When you divide the first 10 digits of the account number by 97, the remainder must be equal to the last two digits of the account number.
• When there is no remainder (the number is cleanly divisible by 97), the last two digits of the account number should be 97.
Example: A correctly entered Belgian account number is, therefore, 970097000097. When you divide by 97 there is no remainder, and the last two digits are 97. An incorrect account number is 979797979800. The remainder when divided by 97 is .0309, which is not equal to the last two digits of the account number.
Important: When you create your own format, you cannot define and apply check digit validation.
You must apply a format to every account number that you enter. The XX format lets you enter an unvalidated account number. Use the unvalidated format when you want to store your account number, but no format is available for your particular banking system.

Bank Account Format Maintain
Field Descriptions
Bank Account Format
Enter an alphanumeric code (maximum 20 characters) to identify the bank format.
Description
Enter a brief description (maximum 40 characters) of the format.
Segment Details
Sequence
This field displays the sequence number of the segments in the account number and indicates the order in which the segments are to be completed.
Label
Enter a brief description (maximum 40 characters) of the segment.
Length
Specify the number of characters in the segment.
Mandatory
Select this field to make this segment mandatory. Mandatory segments must be completed in order to validate the account number.
Leading Zeros
Select this field if the segment is a numeric field that must be zero padded automatically during incomplete input.
For example, a five-digit segment has the Leading Zeros field set to Yes. If you enter 23 for that segment, it is stored as 00023. Conversely, if the same five-digit segment has the Leading Zeros field set to No, and you enter 23 in that segment, it is stored as 23.
Delimiter
Enter a delimiter character to separate the format segments, if necessary. Account numbers in certain systems use segment delimiters, such as \, /, or – (for example, 1111/2222/3333/4444). This delimiter character is placed automatically after the segment for which it is defined
Last Modified User/Date/Time
These read-only fields display the ID of the user who last updated this record and the date and time of update.