Skill Tracer
Skills › Scientific Agent Skills › usfiscaldata › datasets-fiscal.md

datasets-fiscal.md

191 lines · skills/usfiscaldata/references/datasets-fiscal.md at 5f2bc03

Open on GitHub
1# Fiscal Statement Datasets — U.S. Treasury Fiscal Data
2

Fiscal Statement Datasets — U.S. Treasury Fiscal Data

Raw lines 1 to 2
3## Daily Treasury Statement (DTS)
4
5The DTS dataset has **9 data tables**, all under `/v1/accounting/dts/`. Updated daily (business days).
6
7**Date Range:** October 2005 to present
8

Daily Treasury Statement (DTS)

The DTS dataset has 9 data tables, all under /v1/accounting/dts/. Updated daily (business days).

Date Range: October 2005 to present

Raw lines 3 to 8
9### DTS Tables
11| Table | Endpoint | Description |
12|-------|----------|-------------|
13| Operating Cash Balance | `/v1/accounting/dts/operating_cash_balance` | Treasury General Account balance |
14| Deposits & Withdrawals | `/v1/accounting/dts/deposits_withdrawals_operating_cash` | Changes to TGA |
15| Public Debt Transactions | `/v1/accounting/dts/public_debt_transactions` | Issues and redemptions of securities |
16| Adjustment of Public Debt | `/v1/accounting/dts/adjustment_public_debt_transactions_cash_basis` | Cash basis adjustments |
17| Debt Subject to Limit | `/v1/accounting/dts/debt_subject_to_limit` | Debt vs. statutory limit |
18| Inter-Agency Tax Transfers | `/v1/accounting/dts/inter_agency_tax_transfers` | Intra-government tax transfers |
19| Federal Tax Deposits | `/v1/accounting/dts/federal_tax_deposits` | Tax deposit activity |
20| Short-Term Cash Investments | `/v1/accounting/dts/short_term_cash_investments` | Cash investment activity |
21| Income Tax Refunds Issued | `/v1/accounting/dts/income_tax_refunds_issued` | Tax refund issuances |

DTS Tables

TableEndpointDescription
Operating Cash Balance/v1/accounting/dts/operating_cash_balanceTreasury General Account balance
Deposits & Withdrawals/v1/accounting/dts/deposits_withdrawals_operating_cashChanges to TGA
Public Debt Transactions/v1/accounting/dts/public_debt_transactionsIssues and redemptions of securities
Adjustment of Public Debt/v1/accounting/dts/adjustment_public_debt_transactions_cash_basisCash basis adjustments
Debt Subject to Limit/v1/accounting/dts/debt_subject_to_limitDebt vs. statutory limit
Inter-Agency Tax Transfers/v1/accounting/dts/inter_agency_tax_transfersIntra-government tax transfers
Federal Tax Deposits/v1/accounting/dts/federal_tax_depositsTax deposit activity
Short-Term Cash Investments/v1/accounting/dts/short_term_cash_investmentsCash investment activity
Income Tax Refunds Issued/v1/accounting/dts/income_tax_refunds_issuedTax refund issuances
Raw lines 9 to 22
23### Common DTS Fields
25| Field | Type | Description |
26|-------|------|-------------|
27| `record_date` | DATE | Business date |
28| `account_type` | STRING | Account/balance type |
29| `open_today_bal` | CURRENCY0 | Opening balance |
30| `open_month_bal` | CURRENCY0 | Opening month balance |
31| `open_fiscal_year_bal` | CURRENCY0 | Opening fiscal year balance |
32| `close_today_bal` | CURRENCY0 | Closing balance |
33| `transaction_today_amt` | CURRENCY0 | Today's transaction amount |
34| `transaction_mtd_amt` | CURRENCY0 | Month-to-date amount |
35| `transaction_fytd_amt` | CURRENCY0 | Fiscal year-to-date amount |
37Since April 18, 2022, `close_today_bal` is null. Select
38`account_type:eq:Treasury General Account (TGA) Closing Balance` and read
39`open_today_bal` for the closing balance (millions of USD). The similarly named
40opening-balance row is a different observation. See [examples.md](examples.md).
42Table II has category hierarchies; preserve `account_type`, `transaction_type`,
43`transaction_catg` and `transaction_catg_desc` before selecting totals. Use the
44explicit Table I total deposit/withdrawal rows for a daily cash-flow summary.
45Do not add cumulative `transaction_mtd_amt`/`transaction_fytd_amt` across dates.
47Federal Tax Deposits is historical; the current reporting structure uses
48Inter-Agency Tax Transfers and Table II. Short-Term Cash Investments is
49historical and was removed from the published report in February 2023.
51---

