7 Spreadsheets to Help you Create a Budget

by Tom Tousignant

in Blog, Wealth Building

Below are Seven different spreadsheets that you can download to help you create a budget.  They are in no particular order so you may want to read through and see which format matches your personality best.

Personal budgeting spreadsheet

This is a pretty complete budget and expense tracking spreadsheet. You would have to enter each purchase and details in order to get full and accurate tracking of daily expenses.

personal-budgeting-spreadsheet-thumb.jpg


Household budget template

Use this spreadsheet to track your spending. It adds up everything by category, so that you can build a budget from the results – use this for a month or so to really know where you money is going. 

household-budget-template-thumb.jpg


Personal Budget monthly spreadsheet

This one is good if you are trying to add up income and expenses and find the difference between the two.

personal-budget-monthly-spreadsheet-thumb.jpg


Family Budget planner

This one allows you to look at the whole year’s expenses and income with each month being a column in the sheet. 

This free family budget planner spreadsheet helps you create a budget for an entire year. Doing this can help you make predictions about where you may stand financially in the future, especially if you are moving, switching jobs, buying a home, or making other major life changes.

family-household-budget-planner-thumb.jpg


GLBL Budget Spreadsheet

It is different than most because it works by pay period, rather than by month.

glbl-household-budget-template-thumb.jpg


Debt Reduction spreadsheet

This is a really cool spreadsheet that helps you decide the best method for paying down your debts. It allows you to create a debt reduction schedule based on the debt-snowball method. The first page is a basic calculator for you to enter your information, choose your total monthly payment, and see a summary of the results based your debt reduction strategy. The second page is a printable payment schedule to help you keep track of your progress.

free-debt-snowball-template-spreadsheet-thumb.jpg


Personal Budget Worksheet

A famous Microsoft budgeting template. It is very simple, but has proven to be helpful with the 2,000,000+ downloads. It simply allows you to add up your expenses and your income showing the difference.

microsoft-excel-personal-budgeting-template-thumb.jpg


My best advice:  Build your own Spreadsheet!  

If you build your own, you will have all your personal categories included, and you will understand the math that will make you a better forecaster. Use these basic sections:

  • Top section:  Forecast the income you have coming in from working, commissions, bonuses, etc.
  • Second:  Forecast what you will Save / Invest / Give / pay down debt.
  • Third:  Forecast what you have to spend money on:  Mortgage, Auto Loan, Taxes, Etc
  • Third: Forecast things you will spend money on:  Food, Gasoline, Vacations, Etc
  • Fourth: Find out what is left and decide where you want to put that money:  Save, debt reduction, vacation, etc.
  • Fifth: If there is nothing left, it’s pretty simple: You need to figure out how to earn more, or where you can spend less.

Once you build your own – try Mint – this software is free, works on your PC, MAC, Droid or iPhone and tracks all your spending for you.  I’ve used Mint for about 16 months now and find it very useful.

Comment to let me know which spreadsheet you like best, or send me what you use so I can add it to this list!

Maggie Redmond December 15, 2010 at 10:58 am

I have been using the last spreadsheet “Personal Budget Worksheet” for the last 2 years and tweaked it to also use for my business. I really like it.

Tom Tousignant December 15, 2010 at 2:00 pm

The personal Budget Worksheet is a good one – it’s easy to get started with and to update.

Comments on this entry are closed.

Previous post:

Next post: