An all-in-one Excel-based financial management dashboard designed to help you budget, track expenses, manage debt, and monitor investments. Built with advanced Excel, VBA automation, and Power Query, this tracker turns raw financial data into actionable insights.
- Custom Setup – Personalize with your name, opening balance, and monthly start date.
- Budget Planning – Allocate income across savings and expense categories.
- Expense Tracking – Log daily spending with auto-validation and category matching.
- Budget Dashboard – Visualize planned vs. actual spending with progress bars and alerts.
- Debt Manager – Track loans with automated payoff schedules (avalanche/snowball).
- Investment Tracker – Monitor stocks, crypto, and local investments with ROI calculations.
- All-in-One Dashboard – View income, expenses, savings, debt, and investments in one summary.
- Automation & Macros – VBA-powered automation for real-time updates and smooth workflows.
- Settings – Initial setup (personal info, bank balance, preferences).
- Savings & Budgeting / Expense Tracker – Plan your income and allocations.
- Budget Tracking – Record real-world expenses.
- Budget Dboard – Compare budget vs. actuals visually.
- Debt Manager – Add and monitor debts.
- Investments – Track asset growth and performance.
- Dashboard – Monthly summary view.
⚠️ Protected sheets (e.g., Calculations, Dropdown Data, Debt List) handle backend logic. Do not edit.
- Start in Settings – Enter your details.
- Plan your budget – Fill in Savings & Budgeting + Expense Tracker.
- Track spending – Log actuals in Budget Tracking.
- Manage debts & investments – Update as needed.
- Review Dashboard – Get a full overview of your finances.
- Dropdowns auto-filled for easy selection.
- Auto-calculated interest, ROI, and debt timelines.
- Visual alerts for overspending and debt deadlines.
- Real-time updates powered by Power Query and VBA macros.
If you encounter issues, contact: steve@datastagke.com
This tracker is designed to make personal finance simple and actionable. Use it consistently to:
- Stay on budget
- Save smarter
- Pay off debt
- Grow your investments
Take charge of your financial future.