XXLFormula AI
Pro TemplateFinanceBeginner

Monthly Budget Tracker

4.9· Updated Jul 2026

A polished personal-finance workbook with categorised income and expenses, savings targets, and a live dashboard that recalculates as you type. Ideal for households, freelancers, and anyone who wants a clear month-by-month picture of their money.

Excel compatibleGoogle Sheets compatible
Monthly Budget Tracker — XLFormula AIHomeInsertFormulasDataViewfx =SUM(B2:B13)ABCDEFGHI12345678910111213141516Revenue$48,290+12.4%Expenses$22,140-3.1%Net Income$26,150+18.9%Runway14 mo+1 moMonthly TrendCategory SplitTotal$22,140DashboardDataSettings+

Screenshots

Key features

  • Interactive dashboard with trend charts
  • Auto-categorised expenses with sub-totals
  • Savings goal progress bars
  • Rolling 12-month comparison view
  • Printable one-page summary

What's included

  • Excel .xlsx workbook (macro-free)
  • Google Sheets link with make-a-copy
  • Setup guide (PDF)
  • Example month prefilled with sample data
Included with Pro

Get this template — and every other one

Every download, every category, every future release for $5.00/month.

  • Unlimited Template Downloads
  • Excel Templates
  • Google Sheets Templates
  • AI Formula Generator
  • AI VBA Generator
  • Premium Formula Library
  • Future Template Updates

Frequently asked questions

Do I need Excel installed?
No — you can use the Google Sheets copy in your browser. Excel 2016+ is required for the .xlsx workbook.
Can I add my own categories?
Yes. Categories are driven by a single settings tab, so renaming or adding rows updates every formula automatically.
Does it support multiple currencies?
The workbook is currency-agnostic. Change the number format on the totals row to display any currency symbol.

Related templates