Budget Planner

  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Budget Planner as PDF for free.

More details

  • Words: 2,667
  • Pages: 8
Ques tions? Email at mil in dsku lkarni2005 @yahoo.co .in

Budget Planner - Overview / Help Budge t By Month

Quick Budge t

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

Current Month Prior Month Aug To Date January February March April May June July August September October November December

Current Month Prior Month Aug To Date

September

Daily

Overvi ew/ Help

Comp arison

Spend or create a budget ing by month

Tracki ng

Budge t By Month

Quick Budge t

Quick Budget

Monthly

Chart:

Income 1 1 4.33 1 1

Frequency

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

Spending

Monthly Monthly Weekly Monthly Monthly

Monthly Monthly Weekly Quarterly Yearly Monthly Monthly Monthly

Home EMI Rent Maintenance Insurance Furniture 0.08 Household Supplies 1 Groceries 4.33 Real Estate Tax 0.17 Mess 1 Other 1

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

1 1 1 1

1 1 1

Utilities Phone - Home Phone - Cell Cable

9995.00

Total:

Transportation Auto Loan/Lease Insurance 1 Gas 4.33 Maintenance 0.33 Registration/Inspection 0.08 Bill's train pass 1 Jane's bus pass 1 Other 1 1

Amount

Monthly Monthly Monthly

4000.00

1350.00

600.00

Monthly 9995.00 9995.00 0.00 0.00 0.00 0.00

Budget Summary

Yearly 119940.00 119940.00 0.00 0.00 0.00 0.00

7650.00

91800.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

5350.00 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1350.00 0.00

64200.00 48000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16200.00 0.00

600.00 0.00 600.00 0.00

7200.00 0.00 7200.00 0.00

$2,345

$9,995 Column Z $7,650 $0

$ 2 ,00 0

$ 4,0 0 0

Row 26

$6,00 0

Row 25

$ 8,0 00

$ 10,00 0

Row 24

Spending Summary

Quick Budget FALSE

Yearly Monthly Weekly 2

$5,350 $200 $500 $600

Transportation Health

$1,000

Home Entertainment

Utilities Miscellaneous

Pie Chart Transportation $Home $5,350 Utilities $600 Health $1,000 Entertainment $500 Miscellaneous $200

Bar Chart Balance Income Expense

$2,345 $9,995 $7,650

1 1 1 1 1 1

Gas Water Electricity Internet Other Other

Monthly Monthly Monthly Monthly Monthly Monthly

Health Dental Medical Medication Vision/contacts 0.17 Life Insurance 1 Other 1 Other 1

Monthly Monthly Monthly Semi-Annually Monthly Monthly Monthly

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

Monthly Monthly Monthly Monthly Monthly Monthly Weekly Yearly Monthly Monthly

1 1 1

1 1 1 1 1 1

4.33

Miscellaneous Dry Cleaning New Clothes Donations Child Care Tuition College Loans Pocket Money Gifts Credit Card Other Other Other 1 1

0.17

1 1 1 1 4.33

1 1 1 1

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

Daily Weekly Monthly Semi-Annually Quarterly Yearly

1000.00

500.00

200.00

0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00

1000.00 0.00 0.00 0.00 0.00 1000.00 0.00 0.00

12000.00 0.00 0.00 0.00 0.00 12000.00 0.00 0.00

500.00 0.00 500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

6000.00 0.00 6000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

200.00 200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2400.00 2400.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

ing

Daily

Overvi ew/ Help

or create Spend a quick budget

Comp arison

Tracki ng

Budge t By Month

Quick Budge t

Budget By Month

July

Chart: 3

Income

Jan

Feb

Mar

Apr

May

Budget Summary

1 Months Jul to Date

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

9995.00 9995.00

0.00

0.00

0.00

0.00

9995.00 9995.00 0.00 0.00 0.00 0.00

9995

0

9995

0

0

0

0

0

Column AK

Spending

Total:

0

9000.00

0.00

0.00

0.00

0.00

9000.00

0.00

0.00

0.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 00 000000

9000

Transportation Auto Loan/Lease Insurance Gas Maintenance Registration/Inspection Bill's train pass Jane's bus pass Other Home EMI Rent Maintenance Insurance Furniture Household Supplies Groceries Real Estate Tax Mess Other

6800.00 5000.00

0.00

0.00

0.00

0.00

1800.00

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

500.00

Health Dental Medical Medication Vision/contacts Life Insurance Other Other

