FEC Import
Introduction
FEC: “fichier des écritures comptables” in French or the Accounting entries file in English.
The FEC is a document that contains all accounting entries from all journals. In the event of an audit, it must be presented to the tax inspector.
Since January 1, 2014, taxpayers who keep their accounts using computerized systems must present them in the form of electronic files during an audit by the tax authorities (Article L.47 A-I of the Tax Procedures Code).
These accounting entry files must comply with the standards codified in Article A.47 A-1 of the Book of Tax Procedures (source in French: https://www.economie.gouv.fr/dgfip/outil-de-test-des-fichiers-des-ecritures-comptables-fec).
FEC Import
Access: Accounting → Configuration → FEC Import
Access: Accounting → Configuration → Exports/Imports → Import FEC Type
Since version 8.0 of AOS, users now have the option to perform FEC imports.
No prior installation or configuration is necessary: the menu entry appears automatically from version 8.0 onwards.
Before launching the FEC import, remember to configure a FEC import type beforehand.
Create an FEC import type
Access: Accounting → Configuration → Exports/Imports → Import FEC type
The FEC import type is important because it is involved in field mapping. Two types of FEC imports are available in AOS by default:
-
FEC
-
FEC with VAT
Users are free to create other types of FEC imports.
Create an FEC import
Imported entries will have a sequence number that will be reflected on their entry sheet.
Access: Accounting → Configuration → FEC Import
-
Create a new FEC import.
-
Name: give it a name.
-
Import FEC type: define the FEC import type (for example, FEC with VAT).
In order to select a FEC import type, it must be configured beforehand.
-
Move description: add a description of the entry if necessary.
-
Description: add a description if necessary.
-
Data file: select the data file to download.
-
Validate the generated move: check this box if you want the imported entries to have the status “Daybook” (note: remember to enable the option that allows daybook entries) or the status “Accounted”.
For the imported entries to have the status “Daybook,” this option must be enabled beforehand. If the Daybook option is not enabled, the entries will be accounted.
When the “Validate the generated move” option is enabled, the system will check the consistency of the entries. Entries without anomalies will be validated with the status ‘Daybook’ or “Accounted” and inconsistent entries will be marked as anomalies.
When this option is disabled, imported entries will have the status “New”.
For entries to have the Daybook status, you must enable the option in the Accounting application and in the accounting journals.
-
First, enable this option in the Accounting application settings. Access: Application config → Apps management → Accounting, configure → click on the company file → in the Accounting entries status section, enable the “Accounting Daybook” option.
-
Next, activate the daybook mode on the journals. Access: Accounting → Configuration → Financial → Journals → Configurations tab → activate the “Allow accounting daybook” option
- Run FEC Import: click on the “Import” button. The imported entries can be found in the list of accounting entries (access: Accounting → Moves → Moves/Move lines. To find the imported lines, use the filter at the top of the page).
It is possible to import all entries at once.
However, data processing may take some time.
In this case, the user can import the entries journal by journal.
- Generate tax lines: once the entry lines have been imported, you can open an accounting entry and generate the tax lines by clicking on the “Generate tax lines” button (access: Accounting → Moves).