Write out actuals for Treasury MTS API
Year = 2027
GTE Date: 2026-09-30

return to Menu

delete from mts_data

Rows deleted: 79

Table 2: Receipts/Outlays
Total Receipts5403327
Total Outlays7395800

Table 3: Summary of Receipts and Outlays
2629899Individual Income TaxesTotal--Individual Income Taxes
398640Corporation Income TaxesCorporation Income Taxes
35795Estate and Gift TaxesEstate and Gift Taxes
406059Customs DutiesCustoms Duties
49909Miscellaneous ReceiptsMiscellaneous Receipts
5475705Total ReceiptsTotal Receipts
1301255Interest on Treasury Debt Securities (Gross)Interest on Treasury Debt Securities (Gross)
7540434Total OutlaysTotal Outlays

replace mts_data (table_name,id,label,amt) values ("table_3","2","Individual Income Taxes","2629899"), ("table_3","3","Corporation Income Taxes","398640"), ("table_3","10","Estate and Gift Taxes","35795"), ("table_3","11","Customs Duties","406059"), ("table_3","12","Miscellaneous Receipts","49909"), ("table_3","13","Total Receipts","5475705"), ("table_3","33","Interest on Treasury Debt Securities (Gross)","1301255"), ("table_3","52","Total Outlays","7540434")

Table 4: Receipts
2845527Total -- Individual Income TaxesTotal--Individual Income Taxes
381415Corporation Income TaxesCorporation Income Taxes
1146866Total -- Federal Old-Age and Survivors Insurance Trust FundTotal OASI
194618Total -- Federal Disability Insurance Trust FundTotal DI
406134Total -- Federal Hospital Insurance Trust FundTotal HI
49090Total -- Unemployment InsuranceTotal Unemployment
8431Total -- Other RetirementTotal Other Retirement
3885Rail Pension and Supplemental AnnuityRR pension
2770Social Security Equivalent AccountRR Sosec
33342Miscellaneous Excise TaxesMisc Excise
23700Airport and Airway Trust FundAirport Airway Trust Fund
48671Highway Trust FundHighway Trust Fund
105995Total -- Excise TaxesTotal Excise
38720Estate and Gift TaxesEstate and Gift
173219Customs DutiesCustoms Duties
10480Deposit of Earnings, Federal Reserve SystemDeposit of Earnings, Federal Reserve System
46657Total -- Miscellaneous ReceiptsTotal Misc Receipts
5403327Total -- ReceiptsTotal Receipts

blank

Table 5: Outlays

https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/mts/mts_table_5?fields=record_date,classification_desc,src_line_nbr,current_fytd_net_outly_amt&filter=record_date:eq:2026-09-30,src_line_nbr:in:(87,145,213,217,218,219,222,223,224,225,226,296,309,437,443,448,454,455,664,665,666,667,669,670,671,672,699,504,713,806)

