| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Personal Monthly Budget | Vertex42.com | Additional Templates | ||||||||
2 | https://www.vertex42.com/ExcelTemplates/personal-monthly-budget.html | © 2008-2019 Vertex42 LLC | ► Budget Templates | ||||||||
3 | ► Money Manager Template | ||||||||||
4 | INCOME | Projected | Actual | Difference | [42] | MONTHLY BUDGET SUMMARY | Projected | Actual | Difference | ► Home & Family Templates | |
5 | Wages & Tips | 2,000.00 | 2,000.00 | 0.00 | Total Income | 2,000.00 | 2,000.00 | 0.00 | |||
6 | Interest Income | 0.00 | Total Expenses | 1,381.00 | 1,527.00 | (146.00) | |||||
7 | Dividends | 0.00 | NET | 619.00 | 473.00 | (146.00) | To Print: Hide this column first | ||||
8 | Gifts Received | 0.00 | ` | ||||||||
9 | Refunds/Reimbursements | 0.00 | |||||||||
10 | Transfer From Savings | 0.00 | DAILY LIVING | Projected | Actual | Difference | |||||
11 | Other | 0.00 | Groceries | 0.00 | |||||||
12 | Other | 0.00 | Personal Supplies | 0.00 | |||||||
13 | Total INCOME | 2,000.00 | 2,000.00 | 0.00 | Clothing | 0.00 | |||||
14 | Cleaning | 0.00 | |||||||||
15 | HOME EXPENSES | Projected | Actual | Difference | Education/Lessons | 0.00 | |||||
16 | Mortgage/Rent | 1,100.00 | 1,100.00 | 0.00 | Dining/Eating Out | 0.00 | |||||
17 | Home/Rental Insurance | 56.00 | 56.00 | 0.00 | Salon/Barber | 0.00 | |||||
18 | Electricity | 50.00 | 67.00 | (17.00) | Pet Food | 0.00 | |||||
19 | Gas/Oil | 43.00 | 52.00 | (9.00) | Other | 0.00 | |||||
20 | Water/Sewer/Trash | 7.00 | 7.00 | 0.00 | Total DAILY LIVING | 0.00 | 0.00 | 0.00 | |||
21 | Phone | 25.00 | 25.00 | 0.00 | ENTERTAINMENT | Projected | Actual | Difference | |||
22 | Cable/Satellite | 35.00 | 35.00 | 0.00 | Videos/DVDs | 0.00 | |||||
23 | Internet | 15.00 | 15.00 | 0.00 | Music | 0.00 | |||||
24 | Furnishings/Appliances | 0.00 | 150.00 | (150.00) | Games | 0.00 | |||||
25 | Lawn/Garden | 0.00 | 0.00 | 0.00 | Rentals | 0.00 | |||||
26 | Maintenance/Supplies | 50.00 | 20.00 | 30.00 | Movies/Theater | 0.00 | |||||
27 | Improvements | 0.00 | 0.00 | 0.00 | Concerts/Plays | 0.00 | |||||
28 | Other | 0.00 | 0.00 | 0.00 | Books | 0.00 | |||||
29 | Total HOME EXPENSES | 1,381.00 | 1,527.00 | (146.00) | Hobbies | 0.00 | |||||
30 | TRANSPORTATION | Projected | Actual | Difference | Film/Photos | 0.00 | |||||
31 | Vehicle Payments | 0.00 | Sports | 0.00 | |||||||
32 | Auto Insurance | 0.00 | Outdoor Recreation | 0.00 | |||||||
33 | Fuel | 0.00 | Toys/Gadgets | 0.00 | |||||||
34 | Bus/Taxi/Train Fare | 0.00 | Vacation/Travel | 0.00 | |||||||
35 | Repairs | 0.00 | Other | 0.00 | |||||||
36 | Registration/License | 0.00 | Total ENTERTAINMENT | 0.00 | 0.00 | 0.00 | |||||
37 | Other | 0.00 | SAVINGS | Projected | Actual | Difference | |||||
38 | Total TRANSPORTATION | 0.00 | 0.00 | 0.00 | Emergency Fund | 0.00 | |||||
39 | HEALTH | Projected | Actual | Difference | Transfer to Savings | 0.00 | |||||
40 | Health Insurance | 0.00 | Retirement (401k, IRA) | 0.00 | |||||||
41 | Doctor/Dentist | 0.00 | Investments | 0.00 | |||||||
42 | Medicine/Drugs | 0.00 | Education | 0.00 | |||||||
43 | Health Club Dues | 0.00 | Other | 0.00 | |||||||
44 | Life Insurance | 0.00 | Total SAVINGS | 0.00 | 0.00 | 0.00 | |||||
45 | Veterinarian/Pet Care | 0.00 | OBLIGATIONS | Projected | Actual | Difference | |||||
46 | Other | 0.00 | Student Loan | 0.00 | |||||||
47 | Total HEALTH | 0.00 | 0.00 | 0.00 | Other Loan | 0.00 | |||||
48 | CHARITY/GIFTS | Projected | Actual | Difference | Credit Cards | 0.00 | |||||
49 | Gifts Given | 0.00 | Alimony/Child Care | 0.00 | |||||||
50 | Charitable Donations | 0.00 | Federal Taxes | 0.00 | |||||||
51 | Religious Donations | 0.00 | State/Local Taxes | 0.00 | |||||||
52 | Other | 0.00 | Other | 0.00 | |||||||
53 | Total CHARITY/GIFTS | 0.00 | 0.00 | 0.00 | Total OBLIGATIONS | 0.00 | 0.00 | 0.00 | |||
54 | SUBSCRIPTIONS | Projected | Actual | Difference | MISCELLANEOUS | Projected | Actual | Difference | |||
55 | Newspaper | 0.00 | Bank Fees | 0.00 | |||||||
56 | Magazines | 0.00 | Postage | 0.00 | |||||||
57 | Dues/Memberships | 0.00 | Other | 0.00 | |||||||
58 | Other | 0.00 | Other | 0.00 | |||||||
59 | Total SUBSCRIPTIONS | 0.00 | 0.00 | 0.00 | Total MISCELLANEOUS | 0.00 | 0.00 | 0.00 | |||
60 | |||||||||||
61 | |||||||||||
62 | |||||||||||