Reporting

Trustly offers 2 reports for your consumption:

  1. Transaction Records File. This report echos any transactions that were created or updated during the reporting period.
  2. Settlement Funding File. This report provides an overview of transactions that make up any batch settlements or withdrawals to your settlement bank account.

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 NameMax LengthFormatRequiredSample DataNotes
Record Type Indicator1HYesHAlways H
Magic7P11KFUNYesP11KFUNMagic number
Version11AlphanumericYes1.0.0File version
Start Date24UTC Date Time in ISO 8601 formatYes2017-01-21T12:00:00ZReport start date
End Date24UTC Date Time in ISO 8601 formatYes2017-01-22T12:00:00ZReport end date
Merchant ID50NumericYes10000000234Merchant identifier
Sequence10NNNNofNNNNYes0001of0002File sequence. A report can be broken into multiple files

Funding Record

Field NameMax LengthFormatRequiredSample DataNotes
Record Type Indicator1FYesFAlways F
Processor50AlphanumericYesProfitStarsPayment processor
Reserved0NoReserved for future use
Funding Trace ID50AlphanumericYesA12341234Funding trace identifier. Link between funding record and item record
Amount Currency3AlphanumericYesUSDAmount currency
Amount18Decimal StringYes-100.00Amount
Funding Date24UTC Date Time in ISO 8601 formatYes2017-01-21T13:42:03ZFunding date and time

Item Record

Field NameMax LengthFormatRequiredSample DataNotes
Record Type Indicator1IYesIAlways I
Transaction ID50AlphanumericYes100000234235Transaction identifier
Transaction Created At24UTC Date Time in ISO 8601 formatYes2017-01-21T13:42:03Z Transaction create date and time
Parent Transaction ID50AlphanumericYes100000234234Parent Transaction identifier
Merchant ID50NumericYes10000000234Merchant identifier
Payment Provider Type20NumericYes1Payment provider type
Payment Provider ID9AlphanumericYes023456737Payment provider identifier
Payment Account4NumericYes1234Last 4 digits of the payment account
Merchant Reference90AlphanumericNoMREF122344Merchant reference
Transaction Type30AlphanumericYesRefundTransaction type
Transaction Status30AlphanumericYesAuthorizedTransaction status
Transaction Updated At24UTC Date Time in ISO 8601 formatYes2017-01-21T23:42:03ZTransaction last update date and time
Transaction Processed At24UTC Date Time in ISO 8601 formatYes2017-01-21T23:42:03ZTransaction processed date and time
Amount Currency3AlphanumericYesUSDAmount currency
Amount18Decimal StringYes-100.00Amount
Funding Trace ID50AlphanumericNoA12341234Funding trace identifier
Payment Provider Transaction Status5AlphanumericNoR03Payment provide transaction status. For returned items it is the return reason code
Batch ID50AlphanumericNo3424Batch id representing a group of transactions
Settlement Type3AlphanumericNo20Internal
Parent Merchant Reference90AlphanumericNoMREF122Merchant reference of the parent transaction
Payment Provider Transaction ID40AlphanumericNoptx-5sq8ku8smVrss6Pc7-cOVBbI-Payment Provider Transaction ID. Sent as ID to the ACH processor.
Transaction Fee18Decimal StringNo-0.29Fee that was deducted from the funding of the transaction. NOTE This is only applicable if you are participating in Net Settlement.

Trail

Field NameMax LengthFormatRequiredSample DataNotes
Record Type Indicator1LYesLAlways L
Num Item Records9NumericYes300Total count of the item records
Total Items Amount18Decimal StringYes100.00Total sum of the transaction records amount
Total Funding Records9NumericYes300Total count of the funding records
Total Funding Amount18Decimal StringYes100.00Total sum of the funding records amount, less any transaction fees (if participating in Net Settlement).

Did this page help you?