Household budget8 min readUpdated:

Free household budget template for Switzerland: Excel in CHF, with a grocery sheet

Yes: the budget template at the top of this page is a free Excel file in Swiss francs. It totals income, fixed costs and receipts by month. The Groceries sheet sets your receipts against the 2023 Federal Statistical Office average (CHF 638 per household per month for food and non-alcoholic drinks) and the 2025/26 Budgetberatung Schweiz guideline.

Rappn compares the current promotions of 7 Swiss retailers, updated daily: free, no subscription.

Fill the grocery line with Rappn, free
Ink drawing of a little house unfolding a budget grid, with the grocery column highlighted in yellow

The household budget template for Switzerland (Excel, CHF) covers income, fixed costs, groceries, other variable costs and provisions, with a monthly summary that does the sums for you. You fill in income and fixed costs once, then add your grocery receipts every week. For your type of household, the Groceries sheet also shows the guideline of Budgetberatung Schweiz, the Swiss umbrella association of budget counselling services.

Updated October 2026. Sources: Federal Statistical Office (FSO), Household Budget Survey 2023 (press release of 17 November 2025); Budgetberatung Schweiz, budget examples and budget templates 2025/2026; Federal Tax Administration (FTA), tax at source (viewed on 8 October 2026).

Where can I find a household budget template in Swiss francs?

Right here. The Rappn template at the top of this page is a free .xlsx file in Swiss francs (CHF). It has no macros, no external links and no sample figures to delete. Each language version of this page (English, German, French, Italian) comes with its own file.

Another option is Budgetberatung Schweiz: free budget templates in Excel and PDF, also for apprentices and students, plus 2025/2026 budget examples for single people, couples and families. Its materials are in German, French and Italian.

Export your receipts from Rappn as CSV and paste them into the template’s Groceries sheet.

Fill the grocery line with Rappn, free

Free, no subscription · iOS & Android

Your spending

YOU SPENT

CHF 609.28

📅 April 2026

CHF 200
CHF 133
CHF 67
1-78-1415-2122-2829-30

By category

What is in the template?

A household budget is a monthly list of a household’s income and spending that shows what is left at the end of the month. The template has one sheet for each part of it, plus the summary and the instructions. You only type in the white and yellow cells (the year and the household type); the grey ones hold the formulas.
SheetWhat you enterWhen
SummaryOnly the year; income, spending and balance for each month are calculated for youAt the end of the month
IncomeNet salaries, 13th-month salary, family allowances, pensionsWhen it changes
Fixed costsRent and service charges, health insurance, other insurance, taxes, transport, phone, radio and TV fee, childcare, savingsOnce, then only changes
GroceriesOne row per receipt: date, shop, amount, optional categoryEvery week
Variable costsHousehold and personal care, clothes, eating out, alcohol, leisure, healthEvery week or at the end of the month
ProvisionsMoney set aside for yearly costs: deductible, dentist, gifts, holidays, unexpected costsOnce: yearly cost ÷ 12

How do you fill in a household budget in 5 steps?

  1. Enter the year on the Summary sheet. The Groceries sheet only counts receipts from that year.
  2. Income: the net amount that reaches your account. The Budgetberatung Schweiz examples use monthly net income without the 13th-month salary. In the template, enter it in the month you receive it.
  3. Fixed costs: once, from contracts and bills. For rent, Budgetberatung Schweiz assumes about a quarter of net income, up to a third including service charges. Set taxes aside every month, unless you pay tax at source. As a rule, that applies to foreign employees living in Switzerland without a C permit (settlement permit) and to cross-border commuters. Your employer deducts it from your salary (FTA), so the line usually stays at zero. If you are a cross-border commuter, the agreement with your country of residence may also mean tax there: set that part aside.
  4. Provisions: yearly costs divided by 12. In the budget examples these are the minimum health-insurance deductible (franchise, CHF 300 for adults) plus the co-payment, dental and eye check-ups, gifts and a reserve for unexpected costs. Type the yearly cost into column O of the Provisions sheet. Column P shows the monthly share: copy it into the months so it counts in the Summary.
  5. Groceries every week, the summary at the end of the month. That gives you income, spending, balance and the share of income that goes on groceries.

How much does the average Swiss household spend on each budget line?

