| Create a Personal Monthly Budget in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started. |
| Title of this worksheet is in cell at right. Next instruction is in cell A5. | | Personal Monthly Budget |
| Projected Monthly Income label is in cell at right. Enter Income 1 in cell C5 and Extra Income in C6 to calculate Total monthly income in C7. Next instruction is in cell A7. |
| Projected Balance is auto calculated in cell H4, Actual Balance in H6, and Difference in H8. Next instruction is in cell A9. | | | | | | total monthly income
| | | $8,000.00 |
| Actual Monthly Income label is in cell at right. Enter Income 1 in cell C10 and Extra Income in C11 to calculate Total monthly income in C12. Next instruction is in cell A14. | pre-tax deductions | | | | | deductions (multiplied by 4) | | | $2,756.00 |
| | Medical | $20.00 |
| | dental | $20.00 | | | | monthly Net Pay
(total minus deductions) | | | $5,244.00 |
| | vision | $20.00 |
| | 401 (k) | $100.00 |
| | Total monthly income | $160.00 |
| Enter details in Housing table starting in cell at right and in Entertainment table starting in cell G14. Next instruction is in cell A27. |
| | State InsuranceTaxes |
| | social security | $120.00 |
| | medicare | $28.00 |
| | state disability insurance tax | $1.00 |
| | state unenemployment | $3.00 |
| | state family leave | $1.00 |
| | workers compensation | $0.00 |
| | Total monthly income | $153.00 |
| | Taxes |
| | Federal Income | $293.00 |
| | State income | $83.00 |
| Enter details in Transportation table starting in cell at right and in Loans table starting in cell G26. Next instruction is in cell A37. | Total monthly income | $376.00 |
| | HOUSING | Budget Cost | Actual Cost |
| | Mortgage or rent | $1,000.00 | $1,000.00 |
| | Phone | $42.00 | $42.00 | | Total Budgeted Cost | | | $3,828.61 |
| | Electricity&Gas | $200.00 | $191.00 |
| | Internet | $63.81 | $63.81 | | Total Actual Cost | | | $3,538.52 |
| | Supplies | $0.00 | $0.00 |
| Enter details in Insurance table starting in cell at right and in Taxes table starting in cell G35. Next instruction is in cell A44. | Other | $0.00 | $0.00 | | Total Difference | | | $290.09 |
| | Subtotal | $1,305.81 | $1,296.81 |
| | TRANSPORTATION | Budget Cost | Actual Cost | | Savings | | | $1,805.48 |
| | Insurance | $236.45 | $236.45 |
| | Fuel | $60.00 | $40.00 |
| | Maintenance | $0.00 | $0.00 |
| Enter details in Food table starting in cell at right and in Savings table starting in cell G42. Next instruction is in cell A50. | Other | $0.00 | $0.00 |
| | Subtotal | $296.45 | $276.45 |
| | INSURANCE | Budget Cost | Actual Cost |
| | Life | $29.00 | $29.00 |
| | Subtotal | $29.00 | $29.00 |
| Enter details in Pets table starting in cell at right and in Gifts table starting in cell G48. Next instruction is in cell A58. |
| | FOOD | Budget Cost | Actual Cost |
| | Groceries | $100.00 | $75.00 |
| | Dining out | $20.00 | $19.00 |
| | Other | $0.00 | $0.00 |
| | Subtotal | $120.00 | $94.00 |
| Enter details in Personal Care table starting in cell at right and in Legal table starting in cell G54. Next instruction is in cell A61. |
| | PERSONAL CARE | Budget Cost | Actual Cost |
| Total Projected Cost is auto calculated in cell J61, Total Actual Cost in J63, and Total Difference in J65. | Hair/nails | $100.00 | $70.00 |
| | Clothing | $157.35 | $100.00 |
| | Dry cleaning | $20.00 | $10.00 |
| | Subtotal | $277.35 | $180.00 |
| | ENTERTAINMENT | Budget Cost | Actual Cost |
| | Movies | $0.00 | $0.00 |
| | Subtotal | $0.00 | $0.00 |
| | LOANS | Budget Cost | Actual Cost |
| | Student | $200.00 | $0.00 |
| | Credit card | $400.00 | $30.00 |
| | Credit card | $1,200.00 | $30.00 |
| | Subtotal | $1,800.00 | $60.00 |
Jleebap
PersonalMonthlyBudget1.xlsx
