Importing Bank Statement
Integration with Ukrainian banks is done through files that are exported in a specific format (.csv, .txt, .dat, .xml) from the client-bank system. You can import these files into the Bank Payment Journal.
System Configuration
- On the Bank Account Card page, set the value for the Import Format field according to your bank.
- Create a section in the Bank Payment Journal for the selected bank.
Importing Bank Statement
- Click the
button, which opens the Search function, and enter Bank Payment Journal to navigate to the relevant link. - On the Bank Payment Journal page, select the desired section of the journal in the Section Code field.
- Click Actions > Functions > Import Bank Statement.
- On the Import Bank Statement page, select the necessary file to be imported in the File Selection field.
- Enable the Import Duplicates option if you need to import duplicate transactions from the bank statement. If this option is disabled and there are already lines in the journal that are identical to those in the bank statement, the system will skip such lines during the import of the bank statement.
- Click the OK button. After a successful import, a completion message and verification results will be displayed.
- The lines of the bank statement file will be added to the Bank Statement Buffer. If there were any errors during the import of bank statement transactions, the corresponding lines will be displayed in red with values in the Error Code and Error Description fields. To check for errors in the lines, click the Verify button.
- Click the Import to Bank Payment Journal button. After a successful import, a completion message will be displayed. Importing to the Bank Payment Journal is only possible after resolving all errors.
Note
When generating the Bank Statement Buffer lines, the system looks for a match between the EDRPOU code or the VAT Registration No. and IBAN from the statement in the system directories. First, the settings on the Bank Account Details page are checked, and then other directories are checked - Customers, Vendors, Bank Accounts. If the system does not find any matches, the line will be marked in red and the Error code, Error description fields will be filled.
Bank Account Details
The Bank Statement Buffer contains the Bank Account Details feature. The table is used for automatic recognition of payments when importing a bank statement directly to the G/L Account (for example: Bank Commission, Salary Transfer, etc.). You need to fill in the following fields:
| Field | Description |
|---|---|
| Code | Specifies the unique identification code associated with this bank account detail record. The maximum length of the field is 10 characters. |
| Registration No. | Specifies the EDRPOU code of the counterparty. For example, a bank's EDRPOU code for the bank commission. |
| VAT Registration No. | Specifies the VAT Registration number of the counterparty. |
| Account Type | Specifies the type of account that the entry on the journal line will be posted to: - Customer; - Vendor; - Bank Account; - G/L Account. |
| Account No. | Specifies the account number this bank information is related to. |
| G/L Account Name | Specifies the name of the account to which this bank information applies. |
| Bank Account No. | Specifies the corresponding bank account to which/from which the payment is made or to which/from which the refund is made. |
| IBAN | Specifies the IBAN of the corresponding bank account. |
| Bank Code | Specifies of the SWIFT BIC code of the corresponding bank account. |
| Currency Code | Specifies the currency code in which the transaction is performed. |
| Bank City | Specifies the bank city associated with the bank operation. |
| Bank Name | Specifies the bank name associated with the bank operation. |
| Transit No. | Specifies the number of the relevant settlement bank account associated with this bank transaction (our settlement account). |
| Transit IBAN | Specifies the transit IBAN of the bank account (our current account). |
| Document Type | Specifies the type of document: Payment or Refund. |
| Transaction Code | Specifies the transaction code to which this bank information applies. |
| Shortcut Dimension Code 1 | Specifies the Global Dimension 1 code to be set for the operation. |
| Shortcut Dimension Code 2 | Specifies the Global Dimension 2 code to be set for the operation. |
Useful Links
Bank Payment Journal
Creating Payment Order
Bank/Cash Account