TEMPLATES TO DOWNLOAD
Six invoice templates for Switzerland, free and with no sign-up: in Word, Excel and PDF, each with and without VAT. They have room for everything an invoice needs. What no template can contain is the QR code: you create it for each invoice in the generator. Below you will find why, and how to bring the two together.
Download the templates
- Word (.docx): you lay out the text as you like; you work out the amounts yourself.Word with VATWord without VAT
- Excel (.xlsx): the sheet works out the amount of each item, the VAT and the total, for up to 15 items.Excel with VATExcel without VAT
- Fillable PDF (.pdf): you fill in the fields on screen and print or save the invoice; you work out the amounts yourself.PDF with VATPDF without VAT
The templates are plain: A4, in Arial or Helvetica, with no logo and no advertising. You may use and adapt them freely, including with your own logo.
What is on the invoice
Each template has room for:
- your details: name or company, address, phone and email; in the template with VAT, also the VAT number (CHE-123.456.789 MWST, TVA or IVA);
- your customer’s name and address;
- the invoice number and date, and the date or period of supply;
- the items with description, quantity, unit, price and amount;
- with VAT: the total excluding VAT, the rate, the VAT amount and the total including VAT; without VAT: the total;
- the payment terms and your IBAN.
What an invoice must contain and how to number and keep it is explained in the guide How to create an invoice in Switzerland. For VAT-registered businesses, Art. 26 of the Swiss VAT Act (MWSTG) lists the required details.
With or without VAT
With VAT: the template is for VAT-registered businesses. In the Excel template the rate sits in a single cell: 8.1% is the standard rate, 2.6% the reduced rate and 3.8% the special rate for accommodation. If you report with the net tax rate method, the invoice still shows the statutory rate, for example 8.1%, never the net tax rate.
Without VAT: the template is for anyone who is not VAT-registered. It has no VAT rate, VAT amount or VAT number. Anyone who is not registered and still shows VAT on an invoice may owe the tax shown to the Federal Tax Administration (Art. 27 para. 2 MWSTG).
When you have to register and how reporting works is in our guide to VAT in Switzerland.
The QR code comes from the generator
No template can contain a valid QR code. The code carries your IBAN, the amount and the addresses of that one invoice; it has to be created for each invoice. A code already in the template would be the same for every invoice.
This is how you do it:
- Fill in the invoice in the template.
- In the QR code generator, enter your IBAN, your name and address and the amount, and the invoice number as the message. The code is created in your browser; the data is not sent anywhere.
- Download the code as an SVG. The file is sized so that the printed code measures 46 x 46 mm, as required. Check the size after inserting it: printed too small, the banking app often cannot read it.
- The code belongs in the payment part with receipt, at the bottom of the invoice or on a separate sheet. You lay out that part yourself to the SIX specifications, or invoicing software creates it for you.
The payment part measures 148 x 105 mm and the receipt, to its left, 62 x 105 mm. Source: SIX Implementation Guidelines for the QR-bill, version 2.4.
Without a QR code your customers pay by hand with the IBAN and the invoice number. If you invoice regularly, invoicing software does both for you: Vidima creates the invoice with the payment part and the QR code in one step.
Frequently asked questions
Is an invoice made in Word or Excel valid in Switzerland?
Can I create a QR-bill with Excel?
Which template do I need: with or without VAT?
May I adapt the templates?
Invoice, payment part and QR code in one step.
With Vidima you write the invoice and the payment part with the QR code comes with it. 30 days free, no credit card.
idima