Wednesday, April 6, 2011

Stand on the budget could be easier than you think

Ask most of your friends how they're doing, and probably will tell you how busy their lives are. You may feel that too. Sometimes just thinking to reconcile work and family can be exhausting. Many of you use and love Excel in the workplace. Makes the tasks faster, keeps you organized and adds insight into data that surround you.

Many of you may already be taking advantage of those same benefits of Excel at home too. After all, how many of us know, sometimes keeping a handle on workplace data is easier than managing our family budgets.

We have shared models with you before on this blog, but today we want to highlight a really big family budget template.

Image of family budget template

This model allows you to monitor your expenses of households for the category and monitor expenditure. One cool feature is that it quickly identifies where you need to cut. That's why immediately calculates the difference between actual expenditure and objectives which it is set at the beginning of each month.

For example, below you can see the summary view of entertainment expenses with projected and actual costs, and the difference clearly called out.

Summary view of a single category

I also like how you can use this template to monitor your spending. When you need details, can quickly drill down into each category to see specific costs. And enter a new expense is easy, too. In addition, the budget will automatically update with each new entry.

Here is an example of the details around monthly expenses. You can quickly see where spending has gotten a little hand in the categories of Entertainment and food.

Monthly expenses details view

If you need a little help with your family budget, and already love Excel, check out this model. It not only makes it easier to stay on budget, but also helps make every penny and every minute counts, so you can use your valuable time at home to do things that are more fun, like playing monopoly with your children, take a walk with your spouse, or even taking a NAP (my ideal way to spend a Saturday afternoon).

-Amy Miller

View the original article here

No comments: