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.
 th
th
on
on
m
m
by
by
et
et
Quick dg
dg
bu
Budget
bu
aa Chart: Yearly
te
te
Income Frequency Amount
ea
ea
Monthly Yearly Budget Summary
cr
cr
Total Income (net) 26000.00 312000.00
or
or
Salary/Wages Monthly 18000.00 18000.00 216000.00
Salary/Wages (Spouse) Monthly 8000.00 8000.00 96000.00 $(69,200)
Other Weekly 0.00 0.00
Other Monthly 0.00 0.00
Other Monthly 0.00 0.00 $312,000

Spending Total: 31766.67 381200.00

$381,200
Transportation 0.00 0.00
Auto Loan/Lease Monthly 0.00 0.00
Insurance Monthly 0.00 0.00 -$100,000 $0 $100,000 $200,000 $300,000 $400,000
Gas Weekly 0.00 0.00 Balance Income Expense
Maintenance Quarterly 0.00 0.00
Registration/Inspection Yearly 0.00 0.00
Bill's train pass Monthly 0.00 0.00
Spending Summary
Jane's bus pass Monthly 0.00 0.00
Other Monthly 0.00 0.00 $17,400
$39,200
Home 26000.00 312000.00
$3,600
EMI Monthly 0.00 0.00
$9,000
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 6000.00 26000.00 312000.00
Real Estate Tax Semi-Annually 0.00 0.00
Other Monthly 0.00 0.00 $312,000
Other Monthly 0.00 0.00

Utilities 750.00 9000.00

Phone - Home Monthly 0.00 0.00
Transportation Home Utilities
Phone - Cell Monthly 500.00 500.00 6000.00
Health Entertainment Miscellaneous
Cable Monthly 250.00 250.00 3000.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

Health 300.00 3600.00

Dental Monthly 0.00 0.00
Medical Monthly 300.00 300.00 3600.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

Entertainment 3266.67 39200.00

Memberships Monthly 0.00 0.00
Dining out Monthly 2500.00 2500.00 30000.00
Events Monthly 0.00 0.00
Subscriptions Monthly 0.00 0.00
Movies Monthly 500.00 500.00 6000.00
Music Monthly 200.00 200.00 2400.00
Hobbies Weekly 0.00 0.00
Travel/ Vacation Yearly 800.00 66.67 800.00
Other Monthly 0.00 0.00
Other Monthly 0.00 0.00

Miscellaneous 1450.00 17400.00

Dry Cleaning Monthly 0.00 0.00
New Clothes Semi-Annually 1500.00 250.00 3000.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 200.00 200.00 2400.00
Credit Card Monthly 1000.00 1000.00 12000.00
Other Monthly 0.00 0.00
Other Monthly 0.00 0.00
Other Monthly 0.00 0.00
 et
et
dg
dg
bu
bu
kk

Budget By
ic
ic
qu
qu

Month
aa
te
te Chart: March
1

ea
ea
Income Jan Feb cr
cr Mar Apr May 1 Months Budget Summary
Oct to Date

or
or
Total Income (net) 26000.00 0.00 0.00 0.00 0.00 26000.00 26000

Salary/Wages 18000.00 18000.00 18000

Salary/Wages (Spouse) 8000.00 8000.00 8000

$-
Other 0.00 0

Other 0.00 0

Other 0.00 0
$-

Spending Total: 14800.00 0.00 0.00 0.00 0.00 14800.00

14800 $-
Transportation 2000.00 0.00 0.00 0.00 0.00 2000.00 2000

Auto Loan/Lease 0.00 0

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

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 6000.00 0.00 0.00 0.00 0.00 6000.00 6000

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 6000.00 6000.00 6000

Real Estate Tax 0.00 0

Other 0.00 0

Other 0.00 0

Utilities 1000.00 0.00 0.00 0.00 0.00 1000.00 1000

Phone - Home 1000.00 1000.00 1000

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
30,000
Other 0.00 0

Other 0.00 0 25,000

Health 1000.00 0.00 0.00 0.00 0.00 1000.00 1000

20,000
Dental 0.00 0

Medical 1000.00 1000.00

15,000
1000

Medication 0.00 0

Vision/contacts 0.00 0

10,000
Life Insurance 0.00 0

Other 0.00 0

Other 0.00 5,000

0

Entertainment 2500.00 0.00 0.00 0.00 0.00 2500.00 0

Expense Income
2500

Memberships 0.00 0
Jan Feb Mar Apr May
Dining out 1500.00 1500.00 1500

Events 0.00 0

Subscriptions 0.00 0

Movies 1000.00 1000.00 1000

Music 0.00 0

Hobbies 0.00 0

Travel/ Vacation 0.00 0

Other 0.00 0

Other 0.00 0

Miscellaneous 2300.00 0.00 0.00 0.00 0.00 2300.00 2300

Dry Cleaning 300.00 300.00 300

New Clothes 1000.00 1000.00 1000

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 1000.00 1000.00 1000

Other 0.00 0

Other 0.00 0

Other 0.00 0
 Trackin
