Generate reports

Trustly offers the following reports for transaction management:

Funding Report This report contains all funds transferred (credits and debits) and all transactions that are part of a batch sent to the merchant’s bank account for the reporting period.
Settlement Reconciliation This report contains all transactions that were created during the reporting period.
RTP Settlement Reconciliation This is a separate reconciliation report that contains only Real-Time Payment (RTP) transactions created for the specific period. This report is available only to merchants using RTP functionality.

Report availability and delivery

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

You can receive reports in one of two ways:

Reports are available on a Secure File Transfer Protocol (SFTP) site hosted by Trustly. To request access, contact your Trustly integration team.
You download reports 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 since the last reporting window. It correlates all transactions that belong to a net settlement and the bank funding activity.

Item records that affect future settlements do not have a Funding Trace ID. These records represent status updates rather than funds movement, so they display a zero amount and are excluded from the current settlement total.

File format

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

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. Always `P11KFUN`.
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 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 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-5sq8ku8sm...`	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 contains.

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`	Yes	Transaction create date and time
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`	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`	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-5sq8ku8sm...`	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 the value of recurring records
Currency	3	Alphanumeric	No	`USD`	Currency of the total value of transaction records

RTP Settlement Reconciliation File

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

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`	Yes	Transaction create date and time
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`	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`	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-5sq8ku8sm...`	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 the value of recurring records
Currency	3	Alphanumeric	No	`USD`	Currency of total value of transaction records