Liberty Bank Integration
Within the system, there is the ability to export payments and import bank statement. The integration is fully implemented for Liberty bank. For full integration with Liberty, it's necessary to set up Bank Accounts, Vendor Bank Account, Vendor Card, Bank Account Details, Checkup by Payment Assignment in the system, and the process of creating, exporting and importing payments should be done in the Bank Payment Journal.
Process Beyond System
A company should have an account on: https://my.libertybank.ge/. For API integration, it is necessary to contact Liberty Bank regarding Code Flow Authentication and to provide a Redirect URI. The Redirect URI is the link of the BC database for which the bank integration will be implemented. The bank will then provide a Client ID, which should be used in the Bank Service Setup.
Required Settings
To Create Company Bank Accounts, Select the 
icon, enter Bank Accounts and fill out the mandatory fields for integration with the bank:
- Section - General
| Fields | Description |
|---|---|
| No. | Specifies the number of the involved entry or record, according to the specified number series |
| Bank Code | International code of Bank - LBRTGE22 |
| Name | Specifies the name of the bank where you have the bank account |
| Bank Account no. | Specifies the number used by the bank for the bank account |
| Export Format | Options - Individual Liberty API/Package Liberty API |
| Import Format | Option - Liberty Bank API |
| Bank Extract Format | Specifies the data format for the bank extract |
| Client Bank | Specifies the type of interaction with the client bank system for the bank account, the ability to import/export a bank statement or just import |
| Bank Service | Specifies authentication credentials of the internet bank, card of credentials created for Liberty must be selected |
| LBT Exclude Type from Checkup/Matching | Specifies statement types that will be excluded from Checkup and Matching By Document No. logic for Liberty. "Commission" should shoud be spacified for now. Will be filled in by default from the selected Bank Service with the possibility to edit |
LBT Operation types:
- "Card Transaction";
- "External GEL Transfer (OUT)";
- "Internal GEL Transfer";
- "Conversion";
- "Utility";
- "Commission";
- "External GEL Transfer (IN)";
- "Cash Deposit";
- "SWIFT (IN)";
- "SWIFT (OUT)";
- "GEL Transfer Between Own Accounts";
- "Treasury Transfer";
- "Other";
- "Internal Currency Transfer";
- "Currency Transfer Between Own Accounts";
- "Cash Withdrawal".
- Section - Communication
| Fields | Description |
|---|---|
| Country/Region Code | It's necessary to choose |
- Section - Posting
| Fields | Description |
|---|---|
| Currency Code | Specifies the relevant currency code for the bank account |
| Bank Acc. Posting Group | Specifies a code for the bank account posting group for the bank account |
- Section - Transfer
| Fields | Description |
|---|---|
| SWIFT Code | Specifies the international bank identifier code (SWIFT) of the bank where you have the account (LBRTGE22) |
| IBAN | Specifies the bank account's international bank account number |
Setup Bank Services:
| Fields | Description |
|---|---|
| Code | Specifies the unique identification code associated with this Bank Service record |
| Description | Fill in with the name of the selected Bank Service |
| Bank Service | Option - Liberty |
| LBT Exclude Type from Checkup/Matching | Specifies statement types that will be excluded from Checkup and Matching By Document No. logic for Liberty. "Commission" should shoud be spacified for now |
To specify bank exchange formats, go to Bank Services. Here you can add bank account code and approproate bank service, and from actions "Setup" opens main integraiton tool page with fields:
| Fields | Description |
|---|---|
| Base API URL | Specifies the URL for connecting via the API if the bank extract format is being configured for online banking: https://my.libertybank.ge/api |
| Authentication URL | Specifies the value of the Authentication API URL field: https://accounts.libertybank.ge |
| Client ID | It is provided by the bank upon request for integration |
| Redirect URI | Specifies the link of the BC database for which the bank integration should be implemented |
| Scope | default value - openid profile account_api_public exchangerate_api_public currenttask_api_public transfer_api_public transaction_api_public billing_api_public |
| Response Type | default value - code |
| Grant Type | default value - authorization_code |
| Log Web Requests | Should be activated to create logs of requests and returned responses |
| Token Acquisition Time | Informational field |
| Token Expiration Time | Informational field |
From the Actions, the user can automatically fill in the following:
- Fill Redirect URI – This function fill in the Redirect URI link from the database in which it is activated. In some cases, it may require correction by user.
- Fill Default Settings – This function fills in the Scope, Response Type, and Grant Type with default values.
The token should be updated every 3 days and can be updated using the Authenticate function. Additionally, if the token expires during the import/export of payments, the system will notify the user and prompt them to acquire a new token.
Bank Account Details defines the setting for recognizing specific operactions (such as transfers between own accounts, conversion, commisions...) by transaction codes . Select the icon, enter Bank Account Details and fill out the following mandatory fields:
| Fields | Description |
|---|---|
| Code | Specifies the unique identification code associated with this bank account detail record |
| VAT Registration No. | Specifies the Company's VAT registration No. from the company information |
| Bank Account No. | Specifies the account number of the bank associated with this general ledger account bank operation |
| Account Type | Specifies the type of account that the entry on the journal line will be posted to ( G/L Account/Vendor/Customer) |
| Account No. | Specifies the Account No. to which the entry on the journal line will be posted to |
| Bank BIC | Specifies the SWIFT BIC code of the recipient of the bank operation |
| Document Type | Specifies the document type of the identifyed transaction by transaction code (Payment/Refund) |
| IBAN | Specifies the bank account's international bank account number |
| Transaction Code | Specifies the transaction code to which this bank information applies |
The uniqueness of lines is checked by the following fields: Account Type, Account No., Currency Code, Transaction Code, Document Type, Payment Assignment.
If in the Bank Account Details lines Shortcut Dimension 1 and Shortcut Dimension 2 are specified and the transaction in the buffer has been checked up from the setup in the bank account details -> the specified dimensions will be filled in the Bank Buffer accordingly.
Checkup by Payment Assignment defines the setting for recognizing specific operactions (such as transfers between own accounts, conversion, commisions...) by payment assignment. Select the icon, enter Checkup by Payment Assignment and fill out the following mandatory fields:
| Fields | Description |
|---|---|
| Code | Specifies the unique identification code associated with this record |
| Type | Specifies whether the rule applies to incoming amounts, outgoing amounts, or both (if left empty) |
| Payment Assignment | Specifies the payment assignment for which identification should be performed for bank operations |
| Bank Account Details | Specifies the relevant bank account details from which the Account No. should be taken for identified bank operations, based on type and payment assignment |
Vendor Bank Account card must be configured to export transactions. The following are the required fields for exporting payments in local and foreign currencies:
| Fields | Description |
|---|---|
| Code | Specifies the unique identification code associated with this bank account detail record |
| Bank Code | International code of the Bank |
| Name | Specifies the name of the bank |
| Adress | Specifies the adress of the Beneficiary Bank (for foreign payments) |
| Country/Region Code | Specifies the country of the Beneficiary Bank |
| City | Specifies the City of the Beneficiary Bank (for foreign payments) |
| Currency Code | Specifies the relevant currency code for the bank account |
| Bank Type | Specifies the Beneficiary Bank Type Vendor or Tax Authority (for treasure payments) |
| SWIFT Code | Specifies the SWIFT code (international bank identifier code) of the beneficiary bank account. For treasure payments - TRESGE22 |
| IBAN | Specifies the bank account's international bank account number |
| Intermediary Bank | Specifies the SWIFT code (international bank identifier code) of the intermediary bank |
| SWIFT Intermediary Bank Name | Specifies the name of the intermediary bank |
Functionality
Bank Payment Journal
In order to complete import/export of payments from bank payment journal, General Journal Batches should be set up.
Select the icon, enter Bank Payment Journal, and from the Batch Name field, open General Journal Batches. There can be added batches for different bank accounts that company has. It is necessary to fill out Bal. Account Type, Bal. Account No., No.Series. and mark "Use Document No. from Batch No. Series" in order for Document No.s to always be unique in the bank payment journal.
After setting up the batches, choose one of them and begin the processes of bank payments.
For additional information about Templates and Batches, see the link.
Exporting Payments
Liberty export formats:
• Individual Liberty API - payments are sent straight to internet bank's individual payments
• Package Liberty API - payments are sent straight to internet bank's package payments
To export Payments from Bank Payment Journal, the following Account types are mostly used: Vendor, Customer (for refunds).
Liberty payments can be created in Bank Payment Journal and exported:
- To liberty bank accounts in national currency and foreign currency,
- To another bank in national currency
In order to export payments from the Bank Payment Journal to the Vendor, the following fields should be filled in:
| Fields | Description |
|---|---|
| Posting Date | Specifies the posting date for the entry |
| Document Type | Specifies the type of document that the entry on the journal line is (Payment) |
| Document No | Specifies a document number for the journal line. Automaticaaly filled in from the No. Series of the batch |
| Account Type | Specifies the type of account that the entry on the journal line will be posted to (Vendor) |
| Account No. | Specifies the account no. that the entry on the journal line will be posted to (Vednor Account No.) |
| Description | Filled in with the name of the selected Account No |
| Currency Code | Specifies the code of the currency for the amounts on the journal line. Filled in automatically from the Bank Account No. of the selected Batch name |
| Amount | Specifies the total amount (including VAT) that should be exported |
| Recipient Bank Account | Specifies the bank account that the amount will be transferred to after it has been exported from the payment journal |
| Payment Assignment | Specifies the purpose of the payment |
| Payment Order Status | If export is required, select For Export from options |
| Expense Type | Specifies who is the payer of the charges and fees associated with the bank payment journal line (BEN/OUR/SHA) |
Note. Refunding to Customer is filled out in the same way and can be exported.
Payment preparation can be done in the following ways:
- Manually
- By Suggest Vendor Payments. In the Payment Journal window, you can use the Suggest Vendor Payments batch job to suggest payment lines based on due date. For further information see the link.
- The Create Payment feature on the Open Documents subform. For further information:see the link
After flling out the Lines in Bank Payment Journal and Changing Payment Order Status (For Export), you can select Process-> Export Payments. The system will notify that export was successful, and Payment Order Status will change to Exported.
If any information is missing in the payment line, the system notifies about it. If there is incorrect information in a field, for example Recipient Bank Account is not valid, the Payment Order Status changes to ERROR, and an Error Message field is filled out with the reason of not exporting a payment.
Check Payment Status function allows you to check the status of exported payments (for individual and package payments):
- Select the lines in the bank payment journal for which you want to check the status;
- Actions -> Functions -> Check Payment Status;
- The status received from the bank will be filled in the Transaction Status field
Importing Payments
In Bank Payment Journal, click Import Bank Extract from the menu and choose the dates of payments you want to import. For the import to be completed, Bank Extract should be empty. If there are some lines in it, the system won't import the payments.
After successful import, the payments will be imported in the Bank Extract Buffer window (Bank Extract -> Open Bank Extract):
Flow of the Checkup process of imported transactions in Bank Extract Buffer to identify transactions:
- By Document No. in case Checkup by Document No. is activated for the Bank Account Card. When payments from the bank payment journal are exported successfully with "Document No", wchich is unique and we also receive it when importing payments. The Account Type and Account No. will be filled from the identified transactions by Document No. from bank payment journal. The check-up by Document No. process will be excluded for transactions that have the same value in LBT Operation Type in the bank buffer and LBT Exclude Type from Checkup/Matching in the Bank Account.
- According to the Checkup by Payment Assignment which sets up rules for recognizing transactions by payment assignment
- Customer/Vendor/Employee identification:
- if the amount is positive (outgoing amount) the search is first performed in Vendors by Cor. Settlment Account, then by VAT Registration No., if not found: in Customers by Cor. Settlment Account, then by VAT Registration No.. If found, the Account Type and Account No. are filled in. If Account type=Vendor -> Document type=Payment, if Customer -> Document type=Refund.
- if the amount is negative (ingoing amount), the search is first performed in Cusomers by Cor. Settlment Account, then by VAT Registration No., if not found: in Vendors by Cor. Settlment Account, then by VAT Registration No.. If found, the Account Type and Account No. are filled in. If Account type=Customer -> Document type=payment, if Vendor -> Document type=Refund.
By clicking the Check Up button you can update checking process.
-The lines colored in red are payments that the system doesn't recognize by any of the Checkup Process. When clicking Import to Bank Payment Journal, red Payments stay in Bank Extract Buffer.
-The lines in black are payments which were recognized by the system and can be transferred into Bank Payment Journal by clicking Import to Bank Payment Journal on the ribbon of Bank Extract Buffer.
Process of checking for duplicate entries:
Imported Payments shouldn't be duplicated in the system, so the Check Bank Extract for Duplicate Entries should be activated. When importing payments from Bank Extract Buffer to Bank Payment Journal, lines will be checked if the operation is already posted in General Ledger Entries or generated in Bank Payment Journals, this payment won't be transferred to Bank Payment Journal.
- When checking in Bank Account Ledger Entries, the following parameters are checked: Bank Account No., External Document No., Posting Date, Account No., Reversed=false, Amount
- When checking in Bank Payment Journal, the following parameters are checked: Account Type, BankAccount. No., Account No., External Document No., Posting Date, Amount
Matching Process of exported and the relevant imported transactions:
- The following fields must be matched to identify the exported transaction from the bank payment journal with the imported transaction in the bank extract buffer: payment order status must be exported, Account type, Account No, Document Type, Amount, Vat Registration No., Recipient Bank Account.
- Including all the above fields, you can additinally check transactions by document number where Document No (buffer)=Document No (bank payment journal) if the Compare Document No. function is activated on the Bank Account Card. The process will be excluded for transactions that have the same value in LBT Operation Type in the bank buffer and LBT Exclude Type from Checkup/Matching in the Bank Account.
- Additionally, the matching process can only be performed by matching the Document No. field only if the Matching by Document No for exp. transactions is activated on the Bank Account Card. The process will be excluded for transactions that have the same value in LBT Operation Type in the bank buffer and LBT Exclude Type from Checkup/Matching in the Bank Account.
If all fields match -> Payment Order Status will change to Paid and update the posting date in journal from the Extract Date field (buffer). Matching transactions will not be duplicated in the bank payment journal.
Check Bank Account Details
If you want to check if a Cor. Settlement Account exists for Customers/Vednors in the system, you can activate Check Bank Account Details function on the Bank Account Card. If such a corr. settlement account is not fund -> the system will notify you about the need to add Bank Account Card
If Payments aren't between own accounts, the system checks the company's VAT Registration No. to identify if the imported payment is incoming or outgoing. If the Imported field value in Bank Buffer Cor. VAT Registration No. = VAT Registration No from Company Information, and VAT Registration No. doesn't equal the Cor. VAT Registration No. for that line on Bank Buffer, then during the import of bank statement, the values are switching for the following fields:
-Settlement Account to/from Cor. Settlement Account,
-VAT Registration No. to/from Cor. VAT Registration No.,
-Account No. to/from Cor. Account No.
Reverse posted transactions
The cancellation of the transactions must be performed from the Bank Account Ledger Enties using the action Reverse Transaction.
Web Request Logs
To create log of requests and returned responses, set up the following:
- Go to Bank Account Card,
- Open Bank Extract Format,
- Check Log Web Requests,
- Go to Bank Payment Journal,
- Create payment and send to onlines banking,
- Go to Web Request Log,
- Download the Requests/Response files.
In the Bank Extract Buffer, a new button called 'Fill Date' has been added. This button ensures that if the Extract Date is empty, its value is filled with the Document Date, and vice versa.