Household Budget Modelo Essentials
Track household income and expenses for families or shared living situations. Covers dual incomes, shared bills, and household-specific categories.
O Que Está Incluído
- Dashboard with household financial overview showing combined income, total expenses, and net balance
- Dual income support with separate entry rows for each earner plus additional income sources
- Household-specific expense categories including mortgage or rent, childcare, groceries, and utilities
- Monthly budget worksheet with automatic formulas that sum shared and individual expenses
- Color-coded cells distinguishing editable input fields from auto-calculated summary totals
- 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 household financial overview showing combined income, total expenses, and net balance
- Dual income support with separate entry rows for each earner plus additional income sources
- Household-specific expense categories including mortgage or rent, childcare, groceries, and utilities
- Monthly budget worksheet with automatic formulas that sum shared and individual expenses
- Renda Configuração aba supporting até 4 household members com salário, side renda, e outro renda sources por pessoa
- Shared Despesas aba for household bills split entre members - cada linha mostra custo total e cada person's share based on split ratio
- Individual Despesas aba for personal gastos per household member tracked separadamente de shared custos
- Split ratio input per despesa categoria - definir 50/50, 60/40, ou qualquer custom split e um planilha calculates cada person's share automaticamente
- Mensal Acompanhamento aba consolidating shared e individual despesas by categoria for cada mês
Pré-visualização
Veja o que tem dentro desta planilha
Como Usar Esta Planilha de Household Budget
List household income
Enter each earner separately - primary salary, secondary income, and any other sources. The template totals them automatically.
Fill in shared expenses
Add household costs like mortgage or rent, utilities, groceries, childcare, and insurance into the expense categories.
Review the dashboard
See combined income vs total household expenses, net balance, and which categories consume the largest share of the budget.
Update each month
Adjust amounts as bills and income change. The formulas recalculate totals so you can track household spending trends over time.
Criadas com Claude AI. Aperfeiçoadas por nós.
Usamos Claude AI para criar cada planilha, após uma pesquisa aprofundada. Depois, nossa equipe entra em ação. Refinamos o layout, testamos exaustivamente cada fórmula, corrigimos casos extremos e polimos o design até que pareça algo que nós mesmos usaríamos. A IA nos leva 80% do caminho. Os últimos 20% são puro julgamento humano.
Perguntas Frequentes
Can I track two incomes separately?
Yes. The template has separate income rows for each earner plus additional rows for other household income sources like rental income or side work.
What household categories are included?
Categories include mortgage or rent, utilities, groceries, childcare, transportation, insurance, medical, entertainment, and more. You can rename or add categories to fit your household.
Is this template for families only?
No. It works for any shared living arrangement - couples, families, or roommates splitting expenses. Adjust the income and expense labels to match your situation.
How do I handle shared vs personal expenses?
You can add separate rows for personal expenses under each earner, or focus only on shared household costs. The template is flexible enough for either approach.
Como abrir no Google Sheets?
Envie o arquivo .xlsx para o Google Drive e abra com o Google Sheets. Todas as fórmulas e formatações serão preservadas.
Mais modelos Essentials de Personal Budgeting
Procurando planilhas premium?
Nossas planilhas pagas incluem painéis avançados com várias abas, gráficos nativos do Excel e atualizações contínuas.