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. Questions? Email at milindskulkarni2005@yahoo.co.in Budget Planner -Overview /Help 400 Quick Budget Budget By Month Aug To DateChart: Frequency Amount Monthly Yearly Total Income (net) 0.00 0.00 Salary/Wages Monthly 0.00 0.00 Salary/Wages (Spouse) Monthly 0.00 0.00 Other Weekly 0.00 0.00 Other Monthly 0.00 0.00 Other Monthly 0.00 0.00 0.00 0.00 0.00 0.00 Auto Loan/Lease Monthly 0.00 0.00 Insurance Monthly 0.00 0.00 Gas Weekly 0.00 0.00 Maintenance Quarterly 0.00 0.00 Registration/Inspection Yearly 0.00 0.00 Bill's train pass Monthly 0.00 0.00 Jane's bus pass Monthly 0.00 0.00 Other Monthly 0.00 0.00 0.00 0.00 EMI Monthly 0.00 0.00 Rent Monthly 0.00 0.00 Maintenance Monthly 0.00 0.00 Insurance Monthly 0.00 0.00 Furniture Yearly 0.00 0.00 Household Supplies Monthly 0.00 0.00 Groceries Weekly 0.00 0.00 Real Estate Tax Semi-Annually 0.00 0.00 Other Monthly 0.00 0.00 Other Monthly 0.00 0.00 0.00 0.00 Phone -Home Monthly 0.00 0.00 Phone -Cell Monthly 0.00 0.00 Cable Monthly 0.00 0.00 Gas Monthly 0.00 0.00 Water Monthly 0.00 0.00 Electricity Monthly 0.00 0.00 Internet Monthly 0.00 0.00 Other Monthly 0.00 0.00 Other Monthly 0.00 0.00 0.00 0.00 Dental Monthly 0.00 0.00 Medical Monthly 0.00 0.00 Medication Monthly 0.00 0.00 Vision/contacts Semi-Annually 0.00 0.00 Life Insurance Monthly 0.00 0.00 Other Monthly 0.00 0.00 Other Monthly 0.00 0.00 0.00 0.00 Memberships Monthly 0.00 0.00 Dining out Monthly 0.00 0.00 Events Monthly 0.00 0.00 Subscriptions Monthly 0.00 0.00 Movies Monthly 0.00 0.00 Music Monthly 0.00 0.00 Hobbies Weekly 0.00 0.00 Travel/Vacation Yearly 0.00 0.00 Other Monthly 0.00 0.00 Other Monthly 0.00 0.00 0.00 0.00 Dry Cleaning Monthly 0.00 0.00 New Clothes Semi-Annually 0.00 0.00 Donations Monthly 0.00 0.00 Child Care Monthly 0.00 0.00 Tuition Monthly 0.00 0.00 College Loans Monthly 0.00 0.00 Pocket Money Weekly 0.00 0.00 Gifts Monthly 0.00 0.00 Credit Card Monthly 0.00 0.00 Other Monthly 0.00 0.00 Other Monthly 0.00 0.00 Other Monthly 0.00 0.00 Entertainment Miscellaneous Transportation Home Utilities Health Yearly Quick Budget Spending Total: Income 0 Transportation Home Utilities Health Entertainment Miscellaneous 000 $0 $0 $0 $1 $1 $1 Expense Income Balance Budget Summary Spending Summary-8 Chart: Apr May Jun Jul Aug 0 Months Oc t to Date Total Income (net) 0.00 0.00 0.00 0.00 0.00 0.00 #REF! Salary/Wages 0.00 #REF! Salary/Wages (Spouse) 0.00 #REF! Other 0.00 #REF! Other 0.00 #REF! Other 0.00 #REF! 0.00 0.00 0.00 0.00 0.00 0.00 #REF! 0.00 0.00 0.00 0.00 0.00 0.00 #REF! Auto Loan/Lease 0.00 #REF! Insurance 0.00 #REF! Gas 0.00 #REF! Maintenance 0.00 #REF! Registration/Inspection 0.00 #REF! Bill's train pass 0.00 #REF! Jane's bus pass 0.00 #REF! Other 0.00 #REF! 0.00 0.00 0.00 0.00 0.00 0.00 #REF! EMI 0.00 #REF! Rent 0.00 #REF! Maintenance 0.00 #REF! Insurance 0.00 #REF! Furniture 0.00 #REF! Household Supplies 0.00 #REF! Groceries 0.00 #REF! Real Estate Tax 0.00 #REF! Other 0.00 #REF! Other 0.00 #REF! 0.00 0.00 0.00 0.00 0.00 0.00 #REF! Phone -Home 0.00 #REF! Phone -Cell 0.00 #REF! Cable 0.00 #REF! Gas 0.00 #REF! Water 0.00 #REF! Electricity 0.00 #REF! Internet 0.00 #REF! Other 0.00 #REF! Other 0.00 #REF! 0.00 0.00 0.00 0.00 0.00 0.00 #REF! Dental 0.00 #REF! Medical 0.00 #REF! Medication 0.00 #REF! Vision/contacts 0.00 #REF! Life Insurance 0.00 #REF! Other 0.00 #REF! Other 0.00 #REF! 0.00 0.00 0.00 0.00 0.00 0.00 #REF! Memberships 0.00 #REF! Dining out 0.00 #REF! Events 0.00 #REF! Subscriptions 0.00 #REF! Movies 0.00 #REF! Music 0.00 #REF! Hobbies 0.00 #REF! Travel/Vacation 0.00 #REF! Other 0.00 #REF! Other 0.00 #REF! 0.00 0.00 0.00 0.00 0.00 0.00 #REF! Dry Cleaning 0.00 #REF! New Clothes 0.00 #REF! Donations 0.00 #REF! Child Care 0.00 #REF! Tuition 0.00 #REF! College Loans 0.00 #REF! Pocket Money 0.00 #REF! Gifts 0.00 #REF! Credit Card 0.00 #REF! Other 0.00 #REF! Other 0.00 #REF! Other 0.00 #REF! Transportation Home Utilities Health Entertainment Miscellaneous 0000 0 0 1 1 1 Expense Income Balance March Spending Total: Income Budget By Month 000111 Apr May Jun Jul Aug Expense Income 0 Transportation Home Utilities Health Entertainment Miscellaneous Budget Summary Spending Summary Budget by MonthChart: Oct Nov Dec Jan Oct to Date Total Income (net) 0.00 0.00 0.00 0.00 0.00 Salary/Wages 0.00 Salary/Wages (Spouse) 0.00 Other 0.00 Other 0.00 Other 0.00 Total Spending: 0.00 0.00 0.00 0.00 0.00 Transportation 0.00 0.00 0.00 0.00 0.00 Auto Loan/Lease 0.00 Insurance 0.00 Gas 0.00 Maintenance 0.00 Registration/Inspection 0.00 Bill's train pass 0.00 Jane's bus pass 0.00 Other 0.00 Home 0.00 0.00 0.00 0.00 0.00 EMI 0.00 Rent 0.00 Maintenance 0.00 Insurance 0.00 Furniture 0.00 Household Supplies 0.00 Groceries 0.00 Real Estate Tax 0.00 Other 0.00 Other 0.00 Utilities 0.00 0.00 0.00 0.00 0.00 Phone -Home 0.00 Phone -Cell 0.00 Cable 0.00 Gas 0.00 Water 0.00 Electricity 0.00 Internet 0.00 Other 0.00 Other 0.00 Health 0.00 0.00 0.00 0.00 0.00 Dental 0.00 Medical 0.00 Medication 0.00 Vision/contacts 0.00 Life Insurance 0.00 Other 0.00 Other 0.00 Entertainment 0.00 0.00 0.00 0.00 0.00 Memberships 0.00 Dining out 0.00 Events 0.00 Subscriptions 0.00 Movies 0.00 Music 0.00 Hobbies 0.00 Travel/Vacation 0.00 Other 0.00 Other 0.00 Miscellaneous 0.00 0.00 0.00 0.00 0.00 Dry Cleaning 0.00 New Clothes 0.00 Donations 0.00 Child Care 0.00 Tuition 0.00 College Loans 0.00 Pocket Money 0.00 Gifts 0.00 Credit Card 0.00 Other 0.00 Other 0.00 Other 0.00 September Spending Income Tracking 00000111111 Oct Nov Dec Jan Expense Income 0000 0 0 1 1 1 Expense Income Balance Actuals by Month Actual Income/Spend SummaryCompare to Budget October Budget Oct Actual Vs Budget Total Income (net) 0 0 0 Salary/Wages 0 0.00 0.00 Salary/Wages (Spouse) 0 0.00 0.00 Other 0 0.00 0.00 Other 0 0.00 0.00 Other 0 0.00 0.00 Total Spending: 0 0 0 Transportation 0 0 0 Auto Loan/Lease 0.00 0.00 0.00 Insurance 0.00 0.00 0.00 Gas 0.00 0.00 0.00 Maintenance 0.00 0.00 0.00 Registration/Inspection 0.00 0.00 0.00 Bill's train pass 0.00 0.00 0.00 Jane's bus pass 0.00 0.00 0.00 Other 0.00 0.00 0.00 Home 0 0 0 EMI 0.00 0.00 0.00 Rent 0.00 0.00 0.00 Maintenance 0.00 0.00 0.00 Insurance 0.00 0.00 0.00 Furniture 0.00 0.00 0.00 Household Supplies 0.00 0.00 0.00 Groceries 0.00 0.00 0.00 Real Estate Tax 0.00 0.00 0.00 Other 0.00 0.00 0.00 Other 0.00 0.00 0.00 Utilities 0 0 0 Phone -Home 0.00 0.00 0.00 Phone -Cell 0.00 0.00 0.00 Cable 0.00 0.00 0.00 Gas 0.00 0.00 0.00 Water 0.00 0.00 0.00 Electricity 0.00 0.00 0.00 Internet 0.00 0.00 0.00 Other 0.00 0.00 0.00 Other 0.00 0.00 0.00 Health 0 0 0 Dental 0.00 0.00 0.00 Medical 0.00 0.00 0.00 Medication 0.00 0.00 0.00 Vision/contacts 0.00 0.00 0.00 Life Insurance 0.00 0.00 0.00 Other 0.00 0.00 0.00 Other 0.00 0.00 0.00 Entertainment 0 0 0 Memberships 0.00 0.00 0.00 Dining out 0.00 0.00 0.00 Events 0.00 0.00 0.00 Subscriptions 0.00 0.00 0.00 Movies 0.00 0.00 0.00 Music 0.00 0.00 0.00 Hobbies 0.00 0.00 0.00 Travel/Vacation 0.00 0.00 0.00 Other 0.00 0.00 0.00 Other 0.00 0.00 0.00 Miscellaneous 0 0 0 Dry Cleaning 0.00 0.00 0.00 New Clothes 0.00 0.00 0.00 Donations 0.00 0.00 0.00 Child Care 0.00 0.00 0.00 Tuition 0.00 0.00 0.00 College Loans 0.00 0.00 0.00 Pocket Money 0.00 0.00 0.00 Gifts 0.00 0.00 0.00 Credit Card 0.00 0.00 0.00 Other 0.00 0.00 0.00 Other 0.00 0.00 0.00 Other 0.00 0.00 0.00 000000 0 0 0 1 1 1 Expense Income Balance (Savings) Tracking Budget October Spending Income Comparison 0 0 0 0 0 0 0 0 0 0 0 0 Transportation Home Utilities Health Entertainment Miscellaneous Tracking Budget Spending Comparison Tracking vs Budget Summary1st 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st Month Total Day's 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 Transportation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Auto Loan/Lease 0.00 Insurance 0.00 Gas 0.00 Maintenance 0.00 Registration/Inspection 0.00 Bill's train pass 0.00 Jane's bus pass 0.00 Other 0.00 Home 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 EMI 0.00 Rent 0.00 Maintenance 0.00 Insurance 0.00 Furniture 0.00 Household Supplies 0.00 Groceries 0.00 Real Estate Tax 0.00 Other 0.00 Other 0.00 Utilities 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Phone -Home 0.00 Phone -Cell 0.00 Cable 0.00 Gas 0.00 Water 0.00 Electricity 0.00 Internet 0.00 Other 0.00 Other 0.00 Health 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dental 0.00 Medical 0.00 Medication 0.00 Vision/contacts 0.00 Life Insurance 0.00 Other 0.00 Other 0.00 Entertainment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Memberships 0.00 Dining out 0.00 Events 0.00 Subscriptions 0.00 Movies 0.00 Music 0.00 Hobbies 0.00 Travel/Vacation 0.00 Other 0.00 Other 0.00 Miscellaneous 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dry Cleaning 0.00 New Clothes 0.00 Donations 0.00 Child Care 0.00 Tuition 0.00 College Loans 0.00 Pocket Money 0.00 Gifts 0.00 Credit Card 0.00 Other 0.00 Other 0.00 Other 0.00 Spending Daily Spending Record