File spec

Column	Description	Data Type	Format	Contraints	Example
Customer name	Name of customer	String	Alphanumeric	Mandatory, Max length: 50 characters	Payment Bank
Transfer ID	Unique ID of the transfer defined by ReadyRemit	String	UUID	Mandatory, Valid UUID format	f592edb9-f094-49cc-8f00-7c4168b80ed8
Confirmation number	Unique ID of the transfer defined by the remittance service provider	String	Alphanumeric	Mandatory, Max length: 50 characters	33TF030740448
Transfer date time	Date and time the transfer was originally submitted	DateTime	MM/dd/yyyy hh:mm:ss tt	Mandatory, Eastern Time (EST/EDT)	10/03/2022 11:19:31 AM
Sender name	Full name of the sender	String	Text	Mandatory, Max length: 200	John Doe
Recipient name	Full name of recipient	String	Text	Mandatory, Max length: 200	Jane Doe
Send amount	Total amount sent by the user	Decimal	Numeric	Mandatory, 2 decimal places, no thousands separator	150.00
Transfer fee	Total fee amount	Decimal	Numeric	Mandatory, 2 decimal places, no thousands separator	3.00
Total debit amount	Total send amount + fee	Decimal	Numeric	Mandatory, 2 decimal places, no thousands separator	153.00
Proxy number	Card proxy number (available if ingested during transfer)	String	Alphanumeric	Optional, Max length: 30 characters	ABC123XYZ
RSP Name	Remittance service provider that was used for the original transfer of funds	String	Text	Mandatory, Max length: 50	Transpay
FX Rate	Total FX rate charged for the payment	Decimal	Numeric	Mandatory, Up to 4 decimal places	0.89
Transfer Method	Modality used for the payment	String	Alphanumeric	Mandatory	PUSH_TO_CARD, BANK_ACCOUNT, CASH_PICKUP, MOBILE_WALLET
Destination Country	Country the funds were sent to	String	Alphanumeric	Mandatory, ISO3 country code	FRA
Destination Currency	Currency in which the recipient will receive the funds	String	Alphanumeric	Mandatory, ISO3 country code	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 ET (adjusts with daylight savings time)

📘
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].