If you have started making larger purchases, including houses, vehicles, etc. and it is getting harder for you to remember all the bills you have to pay or have already have paid and when they are due. You just need to create a Bill Tracking sheet in Microsoft Excel an user friendly way just to keep track of paid bills and also shows how much you have spent each month.
Following are the ways you can Track your Bills in Microsoft Excel.
You need to start with a blank spreadsheet by clicking in Microsoft office and then selecting Microsoft Excel. Now name the tab “Bills for Year” but instead of typing the word year, type in the year you are tracking. For example “Bills for 2011”. Now you need to save this spreadsheet somewhere you can easily access to.
In the first Cell in Row A, you need to enter the word “Total”, and then columns B-O enter this formula SUM (B4:B100). You have to make sure that you have to change the B in that formula to match the column you are in and format the items as currency. This row is very helpful to you as it will total up your bills for you as you use the spreadsheet. You also have an option to colour it as you see fit.
Start with Cell B2 and enter in the following headers. You can bold or colour them as you want to monthly average. 2011 Total, Jan-2011, Feb-2011, Mar-2011 and continue it till Dec-2011 normally due or billed o
Enter the first category of bills in Row 3 that you are going to track. For example, the categories can be House, cars, handsets, laptops etc. Color according to your preference.
Add up all your bills and formulas to total it. Enter the title of the first bill as “Mortage” in Row 4. You also need to copy this formula into cell B4:=+ IF(SUM(D4:O4)<>0,AVERAGE(D4:O4),0). And also copy this formula into cell B5:=SUM(D4:O4). You need to format the items as currency. And don’t forget to format the cells D4 through O4 as currency.
Repeat step 5 for each bill you have to pay by adding new bills down the line. Add any new categories as in step 4 whenever necessary.
Using the column P and Q to note each bill is normally due as well as how to pay it or any other notes that you may want to.
Each month, after paying your bills, enter in the total paid for the appropriate month. Do not write it on the spreadsheet until you have the payment.
Each year, you have to create a new tab from the previous one and delete all the payments. You will be able to reflect back on previous years and be prepared for how much you normally owe each month.
As an optional upload the spreadsheet to Google Documents to share privately with your spouse. I this way it will help booth of you to track bills that you each pay.
These simple steps help you to keep a track on all the bills that you have paid and are due to pay. It also keeps a check on your budget and shows you how much you have spent. This feature by Microsoft has helped people a lot. So just explore the option and make your life easy.