Budget Planner
Use our budget planner in Excel to work out what you are spending your money on and compare this with your income.
|
||||||||||||||||
Instructions | ||||||||||||||||
You may move from worksheet to worksheet by clicking on the dark blue buttons | ||||||||||||||||
located at the top of each worksheet or the blue tabs at the bottom of this workbook. | ||||||||||||||||
Enter data in only the white cells with gray borders: | ||||||||||||||||
Use the drop down boxes to chart different time periods (Current Month, Prior Month, Yearly, Jan, Feb, etc.) | ||||||||||||||||
Quick Budget | ||||||||||||||||
Create a quick and easy budget by filling out the white cells on the “Quick Budget” sheet. Enter the “Frequency” by using the drop down menu | ||||||||||||||||
provided in each cell. The Monthly/Yearly figures are calculated for you and compared to your Tracking (actual) figures on the “Comparison” sheet. | ||||||||||||||||
Make sure “Use this budget for comparison purposes” is selected. (If this box is not selected, the “Budget By Month” figures will be used for | ||||||||||||||||
comparison purposes instead.) | ||||||||||||||||
Budget by Month | ||||||||||||||||
Use the “Budget By Month” sheet to create a budget with greater detail. Select your first budget month by using the drop down box in | ||||||||||||||||
the “Income” section. To unhide future months, click the grey button at the top of the sheet labeled “Click here then Ctrl+Shift+0”. | ||||||||||||||||
Make sure “Use this budget for comparison purposes” is selected if you are building ‘a budget by month. (If this box is not selected, | ||||||||||||||||
the “Quick Budget” sheet figures will be used for comparison purposes instead.) | ||||||||||||||||
Tracking | ||||||||||||||||
Use this sheet to track your actual income and spending. Select your first tracking month by using the drop down box in the “Income” section. | ||||||||||||||||
These figures will be compared to your budgeted figures on the “Comparison” page. | ||||||||||||||||
Comparison | ||||||||||||||||
Use this sheet to monitor how well you are sticking to your budget. Compare different time periods by using the drop down box above the | ||||||||||||||||
“Income” section | ||||||||||||||||
Daily Spending | ||||||||||||||||
We’ve provided this sheet for those interested in tracking their spending on a daily basis. This simple record goes a long way in helping | ||||||||||||||||
you stick to your budget. | ||||||||||||||||
Click Here To Download Daily Expense Manager Excel