Daily Transfers Report
Customer transfers conducted within a twenty-four-hour period are documented in a Daily Transfer Report. This report, provided by ReadyRemit in CSV format, can be delivered to the customer every morning via email or SFTP.
File spec
| Column | Description | Format | Example |
|---|---|---|---|
| Customer name | Name of customer | String | BWP Shipping |
| Transfer ID | Unique ID of the transfer defined by ReadyRemit | String | f592edb9-f094-49cc-8f00-7c4168b80ed8 |
| Confirmation number | Unique ID of the transfer defined by the remittance service provider | String | 33TF030740448 |
| Transfer date time | Date and time the transfer was originally submitted (in UTC) | MM/dd/YYYY hh:mm:ss tt | 10/03/2022 11:19:31 AM |
| Sender name | Full name of the sender | String | John Doe |
| Recipient name | Full name of recipient | String | Jane Doe |
| Send amount | Total amount sent by the user | Number with 2 decimal places | 150.00 |
| Transfer fee | Total fee amount | Number with 2 decimal places | 3.00 |
| Total debit amount | Total refund amount (send amount + fee) | Number with 2 decimal places | 153.00 |
| Proxy number | Card proxy number (available if ingested during transfer) | String | ABC123XYZ |
| RSP Name | Remittance service provider that was used for the original transfer of funds | String | Transpay |
| FX Rate | Total FX rate charged for the payment | Number with 2 decimal places | 0.89 |
| Transfer Method | Modality used for the payment | String | Push to Card |
| Destination Country | Country the funds were sent to | String | FRA |
| Destination Currency | Currency in which the recipient will receive the funds | String | EUR |
Optional Columns
FX Rate, Transfer Method, Destination Country, and Destination Currency are currently optional. We will be including them as part of the standard format and recommend including those columns for new customers.
File information
- File Name: The file will use the following naming convention:
Customer_ReadyRemit_Daily_Transfers_MMDDYY.csv - Header Row: The file will have a header row
- Summary Row: The last row of the transfers file will be a summary row with totals for Send amount, Transfer fee, and Total debit amount.
- Frequency: The file will be sent daily at 6:00AM EST (10:00 AM UTC)
Report Generation
The file is generated daily, regardless of whether any transfers occurred during the specified time period. If no transfers are found within the applicable timeframe, the report will include only the header row, with no accompanying data rows.
Summary Row
The last row of the file will be a summary row with totals for Send amount, Transfer fee, and Total debit amount. This row will not contain ID information for any specific transfer and should not be processed as a transfer.
Sample
Customer name,Transfer ID,Confirmation number,Transfer date time,Sender name,Recipient name,Send amount,Transfer fee,Total debit amount,Proxy number,RSP Name,FX Rate,Transfer Method,Destination Country,Destination Currency
BWP Shipping,18621432-79ad-4ca6-b9d3-cd3c819d40eb,4.32524E+11,11/20/24 18:34,Sender 1,Recipient 1,100,8,108,,Visa,0.89,PUSH_TO_CARD,FRA,EUR
BWP Shipping,03190626-5b06-461c-9cc4-45f3d50752b5,4.32523E+11,11/20/24 18:17,Sender 2,Recipient 2,100,8,108,,Visa,0.89,PUSH_TO_CARD,FRA,EUR
BWP Shipping,ad2326c2-ded8-4554-a994-fdd491915406,4.32523E+11,11/20/24 18:11,Sender 3,Recipient 3,100,8,108,,Visa,0.89,PUSH_TO_CARD,FRA,EUR
BWP Shipping,6f4a0c2b-b2f4-44cd-9d36-61b86c76e61a,4.32524E+11,11/20/24 18:04,Sender 4,Recipient 4,100,8,108,,Visa,0.89,PUSH_TO_CARD,FRA,EUR
,,,,,,400,32,432,,,,,,
Report Delivery
The daily transfers report can be delivered one of three ways:
1. Email
The quickest solution to receiving the daily transfers report is through email. An email address will be provided to the ReadyRemit integrations team and the report will be delivered daily as an attachment.
2. SFTP (pull)
If a more automated process is desired the daily transfers report can be delivered via SFTP. In the "pull" model, the ReadyRemit integrations team will provide you with SFTP credentials and you will provide ReadyRemit with a public key for encryption. Files will be dropped in the determined SFTP directory on a daily basis.
3. SFTP (push)
Similar to the pull model, in the SFTP push model a file is generated and dropped in an agreed upon SFTP directory. In this model you will provide the ReadyRemit team with SFTP credentials along with the public encryption key.
Next steps
To get started with the process of receiving the daily transfers report, please reach out to the ReadyRemit integrations team at [email protected].
Updated about 1 month ago