the home budget tour

Holly JusticePeople | Projects | Software | Communication

Come along for a quick tour of the Sample Home

Budget!

Holly Justice

There are several spreadsheets in the budget workbook. Let’s start with the “Family Budget Projection”.

Holly Just ice

Holly Justice

Here we project our estimated income and expenses for the year.

Holly Just ice

We start with sources of income for year such as paychecks. Extra income may recorded from gifts or tax returns.

Holly Just ice

We take a look at our bills and expenses from last year. For most expenses we usually project a slight increase.

Holly Just ice

We plan for special expenses like a vacation or a special project to fix up our house.

Holly Just ice

Holly Justice

From our monthly estimates, we can see the projection for each quarter and the entire year.

Holly Justice

Now let’s look at the “Family Budget Actual” spreadsheet.

Holly Just ice

Holly Justice

Here we start tracking our actual expenses and income monthly.

Holly Just ice

On a monthly basis, things could be better for us or worse, due to changes in income or expenses.

Holly Just ice

So our family takes a different approach. We look ahead and say “How we doing this quarter? ”

Holly Just ice

Holly Justice

For example,in January we are over budget due to high expenses. However, we will recover quickly the next month. The quarterly total is more important than the monthly total.

Holly Justice

Now let’s check to see “How Are We Doing?”

Holly Just ice

Here we can check our projection against the actual results.

Holly Just ice

Holly Justice

On this budget the electricity and natural gas cost more than we projected. Now we can improve our plan for next year.

Holly Just ice

The charts add visual meaning to the data. This chart shows we projected more income than we actually received.

Holly Justice

Now let’s look at the “Difference in Expenses Chart”.

Holly Just ice

Holly Justice

This chart shows the difference in projected verses actual expenses. When the cylinders fall below the middle line, your costs were greater than what you had projected.

Holly Justice

Now let’s look at the “Actual Expenses Chart”.

Holly Just ice

The final chart shows the allocation of money spent.

Holly Justice

This chart helps you see where you might be able to reduce your expenses.

Holly Justice

That’s all the tabs in the workbook! I hope you enjoyed this sample.

Holly JusticePeople | Projects | Software | Communication

I hope you will put your own spin on this

example to make a family budget to fit your

own needs.