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
USDCAD
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
USDCAD
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.