File Based Settlements

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.

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	DateTime `yyyy-MM-dd`
`Settlement_Date`	Date of end of settlement when payment arrives at Liberis (for Unsettled transactions)	DateTime `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