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 `yyyy-MM-dd`
`Settlement_Date`	Date of end of settlement when payment arrives at Liberis (for Unsettled transactions)	Date Only `yyyy-MM-dd`
`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: `Unsettled` `Settled`	String
`Batch_ID`	OPTIONAL - Allows Liberis to reconcile batch payment. If partner settles >T+1, this MUST be provided	String

Flow