In short
- Every business day you get two files: the Daily Transfers Report and the Cancellation Report.
- They list only what settled with the sponsor bank the previous business day.
- Use them to reconcile your prefunding account against your sponsor bank's records.
What these files are
-
Daily Transfers Report: one row for each transfer that settled in the previous settlement period.
-
Cancellation Report: one row for each cancellation (reversal) that settled in the previous settlement period. A cancellation is listed on the day the reversal settles, not on the date of the original transfer.
Every prefunding client gets both files.
| File |
Default file name |
| Daily Transfers Report |
Customer_ReadyRemit_Daily_Transfers_MMDDYY.csv |
| Cancellation Report |
Customer_ReadyRemit_Daily_Cancelled_Transfers_MMDDYY.csv |
-
Your own name: file names can be set for you and are agreed during implementation. Some files start with your institution's name instead of
Customer_. It's the same file.
-
The date:
MMDDYY is the day the file is delivered. The data inside is the previous business day's activity.
-
"ReadyRemit" stays in the name on purpose, so file handling you've already built keeps working.
-
Format: both files are CSV.
Delivery and timing
| File |
Arrives (ET) |
| Daily Transfers Report |
About 6:30 AM ET for most clients, or about 8:30 AM ET for clients on v2 files |
| Cancellation Report |
About 6:30 AM ET for most clients, or about 8:30 AM ET for clients on v2 files |
-
Business days: the files come every business day, at about 6:30 AM ET for most clients, or about 8:30 AM ET for clients on v2 files. The times adjust for daylight saving.
-
Mondays: Monday's files cover Friday through Sunday. If Monday is a federal holiday, the files come on Tuesday and cover Friday through Monday.
-
Quiet days: each file is still sent when there's no activity, as a header-only file. An empty file isn't an outage.
-
How: by SFTP. See Files you receive for how delivery works.
Setup
-
Delivery: by default you pull the files from an SFTP folder we host for you (we give you credentials and you give us a public key). We can push them to your own SFTP instead (you give us both), but that's a non-standard setup.
-
File names are agreed during implementation.
-
Starting setup: contact the Integrations Team. They confirm your delivery time and set up SFTP with you.
Columns
Daily Transfers Report
Twenty columns, one row per settled transfer.
| \# |
Column |
What it holds |
| 1 |
Customer name |
Your institution's name, the same on every row |
| 2 |
Transfer ID |
A unique ID for the transfer |
| 3 |
Confirmation number |
A unique reference for the transfer |
| 4 |
Transfer date time |
Date and time of the transfer, in Eastern Time (ET) |
| 5 |
Sender name |
Name of the sender |
| 6 |
Recipient name |
Name of the recipient |
| 7 |
Send amount |
The amount sent, including the FX markup |
| 8 |
Transfer fee |
Total fees on the transfer |
| 9 |
Fx rate |
The exchange rate applied |
| 10 |
Total debit amount |
Send amount plus transfer fee |
| 11 |
Fee revenue share |
Your share of the transfer fee. Filled in only if you're set up for revenue withholding. Otherwise $0.00 |
| 12 |
Fx revenue share |
Your share of the FX revenue. Filled in only if you're set up for revenue withholding. Otherwise $0.00 |
| 13 |
Re-quote fx |
Only if you've opted into re-quote. Filled in only where the rate changed between when the transfer started and when it was released |
| 14 |
Re-quote variation |
Only if you've opted into re-quote. The difference that rate change created |
| 15 |
Re-quote liability |
Only if you've opted into re-quote. The part of that difference that falls on you, where it applies |
| 16 |
Delivery method |
BANK_ACCOUNT, MOBILE_WALLET, PUSH_TO_CARD or CASH_PICKUP
|
| 17 |
Destination country |
Where the money is going |
| 18 |
Destination currency |
The currency at the destination |
| 19 |
Proxy number |
The sender's account identifier at your institution. Not every client uses it |
| 20 |
RSP name |
The payout provider behind the transfer |
-
Summary row: the file ends with a summary row. It isn't a transfer, so leave it out of any row count.
Cancellation Report
Twenty-one columns: the same as the Daily Transfers Report, with Total credit amount in place of Total debit amount, plus Cancelation reason.
| Cancelation reason values |
| Customer Request |
| Change Mind |
| Failed Validation |
| FailedCompliance |
| Incorrect Account Number |
| Account does not support payment |
| Provider Validation Error |
What clients use them for
-
Reconciling your prefunding account: match the Daily Transfers Report and Cancellation Report against your sponsor bank's records for the account.
-
They won't match the portal: these files list only what settled. The Admin Portal shows everything, including what hasn't settled. To reconcile your own ledger, use the Daily Consolidated Report or a portal export.
-
Cancellations arrive on a later day: a sender who cancels is refunded straight away. Your prefunding account is credited the next business day, after the payout network settles, and the amount shows on that day's Cancellation Report. A cancellation never removes the original transfer row.
-
Cash pickup is the exception: uncollected cash can stay on the network for up to 30 days before it returns.
-
Why the same day can split across providers: each payout network settles on its own window.
| Network |
Settlement window (ET) |
| Mastercard |
12:00:00 AM to 11:59:59 PM |
| Visa |
6:00:00 AM to 5:59:59 AM the next day |
-
Quote the transaction ID: every transfer has a unique transaction ID. It's in the sender's history, the Admin Portal and the daily file. Quote it on any support ticket.
Related articles