Monthly Budget Tracker

What it does

• Categories in six groups: income, bills, needs, wants, savings and debt. Up to 40 categories, each with its own monthly budget
• One transactions list: date, description, category from a drop-down and amount. No monthly tabs to copy
• Dashboard: pick a month and see budget, actual, what is left and the share used for every group and every category, with a progress bar and over-budget amounts in red
• Left over each month: income minus bills, needs, wants, savings and debt payments
• Year tab: every category for all 12 months, the year total, the yearly budget and what is left, plus totals by group
• Chart of income and spending by month
• Works for any year (change one cell), with room for 2,000 transactions. Any currency
• Prefer to budget by paycheck? Our 2027 Paycheck Budget Planner plans each payday; this one budgets by month

What you get

• XLSXMonthly-Budget-Tracker.xlsx (blank: starter categories, budgets ready for yours)
• XLSXMonthly-Budget-Tracker-with-Sample-Data.xlsx (a filled-in example: 19 categories, January to September)
• PDFQuick-start guide (PDF)

Good for

Anyone who wants a simple monthly budget: see where the money went, which categories ran over and how much was left each month.