g 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
$-
Other 0.00
Other 0.00
Other 0.00
$-

Spending
$-
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 1 1
Insurance 0.00 Balance Income Expense
Gas 0.00
Maintenance 0.00
Registration/Inspection 0.00
Actuals by Month
Bill's train pass 0.00
Jane's bus pass 0.00
Other 0.00
1

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 1
Household Supplies 0.00
Groceries 0.00
Real Estate Tax 0.00
Other 0.00
Other 0.00
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 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
 Compariso Compare January to Budget January
n
Income Budget Jan Actual Vs Budget Tracking vs Budget Summary
Total Income (net) 26,000 0 -26,000
Salary/Wages 18000 -18,000.00 $11,200
Salary/Wages (Spouse) 8000 -8,000.00
Budget $26,000
Other 0.00
Other 0.00
$14,800
Other 0.00

Spending $-

Total Spending: 14,800 0 -14,800 Tracking$-

Transportation 2,000 0 -2,000

$-
Auto Loan/Lease 0.00
Insurance 0.00
Gas 0.00 0 5,000 10,000 15,000 20,000 25,000 30,000
Balance (Savings) Income Expense
Maintenance 2,000.00 -2,000.00
Registration/Inspection 0.00
Bill's train pass 0.00
Jane's bus pass 0.00 Spending Comparison
Other 0.00

Home 6,000 0 -6,000 6000

EMI 0.00
Rent 0.00
Maintenance 0.00
Insurance 0.00
Furniture 0.00
Household Supplies 0.00 2500
2300
Groceries 6,000.00 -6,000.00 2000
Real Estate Tax 0.00
Other 0.00 1000 1000
Other 0.00
0 0 0 0 0 0
Budget Tracking
Utilities 1,000 0 -1,000
Phone - Home 1,000.00 -1,000.00 Transportation Home Utilities
Phone - Cell 0.00 Health Entertainment Miscellaneous
Cable 0.00
Gas 0.00
Water 0.00
Electricity 0.00
Internet 0.00
Other 0.00
Other 0.00

Health 1,000 0 -1,000

Dental 0.00
Medical 1,000.00 -1,000.00
Medication 0.00
Vision/contacts 0.00
Life Insurance 0.00
Other 0.00
Other 0.00

Entertainment 2,500 0 -2,500

Memberships 0.00
Dining out 1,500.00 -1,500.00
Events 0.00
Subscriptions 0.00
Movies 1,000.00 -1,000.00
Music 0.00
Hobbies 0.00
Travel/ Vacation 0.00
Other 0.00
Other 0.00

Miscellaneous 2,300 0 -2,300

Dry Cleaning 300.00 -300.00
New Clothes 1,000.00 -1,000.00
Donations 0.00
Child Care 0.00
Tuition 0.00
College Loans 0.00
Pocket Money 0.00
Gifts 0.00
Credit Card 1,000.00 -1,000.00
Other 0.00
Other 0.00
Other 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: 900.00 450.00 315.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 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,665.00
Transportation 200.00 300.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 500.00
Auto Loan/Lease 0.00
Insurance 0.00
Gas 200.00 300.00 500.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 275.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 275.00
Phone - Home 0.00
Phone - Cell 275.00 275.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 700.00 150.00 40.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 890.00
Memberships 0.00
Dining out 700.00 150.00 40.00 890.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
 Month
Month ng
ng Help
Help
Budget
Budget ng
ng arison
arison
By
By Spendi
Spendi ew/
ew/
Quick
Quick Tracki
Tracki Comp
Comp
Budget
Budget Daily
Daily Overvi
Overvi

Daily Spending
Record
Spending 1st 2nd 3rd 4th 5th

Total Day's 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
Insurance
Gas
Maintenance
Registration/Inspection
Bill's train pass
Jane's bus pass
Other

Home 0.00 0.00 0.00 0.00 0.00

EMI
Rent
Maintenance
Insurance
Furniture
Household Supplies
Groceries
Real Estate Tax
Other
Other

Utilities 0.00 0.00 0.00 0.00 0.00

Phone - Home
Phone - Cell
Cable
Gas
Water
Electricity
Internet
Other
Other

Health 0.00 0.00 0.00 0.00 0.00

Dental
Medical
Medication
Vision/contacts
Life Insurance
 Other
Other

Entertainment 0.00 0.00 0.00 0.00 0.00

Memberships
Dining out
Events
Subscriptions
Movies
Music
Hobbies
Travel/ Vacation
Other
Other

Miscellaneous 0.00 0.00 0.00 0.00 0.00

Dry Cleaning
New Clothes
Donations
Child Care
Tuition
College Loans
Pocket Money
Gifts
Credit Card
Other
Other
Other
 Help
Help
ew/
ew/
Overvi
Overvi

6th 7th 8th 9th 10th 11th 12th 13th

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

14th 15th 16th 17th 18th 19th 20th 21st

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

22nd 23rd 24th 25th 26th 27th 28th 29th

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

30th 31st 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 0.00 0.00

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