Use case
You’ve downloaded your export and want to:
Validate totals
Understand how invoices map to journal lines
Troubleshoot an accounting import
How lines are generated
Kinnovis generates accounting lines based on invoice documents and invoice line items:
Kinnovis retrieves all invoices/credit notes in your selected period.
Each line item is mapped to your configured revenue and VAT accounts.
A document produces multiple export lines (customer, revenue, VAT).
Each document is balanced: total debits = total credits (per invoice / per credit note).
Column reference (what you’ll see in the CSV)
Journal identification
JournalCode: journal code (configured by you for invoices / credit notes)
JournalLib: journal label (configured by you)
Entry grouping and dates
EcritureNum: sequential entry number to group invoice line items that belong together (e.g.
P1,P2,P3)EcritureDate: invoice issue date formatted using your selected date format
PieceRef: invoice number or credit note number
PieceDate: invoice issue date
Accounts and customer identification
CompteNum / CompteLib: your configured account number + label (customer, revenue, VAT)
CompAuxNum: your customer identifier (from Kinnovis)
CompAuxLib: customer name (person name or company name)
Description and amounts
EcritureLib: customer name + invoice number; for credit notes it should reference the original invoice)
Debit / Credit: amounts per line
Empty FEC columns (headers only)
The export includes some columns as empty (header present, values blank) because these are typically handled inside your accounting software during reconciliation:
EcritureLet, DateLet, ValidDate, Montantdevise, Idevise
Examples
Example: Invoice with multiple VAT rates
If one invoice includes items with different VAT rates (e.g. rent at 20% and insurance at 10%), the export will include separate revenue and VAT lines for each VAT rate, while still grouping everything under one document reference and entry number.
An invoice with net rent + VAT creates:
1 customer line (411)
2 revenue line items
1 revenue line - rental revenues (70610000)
1 revenue line - protection plans (70810000)
2 VAT lines
20% for rental revenues
10% for protection plan
For each Debit & Credit, verify that the sum of debit entries is the same as sum of credit entries.
JournalCode | JournalLib | EcritureNum | CompteNum | CompteLib | Debit | Credit |
VE | VENTES | P1 | 411 | Collectif client | 131,00 | 0 |
VE | VENTES | P1 | 70610000 | Prestations de locations | 0 | 100,00 |
VE | VENTES | P1 | 44571000 | TVA collectée 20% | 0 | 20,00 |
VE | VENTES | P1 | 70810000 | Refacturations frais assurance | 0 | 10,00 |
VE | VENTES | P1 | 44571100 | TVA collectée 10% | 0 | 1,00 |
Example: Credit notes
Credit notes are exported under your credit note journal (e.g. AV / AVOIRS CLIENTS) and include customer, revenue, and VAT lines that are intended to offset the original invoice when imported and posted correctly.
JournalCode | JournalLib | EcritureNum | CompteNum | CompteLib | Debit | Credit |
AV | AVOIRS CLIENTS | P1 | 411 | Collectif client | 0 | 131,00 |
AV | AVOIRS CLIENTS | P1 | 70610000 | Prestations de locations | 100,00 | 0 |
AV | AVOIRS CLIENTS | P1 | 44571000 | TVA collectée 20% | 20,00 | 0 |
AV | AVOIRS CLIENTS | P1 | 70810000 | Refacturations frais assurance | 10,00 | 0 |
AV | AVOIRS CLIENTS | P1 | 44571100 | TVA collectée 10% | 1,00 | 0 |
Invoice: The original invoice (VE) generates a debit to the client account (411) and credits the revenue and VAT accounts.
Credit Note: The credit note (AV) reverses these entries:
The client receivable (411) is debited (the customer is no longer liable for the amount).
The revenue and VAT accounts are credited (reducing income and VAT collected).
Tip: Your accounting software may expect credit notes as negative lines or as reversed debit/credit postings. If your import doesn’t offset as expected, check your accounting software’s credit note import rules.
Summary
Your export is a structured accounting CSV: each invoice/credit note becomes a balanced set of lines with configured journals, revenue accounts, and VAT accounts, ready for import and reconciliation.