Household budget planner (Excel)

Excel budget planner for a full year: entries, fixed costs, 12 months per category, savings rate and a yearly summary.

A budget planner for a whole year in one Excel file. You enter regular payments such as salary, rent, insurance or standing orders once on the sheet for fixed costs, and the workbook spreads them over the right months. Everything else goes in as an entry with date, category and amount on one input sheet; the month column fills itself.

The summary calculates income and expenses per category and month, the balance and the savings rate with formulas. The yearly overview shows key figures, all twelve months and the share of each expense category. Categories can be renamed. 600 entry rows and 60 fixed-cost rows are prepared. This is an organising tool, not financial or tax advice. All labels and instructions are in German.