US Treasury Daily Statement Deposits And Withdrawals — Operating Cash Flows By Account, Transaction Type And Category (DTS Table II), Today, Month-To-Date And Fiscal-Year-To-Date, Every Business Day Since 2005
481,569 line-day rows from Table II of the Daily Treasury Statement (Deposits and Withdrawals of Operating Cash) covering 5,256 business days, 7 account types and 515 distinct categories: every deposit line (withheld, individual, corporate, excise, estate and unemployment taxes, customs duties, Federal Reserve earnings, agency and program receipts, public debt cash issues) and every withdrawal line (Social Security and Medicare benefits, Medicaid, defense, veterans, interest, tax refunds, public debt cash redemptions and department-level outlays), plus the daily sub-total lines and, since April 2022, the total lines (account types Treasury General Account Total Deposits and Total Withdrawals, which carry no category), each with the day's amount, the month-to-date and the fiscal-year-to-date amounts in millions of US dollars. The statement was redesigned on 1 October 2021 and 18 April 2022: earlier lines sit in the Federal Reserve Account, the Tax and Loan Note Accounts (to September 2012) and Short-Term Cash Investments (to April 2022), later lines in the Treasury General Account with department-level categories and daily total lines, so category labels are not continuous across the redesign; category_desc carries the sub-line description the older format used for the Deposits by States and Other Deposits and Withdrawals lines and is blank otherwise. From the Treasury's Fiscal Data API as of 2026-09-06.
Use Cases
- Treasury General Account and liquidity tracking
- Daily tax-receipt and customs-duty nowcasting
- Federal outlay timing by department and program
- Debt-ceiling and cash-balance stress analysis
Methodology
Paged fetch of the Fiscal Data dts/deposits_withdrawals_operating_cash endpoint in statement line order (record_date, then source line number); amounts kept as published in USD millions; the source's literal "null" blanked; no date filter, the full history being under the size cap. Table number and name are constant for this endpoint (Table II) and are not repeated on every row; line_number (the statement's own line order) is the key within a day, since labels such as "Sub-Total Deposits" recur across account types.
Update Schedule
Static snapshot. Published every business day at 4 p.m. Eastern for the previous business day; refresh weekly.
Attribution
Source: U.S. Department of the Treasury, Bureau of the Fiscal Service, Daily Treasury Statement (public domain).
Schema
| name | type |
|---|---|
| record_date | date |
| line_number | integer |
| account_type | string |
| transaction_type | string |
| category | string |
| category_desc | string |
| today_amt_usd_millions | integer |
| month_to_date_usd_millions | integer |
| fiscal_ytd_usd_millions | integer |
Sample Data
| category | line_number | record_date | account_type | category_desc | transaction_type | today_amt_usd_millions | fiscal_ytd_usd_millions | month_to_date_usd_millions |
|---|---|---|---|---|---|---|---|---|
| Agriculture Loan Repayments (misc) | 1 | 2005-10-03 | Federal Reserve Account | Deposits | 62 | 62 | 62 | |
| Commodity Credit Corporation programs | 2 | 2005-10-03 | Federal Reserve Account | Deposits | 61 | 61 | 61 | |
| Customs and Certain Excise Taxes | 3 | 2005-10-03 | Federal Reserve Account | Deposits | 127 | 127 | 127 | |
| Deposits by States | 4 | 2005-10-03 | Federal Reserve Account | Supplemental Security Income | Deposits | 2 | 2 | 2 |
| Deposits by States | 5 | 2005-10-03 | Federal Reserve Account | Unemployment | Deposits | 12 | 12 | 12 |
Get this via API
# 1. Add dAgentBase once, in any MCP client. No install, no vendor keys.
# Claude.ai / Claude Desktop: Settings -> Connectors -> Add custom connector
# Cursor / Claude Code / others: mcp.json
{
"mcpServers": {
"dagentbase": {
"url": "https://dagentbase.com/api/mcp",
"headers": { "Authorization": "Bearer dm_live_YOUR_KEY" }
}
}
}
# 2. Then ask your agent, in plain language:
# "Preview 'US Treasury Daily Statement Deposits and Withdrawals — Operating Cash Flows by Account, Transaction Type and Category (DTS Table II), Today, Month-to-Date and Fiscal-Year-to-Date, Every Business Day since 2005' and, if it fits, claim it and download the files."
# Tools it will use: search_listings -> preview_listing -> purchase_listing -> get_download_urls
# 1. Add dAgentBase once, in any MCP client. No install, no vendor keys.
# Claude.ai / Claude Desktop: Settings -> Connectors -> Add custom connector
# Cursor / Claude Code / others: mcp.json
{
"mcpServers": {
"dagentbase": {
"url": "https://dagentbase.com/api/mcp",
"headers": { "Authorization": "Bearer dm_live_YOUR_KEY" }
}
}
}
# 2. Then ask your agent, in plain language:
# "Preview 'US Treasury Daily Statement Deposits and Withdrawals — Operating Cash Flows by Account, Transaction Type and Category (DTS Table II), Today, Month-to-Date and Fiscal-Year-to-Date, Every Business Day since 2005' and, if it fits, claim it and download the files."
# Tools it will use: search_listings -> preview_listing -> purchase_listing -> get_download_urlsone time · open license
Details
Available formats