Docstoc

Personal Budget Planner

Document Sample
Personal Budget Planner Powered By Docstoc
					Questions? Email at milindskulkarni2005@yahoo.co.in

Instructions Budget Planner - Overview / Help 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: Quick Budget Use the drop down boxes Aug To Date to chart different time periods (Current Month, Prior Month, Yearly, Jan, Feb, etc.)

Budget By Month

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 400 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.

Quick Budget
Total Income (net) Salary/Wages Salary/Wages (Spouse) Other Other Other

Chart: Yearly
Amount Monthly 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Yearly 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Frequency

Income

Monthly Monthly Weekly Monthly Monthly

0.00 0.00 0.00 0.00 0.00

0

Transportation Auto Loan/Lease Insurance (Car) Gas (Patrol) Maintenance Registration/Inspection Bill's train pass Jane's bus pass Other

Spending

Monthly Monthly Weekly Quarterly Yearly Monthly Total: Monthly Monthly

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0

0

Home EMI Rent Maintenance(Dadaa) Insurance Furniture Household Supplies Groceries Real Estate Tax Other Other Utilities Phone - Home Phone - Cell Cable Gas Water Electricity Internet Other Other Health Dental Medical Medication Vision/contacts Life Insurance Other Other Entertainment Memberships Dining out Events Subscriptions Movies Music Hobbies Travel/ Vacation Other Other Miscellaneous Dry Cleaning New Clothes Donations Child Care Tuition College Loans Pocket Money Gifts Credit Card Other Other Other

Monthly Monthly Monthly Monthly Yearly Monthly Monthly Semi-Annually Monthly Monthly

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

$0

$0

Monthly Monthly Monthly Monthly Monthly Monthly Monthly Monthly Monthly

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Monthly Monthly Monthly Semi-Annually Monthly Monthly Monthly

0.00 0.00 0.00 0.00 0.00 0.00 0.00

Transportation

Monthly Monthly Monthly Monthly Monthly Monthly Weekly Monthly Monthly Weekly

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Health

Monthly Semi-Annually Monthly Monthly Monthly Monthly Weekly Monthly Yearly Monthly Monthly Monthly

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Budget By Month
Jan

Chart:
6

January

Feb 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Mar 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Apr 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

May 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0 Months
Jan to Date

Total Income (net) Salary/Wages Salary/Wages (Spouse) Other Other Other

Income

0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00

0

0

0

0

0

0

0

0

Transportation Auto Loan/Lease Insurance Gas (Petrol) Maintenance Registration/Inspection Bill's train pass Jane's bus pass Other

0.00 0.00

Spending

Total:

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0

0

0

0

0

0

0

0

0

0

0

Home EMI Rent Maintenance Insurance Furniture Household Supplies Groceries Real Estate Tax Other Other Utilities Phone - Home Phone - Cell Cable Gas Water Electricity Internet Other Other Health Dental Medical Medication Vision/contacts Life Insurance Other Other Entertainment Memberships Dining out Events Subscriptions Movies Music Hobbies Travel/ Vacation Other Other Miscellaneous Dry Cleaning New Clothes Donations Child Care Tuition College Loans Pocket Money Gifts Credit Card Other Other Other

0.00

0.00

0.00

0.00

0.00

0

0

0

0

0

0

0

0

0

0

0

0

0.00

0.00

0.00

0.00

0.00

0

0

0

0

0

0

0

0

0

0

0.00

0.00

0.00

0.00

0.00

0

0

0

0

0

0

0

0

0.00

0.00

0.00

0.00

0.00

Transportation
0 0

Health

0

0

0

0

0

0

0

0

0

0.00

0.00

0.00

0.00

0.00

0

0

0

0

0

0

0

0

0

0

0

1 1 1 1 1 1 0 0 0 0 0 Jan

0

0

Tracking
Total Income (net) Salary/Wages Salary/Wages (Spouse) Other Other Other

Chart:
Jan 0.00 0.00 0.00 0.00 0.00 0.00 Feb 0.00 0.00 0.00 0.00 0.00 0.00 Mar 0.00 0.00 0.00 0.00 0.00 0.00 Apr 0.00 0.00 0.00 0.00 0.00 0.00 Jan to Date 0.00 0.00 0.00 0.00 0.00 0.00

