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()Returns
number
Federal government receipts in billions of dollars
Examples
Current federal receipts in billions
=FederalReceipts()/1000Calculate surplus (positive = surplus)
=FederalReceipts()/Population()*1000When 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
What unit is the result in?
Billions of U.S. dollars.
What types of revenue are included?
All federal revenue including income tax, payroll tax, corporate tax, and excise taxes.
How often is the data updated?
Monthly, sourced from FRED/U.S. Treasury data.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?