Generating the France Fichier d’Ecritures Comptables (FEC) Report
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.
This topic introduces steps on how to properly generate the France Fichier d’Ecritures Comptables (FEC) Report.
For steps on how to create tax audit files, refer to the help topic Generating a Tax Audit File.
Prerequisites
Before generating a France FEC report, you must perform the following tasks:
-
Enable account numbers. Go to Setup > Accounting > Accounting Preferences. On the General subtab, check the Use Account Numbers box. For more information, see Chart of Account Numbering.
-
Set up your chart of accounts.
-
Use the standard Chart of Accounts in NetSuite. To set up your chart of accounts, go to Lists > Accounting > Accounts or to Setup > Accounting > Chart of Accounts. For more information, see Chart of Accounts Management.
-
For OneWorld accounts, use the Statutory Chart of Accounts if the standard Chart of Accounts does not comply with regulatory requirements. For example, if the standard chart of accounts is shared with other subsidiaries, or if the parent company requires a subsidiary to use account names and numbers that are not in the formats required for statutory compliance in the subsidiary’s country. To set up statutory chart of account names and numbers, see Statutory Chart of Accounts for Tax Audit Files.
Note:You can use CSV import to set up or update the Statutory Chart of Accounts. If you are using French accents in the Statutory Chart of Accounts that will be used for France FEC, you can only import to custom records using the following NetSuite encoding: Western (Windows 1252), Western (ISO-8859-1), and Western (Mac Roman).
-
-
Enable GL Audit Numbering and run GL Numbering Sequences. Go to Setup > Company > Enable Features and check the GL Audit Numbering box on the Accounting subtab. For more information, see GL Audit Numbering.
Important:Before generating a France FEC report, make sure that GL Audit Numbering has been enabled, and that you have run GL numbering. Otherwise, file generation and download will fail. This step is not required for accounting periods earlier than 2014.
GL Audit Numbering Setup for FEC Report
The FEC report requires that the values in the EcritureNum and EcritureDate columns are in sync.
The EcritureNum column of the FEC report is the value of the GL# field.
The EctritureDate column of the FEC report is the value of either of the following:
-
The GL# Date field from the GL Audit Numbering feature
-
The transaction date
In Sync |
Out of Sync (GL# Dates are not in chronological order |
||
GL# |
GL# Date |
GL# |
GL# Date |
1 |
January 1 |
1 |
January 1 |
2 |
January 3 |
2 |
January 4 |
3 |
January 4 |
3 |
January 3 |
To ensure that the EcritureNum and EcritureDate columns in your FEC report are in sync, you must use the appropriate GL audit numbering sequence.
When to Use the Transaction Date as EcritureDate
-
If you run the GL audit numbering sequence as part of the accounting period close task at the end of the year
-
If the GL audit numbering sequence has not been set to run every 24 hours
-
If you do not have transactions that go through the approval process which may cause the transaction date to be different from the GL posting date
-
If you have transactions that were assigned a GL# prior to the 2017.2 release. These transactions will not have a GL# Date.
To use the transaction date as EcritureDate:
-
On the GL Audit Numbering Sequence page, in the Numbering section, select Transaction Date in the Order By field.
For more information, see Setting Up a GL Audit Numbering Sequence.
-
Before you generate the FEC report, check the Use Transaction Date box on the Audit Files page.
When to Use GL# Date as EcritureDate
-
If the GL audit numbering sequence has been set to run every 24 hours and the transactions to be reported are covered by this sequence. For example, if you need to run the FEC report for 2019, you must set up your GL Audit Numbering Sequence on January 1, 2019.
-
If you use an approval process that may cause some transactions to have transaction dates that are different from their GL posting dates. Using the GL# Date means that the EcritureDate column shows the posting date of the transaction.
It is recommended to use the Transaction Date as the EcritureDate. However, if you follow approvals, this could cause some inconsistencies between the General Ledger (GL) number and the transaction date. We recommend adding a note to explain this to your auditors.
To use the GL# Date as EcritureDate:
-
On the GL Audit Numbering Sequence page, use the following settings:
-
In the Primary Information section, select Permanent in the Numbering Type field.
-
In the Recurring section, select Hourly in the Recurring Type field, and enter 24 in the Hourly Recurring field.
-
-
Before you generate the FEC report, clear the Use Transaction Date box on the Audit Files page.
Examples
The following examples show bill reference no. VB03 having a transaction date of July 3, 2018. The bill was created with a status of Pending Approval, and it was approved on August 5, 2018.
Run GL Audit Numbering at year End — December 31, 2018 |
|||||
Reference |
Bill |
Bill |
EcritureNum |
EcritureDate is |
|
No. |
Transaction Date |
Approval Date |
GL# |
Entry Date (GL# Date) |
Transaction Date |
VB01 |
7/1/2018 |
7/1/2018 |
1 |
12/31/2018 |
7/1/2018 |
VB02 |
7/2/2018 |
7/2/2018 |
2 |
12/31/2018 |
7/2/2018 |
VB03 |
7/3/2018 |
8/5/2018 |
3 |
12/31/2018 |
7/3/2018 |
VB04 |
7/4/2018 |
7/4/2018 |
4 |
12/31/2018 |
7/4/2018 |
VB05 |
7/5/2018 |
7/5/2018 |
5 |
12/31/2018 |
7/5/2018 |
VB06 |
7/6/2018 |
7/6/2018 |
6 |
12/31/2018 |
7/6/2018 |
If GL Audit Numbering has been set to run every 24 hours:
Run GL Audit Numbering Every 24 Hours/Daily |
|||||
Reference |
Bill |
Bill |
EcritureNum |
EcritureDate is |
|
No. |
Transaction Date |
Approval Date |
GL# |
Entry Date (GL# Date) |
Transaction Date |
VB01 |
7/1/2018 |
7/1/2018 |
1 |
12/31/2018 |
7/1/2018 |
VB02 |
7/2/2018 |
7/2/2018 |
2 |
12/31/2018 |
7/2/2018 |
VB04 |
7/4/2018 |
7/4/2018 |
3 |
12/31/2018 |
7/3/2018 |
VB05 |
7/5/2018 |
7/5/2018 |
4 |
12/31/2018 |
7/4/2018 |
VB06 |
7/6/2018 |
7/6/2018 |
5 |
12/31/2018 |
7/5/2018 |
VB03 |
7/3/2018 |
8/5/2018 |
6 |
12/31/2018 |
7/6/2018 |
Related Topics
- France Fichier d’Ecritures Comptables (FEC) Reporting Compliance
- Tax Audit Files Configuration for France Fichier d’Ecritures Comptables (FEC)
- France Fichier d'Ecritures Comptables (FEC) Field Mapping
- Tax Audit Files
- Creating or Customizing Roles to Use Tax Audit Files
- Using Tax Audit Files
- Generating a Tax Audit File
- Troubleshooting Tax Audit File Generation Failures
- Downloading a Tax Audit File
- Deleting a Tax Audit File
- Statutory Chart of Accounts for Tax Audit Files