1000.00

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

500.00

Miscellaneous Dry Cleaning New Clothes Donations Child Care Tuition College Loans Pocket Money Gifts Credit Card Other Other Other

200.00 200.00

0.00

0.00

0.00

0.00

500.00

0.00

0.00

0.00

0.00

1000.00

0.00

0.00

0.00

0.00

500.00

0.00

0.00

0.00

0.00

6800.00 5000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1800.00 0.00 500.00 0.00 500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1000.00 0.00 0.00 0.00 0.00 1000.00 0.00 0.00 500.00 0.00 500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 200.00 200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0

00111 11111

1111 111 111

11

0

0

Row 27

0

Row 26

Row 25

0

0

Budget by

Spending Summary

0

Chart:

Month

0

Mths/Wks

Jul TRUE

Start Mth

Bar Chart

$-

1

Balance

$-

Home

$-

4

Income

$-

6800

2 Monthly (avg.)

1 Months

Utilities

$-

Expense

$-

5000

3 Weekly (avg.)

1 Months

Health

$-

0

4 Current Month

Sep

Entertainment

$-

0

5 January

Jan

Miscellaneous

$-

0

6 February

Feb

0

7 March

Mar

0

8 April

Apr

0

9 May

May

10 June

Jun

11 July

Jul

12 August

Aug

13 September

Sep

14 October

Oct

15 November

Nov

16 December

Dec

0

0

500

0

500

Transportation Entertainment

Home Miscellaneous

Utilities

Health

0

0

Budget by Month

0

0

0

0

0

1000

0

0

0

0

1000

10,000 9,000 8,000 7,000 6,000 5,000 4,000 3,000 2,000 1,000 0

Jan

Feb

Mar

0

Apr

May

0

500

0

500

0

0

0

0

0

0

0

0

200

200

0

0

0

0

0

0

0

0

0

0

0

Row 16

Row 8

Row 8 Row 16

1

1 Budgeted

Transportation

1 Months

1800

11

Pie Chart

1 Yearly

0

$-

Overvi ew/ Help

Daily Spend ing

Comp arison

Tracki ng

Budge t By Month

Quick Budge t

Tracking

Jul to Date

Chart:

Income Total Income (net) Salary/Wages 3 Salary/Wages (Spouse) 4 Other 5 Other 6 Other 7

Spending Total Spending: Transportation Auto Loan/Lease Insurance Gas 14 Maintenance 15 Registration/Inspection 16 Bill's train pass 17 Jane's bus pass 18 Other 19

Jul 9995.00 9,995.00

Aug

Sep

0.00

Oct

0.00

Jul to Date

0.00

0.00

0.00

0.00

9741.22

0.00

0.00

0.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

20

5800.00 4,000.00

0.00

0.00

0.00

1,800.00

5800.00 4,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,800.00 0.00

32

Utilities Phone - Home Phone - Cell Cable 36 Gas 37 Water 38 Electricity 39 Internet 40 Other 41 Other 42 33

741.22

0.00

0.00

0.00

741.22 0.00 741.22 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00

0.00

0.00

1000.00 0.00 0.00 0.00 0.00 1,000.00 0.00 0.00

0.00

0.00

0.00

2000.00 0.00 2,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00

0.00

0.00

200.00 200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

34 35

741.22

43

Health Dental Medical Medication Vision/contacts 48 Life Insurance 49 Other 50 Other 51 44

1000.00

45 46 47

1,000.00

52

Entertainment Memberships Dining out Events Subscriptions 57 Movies 58 Music 59 Hobbies 60 Travel/ Vacation 61 Other 62 Other 63 53

2000.00

54 55

2,000.00

56

64

Miscellaneous Dry Cleaning New Clothes Donations Child Care 69 Tuition 70 College Loans 71 Pocket Money 72 Gifts 73 Credit Card 74 Other 75 Other 76 Other 77 65 66

9,995 Column AN

9741.22

13

Home EMI 22 Rent 23 Maintenance 24 Insurance 25 Furniture 26 Household Supplies 27 Groceries 28 Real Estate Tax 29 Mess 30 Other 31

254

Over Budget

12

21

Actual Income/Spend Summary

9995.00 9,995.00 0.00 0.00 0.00 0.00

200.00 200.00

67 68

9,741

-

-

-

0

9,741 2,000

4,000

Row 28

6,000

Row 27

8,000 9,000

Row 26

