Reporting
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). |
Updated 8 months ago