Budget Planner - Overview / Help: Instructions

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 7

Questions?

Questions?
Email
Email at
at :: [email protected]
[email protected]

Budget Planner - Overview / Help

Instructions Budget
Budget
Month
Month
You may move from worksheet to worksheet by clicking on the dark blue buttons Quick
Quick
By
By
Budget
located at the top of each worksheet or the blue tabs at the bottom of this workbook.
Budget

Enter data in only the white cells with gray borders: 400
Use the drop down boxes Aug To Date 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. Your savings can be invested in a better way and which will help you when you are in need!
Benefits to you
Often people find it difficult to manage their resources or fail to manage their income and expenditure leading to a life which no longer lead their
family or society in a happy and healthy situation. It can grow up as a social problem. Especially people work in Gulf Countries will have a
Big "0" balance once they retire or lose their job. We believe this can help you in this situation to manage your funds and help you lead a
Disciplined Life.
th
th
on
on
m
by
by
et
Quick Budget dg
dg
bu
bu
aa Chart: Monthly
te
te
Income Frequency Amount
ea
Monthly Yearly Budget Summary
cr
cr
Total Income (net) 0.00 0.00
or
or
Salary/Wages Monthly 0.00 0.00
Salary/Wages (Spouse) Monthly 0.00 0.00 0
Other Quarterly 0.00 0.00
Other Monthly 0.00 0.00
Other Monthly 0.00 0.00 0

Spending Total: 0.00 0.00


0
Transportation 0.00 0.00
Auto Loan/Lease Monthly 0.00 0.00
Insurance Monthly 0.00 0.00 $0 $0 $0 $0 $0 $1 $1 $1 $1 $1 $1
Petrol,Gas,Oil & Lub. Monthly 0.00 0.00 Expense Income Balance
Maintenance Semi-Annually 0.00 0.00
Registration/Inspection Yearly 0.00 0.00
Train/Bus tickets Monthly 0.00 0.00
Spending Summary
Taxis Monthly 0.00 0.00
Other Monthly 0.00 0.00

Home 0.00 0.00


Home Loan 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

Utilities 0.00 0.00


Phone - Home Monthly 0.00 0.00
Transportation Home Utilities
Phone - Cell Monthly 0.00 0.00
Health Entertainment Miscellaneous
Cable TV Monthly 0.00 0.00
Cooking 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

Health 0.00 0.00


Dental Monthly 0.00 0.00
Medical Monthly 0.00 0.00
Medicines Monthly 0.00 0.00
Vision/contacts Semi-Annually 0.00 0.00
Life Insurance Monthly 0.00 0.00
Yoga/Fitness Club Monthly 0.00 0.00
Other Monthly 0.00 0.00

Entertainment 0.00 0.00


Memberships Monthly 0.00 0.00
Dining out Weekly 0.00 0.00
Events Monthly 0.00 0.00
Subscriptions,Newspaper 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

Miscellaneous 0.00 0.00


Laundry,Dry Cleaning Monthly 0.00 0.00
New Clothes Quarterly 0.00 0.00
Donations/Charity 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
et
et
dg
bu
kk

Budget By Month
ic
qu

March
aa
te
te
2
Chart:
ea
ea
Income Aug Sep cr
cr Oct Nov Dec 0 Months Budget Summary
Oct to Date

or
Total Income (net) 0.00 0.00 0.00 0.00 0.00 0.00 0

Salary/Wages 0.00 0

Salary/Wages (Spouse) 0.00 0


0
Other 0.00 0

Other 0.00 0

Other 0.00 0
0

Spending Total: 0.00 0.00 0.00 0.00 0.00 0.00


0 0
Transportation 0.00 0.00 0.00 0.00 0.00 0.00 0

Auto Loan/Lease 0.00 0

Insurance 0.00 0
0 0 0 0 0 1 1 1 1 1 1
Gas 0.00 0
Expense Income Balance
Maintenance 0.00 0

Registration/Inspection 0.00 0

Bill's train pass 0.00 0

Spending Summary
Jane's bus pass 0.00 0

Other 0.00 0

Home 0.00 0.00 0.00 0.00 0.00 0.00 0

EMI 0.00 0

Rent 0.00 0

Maintenance 0.00 0

Insurance 0.00 0

Furniture 0.00 0

Household Supplies 0.00 0

Groceries 0.00 0

Real Estate Tax 0.00 0

Other 0.00 0

Other 0.00 0

Utilities 0.00 0.00 0.00 0.00 0.00 0.00 0

Phone - Home 0.00 0

Transportation Home Utilities


Phone - Cell 0.00 0

Health Entertainment Miscellaneous


Cable 0.00 0

Gas 0.00 0

Water 0.00 0 Budget by Month


Electricity 0.00 0

Internet 0.00 0
1
Other 0.00 0

1
Other 0.00 0

Health 0.00 0.00 0.00 0.00 0.00 0.00 0


1
Dental 0.00 0
1
Medical 0.00
1
0

Medication 0.00 0

Vision/contacts 0.00 0
0

Life Insurance 0.00 0 0


Other 0.00 0

0
Other 0.00 0

Entertainment 0.00 0.00 0.00 0.00 0.00 0.00 0


Expense Income
0

Memberships 0.00 0
Aug Sep Oct Nov Dec
Dining out 0.00 0

Events 0.00 0

