How to generate the Fichier des Écritures Comptables (FEC) in a few words?

14-09-2020 | 6 | DART, Fichier des Écritures Comptables (FEC), SAF-T Compliance, Tax and Audit Readiness

Authors: Patchanok Kluabkaew and Graham Little

SAP provides a standard solution to generate the Fichier des Écritures Comptables (FEC) in the DART tool and recommends using DART version 2.7.  There are some prerequisites to implement before Tax and Audit teams can actually create the FEC file in DART. The following article provides some guidance on these prerequisites and the steps to be taken to generate the FEC using the DART tool in comparison with the FEC software by TJC, an SAP Certified application that complements SAP tools.

What is the Fichier des Écritures Comptables (FEC)?

The Fichier des Écritures Comptables (FEC) is an audit file for France. From 1st January 2014, it is mandatory for all companies established in France to provide the FEC file to the French Tax Administration in the event of a tax audit. The FEC contains all accounting entries journals for a closed fiscal year and the opening balance complying with French GAAP (PCG and LPF). Upon receiving notice of a tax audit, a company has 15 days to prepare and remit the FEC file. In case of failing to deliver the FEC file or in the event of non-compliance, companies could face significant penalties up to € 5000.

Hence, all companies must ensure to place the appropriate mechanism to generate the FEC file before receiving a notification from the French Government.

Further information about the legal requirements can be found in the Article A47 A-1 of the French Tax regulation.

FEC | TJC Group
Figure 1: Introduction of Fichier des Écritures Comptables (FEC).

The FEC file format requires 18 fields of accounting entries information as depicted in the table below.

No.InformationField NameField Type
1The journal entry codeJournalCodeAlphanumeric
2The journal entry nameJournalLibAlphanumeric
3The number of accounting entry (continuous number sequence)EcritureNumAlphanumeric
4The posting dateEcritureDateDate
5The account number.the first three characters must comply with French accounting standardCompteNumAlphanumeric
6The account name, in accordance with French accounting standardCompteLibAlphanumeric
7The sub ledger account number (blank if not used)CompAuxNumAlphanumeric
8The sub ledger account description (blank if not used)CompAuxLibAlphanumeric
9Reference of the supporting documentPieceRefAlphanumeric
10Date of the supporting documentPieceDateDate
11Description of the accounting entryEcritureLibAlphanumeric
12The debit amountDebitNumber
13The credit amountCreditNumber
14The lettering of the accounting entry (blank if not used)EcritureLetAlphanumeric
15The lettering date (blank if not used)DateLetDate
16The validation date of the accounting entryValidDateDate
17Amount in currency (blank if not used)MontantdeviseNumber
18Currency code (blank if not used)IdeviseAlphanumeric

How to generate a FEC file from the SAP system?

SAP provides the solution to generate a FEC file in the DART tool and recommends using DART version 2.7.  There are some prerequisite tasks to follow: 

  1. Implement SAP notes with the latest version in the correct order. You can find a list of SAP notes and the implementation order in note 2162977. The number of notes depends on your SAP version. If your system is ECC6, you could need as many as 39 notes to implement.
  2. Configure the DART view to meet the French legal requirements for the FEC file and your company requirements (if any). You can find more details in SAP note 1923322. The standard data view is 2FR_FI01 “DART: FI Transaction data for France legal requirements.”
  3. Customize document type and G/L account creation for opening balance postings.

Before creating the FEC file, one must post the opening balance, as mentioned in Article A47 A-1 of the French Tax regulation. To do so, run transaction FAGL_FR_03 (this is applicable for classical GL). This program will post statistical documents (status BSTAT ‘O’) in period ‘00’. This process should be done after the year-end process completion. We recommend verifying opening balances from postings, reverse, and re-postings in case of unexpected results.

Next, we can start creating the FEC file in DART. Follow the next steps:

  • First, run transaction FTW1A to create data extracts for all accounting entries postings for a given fiscal year and opening balance documents, as mentioned in the prerequisite tasks, then select FR as the key language and choose “Finance documents (FI), and Open Items list (FI) under Transaction Data section.
