We all have a budget, but what do we use to keep track of it? An ancient way was to use a pencil and a pad of paper and write down our income and expenses.

With the advent of the computer, more people have turned to keeping their budgets saved on their computer. I am sure there are many different programs out there to do this, but I personally use and recommend using a template found in Microsoft Excel 07. The template can be accessed by following these simple steps.

  1. Open up Microsoft Excel and click on New.
  2. Go to the Microsoft Office Online section (yes, you will need internet access for get this template) and click on the budget tab.
  3. Scroll down until you find the template titled “Personal budget2″ and double click on it to open it. Here is a picture of what the template looks like for your reference.

 

The template is extremely simple to use and edit. At the top, you input your income. Below that you can enter a wide variety of expenses. The program automatically calculates your total expenses at the bottom. At the very bottom is your net total of income vs expenses. You can view this to see if you have a surplus of deficit of spending for the month.

October 16, 2015 at 9:44 am by admin
Category: Personal Finance