Reporting

Trustly offers the following 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.
  3. Settlement Reconciliation
  4. RTP Settlement Reconciliation

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 Currency3AlphanumericYesUSD CADAmount 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 Currency3AlphanumericYesUSD CADAmount 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).

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


Did this page help you?