Bank Accounts

• Code (field BAN)

This code identifies a bank account. You can enter the code directly or select from the bank account table.

• Description (field DES)

This field is used to link a description to its record. This description can be printed on the records, displayed when the record code is entered in a screen, or used on selection.
The title, used by default in the reports and entry masks is replaced by the short title when it is required by display and print constraints.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

• Click Translation from the Actions icon in the corresponding field.
• In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

The connection language must be defined as a default language for thefolder.

• Address (field ADDLIG)

Bank address.

• Country (field CRY)

This code is used to identify amongst other things, the Country of a BP.
This is important information, associated with a number of characteristics useful for performing controls on other linked information, in particular:

• the telephone number format,
• the format of the number that identifies a company or an activity (site tax ID number, NAF in France), and whether its entry is mandatory or not,
• the postal code format of the town and also the code of the geographic subdivision, and whether their entry is mandatory,
• whether the VAT number of this community is mandatory,
• the Bank ID code format.

• field CRYNAM

• Postal code (field POSCOD)

The postal code, which entry format is defined in the Country table, is used to define the town/city, state/region and the geographical subdivision, if defined for the country.
If you modify the postal code, the city/town and state/region corresponding to this new code are automatically displayed. The principle is the same for the geographical subdivision if it is present for the country.
You can also directly enter a town/city name or state/province. If the city/town, state/region are defined, the associated postal codes are displayed automatically.
The control of this information and its mandatory nature depend on the setup carried out in the country management. For the control to be applied, the POSCOD - Warning nonexistent postal code parameter (SUP chapter, INT group) must also be set to 'Yes'.

Particular cases:

- for ANDORRA, indicate 99130,
- for MONACO, indicate 99138,
- for the other foreign countries, indicate the national identifier of the country or 99999 if not known.

When the postal code is defined as mandatory for the country, it must be entered if the Postal Code or City/town fields are entered, or if information is modified in the BP address window. However, this control is not applied in document creation.

• City (field CTY)

The city automatically suggested is the one associated with the postal code previously indicated. It is also possible to manually enter the name of a town/city:
- If the town/city is already defined, the associated postal code is automatically displayed,
- If it does not exist and the postal code control has been set up in the Country record, a warning message is displayed but the continuation of the entry is authorized (in order for this control to be applied, the CTY - Nonexistent city alert parameter - SUP chapter, INT group - must also be set 'Yes'),
- If it does not exist and the postal code is set up as mandatory for the country, a blocking message is displayed in case the fields Postal code or City/Town are entered or in case of modification of information in the address window of the BP. However, this control is not carried out in document creation.

Notes.

• Its format is defined in the Country record setup.
• Depending on this setup, the entered town/city can automatically be converted into uppercase after it has been entered.
• In order to make selections easier without taking into account the format (accented characters/uppercase letters/lowercase letters), the selection window available on this field proposes a column dedicated to the search, where the names of the towns/cities are displayed in uppercase.

• Map (field ITINERAIRE)

Click this icon to open a mapping site and locate the entered address.

• State (field SAT)

Code making it possible to specify the county where the bank is located.

• Telephone (field TEL)

Telephone number.

The format depends on the country.

• Fax (field FAX)

Fax number

The format depends on the country.

• Internet (field WEB)

Full email address.

• Short description (field DESSHO)

Title used in some screens or reports when there is not enough space to view the long title.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

• Click Translation from the Actions icon in the corresponding field.
• In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

The connection language must be defined as a default language for thefolder.

• Site tax ID no. (field CRN)

• Bank acct. number (field BIDNUM)

Default bank account number.

• BIC code (field BICCOD)

International identification code for banking institutions defined by the ISO standard.

• IBAN code (field IBACOD)

For countries for which the IBAN management box is checked, the IBAN is automatically calculated after the user has entered the Bank ID field.
The country code and the bank ID must have been previously entered for the bank account currently under setup.

• QR-IBAN (field QRCIBACOD)

Enter the QR-IBAN number for the sender. This is used when generating sales invoices as QR-bills and this number is used as the sender's account number in the QR payment slip.

See the Swiss localization guide for detailed information on QR-bills.

• ABA number (field ABANUM)

Enter the 9-digit routing or transit number for the bank.

This field is required when generating bank files with an ACH format, whether fixed or XML file.

Note: The KUS activity code must be active to use ACH payments.

• ACH individual ID (field SGLIDACH)

Enter the unique 15-character code assigned to you by the bank.

This field is required when generating bank files with an ACH format as an XML file.

Note: The KUS activity code must be active to use ACH payments.

• MTS individual ID (field SGLIDMTS)

Enter the unique 15-character code assigned to you by the bank.

This field is required when generating bank files with an ACH format as an XML MTS file.