Common DTS Fields

FieldTypeDescription
record_dateDATEBusiness date
account_typeSTRINGAccount/balance type
open_today_balCURRENCY0Opening balance
open_month_balCURRENCY0Opening month balance
open_fiscal_year_balCURRENCY0Opening fiscal year balance
close_today_balCURRENCY0Closing balance
transaction_today_amtCURRENCY0Today's transaction amount
transaction_mtd_amtCURRENCY0Month-to-date amount
transaction_fytd_amtCURRENCY0Fiscal year-to-date amount

Since April 18, 2022, close_today_bal is null. Select account_type:eq:Treasury General Account (TGA) Closing Balance and read open_today_bal for the closing balance (millions of USD). The similarly named opening-balance row is a different observation. See examples.md.

Table II has category hierarchies; preserve account_type, transaction_type, transaction_catg and transaction_catg_desc before selecting totals. Use the explicit Table I total deposit/withdrawal rows for a daily cash-flow summary. Do not add cumulative transaction_mtd_amt/transaction_fytd_amt across dates.

Federal Tax Deposits is historical; the current reporting structure uses Inter-Agency Tax Transfers and Table II. Short-Term Cash Investments is historical and was removed from the published report in February 2023.

Raw lines 23 to 52
53## Monthly Treasury Statement (MTS)
55The MTS dataset has **18 data tables**, all under `/v1/accounting/mts/`. Updated monthly.
57**Date Range:** October 1980 to present

Monthly Treasury Statement (MTS)

The MTS dataset has 18 data tables, all under /v1/accounting/mts/. Updated monthly.

Date Range: October 1980 to present

Raw lines 53 to 58
59### MTS Tables
61| Endpoint | Description |
62|----------|-------------|
63| `/v1/accounting/mts/mts_table_1` | Summary of receipts, outlays, and deficit/surplus |
64| `/v1/accounting/mts/mts_table_2` | Summary of budget and off-budget results |
65| `/v1/accounting/mts/mts_table_3` | Summary of receipts and outlays |
66| `/v1/accounting/mts/mts_table_4` | Receipts of the U.S. Government |
67| `/v1/accounting/mts/mts_table_5` | Outlays of the U.S. Government |
68| `/v1/accounting/mts/mts_table_5m` | Receipts offset against outlays |
69| `/v1/accounting/mts/mts_table_6` | Means of financing the deficit or disposition of surplus |
70| `/v1/accounting/mts/mts_table_6a` | Analysis of change in excess of liabilities |
71| `/v1/accounting/mts/mts_table_6b` | Securities issued under special financing authorities |
72| `/v1/accounting/mts/mts_table_6c` | Federal agency borrowing via Treasury securities |
73| `/v1/accounting/mts/mts_table_6d` | Investments of federal accounts in federal securities |
74| `/v1/accounting/mts/mts_table_6e` | Guaranteed and direct loan financing, net activity |
75| `/v1/accounting/mts/mts_table_7` | Receipts and outlays by month |
76| `/v1/accounting/mts/mts_table_8` | Trust fund impact on budget results and holdings |
77| `/v1/accounting/mts/mts_table_9` | Summary of receipts by source and outlays by function |
78| `/v1/accounting/mts/mts_table_9_outlays_functions_subfunctions` | Outlays by function and subfunction |
79| `/v1/accounting/mts/mts_distributed_offsetting_receipts` | Distributed offsetting receipts |
80| `/v1/accounting/mts/mts_receipts_outlays_deficit_surplus` | Receipts, outlays, and deficit/surplus |

