Trustly offers 2 reports for your consumption:

Transaction Records File: This report echos any transactions that were created or updated during the reporting period.
Settlement Funding File: This report provides an overview of transactions that make up any batch settlements or withdrawals to your settlement bank account.
Settlement Reconciliation File:
RTP Settlement Reconciliation File:

Report Availability

Reports are available daily by 10:00 AM Eastern Time.

Report Delivery

Reports can either be delivered to a SFTP site hosted by Trustly, or downloaded from our Merchant Portal.

Settlement Funding File

The Settlement Funding File reports the funds transferred into (positive net settlement) or from (negative net settlement) the merchant bank account on the period since the last report. It correlates all transactions that are part of a net settlement and the bank funding activity.

Item records without funding trace id are to report status changes that affects future settlements and will be reported with amount as zero as they are not part of a settlement.

File Format

Each line in the Funding File is prefixed with a Record Type Indicator that dictates the type of information it is conveying.

Header

Field Name	Max Length	Format	Required	Sample Data	Notes
Record Type Indicator	1	`H`	Yes	`H`	Always `H`
Magic	7	`P11KFUN`	Yes	`P11KFUN`	Magic number
Version	11	Alphanumeric	Yes	`1.0.0`	File version
Start Date	24	UTC Date Time in ISO 8601 format	Yes	`2017-01-21T12:00:00Z`	Report start date
End Date	24	UTC Date Time in ISO 8601 format	Yes	`2017-01-22T12:00:00Z`	Report end date
Merchant ID	50	Numeric	Yes	`10000000234`	Merchant identifier
Sequence	10	`NNNNofNNNN`	Yes	`0001of0002`	File sequence. A report can be broken into multiple files

Funding Record

Field Name	Max Length	Format	Required	Sample Data	Notes
Record Type Indicator	1	`F`	Yes	`F`	Always `F`
Processor	50	Alphanumeric	Yes	`ProfitStars`	Payment processor
Reserved	0		No		Reserved for future use
Funding Trace ID	50	Alphanumeric	Yes	`A12341234`	Funding trace identifier. Link between funding record and item record
Amount Currency	3	Alphanumeric	Yes	`USD`	Amount currency
Amount	18	Decimal String	Yes	`-100.00`	Amount
Funding Date	24	UTC Date Time in ISO 8601 format	Yes	`2017-01-21T13:42:03Z`	Funding date and time

Item Record

Field Name	Max Length	Format	Required	Sample Data	Notes
Record Type Indicator	1	`I`	Yes	`I`	Always `I`
Transaction ID	50	Alphanumeric	Yes	`100000234235`	Transaction identifier
Transaction Created At	24	UTC Date Time in ISO 8601 format	Yes	`2017-01-21T13:42:03Z` Transaction create date and time
Parent Transaction ID	50	Alphanumeric	Yes	`100000234234`	Parent Transaction identifier
Merchant ID	50	Numeric	Yes	`10000000234`	Merchant identifier
Payment Type	12	Alphanumeric	Yes	Disbursement
Payment Provider Type	20	Numeric	Yes	`1`	Payment provider type
Payment Provider ID	9	Alphanumeric	Yes	`023456737`	Payment provider identifier
Payment Account	4	Numeric	Yes	`1234`	Last 4 digits of the payment account
Merchant Reference	90	Alphanumeric	No	`MREF122344`	Merchant reference
Transaction Type	30	Alphanumeric	Yes	`Refund`	Transaction type
Transaction Status	30	Alphanumeric	Yes	`Authorized`	Transaction status
Transaction Updated At	24	UTC Date Time in ISO 8601 format	Yes	`2017-01-21T23:42:03Z`	Transaction last update date and time
Transaction Processed At	24	UTC Date Time in ISO 8601 format	Yes	`2017-01-21T23:42:03Z`	Transaction processed date and time
Amount Currency	3	Alphanumeric	Yes	`USD`	Amount currency
Amount	18	Decimal String	Yes	`-100.00`	Amount
Funding Trace ID	50	Alphanumeric	No	`A12341234`	Funding trace identifier
Payment Provider Transaction Status	5	Alphanumeric	No	`R03`	Payment provide transaction status. For returned items it is the return reason code
Batch ID	50	Alphanumeric	No	`3424`	Batch id representing a group of transactions
Settlement Type	3	Alphanumeric	No	`20`	Internal
Parent Merchant Reference	90	Alphanumeric	No	`MREF122`	Merchant reference of the parent transaction
Payment Provider Transaction ID	40	Alphanumeric	No	`ptx-5sq8ku8smVrss6Pc7-cOVBbI-`	Payment Provider Transaction ID. Sent as ID to the ACH processor.
Transaction Fee	18	Decimal String	No	`-0.29`	Fee that was deducted from the funding of the transaction. *NOTE* This is only applicable if you are participating in Net Settlement.

Trail

Field Name	Max Length	Format	Required	Sample Data	Notes
Record Type Indicator	1	`L`	Yes	`L`	Always `L`
Num Item Records	9	Numeric	Yes	`300`	Total count of the item records
Total Items Amount	18	Decimal String	Yes	`100.00`	Total sum of the transaction records amount
Total Funding Records	9	Numeric	Yes	`300`	Total count of the funding records
Total Funding Amount	18	Decimal String	Yes	`100.00`	Total sum of the funding records amount, less any transaction fees (if participating in Net Settlement).