Subscriptions 0.00 0

Movies 0.00 0

Music 0.00 0

Hobbies 0.00 0

Travel/ Vacation 0.00 0

Other 0.00 0

Other 0.00 0

Miscellaneous 0.00 0.00 0.00 0.00 0.00 0.00 0

Dry Cleaning 0.00 0

New Clothes 0.00 0

Donations 0.00 0

Child Care 0.00 0

Tuition 0.00 0

College Loans 0.00 0

Pocket Money 0.00 0

Gifts 0.00 0

Credit Card 0.00 0

Other 0.00 0

Other 0.00 0

Other 0.00 0
Tracking
Chart: September
Income Oct Nov Dec Jan Oct to Date Actual Income/Spend Summary
Total Income (net) 0.00 0.00 0.00 0.00 0.00
Salary/Wages 0.00
Salary/Wages (Spouse) 0.00
0
Other 0.00
Other 0.00
Other 0.00
0

Spending
0
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 0 0 0 0 0 1 1 1 1 1 1
Insurance 0.00 Expense Income Balance
Petrol,Gas,Oil & Lub. 0.00
Maintenance 0.00
Registration/Inspection 0.00
Actuals by Month
Train/Bus tickets 0.00
Taxis 0.00
Other 0.00
1

Home 0.00 0.00 0.00 0.00 0.00 1


Home Loan EMI 0.00 1
Rent 0.00 1
Maintenance 0.00
1
Insurance 0.00
Furniture 0.00 1
Household Supplies 0.00 0
Groceries 0.00 0
Real Estate Tax 0.00
0
Other 0.00
Other 0.00 0

0 Expense Income
Utilities 0.00 0.00 0.00 0.00 0.00 Oct Nov Dec Jan
Phone - Home 0.00
Phone - Cell 0.00
Cable TV 0.00
Cooking 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
Medicines 0.00
Vision/contacts 0.00
Life Insurance 0.00
Yoga/Fitness Club 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,Newspaper 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


Laundry,Dry Cleaning 0.00
New Clothes 0.00
Donations/Charity 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
Comparison Compare October to Budget October

Income Budget Oct Actual Vs Budget Tracking vs Budget Summary


Total Income (net) 0 0 0
Salary/Wages 0 0.00 0
Salary/Wages (Spouse) 0 0.00
Budget 0
Other 0 0.00
Other 0 0.00
0
Other 0 0.00

Spending 0

Total Spending: 0 0 0 Tracking


0
Transportation 0 0 0
0
Auto Loan/Lease 0.00 0.00
Insurance 0.00 0.00
Petrol,Gas,Oil & Lub. 0.00 0.00 0 0 0 0 0 1 1 1 1 1 1
Expense Income Balance (Savings)
Maintenance 0.00 0.00
Registration/Inspection 0.00 0.00
Train/Bus tickets 0.00 0.00
Taxis 0.00 0.00 Spending Comparison
Other 0.00 0.00

Home 0 0 0
Home Loan EMI 0.00 0.00
Rent 0.00 0.00
Maintenance 0.00 0.00
Insurance 0.00 0.00
Furniture 0.00 0.00
Household Supplies 0.00 0.00
Groceries 0.00 0.00
Real Estate Tax 0.00 0.00
Other 0.00 0.00
Other 0.00 0.00
0 0 0 0 0 0 0 0 0 0 0 0
Budget Tracking
Utilities 0 0 0
Phone - Home 0.00 0.00 Transportation Home Utilities
Phone - Cell 0.00 0.00 Health Entertainment Miscellaneous
Cable TV 0.00 0.00
Cooking Gas 0.00 0.00
Water 0.00 0.00
Electricity 0.00 0.00
Internet 0.00 0.00
Other 0.00 0.00
Other 0.00 0.00

Health 0 0 0
Dental 0.00 0.00
Medical 0.00 0.00
Medicines 0.00 0.00
Vision/contacts 0.00 0.00
Life Insurance 0.00 0.00
Yoga/Fitness Club 0.00 0.00
Other 0.00 0.00

Entertainment 0 0 0
Memberships 0.00 0.00
Dining out 0.00 0.00
Events 0.00 0.00
Subscriptions,Newspaper 0.00 0.00
Movies 0.00 0.00
Music 0.00 0.00
Hobbies 0.00 0.00
Travel/ Vacation 0.00 0.00
Other 0.00 0.00
Other 0.00 0.00

Miscellaneous 0 0 0
Laundry,Dry Cleaning 0.00 0.00
New Clothes 0.00 0.00
Donations/Charity 0.00 0.00
Child Care 0.00 0.00
Tuition 0.00 0.00
College Loans 0.00 0.00
Pocket Money 0.00 0.00
Gifts 0.00 0.00
Credit Card 0.00 0.00
Other 0.00 0.00
Other 0.00 0.00
Other 0.00 0.00
Daily Spending Record

Spending 1st 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
Petrol,Gas,Oil & Lub. 0.00
Maintenance 0.00
Registration/Inspection 0.00
Train/Bus tickets 0.00
Taxis 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
Home Loan 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 TV 0.00
Cooking 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
Medicines 0.00
Vision/contacts 0.00
Life Insurance 0.00
Yoga/Fitness Club 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,Newspaper 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
Laundry,Dry Cleaning 0.00
New Clothes 0.00
Donations/Charity 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

You might also like