FNE Excel template - Classic¶

This document describes how to use the Classic Excel template to import invoices and credit notes into the FNE module.

Version date: January 14, 2026 Template file: minlessika_fne_invoice_import_template.xlsx Type: Classic Template version: 1.1

The template is in French

The sheet names and column headers of the Excel file are in French and must not be changed. Each one is given below as it appears in the file, with its English translation.

When to use the Classic template¶

Use this file to bulk-import invoices and credit notes without an API integration. The Classic template relies on row-by-row entry (one row per invoice item) and reference sheets for the codes (VAT, taxes, payment methods, currencies, etc.).

File structure¶

The file contains the following sheets:

Légende (Legend): identifies the type and version of the template.
Factures (Invoices): main sheet for the invoice rows.
Avoirs (Credit notes): sheet for the credit note rows.
TVA (VAT), Autres taxes (Other taxes), Modes de paiement (Payment methods), Type de facture (Invoice type), Type de facturation (Invoicing type), Devises (Currencies), Booléen (Boolean): reference sheets for the codes to use in the matching columns.

Fill in the Factures sheet¶

Each row is one invoice item. For an invoice with several items, repeat the header information (establishment, customer, date, etc.) on each row, keeping the same Référence Facture (invoice reference).

Orange headers mark the required fields. The table below gives, for each column, its purpose and whether it is required.

Column	Description	Required
Établissement	Identification of the issuing establishment.	Yes
Point de vente	Point of sale or sales channel.	Yes
Vendeur	Name or identifier of the seller.	No
Référence Facture	Unique identifier of the invoice.	No (generated if left empty)
Type de facture	Code from the Type de facture sheet (e.g. `sale`).	Yes
Date Facture	Valid Excel date (e.g. `15/01/2026`).	Yes
Type de facturation	Code from Type de facturation (e.g. `B2B`, `B2F`).	Yes
Mode de paiement	Code from Modes de paiement (e.g. `cash`, `transfer`).	Yes
Référence Client	Internal customer identifier.	Yes
Raison Sociale Client	Legal name of the customer.	No
Numéro Fiscal Client	NCC or tax identifier.	No
N° Téléphone Client	Phone number of the customer.	Yes
Adresse mail Client	E-mail of the customer.	Yes
Devise	Currency code from Devises.	No
Taux Devise / XOF	Conversion rate to XOF.	Yes if Devise is filled in
Code Produit	Internal product reference.	Yes
Libellé du Produit	Name of the product or service.	Yes
Description de la ligne	Additional details of the line.	No
Quantité	Invoiced quantity.	Yes
Unité de mesure	Unit (e.g. piece, kg).	No
Prix Unitaire HT	Unit price excluding tax.	Yes
Remise (%)	Discount applied, as a percentage.	No
TVA	Code from the TVA sheet.	Yes
Autre taxe 1	Code from Autres taxes.	No
Valeur autre taxe 1	Associated rate or value.	Yes if Autre taxe 1 is filled in
Autre taxe 2	Code from Autres taxes.	No
Valeur autre taxe 2	Associated rate or value.	Yes if Autre taxe 2 is filled in
Autre taxe 3	Code from Autres taxes.	No
Valeur autre taxe 3	Associated rate or value.	Yes if Autre taxe 3 is filled in
Object ou description	Overall description of the invoice.	No
Conditions de paiement	Payment terms.	No
Est attachée à une RNE ?	`1` (TRUE) or `0` (FALSE) from Booléen.	Yes
Référence RNE	Linked RNE reference, if applicable.	No
Groupe/Catégorie	Internal grouping.	No
N° Bon de commande	Purchase order reference.	No

Reference lists (code sheets)¶

Fields with a value list rely on the reference sheets of the file. Use only the codes below.

TVA (VAT)¶

Code	Meaning
TVA	Standard 18% VAT
TVAB	Reduced 9% VAT
TVAC	Conventional 0% VAT exemption
TVAD	Legal 0% VAT exemption for TEE and RME

Autres taxes (Other taxes)¶

You may add your own taxes and values in this sheet.

Code	Meaning	Value in %
AIRSI	AIRSI	5
AIRSI	AIRSI	25
TDT	Tourism Development Tax	1.5

Modes de paiement (Payment methods)¶

Code	Meaning
cash	Cash
card	Bank card
check	Check
mobile-money	Mobile money
transfer	Bank transfer
deferred	Deferred payment

Type de facture (Invoice type)¶

Code	Meaning
sale	Sales invoice
purchase	Purchase slip

Type de facturation (Invoicing type)¶

Code	Meaning
B2B	The customer is a company or professional holding an NCC
B2F	The customer is international
B2G	The customer is a government institution
B2C	The customer is an individual

Devises (Currencies)¶

Code	Meaning
XOF	CFA franc
USD	US dollar
EUR	Euro
JPY	Japanese yen
CAD	Canadian dollar
GBP	British pound sterling
AUD	Australian dollar
CNH	Chinese yuan
CHF	Swiss franc
HKD	Hong Kong dollar
NZD	New Zealand dollar

Booléen (Boolean)¶

Value	Meaning
1	TRUE
0	FALSE

Fill in the Avoirs sheet¶

Use this sheet to cancel an existing invoice line.

The table below gives, for each column, its purpose and whether it is required.

Column	Description	Required
Référence Avoir	Unique identifier of the credit note.	No (generated if left empty)
Référence Facture initiale	Reference of the original invoice.	Yes
N° ligne initiale	Line number of the invoice to cancel.	Yes
Référence du Produit	Product code of the original line.	Yes
Libellé du Produit	Label of the original line.	Yes
Quantité à annuler	Quantity to credit back.	Yes

Good practices¶

Do not change the sheet names or the column order.
Use only the codes from the reference sheets.
Enter dates as Excel dates (not free text).
Check the uniqueness of invoice and credit note references.

Changelog

September 2, 2025: Classic template documentation created.
January 14, 2026: list of required fields added.