Transactions reconciliation
27. 12. 2024
To perform transactions reconciliation, a file with transactions from the external system should be uploaded.
File format should be csv and field names should be exactly as follows:
- transaction ID – transaction ID to look for transaction in the system.
- transaction date – transaction date in the format <code>YYYY-MM-DD</code>.
- transaction amount – transaction amount.
- transaction currency – currency code in ISO 4217 format (for example, USD, EUR).
Reconciliation file statuses:
| Status | Transition | Description |
| UPLOAD_FAILED | – | file was not uploaded |
| UPLOADED | IN_PROGRESS
EXCEPTION |
file is uploaded to the file storage |
| PARSED | RECONCILED | file is parsed and all data from file is stored in the database |
| PARSING_ERROR | – | error occurs during parsing and file cannot be parsed and no data can be stored in the database |
| PARTIALLY_PARSED | RECONCILED | some records are parsed and some records are not, for example if value in the file is longer than database accepts |
| IN_PROGRESS | PARSED
PARSING_ERROR PARTIALLY_PARSED |
parsing is in progress |
| RECONCILED | – | data from file were taken for the reconciliation |
| EXCEPTION | – | any other exception occurred during file uploading or parsing |
During transactions reconciliation process, the system compares transactions from file with transactions in the system for the specified period and generates the following reconciliation mismatches:
- Transaction not found – transaction is present in the file but is not found in the system for the specified period.
- Wrong amount – transaction amount in the file is different from the transaction amount in the system.
- Wrong currency – currency code in the file is different from the currency in the system.
- Wrong date – date from the file is different from the date in the system.
- Wrong transaction status – transaction status in the system is not “Processed”.
Users can resolve reconciliation mismatches. This action will just change mismatch status.
Transactions reconciliation manual
Upload reconciliation file
- Perform system authorization as a service user with appropriate permission
- Open the “CFO” → “Reconciliation” menu
- Switch to the tab “Files”
- Click the button “Upload file”
- In the opened side-bar
- Upload file
- Choose file format from the drop-down
- Click the button “Upload file”
View list of reconciliation files
- Perform system authorization as a service user with appropriate permission
- Open the “CFO” → “Reconciliation” menu
- Switch to the tab “Files”
Run reconciliation
- Perform system authorization as a service user with appropriate permission
- Open the “CFO” → “Reconciliation” menu
- Fined reconciliation record with “Transaction Reconciliation” type
- On the founded record, click the “View details button”
- In the opened “Transaction reconciliation” menu click the button “Start reconciliation”
- In the opened side-bar
- Choose the required files
- Specify the period for reconciliation
- Click the button “Start Reconciliation”
View list of transaction reconciliations
- Perform system authorization as a service user with appropriate permission
- Open the “CFO” → “Reconciliation” menu
- Fined reconciliation record with “Transaction Reconciliation” type
- On the founded record, click the “View details button”
Check the Back office manual for transaction reconciliation.