Trustly offers the following reports for your consumption:

Settlement Funding File. This report contains all funds transferred (credits and debits) with all transactions that are part of a batch sent to the merchant's bank account for the reporting period.
Settlement ReconciliationThis report contains all transactions that were created during the reporting period.
RTP Settlement Reconciliation This is a separate reconciliation report that contains only RTP transactions created for the specific period. It is enabled only for merchants using RTP functionality.

Report Availability

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

Report Delivery

Reports can either be delivered to an 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 in 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 affect 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` `CAD`	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 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` `CAD`	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 provider 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).

Settlement Reconciliation File

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

Header (Required)

Field Name	Max Length	Format	Required	Sample Data	Notes
Record Type Indicator	1	H	Yes	H	Always H
Magic	7	P11KREC	Yes	P11KREC	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-21T12: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

Transactions Record

Field Name	Max Length	Format	Sample Data	Required	Notes
Record Type Indicator	1	T	T	Yes	Always T
Transaction ID	50	Alphanumeric	100000234235	Yes	Transaction identifier
Transaction Created At	24	UTC Date Time in ISO 8601 format	2017-01-21T13:42:03Z Transaction create date and time	Yes
Parent Transaction ID	50	Alphanumeric	100000234234	Yes	Parent transaction identifier
Merchant ID	50	Numeric	10000000234	Yes	Merchant identifier
Payment Type	2	Numeric	1	Yes	Payment type
Payment Provider Type	20	Numeric	1	Yes	Payment provider type
Payment Provider ID	9	Alphanumeric	023456737	Yes	Payment provider identifier
Payment Account	4	Numeric	1234	Yes	Last 4 digits of the payment account
Merchant Reference	90	Alphanumeric	MREF122344	No	Merchant reference
Transaction Type	30	Alphanumeric	Refund	Yes	Transaction type
Transaction Status	30	Alphanumeric	Authorized	Yes	Transaction status
Transaction Updated At	24	UTC Date Time in ISO 8601 format	2017-01-21T23:42:03Z	Yes	Transaction last update date and time
Amount Currency	3	Alphanumeric	USD CAD	Yes	Amount currency
Amount	18	Decimal String	-100.00	Yes	Amount
Recurring Start Date	24	UTC Date Time in ISO 8601 format	2017-01-21T23:42:03Z	Yes	Recurring start date and time
Recurring End Date	24	UTC Date Time in ISO 8601 format	2017-01-21T23:42:03Z	Yes	Recurring end date and time
Recurring Frequency	20	Numeric	2	Yes	Recurring frequency
Recurring Frequency Unit Type	1	Numeric	2	Yes	Recurring frequency type
Currency	3	Alphanumeric	USD CAD	Yes	Currency
Recurring Amount	18	Decimal String	-100.00	Yes	Recurring Amount
Recurring Automatic	N/A	Boolean	True	Yes
Payment Provider Transaction ID	40	Alphanumeric	ptx-5sq8ku8smVrss6Pc7-cOVBbI-	No	Payment Provider Transaction ID. Sent as ID to the ACH processor.

Trail (Required)

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 Recurring Amount	18	Decimal String	Yes	100.00	Total sum of value of records recurring
Currency	3	Alphanumeric	No	USD CAD	Currency of total value of financing records

RTP Settlement Reconciliation File

This report only available if RTP is configured for merchant. Each line in the Reconciliation File is prefixed with a Record Type Indicator that dictates the type of information it is conveying.

Header (Required)

Field Name	Max Length	Format	Required	Sample Data	Notes
Record Type Indicator	1	H	Yes	H	Always H
Magic	7	P11KRTP	Yes	P11KRTP	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-21T12: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

Transactions Record

Field Name	Max Length	Format	Sample Data	Required	Notes
Record Type Indicator	1	T	T	Yes	Always T
Transaction ID	50	Alphanumeric	100000234235	Yes	Transaction identifier
Transaction Created At	24	UTC Date Time in ISO 8601 format	2017-01-21T13:42:03Z Transaction create date and time	Yes
Parent Transaction ID	50	Alphanumeric	100000234234	Yes	Parent transaction identifier
Merchant ID	50	Numeric	10000000234	Yes	Merchant identifier
Payment Type	2	Numeric	1	Yes	Payment type
Payment Provider Type	20	Numeric	1	Yes	Payment provider type
Payment Provider ID	9	Alphanumeric	023456737	Yes	Payment provider identifier
Payment Account	4	Numeric	1234	Yes	Last 4 digits of the payment account
Merchant Reference	90	Alphanumeric	MREF122344	No	Merchant reference
Transaction Type	30	Alphanumeric	Refund	Yes	Transaction type
Transaction Status	30	Alphanumeric	Authorized	Yes	Transaction status
Transaction Updated At	24	UTC Date Time in ISO 8601 format	2017-01-21T23:42:03Z	Yes	Transaction last update date and time
Amount Currency	3	Alphanumeric	USD CAD	Yes	Amount currency
Amount	18	Decimal String	-100.00	Yes	Amount
Recurring Start Date	24	UTC Date Time in ISO 8601 format	2017-01-21T23:42:03Z	Yes	Recurring start date and time
Recurring End Date	24	UTC Date Time in ISO 8601 format	2017-01-21T23:42:03Z	Yes	Recurring end date and time
Recurring Frequency	20	Numeric	2	Yes	Recurring frequency
Recurring Frequency Unit Type	1	Numeric	2	Yes	Recurring frequency type
Currency	3	Alphanumeric	USD CAD	Yes	Currency
Recurring Amount	18	Decimal String	-100.00	Yes	Recurring Amount
Recurring Automatic	N/A	Boolean	True	Yes
Payment Provider Transaction ID	40	Alphanumeric	ptx-5sq8ku8smVrss6Pc7-cOVBbI-	No	Payment Provider Transaction ID. Sent as ID to the ACH processor.

Trail (Required)

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 Recurring Amount	18	Decimal String	Yes	100.00	Total sum of value of records recurring
Currency	3	Alphanumeric	No	USD CAD	Currency of total value of financing records