How to Create a Budget on Excel ?

Create your own Personal Monthly Budget Template on Excel

How to Create a Budget on Excel ?
Image Source - https://www.flickr.com/photos/jamingray/979975865/
Excel templates to plan your budget is wise because Excel calculates your budget for you and you will have a personal template that can be updated monthly. When changes are made Excel automatically recalculates your totals on your spreadsheet so that it does all the hard work and all you do is save your new budget template.

Steps to Create your Budget on Excel:

Step 1: Set up a New Spreadsheet Template

First you will need a computer or laptop with Excel software. You can download it or use Google Docs as an alternative to create your Budget, but we will assume Excel for this tutorial. Go to Excel and open a blank page to create a new spreadsheet template by clicking on "new blank workbook". Label your Months or Weeks across the top of the columns starting with Column B. Use Column A to Label your categories of incoming and outgoing expenditures.

Step 2: Organize your Earning and Spending Amounts

Start by labeling two main categories for your left column of your spreadsheet: Income and Expenses. Then list subcategories for each. 

Start with Income and use two subcategories: Fixed Income and Variable Income

  • Fixed income represents any earnings or payments that come to you in the same amount on a fixed interval. 
  • Any other income such as commission or bonuses or personal business income from hobbies, consulting, home business, etc. need to categorised under variable income and these amounts can only be estimated.

List Expenses as your second main category down the left column on your Excel template.  Divide your Expenses category into three sub-categories:   Fixed Expenses, Variable Expenses and Periodic Expenses. 

  • Fixed Expenses include mortgage, auto, and utilities.  
  • Variable expenses should include food, gas, entertainment, etc. 
  • Periodic expenses are unlike variable in that the amounts can be fixed but the time interval may vary such as auto maintenance, taxes, etc.

Step 4:  Add Formulas for Calculation

Adding formulas on Excel can seem complex but there is only one main formula that we will need to help calculate our budget spreadsheets. This formula is called AutoSum. AutoSum adds data together represented by corresponding line numbers. Here are the basic steps: 

  • Click on the box in your table where you want the total of several boxes to appear (Cell B7 for example)
  • Press the Auto Sum button in the top-right of the Screen
  • Either hold down to expand your box to include any number of cells in your auto sum. Or, put the data in yourself by typing in the cell numbers in the function bar itself.
  • Input your data into the necessary cells and the AutoSum will recalculate your amounts.

Step 5:  Compare your Income and Expenses

To check how much you earn verses what you spend, there is another simple formula you can use.  Assuming your total income is represented in box 7 and total expenses in box 19 for example, use this formula =SUM(B7-B19) to subtract the two.

Place this box at the bottom of your other calculations and label Balance to represent this total which could be positive or negative - hopefully positive but if it's negative it indicates adjustments will need to be made.

Step 6:  Make Your Adjustments

One of the most important aspect of creating a budget whether you use Excel, or another spreadsheet program is to use it as a tool to adjust your spending and habits and make cuts or additions where necessary.

Step 7:  Save and Revisit

Finally, once you have made all your adjustments and you are happy with your outcome you can simply name your Excel budget template and save it. Make sure to revisit your spreadsheet often to accurately include any expenses and income adjustments when needed and you will then have a tool that can help you change habits and keep you in budget.

Additional Tips and Tricks:

Group variable forms of income that you aren't able to estimate as Reserve Funds category. Try not to include them if not absolutely necessary or at least estimate these amounts on the low side if you do include them in your budget.

Also, It is sometimes a good idea to list Other as a category under income or expenses to allow any sudden unexpected changes that cant be grouped and wont fall into a category every month.


Let us know how you like this article. Like it and Rate it below.
152 0
0
0 stars - by 0 user(s)

Related Articles

If you include investing your hard-earned money in your New Year's resolution this 2018, then it will not do you bad if you try investing in stocks. This article, as the title suggest talks about anything you need to know about stocks and the stock market..

An activity may be defined as something that somebody takes part in or does. Also, an activity is that in which something is happening or a lot of things are being done.

Unlike law, where extreme emphasis is placed on defining a word for the purpose of a given statute, words are often used somewhat loosely in other faculties, including economics. This is one of the reasons why many experts tend to use words like value, price and cost somewhat interchangeably, as if they relate to the same thing.

Post Your Comment

There are no comments yet.