Reporting
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 |
Updated 12 days ago