About this template

Use this personal monthly budget worksheet to track your projected and actual monthly
income and projected and actual cost.

• Enter expenses incurred on various categories in respective tables.

• Projected balance, actual balance, and difference are auto-calculated.

Note:
Additional instructions have been provided in column A in PERSONAL MONTHLY BUDGET worksheet.
This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide
text, select column A, then change font color.

To learn more about tables in the worksheet, press SHIFT and then F10 within a table, select the TABLE
option, and then select ALTERNATIVE TEXT.
 Personal monthly budget
Projected monthly income Projected balance
(Projected income minus expenses) $3,405.00
Income 1 $4,300.00

Extra income $300.00

Actual balance $3,064.00
(Actual income minus expenses)
Total monthly income $4,600.00

Difference ($341.00)
(Actual minus projected)
Actual monthly income
Income 1 $4,000.00

Extra income $300.00

Total monthly income $4,300.00

Housing Entertainment
Category Projected Actual Difference Category Projected Actual Difference
cost cost cost cost

Mortgage or rent $1,000.00 $1,000.00 $0.00 Video/DVD $0.00

Phone $54.00 $100.00 -$46.00 CDs $0.00

Electricity $44.00 $56.00 -$12.00 Movies $0.00

Gas $22.00 $28.00 -$6.00 Concerts $0.00

Water and sewer $8.00 $8.00 $0.00 Sporting events $0.00

Cable $34.00 $34.00 $0.00 Live theater $0.00

Waste removal $10.00 $10.00 $0.00 Other $0.00

Maintenance or repairs $23.00 $0.00 $23.00 Other $0.00

Supplies $0.00 $0.00 $0.00 Other $0.00

Other $0.00 $0.00 $0.00 Subtotal $0.00

Subtotal -$41.00

Transportation Loans
Category Projected Actual Difference Category Projected Actual Difference
cost cost cost cost

Vehicle payment $0.00 Personal $0.00

Bus/taxi fare $0.00 Student $0.00

Insurance $0.00 Credit card $0.00

Licensing $0.00 Credit card $0.00

Fuel $0.00 Credit card $0.00

Maintenance $0.00 Other $0.00

Other $0.00 Subtotal $0.00

Subtotal $0.00

Insurance Taxes
Category Projected Actual Difference Category Projected Actual Difference
cost cost cost cost

Home $0.00 Federal $0.00

Page 2 of 3
Health $0.00 State $0.00

Life $0.00 Local $0.00

Other $0.00 Other $0.00

Subtotal $0.00 Subtotal $0.00

Food Savings or investments

Category Projected Actual Difference Category Projected Actual Difference
cost cost cost cost

Groceries $0.00 Retirement account $0.00

Dining out $0.00 Investment account $0.00

Other $0.00 Other $0.00

Subtotal $0.00 Subtotal $0.00

Pets Gifts and donations

Category Projected Actual Difference Category Projected Actual Difference
cost cost cost cost

Food $0.00 Charity 1 $0.00

Medical $0.00 Charity 2 $0.00

Grooming $0.00 Charity 3 $0.00

Toys $0.00 Subtotal $0.00

Other $0.00

Subtotal $0.00

Personal care Legal

Category Projected Actual Difference Category Projected Actual Difference
cost cost cost cost

Medical $0.00 Attorney $0.00

Hair/nails $0.00 Alimony $0.00

Clothing $0.00 Payments on lien or judgment $0.00

Dry cleaning $0.00 Other $0.00

Health club $0.00 Subtotal $0.00

Organization dues or fees $0.00

Other $0.00

Subtotal $0.00

Total projected cost $1,195.00

Total actual cost $1,236.00

Total difference ($41.00)

Page 3 of 3