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.
Free. Excel .xlsx format, no macros, no registration.
Contents
| Tab | Purpose |
|---|---|
| Start Here | Four steps to set up and use the planner. |
| My Budget | Monthly income and planned amounts by category, grouped into needs, wants, and savings and debt. |
| Spending Log | One line per transaction: date, description, category and amount. |
| Dashboard | Spending against budget for a selected month, by category and by group, with a chart. |
| Year at a Glance | Twelve months of spending by group compared with planned income. |
| Goals and Debts | Progress toward savings goals, and payoff time and interest for each debt. |
| Lists | Supporting lists used by the dropdowns. |
Features
- 32 categories, all renameable, with a dropdown in the spending log.
- Shows whether every dollar of income has been assigned.
- Categories over budget are highlighted on the dashboard.
- Handles variable income: enter what was actually received in any month.
- Compares the plan with the 50/30/20 guideline.
- Debt tracker estimates months to payoff and total interest.
- Room for 1,500 spending entries.
Instructions
- On the My Budget tab, enter monthly income and a planned amount for each category.
- Record spending on the Spending Log tab.
- Select a month on the Dashboard tab.
- 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
- Budget Calculator (50/30/20)Split monthly take-home pay into needs, wants and savings using the 50/30/20 rule or percentages of your own.
- Debt Snowball vs Avalanche CalculatorCompare the snowball and avalanche methods for paying off several debts: months to debt-free and total interest for each.
- Emergency Fund CalculatorCalculate an emergency fund target from your monthly expenses, the gap from what you have saved and how long it will take to fill.
- Savings Goal CalculatorFind the monthly deposit needed to reach a savings goal by a target date, including interest on what you already have.
- Debt Payoff CalculatorFind how long it takes to pay off a credit card or loan balance at a fixed monthly payment, and the interest you will pay.
- Net Worth CalculatorCalculate net worth from a list of assets and a list of debts, with totals and your debt-to-asset ratio.
- Credit Card Minimum Payment CalculatorSee how long a credit card balance takes to clear, and what it costs in interest, if you only ever make the minimum payment.
- Rent Affordability CalculatorWork out how much rent fits your income at a percentage you choose, and the income needed for a given rent.
- Debt-to-Income Ratio CalculatorCalculate your debt-to-income ratio from monthly debt payments and gross monthly income.
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.