Actuals by Month 10,000 9,000 8,000 7,000 6,000 5,000 4,000 3,000 2,000 1,000 0

9 8

Jul

Aug

Sep

Row 17

Oct

Row 8

Row 8 Row 17

3 Jul to Date 1 Sep 1 Current Month Sep 2 Prior Month Aug 3 Jul to Date Jul to Date 4 January Jan 5 February Feb 6 March Mar 7 April Apr 8 May May 9 June Jun 10 July Jul 11 August Aug 12 September Sep 13 October Oct 14 November Nov 15 December Dec

First Tracking Month 7 1 Jan Feb 2 Feb Mar 3 Mar Apr 4 Apr May 5 May Jun 6 Jun Jul 7 Jul Aug 8 Aug Sep 9 Sep Oct 10 Oct Nov 11 Nov Dec 12 Dec Jan 13 Jul to Date

Budget By Month? January TRUE February March April May June July August September October November December July to Date

1

Bar Chart Balance Income Expense

$254 $9,995 $9,741

Overvi ew/ Help

Daily Spend ing

Total Income (net) Salary/Wages Salary/Wages (Spouse) Other 5 Other 6 Other 7 3

Comp arison

Income

Tracki ng

Budge t By Month

Quick Budge t

Comparison

January

January

Compare

to Budget

Budget

Jan Actual

9,995 9995

Tracking vs Budget Summary

Vs Budget 0

4

-9,995 -9,995.00 0.00 0.00 0.00 0.00

995 9,995

Budget 9,000 0 0

Spending Total Spending: Transportation Auto Loan/Lease Insurance Gas 14 Maintenance 15 Registration/Inspection 16 Bill's train pass 17 Jane's bus pass 18 Other 19

Tracking0 9,000

0

-9,000

0

0

0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

12 13

20 21 Home 22 23 24 25 26 27 28 29 30 31

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

6,800 5,000.00

0

1,800.00

-6,800 -5,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -1,800.00 0.00

32 33 Utilities 34 35 36 37 38 39 40 41 42

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

500

0

500.00

-500 0.00 -500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

43 44 Health 45 46 47 48 49 50 51

Dental Medical Medication Vision/contacts Life Insurance Other Other

1,000

0

-1,000 0.00 0.00 0.00 0.00 -1,000.00 0.00 0.00

0

-500 0.00 -500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0

-200 -200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

1,000.00

52 53 Entertainment 54 55 56 57 58 59 60 61 62 63

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

500 500.00

64 65 Miscellaneous 66 67 68 69 70 71 72 73 74 75 76 77

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

200 200.00

0

2,000

4,000

Expense

6,000

8,000

Income

10,000

Balance (Savings)

Spending Comparison 7000 6500 6000 5500 5000 4500 4000 3500 3000 2500 2000 1500 1000 500 0

9 8

6800

1000 500 0

500

200

0

Budget Budget

Transportation Health

0

0

0

0

Tracking Tracking

Home Entertainment

Utilities Miscellaneous

0

4 Jan Budget By Month? 1 Current Month Sep TRUE 2 Prior Month Aug 3 Jul to Date Jul to Date 4 January Jan 5 February Feb 6 March Mar 7 April Apr 8 May May 9 June Jun 10 July Jul 11 August Aug 12 September Sep 13 October Oct 14 November Nov 15 December Dec Simple Budget

1

1 Pie Chart

Bar Chart Budget

Transportation Home Utilities Health Entertainment Miscellaneous

0 6800 500 1000 500 200

Tracking

0 0 0 0 0 0

Tracking Balance (Savings) $Income $Expense $-

Budget $995 $9,995 $9,000

Overvi ew/ Help

Daily Spend ing

Comp arison

Tracki ng

Budge t By Month

Quick Budge t

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 Auto Loan/Lease Insurance Gas 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.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Home EMI Rent Maintenance Insurance Furniture Household Supplies Groceries Real Estate Tax Mess 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.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Utilities Phone - Home Phone - Cell Cable Gas Water Electricity Internet Other 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.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Health Dental Medical Medication Vision/contacts Life Insurance Other 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.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Entertainment Memberships Dining out Events Subscriptions Movies Music Hobbies Travel/ Vacation Other 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.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

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

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

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

Related Documents

Budget Planner
July 2020 8
Budget Planner
May 2020 10
Budget Planner
November 2019 18
Budget Planner
June 2020 9
Budget Planner
August 2019 32
Budget Planner Demo
October 2019 14