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

14-09-20 | Blog

Authors: Patchanok Kluabkaew and Graham Little

Time: 7 min read.

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.

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.	Information	Field Name	Field Type
1	The journal entry code	JournalCode	Alphanumeric
2	The journal entry name	JournalLib	Alphanumeric
3	The number of accounting entry (continuous number sequence)	EcritureNum	Alphanumeric
4	The posting date	EcritureDate	Date
5	The account number. the first three characters must comply with French accounting standard	CompteNum	Alphanumeric
6	The account name, in accordance with French accounting standard	CompteLib	Alphanumeric
7	The sub ledger account number (blank if not used)	CompAuxNum	Alphanumeric
8	The sub ledger account description (blank if not used)	CompAuxLib	Alphanumeric
9	Reference of the supporting document	PieceRef	Alphanumeric
10	Date of the supporting document	PieceDate	Date
11	Description of the accounting entry	EcritureLib	Alphanumeric
12	The debit amount	Debit	Number
13	The credit amount	Credit	Number
14	The lettering of the accounting entry (blank if not used)	EcritureLet	Alphanumeric
15	The lettering date (blank if not used)	DateLet	Date
16	The validation date of the accounting entry	ValidDate	Date
17	Amount in currency (blank if not used)	Montantdevise	Number
18	Currency code (blank if not used)	Idevise	Alphanumeric

 

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.

 

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”.

 

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.

 

 

Figure 4: DART file extraction

 

 

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  

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. 

 

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.

 

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.

 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.

 

Note: all the images have been produced by TJC Group.

 Sources:

• Article A47 A-1 of the French Tax regulation: https://www.legifrance.gouv.fr/affichCodeArticle.do;jsessionid=1D905278ED63729D4CDF44E8064D8160.tpdila07v_3?idArticle=LEGIARTI000027804775&cidTexte=LEGITEXT000006069583&categorieLien=id&dateTexte=20150610

• “Test Compta Demat” FEC testing tool: https://www.economie.gouv.fr/dgfip/outil-test-des-fichiers-des-ecritures-comptables-fec

• SAP Help Data Retention Tool (DART): https://help.sap.com/viewer/12d822d6709e480ea991fb53fd941576/6.18.14/en-US/6f96c2531bb9b44ce10000000a174cb4.html

• 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

• FEC solution by TJC: https://www.tjc-group.com/products/fec