Array
(
    [data] => Array
        (
            [0] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Federal Old-Age and Survivors Insurance Trust Fund (Off-Budget):
                    [src_line_nbr] => 664
                    [current_fytd_net_outly_amt] => null
                )

            [1] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Benefit Payments
                    [src_line_nbr] => 670
                    [current_fytd_net_outly_amt] => 159902973901.26
                )

            [2] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Department of Defense--Military Programs:
                    [src_line_nbr] => 87
                    [current_fytd_net_outly_amt] => null
                )

            [3] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Total Outlays
                    [src_line_nbr] => 806
                    [current_fytd_net_outly_amt] => 7395799983313.23
                )

            [4] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Federal Supplementary Medical Insurance Trust Fund:
                    [src_line_nbr] => 222
                    [current_fytd_net_outly_amt] => null
                )

            [5] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Benefit Payments
                    [src_line_nbr] => 223
                    [current_fytd_net_outly_amt] => 612269181275.10
                )

            [6] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Administrative Expenses
                    [src_line_nbr] => 224
                    [current_fytd_net_outly_amt] => 5909221849.08
                )

            [7] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Medicare Prescription Drugs:
                    [src_line_nbr] => 225
                    [current_fytd_net_outly_amt] => null
                )

            [8] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Benefit Payments
                    [src_line_nbr] => 226
                    [current_fytd_net_outly_amt] => 198467589473.86
                )

            [9] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => FHA-Mutual Mortgage Insurance Capital Reserve Account
                    [src_line_nbr] => 296
                    [current_fytd_net_outly_amt] => -20353607252.24
                )

            [10] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Guarantees of Mortgage-Backed Securities
                    [src_line_nbr] => 309
                    [current_fytd_net_outly_amt] => -1386250708.70
                )

            [11] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Benefit Payments
                    [src_line_nbr] => 665
                    [current_fytd_net_outly_amt] => 1494558724109.46
                )

            [12] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Grants to States for Medicaid
                    [src_line_nbr] => 213
                    [current_fytd_net_outly_amt] => 722976709337.78
                )

            [13] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Total--Department of Defense--Military Programs
                    [src_line_nbr] => 145
                    [current_fytd_net_outly_amt] => 916836451162.99
                )

            [14] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Federal Hospital Insurance Trust Fund:
                    [src_line_nbr] => 217
                    [current_fytd_net_outly_amt] => null
                )

            [15] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Benefit Payments
                    [src_line_nbr] => 218
                    [current_fytd_net_outly_amt] => 464943865598.77
                )

            [16] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Administrative Expenses
                    [src_line_nbr] => 219
                    [current_fytd_net_outly_amt] => 3333057158.92
                )

            [17] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Total--Federal Aviation Administration
                    [src_line_nbr] => 437
                    [current_fytd_net_outly_amt] => 25616375293.38
                )

            [18] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Total--Federal Highway Administration
                    [src_line_nbr] => 443
                    [current_fytd_net_outly_amt] => 65950614452.73
                )

            [19] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Total--Federal Railroad Administration
                    [src_line_nbr] => 448
                    [current_fytd_net_outly_amt] => 7088662861.75
                )

            [20] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Total--Federal Transit Administration
                    [src_line_nbr] => 454
                    [current_fytd_net_outly_amt] => 21068434730.17
                )

            [21] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Maritime Administration
                    [src_line_nbr] => 455
                    [current_fytd_net_outly_amt] => -754356408.95
                )

            [22] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Total--Interest on Treasury Debt Securities (Gross)
                    [src_line_nbr] => 504
                    [current_fytd_net_outly_amt] => 1359953253416.84
                )

            [23] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Administrative Expenses
                    [src_line_nbr] => 666
                    [current_fytd_net_outly_amt] => 3735144330.40
                )

            [24] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Payment to Railroad Retirement Account
                    [src_line_nbr] => 667
                    [current_fytd_net_outly_amt] => 6324320000.00
                )

            [25] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Federal Disability Insurance Trust Fund (Off-Budget):
                    [src_line_nbr] => 669
                    [current_fytd_net_outly_amt] => null
                )

            [26] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Administrative Expenses
                    [src_line_nbr] => 671
                    [current_fytd_net_outly_amt] => 2941004430.41
                )

            [27] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Payment to Railroad Retirement Account
                    [src_line_nbr] => 672
                    [current_fytd_net_outly_amt] => 5927000.00
                )

            [28] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Total--Federal Deposit Insurance Corporation
                    [src_line_nbr] => 699
                    [current_fytd_net_outly_amt] => -22191862750.36
                )

            [29] => Array
                (
                    [record_date] => 2026-09-30
                    [classification_desc] => Public Enterprise Funds
                    [src_line_nbr] => 713
                    [current_fytd_net_outly_amt] => 1099804445.91
                )

        )

    [meta] => Array
        (
            [count] => 30
            [labels] => Array
                (
                    [record_date] => Record Date
                    [classification_desc] => Classification Description
                    [src_line_nbr] => Source Line Number
                    [current_fytd_net_outly_amt] => Current Fiscal Year to Date Net Outlays Amount
                )

            [dataTypes] => Array
                (
                    [record_date] => DATE
                    [classification_desc] => STRING
                    [src_line_nbr] => INTEGER
                    [current_fytd_net_outly_amt] => CURRENCY
                )

            [dataFormats] => Array
                (
                    [record_date] => YYYY-MM-DD
                    [classification_desc] => String
                    [src_line_nbr] => 10
                    [current_fytd_net_outly_amt] => $10.20
                )

            [total-count] => 30
            [total-pages] => 1
        )

    [links] => Array
        (
            [self] => &page%5Bnumber%5D=1&page%5Bsize%5D=100
            [first] => &page%5Bnumber%5D=1&page%5Bsize%5D=100
            [prev] => 
            [next] => 
            [last] => &page%5Bnumber%5D=1&page%5Bsize%5D=100
        )

)
87 0Department of Defense--Military Programs:Department of Defense--Military Programs:
145 916836Total--Department of Defense--Military ProgramsTotal--Department of Defense--Military Programs
213 722977Grants to States for MedicaidGrants to States for Medicaid
217 0Federal Hospital Insurance Trust Fund:Federal Hospital Insurance Trust Fund:
218 464944Benefit PaymentsBenefit Payments (HI)
219 3333Administrative ExpensesAdministrative Expenses (HI)
222 0Federal Supplementary Medical Insurance Trust Fund:Federal Supplementary Medical Insurance Trust Fund:
223 612269Benefit PaymentsBenefit Payments (SMI)
224 5909Administrative ExpensesAdministrative Expenses (SMI)
225 0Medicare Prescription Drugs:Medicare Prescription Drugs:
226 198468Benefit PaymentsBenefit Payments (Drug)
296 -20354FHA-Mutual Mortgage Insurance Capital Reserve AccountFHA-Mutual Mortgage Insurance Capital Reserve Account
309 -1386Guarantees of Mortgage-Backed SecuritiesGuarantees of Mortgage-Backed Securities
437 25616Total--Federal Aviation AdministrationTotal--Federal Aviation Administration
443 65951Total--Federal Highway AdministrationTotal--Federal Highway Administration
448 7089Total--Federal Railroad AdministrationTotal--Federal Railroad Administration
454 21068Total--Federal Transit AdministrationTotal--Federal Transit Administration
455 -754Maritime AdministrationMaritime Administration
664 0Federal Old-Age and Survivors Insurance Trust Fund (Off-Budget):Federal Old-Age and Survivors Insurance Trust Fund (Off-Budget):
665 1494559Benefit PaymentsOASI Benefit Payments
666 3735Administrative ExpensesOASI Administrative Expenses
667 6324Payment to Railroad Retirement AccountPayment to Railroad Retirement Account (OASI)
669 0Federal Disability Insurance Trust Fund (Off-Budget):Federal Disability Insurance Trust Fund (Off-Budget):
670 159903Benefit PaymentsBenefit Payments (DI)
671 2941Administrative ExpensesAdministrative Expenses (DI)
672 6Payment to Railroad Retirement AccountPayment to Railroad Retirement Account (DI)
699 -22192Total--Federal Deposit Insurance CorporationTotal--Federal Deposit Insurance Corporation
504 1359953Total--Interest on Treasury Debt Securities (Gross)Total--Interest on Treasury Debt Securities (Gross)
713 1100Public Enterprise FundsPublic Enterprise Funds
806 7395800Total OutlaysTotal Outlays

blank

Table 6: Debt
7746813Intragovernmental HoldingsIntragovernmental holdings
40171825Total Treasury Securities OutstandingTotal Treasury Securities Outstanding

blank

Table 9: Receipts/Outlays by Function
0Net OutlaysNet Outlays
965160National DefenseNational Defense
48015International AffairsInternational Affairs
39877General Science, Space, and TechnologyGeneral Science, Space
20971EnergyEnergy
57098Natural Resources and EnvironmentNatural Resources and Environment
52566AgricultureAgriculture
-15465Commerce and Housing CreditCommerce and Housing Credit
142864TransportationTransportation
62430Community and Regional DevelopmentCommunity and Regional Development
107551Education, Training, Employment, and Social ServicesEducation, Training, Employment, and Social Services
1025587HealthHealth
1072626MedicareMedicare
694224Income SecurityIncome Security
1667097Social SecuritySocial Security
416204Veterans Benefits and ServicesVeterans Benefits and Services
109915Administration of JusticeAdministration of Justice
32343General GovernmentGeneral Government
1051754Net InterestNet Interest
-155019Undistributed Offsetting ReceiptsUndistributed Offsetting Benefits
7395800TotalTotal

replace mts_data (table_name,id,label,amt) values ("table_3","2","Individual Income Taxes","2629899"), ("table_3","3","Corporation Income Taxes","398640"), ("table_3","10","Estate and Gift Taxes","35795"), ("table_3","11","Customs Duties","406059"), ("table_3","12","Miscellaneous Receipts","49909"), ("table_3","13","Total Receipts","5475705"), ("table_3","33","Interest on Treasury Debt Securities (Gross)","1301255"), ("table_3","52","Total Outlays","7540434"), ("table_4","5","Total -- Individual Income Taxes","2845527"), ("table_4","6","Corporation Income Taxes","381415"), ("table_4","14","Total -- Federal Old-Age and Survivors Insurance Trust Fund","1146866"), ("table_4","20","Total -- Federal Disability Insurance Trust Fund","194618"), ("table_4","27","Total -- Federal Hospital Insurance Trust Fund","406134"), ("table_4","36","Total -- Unemployment Insurance","49090"), ("table_4","40","Total -- Other Retirement","8431"), ("table_4","29","Rail Pension and Supplemental Annuity","3885"), ("table_4","30","Social Security Equivalent Account","2770"), ("table_4","43","Miscellaneous Excise Taxes","33342"), ("table_4","44","Airport and Airway Trust Fund","23700"), ("table_4","45","Highway Trust Fund","48671"), ("table_4","47","Total -- Excise Taxes","105995"), ("table_4","48","Estate and Gift Taxes","38720"), ("table_4","49","Customs Duties","173219"), ("table_4","51","Deposit of Earnings, Federal Reserve System","10480"), ("table_4","54","Total -- Miscellaneous Receipts","46657"), ("table_4","55","Total -- Receipts","5403327"), ("table_5","87","Department of Defense--Military Programs:","0"), ("table_5","145","Total--Department of Defense--Military Programs","916836"), ("table_5","213","Grants to States for Medicaid","722977"), ("table_5","217","Federal Hospital Insurance Trust Fund:","0"), ("table_5","218","Benefit Payments (HI)","464944"), ("table_5","219","Administrative Expenses (HI)","3333"), ("table_5","222","Federal Supplementary Medical Insurance Trust Fund:","0"), ("table_5","223","Benefit Payments (SMI)","612269"), ("table_5","224","Administrative Expenses (SMI)","5909"), ("table_5","225","Medicare Prescription Drugs:","0"), ("table_5","226","Benefit Payments (Drug)","198468"), ("table_5","296","FHA-Mutual Mortgage Insurance Capital Reserve Account","-20354"), ("table_5","309","Guarantees of Mortgage-Backed Securities","-1386"), ("table_5","437","Total--Federal Aviation Administration","25616"), ("table_5","443","Total--Federal Highway Administration","65951"), ("table_5","448","Total--Federal Railroad Administration","7089"), ("table_5","454","Total--Federal Transit Administration","21068"), ("table_5","455","Maritime Administration","-754"), ("table_5","664","Federal Old-Age and Survivors Insurance Trust Fund (Off-Budget):","0"), ("table_5","665","OASI Benefit Payments","1494559"), ("table_5","666","OASI Administrative Expenses","3735"), ("table_5","667","Payment to Railroad Retirement Account (OASI)","6324"), ("table_5","669","Federal Disability Insurance Trust Fund (Off-Budget):","0"), ("table_5","670","Benefit Payments (DI)","159903"), ("table_5","671","Administrative Expenses (DI)","2941"), ("table_5","672","Payment to Railroad Retirement Account (DI)","6"), ("table_5","699","Total--Federal Deposit Insurance Corporation","-22192"), ("table_5","504","Total--Interest on Treasury Debt Securities (Gross)","1359953"), ("table_5","713","Public Enterprise Funds","1100"), ("table_5","806","Total Outlays","7395800"), ("table_6","5","Intragovernmental Holdings","7746813"), ("table_6","6","Total Treasury Securities Outstanding","40171825"), ("table_9","13","Net Outlays","0"), ("table_9","14","National Defense","965160"), ("table_9","15","International Affairs","48015"), ("table_9","16","General Science, Space, and Technology","39877"), ("table_9","17","Energy","20971"), ("table_9","18","Natural Resources and Environment","57098"), ("table_9","19","Agriculture","52566"), ("table_9","20","Commerce and Housing Credit","-15465"), ("table_9","21","Transportation","142864"), ("table_9","22","Community and Regional Development","62430"), ("table_9","23","Education, Training, Employment, and Social Services","107551"), ("table_9","24","Health","1025587"), ("table_9","25","Medicare","1072626"), ("table_9","26","Income Security","694224"), ("table_9","27","Social Security","1667097"), ("table_9","28","Veterans Benefits and Services","416204"), ("table_9","29","Administration of Justice","109915"), ("table_9","30","General Government","32343"), ("table_9","31","Net Interest","1051754"), ("table_9","32","Undistributed Offsetting Receipts","-155019"), ("table_9","33","Total","7395800")

Done

return to Menu