Datadory notebook

Z.1 flow of funds tables: what the sector matrices hold

Datadory delivers asset management & custody banks data anchored on Z.1 flow of funds tables: the Federal Reserve's quarterly sector-by-instrument accounts of US credit - flows, levels and full balance sheets with net worth across households, funds, banks, government and the rest of the world, restated whole back to 1945:Q4 - flattened into typed rows and delivered daily, weekly, or hourly.

1,744 datasets. Pick your catch.

What are the Z.1 flow of funds tables?

The Z.1 - formally the Financial Accounts of the United States - is where the American credit system gets counted: transactions and levels of financial assets and liabilities, cut by sector and financial instrument at once, plus full balance sheets with net worth for households and nonprofits, nonfinancial corporate and noncorporate business, the Integrated Macroeconomic Accounts and supplemental detail. Federal Reserve Z.1 Financial Accounts of the United States (Flow of Funds) is the Datadory product built on that release, one of five primary records among the eleven pooled datasets on the asset-management-custody-banks hub.

It is also the strongest record Datadory catalogs for this industry - a perfect 10 out of 10 quality score, shared only with SEC Form N-PORT, against a catalog-wide mean of 7.81; just 145 of 1,744 records reach ten.

Which table family answers which question?

Every table in the bundle falls into one of five families, and picking the right one saves hours of column-hunting:

Which sectors, instruments and mnemonics do the tables encode?

The matrices cut the economy by sector and instrument simultaneously: households, nonfinancial business, federal and state-local government, the rest of the world, commercial banks, credit unions, money market funds, mutual funds, ETFs, finance companies, insurers, private and government pensions, agencies and GSEs, securitizers. Fund sectors are named directly - S123.s covers money market funds, S124.1.s covers mutual funds - with related instruments such as L.206 money market fund shares, L.226 mutual fund shares, L.228 life insurance reserves and L.229 pension entitlements.

A concrete read shows how deep the levels run. In the mutual-fund table, the first column LM654090000.Q - "Mutual funds; total financial assets," millions of dollars at market value - opens at 1,245 for 1945:Q4 and 1,298 for 1946:Q4: roughly $1.2 billion held by an industry whose scale the same column then tracks quarter by quarter into six figures.

Mnemonic anatomy makes the rest navigable. Codes combine an instrument prefix with a sector suffix - LM654090000.Q, FA384104005.Q - and every table ships a matching dictionary entry that resolves each code to its description, line number, table and units: "Mutual funds; total financial assets | Line 1 | S124.1.s Mutual funds | Millions of dollars; amounts outstanding end of period, market value, not seasonally adjusted." Six fields describe every series: period, mnemonic, description, line, table, units.

That structure is why quants modeling custody-bank custody flows start at the sector matrices rather than at filings: one quarterly refresh restates the whole who-holds-what matrix, so joining fund-sector levels to the banking system needs no entity resolution. The trade-off runs the other way too - security-level positions live in Form N-PORT's holdings corpus instead.

How far does the history reach, and what changes between releases?

Temporal - quarterly flows and levels open at 1945:Q4 and annual series reach back to 1919, which makes multi-cycle structural work possible without stitching vintages together. Rate regimes, deleveraging episodes, household net worth swings: all of them fit inside one consistent definition.

Each quarterly release refreshes that full history rather than appending a single quarter - the June 11, 2026 release covered 2026:Q1, and corrections are reposted with notices, as with the June 12, 2026 correction to matrix table M3.s. Two structural caveats belong in any model built on top. First, publication lands roughly 10-11 weeks after quarter end, so align any trigger to the actual schedule rather than the quarter boundary. Second, table numbering changed between vintages - S124.1.s maps to legacy L.122 Mutual funds, F521.s to legacy L.206 Money market fund shares - so cross-vintage joins should ride the published mapping rather than hard-coded numbers.

What can analysts actually build on the sector matrices?

Household leverage and net-worth cycles. The B.x balance-sheet family turns household net worth, liabilities and debt-service-relevant stocks into a quarterly panel spanning eight decades - the natural base for deleveraging studies and housing-cycle work.

Fund-industry growth accounting. S123.s and S124.1.s give money market and mutual fund assets quarter by quarter from 1945, so market-share and flow-of-capital narratives get measured instead of anecdotal.

Who-lends-to-whom structure. The M3.s flow matrices expose instrument-by-instrument borrowing and lending between sectors each quarter - credit transmission traced end to end rather than inferred.

Benchmarking micro positions. Aggregate N-PORT holdings up and the result must reconcile to these sector levels; the two records are designed to be read side by side, and both carry the pool's perfect quality score.

