50/30/20 Budget Plantilla Essentials
Organize spending into needs, wants, and savings using the 50/30/20 framework. Useful for those who prefer a percentage-based approach to budgeting.
Qué incluye
- Dashboard with visual 50/30/20 split showing needs, wants, and savings as percentage of income
- Automatic percentage calculations that update target amounts based on your total income entry
- Category-level budget tracker with pre-filled items for housing, groceries, insurance, and entertainment
- Income-based target amounts with real-time variance showing over or under budget per category
- Color-coded input cells and formatted result areas for a clean, easy-to-read budget layout
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Need more from this template?
The Essentials version covers everyday tracking. Ultimate goes further with multi-entity support, scenario analysis, and ultimate-grade reporting.
- Dashboard with visual 50/30/20 split showing needs, wants, and savings as percentage of income
- Automatic percentage calculations that update target amounts based on your total income entry
- Category-level budget tracker with pre-filled items for housing, groceries, insurance, and entertainment
- Income-based target amounts with real-time variance showing over or under budget per category
- Hoja de Metas de Ingreso estableciendo el ingreso mensual y calculando las metas en dólares del 50/30/20 para Necesidades, Deseos y Ahorro automáticamente
- Hoja de Necesidades para registrar todos los gastos esenciales - vivienda, servicios, supermercado, seguros, transporte - con subtotales por categoría y comparación con la meta del 50%
- Hoja de Deseos para gastos discrecionales - restaurantes, entretenimiento, compras, suscripciones - con subtotales por categoría y comparación con la meta del 30%
- Hoja de Ahorro rastreando aportes a fondo de emergencia, jubilación, inversiones y metas de ahorro con comparación de la meta del 20%
- Panel con 6 tarjetas de KPI: ingreso total, total de necesidades, total de deseos, total de ahorro, saldo general del presupuesto y tasa de ahorro del mes actual
Vista previa
Mira qué contiene esta plantilla
Cómo usar esta plantilla de 50/30/20 Budget
Enter total income
Type your monthly after-tax income at the top. The template calculates 50%, 30%, and 20% target amounts automatically.
Categorize your spending
Assign each expense to needs, wants, or savings. The pre-filled categories give you a starting point you can customize.
Check your split
The dashboard shows how your actual spending compares to the 50/30/20 targets with percentage breakdowns per bucket.
Rebalance as needed
If one bucket is over target, look for expenses to shift or reduce. The variance columns highlight where adjustments may help.
Creadas por Claude AI. Perfeccionadas por nosotros.
Usamos Claude AI para crear el borrador de cada plantilla, después de una investigación profunda. Luego nuestro equipo interviene. Refinamos el diseño, probamos cada fórmula a fondo, corregimos casos especiales y pulimos el diseño hasta que se siente como algo que realmente usaríamos nosotros mismos. La IA nos lleva al 80%. El último 20% es criterio humano.
Preguntas frecuentes
What counts as needs vs wants?
Needs are essentials like housing, groceries, insurance, and minimum debt payments. Wants are non-essentials like dining out, entertainment, and subscriptions. The template includes pre-filled examples in each category.
Is the split based on gross or net income?
The template is designed for after-tax (net) income. Enter the amount you actually receive in your paycheck or bank account.
Can I change the percentage split?
Yes. The percentage cells are editable, so you can adjust to 60/20/20 or any other ratio that fits your situation.
What if my needs exceed 50%?
The template still tracks everything accurately. The variance column shows how far over or under you are, which is useful for seeing where your money goes even if the split differs.
¿Cómo abro esto en Google Sheets?
Sube el archivo .xlsx a Google Drive y luego ábrelo con Google Sheets. Todas las fórmulas y el formato se conservarán.
Más plantillas Essentials de Personal Budgeting
¿Buscas plantillas premium?
Nuestras plantillas de pago incluyen paneles avanzados con múltiples hojas, gráficos nativos de Excel y actualizaciones continuas.