Used by every major US bank for end-of-day reconciliation. Four sections. Different schema in each. One template.
FEDERAL RESERVE BANK OF NY DAILY SETTLEMENT REPORT
FEDWIRE FUNDS SERVICE REPORT ID: FW-SETTLE-2025-1215
--------------------------------------------------------
DATE: 12/15/2025 PARTICIPANT: JPMORGAN CHASE BANK NA
ABA: 021000021 FED DISTRICT: 02-NEW YORK
ACCOUNT: 0218-4403-7 RESERVE BAL: $847,291,403,228.14
SECTION 1: TRANSACTION SUMMARY BY MESSAGE TYPE
--------------------------------------------------------
MSG DESCRIPTION SENT CNT SENT AMOUNT ($)
1000 BASIC FUNDS TRANSFER 14,823 287,493,021,847.50
1001 BASIC FT - DRAWDOWN 482 8,921,304,527.00
1500 FOREIGN TRANSFER 3,847 94,728,301,482.25
3000 SECURITIES (DVP/RVP) 6,721 124,839,201,748.25
--------------------------------------------------------
TOTALS 61,323 908,548,128,409.75
SECTION 2: SETTLEMENT POSITION DETAIL
--------------------------------------------------------
TIME SLOT OPENING BAL DEBITS CLOSING BAL
06:00-08:00 847,291,403 42,819,304 855,756,117
14:00-16:00 862,795,763 312,847,103 848,420,677
18:00-18:30 853,874,959 18,293,048 852,429,202
RESERVE BAL CLOSING: $852,429,202,490.52
REQUIRED RESERVE: $124,847,291,038.00
EXCESS RESERVES: $727,581,911,452.52
FED FUNDS TARGET: 5.25-5.50%
Header Region · 10 Fields
Participant metadata
Bank name, ABA, Fed district, account, opening reserve. Parent record for everything below.
Section 1 · 7 Columns
Transaction summary
Message-type rows: sent/received counts and amounts, net position. Totals reconciled against detail.
Section 2 · 6 Columns
Position detail
Time-slot rows: opening, debits, credits, closing, overdraft flag. Different schema than Section 1.
Reserve Summary · K/V Pairs
End-of-day position
Closing balance must match Section 2's 18:30 row. Validation runs automatically. Exceptions alert ops.