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:
Report | Format | Example |
---|---|---|
Funding | P11KFUN-{Merchant ID}-{Start date time}-{End date time}-{Sequence}.csv | P11KFUN-9999999999-20220822080000-20220823080000-0001of0001.csv |
Reconciliation | P11KREC-{Merchant ID}-{Start date time}-{End date time}-{Sequence}.csv | P11KREC-9999999999-20220822080000-20220823080000-0001of0001.csv |
RTP | P11KRTP-{Merchant ID}-{Start date time}-{End date time}-{Sequence}.csv | P11KRTP-9999999999-20220822080000-20220823080000-0001of0001.csv |
Bank Holiday Information | The 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
- Sign in to the merchant portal and then expand Reports in the left pane.
- 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.
Updated 3 days ago