DART data extraction | TJC Group
Figure 2: DART data extraction
  • Second, schedule the view 2FR_FI01 and create the FEC file with transaction FTWH.
  • The source extract is the data file name from the previous step.
  • The file name format must be SIREN number + FEC + Closing Date. For example: 112233444FEC
  • Under Export to File, choose the radio button “French file format”.
DART FEC file creation | TJC Group
Figure 3: DART FEC file creation
  • As a result, you can find your generated data using transactions. Verify the result and extract the FEC file. You can display the data via List and export the file as a local file with extension .txt.
DART file extraction | TJC Group
Figure 4: DART file extraction
FEC solution by SAP DART | TJC Group
Figure 5: FEC solution by SAP DART.

Reference SAP Notes:

1933144 – Article L47 A I of the French Tax regulation effective 01.01.2014

1951943 – DART: France Legal Requirement FAQ note

1923322 – DART: View file creation for France Legal Requirement

2162977 – DART: Order of implementation of notes for FEC

How to do a technical validation?

“Test Compta Demat” is a free FEC testing tool to validate the file structure and specifies the anomaly points detected to be compliant from a technical perspective.

You can download “Test Compta Demat” from the following link: https://www.economie.gouv.fr/dgfip/outil-test-des-fichiers-des-ecritures-comptables-fec  

You can find out more on how to create and submit the FEC file in this Expert Guide to International Compliance.

An “Out of the Box” solution to easily generate the FEC file

The generation of the FEC file is a cumbersome process that requires time and niche knowledge. At TJC Group we know that and that is why we have worked hand in hand with our clients to develop a straightforward software solution to simplify the process. If you are not familiar with DART or you do not have the resources to implement all prerequisites properly, the FEC 4.0 by TJC is an SAP Certified software that helps SAP customers overcome Audit and Tax challenges, not only for the FEC in France but also to meet other OECD countries’ requirements through a SAF-T (Standard Audit File for Tax) package. 

FEC solution | TJC Group
Figure 6: FEC solution by TJC

The FEC by TJC was developed in collaboration with one of the Big Four audit firms to simplify extraction and produce compliant files according to the FEC requirements without impacting your SAP system’s performance.

It can make deliver massive time savings and reduce implementation costs. Moreover, we provide predefined validation rules to ensure technical compliance, and all customers can define custom rules to meet their business requirements. 

Since 2013, the TJC FEC solution has been successfully used by more than 400 SAP customers, which allows TJC to improve this solution, particularly for their business needs continually. The latest release, the FEC 4.0, provides a user-friendly interface with Fiori design and is compatible with SAP versions from ECC6 to S/4HANA UI5.

SAP DART vs TJC FEC
Figure 7: SAP DART vs TJC FEC

Wrap-up and Conclusion

If you are not familiar with DART or you do not have the resources to implement all prerequisites properly, the FEC software solution by TJC is good support for tax and audit professionals, particularly when having to meet the tight deadlines imposed by the French Tax Authorities.

Free VAT Guide Banner Image

Watch this video to find out the benefits of the FEC solution by TJC in or get in touch with us to request a demo.

FEC 4.0 Software | TJC Group
Note: all the images have been produced by TJC Group.

 Sources of information:

  • “Test Compta Demat” FEC testing tool: https://www.economie.gouv.fr/dgfip/outil-test-des-fichiers-des-ecritures-comptables-fec
  • SAP Note 1933144- Article L47 A I of the French Tax regulation effective 01.01.2014: https://launchpad.support.sap.com/#/notes/1933144
  • SAP Note 1951943 – DART: France Legal Requirement FAQ note: https://launchpad.support.sap.com/#/notes/1951943
  • SAP Note 1923322 – DART: View file creation for France Legal Requirement: https://launchpad.support.sap.com/#/notes/1923322
  • SAP Note 2162977 – DART: Order of implementation of notes for FEC: https://launchpad.support.sap.com/#/notes/2162977