Federal Receipts

Returns total U.S. federal government receipts (revenue) in billions of dollars. This includes all federal tax collections and other revenue sources.

Data Details

Attribute Value
Source U.S. Treasury / FRED
Frequency Monthly
Unit Billions of USD
Seasonality Seasonally adjusted

Notes

  • Receipts include income taxes, payroll taxes, corporate taxes, excise taxes, and other revenue
  • Data is updated monthly with the latest available figures
  • Compare with FederalOutlays() to analyze the budget balance

Syntax

=FederalReceipts()
Excel Desktop (Windows)

Examples

Current federal receipts in billions
=FederalReceipts()/1000
Convert to trillions
Calculate surplus (positive = surplus)
Per capita receipts (in thousands)

When to Use

  • Tracking federal tax revenue trends
  • Comparing receipts to outlays for budget analysis
  • Economic research on fiscal policy
  • Revenue forecasting and analysis

When NOT to Use

Scenario Use Instead
Need federal spending FederalOutlays()
Need deficit/surplus directly FederalSurplusOrDeficit()
Need national debt FederalDebt()

Common Issues & FAQ

Q: What unit is the result in? A: Billions of U.S. dollars.

Q: What types of revenue are included? A: All federal revenue including income tax, payroll tax, corporate tax, and excise taxes.

Q: How often is the data updated? A: Monthly, sourced from FRED/U.S. Treasury data.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Federal Receipts and Other Financial Formulas
How does MarketXLS work?