How to Do a Home Budget Tracking Template

by Contributor ; Updated July 27, 2017
A tracking spreadsheet is a must if you want to stay on your budget.

Items you will need

  • Computer
  • Spreadsheet software
  • Home budget records
  • Printer

A home budget tracking template is a tool to help you track finances in the home and keep you on a budget. This template can be adjusted to match your home budget tracking needs.

Step 1

Divide your budget template into seven columns for tracking home expenses.

Step 2

Label the tracking columns Home Budget Expense; Projected Use; Projected Amount; Budget Priority; Actual Use; Actual Amount; and Total Savings

Step 3

Choose a home budget tracking schedule for your template such as daily, weekly, bi-weekly or monthly.

Step 4

List all your home budget expenses under the budget expense columns tracking fixed bills first, then home expense needs, then personal needs and last discretionary spending. For example eating lunches out would be considered discretionary spending.

Step 5

List an estimate of how often you pay the expense in your home or buy the item in your Projected Use column. For example you estimate you will eat lunch out three times a week or 12 times a month, depending on the tracking schedule for your budget template.

Step 6

Next estimate the dollar amount you spend on this budget expense item under your Projected Amount column within your given tracking schedule. For example, say you estimate spending $20 per week on lunches away from home.

Step 7

Then assign a priority to the budget item according to how important it is to you. A priority of 1 means you cant do without it, a 2 you must have but can cut back, and a 3 you can eliminate it completely.

Step 8

Now track how many times you actually paid the expense in your Actual Use column of your budget template. For example you actually went to lunch two times that week, etc.

Step 9

Then write in how much you spent on the item in the given tracking period. You actually spent $17.50 on lunches away from home that week, for example.

Step 10

Now subtract your actual home budget amount from your projected to get your positive or negative savings balance and list it in the Total Savings column of your tracking template.

Tips

  • Make your tracking schedule short enough to focus and account for all spending. Look at cut backs first before trying to eliminate things on your template. List all home expenses first, then assign a priority to each and use this to look for cutbacks and to see which you might budget items want to eliminate.

Photo Credits

  • Stockbyte/Stockbyte/Getty Images