Note: The KUS activity code must be active to use ACH payments.

• Paying bank 1 (field PAB1)

Paying bank linked to the Bank ID number.

• Paying bank 2 (field PAB2)

Additional paying bank linked to Bank ID number.

• Additional issuer identification (field SENNUM)

Specify here the issuer number to be provided during a magnetic transfer.

• Treasury interface (field TRECOD)

Bank code for the interfaces to the cash management software

• Direct debit issuer no. (field SENNUM2)

• Portuguese bank code (field PORBANCOD)

• Access code (field ACS)

Access code used to limit the access to the bank for certain users.
If this field is assigned, only users with this access code in their profile can use this bank.

• Site (field FCY)

Site that possesses this bank account. Entering this information automatically updates the company code.

• Company (field CPY)

Company that possesses this bank account.
Mandatory information.

• Bank statement identifier (field BSIREFBAN)

Enter a unique code or string appearing in the bank statement file to identify this bank account.

This field is optionally used in the context of the advanced bank statement import process. Depending on the setup, the bank statement import uses this information to automatically find the Sage X3 bank account belonging to the bank statement file. Typically, this is needed when importing statement files containing multiple statements from different bank accounts for the same bank in one file.

Refer to the Advanced Bank Statement how to guide for more details.

• ISR customer no. (field BVRNUM)

This field requires the KSW – Swiss localization activity code to be active. You use it to enter the ISR customer number for the given bank account. This number is used for payments with ISR number (inpayment slip with reference numbers).

For suppliers, the ISR customer no. is also used to search for a matching BP account if support for ISR code line entry on purchase invoices is active in the SWIPURBVR - Swiss ISR usage purchasing parameter (LOC chapter, SWI group).

Refer to the Swiss legislation guide on the How to tab for more details regarding payment and ISR setup.

• Customer ID ISR (field BVRCUSTID)

Enter the ISR customer ID if you use ISR customer invoices with a standard bank account and not a Postfinance account. The ISR customer ID is issued by your bank.

This field is only available if the KSW – Swiss localization activity code is active.

• Incoming payment transaction (field INPAYTRA)

Enter or select the Revenue Payment entry type (GESTPY) code for this bank account. This code is used in the related Bank register.

This field only displays for a Polish or South African legislation for a Bank register.

• Outgoing payment transaction (field OUTPAYTRA)

Enter or select the Expense Payment entry type (GESTPY) code for this bank account. This code is used in the related Bank register.

This field only displays for a Polish or South African legislation for a Bank register.

• field BAK11

• field BAK12

• field BAK13

• field BAK14

• O/L check remit. (field CHQTYPFLG)

Specify here whether the bank requests separate "On site" and "Off site" check deposits.
This option will be used by the A/P-A/R Accounting module upon check deposit.

• Deposit by due date (field FRMDUDFLG)

• Payment order by due date (field PABDUDFLG)

This option makes it possible to create a document for each due date or a document by note during the validation of a paying bank notice on the bank.

If 'yes', there will be an item by due date with as posting date the due date. If not the posting date will be the note date.

• No. (field NUMLIG1)

Current line of the grid.

• Journal type (field JOUTYP)

• Bank journal: the journal where the entries are posted for this bank.
• Journal of checks to be collected: journal where the entries of check remittances are posted.
• Payment receipt journal: journal where notes payable/receivable are posted on collection.
• Discount journal: journal where notes payable/receivable deposits are posted on discount. This journal can be identical or different from the payment receipt journal.

Two journals can used whether the payments relate to fixed asset suppliers or not:

• Purchase notes payable journal: journal where notes payable on purchases are posted.
• Fixed assets notes payable journal: journal where notes payable on fixed assets are posted.

Each journal can be set to Cash management or Miscellaneous operations.

• Journal (field JOU)

The entry of the bank journal is mandatory.
The entry of the other journals is optional. They will replace those entered in the general parameterization.
In any case, these must be the cash management or MO journals.
The choice of a journal type is made in a local menu.

• Entry type (field GTE)

Used to associate a document type to a journal type, in other words a posting phase.

• Cash acct. (field TREACC)

Used to associate a cash account to a journal type, in other words, a posting phase.

• BP code (field BANBPR)

This field displays the BP Code, which is mandatory when one of the journals is associated with a collective account. The BP code must be a miscellaneous BP and is considered as a subdivision of the bank account.

For example, this setup makes it possible to follow the entries and avoid duplicating bank accounts in Financials.

• Accounting code (field ACCCOD)

Use this field to specify the accounting code of the site.
The accounting code is a default value used in the setting up of accounting entries.
It refers to a table that lists a certain amount of elements (collective accounts, accounts or parts of accounts) that can be used for the determination of the documents that will be posted.

• Currency (field CUR)

Specifies the operation-keeping currency.

