Rounding Robin

Home › Templates › Personal Budget Planner

Personal Budget Planner

A household budget designed for people who do not work with spreadsheets. Set a monthly plan, record spending as it happens, and the dashboard shows what is left in each category.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
Start HereFour steps to set up and use the planner.
My BudgetMonthly income and planned amounts by category, grouped into needs, wants, and savings and debt.
Spending LogOne line per transaction: date, description, category and amount.
DashboardSpending against budget for a selected month, by category and by group, with a chart.
Year at a GlanceTwelve months of spending by group compared with planned income.
Goals and DebtsProgress toward savings goals, and payoff time and interest for each debt.
ListsSupporting lists used by the dropdowns.

Features

Instructions

  1. On the My Budget tab, enter monthly income and a planned amount for each category.
  2. Record spending on the Spending Log tab.
  3. Select a month on the Dashboard tab.
  4. Add savings goals and debts on the Goals and Debts tab.

Notes

Example entries are included to show how the planner works. Clear them before use.

Related calculators

Need a version built for your process? Request a custom template quote.

To report an error or request a calculator or template, send feedback.

Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.