Freelancer Time Tracking Switzerland 2026 — Excel + Guide (English)

Track Your Hours, Projects & Revenue — Ready-Made for Swiss Freelancers

Spreadsheets from scratch? Expensive SaaS subscriptions? Neither. This Excel template is ready to use in 5 minutes — with automatic calculations for revenue, AHV reserves, and tax planning.

Includes: Excel Template (6 sheets) + 15-page PDF Guide

📊 What's in the Excel Template?

6 Professional Sheets — Ready to Fill In

• Instructions: Quick start guide — open, read, done
• Settings: Your name, hourly rate, MWST (VAT), client list
• Time Tracking: Daily entries by project — the heart of the template
• Project Overview: All projects with budget, hours, and progress — automatically calculated
• Monthly Report: Revenue and hours per month — at a glance
• Annual Report: Key figures, AHV reserves, tax estimate — for your Steuererklärung

Automatic Calculations

• Revenue per project, per client, per month — no manual addition
• Project budget tracking: how much budget is left?
• AHV reserve: 10.6% automatically calculated
• Tax reserve: 20–25% set aside for income tax

📖 What's in the PDF Guide? (15 Pages)

• Hourly rate calculator: Enter your target annual salary → get your required hourly rate
• AHV & social insurance: What you must pay as a self-employed person in Switzerland
• Tax reserve planning: How much to set aside per Kanton
• Project management tips: Tracking, billing, client communication
• MWST setup: When to register, how to invoice with VAT
• Glossary: AHV, BVG, MWST, Ausgleichskasse — all terms explained

🎯 Who Is This For?

• Freelancers & consultants tracking billable hours
• Self-employed professionals who need project overview
• Small business owners managing multiple clients
• Anyone who wants to stop paying for time tracking SaaS

💡 Why This Template?

• No subscription, no cloud — your data stays with you
• Works in Excel, LibreOffice, Google Sheets
• Swiss-specific: AHV, MWST, CHF — built for Switzerland
• One-time purchase, free updates

Information as of: May 2026

Swiss Business Tools — Professional digital templates for Switzerland · swissbusinesstools.ch