The table shows the FSO averages for 2023 across all households (2.07 people, gross income of CHF 10'341 a month). They give the scale, not a target: your figures depend on canton, income and family.
ItemTemplate sheetCHF per monthShare of gross income
Housing and energyFixed costs1'44914.0%
TaxesFixed costs1'24512.0%
Basic health insurance premiumsFixed costs6896.7%
TransportFixed costs (passes, car)7447.2%
Food and non-alcoholic drinksGroceries6386.2%
Restaurants and accommodationVariable costs5585.4%
Amount left for savingFixed costs (savings)1'73616.8%

Source: FSO 2023, table T1. To see which items you can cut, and by when, read the guide to the biggest household expenses in Switzerland. To split your net pay, see the 50/30/20 rule with Swiss figures, and for a complete month, the monthly budget examples for Switzerland.

Groceries: how do you fill the sheet from receipts?

One row per receipt on the Groceries sheet: date, shop, amount and, if you like, a category. Next to it the template works out each month’s total, your monthly average and each category’s share of the total.

  • By hand. From paper receipts the total is enough; for categories, one row per group of items. Enter them every week: thermal paper fades.
  • From digital receipts. If the shop emails them or keeps them in its loyalty app or your online account, copy the date, shop and total; what you can download depends on the programme.
  • From a CSV file. If an app that reads receipts exports CSV, copy the date, shop and amount columns into columns A, B and C. Check first which column is which, and whether the file has one row per receipt or per item (paste one kind only, so no amount counts twice). Then make sure dates stay dates and amounts use your Excel’s decimal separator.

Cleaning products, personal care and alcohol go under Variable costs, as in the FSO survey and the Budgetberatung Schweiz examples. Left in the grocery total, they make it look higher than the average you compare it with. The guide to analysing your grocery receipts explains how to split a receipt into categories.

The comparison with the average and the guideline

Below the totals, the template sets your monthly average next to the FSO average (CHF 638 a month for food and non-alcoholic drinks consumed at home, 2023) and the 2025/26 guideline of Budgetberatung Schweiz for the household type you pick from the menu. The guideline is CHF 370 to 500 a month for a single person, 550 to 700 for a couple and 850 to 1'100 for a family with two children. The lower your net income, the closer to the minimum. The template tells you whether you are below, within or above the range, without the CHF 50 to 100 for each child aged 12 or over: add that yourself. All household types are in the guide to the grocery budget by household size.

Excel, app or paper: which budget method suits you?

The one you will keep up every week. You can also combine the two: fixed costs in the template, groceries from an app that reads receipts.
MethodWhat it coversEffortWhat you see of your groceriesCost
Excel or PDF template (this one or those of Budgetberatung Schweiz)The whole budgetMedium: everything by handWhat you write downFree
General budget app with manual entryThe spending you enterMediumUsually amount and categoryOften free, sometimes a subscription
Spending tab of a banking appCard and account paymentsLowShop and total, not the items; cash only as a withdrawalPart of the bank’s app
Receipts in RappnGroceries onlyLow by photo, medium by handSpending by category and by month, export as PDF or CSVFree, no subscription

If you would rather not give any app access to your bank account, the guide to expense tracking without a bank connection compares the alternatives.

How can I fill the Groceries sheet with Rappn?

Rappn is a free Swiss app (iOS and Android) that compares the current promotions of seven Swiss retailers and turns receipts into a spending overview. You can start today: photograph this week’s receipts, upload them from your gallery or enter a purchase by hand. At the end of the month, export them as CSV and copy the date, shop and amount into columns A, B and C of the Groceries sheet, with the checks described above. Rent, health insurance and taxes stay in the template: Rappn only covers groceries.

If you want your own figure rather than an average, the free Rappn app imports the receipts of three big Swiss supermarkets’ loyalty programmes, up to 12 months back, and you add the others by photo; it then shows your spending by category and by month. You need a Rappn account and must be an adult; the programmes’ terms still apply and the operator can restrict the link (how linking works).

Rappn is building an AI assistant for groceries: you can join the waitlist.

Updated: .

Why Rappn?

Rappn is an independent grocery price comparison app in Switzerland, with no commercial agreements with any retailer. Our comparisons are truly independent.

  • 100% free: no subscription, no hidden costs
  • Neutral: no commercial agreements with Migros, Coop, Aldi, Lidl, Denner, Aligro, or Otto’s
  • Updated daily, as soon as the chains publish their deals
  • The chains’ deals in one place: search, filter, compare, no subscription
  • Meal planner in the Kitchen tab: plan the week, send the ingredients to your list
Available now

Ready to save on groceries?

Install Rappn and compare for yourself this week. No account required.

Currentoffers
7retailers
100%free

Frequently Asked Questions

Is there a free budget template for Switzerland?

Yes. The Rappn household budget template is a free Excel file in Swiss francs, in English, German, French and Italian. It has income, fixed costs, groceries, variable costs, provisions and a monthly summary. Budgetberatung Schweiz, the Swiss umbrella association of budget counselling services, also publishes free budget templates in Excel and PDF, and budget examples for 2025/2026 for different household types.

How do I make a household budget?

Enter your net income for each month, your fixed costs from contracts and bills, and your yearly costs divided by 12. Then add your groceries and other variable costs every week, and the summary shows the balance at the end of the month. After two or three months you can see which items you can actually change.

What should a household budget include?

A household budget should cover income, fixed costs (rent with service charges, health insurance, other insurance, taxes, transport, phone and internet, radio and TV fee, childcare, savings), groceries, other variable costs (household and personal care, clothes, eating out, alcohol, leisure, health) and provisions (deductible, dentist, gifts, holidays, unexpected costs). The 2025/2026 budget examples of Budgetberatung Schweiz follow the same structure.

Does the template work in Google Sheets or Numbers?

It should work, but we have only tested it in Microsoft Excel, not in Google Sheets or Numbers. The Rappn household budget template is an ordinary .xlsx with no macros and only standard formulas (sums, conditional sums and table lookups), which both programs also support. If a grey cell shows an error, check that the dates on the Groceries sheet are recognised as dates.

Can I add receipts exported from Rappn to the template?

Yes. In the free Rappn app, export your receipts as CSV and open the file. Check which column holds the date, the shop and the amount, then copy them into columns A, B and C of the Groceries sheet. The monthly totals and the summary update by themselves.

Related Comparisons