Overview
Bank statements are reconciled when payments are performed by the bank. The frequency of reconciliation is determined by the payment regulations of the enterprise.
First, outgoing payments that have already been created in the system are reconciled against bank statements items. Reconciliation is carried out using identification document numbers, currency, amount and other supporting data. The reconciled outgoing payments are automatically offset against the vendor's invoice amount.
Then a reconciliation results are checked on the level of total amounts of reconciled system documents.
If unauthorized payments are detected, such payments are created in the system manually.
There are often cases when the bank was unable to fulfill the payment. Such documents must be deleted from the system.
As a result of the process, the bank statements with outgoing payments are reconciled.
Video guide
Reconcile payments from bank statement without bank EDI flowchart
Paths
| Path | Treasury → Bank → Bank account payments |
|---|---|
| In-app link EN code |
e1cib/app/DataProcessor.DocumentsJournalBankAccountPayments
|
| In-app link RU code |
e1cib/app/Обработка.ЖурналДокументовБезналичныеПлатежи
|
How to reconcile payments from bank statement
1. Go to Treasury, then click Bank account payments under Bank.
2. In the Bank account payment workplace, select the Bank account, specify the period of the bank payment orders.
3. Select the Not processed by bank view mode.
4. For each bank statement transaction, find the Outgoing payment document with the relevant bank document ID number, currency, and amount.
5. Select the document and click Processed by bank button, specify the actual processing date by the bank statement. Click Ok.
How to check reconciliation results
1. In the Bank account payment workplace, specify the period of the bank payment orders.
2. At the bottom of the form, click the Statement reconciliation hyperlink.
3. In the Bank statement reconciliation report, compare the system data with the bank statement totals.
How to create outgoing payment manually
1. In the Bank account payment workplace, click Outgoing payments, select relevant Transaction.
2. In the Outgoing payment document, select the bank Document type, fill in payment data according to bank statement.
3. Fill in other required information, Post the document.
How to delete unprocessed payment orders
1. In the Bank account payment workplace, select the Bank account, specify the past period, enable the Not processed by bank view mode.
2. Select the Outgoing payment documents that the bank did not process, click More actions, and select Mark for deletion.