Annual Family Budget — Excel Template

What it's for

Keep your family budget for the year in one file: record income and expenses, and Excel calculates totals by month and category, shows overspending against limits and your savings rate, and tells you how much to set aside for your goals.

What's inside

• “Settings” sheet: year, currency, opening balance, editable income and expense category lists, monthly plans and limits.
• “Transactions” sheet: up to 3000 transactions with type and category chosen from a list and a check column.
• “Months” sheet: a category × month matrix with plan, actual and variance; overspending is highlighted.
• “Year summary” sheet: income, expenses, net balance, savings rate, expense shares by category, a column chart by month and a pie chart of expenses.
• “Savings goals” sheet: amount, deadline, saved so far, how much to save per month and a progress bar.

Who it's for

Families and anyone who wants to get their personal finances in order without special software or apps.

Compatibility

Excel 2007 and later, LibreOffice. No macros; your data is stored only in your file. The file is in English.