Budget Planner

  • August 2019
  • 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,721
  • Pages: 8
Questions? Email at [email protected]

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

Overvi ew/ Help

Comp arison

Daily Spend ing

or cr ea te a bu dg et by m on th

1 1

Tracki ng

Budge t By Month

Quick Budge t

Quick Budget

Chart:

Income 1 1 4.33

Frequency

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

Monthly Monthly Weekly Monthly Monthly

Amount

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

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

Monthly Monthly Weekly Quarterly 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 0.00 0.00 0.00 0.00 0.00 0.00

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

Monthly Monthly Monthly Monthly Yearly Monthly Weekly 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.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Monthly Monthly Monthly

0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00

Spending 1

1 1 1 1

1 1 1

Utilities Phone - Home Phone - Cell Cable

Total:

Budget Summary

Yearly

Yearly

$0

$0 Column Z

$0

$ 0$ 0 $ 0 $ 0 $0

$0 $ 0 $ 0 $0 $ 0 $ 0

Row 26

$ 1 $ 1 $1 $1 $ 1 $ 1 $1 $1 $ 1

Row 25

Row 24

Spending Summary

Quick Budget TRUE

Yearly Monthly Weekly 1

Transportation Entertainment

Home Miscellaneous

Utilities

Health

Pie Chart Transportation Home Utilities Health Entertainment Miscellaneous

$$$$$$-

Bar Chart Balance Income Expense

$$$-

Monthly Monthly Monthly 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

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

Monthly Monthly Monthly Semi-Annually 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 0.00 0.00 0.00 0.00

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

Monthly Monthly Monthly Monthly Monthly Monthly Weekly Yearly 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

Monthly Semi-Annually Monthly Monthly Monthly Monthly Weekly Monthly Monthly 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 0.00

0.00 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 1

Gas Water Electricity Internet Other Other

1 1 1

1 1 1

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

Daily Weekly Monthly Semi-Annually Quarterly Yearly

Overvi ew/ Help

Daily Spend ing

Comp arison

Tracki ng

Budge t By Month

Quick Budge t

or cr ea te a qu ic k bu dg et

Budget By Month

March

Chart: -7

Income

Apr

May

Jun

Jul

Aug

Budget Summary

0 Months Oct to Date

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

Spending

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

Column AK

0

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 0 0 0 0 000000 00001 11111 11111

0

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 Other Other

0.00

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

0.00

Health Dental Medical Medication Vision/contacts Life Insurance Other Other

0.00

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

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

0

1 111 11 11 1

0

0

Row 27

0

Row 26

Row 25

0

0

Budget by

Spending Summary

0

Chart:

Month

0

Mths/Wks

Mar FALSE

Start Mth

Bar Chart

$-

-

Balance

$-

Home

$-

-

Income

$-

0

2 Monthly (avg.)

0 Months

Utilities

$-

Expense

$-

0

3 Weekly (avg.)

0 Months

Health

$-

0

4 Current Month

Feb

Entertainment

$-

0

5 January

Jan

Miscellaneous

$-

0

6 February

Feb

0

7 March

Mar

0

8 April

Apr

0

9 May

May

0

10 June

Jun

0

11 July

Jul

0

12 August

Aug

13 September

Sep

14 October

Oct

15 November

Nov

16 December

Dec

0

0

0

Home

Utilities

Health

Miscellaneous

0

0

Budget by Month

0

0

0

0

0

0

0

0

0

0

0

0

1 1 1 1 1 0 0 0 0 0 0

Apr

May

Jun

Jul

Aug

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Row 16

Row 8

Row 16

4

1 Budgeted

Transportation

0 Months

Transportation Entertainment

7

Pie Chart

1 Yearly

0

$-

Overvi ew/ Help

Daily Spend ing

Comp arison

Tracki ng

Budge t By Month

Quick Budge t

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

Nov

0.00

Dec

0.00

Jan

0.00

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

0.00 0.00 0.00 0.00 0.00 0.00

0.00

0.00

0.00

0.00

0.00

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

0.00

0.00

0.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

32

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

0.00

0.00

0.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00

0.00

0.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00

0.00

0.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00

0.00

0.00

0.00

0.00 0.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

43

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

52

Entertainment Memberships Dining out Events Subscriptions 57 Movies 58 Music 59 Hobbies 60 Travel/ Vacation 61 Other 62 Other 63 53 54 55 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

0 0

0.00

13

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

0

Column AN

12

21

Actual Income/Spend Summary

Oct to Date

0.00

Spending Total Spending:

September

Chart: Oct

66 67 68

-

-

-

-

0 0 0 0 00000 000 00001 1 111

Row 28

1111 11 1 1

Row 27

1 11 1 11 1

Row 26

Actuals by Month 1 1 1 1 1 0 0 0 0 0 0

2 1

Oct

Nov

Dec

Row 17

Jan

Row 8

Row 8 Row 17

12 Sep 1 Feb 1 Current Month Feb 2 Prior Month Jan 3 Oct to Date Oct 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 10 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 Oct to Date

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

1

Bar Chart Balance Income Expense

$$$-

Overvi ew/ Help

Daily Spend ing

4

Comp arison

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

Tracki ng

Budge t By Month

Quick Budge t

Compariso n Income

October

October

Compare

to Budget

Budget

Oct Actual 0 0 0 0 0 0

Tracking vs Budget Summary

Vs Budget 0

0 0.00 0.00 0.00 0.00 0.00

0 0

Budget0 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 12 13

Tracking0

0

0

0

0 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 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

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

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

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

0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.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

0 0.00 0.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

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

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

0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1

Expense

Income

Balance (Savings)

Spending Comparison 2 1

$1 $1 $1 $1 $1 $0 $0 $0 $0 $0 $0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Budget

Tracking

TransportaHome Budget tion EnterMisceltainment laneous

UtilitiesTracking Health

13 Oct Budget By Month? 1 Current Month Feb FALSE 2 Prior Month Jan 3 Oct to Date Oct 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

Tracking

0 0 0 0 0 0

0 0 0 0 0 0

Tracking Balance (Savings) $Income $Expense $-

Budget $$$-

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

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