Merchant Reports

Reports help you keep track of your transactions, funding, and reconciliation.

Available reports

The following reports available in the Merchant Portal Report section:

  • Merchant Collections File: This report is only available if a merchant has Merchant Collections configured in the admin portal.
  • Reconciliation & Funding: Generate and download Funding, Reconciliation, and Real-Time Payments (RTP) reports. The RTP report is only available when Real-Time Payment transactions are enabled.
  • ACH and EFT Return: Generate and download Automated Clearing House (ACH) and Electronic Funds Transfer (EFT) Returns reports.
  • VIP Program: This report is only available to merchants who have the VIP Program enabled.

Report file naming format

You can't change the format for report files in the system. The following table details the naming convention for each report file.

ReportFormatExample
FundingP11KFUN-{Merchant ID}-{Start date time}-{End date time}-{Sequence}.csvP11KFUN-9999999999-20220822080000-20220823080000-0001of0001.csv
ReconciliationP11KREC-{Merchant ID}-{Start date time}-{End date time}-{Sequence}.csvP11KREC-9999999999-20220822080000-20220823080000-0001of0001.csv
RTPP11KRTP-{Merchant ID}-{Start date time}-{End date time}-{Sequence}.csvP11KRTP-9999999999-20220822080000-20220823080000-0001of0001.csv
Bank Holiday InformationThe merchant's geographic location determines which bank holidays apply to transactions and reports. Contact your Customer Success Manager to identify your bank holidays.N/A

Access reports

All reports are provided in CSV format and are available at 11:00 AM UTC Monday through Friday (excluding holidays). Trustly generates and delivers an additional report on Saturday for funding reports that use the EFT rail. You can access reports in the Merchant Portal or from the Trustly secure file transfer protocol (SFTP) site.

Access reports on the Merchant Portal

  1. Sign in to the Merchant Portal, then expand Reports in the left pane.
  2. Select the report you want to generate.

Access reports on the SFTP

Merchants can request access to the Secure File Transfer Protocol (SFTP) site during integration. A compressed file of all available reports in CSV format automatically generates daily. This file is available on the SFTP site by 11:00 AM UTC.