In short
- The Daily Consolidated Report helps you reconcile your own general ledger or DDA account, the internal account money moves into when a transfer starts.
- Unlike the Daily Transfers and Cancellation reports, it includes transfers that haven't settled yet.
- It's optional and available to any client on request. Its columns are set up for you.
What it is
- For your internal account: it reconciles your own general ledger or DDA account, not your prefunding account at the sponsor bank.
- A log of changes, not a snapshot: a transfer gets a row because something happened to it that day, not because it exists. Four things create a row:
- A customer hold was placed.
- A customer hold was released.
- The transfer settled.
- The transfer was cancelled or reversed.
- At most two rows per transfer per day: one debit and one credit. If a transfer is cancelled on the same day its customer hold is released, the release doesn't get its own row. It's folded into the credit row.
Naming format
-
Default name:
CustomerName_Daily_Consolidated_Report_MMDDYY. The name can be set for you. - Format: CSV by default, with a delimiter you can choose. XLSX is also available.
Delivery and timing
- How: by SFTP. By default you pull it from the SFTP folder we host for you. Pushing to your own destination is a non-standard setup. See Files you receive.
- When: about 6:30 AM ET, every day, seven days a week, including weekends and holidays. (Unlike the Daily Transfers and Cancellation reports, this file is not limited to business days.)
- Quiet days: the file is still sent with no activity, as a header-only file.
- Daily boundary: by default, each network's own settlement window decides which day a transfer falls on. At setup, a single custom cut-off for all your transfers can be configured instead of the network defaults.
Setup
Setup is done for you, not in the portal. During setup you'll be asked for:
- File name: your preferred name, or the default.
- File format: CSV (and the delimiter, if not a comma) or XLSX.
- Columns: which columns you want. Some only make sense if you use the matching feature, like Customer hold status for customer holds and the re-quote columns for re-quote.
- Delivery: SFTP pull, the default (we give you credentials and you give us a public key), or push, a non-standard setup (you give us the destination and credentials).
- How to ask: available to any client on request. Contact the Integrations Team to start setup.
Columns
Up to twenty-three columns. Your set depends on how your report is set up.
Shared with the Daily Transfers and Cancellation reports: Customer name, Transfer ID, Confirmation number, Transfer date time (Eastern Time), Sender name, Recipient name, Send amount, Transfer fee, Fx rate, Fee revenue share, Fx revenue share, Re-quote fx, Re-quote variation, Re-quote liability, Delivery method, Destination country, Destination currency, Proxy number, RSP name. What each holds is on Daily transfer and cancellation files.
Only in this report:
| Column | What it holds |
|---|---|
| Total credit amount | Filled in on reversal rows only |
| Total debit amount | Filled in on debit rows only |
| Cancelation reason | Filled in on reversal rows only |
| Customer hold status |
On Customer Hold, Released from Hold or Cancelled from Hold. Only if you use customer holds |
| Status update date time | When the change on this row happened |
| Is settled | Whether the money on this row has settled with the network |
Customer hold status shows the latest hold you placed, up to and including the report day. Holds for compliance review never appear in this column and don't create rows.
What clients use it for
- Reconciling your internal account: compare one day's file with that day's activity in your general ledger or DDA account.
- Don't add up several days without removing repeats: each change creates its own row, and every row carries the transfer's full amount. A transfer held on Monday and settled on Wednesday has a Monday row (not settled) and a Wednesday row (settled), at the same amount. Keep one row per Transfer ID before summing across days.
- Transfers under compliance review appear late: a transfer held for compliance review has no rows while it's held. It first appears on the day it settles or is cancelled.
-
Reading the file:
- * Row 2 is a description row. Data starts on row 3.
- * The file ends with a totals row. It sums every row, including rows that haven't settled, so it isn't a settled total.
- * A blank number cell means zero. A row fills in either the debit or the credit column, never both.
- * Is settled describes the row, not the transfer. A reversal row can read Yes.
- * A cancellation never removes the original debit row. The credit appears on the day the reversal settles.