treasury_monthly_statement
Retrieve federal receipts, outlays, and deficit/surplus by month from the Monthly Treasury Statement. Filter by date range, exclude summary rows by default for clean line-item data.
Instructions
Monthly Treasury Statement (MTS table 1, keyless): federal receipts, outlays, and deficit/surplus by month. Returns record_date, classification, grossReceipts, grossOutlays, deficitSurplus (USD, number|null). startDate/endDate (ISO YYYY-MM-DD) filter record_date (default: trailing ~12 months). By default excludeSummaryRows=true drops the fiscal-year parent/summary header rows (whose amounts are all null) via a server-side filter, so totalAvailable and rows reflect real child line-items only; set excludeSummaryRows=false to include them. Highest-value budget-analysis tool.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| endDate | No | ISO YYYY-MM-DD upper bound on record_date (inclusive). | |
| pageSize | No | Rows per page, 1..500, default 100. | |
| startDate | No | ISO YYYY-MM-DD lower bound on record_date (inclusive). Default: trailing ~12 months. | |
| pageNumber | No | 1-based page number, default 1. | |
| excludeSummaryRows | No | true (default) excludes fiscal-year PARENT/SUMMARY rows (parent_id/amounts all null) via the server-side filter current_month_gross_outly_amt:gt:0, so only real child line-items (and totalAvailable) remain. false includes the null-amount summary rows. |