MTS Tables

EndpointDescription
/v1/accounting/mts/mts_table_1Summary of receipts, outlays, and deficit/surplus
/v1/accounting/mts/mts_table_2Summary of budget and off-budget results
/v1/accounting/mts/mts_table_3Summary of receipts and outlays
/v1/accounting/mts/mts_table_4Receipts of the U.S. Government
/v1/accounting/mts/mts_table_5Outlays of the U.S. Government
/v1/accounting/mts/mts_table_5mReceipts offset against outlays
/v1/accounting/mts/mts_table_6Means of financing the deficit or disposition of surplus
/v1/accounting/mts/mts_table_6aAnalysis of change in excess of liabilities
/v1/accounting/mts/mts_table_6bSecurities issued under special financing authorities
/v1/accounting/mts/mts_table_6cFederal agency borrowing via Treasury securities
/v1/accounting/mts/mts_table_6dInvestments of federal accounts in federal securities
/v1/accounting/mts/mts_table_6eGuaranteed and direct loan financing, net activity
/v1/accounting/mts/mts_table_7Receipts and outlays by month
/v1/accounting/mts/mts_table_8Trust fund impact on budget results and holdings
/v1/accounting/mts/mts_table_9Summary of receipts by source and outlays by function
/v1/accounting/mts/mts_table_9_outlays_functions_subfunctionsOutlays by function and subfunction
/v1/accounting/mts/mts_distributed_offsetting_receiptsDistributed offsetting receipts
/v1/accounting/mts/mts_receipts_outlays_deficit_surplusReceipts, outlays, and deficit/surplus
Raw lines 59 to 81
82### MTS field and unit differences
84| Table | Amount fields | Interpretation |
85|-------|---------------|----------------|
86| Table 1 | `current_month_gross_rcpt_amt`, `current_month_gross_outly_amt`, `current_month_dfct_sur_amt` | Dollar amounts; each publication includes multiple months, fiscal years and YTD rows |
87| Table 9 | `current_month_rcpt_outly_amt`, `current_fytd_rcpt_outly_amt`, `prior_fytd_rcpt_outly_amt` | Dollar amounts by receipt source/outlay function |
88| Monthly summary | `amt_category`, `mil_amt` | One category per reporting month; amount in millions of USD |
90`record_date` dates the publication, not necessarily the month described by a
91Table 1 row. For a simple monthly budget series use
92`mts_receipts_outlays_deficit_surplus` as shown in [examples.md](examples.md).
93Deficit is positive and surplus negative in its `Deficit/Surplus (-)` category.
95Tables have totals, subtotals and structural rows with null values. Reconcile
96`parent_id`/`classification_id` within each publication before aggregating;
97classification IDs change between publications. Do not filter Table 1 for
98"Total Receipts": its receipt and outlay values are columns on month/YTD rows.
99Table 9 line 120 is the documented total-receipts example; inspect its label and
100hierarchy and use `current_month_rcpt_outly_amt`.
102The dataset's generic notes describe published reports in millions, but live
103Table 1/9 API amounts are dollar-scale while `mil_amt` explicitly represents
104millions. Validate each field against the matching report; never apply one
105scaling factor to all MTS endpoints. API coverage starts at different dates by
106table; the dataset-wide 1980 start is not every table's first API observation.
108---

MTS field and unit differences

TableAmount fieldsInterpretation
Table 1current_month_gross_rcpt_amt, current_month_gross_outly_amt, current_month_dfct_sur_amtDollar amounts; each publication includes multiple months, fiscal years and YTD rows
Table 9current_month_rcpt_outly_amt, current_fytd_rcpt_outly_amt, prior_fytd_rcpt_outly_amtDollar amounts by receipt source/outlay function
Monthly summaryamt_category, mil_amtOne category per reporting month; amount in millions of USD

