SFTP File Exchange
Liberis allows settlement records to be shared through Liberis' SFTP, using a Liberis owned schema CSV. A daily record of the previous days aggregated revenue and the split paid to Liberis for active deal merchants must be submitted through the Liberis SFTP server for ingestion.
Location: /Inbound/Reconciliation/
Recommended file name: daily_reconciliation_{yyyyMMdd}.csv - optionally, the date could include time yyyyMMddHHmmss
Any .csv file uploaded to the shared location will be treated as a settlement file and processed automatically, provided the file name is unique. Although not required, using a meaningful file name helps speed up issue diagnosis and resolution.
We also recommend not modifying files after they are uploaded. If you encounter unusual or irregular issues, please contact us so we can assist with manual resolution.
Access to Liberis SFTP is granted during integration for File Transfer.
Templates
Daily Reconciliation File - Empty Template
Daily Reconciliation File - Filled Template
File format
Liberis ESplit File Exchange
| Column | Description | Format |
|---|---|---|
Transaction_Date | Date of transaction | Date Only
|
Settlement_Date | Date of end of settlement when payment arrives at Liberis (for Unsettled transactions) | Date Only
|
Liberis_ID | Liberis Company ID | GUID |
Application_ID | Liberis Application ID | GUID |
Company_ID | Partner's internal ID for merchant | String |
Payment_Channel_ID | Payment Channel id, source of TX | String |
Transaction_Reference | OPTIONAL - Reference of settlement in merchant's bank account | String |
Currency | Currency of transaction - ISO standard | String |
Transaction_Amount | Raw transaction value prior to split For Settled transactions, this is the total of settlement period transaction_amounts | Double |
Split_Percentage | Split percentage sent to Liberis for repayment | Integer |
Repayment_Amount | Transaction_Amount * (Split_Percentage / 100) For Settled transactions, total of settlement period transactions repayment_amounts | Double |
Transaction_Type | one of:
| String |
Batch_ID | OPTIONAL - Allows Liberis to reconcile batch payment. If partner settles >T+1, this MUST be provided | String |
Flow
