Fedwire Transfer Messages
This dataset contains detailed records of real-time gross settlement Fedwire transfers, including sender and receiver information, transaction amounts, payment types, and settlement status. It enables analysis of large-value and time-critical payments with central bank guarantees, supporting financial compliance, risk management, and operational transparency.
Sample rows
preview · 8 of 400 rows · all 29 columns| transfer_idstring | payment_typestring | amountfloat | central_bank_guaranteeboolean | sender_statestring | transaction_datetimedatetime | currencystring | sender_bank_idstring | sender_bank_namestring | sender_account_numberstring | receiver_bank_idstring | receiver_bank_namestring | receiver_account_numberstring | sender_namestring | sender_street_addressstring | sender_citystring | sender_postal_codestring | sender_countrystring | receiver_namestring | receiver_street_addressstring | receiver_citystring | receiver_statestring | receiver_postal_codestring | receiver_countrystring | purpose_codestring | reference_numberstring | message_textstring | settlement_datedate | statusstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A1B2C3D4E5 | large-value | 2500000 | true | TX | 2024-06-03T13:24:31 | USD | 021000021 | JPMorgan Chase | 40012345678 | 026009593 | Bank of America | 42098765432 | Acme Holdings LLC | 1200 Commerce St | Dallas | 75201 | US | Global Investments Ltd | 3300 Peachtree Rd NE | Atlanta | GA | 30326 | US | investment | INV-20240603-001 | Investment funding for June round. | 2024-06-03 | completed |
| F6G7H8J9K0 | time-critical | 0.99 | false | blank | 2024-06-03T09:06:17 | USD | 091000019 | Wells Fargo | 41098765432 | 122105278 | U.S. Bank | 43012345678 | Test Entity | blank | blank | blank | blank | Edge Case | blank | blank | blank | blank | blank | test | blank | blank | 2024-06-03 | completed |
| Q1W2E3R4T5 | large-value | 820000.5 | false | PA | 2024-06-03T16:44:58 | USD | 031101279 | TD Bank | 40123456789 | 021001208 | Citibank | 44098765432 | Baker Foods Inc | 200 Market St | Philadelphia | 19106 | US | Whole Goods LLC | 1700 Broadway | New York | NY | 10019 | US | settlement | SET-20240603-002 | Settlement payment for Q2 deliveries. | 2024-06-03 | completed |
| Y6U7I8O9P0 | time-critical | 75.5 | false | TN | 2024-06-03T08:16:43 | USD | 053000219 | PNC Bank | 42012345678 | 084000026 | Regions Bank | 45098765432 | John M. Evans | 458 Maple Dr | Memphis | 38103 | US | Emily Evans | 1300 2nd Ave S | Birmingham | AL | 35233 | US | family-support | FS-20240603-JE | Monthly support payment. | 2024-06-03 | completed |
| Z9X8C7V6B5 | large-value | 12000000 | true | OH | 2024-06-03T14:15:12 | USD | 041000124 | Huntington Bank | 43012345678 | 121000358 | Wells Fargo | 46098765432 | Atlas Real Estate Corp | 800 Superior Ave | Cleveland | 44114 | US | Prime Realty Partners | 6111 S Pointe Blvd | Fort Myers | FL | 33919 | US | property-purchase | PP-20240603-003 | Final payment for real estate closing. | 2024-06-03 | completed |
| M9N8B7V6C5 | time-critical | 430.75 | false | KY | 2024-06-03T10:11:49 | USD | 062000019 | Regions Bank | 44012345678 | 111000614 | Fifth Third Bank | 47098765432 | Paula C. Nguyen | 2501 W Main St | Louisville | 40212 | US | Derek Nguyen | 800 S 4th St | Louisville | KY | 40203 | US | personal | PN-20240603-004 | Birthday gift. | 2024-06-03 | completed |
| L5K4J3H2G1 | large-value | 230000 | false | CT | 2024-06-03T12:30:02 | USD | 021000322 | HSBC Bank USA | 45012345678 | 025000017 | Capital One | 48098765432 | United Technologies | 10 Farm Springs Rd | Farmington | 06032 | US | Lockheed Martin | 6801 Rockledge Dr | Bethesda | MD | 20817 | US | settlement | SET-20240603-005 | Settlement for Q2 contract. | 2024-06-03 | completed |
| S2D4F6G8H0 | time-critical | 1450 | false | VA | 2024-06-03T11:35:42 | USD | 091000022 | U.S. Bank | 46012345678 | 021001208 | Citibank | 49098765432 | Miller Consulting LLC | 1500 E Main St | Richmond | 23219 | US | Smith & Sons | 1000 W Broad St | Richmond | VA | 23220 | US | consulting | CON-20240603-006 | Consulting fees for May. | 2024-06-04 | pending |
| P3O2I1U9Y8 | large-value | 50000000 | true | CO | 2024-06-03T15:52:19 | USD | 031100209 | Santander Bank | 47012345678 | 021000322 | HSBC Bank USA | 50098765432 | Monarch Energy Corp | 1225 17th St | Denver | 80202 | US | Pioneer Energy LLC | 600 Travis St | Houston | TX | 77002 | US | acquisition | ACQ-20240603-007 | Acquisition transfer. | 2024-06-03 | completed |
| U6T5R4E3W2 | time-critical | 12.5 | false | IL | 2024-06-03T17:23:08 | USD | 021000089 | BMO Harris Bank | 48012345678 | 021000021 | JPMorgan Chase | 51098765432 | Samantha L. Reed | 2550 N Clark St | Chicago | 60614 | US | David Reed | 700 W Van Buren St | Chicago | IL | 60607 | US | personal | PR-20240603-008 | Transfer for groceries. | 2024-06-03 | completed |
| I9U8Y7T6R5 | large-value | 99999999.99 | true | NY | 2024-06-03T07:58:46 | USD | 021000322 | HSBC Bank USA | 49012345678 | 026009593 | Bank of America | 52098765432 | Apollo Holdings | 345 Park Ave | New York | 10154 | US | Starlight Partners | 1000 Peachtree St | Atlanta | GA | 30309 | US | merger | MER-20240603-009 | Merger finalization payment. | 2024-06-03 | completed |
| O2P3Q4R5S6 | time-critical | 570 | false | TX | 2024-06-03T13:21:29 | USD | 121000358 | Wells Fargo | 50012345678 | 041000124 | Huntington Bank | 53098765432 | Michael T. Harris | 3200 Smith St | Houston | 77006 | US | Linda Harris | 2300 Kirby Dr | Houston | TX | 77019 | US | family-support | FS-20240603-MH | Monthly family support. | 2024-06-03 | completed |
| J8K9L0M1N2 | large-value | 150000 | false | MI | 2024-06-03T11:47:13 | USD | 025000017 | Capital One | 51012345678 | 031100209 | Santander Bank | 54098765432 | Weston Manufacturing | 100 Industrial Rd | Detroit | 48201 | US | East Supply Inc | 2000 E Jefferson Ave | Detroit | MI | 48207 | US | supply-payment | SP-20240603-010 | Payment for Q2 supplies. | 2024-06-03 | completed |
| Q7W8E9R0T1 | time-critical | 900 | false | OH | 2024-06-03T14:55:26 | USD | 111000614 | Fifth Third Bank | 52012345678 | 021000021 | JPMorgan Chase | 55098765432 | Rachel S. Lee | 2500 Vine St | Cincinnati | 45219 | US | Jessica Lee | 1500 Elm St | Cincinnati | OH | 45202 | US | family-support | FS-20240603-RL | Support for education expenses. | 2024-06-04 | pending |
| B4N5M6V7C8 | large-value | 9900000 | true | NY | 2024-06-03T15:03:22 | USD | 021001208 | Citibank | 53012345678 | 031101279 | TD Bank | 56098765432 | Empire Tech Corp | 450 Madison Ave | New York | 10022 | US | Nova Systems | 200 Central Park S | New York | NY | 10019 | US | settlement | SET-20240603-011 | Settlement for software license. | 2024-06-03 | completed |
| L9K8J7H6G5 | time-critical | 45.25 | false | MN | 2024-06-03T10:55:34 | USD | 122105278 | U.S. Bank | 54012345678 | 021000089 | BMO Harris Bank | 57098765432 | Brandon S. Miller | 1200 E 7th St | St Paul | 55101 | US | Tanya Miller | 150 Grand Ave | St Paul | MN | 55102 | US | personal | PR-20240603-BM | Monthly allowance. | 2024-06-03 | completed |
| T8R6E5W4Q3 | time-critical | 72000 | false | OH | 2024-06-03T17:45:11 | USD | 041000124 | Huntington Bank | 55012345678 | 053000219 | PNC Bank | 58098765432 | Brown Logistics | 2000 E 9th St | Cleveland | 44115 | US | QuickTruck LLC | 4000 Spring Grove Ave | Cincinnati | OH | 45223 | US | supply-payment | SP-20240603-012 | Payment for Q2 shipment. | 2024-06-03 | completed |
| P6O7I8U9Y0 | time-critical | 0.01 | false | blank | 2024-06-03T09:14:18 | USD | 031101279 | TD Bank | 56012345678 | 021000322 | HSBC Bank USA | 59098765432 | Micro Test LLC | blank | blank | blank | blank | Edge Transfer | blank | blank | blank | blank | blank | edge-test | blank | blank | 2024-06-03 | completed |
| N1M2B3V4C5 | time-critical | 44000 | false | OH | 2024-06-03T12:45:38 | USD | 021000021 | JPMorgan Chase | 57012345678 | 021000089 | BMO Harris Bank | 60098765432 | Green Valley Inc | 4200 Smith Rd | Cincinnati | 45209 | US | Farm Supplies Co | 1800 Main St | Toledo | OH | 43605 | US | supply-payment | SP-20240603-013 | Seed and fertilizer payment. | 2024-06-03 | completed |
| A2S3D4F5G6 | time-critical | 150 | false | TX | 2024-06-03T14:31:54 | USD | 091000019 | Wells Fargo | 58012345678 | 025000017 | Capital One | 61098765432 | Sarah K. Taylor | 800 W 5th St | Austin | 78703 | US | Robert Taylor | 900 E 6th St | Austin | TX | 78702 | US | personal | PR-20240603-ST | Transfer for books. | 2024-06-03 | completed |
What the 400 rows show
from the 400-row sampleLarge-value (payment type) stands out: 101 of its 155 rows have central_
- 25%central_
bank_ guarantee = true - 3,450median amount
- 2statuses
- 22purpose codes
- 36receiver states
- 51receiver bank names
Median 3,450, from 0.01 to 150,000,000.
- string 25
- float 1
- date 1
- datetime 1
- boolean 1
Columns
29 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 25 columns | |||
transfer_id | string | Unique identifier for each Fedwire transfer messageunique | A1B2C3D4E5 |
currency | string | Currency code of the transfer, typically USDUSD | USD |
sender_bank_id | string | Unique identifier (e.g., ABA routing number) for the sending bank | 021000021 |
sender_bank_name | string | Name of the sending bank | JPMorgan Chase |
sender_account_number | string | Account number of the sender | 40012345678 |
receiver_bank_id | string | Unique identifier (e.g., ABA routing number) for the receiving bank | 026009593 |
receiver_bank_name | string | Name of the receiving bank | Bank of America |
receiver_account_number | string | Account number of the receiver | 42098765432 |
sender_name | string | Name of the sender (individual or entity) | Acme Holdings LLC |
sender_street_address | string | Street address of the senderoptional | 1200 Commerce St |
sender_city | string | City of the senderoptional | Dallas |
sender_state | string | State of the senderoptional | TX |
sender_postal_code | string | Postal code of the senderoptional | 75201 |
sender_country | string | Country of the senderoptional | US |
receiver_name | string | Name of the receiver (individual or entity) | Global Investments Ltd |
receiver_street_address | string | Street address of the receiveroptional | 3300 Peachtree Rd NE |
receiver_city | string | City of the receiveroptional | Atlanta |
receiver_state | string | State of the receiveroptional | GA |
receiver_postal_code | string | Postal code of the receiveroptional | 30326 |
receiver_country | string | Country of the receiveroptional | US |
payment_type | string | Type of payment (e.g., large-value, time-critical)large-value · time-critical | large-value |
purpose_code | string | Code indicating the purpose of the transfer (e.g., payroll, settlement, loan repayment)optional | investment |
reference_number | string | Reference number for reconciliation or trackingoptional | INV-20240603-001 |
message_text | string | Freeform message or instructions included with the transferoptional | Monthly support payment. |
status | string | Status of the transfer (e.g., completed, pending, failed)completed · pending · failed · cancelled | completed |
| Numbers 1 column | |||
amount | float | Monetary value of the transfer in USD0.01 or more | 2500000 |
| Dates and times 2 columns | |||
transaction_datetime | datetime | Date and time when the transfer was initiated | 2024-06-03T13:24:31 |
settlement_date | date | Date when the transfer was settled | 2024-06-03 |
| True or false 1 column | |||
central_bank_guarantee | boolean | Indicates whether the transfer is guaranteed by the central bank | true |
Use it for
A finance dashboard
The central_
bank_ guarantee rate, amount by payment_ type and a breakdown of sender_ state. Excel, Power BI or Tableau. Why do 101 of 400 rows have central_
bank_ guarantee = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Transfers400A1B2C3D4E52500000large-va…F6G7H8J9K00.99time-cri…Z9X8C7V6B512000000large-va…
A software demo
Believable transfers with transaction_
datetime, amount and currency to fill a screen in front of a buyer.
blueprint · fedwire-transfer-messages-2
Behind this dataset
Same schema. As many rows as you need.
These 400 rows came out of a blueprint — 29 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- IMAD (Input Message Accountability Data) unique
- Real-time settlement with immediate finality
- Minimum amount typically $1,000
- Sender and receiver ABA routing numbers
- Business function code: BTR, DRW, etc.
- Value date same business day
- Cut-off time: 6:30 PM ET
- Irrevocable once sent
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- fedwire-transfer-messages-2