record_date dates the publication, not necessarily the month described by a Table 1 row. For a simple monthly budget series use mts_receipts_outlays_deficit_surplus as shown in examples.md. Deficit is positive and surplus negative in its Deficit/Surplus (-) category.

Tables have totals, subtotals and structural rows with null values. Reconcile parent_id/classification_id within each publication before aggregating; classification IDs change between publications. Do not filter Table 1 for "Total Receipts": its receipt and outlay values are columns on month/YTD rows. Table 9 line 120 is the documented total-receipts example; inspect its label and hierarchy and use current_month_rcpt_outly_amt.

The dataset's generic notes describe published reports in millions, but live Table 1/9 API amounts are dollar-scale while mil_amt explicitly represents millions. Validate each field against the matching report; never apply one scaling factor to all MTS endpoints. API coverage starts at different dates by table; the dataset-wide 1980 start is not every table's first API observation.

Raw lines 82 to 109
110## U.S. Government Revenue Collections
112**Endpoint:** `/v2/revenue/rcm`
113**Frequency:** Daily
114**Date Range:** October 2004 to present
116Daily tax and non-tax revenue collections.
118---

U.S. Government Revenue Collections

Endpoint: /v2/revenue/rcm Frequency: Daily Date Range: October 2004 to present

Daily tax and non-tax revenue collections.

Raw lines 110 to 119
120## Financial Report of the U.S. Government
122**Endpoint:** (8 tables)
123**Frequency:** Annual
124**Date Range:** September 1995 onward; inspect the latest published fiscal year
126Annual audited financial statements. Includes:
127- Balance sheets
128- Statement of net cost
129- Statement of operations
130- Statement of changes in net position
132---

Financial Report of the U.S. Government

Endpoint: (8 tables) Frequency: Annual Date Range: September 1995 onward; inspect the latest published fiscal year

Annual audited financial statements. Includes:

  • Balance sheets
  • Statement of net cost
  • Statement of operations
  • Statement of changes in net position
Raw lines 120 to 133
134## Monthly Treasury Disbursements
136**Frequency:** Monthly
137**Date Range:** October 2013 to present
139Monthly federal disbursements reports. The current catalog has no REST endpoint for this table; use its dataset-page downloads.
141---

Monthly Treasury Disbursements

Frequency: Monthly Date Range: October 2013 to present

Monthly federal disbursements reports. The current catalog has no REST endpoint for this table; use its dataset-page downloads.

Raw lines 134 to 142
143## Receipts by Department
145**Endpoint:** `/v1/accounting/od/receipts_by_department`
146**Frequency:** Annual
147**Date Range:** September 2015 to present
149Annual breakdown of federal receipts by department.
151---

Receipts by Department

Endpoint: /v1/accounting/od/receipts_by_department Frequency: Annual Date Range: September 2015 to present

Annual breakdown of federal receipts by department.

Raw lines 143 to 152
153## Treasury Managed Accounts
155**Frequency:** Quarterly
156**Date Range:** December 2022 to present (3 data tables)
158Agency-level Contract Disputes Receivables, No FEAR Act Receivables and Unclaimed Money balances. This dataset does not identify unclaimed money owed to individual people.
160---

Treasury Managed Accounts

Frequency: Quarterly Date Range: December 2022 to present (3 data tables)

Agency-level Contract Disputes Receivables, No FEAR Act Receivables and Unclaimed Money balances. This dataset does not identify unclaimed money owed to individual people.

