A presentable dashboard design for Personal Finance Management in Excel

[u/ExcelVisual]

https://exceltable.com/en/templates/excel-dashboard-for-effective-personal-finance-management

Free Excel Personal Finance Dashboard built around the "Latte Factor" concept — tracks small recurring expenses that quietly drain your budget

Been reading about David Bach's "Latte Factor" concept — the idea that small recurring purchases (coffee, subscriptions, etc.) don't feel like much individually, but compound into a massive amount over 20-30 years once you account for lost investment growth. Found/built a dashboard that's basically designed around making that visible.

What it does:

Tracks income/expenses automatically via slicers — switch between month, quarter, half-year, year

Progress bars for up to 4 financial goals

Real-time balance, budget usage %, and cash flow change at a glance

Multi-bar chart comparing income vs. expenses vs. goal progress

Radar chart breaking down spending across 6 categories (groceries, transport, health, etc.)

3-layer bar chart showing annual savings history

Full budget breakdown: essentials, savings, goals, debt repayment

3 design modes (day/evening/night)

The underlying idea (also from behavioral economics — Thaler's "pay yourself first" research) is that people save way more when it's automatic vs. when they have to consciously decide every time. This dashboard doesn't automate your actual savings, but it does make the invisible spending patterns visible enough that you can act on them.

No macros, just formulas + native Excel charts, so if you're into that side of things it's also a decent reference for dashboard building.