France Fichier d'Ecritures Comptables (FEC) Field Mapping

Important:

This topic pertains to the France FEC files generation feature, which is no longer supported as of Tax Audit File SuiteApp version 1.85.0. You can only use this SuiteApp to generate France FEC files from 2022 and earlier. To generate this report, see Fichier d’Ecritures Comptables (FEC) in France Localization.

Fichier d’Ecritures Comptables (FEC) is France’s version of standard audit file for tax (SAF-T), which is aligned to the national chart of accounts, Plan Comptable Général. The France FEC report is generated in flat file format (.txt) with the following report columns and field mapping in NetSuite:

Field Name	Description	NetSuite Field	Remarks
JournalCode	The ID of the journal entry	Transaction Type -Short Name	i.e. CustInv
JournalLib	The name of the journal entry	Transaction Type -Long Name	i.e. Invoice
EcritureNum	The number from a gapless sequence of the posting transactions	GL#
EcritureDate	The posting date of the posting transaction	Transaction Date or GL# Date	Important: It is recommended to use Transaction Date as EcritureDate. For more information using Transaction Date, see When to Use the Transaction Date as EcritureDate. For more information using GL# Date, see When to Use GL# Date as EcritureDate.
CompteNum	The account number whose first three characters must correspond to the numbers specified by the French chart of accounts standard	Order of field sourcing: Number setup using Accounting Context Number setup using Statutory Chart of Accounts for Tax Audit Files Account number using Chart of Accounts	-
CompteLib	The account name, which must correspond to naming conventions specified by the French chart of accounts standard	Order of field sourcing: Name setup using Accounting Context Name setup under Setup > Accounting > Statutory Chart of Accounts for Tax Audit Files Account name using Chart of Accounts	-
CompAuxNum	The auxiliary account number (leave blank if not applicable)	Customer/ Vendor Internal ID	To use customer or vendor internal ID for the CompAuxNum, see Tax Audit Files Configuration for the FEC Report.
CompAuxLib	The auxiliary account name (leave blank if not applicable)	Customer/ Vendor ID	To use customer or vendor name for the CompAuxLib , see Tax Audit Files Configuration for the FEC Report.
PieceRef	The reference of the original accounting document	Order of field sourcing: Document Number Transaction Number Transaction ID	-
PieceDate	The date of the original accounting document	Order of field sourcing: Document Date Transaction Date	-
EcritureLib	The name of the posting transaction	Order of field sourcing: Transaction > Items > Description Transaction > Memo Account > Account Number +Account Name	Note: For Notional Tax Posting, memo value is ="Autoliquidation de TVA"
Debit	The debit amount	Debit amount of the GL impact	Value is set to 0,00 when no debit amount is reported.
Credit	The credit amount	Credit amount of the GL impact	Value is set to 0,00 when no credit amount is reported.
EcritureLet	The reconciliation of the posting transaction (leave blank if not applicable)	Blank	Not yet supported
DateLet	The date of the reconciliation transaction (leave blank if not applicable)	Blank	Not yet supported
ValidDate	The date of validation of the posting transaction	GL# Date
Montantdevise	The foreign currency amount (leave blank if not applicable)	Transaction currency amount	Value is set to blank if no foreign currency is applicable.
Idevise	The foreign currency ID (leave blank if not applicable)	Order of field sourcing: Transaction currency Subsidiary currency	Currency ISO code, i.e. USD.
CodeEtbt	The establishment code	Order of field sourcing: Transaction > Items > Items > Establishment Code Transaction > France Tax Reporting > Establishment Code	Note: This is an optional column of the FEC report. If subsidiary does not use the Establishment Code fields either at the line item or header levels, CodeEtbt column will not be shown on the report.

Field Name

Description

NetSuite Field

Remarks

JournalCode

The ID of the journal entry

Transaction Type -Short Name

i.e. CustInv

JournalLib

The name of the journal entry

Transaction Type -Long Name

i.e. Invoice

EcritureNum

The number from a gapless sequence of the posting transactions

GL#

EcritureDate

The posting date of the posting transaction

Transaction Date or GL# Date

Important:

It is recommended to use Transaction Date as EcritureDate.

For more information using Transaction Date, see When to Use the Transaction Date as EcritureDate. For more information using GL# Date, see When to Use GL# Date as EcritureDate.

CompteNum

The account number whose first three characters must correspond to the numbers specified by the French chart of accounts standard

Order of field sourcing:

Number setup using Accounting Context
Number setup using Statutory Chart of Accounts for Tax Audit Files
Account number using Chart of Accounts

CompteLib

The account name, which must correspond to naming conventions specified by the French chart of accounts standard

Order of field sourcing:

Name setup using Accounting Context
Name setup under Setup > Accounting > Statutory Chart of Accounts for Tax Audit Files
Account name using Chart of Accounts

CompAuxNum

The auxiliary account number (leave blank if not applicable)

Customer/ Vendor Internal ID

To use customer or vendor internal ID for the CompAuxNum, see Tax Audit Files Configuration for the FEC Report.

CompAuxLib

The auxiliary account name (leave blank if not applicable)

Customer/ Vendor ID

To use customer or vendor name for the CompAuxLib , see Tax Audit Files Configuration for the FEC Report.

PieceRef

The reference of the original accounting document

Order of field sourcing:

Document Number
Transaction Number
Transaction ID

PieceDate

The date of the original accounting document

Order of field sourcing:

Document Date
Transaction Date

EcritureLib

The name of the posting transaction

Order of field sourcing:

Transaction > Items > Description
Transaction > Memo
Account > Account Number +Account Name

Note:

For Notional Tax Posting, memo value is ="Autoliquidation de TVA"

Debit

The debit amount

Debit amount of the GL impact

Value is set to 0,00 when no debit amount is reported.

Credit

The credit amount

Credit amount of the GL impact

Value is set to 0,00 when no credit amount is reported.

EcritureLet

The reconciliation of the posting transaction (leave blank if not applicable)

Blank

Not yet supported

DateLet

The date of the reconciliation transaction (leave blank if not applicable)

Blank

Not yet supported

ValidDate

The date of validation of the posting transaction

GL# Date

Montantdevise

The foreign currency amount (leave blank if not applicable)

Transaction currency amount

Value is set to blank if no foreign currency is applicable.

Idevise

The foreign currency ID (leave blank if not applicable)

Order of field sourcing:

Transaction currency
Subsidiary currency

Currency ISO code, i.e. USD.

CodeEtbt

The establishment code

Order of field sourcing:

Transaction > Items > Items > Establishment Code
Transaction > France Tax Reporting > Establishment Code

Note:

This is an optional column of the FEC report. If subsidiary does not use the Establishment Code fields either at the line item or header levels, CodeEtbt column will not be shown on the report.

Related Topics