Income & Expense Analytics Dashboard – Key Insights (Jan 1, 2024 – Oct 20, 2025)

High-Level Financial Summary

1. Total Income: $1.08 billion ↑ +6.18% vs previous comparable period
2. Total Expense: $630.33 million ↑ +6.18% (exactly matching income growth)
3. Passive Income: $135.17 million ↑ +6.18%
4. Expense-to-Income Ratio: 0.58 (58%) – healthy and stable

Monthly Trend

1. Both income and expenses remained remarkably steady throughout the 22-month period with only minor seasonal fluctuations.
2. Highest spending months: March, May, and August (highlighted as top 3 peak months).

Expense Breakdown by Category

1. Food – 42.74% (largest category by far)
2. Entertainment – 29.89%
3. Clothing – 17.12%
4. Electronics – 10.25%

Geographic Spending Insights (Top Counties/Cities by Total Spending)

Top spending cities include Albuquerque, Anaheim, Atlanta, Aurora, and Austin – indicating strong consumption in major metropolitan areas.Key Takeaways & Implications

1. Extremely disciplined financial profile: expenses grew at exactly the same rate as income → spending habits scale linearly with earnings.
2. Very strong Expense-to-Income ratio of 58% leaves significant room for savings/investment.
3. Food and Entertainment together account for ~73% of all expenses – lifestyle-driven rather than necessity-driven spending.
4. Spending is highly concentrated in a few high-population counties, suggesting urban professionals or higher-income households dominate the dataset.
5. Passive income contribution ($135M) is meaningful and growing in lockstep.

Recommendations

1. Leverage the low 58% expense ratio to aggressively boost savings or investment rate.
2. Target Food (43%) and Entertainment (30%) for potential optimization if faster wealth accumulation is desired.
3. Consider geographic-specific offers or loyalty programs in top-spending counties (Ada, Alameda, Allegheny, etc.) if this data belongs to a retail/F&B business.

Overall: Very healthy, scalable personal/business finances with significant spending power concentrated in lifestyle categories and major urban areas.

The dashboard is designed using Flexa Design, Flexa Tables, and Flexa Charts from Flexa Intel.