CEGID Y2 format
Introduction
This article provides detailed instructions for configuring the expense export for your expense claims.
The aim is to enable you to configure or find out how to modify the data appearing in the export file generated by Eurécia and intended for your accounting software.
Before you start
The export file contains 24 fields; none of them require prior configuration.
- You can configure the journal code in the connector toolbox.
Configuration
Access: Admin area > General settings > Company file -> Configuration tab
1. You can specify a journal code in the connector toolbox. By default, the journal code is ND.

The procedure is complete
The export described in this guide enables all the information required for accounting to be sent to Cegid Y2.
File format
- Text file (TRA extension)
- Positional file
- No header lines
- Date format: DDMMYYYY
- Amount format: comma separator, left-aligned
File content
File header
|
Order |
Columns |
Start |
Length |
Comments |
|
1 |
Fixed area |
1 |
3 |
Toolbox |
|
2 |
Empty |
4 |
144 |
Empty |
|
3 |
New CEGID Y2 analytical management |
148 |
1 |
Toolbox |
File content
|
Order |
Columns |
Start |
Length |
Comments |
|
1 |
Journal code |
1 |
3 |
Toolbox |
|
2 |
Accounting date |
4 |
8 |
Date entered in the export window |
|
3 |
Document type |
12 |
2 |
Toolbox |
|
4 |
General ledger account |
14 |
17 |
See specific features |
|
5 |
Account type |
31 |
1 |
See specific features |
|
6 |
Auxiliary or Section |
32 |
17 |
See specific features |
|
7 |
Internal reference |
49 |
35 |
Document number |
|
8 |
Description |
84 |
35 |
Toolbox Do not fill in on analytical lines |
|
9 |
Payment method code |
119 |
3 |
Toolbox |
|
10 |
Due date |
122 |
8 |
Empty |
|
11 |
Direction |
130 |
1 |
Debit = D Credit = C |
|
12 |
Amount 1 |
131 |
20 |
In euros |
|
13 |
Entry type |
151 |
1 |
Toolbox |
|
14 |
Document number |
152 |
8 |
Entry number |
|
15 |
Currency code |
160 |
3 |
Empty |
|
16 |
Exchange rate |
163 |
10 |
Empty |
|
17 |
Amount code |
173 |
3 |
E-- |
|
18 |
Amount 2 |
176 |
20 |
0 |
|
19 |
Amount 3 |
196 |
20 |
0 |
|
20 |
Establishment |
216 |
3 |
Toolbox |
|
21 |
Analytical dimension |
219 |
2 |
See specific features |
|
22 |
Multiple due-date management |
221 |
2 |
Empty |
|
23 |
Empty |
223 |
208 |
Empty on analytical lines. Do not include the column on the other lines. |
|
24 |
Analytical section 2 |
431 |
3 |
See specific features Do not include the column on the other lines. |
Specific features
- Grouping by general ledger account
-
Order of the lines to be generated in the file:
- Processed gross amount line
- Processed VAT amount line
- Processed net amount line
- Analytical lines
-
General ledger account column:
- Processed net amount line: Expense account for the selected expense type.
- Processed VAT amount line: VAT account for the selected expense type.
- Processed gross amount line: Clearing account for the payment method on the employee file. If empty, the third-party account for the payment method on the employee file.
-
Account types:
- Analytical = A
- Others = Empty
-
Auxiliary or Section:
- If account type = A -> Analytical account. Source of the analytical account in the toolbox.
-
Analytical dimension:
- AX where X is the number of the analytical dimension.
-
Document number
- Increment for each exported expense claim.
- Starts again at 1 for each export.
-
Analytical section 2:
- Analytical account on analytical lines only.
- Do not include the column on the other lines.
-
Company code:
- If department code:
• Filter by a department before exporting so that the code for this department is entered
• If the department code is not entered or if the ‘department’ filter is set to ‘All’, the company code will be entered - If structure code:
• Filter by a structure before exporting so that the code for this structure is entered
• If the structure code is not entered or if the ‘structure’ filter is set to ‘All’, the company code will be entered - If company code, the Code field (Company file > Configuration tab > Expense claims section)
- If fixed value: the value is always entered
- If department code:
Configuration
-
Header fixed area
-
Free-entry field:
- Default: ***
-
Free-entry field:
-
New CEGID Y2 analytical management
-
Free-entry field:
- If old version: - (hyphen)
- If new version: X
-
Free-entry field:
-
Company code source:
-
List of values:
- Fixed value (displays a free-entry field)
- Company Code: default value, code field from the company file
- Department code: department establishment code field
- Structure code: structure establishment code field
-
List of values:
- The description can be constructed using several sources.
-
Document type
- Text field, default OD
-
Entry type
- Text field, default N (enter S for simulation)
-
Establishment
- Option to choose between the department code and the structure code
-
Payment method
- Text field, default VIR

Comments
Please sign in to leave a comment.