In short
- We send you files every day to help you reconcile. Which ones you get depends on your setup.
- Files go by SFTP. You pull them from us, or we push them to you.
- Daily files list only what settled with the sponsor bank, so they won't match the Admin Portal exactly.
Files at a glance
| File | What it is | Who gets it | Arrives (ET) | Format |
|---|---|---|---|---|
| Daily Transfers Report | Transfers that settled the previous business day | Every prefunding client | About 6:30 AM ET for most clients, or about 8:30 AM ET for clients on v2 files, business days | CSV |
| Cancellation Report | Cancellations that settled the previous business day | Every prefunding client | About 6:30 AM ET for most clients, or about 8:30 AM ET for clients on v2 files, business days | CSV |
| Daily Consolidated Report | A log of changes for reconciling your own general ledger, including transfers that haven't settled | Optional, on request | About 6:30 AM ET, every day (seven days a week) | CSV or XLSX |
| Daily BAI2 File | Your prefunding account statement in BAI2 format, built by us | Optional, for any client who needs it | Business days, after your daily transfer files. There's no set time. | BAI2 (.bai) |
| Sponsor bank BAI2 statement | Your sponsor bank's own BAI2 statement of your prefunding account | Depends on the bank setting it up | Bancorp: Tuesday to Saturday, 7:00 to 8:00 AM ET (6:00 to 7:00 AM CT). MVB: Tuesday to Saturday | BAI2 |
Details for each file, including names and columns:
B2C payout clients: see your B2C docs.
How delivery works
- SFTP: by default you pull files from an SFTP folder we host for you (we give you credentials and you give us a public key). Pushing to your own SFTP (you give us both) is a non-standard setup.
- Set up for you: file delivery isn't self-service. It's set up during implementation.
- Quiet days: daily files are still sent when there's no activity, as header-only files. An empty file isn't an outage.
- Mondays: Monday's daily files cover Friday through Sunday. If Monday is a federal holiday, they come on Tuesday and cover Friday through Monday.
- Re-sending a file: the portal can't re-send or reschedule a daily file. If you need one re-delivered, open a support ticket.
- Time zone: the Transfer date time column in the daily files is in Eastern Time (ET), the sponsor banks' time zone.
- Starting setup: contact the Integrations Team. They confirm your delivery time and set up SFTP with you. File delivery isn't self-service.
Which file to reconcile with
| To reconcile | Use |
|---|---|
| Your prefunding account | The Daily Transfers and Cancellation reports, against your sponsor bank's records or BAI2 file |
| Your own general ledger | The Daily Consolidated Report, or a portal export |
The daily files contain only what settled with the sponsor bank. The Admin Portal shows everything, including what hasn't settled, so the two aren't meant to tie out.
What you can get yourself in the portal
- Search and filter transfers, and export the results to CSV. Export is switched on per organization.
- Download the receipt for a completed transfer.
- View sender profiles and transfer history.
- View the activity log.
Quoting a transfer
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.