Free Household Budget Template Switzerland (Excel)

A Haushaltsbuch, a household budget book, is the simplest money habit there is, and in a high-cost country like Switzerland it pays off faster than almost anywhere else. Writing down what comes in and what goes out turns a vague sense of "where does it all go?" into a clear picture you can act on. You do not need an app or a course to start; a single spreadsheet does the job. This guide gives you a free Excel and Google Sheets template, shows exactly how to use it, and explains the small habits that make a budget actually stick, plus when a spreadsheet stops being enough.

Download the free Swiss household budget template (Excel / Google Sheets). It already has the categories and the formulas set up, so your totals add up automatically. Prefer something interactive? Try our budget calculator first, then keep the template for tracking month to month.

What a Haushaltsbuch is and why it works

A Haushaltsbuch is simply a record of your income and spending over a period, usually a month. Its power is not in the maths but in the visibility: most overspending is not dramatic, it is a dozen small outflows nobody is watching. Once every franc is grouped by category, the patterns jump out, the forgotten subscription, the creeping food-delivery habit, the gap between what you thought you spent and what you actually did. Studies and personal experience both point the same way: people who track their spending spend less, simply because awareness changes behaviour. In Switzerland, where rent and insurance already take a big bite, that clarity is worth real money.

Get the free template

The free template is a ready-made spreadsheet you can open in Microsoft Excel, LibreOffice or Google Sheets. To use it in Google Sheets, open Sheets, choose File then Import, upload the file and select "Replace spreadsheet". Everything is pre-built: income, fixed costs, variable costs and savings, each with a Budgeted and an Actual column, and the totals and the leftover at the bottom update automatically as you type. There is nothing to set up and nothing to pay. Fill in your planned amounts once, then update the actual figures as the month goes on.

The four sections to track

A good budget separates your money into four clear parts, which is exactly how the template is laid out. Income is everything coming in: salary, a partner’s salary, side income. Fixed costs are the bills that barely change, rent, health insurance, utilities, phone, Serafe, transport, subscriptions. Variable costs are the flexible everyday spending, groceries, eating out, leisure, clothing. Savings is what you deliberately set aside, Pillar 3a, investments, an emergency fund. Keeping savings as its own line, not whatever happens to be left, is the single most important habit: decide it first, and treat it like a bill.

The 50/30/20 starting split

If you want a target rather than a blank page, the 50/30/20 rule is a good starting point: aim for roughly 50% of your net income on needs, 30% on wants, and 20% on savings. It is a guide, not a law, and Swiss rents in particular can push the "needs" share higher, but it gives you a sensible shape to budget toward. Our budget calculator applies this split to your income automatically and also shows how much rent you can comfortably carry, a useful companion to the template.

How to actually keep it up

The hardest part of a Haushaltsbuch is not starting it but maintaining it, so make it small. Spend five minutes once a week entering the week’s spending from your banking app rather than saving it all for month-end. Keep the categories few and broad, too much detail is what makes people quit. At the end of each month, compare Budgeted against Actual, notice the one or two lines that overshot, and adjust next month’s plan rather than feeling guilty. A budget you update lightly every week beats a perfect one you abandon after three.

Where a spreadsheet stops working

A spreadsheet is the perfect way to start, and for many people it is all they ever need. But it has a ceiling: every entry is manual, multiple accounts and cards mean constant copying, and it only reflects reality as often as you update it. The day the typing becomes the reason you stop is the day to let software do the data entry. That is exactly what hopli does, pulling your accounts into one place, categorising automatically, and flagging duplicate purchases and forgotten subscriptions, so the budget keeps itself current. Start with the template; move to automation when the manual work outgrows the benefit.

Excel or Google Sheets?

The template works in both, and the right choice is about how you like to work. Excel (or the free LibreOffice Calc) is powerful, works fully offline and is ideal if you already live in Microsoft Office. Google Sheets is free, lives in the cloud, syncs across your phone and laptop automatically, and is the easier option if you want to update the budget from your phone or share it with a partner in real time. The numbers and formulas behave the same way in either; pick the one you will actually open. If in doubt, Google Sheets is the lowest-friction starting point for most people because there is nothing to install.

Common budgeting mistakes to avoid

A few predictable errors quietly sink budgets. The first is too many categories: fifteen tidy lines feel thorough but make upkeep a chore, so keep them broad. The second is forgetting irregular costs, the annual or quarterly bills, insurance instalments, tax, Serafe, that do not show up every month but blow a budget when they land; set aside a twelfth of them each month so they never surprise you. The third is budgeting from your gross salary instead of your net, which overstates what you have to spend. The fourth is ignoring cash and card spending you do not log. And the fifth is leaving no buffer at all, so a single unexpected expense derails the whole plan.

Budgeting as a couple or household

For couples and shared households, a budget works best when it is visible to everyone who spends from it. A shared Google Sheet, or a single view both partners can see, removes the awkward guesswork about who paid for what and whether the month is on track. Agree upfront how you split the fixed costs, whether you keep a joint pot for shared bills plus personal money each, and who tracks what. The same idea scales to managing money for parents or a shared project: keep that spending as its own clearly labelled set of lines so it never blurs into the household total. Transparency, not control, is what makes shared budgeting hold together.

Turning the numbers into decisions

A budget is only worth keeping if it changes something. The tracking is the means, not the end: the point is the handful of decisions it makes obvious. Each month, the template hands you three of them. First, is your savings line actually being funded, or is it quietly absorbing whatever is left? Set it first and protect it. Second, which one category consistently overshoots, and is that a conscious choice or a leak you would rather close? Fixing the single worst line beats trimming everything. Third, what is your leftover, and where is it going, into Pillar 3a and investments, or evaporating into a slightly richer routine you will not remember? Answer those three questions every month and the budget stops being a chore and becomes the quiet engine of your finances.

The bottom line

A Haushaltsbuch is the highest-return habit in personal finance, and it costs nothing to start. Download the free template, fill in your four sections, keep savings as its own line, and update it lightly each week. Use the budget calculator to set your targets, see where the big costs sit in our cost of living guide, and when the manual work outgrows the spreadsheet, let hopli keep your budget current automatically.