Free Excel invoice template, ready for Factur-X
An .xlsx workbook with the mandatory French invoice details, including the four new ones of the reform. Once filled in, it converts to Factur-X.
Free, no account · Excel, LibreOffice Calc, Google Sheets · no macros · version 1 of 5 November 2026
Already filled in?Convert it to Factur-XSee a filled-in example
- 4 new mandatory mentions
- Invoices and credit notes
- 20 invoices per file
- No macros
The template is in French. Tab names, column headers and drop-down values are in French and must stay exactly as they are: that is how the file is recognised on upload. Fill in the values in your own words; the column guide below explains every header in English. Column guide in English.
Example of a filled-in Excel invoice
Invoice F-2026-0142 from the workbook, once converted. Every detail comes from a cell of the template:
- Vendeuryour name, SIREN, address and VAT scheme, entered once
- Facturesnumber, dates, customer and their SIREN, type of transaction, delivery address if different
- Lignesitem, quantity, unit and unit price excluding VAT
Cells left empty: late payment penalties, the €40 recovery fee and the early payment discount get the standard French wording. Under the VAT exemption scheme, the legal notice is added for you.
Download the template (.xlsx)TVA non applicable, art. L. 223 et s. du CIBS (French VAT exemption notice)
Late payment penalties: three times the legal interest rate. Fixed recovery fee: €40. Early payment discount: none.
Column guide
Every column, explained in English
Columns marked with an asterisk (*) are required. Headers and drop-down values are shown exactly as they appear in the file. Dates are written DD/MM/YYYY and amounts in euros with a decimal comma (1 250,50).
The CSV version has the same fields on a single sheet: one row per invoice line, invoice columns repeated on each line, then the seller columns prefixed « Vendeur : ».
Vendeur — you, once and for all
One detail per row: label in column « Information », your value in column « Valeur ».
| Header in the file | What to enter |
|---|---|
| Nom ou raison sociale * (required) | Business or trading name, as registered. Sole traders add « EI » after their name. |
| Entrepreneur individuel | Sole trader: « Oui » (yes) if you trade in your own name (EI, micro-entreprise), otherwise « Non » (no). |
| SIREN * (required) | SIREN, the 9-digit French company ID (spaces accepted). Only sellers registered in France can be converted. |
| SIRET | SIRET, the 14-digit establishment number (optional). |
| N° de TVA intracommunautaire | EU VAT number: FR followed by 11 characters. Leave empty under the VAT exemption scheme. |
| Adresse * (required) | Street address: number and street name. |
| Complément d'adresse | Address line 2: building, floor, PO box (optional). |
| Code postal * (required) | Postcode (5 digits in France). |
| Ville * (required) | City. |
| Pays | Country, as a two-letter code; FR if empty. |
| Email address (optional). | |
| Régime de TVA * (required) | VAT scheme: « TVA applicable » (you charge VAT) or « Franchise en base de TVA » (small-business exemption: the legal notice is added for you and the VAT rates of the lines are ignored). |
| Mention d'exonération de TVA | VAT exemption notice: only for an exemption or a reverse charge; copy the wording and the legal article. |
| Moyen de paiement | Payment method: « Virement » (bank transfer, default if empty), « Virement hors SEPA » (non-SEPA transfer), « Carte bancaire » (card), « Chèque » (cheque) or « Espèces » (cash). |
| IBAN | IBAN, recommended for payment by bank transfer. |
| BIC | BIC (optional). |
| Pénalités de retard | Late payment penalties: leave empty for the standard French wording (three times the legal interest rate, plus the €40 fixed recovery fee). |
| Escompte pour paiement anticipé | Early payment discount: leave empty if you don’t offer one (printed as « néant », none). |
Factures — one row per invoice
Number, type (invoice or credit note), dates, type of transaction and your customer, SIREN included.
| Header in the file | What to enter |
|---|---|
| N° de facture * (required) | Invoice number: unique, with no gaps in the sequence. It links the lines to the invoice. |
| Type | Document type: « Facture » (invoice, default if empty) or « Avoir » (credit note: also fill in the original invoice columns). |
| Date d'émission * (required) | Issue date, DD/MM/YYYY. |
| Date d'échéance * (required) | Payment due date, DD/MM/YYYY. Optional for a credit note. |
| Date de livraison ou d'exécution | Delivery or service date, if different from the issue date. |
| Nature de l'opération * (required) | Type of transaction, a mandatory mention: « Biens » (goods), « Services » or « Mixte (biens et services) » (both). |
| TVA sur les débits | VAT on debits: « Oui » (yes) only if you opted to pay VAT when invoicing rather than when paid. |
| Type de client | Customer type: « Entreprise française » (French business, default if empty), « Particulier » (consumer), « Entreprise étrangère » (foreign business) or « Administration publique » (public body). |
| Client : nom ou raison sociale * (required) | Customer: business or trading name. |
| Client : SIREN | Customer’s SIREN: required for a French business customer from 1 September 2027. |
| Client : n° de TVA | Customer’s EU VAT number. |
| Client : e-mail | Customer’s billing email address (optional), written into the Factur-X. |
| Client : adresse * (required) | Customer: street address. |
| Client : complément d'adresse | Customer: address line 2. |
| Client : code postal * (required) | Customer: postcode. |
| Client : ville * (required) | Customer: city. |
| Client : pays | Customer: country, two-letter code; FR if empty. |
| Livraison : adresse | Delivery address: street, if different from the customer’s address. |
| Livraison : code postal | Delivery address: postcode. |
| Livraison : ville | Delivery address: city. |
| Livraison : pays | Delivery address: country, two-letter code. |
| Référence de commande | Purchase order reference: the customer’s order number. |
| Référence acheteur | Buyer reference requested by the customer (the service code for a French public body). |
| Conditions de paiement | Payment terms, for example: 30 days by bank transfer. |
| Acompte déjà versé (TTC) | Deposit already paid (including VAT), deducted from the amount due. |
| Avoir : n° de la facture d'origine | Credit note: number of the original invoice. Required for a credit note. |
| Avoir : date de la facture d'origine | Credit note: date of the original invoice, DD/MM/YYYY. Required for a credit note. |
Lignes — the detail of each invoice
Each row points to an invoice number: item, quantity, unit price excluding VAT and VAT rate.
| Header in the file | What to enter |
|---|---|
| N° de facture * (required) | Invoice number: the same number as in the Factures tab. |
| Désignation * (required) | Item: name of the product or service. |
| Description | Description (optional). |
| Quantité * (required) | Quantity. |
| Unité | Unit: « Unité » (unit, default if empty), « Heure » (hour), « Jour » (day), « Forfait » (flat fee), « Mètre carré (m²) », « Mètre » (metre), « Kilogramme » or « Litre ». |
| Prix unitaire HT * (required) | Unit price excluding VAT, in euros. |
| Taux de TVA * (required) | VAT rate: 20 %, 10 %, 5,5 %, 2,1 % or 0 %. Ignored under the VAT exemption scheme. |
| Catégorie de TVA | VAT category: « Taux normal ou réduit » (standard or reduced rate, default if empty), « Exonération » (exempt), « Taux zéro » (zero rate), « Autoliquidation » (reverse charge), « Livraison intracommunautaire » (intra-EU supply), « Exportation hors UE » (export outside the EU) or « Hors champ de la TVA » (out of scope of VAT). |
| Total HT (calculé) | Net line total, calculated by Excel to help you; Factusur always recalculates the totals. Optional. |
How to use it
From the sheet to Factur-X in five steps
Download the workbook, fill in Vendeur, then Factures and Lignes, save as .xlsx and upload the file: you check the preview, then download one Factur-X per invoice. The file’s first tab (« Mode d’emploi ») repeats these steps in French.
Download the template (.xlsx)- 01
Download the template and open it
In Excel, LibreOffice Calc or Google Sheets. It contains no macros.
- 02
Fill in the « Vendeur » tab
Your name, SIREN, address, VAT or exemption. Only once: keep this file as your base.
- 03
Add one row per invoice in « Factures »
Number, type, date, type of transaction and customer. Drop-down lists avoid typos.
- 04
Detail the lines in « Lignes »
One row per service or item, with the number of the invoice it belongs to. The total column is only indicative: we recalculate the totals.
- 05
Save as .xlsx and upload the file
You check the preview, then download one Factur-X per invoice, with its verification report.
Special cases
Credit notes, several invoices, 2027 mentions
The template handles credit notes (type « Avoir » and original invoice), up to 20 invoices per file, and the four mentions added on 1 September 2027 for French SMEs and micro-businesses.
A credit note
In « Factures », choose the type « Avoir » and enter the number and date of the original invoice. Enter amounts as positive numbers: the type is enough to show it is a refund.
Several invoices
One row per invoice in « Factures », up to 20 per file and 200 lines each. They are converted as a batch: sign in with a free account. Each Factur-X downloaded counts as one conversion.
The 2027 mentions
- Customer’s SIREN
- Type of transaction
- Option to pay VAT on debits
- Delivery address if different
Template filled in? Upload it
You check the preview, then download your EN 16931 Factur-X and its verification report. The PDF uses our standard layout, in French.
Frequently asked questions
What is the Factusur Excel invoice template for?
Is the template free?
Why are the headers in French, and can I translate them?
How do I make a credit note with the template?
My file contains several invoices: what happens?
Can I change the template?
Does it work with LibreOffice or Google Sheets?
Is an invoice made with this template an e-invoice?
Does my Factur-X keep the layout of my Excel invoice?
You remain solely responsible for the content of your invoices and for their compliance with invoicing rules.
Factusur is not an approved platform (plateforme agréée, PA) and does not transmit your invoices. We create a file in Factur-X format from the information you confirm.
Prefer to keep your own Excel invoice? Creating a Factur-X invoice from Excel (in French)
What is free at Factusur (validator, conversions, tools): free Factur-X (in French)
A customer asks you for an e-invoice? What they expect, business or public sector (in French)
Convert an Excel file