Templates with an English page

Every template is built for Switzerland: CHF, Swiss date format, VAT rates 8.1% / 2.6% / 3.8% and a UID field where you need one. Each link leads to a page in English with the download or text to copy, an example and how to fill it in. Where the file itself has German labels, the page says so and translates them.

Quotes, orders and contracts

TemplateFormatsWhat it's for
Quote templateEnglish example to copy; Word, Excel, PDF in English (also German, French and Italian)A binding offer (Offerte) with quote number, valid-until date, line items, VAT and a signature field for acceptance.
Cost estimate templateWord, PDF (German labels); English wording to copyA non-binding estimate when the effort isn't fixed yet.
Terms and conditions templateText to copy14 clauses for freelancers and sole proprietors: payment, default, liability, rights of use.

Invoicing and payment

TemplateFormatsWhat it's for
Invoice templateWord, Excel, PDF in English (also German and French)An invoice with all required details, VAT line and payment details. Also usable without VAT.
Pro forma invoice templateText to copyFor customs or a client's internal approval, clearly marked as not a payment request.
Deposit invoice guideGuideWhat goes on a deposit invoice and how to deduct it on the final invoice.
Receipt templateOnline generator in English; text to copy; Word, Excel, PDF in English (also German, French and Italian)Confirmation of payment (Quittung) for cash payments or private sales, with or without VAT.
Acknowledgement of debt templateText to copyWhen a client can't pay and you want the debt confirmed in writing.

Bookkeeping and expenses

TemplateFormatsWhat it's for
Expense report templateExample to copyExpenses with receipts, VAT and approval.
Self-made receipt (Eigenbeleg)Text to copyA replacement document when the original receipt is lost.
Milk-book accounting tableTable to copySimple income and expense records for small sole proprietorships without VAT.
Timesheet guideGuideWhich timesheet layout fits how you bill your clients.
Budget plannerExcel, PDF in EnglishIncome, fixed costs and a savings goal per month for your personal budget.

Templates in German only

These files exist with German labels and don't have an English page yet. They work as they are; the labels are standard Swiss business German.

  • Payment reminder letters (Zahlungserinnerung, Mahnung): friendly reminder (Word, PDF), first formal reminder (Word, PDF) and final reminder before debt collection (Word, PDF). Once an invoice is due, a reminder puts your client in default (CO Art. 102); from then on default interest of 5% a year is owed (CO Art. 104). Reminder stages in English: late payment reminders.
  • Delivery note (Lieferschein): proof of delivery with line items without prices and a confirmation of receipt. Word, Excel, PDF.
  • Cash book (Kassenbuch): cash in and out with a running balance and monthly overview. Excel, PDF, Word.
  • Work report (Arbeitsrapport): hours and material per job with the client's signature; Excel adds up the hours. Excel, Word, PDF.
  • Expense claim (Spesenabrechnung): expenses with VAT, categories and mileage. Excel, PDF.
  • Milk-book workbook (Milchbüechli): income, expenses and assets in Excel. Excel.
  • TWINT reconciliation: TWINT sales, fees and bank payouts per month. Excel.

The Excel files calculate with formulas, the Word files take your logo, and the PDFs are for printing and filling in by hand.

Template or software: which fits you?

Templates are the right choice if you write up to about 5 invoices a month, don't charge VAT and don't need a QR-bill. Word, Excel and PDF are all you need, and you keep full control.

From 5 to 10 invoices a month, once you're VAT-registered, or when you want reminders, quotes and receipts in one place, software pays off. Magic Heidi creates Swiss QR-bills in 30 seconds, in English, German, French or Italian, sends payment reminders with one click and reads expense receipts from a photo. The free plan includes 3 invoices and 3 expenses, with no time limit and no credit card. After that, Magic Heidi costs CHF 24.90 a month on the annual plan, VAT included. Details on the pricing page.

What the templates can't do: create a real QR-bill (use the QR-bill generator), match payments with your bank account, or tell you which invoice is still unpaid.

FAQ

Questions about the templates

Are the templates really free?

Yes. You can download or copy every template and use it for business without signing up, without an email address and without a credit card.

Which templates are in English?

The invoice, quote and receipt templates and the budget planner are English files, and the receipt generator works in English. The Word, Excel and PDF files for cost estimates, reminders, delivery notes and the cash book have German labels.

Which formats are there?

Word (.docx) to adapt with your logo, Excel (.xlsx) with working formulas, and PDF to print. Not every template comes in all three formats; the tables above list what's available. Some templates are texts to copy.

Do the files open in Google Docs, Numbers or LibreOffice?

Yes. The Word and Excel files are standard formats. Formulas, dropdowns and formatting work in Excel, Google Sheets, Numbers and LibreOffice.

Are the templates adapted for Switzerland?

Yes. UID number with the VAT suffix MWST, the current VAT rates 8.1%, 2.6% and 3.8%, CHF formatting with an apostrophe as thousands separator, Swiss date format, and notes on the QR-bill and default interest under the Code of Obligations.

Do I need the VAT fields as a freelancer below CHF 100'000?

No. Below the CHF 100'000 turnover threshold you're not required to register for VAT (Art. 10 VAT Act). Leave out the VAT line or set the rate to 0% in Excel. More in the VAT guide for freelancers.

When is software better than a template?

From about 5 to 10 invoices a month, once you're VAT-registered, or when you want QR-bills, reminders and receipts in one place. Magic Heidi is free for up to 3 invoices and 3 expenses.

When the template isn't enough: Magic Heidi

QR-bills in 30 seconds, payment reminders with one click, receipts by photo. Free for up to 3 invoices and 3 expenses, no credit card.