Raw lines 153 to 161
162## Treasury Bulletin
164**Frequency:** Quarterly
165**Date Range:** March 2021 to present (13 tables)
167Quarterly financial report covering government finances, public debt, savings bonds, and more. Endpoints use the `/v1/accounting/tb/` prefix (not `/v1/accounting/od/`).
169| Endpoint | Description |
170|----------|-------------|
171| `/v1/accounting/tb/esf1_balances` | Exchange Stabilization Fund balances |
172| `/v1/accounting/tb/esf2_statement_net_cost` | ESF statement of net cost |
173| `/v1/accounting/tb/fcp1_weekly_report_major_market_participants` | Major market participants (weekly) |
174| `/v1/accounting/tb/fcp2_monthly_report_major_market_participants` | Major market participants (monthly) |
175| `/v1/accounting/tb/fcp3_quarterly_report_large_market_participants` | Large market participants (quarterly) |
176| `/v1/accounting/tb/ffo5_internal_revenue_by_state` | Internal revenue receipts by state |
177| `/v1/accounting/tb/ffo6_customs_border_protection_collections` | Customs and border protection collections |
178| `/v1/accounting/tb/ofs1_distribution_federal_securities_class_investors_type_issues` | Distribution of federal securities by class and investor |
179| `/v1/accounting/tb/ofs2_estimated_ownership_treasury_securities` | Estimated ownership of Treasury securities |
180| `/v1/accounting/tb/pdo1_offerings_regular_weekly_treasury_bills` | Offerings of regular weekly Treasury bills |
181| `/v1/accounting/tb/pdo2_offerings_marketable_securities_other_regular_weekly_treasury_bills` | Other marketable securities offerings |
182| `/v1/accounting/tb/uscc1_amounts_outstanding_circulation` | Amounts outstanding and in circulation |
183| `/v1/accounting/tb/uscc2_amounts_outstanding_circulation` | Amounts outstanding and in circulation (continued) |

Treasury Bulletin

Frequency: Quarterly Date Range: March 2021 to present (13 tables)

Quarterly financial report covering government finances, public debt, savings bonds, and more. Endpoints use the /v1/accounting/tb/ prefix (not /v1/accounting/od/).

EndpointDescription
/v1/accounting/tb/esf1_balancesExchange Stabilization Fund balances
/v1/accounting/tb/esf2_statement_net_costESF statement of net cost
/v1/accounting/tb/fcp1_weekly_report_major_market_participantsMajor market participants (weekly)
/v1/accounting/tb/fcp2_monthly_report_major_market_participantsMajor market participants (monthly)
/v1/accounting/tb/fcp3_quarterly_report_large_market_participantsLarge market participants (quarterly)
/v1/accounting/tb/ffo5_internal_revenue_by_stateInternal revenue receipts by state
/v1/accounting/tb/ffo6_customs_border_protection_collectionsCustoms and border protection collections
/v1/accounting/tb/ofs1_distribution_federal_securities_class_investors_type_issuesDistribution of federal securities by class and investor
/v1/accounting/tb/ofs2_estimated_ownership_treasury_securitiesEstimated ownership of Treasury securities
/v1/accounting/tb/pdo1_offerings_regular_weekly_treasury_billsOfferings of regular weekly Treasury bills
/v1/accounting/tb/pdo2_offerings_marketable_securities_other_regular_weekly_treasury_billsOther marketable securities offerings
/v1/accounting/tb/uscc1_amounts_outstanding_circulationAmounts outstanding and in circulation
/v1/accounting/tb/uscc2_amounts_outstanding_circulationAmounts outstanding and in circulation (continued)
Raw lines 162 to 184
185## Official sources
187Reviewed 2026-09-30 against the current dataset dictionaries and live API responses.
189- [Daily Treasury Statement](https://fiscaldata.treasury.gov/datasets/daily-treasury-statement/)
190- [Monthly Treasury Statement](https://fiscaldata.treasury.gov/datasets/monthly-treasury-statement/)
191- [Treasury Bulletin](https://fiscaldata.treasury.gov/datasets/treasury-bulletin/)

Official sources

Reviewed 2026-09-30 against the current dataset dictionaries and live API responses.

Raw lines 185 to 191