What a Federal Reserve master account reconciliation covers
A master account is not one stream of money. It is where almost every Federal Reserve service your institution uses settles, plus the activity of any respondents that settle through you (the due to side of a correspondent bank reconciliation). The Daily Statement of Account shows it by service, and each line on it has a different source system and a different way of going wrong. This is the usual inventory.
| Activity on the Fed statement | System on your side | What has to agree | What usually breaks |
|---|---|---|---|
| Fedwire Funds Service | Wire platform and wire clearing GL | Each wire by IMAD and amount against the wire system and the GL | A wire posted to suspense or to the wrong customer account |
| Fedwire Securities Service | Investment accounting or safekeeping system | Securities settlement debits and credits against trades | Settlement on a different date from the trade booking |
| FedACH Services | ACH platform or core | Net settlement per window against origination, receipt and returns | A window settled on one business day and booked on the next |
| FedNow Service | Instant payments platform or service provider | Credit transfers and returns by cycle date against the GL | Evening and weekend activity booked by calendar date |
| Check and cash letters | Item processing or image exchange system | Deposits and presentments, including deferred availability | Credit booked on deposit day but available one or two days later |
| Currency and coin | Vault or cash management system | Orders and deposits against the branch and vault GL | Shipments booked when ordered rather than when charged |
| FRB service charges | Expense accrual | The monthly charge against the Statement of Service Charges | An accrual that does not match the billed amount |
| Respondent activity | Due to and due from accounts | Respondent totals applied to the master account against each respondent's account | Respondent settlement never passed through to the respondent |
The Federal Reserve reports the reconciliation runs on
The Federal Reserve Banks publish the same account activity in several forms. Choosing the right one decides how much of the work can be automated, because a PDF has to be read by a person and a FIRD file does not.
| Report | Level of detail | Format and channel | Timing |
|---|---|---|---|
| Daily Statement of Account | Summary by service, with sections for subaccounts and respondents | PDF in AMI, up to 21 consecutive dates | End of each business day, seven days a week, without a subscription for master account holders |
| Financial Institution Reconcilement Data (FIRD) | Transaction detail, including Fedwire Funds and Fedwire Securities | Machine readable, via FedLine Direct or FedLine Command, or downloaded in AMI | Delivered seven days a week, up to 21 business dates downloadable |
| Statement of Account in Spreadsheet File (SASF) | Transaction detail | Spreadsheet file in AMI | Delivered seven days a week |
| Intraday file | All transactions except Fedwire Funds and Fedwire Securities | Machine readable, via FedLine Direct or FedLine Command, master accounts only | During the day |
| Cash Management Plus (CMS Plus) | All transactions except FedNow, Fedwire Funds and Fedwire Securities | CSV download in AMI | Up to 12 times a day on standard business days |
| FedNow Activity Totals and Activity Details | Totals and transaction detail by routing number | ISO 20022 camt.052 or the FedNow interface | End of cycle date by default, 90 cycle days of history |
Two details matter for the software choice. The FedLine Web package does not include FedNow reports, and FedLine Web Plus adds AMI with the FIRD and SASF files offered for an additional fee, so check which files your connection gives you before you plan the build. And intraday data is provisional: the Fed treats posted intraday activity as provisional except Fedwire Funds, Fedwire Securities, FedNow, National Settlement Service entries and pre-funded FedACH credit originations. An intraday match is a useful early warning. The end of day FIRD file is the record you certify against.
Why the Fed account breaks: cycle dates, not calendar dates
Most Federal Reserve account differences are not errors. They come from a calendar your GL does not share. The Fedwire Funds Service normally opens at 9 p.m. ET on the evening before the business day and closes at 7 p.m. ET. FedNow settles around the clock, every day of the year, but for accounting it uses the same cycle: 7 p.m. to 7 p.m. ET. The FedNow Readiness Guide gives the example directly: a payment that settles on June 1 at 7:01 p.m. ET has a cycle date of June 2.
Since FedNow launched, the Daily Statement of Account, FIRD and SASF have been produced seven days a week. A core that posts only on business days, or a GL that books by calendar date, turns every evening payment and every weekend into a potential difference. The Fed's own guide leaves it to each institution to decide how often it reconciles. Software lets you reconcile every cycle date without adding a weekend shift.
Common Federal Reserve account breaks and what the software does with them
| Break | What it looks like | Classification and suggested action |
|---|---|---|
| Cycle date rollover | A FedNow credit settles at 7:04 p.m. ET on the calendar date and carries the next cycle date, while the GL booked it on the calendar date | Timing. Matched under the approved cycle date rule and closed, with the rule recorded |
| Weekend and holiday activity | FIRD shows net FedNow activity for a Saturday cycle date and the GL posts it on the next business day | Timing. Matched inside the approved window, and anything older than the window stays open |
| Wire to suspense | A Fedwire credit with an IMAD on FIRD has no match in wire clearing because it posted to suspense | Missing reference. Routed to wire operations with the IMAD and counterparty routing number attached |
| Service charge variance | FRB Service Charges, transaction code 85010, debited on the 15th for a different amount than accrued | Fee variance. Compared with the monthly Statement of Service Charges and routed to accounting |
| Deferred availability | A cash letter credit shows one day deferred availability and the GL booked it on deposit day | Timing. Matched on the available date rather than the deposit date |
| Respondent pass-through | Respondent activity settled to your master account with no posting to the respondent's due to account | Missing posting. Routed to correspondent services with the respondent section of the statement attached |
| Daylight overdraft fee | A daylight overdraft charge debited with no accrual on the books | Fee not accrued. Proposed posting to the correct expense account under approval |
From a cycle date to worked items
Input
- FIRD · cycle date 2026-09-05 (Saturday) · FedNow net credit 412,908.17 USD
- Core GL · FedNow settlement · 412,908.17 USD posted 2026-09-08 (Labor Day was 2026-09-07)
- FIRD · 2026-09-15 · FRB Service Charges, code 85010 · debit 18,432.60 USD
- Core GL · Federal Reserve service charge accrual · 17,950.00 USD
Output
- Matched, timing 412,908.17 USD. Same amount, weekend cycle date against the first business day after a federal holiday, inside the approved window.
- Fee variance 482.60 USD. The service charge debit is higher than the accrual.
- Suggested action: compare with the August Statement of Service Charges, post the difference to expense under approval and adjust next month's accrual. Routed to Accounting, aged from the charge date, with both documents attached.
Illustrative sample values. The amounts are invented for the example.
Service charges and daylight overdraft fees
Two fee lines on the Fed statement are small enough to ignore and regular enough to become an audit comment. Federal Reserve service charges accrue daily through the month. The Statement of Service Charges for a master account is available by the fourth business day of the following month, and the charge is applied on the 15th, or the next business day if the 15th falls on a weekend or holiday. It appears on the Daily Statement of Account as FRB Service Charges, transaction code 85010.
Daylight overdraft fees follow the Payment System Risk policy. Since March 24, 2011 the Board has charged 50 basis points, at an annual rate, on uncollateralized daylight overdrafts, and the fees are calculated and assessed for each two-week reserve maintenance period. Reconciliation software is not an intraday liquidity tool, and Bankautomation does not manage your account position. What it does is make sure every fee that reaches the statement is matched to an accrual or routed to someone who can explain it.
Federal Reserve account reconciliation software compared
Institutions shortlisting software for the Fed account usually weigh the same options. The deciding question is whether you need a month-end certification of the account balance or a daily queue of differences someone works while the wire and FedNow teams still remember the item.
| Option | Good at | Weak at | Fits |
|---|---|---|---|
| Spreadsheets on SASF downloads | No new vendor, and SASF opens in Excel | No aging, no rule history, and seven day statements mean seven day manual work | Low volume institutions without FedNow |
| Trintech (Frontier, Cadency) | Trintech's banking page describes aligning Fedwire and ACH settlement, Federal Reserve account balances, fees and daylight overdrafts with internal systems and the GL | Several product lines, so confirm which one the proposal is for. Pricing is quoted | Institutions buying a broad reconciliation and close platform |
| ReconArt | Bank, card, ACH and GL reconciliation, with credit union customers such as Catalyst Corporate FCU reconciling Federal Reserve, ACH and RTP accounts | Pricing is quoted, though ReconArt states an average annual cost below $50,000 | Mid-size banks and credit unions wanting a reconciliation-focused platform |
| Bankautomation | Daily exception work: Fed, ACH, card and nostro breaks classified, routed and aged in one queue, with published pricing | A newer vendor, not a close checklist, and it does not manage intraday liquidity or replace your core | Accounting and payments teams that want a worked daily queue and a price up front |
If you are already comparing the larger platforms, the bank-specific guides to Trintech alternatives, IntelliMatch alternatives and ReconArt alternatives set out pricing and fit side by side.
What Federal Reserve account reconciliation software costs
Most vendors quote per institution, so the first number arrives after a demo. Bankautomation publishes its prices. Operations is $1,200 a month for one process line, 250,000 matched items a month and three source connections, which covers the Fed account with FIRD, the wire system and the GL for many community banks and credit unions. Platform is $3,900 a month and adds unlimited source connections, maker-checker approvals and SSO, which is where teams land once ACH, FedNow, check and respondent activity feed one queue. Institution is $9,500 a month for multi-entity groups. Every limit is on the pricing page.
A rollout that starts with one file
Step 01
Pick the service that hurts most
Usually Fedwire Funds or FedNow, because they carry the value and the evening activity. One service against FIRD is a better start than the whole statement at once.
Step 02
Send a FIRD or SASF sample and the other side
A recent FIRD or SASF file, the wire or FedNow platform report and a GL export as CSV. Field mapping is configuration and versioned, not an integration build.
Step 03
Agree the cycle date and weekend rules
The cycle date window, the business day posting rule, the fee schedule and the dollar threshold below which a difference is logged, each approved by your controller and recorded.
Step 04
Run in parallel, then retire the workbook
Compare the worklist with the current reconciliation for a few cycles. When they agree, retire the workbook for that service and add ACH, check and respondent activity next.
Try the matcher on a settlement sample
The resolver at the top of this page runs the same two pass matcher on a sample USD settlement file against core postings. It holds the kinds of differences settlement teams see every day: an amount that misses by a fee, a settlement posted a day late and a batch that appears twice on the ledger side. Move the date and amount tolerances and watch which differences are absorbed and which stay as breaks. FedACH settlement windows and return deadlines are covered on ACH reconciliation software, the three way view of instruction, settlement and posting is on payment reconciliation software, and correspondent accounts held abroad are on nostro reconciliation automation.
Sample data only. The demo never receives customer, member or production data, and nothing you paste into it is stored.
Questions about federal reserve account reconciliation software
How do banks reconcile their Federal Reserve account?
Banks match the Federal Reserve activity reported in the Daily Statement of Account or the FIRD file against the systems that generated it (wires, ACH, FedNow, check and cash) and against the general ledger, by cycle date. Timing differences are matched under approved rules, and every remaining difference becomes an item with an owner until it is resolved.
What is the FIRD file?
FIRD, Financial Institution Reconcilement Data, is the Federal Reserve's machine-readable Statement of Account file, designed to flow into an institution's accounting system. It carries transaction detail, including Fedwire Funds and Fedwire Securities, is delivered seven days a week and is available through FedLine Direct, FedLine Command or AMI.
What is the difference between FIRD and SASF?
Both carry the end of day Statement of Account in detail. FIRD is a machine-readable file meant for straight-through posting and automated matching. SASF is the same statement as a spreadsheet file from AMI that opens in Excel. Software can read either, but FIRD is the better source for daily automation.
Does the Federal Reserve statement include FedNow activity?
Yes. The Federal Reserve Banks revised the Daily Statement of Account, FIRD and SASF to include FedNow activity, and they now generate those reports seven days a week. FedNow also provides its own Activity Totals and Activity Details reports, with 90 cycle days of history, through ISO 20022 messaging or the FedNow interface.
When does the Fedwire Funds Service business day close?
The Fedwire Funds Service normally opens at 9 p.m. ET on the evening before the business day and closes at 7 p.m. ET. FedNow uses the same 7 p.m. to 7 p.m. ET cycle for accounting, so a payment settled at 7:01 p.m. ET carries the next day's cycle date.
How much does Federal Reserve account reconciliation software cost?
Most vendors quote per institution. ReconArt states an average annual cost below $50,000, and Trintech prices by quote. Bankautomation publishes its plans: Operations at $1,200 a month, Platform at $3,900 a month with unlimited sources and maker-checker, and Institution at $9,500 a month. See pricing.