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

Tit PRESUPUESTO MENSUAL PERSONAL

INGRESO GASTOS SALDO
ProINGRESOS INGRESO PRINCIPAL $ 2,000.00 SALDO PROYECTADO $2,300.00 $1,195.00 $1,105.00
$1,105.00
MENSUALES INGRESO EXTRA $300.00 (Projected income minus expenses)
ProjPROYECTADOS TOTAL INGRESOS MENSUAL $2,300.00 SALDO REAL
$2,300.00
(Actual income minus expenses)
Act INGRESO PRINCIPAL $2,000.00 DIFERENCIA
INGRESOS REALES $1,195.00
INGRESS EXTRA $300.00 (Actual minus projected)
MENSUAL
TOTAL INGRESO MENSUAL $2,300.00

EnteCASA COSTO PROYECTAD COSTO REAL DIFERENCIA ENTRETENIMIENTO Projected Cost Actual Cost Difference
ARRIENDO $1,000.00 $0.00 $1,000.00 CINE $10.00
CELULAE $54.00 $0.00 $54.00 NETFLIX $5.00
LUZ $44.00 $0.00 $44.00 DISNEY $0.00
Gas $22.00 $0.00 $22.00 SALIDAS CARS $0.00
AGUA $8.00 $0.00 $8.00 PARQUES $0.00
ADMINISTRACION $34.00 $0.00 $34.00 Other $0.00
CUOTA ELECTRODOMEST $10.00 $0.00 $10.00 Other $0.00
TV POR CABLE $23.00 $0.00 $23.00 Other $0.00
Subtotal $1,195.00 Other $0.00
Subtotal $15.00
TRANSPORTE COSTO PROYECTAD COSTO REAL DIFERENCIA
Vehicle payment $0.00 PRESTAMOS Projected Cost Actual Cost Difference
EnteBus/taxi fare $0.00 Personal $0.00
Insurance $0.00 Student $0.00
Licensing $0.00 Credit card $0.00
Fuel $0.00 Credit card $0.00
Maintenance $0.00 Credit card $0.00
Other $0.00 Other $0.00
Subtotal $0.00 Subtotal $0.00

SEGURO COSTO PROYECTAD COSTO RELA DIFERENCIA IMPUESTOS Projected Cost Actual Cost Difference
Home $0.00 IMPUESTO MOTO $0.00
EnteHealth $0.00 ADMINISTRACION $0.00
Life $0.00 UNIVERSIDAD $0.00
Other $0.00 OTROS $0.00
Subtotal $0.00 Subtotal $0.00

COMIDAS Projected Cost Actual Cost Difference AHORRO E INVERSION Projected Cost Actual Cost Difference
SALIDAS NOVIASGO $60.00 CUENTA AHORRO $0.00
EnteSALIDA AMIGOS $40.00 CUENTA DE INVERSION $0.00
SALIDA FAMILIAR $100.00 OTROS $0.00
Subtotal $200.00 Subtotal $0.00

ANIMALES Projected Cost Actual Cost Difference REGALOS Y DONACIONES Projected Cost Actual Cost Difference
PERRITO $0.00 OFRENDAS $0.00
EnteBAÑOS $0.00 DIEZMO $0.00
Grooming $0.00 AYUDAS $0.00
Toys $0.00 Subtotal $0.00
Other $0.00
Subtotal $0.00 LEGAL Projected Cost Actual Cost Difference
ABOGADO $0.00
CUIDADO PERSONAL Projected Cost Actual Cost Difference $0.00
GYM $0.00 $0.00
EnteCREMAS $0.00 OTROS $0.00
ODONTOLOGIA $0.00 Subtotal $0.00
$0.00
Total Projected Cost is auto calculated in cell J59, Total Actual C $0.00
COSTO PROYECTADO $1,195.00
$0.00
OTROS $0.00
COSTO TOTAL $0.00
Subtotal $0.00
TOTAL DIFFERENCE $1,195.00

Page 2 of 2