Problem: “My columns don’t split correctly in Excel”
This usually means Excel used the wrong delimiter.
What to do
Import the file using Excel’s Data → From Text/CSV and select the delimiter that matches your file (commonly comma or semicolon).
If you changed the decimal separator to
,, your accounting tool may prefer a different delimiter than when decimals are..
Problem: “Dates look wrong”
What to check
Confirm you selected the correct date format in the export configuration.
Remember: the export uses the document issue date (invoice/credit note date), not the payment date.
Problem: “VAT lines are missing”
What to check
Confirm you mapped each VAT rate to a VAT account (CompteNum/CompteLib).
Problem: “The file imports, but accounts are wrong”
What to check
Re-open your export configuration and confirm the revenue accounts are mapped correctly for:
Rental
Protection plan
Deposit
One-time products
Recurring products
Late fees
If a product type needs a distinct accounting code, make sure you mapped it separately.
Problem: “My accounting software rejects some rows”
Most common causes
Missing mandatory journal code or account number
Incorrect decimal separator for your import settings
Unexpected characters because the importer isn’t reading UTF-8
What to do
Open the CSV in a plain text editor and confirm it reads normally (UTF-8).
Ensure JournalCode / CompteNum fields required by your importer are filled.
Try importing a smaller date range to identify the first failing invoice.
Other FAQs
1. “Can I submit this export directly to French tax authorities?”
No. This export is designed to provide structured transaction data that supports your FEC compliance workflow, but you still need to complete your accounting in your accounting software and generate the final file according to your accountant’s process.
2. “Can I configure different journal codes per location?”
Yes - configuration is stored at location level, which is especially useful if your company runs multiple sites or franchise locations with different accounting setups.
This is the end of the FEC collection.