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.
| 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 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
- Sign in to the Merchant Portal, 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 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.
Updated 15 days ago