Trustly offers the following reports for transaction management:
- Funding Report This report contains all funds transferred (credits and debits) and all transactions that are part of a batch sent to the merchant's bank account for the reporting period.
- Settlement Reconciliation This report contains all transactions that were created during the reporting period.
- RTP Settlement Reconciliation This is a separate reconciliation report that contains only Real-Time Payment (RTP) transactions created for the specific period. This report is available only to merchants using RTP functionality.
Reports are available daily by 10:00 AM Eastern Time.
You can receive reports in one of two ways:
- Reports are available on a Secure File Transfer Protocol (SFTP) site hosted by Trustly. To request access, contact your Trustly integration team.
- You download reports from our Merchant portal.
The Settlement Funding File reports the funds transferred into (positive net settlement) or from (negative net settlement) the merchant bank account since the last report. It correlates all transactions that belong to a net settlement and the bank funding activity.
Item records that affect future settlements do not have a Funding Trace ID. These records represent status updates rather than funds movement, so they display a zero amount and are excluded from the current settlement total.
Each line in the Funding File is prefixed with a Record Type Indicator that dictates the type of information it contains.
| 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. Always P11KFUN. |
| 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. |
| 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 |
| 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 | 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-5sq8ku8sm... | 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. |
| 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). |
Each line in the Reconciliation File is prefixed with a Record Type Indicator that dictates the type of information it contains.
| 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 |
| 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 | Yes | Transaction create date and time |
| 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 | 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 | 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-5sq8ku8sm... | No | Payment Provider Transaction ID. Sent as ID to the ACH processor. |
| 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 the value of recurring records |
| Currency | 3 | Alphanumeric | No | USD | Currency of the total value of transaction records |
This report is only available if RTP is configured for the merchant. Each line in the Reconciliation File is prefixed with a Record Type Indicator that dictates the type of information it contains.
| 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 |
| 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 | Yes | Transaction create date and time |
| 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 | 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 | 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-5sq8ku8sm... | No | Payment Provider Transaction ID. Sent as ID to the ACH processor. |
| 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 the value of recurring records |
| Currency | 3 | Alphanumeric | No | USD | Currency of total value of transaction records |
