Bank accounts

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

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 in your connection language, on creation or update.

You can add your translation in another language using the Translation function:

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

When you log on with this language, you can view the short description, long description or column header in your connection language if a translation exists. Otherwise, these descriptions are available in the folder language.

Bank address.

This code is used to identify the Country of a BP, amongst other things.

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

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.

The city automatically suggested is the one associated with the postal code previously indicated. You can also 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. For this control to be applied, the CTY - Nonexistent city alert parameter (SUP chapter, INT group) must also be set to Yes.
• If it does not exist and the postal code is set up as mandatory for the country, a blocking message is displayed when the fields Postal code or City/Town are entered or when information is modified 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 considering 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.

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

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

Telephone number.

The format depends on the country.

Fax number.

The format depends on the country.

Full email address.

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 in your connection language, on creation or update.

You can add your translation in another language using the Translation function:

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

When you log on with this language, you can view the short description, long description or column header in your connection language if a translation exists. Otherwise, these descriptions are available in the folder language.

Default bank account number.

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

For countries for which the IBAN management checkbox is selected, the IBAN is automatically calculated after you enter the Bank ID field.

The country code and the bank ID must have been previously entered for the bank account currently under setup.

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.

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.

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.

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.

Paying bank linked to the Bank ID number.

Additional paying bank linked to the Bank ID number.

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

Bank code for the interfaces to the cash management software.

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 that owns this bank account.

Entering this information automatically updates the company code.

Enter a unique code or string displaying 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.

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

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.

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.

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.

Specify here whether the bank requests separate On site and Off site check deposits.

This option is used by the A/P-A/R Accounting module upon check deposit.

Use this option to create one journal entry by open item or one journal entry by remittance when posting the notes payable/receivable to the bank.

If you select Yes, one journal entry is created by open item with an entry date set to the open item date.

If you select No, the entry date is set to the remittance date.

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 is an item by due date with as posting date the due date. If not the posting date is the note date.

Current line of the grid.

• Bank journal: The journal where the entries are posted for this bank.
• Journal of checks to be collected: The journal where the entries of check remittances are posted.
• Payment receipt journal: The journal where notes payable/receivable are posted on collection.
• Discount journal: The 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: The journal where notes payable on purchases are posted.
• Fixed assets notes payable journal:The journal where notes payable on fixed assets are posted.

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

The entry of the bank journal is mandatory.

The entry of the other journals is optional. They 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.

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

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

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.

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.

Specifies the operation-keeping currency.

The entries posted on a bank account held in a different currency to that of the company are 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.

If this checkbox is selected, general entries for this account are excluded from the FIFO rate calculation process (GESFIFCV).

This is useful to exclude short-term or overnight deposits and funds posted as Outgoing payment and Incoming payment on the same account.

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

Enter a start date of an open period to include journal entries beginning on that date.

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.

Use this field to enter the bank account number from which the bank charges are 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 used to enter the currency of the account on which the bank charges are debited.

The default currency is the same as the main account.

This field displays the IBAN prefix (International Bank Account Number) of the account from which the bank charges are debited.

This code is only used when generating bank files.

Field not used by the software.

Field not used by the software.

If this field is set to Yes, the balance control for this bank is activated in the Payment/receipt entry function. The balance control is run in the currency of the bank.

If the PROBALCTL - Progressive balance control parameter (TRS chapter, PAY group) is set to Yes, the balance control field is displayed and enabled.

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.

This field is related to the Bank statement import function.

When you import a file in that function, if the Bank account is configured for Portugal and if there is data in the Bank file (Portugal) field, this data is considered instead of the data from the Bank file field of the Bank statement import function.

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

When this checkbox is selected, the bank carries out a global posting. One debit line is considered by deposit slip.

When this checkbox is not selected, the bank carries out a unitary posting. One debit line is considered by payment.

This information is used in the context of the bank file generation with the SEPA format. It corresponds to the BatchBooking field in the .xml file.

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.

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

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

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

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

Check numbers must first be entered in the Checks function (GESCHB). 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.

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

Select 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 checkbook
• 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 parameter (TRS chapter, BNK group) is set to Yes.

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.

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

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

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

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