Citable macro numbers. Every figure traces to the Board's own published accounts with line numbers and units attached, which is what publication teams and academics need before a chart goes in a report.

How does the Z.1 compare with the rest of the pool?

Within Asset Management & Custody Banks, four records answer adjacent questions, and the useful move is knowing which question you are asking:

The pairing that earns its keep is the Z.1 against N-PORT: one aggregates fund and bank sectors back to 1945:Q4 across 286 tables per release, the other descends to named securities held by named funds from October 2019. Both score 10/10, and the head-to-head at Z.1 vs N-PORT works the trade-off attribute by attribute. For banking features at daily frequency beside the quarterly matrices, FRED Category 13 - Banking Data Sub-tree carries roughly 5,200-6,700 addressable banking series - though it does not restate the sector-by-instrument matrix itself.

Why get Z.1 flow of funds tables through Datadory?

API, files, or your warehouse. Daily, weekly, or hourly.

Because the hard part was never obtaining a release - it is keeping eight decades of restated history coherent as one time series. As published, each quarterly drop replaces its predecessor wholesale, numbering shifted between vintages, and every mnemonic needs a dictionary lookup before a value means anything.

Datadory handles that upstream so the rows just arrive: mnemonics resolved against their descriptions, lines, tables and units; current and legacy table codes carried side by side; corrections folded forward while revision vintages stay distinguishable; and each new quarter appended beside prior decades under one schema instead of replacing them. A sector panel accumulates history rather than resetting at every posting.

Z.1 flow of funds table families and what each answers (current-release bundle, as of August 2026)
PrefixFamilyWhat it tells youNamed example
F.xFlowsQuarterly transactions by sector and instrumentF521.s Money market fund shares (legacy L.206)
L.x / S.xLevelsAmounts outstanding at end of period, market valueS124.1.s Mutual funds (legacy L.122)
B.xBalance sheetsFull balance sheets with net worth by sectorHouseholds and nonprofit organizations net worth
D.xGrowthGrowth rates, e.g. debt growth by sectorD3.g Debt growth by sector
M3.s / M3.tMatricesInstrument-by-instrument flow matricesM3.s, corrected and reposted June 12, 2026

Pick up where this leaves off

Every one of these ships with sample rows before you commit to anything.

Asset Management & Custody Banks United States as a closed accounting system, with the rest of…

Federal Reserve Z.1 Financial Accounts of the United States (Flow of Funds)

Asset Management & Custody Banks United States registered investment companies

SEC Form N-PORT Data Sets (via data.gov Catalog)

Asset Management & Custody Banks United States - domestic offices of commercial banks, offices…

Federal Reserve H.8 - Assets and Liabilities of Commercial Banks

Asset Management & Custody Banks United States, national

Federal Reserve Data Download Program Data

Five documented spine fields

Asset Management & Custody Banks United States national aggregates

FRED Category 13 - Banking Data Sub-tree

Want rows instead of a pitch? Name the datasets.

API, files, or your warehouse. Daily, weekly, or hourly.

Get a sample

Questions worth asking

What is inside the Z.1 flow of funds tables?

Transactions and levels of financial assets and liabilities by sector and instrument: 286 tables per quarterly release covering flows (F.x), levels (L.x), balance sheets with net worth (B.x), growth rates (D.x) and instrument-by-instrument matrices (M3.s). Thousands of distinct series ship with a dictionary resolving every mnemonic to description, line, table and units.

How far back do Z.1 flow of funds tables go?

Quarterly flows and levels run from 1945:Q4 to the present and annual series extend to 1919. Each quarterly release refreshes the full history rather than appending one quarter, so a single consistent panel spans every postwar credit cycle without stitching vintages together.

Which Z.1 tables track mutual fund and money market fund assets?

S124.1.s covers mutual funds and S123.s covers money market funds, mapping to legacy tables L.122 and L.121; fund-share instruments sit in L.206 and L.226. The level series LM654090000.Q - mutual funds' total financial assets at market value - opens at $1,245 million in 1945:Q4 and runs quarter by quarter to the present.

Do the Z.1 tables include security-level positions?

No - aggregation is the point and the limit. The matrices stop at sector-by-instrument totals, deliberately, because one quarterly refresh can restate the whole who-holds-what structure with no entity resolution. When a question needs named securities inside named funds, SEC Form N-PORT's quarterly holdings corpus supplies it, from October 2019 onward.

How are Z.1 flow of funds tables delivered through Datadory?

As typed rows keyed on series mnemonic and period, cut to named tables or mnemonics, with current and legacy table codes resolved side by side and revision vintages kept distinguishable. API, scheduled files, or straight into your warehouse, daily, weekly, or hourly - name the series and window when you request a sample and it arrives shaped like the standing feed.