Reconciliation & Funding report

The Reconciliation & Funding report lists all transactions that were created during the reporting period. Real-Time Payment (RTP) transactions are excluded.

Generate the Reconciliation & Funding report

  1. Sign in to the Merchant Portal, then expand Reports in the left pane.

  2. Select Reconciliation & Funding.

  3. Select a start date and an end date.

    The report period can't be greater than 31 days due to file size. To retrieve transactions or settlements for a specific day, select the following business day. For example, selecting a start date of 08/23/2022 and an end date of 08/23/2022 provides all transactions created on 8/22 for the Reconciliation Report and all settlements that occurred on 8/22 for the Funding Report.

  4. Select the report timezone.

    The timezone option only determines the date and time the report displays. It doesn't determine which transactions Trustly includes. Trustly always retrieves transactions from 12:00 PM to 11:59 AM Coordinated Universal Time (UTC) on the selected days. If you select a specific time zone, the time converts from UTC to your chosen time zone.

  5. Select the report output:

    • Download: Downloads a compressed file to your computer.
    • SFTP: Generates a compressed file on the merchant's Secure File Transfer Protocol (SFTP) site.
  6. Click Generate.

Read the Reconciliation & Funding report

The Reconciliation Report consists of individual rows of data. Each row provides one of three types of data, identified by a Record Type Indicator:

  • Header (H)
  • Transaction Record (T)
  • Trail (L)

Every report begins with the Header and ends with the Trail. All transaction records in the report reflect the transactions created during the reporting period. The transaction status reflects the current status for that record.

Some transactions have a Parent Transaction ID, or original transaction identifier, as shown in the following example.

In this case, the original transaction was an authorization, and the child transaction was the capture.

The Trail shows the total number of transactions that were part of the report and the total amount of the transactions created during the reporting period.

Reconciliation & Funding report fields

Each line in the Reconciliation File is prefixed with a Record Type Indicator that dictates the type of information it conveys.

Header

The first line of the report is always the Header. For example:

The following table lists the fields and information contained in the Header.

Field nameMax lengthFormatRequiredSample dataNotes
Record Type Indicator1HYesHAlways H.
Magic7P11KRECYesP11KRECMagic number. Always P11KREC.
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 break into multiple files.

Transaction record

A transaction record provides details for an event that occurred with the merchant. For example:

The following table lists the fields and information contained in the transaction record.

ColumnField NameMax LengthFormatRequiredSample DataNotes
ARecord Type Indicator1TYesTAlways T to label the row as a transaction
BTransaction ID50AlphanumericYes10000023423Unique Trustly Identifier.
CTransaction Created At Date24UTC Date Time in ISO 8601 formatYes2017-01-21T13:42:03ZTransaction creation date and time.
DParent Transaction ID50AlphanumericYes100000234234Reference to the original transaction.
EMerchant ID50NumericYes10000000234Merchant Identifier.
FPayment Type2NumericYes1Online Banking or Manual Entry.
GPayment Provider Type20NumericYes1Trustly payment provider type.
HPayment Provider ID9AlphanumericYes023456234Trustly payment provider identifier.
IPayment Account4NumericYes1234Last four digits of the consumer payment account.
JMerchant Reference90AlphanumericNoMREF122344Reference passed to Trustly by the merchant to identify a transaction.
KTransaction Type30AlphanumericYesRefundSee Transaction Types
LTransaction Status30AlphanumericYesAuthorizedSee Transaction Status.
MTransaction Updated At24UTC Date Time in ISO 8601 formatYes2017-01-21T23:42:03ZLast update date and time to the transaction status.
NAmount Currency3AlphanumericYesUSDTransaction amount currency.
OAmount18Decimal StringYes-100.00Transaction amount.
PRecurring Start Date24UTC Date Time in ISO 8601 formatYes2017-01-21T23:42:03ZRecurring start date and time. Only for recurring payments.
QRecurring End Date24UTC Date Time in ISO 8601 formatYes2017-01-22T23:42:03ZRecurring end date and time. Only for recurring payments.
RRecurring Frequency20NumericYes2How many payments per frequency unit.
SRecurring Frequency Unit Type1NumericYes2Along with frequency, Unit Type defines the interval of the frequency of payments.
TCurrency3AlphanumericYesUSDTransaction currency..
URecurring Amount18Decimal stringYes100.00Recurring transaction amount.
VRecurring AutomaticN/ABooleanYesTrueAutomatic recurring or not.
WPayment Provider Transaction ID40AlphanumericNoptx-5sq8ku8smVrss6Pc7-cOVBbI-Trustly identifier for the transaction ID with the payment provider.

Trail

The Trail indicates the end of the report and is a summation of the records within the report. For example:

The following table lists the fields and information contained in the 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 Recurring Amount18Decimal StringYes300.00Total amount of recurring transactions.
Currency3AlphanumericNoUSDCurrency of total value of financing records.