Transactions reconciliation

To perform transaction reconciliation, a file with transactions from the external system should be uploaded.

The file format should be csv and field names should be exactly as follows:

• transaction ID – transaction ID to look for transactions 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	-the	file was not uploaded
UPLOADED	IN_PROGRESS EXCEPTION	file is uploaded to the file storage
PARSED	RECONCILED	file is parsed and all data from the 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 the database accepts
IN_PROGRESS	PARSED PARSING_ERROR PARTIALLY_PARSED	parsing is in progress
RECONCILED	–	data from the file were taken for the reconciliation
EXCEPTION	–	any other exception occurred during file uploading or parsing

Check out this demo video about Reconciliation:

Check out this video demo case about two files in one Reconciliation process:

During the transactions reconciliation process, the system compares transactions from the file with transactions in the system for the specified period and generates the following reconciliation mismatches:

• Transaction not found – The transaction is present in the file but is not found in the system for the specified period.
• Wrong amount – The transaction amount in the file is different from the transaction amount in the system.
• Wrong currency – the currency code in the file is different from the currency in the system.
• Wrong date – the 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 the 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.