Merchant Reports

The following reports are available in the Merchant Portal Report section:

  • Merchant Collections File - Merchant collection files are only available when 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 RTP transactions are enabled.
  • ACH & EFT Return - Generate and download Automated Clearing House (ACH) and Electronic Funds Transfer (EFT) Returns reports.
  • VIP Program - The report is only available to merchants who have the VIP Program enabled.

Report File Naming Format

The format for report files cannot be changed in the system. The following are the report file formats:

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 what bank holidays are applicable 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 AM UTC Monday - Friday (excluding holidays). An additional report is generated and delivered on Saturday for funding reports that use the EFT rail. Reports are accessible 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 and 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 SFTP site during integration. A compressed file of all available reports in CSV format is automatically generated daily and is available on the SFTP site by 11 AM UTC.