Realtime Bank - User Guide
Table of Contents
- Setup
- Transmitting Payments
- Incoming Bank Messages
- Processing Bank Account Transactions
- LinkPay User Guide
Setup
Setup Bank Connetors
The following connectors are supported out-of-the-box:
- Swedbank Gateway
- SEB Baltic Gateway
- LHV Connect
- Coop Pank Gateway
- Luminor Web Service
Instructions to join with the service can be found here.
Each has its own setup card. Please open the setup of your bank connector and enter the following information:
Field | Description |
– | –
Service URL | Enter the address of bank service.
Swedbank - https://psd2.api.swedbank.com/partner/v1/sgw/
SEB - https://api.bgw.baltics.sebgroup.com/
LHV - https://connect.lhv.eu/
Coop Pank - https://cpgw.cooppank.ee/
Authorization/Device Certificate Filename | Import certificate file (pfx/p12 format). Certifcate will be given by bank.
Authorization/Device Certificate Password | Enter certificate password.
Encryption Certificate (for Swedbank) | Certificate can be downloaded here: http://dev.swedbankgateway.net/info#certificates
Agreement Id/Customer Id | Details from the bank agreement.
Setup Bank Account
Open Bank Account card and choose the connector in the Bank Connector field. If no connector is specified, the transaction information for this bank account will not be pulled into Business Central.
On the Bank Account card, there is a button Set Starting Date for Bank Connector, where you have to set the date of switching to Realtime Bank and the opening balance in the bank on that day.
Setup Realtime Bank
Open Realtime Bank Setup and assign the number series for the Posted Transaction Nos. field.
In the Application Logic field, select Payment Reconciliation Journal. Other application methods will not be supported and will be removed in the future.
Transmitting Payments
On the Payment Journal page you can create payments to be sent to the bank. By clicking on the “Transmit to bank…” button under the Bank tab, the report request page opens. Here, it is possible to activate the function Wait for processing result. In this case, the system will wait for the first payment status response from the bank. All the payments in the journal will be combined into one Credit Transfer Register and transmitted to the bank.
Recommendation from Microsoft: After the transmitting payments to the bank, all lines in the Payment Journal should be deleted. The payments should only be posted in the Payment Reconciliation Journal once the payments have been declared correct by the bank.
You can find the exported payment files on the same page using the button, or by searching the view, Credit Transfer Registers. Under the field No. of Transfers, all the transactions of the journal are recorded separately, as well as the payment status for each transaction.
If the user’s role is Accountant, they will have a Real-time bank cue in the Role Center. Information regarding rejected and pending payments will be displayed there. On the Rejected Payments page, each payment can be individually marked as hidden using the “Hide/Unhide” button - this will remove the problematic payment from the Role Center overview.
Incoming Bank Messages
Get bank messages automatically
To get bank messages press the button Get New Bank Messages or setup Job Queue Entries on the bank connector setup page. The process imports new bank statements to the page Incoming Bank Messages. This page is opened with filters: Source and Status.
Clicking on the “Job Queue Entries” button opens the Job Queue Entries page, where you can configure two automatic jobs:
- retrieving bank messages from the bank, and
- processing bank messages (incl. applying and posting transactions).
By default, messages that have not yet been processed are displayed. Use the “Show all Messages” to see all entries.
Import bank statement manually
You can manually import the bank statement file on the Incoming Bank Messages page by clicking the Import From File button. The entry is in the Received status.
Processing bank messages
To process the file click Process button.
Then click “Show All Messages” and choose the line.
You see the status – Processed and No. of Saved Transactions.
By pressing this number it is possible to go to the Bank Account Transactions.
Processing Bank Account Transactions
Bank Account Transactions
In Bank Account card there is a new field Balance in Bank. Drilldown in this field to open Bank Account Transactions. By default you can see unposted transactions which need to be applied before they can be posted.
The number of rejected payments is displayed in the Realtime Bank cue in the Role Center. When the page is opened, it is possible to mark each payment as hidden using the button Hide/Unhide, which removes the payment from the overview.
Applying Service Fees
You can use Text-To-Account functionality.
Applying Invoices
Appying can be done either manually or automatically.
For manual application, assign Applied Account No. and click Apply Manually. This will open the list of open ledger entries. Apply entries by clicking Process->Set Applies-to ID.
For automatic application run the action Apply Automatically.
Posting
Applied transaction can be posted to ledger entries by clicking Post action.
In addition Job Queue Entry can be configured, which posts transactions automatically when transaction has been applied and Application Status (quality) is ‘High Confidence’.
Contact Information
For more information and pricing please contact:
https://apps.itera.ee/docs/en-us/support