TBC Bank Integration
In system it’s possible to send/receive bank payment and post them. Configuration fully done for TBC bank. For full integration with TBC it’s necessary to set up in system Bank Accounts, Bank Details Account, Bank Extract and process of creating, exporting and importing payments takes place in Bank Payment Journal.
Required Settings
-
To create company bank accounts, Choose the
icon, enter Bank Accounts and create fill mandatory fields for integration and completing with 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- TBCBGE22 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- XML/Individual TBC API/TBC Package Import Format Option - TBC API Bank Extract Format Specifies authentication credentials of internet bank,should be chosen card of credentials created for TBC. 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. Section - Communication
Fields Description Country/Region Code It’s necessary to choose for foreign currencies transactions. 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. Chosen one should have filled G/L, Transit and Commissions Accounts. Bank Payment Order No. Series Specifies the serial number for the bank payment order. Commission % Specifies the commission percentage for the bank account. For example, for currency operations. Section - Transfer
Fields Description SWIFT Code Specifies the international bank identifier code (SWIFT) of the bank where you have the account. (TBCBGE22) IBAN Specifies the bank account's international bank account number - To specify bank exchange formats, go to any Bank Account card and expand the page of Bank Extract Format field. Here you can add bank extracts for different banks. For successful integration with bank, its necessary to fill following fields in it:
Section - General
Fields Description Code Specifies the code of the bank account for which the format is configured. File Type - Specifies the file type of the bank extract. Web Bank Interface Choose interface of TBC from options. Encoding Specifies the text encoding type of the bank extract. (Windows) Data Formaat Specifies the date format of the bank extract. Section - Web Interface
Fields Description Base API URL Specifies the URL for connecting via the API, if the bank extract format is being configured for online banking. For TBC Integration this fields Should be filled by following link: https://test.tbconline.ge/dbi/dbiService. API Login Specifies the login for connecting via the API, if the bank extract format is being configured for online banking. API Password Specifies the password for connecting via the API, if the bank extract format is being configured for online banking. Token Specifies the token for connecting via the API, if the bank extract format is being configured for online banking. Client Secret Specifies the client secret for connecting via the API, if the bank extract format is being configured for online banking. - Bank Account Details are necessary to do operations between companys bank accounts. All companys owned bank accounts should be set up here. Choose the icon, enter Bank Account Details and fill following mandatory fields:
Fields Description Code Specifies the unique identification code associated with this bank account detail record. VAT Registration No. Specifies the bank's VAT registration number. 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 number to which this bank information applies G/L Account No. Specifies the account number to which bank this information applies. G/L Account Name Specifies the name of the account to which this bank information applies. Bank BIC Specifies the SWIFT BIC code of the recipient of the bank operation. Document Type Specifies the type of the related document. (Payment) IBAN Specifies the bank account's international bank account number.
Functionality
Bank Payment Journal
In order to complete import/export of payments from bank payment journal, General Journal Batches should be set up.
Choose the icon , enter Bank Payment Journal, and from the field Batch Name open General Journal Batches. There can be added batches for different bank accounts that company have. It is necessary to fill Bal. Account Type, Bal. Account No., No.Series.
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 link
Importing Payments
In Bank Payment Journal, click Import Bank Extract from menu and choose the dates of payments you want to import. Importing to be completed Bank Extract should be empty , if there are some lines in it, system won’t import payments.
After successful importing, new window of Bank Extract appears and imported payments are filled in lines. By clicking button Check Up is possible system to check coresponding account are registred in BC or not:
-The lines colored in red, are payments that system doesn’t recognizes by Cor. Settlment Account or Cor. VAT Registration No. . When clicking Import to Bank Payment Journal red Payments stay in Bank Extract Buffer.
-The lines in black are payments which was recognized by syste, and can be transferred into Bank Payment Journal, by clicking button Import to Bank Payment Journal on the ribbon of Bank Extract Buffer.
Imported Payments shouldn’t be duplicated in system, so they are checked by External Document No. field. If the payment with this number is already posted or generated in Bank Payment Journals same or different batch, this kind of payment won’t be transferred to Bank Payment Journal.
Recognized imported Payments fill following fields in Bank Extract Buffer: Journal Template Name, Journal Batch Name, Line No, Document Type, External Document No., Document Date, Extract Date, Payment Assignment, Amount, Settlement Account, Account Type, Account No., Cor. Name. Unrecognized Payments leave Document Type, Account No. fields empty, and the reason for not recognizing payment is generated in Error Code and Error Description fields.
After transferring recognized payments to Bank Payment Journal, its possible to post them and posted antry will be addedn in relevant ledger entry.
Exporting Payments
TBC export formats: • TBC XML- After filling payment lines and clicking EXPORT PAYMENTS, XML format file is downloaded, then to be manually imported into internet bank. • Individual TBC API- payments are sent straight to internet bank individual payments. • Package TBC API- payments are sent straight to internet bank package payments.
For both export tyoes TBC payments can be created in Bank Payment Journal and exported:
- To own TBC accounts, in national and foreign currency.
- To the other bank in national currency.
- To the other bank in foreign currency.
- Bank Payment with Account Type Vendor.
There are two ways to export payments from Bank Payment Journal with paying to Vendor:
-Manually filling payment line for exporting with choosing Vendor in Account Type field and filling following fields in line:
| 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, Refund, Invoice, Credit Memo, Finance Charge Memo, Reminder) |
| Document No | Specifies a document number for the journal line. It can be filled after Applying Document to payment from ribbon->Process->Apply Entries->choosing the document and from process-> Set Applies-to ID . |
| Account Type | Specifies the type of account that the entry on the journal line will be posted to- Vendor |
| Account No. | Specifies the account number that the entry on the journal line will be posted to. In this case will be optional chosen Vendors Bank Accounts. |
| Description | Specifies a description of the entry. |
| Currency Code | Specifies the code of the currency for the amounts on the journal line. |
| Amount | Specifies the total amount (including VAT) that the journal line consists of. |
| 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 we want to export must choose For Export from options. |
Note. In the same way is filled Refunding to Customer, and it can be exported.
- By Suggest Vendor Payments. In the Payment Journal window, you can use the Suggest Vendor Payments batch job to suggest payment lines. Lines for things like payments that are due soon, or payments where a payment discount is available, are suggested based on your settings.
For further information about Suggest Vendor Payments see the link: link
- Bank Payment with Account Type G/L Account
To export payments from Bank Payment Journal to company’s one account to another , in Lines use Account Type- G/L Account in Bank Payments Journal lines. Following fields should be filled for exporting G/L Accunt payment:
| 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, Refund, Invoice, Credit Memo, Finance Charge Memo, Reminder) |
| Document No | Specifies a document number for the journal line. |
| Account Type | Specifies the type of account that the entry on the journal line will be posted to- G/L Account |
| Account No. | Specifies the account number that the entry on the journal line will be posted to. Should be indicated only those accounts, that are added for Bank Accounts in Bank Account Details. |
| Currency Code | Specifies the code of the currency for the amounts on the journal line. |
| Amount | Specifies the total amount (including VAT) that the journal line consists of. |
| 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 we want to export must choose For Export from options. |
After Filling Lines in Bank Payment Journal and Changing Payment Order Status to – For Export, you can press button Process-> Export Payments. System will notify that exporting was successful and Payment Order Status will change to Exported.
If any information is missing in payment line system notifies about it. If there is incorrect information in a field, for example Recipient Bank Account is not valid, status of Payment Order Status changes to ERROR and Error message field fills with the reason of not exporting payment.
Note. Bank Payments we can receive and send in/to foreign currencies. When paying to in foreign currency, Recipient Bank must have filled Country/Region code, City, and Address on Vendor Bank Account Card.