Export formats

Every venue report downloads as PDF, Excel or CSV. The three files come from the same document as the on-screen preview: same columns, same rows, same totals. The general ledger also produces two files for the accountant: the FEC and the accounting CSV. The list of documents is in the Report catalogue. Labels written in the files are in French, as the product writes them.

What each file carries

An exported file travels on its own, by email or on a USB key: so it says by itself what it is about.

Header: the title and the venue name; the period in gaming days, with the day’s cut-over time and the time zone; « Édité par … le … » (produced by … on …: the person and the time, to the second).
Key figures: a small summary block, when the report has one.
The table: the report columns, then the TOTAL row.
Annexes (for example « Par dénomination », by denomination): after the main table, each with its title, columns and totals.
Notes: the report’s reservations (“this report does not measure…”), in the file itself.
« N/D » (not measured) when data is missing: never an empty cell, never a 0. The PDF adds a legend line.

PDF

The same template for all reports, automatically in landscape when the table does not fit in portrait.
Column headers repeat on every page; numbers are right-aligned; « N/D » is in grey italics.
Subtotals are in bold between two rules; the total is in bold (on a grey band in management reports).
Annexes are in a double-ruled box.
Footer of every page: « Édité par … le … » and « Page N sur M » (page N of M).
A form to fill in (the closing sheet) has signature boxes at the bottom.

Excel

One sheet: the identity block (title, period, « Édité par »), the key figures, then the table, whose header row stays frozen when scrolling.
Totals are in bold; annexes follow the main table, after two empty rows.
In management reports, amounts are real numbers (with their format): you can add them up in the spreadsheet.
A text starting with “=”, “+”, “-” or “@” is written as text, never as a formula.

CSV

Encoded in UTF-8 with a byte order mark and separated by semicolons: it opens with a double click in a spreadsheet set to French.
The first rows repeat the title, the period and « Édité par »; an empty row; the key figures; then the table.
Annexes follow after an empty row, with their own header row; notes come at the end.
Some reports add a last column Type de ligne (row type: row, section, subtotal, total) to filter in the spreadsheet without mistaking a subtotal for a detail.

Negative amounts

The Montants négatifs : écriture (negative amounts: style) setting chooses how a negative amount is written on screen and in documents:

Choice	Screen and PDF	Excel	CSV
Signe moins (minus sign, the default)	−777 000 (in red on screen)	-777 000	-777000
Entre parenthèses (in brackets)	(777 000)	(777 000), the amount remaining a number	-777000

The figure never changes, only how it is written. The CSV always keeps the plain hyphen, readable by any spreadsheet; printed receipts keep the hyphen.

Large exports

A preview or a download stops at a set number of rows (Documents : lignes au plus, 20 000 by default). Beyond that, ask for a deferred export: the file is prepared in the background and then downloaded from Rapports → Exports différés (Reports → Deferred exports), where it stays available for a limited time (Export différé : garde du fichier, 72 hours by default). See Exports.

FEC (accounting entries file)

The FEC (the French statutory accounting entries file) contains the numbered general ledger entries in the 18 regulatory columns, in this order: JournalCode, JournalLib, EcritureNum, EcritureDate, CompteNum, CompteLib, CompAuxNum, CompAuxLib, PieceRef, PieceDate, EcritureLib, Debit, Credit, EcritureLet, DateLet, ValidDate, Montantdevise, Idevise.

Separator: vertical bar ( | ) or tab; encoding: UTF-8 or ISO 8859-15 (Latin-9). Settings FEC : séparateur des colonnes and FEC : encodage.
File name: <SIREN>FEC<AAAAMMJJ>.txt for a whole fiscal year, with no filter, when the SIREN is set (FEC : SIREN de l’exploitant); otherwise a name that says what it is: « EXTRAIT_… » (part of the year, a journal, an account), « sans-SIREN ».
One currency per file: when the period has entries in several currencies, choose it; they are never added up nor converted.
Never an incomplete file: the FEC is refused (with the reason) as long as the general ledger is not open, the period contains the current day, the history takeover is not finished or entries are waiting for their number. A file that goes beyond the last closed day is marked PROVISOIRE_ (provisional) in its name.

Accounting CSV

The accounting CSV (« CSV comptable ») is used to import the entries into accounting software. Its profile is set once (Paramètres → Réglages → Rapports → CSV comptable : profil d’import, or « Enregistrer comme profil » in the export panel, administrator), and each export can change it for one file.

Profile item	Choices	Default
Columns, in the order you want	Journal, Libellé du journal, N° d’écriture, Date, Date de validation, Exercice, Compte, Libellé du compte, Compte auxiliaire, Libellé auxiliaire, Pièce, Pièce (en mots), Libellé, Débit, Crédit, Montant (débit − crédit), Devise, Flux, Libellé du flux	Journal, Date, N° d’écriture, Compte, Libellé du compte, Compte auxiliaire, Pièce, Libellé, Débit, Crédit, Devise
Separator	semicolon, comma, vertical bar, tab	semicolon
Date format	dd/mm/yyyy, yyyy-mm-dd, yyyymmdd, ddmmyyyy	dd/mm/yyyy
Decimal separator	comma, point	comma
Journal codes	your software’s codes (for example CAI=CA, COF=BQ)	Lucky Touch’s own
Encoding	UTF-8, UTF-8 with byte order mark (Excel), ISO 8859-15 (Latin-9)	UTF-8 with byte order mark
Header row	yes, no	yes

The accounting CSV follows the same rules as the FEC: one currency per file, never an incomplete file. In ISO 8859-15, characters this encoding lacks (typographic apostrophe, long dash…) are replaced by their plain equivalent, never by a “?”.