• Rate type (field CHGTYP)

The entries posted on a bank account held in a different currency to that of the company will be valued in company currency.

Mention here the exchange rate type to be used to perform the conversion.

The type is used in the bank allocation function to value the virtual balance of the bank in company currency.

• Date of currency change (field CHGDAT)

• Cash excluded (field CFOEXD)

• FIFO conversion process (field FLDFIFCP)

• Start date (field FLDSDA)

This field is only available if the account currency is different from the related ledger or journal currency and if the FIFRC- activity code is active and the FIFRC – FIFO rate calculation parameter (CPT chapter, CLO group) is set to Yes.

• Bank account number (field BIDEXS)

Use this field to enter the bank account number from which the bank charges wlll be debited.
This code is only used when generating bank files. The setup of a specific charge account does not generate any particular accounting entry. The validity of the entered number is submittted to the control of the bank account number key.
 This field is optional. If it is not assigned, the details of the main account are retrieved.

• Currency (field CUREXS)

This field is used to enter the currency of the account on which the bank charges will be debited.
The default currency will be the same as the main account's.
 This field is entered if the bank ID of the specific charge account has been entered.

• IBAN code (field IBAEXS)

This field displays the IBAN prefix (International Bank Account Number) of the account from which the bank charges will be debited.
This code is only used when generating bank files.
 This field is entered if the Bank ID of the charges specific account has been filled.

• Bank terms (field BANTRM)

Field not used by the software.

• Early discount rate (field DEPRAT)

Field not used by the software.

• Balance control (field BNKPROBALC)

If this field is set to ‘Yes’, the balance control for this bank is activated in function Payment/receipt entry. The balance control will be run in the currency of the bank.
If parameter PROBALCTL - Progressive balance control (chapter TRS - group PAY) is set to ‘Yes’, the balance control field is displayed and enabled.

• File extension (field FILEXT)

Enter the extension for file names that are generated for electronic transfers. The extension is required when the bank account contains more than three characters.

• Bank file (Portugal) (field BANFIL)

• Additional record (field RECCPT)

When checked, this box is used to generate bank files with format AFB160 and line '07' ('Additional records').

• Processing by batch (field SCTPROLOT)

When this box is checked, the bank carries out a global posting (one debit line taken into account by deposit slip).
When this box is not checked, the bank carries out a unitary posting (one debit line taken into account by payment).
This information is used in the context of the bank file generation with the SEPA format. It corresponds to the field 'BatchBooking' in the .xml file.

• Dimension type (field DIE)

• Dimension (field CCE)

This field displays the analytical dimension type associated with the bank. The displayed dimension types default from the Company/site associated with the bank/cash.

• Format (field CHKFMT)

Select the check format based on the type of check you are printing to:

• Check-stub-stub
• Stub-check-stub
• Check-stub

If the parameter USACHK -US/Can Check Printing (chapter LOC, group USA) is set to Yes, the field is active. If this parameter is set to No, the field is in active and set to Not Used.

• Next check no. (field NXTSEQ)

This field displays the next check number or you can enter a check number.

Check numbers must first be entered in the Checks (GESCHB) function. You can access this from the Checkbook icon.

This field is only active when the CHQCT - Check controls  parameter (TRS chapter, BNK group is set to Yes.

• Checkbook (field CHK_BTN)

Click the Checkbook icon to open the Checks (GESCHB) function to assign check numbers for a unique bank account. Enter the beginning and ending numbers from the check stock.

• Check status (field STA_BTN)

Click the Lookup icon to view the check status and the corresponding Positive Pay date and Positive Pay sequence number if relevant.

Statuses include:

Unissued – initial status when checks are generated through check book

Issued – status once check has been printed for auto checks or assigned for manual checks

Voided – manually void or automatically voided through payment deletion or cancellation

Posted –payment and check are posted

Cleared –check has cleared bank

You cannot manually adjust a check with a status of issued, posted, or cleared. Those statuses are set systematically when activities are performed on the linked payment.Only unposted checks can be reprinted.

This field is only active when the CHQCT - Check controls (TRS chapter, BNK group) parameter is set to Yes.

• Print (field MCRPRT)

Select Yes for MICR printing. This enables the Bank transit and Checking account fields. The check number and the MICR line are printed on the checks.  

• Bank transit (field BANTRA)

Enter the bank transit numbers to be printed on the MICR line for checks.

• Checking account (field CHKACC)

Enter the bank's checking account number to be printed on the MICR line on checks.

• File name (field POSPAYFIL)

Enter the Positive Pay bank file name created in the Bank files function (GESTFB).

This field is available only if the CHQCT - Check controls (TRS chapter, BNK group) parameter of the bank is set to Yes and if the Bank file check box is selected in the Bank files function (GESTFB).