January

Income

Actual Income/Sp

Total Spending: Transportation Auto Loan/Lease Insurance Gas (Petrol) Maintenance Registration/Inspection Bill's train pass Jane's bus pass Other

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0

0

Spending

0

Home EMI Rent Maintenance Insurance Furniture Household Supplies Groceries Real Estate Tax Other Other Utilities Phone - Home Phone - Cell Cable Gas Water Electricity Internet Other Other Health Dental Medical Medication Vision/contacts Life Insurance Other Other Entertainment Memberships Dining out Events Subscriptions Movies Music Hobbies Travel/ Vacation Other Other Miscellaneous Dry Cleaning New Clothes Donations Child Care Tuition College Loans Pocket Money Gifts Credit Card Other Other Other

0.00

0.00

0.00

0.00

0

1
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

1 1 1
1 1 0 0 0

0.00

0.00

0.00

0.00

0 0
Jan

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Compare January

to Budget

January

Comparison
Total Income (net) Salary/Wages Salary/Wages (Spouse) Other Other Other

Budget 0 0 0 0 0 0

Jan Actual 0 0.00 0.00 0.00 0.00 0.00

Vs Budget 0 0.00 0.00 0.00 0.00 0.00

Income

Tracking vs Budget Summary
0

Total Spending: Transportation Auto Loan/Lease Insurance Gas (Petrol) Maintenance Registration/Inspection Bill's train pass Jane's bus pass Other

0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Budget

0
0

Spending

0 Tracking

0
0

Home EMI Rent Maintenance Insurance Furniture Household Supplies Groceries Real Estate Tax Other Other Utilities Phone - Home Phone - Cell Cable Gas Water Electricity Internet Other Other Health Dental Medical Medication Vision/contacts Life Insurance Other Other Entertainment Memberships Dining out Events Subscriptions Movies Music Hobbies Travel/ Vacation Other Other Miscellaneous Dry Cleaning New Clothes Donations Child Care Tuition College Loans Pocket Money Gifts Credit Card Other Other Other

0

0

Balance (Savings)

Spending Comparison

0

0

0

0

0

Budget

Transportation Health

Month

Total Day's Spending:

Transportation Auto Loan/Lease Insurance Gas (Petrol) Maintenance Registration/Inspection Bill's train pass Jane's bus pass Other Home EMI Rent Maintenance Insurance Furniture Household Supplies Groceries Real Estate Tax Other Other Utilities Phone - Home Phone - Cell Cable Gas Water Electricity Internet Other Other Health Dental Medical Medication Vision/contacts Life Insurance Other Other Entertainment Memberships Dining out Events Subscriptions Movies Music Hobbies Travel/ Vacation Other Other Miscellaneous Dry Cleaning New Clothes Donations Child Care Tuition College Loans Pocket Money Gifts Credit Card Other Other Other

Daily Spending Record
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

1st

2nd

3rd

4th 0.00 0.00 0.00 0.00

5th 0.00 0.00 0.00 0.00

6th 0.00 0.00 0.00 0.00

7th 0.00 0.00 0.00 0.00

8th 0.00 0.00 0.00 0.00

9th 0.00 0.00 0.00 0.00

10th 0.00 0.00 0.00 0.00

11th 0.00 0.00 0.00

12th 0.00 0.00 0.00

13th 0.00 0.00 0.00

14th 0.00 0.00 0.00

15th 0.00 0.00 0.00

16th 0.00 0.00 0.00

17th 0.00 0.00 0.00

18th 0.00 0.00 0.00

19th 0.00 0.00 0.00

20th 0.00 0.00 0.00

21st 0.00 0.00 0.00

22nd 0.00 0.00 0.00

23rd 0.00 0.00 0.00

24th 0.00 0.00 0.00

25th 0.00 0.00 0.00

26th 0.00 0.00 0.00

27th 0.00 0.00 0.00

28th 0.00 0.00 0.00

29th 0.00 0.00 0.00

30th 0.00 0.00 0.00

31st 0.00 0.00 0.00

Month 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Income Spending

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00


				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:88
posted:6/27/2009
language:English
pages:6
Description: Personal Budget Planner