Standard Cegid Export
Updated
by Chaïma Bnina
This export format corresponds to Cegid's standard accounting format.
In this article, we will go through the data generated in every column.
File format:
File type | TRA |
Separator | No separator |
File name format | CompanyName_yyyy-MM-ddThh-mm-ss-ms.csv |
Accounting software | Cegid |
Encoding | ANSI |
File content:
Rows:
Group | By invoice |
Credit lines | One line per invoice |
Debit lines | One tax-free line per invoice One tax-free line per analytical axis One VAT line per invoice |
Currency | Company currency |
Columns:
Heading:


Column | Type | Character length | Content | Example |
1 | Charaters | 3 | Fixed value : *** | *** |
2 | Alphanumeric | 2 | The product managing the file. Fixed value: S5 for business place | S5 |
3 | Alphabetical | 3 | Origin of the file. Fixed value: EXP for accounting firm | EXP |
4 | Alphabetical | 3 | Contents of the file. Fixed value: JRL for journal | JRL |
5 | Alphabetical | 3 | File format. Fixed value: EXT for extended | EXT |
6 | 3 | Empty | Empty | |
7 | Date | 8 | CEGID default date. Fixed value: 01011900 | 01011900 |
8 | Date | 8 | CEGID default date Fixed value: 01011900 | 01011900 |
9 | Numerical | 3 | File version. Fixed value: 011 | 011 |
10 | 5 | Empty | Empty | |
11 | Date | 8 | CEGID default date Fixed value: 01011900 | 01011900 |
12 | Alphanumeric | 9 | Fixed value: 0000CEGID | 0000CEGID |
13 | 65 | Empty | Empty | |
14 | Character | 1 | Fixed value : - | - |
15 | 12 | Empty | Empty | |
16 | Date | 8 | CEGID default date Fixed value: 01011900 | 01011900 |
17 | Numerical | 5 | Fixed value : 001-- | 001-- |
18 | 16 | Empty | Empty |
Accounting entry:
Column number | Type | Length in characters | Content | Example |
1 | Alphabetical | 3 | The journal entry code Default: NDF Format : ddMMyyyy | NDF |
2 | Date | 8 | Export generation date: current date. Format : ddMMyyyy | 20122019 |
3 | Alphabetical | 2 | Nature of movement. Fixed value: OD for various operations | OD |
4 | Alphanumeric | 17 | Account corresponding to the line · Debit Line: Tax-free: Category charge account · VAT: Category VAT account · Credit Line: Employee reference | 625100 |
5 | Alphabetical | 1 | Nature of the movement line. Fixed value by line · Debit Line: Tax-free / VAT: Empty · Tax-free analytical: A for Analytical · Credit Line: X for Auxiliary | A |
6 | Alphanumeric | 17 | Debit Line: Tax-free / VAT: Empty · Tax-free analytical : Project's internal reference · Credit Line: Employee reference | Int001 |
7 | Alphanumeric | 35 | VAT: fixed value: VAT Credit / tax-free line: Invoice category | Plane |
8 | Alphanumeric | 35 | Invoice description: Invoice title in Expensya | Return flight |
9 | 3 | Empty | Empty | |
10 | Date | 8 | Movement due date. Tax-free: fixed value: 01011900 · Tax-free / Credit: Invoice date Format: ddMMyyyy | 12122019 |
11 | Alphabetical | 1 | Sense of movement Flow: D Credit: C | C |
6 | Numerical | 20 | Amount by line type. · Debit : · Tax-free: Tax-free invoice amount in company currency (Amount after VAT - VAT recoverable) · VAT: Amount of recoverable VAT of the invoice in the currency of the company · Credit: · Amount reimbursable in the currency of the company if the invoice is reimbursable · Total amount in company currency if the invoice is not reimbursable Format: xxx, xx | 400,00 |
11 | Alphabetical | 1 | Type of movement. Default: N for Normal writing. Configurable by Expensya support | N |
12 | Numerical | 8 | Invoice reference in Expensya | 25 |
13 | Alphabatical | 3 | Company currency in three characters | EUR |
14 | Numerical | 10 | Currency rate of the movement. Fixed value: 1.00000000 | 1.00000000 |
15 | Alphabetical | 3 | Fixed value: E-- | E-- |
16 | 40 | Empty | Empty | |
17 | Numerical | 3 | Home institution Fixed value: 001 | 001 |
18 | Alphanumeric | 2 | Analytical axis. · Analytical line: fixed value: A1 · Other lines: Empty | A1 |
19 | 37 | Empty | Empty | |
20 | Date | 8 | CEGID default date.
Fixed value: 01011900 | 01011900 |
21 | Date | Export generation date: current date. Format: ddMMyyyy | 20122019 | |
22 | Numerical | 3 | Fixed value: 001 | 001 |
23 | 17 | Empty | Empty | |
24 | Date | 8 | Invoice date Format: ddMMyyyy | 20122019 |
25 | 2 | Empty | Empty | |
26 | Alphabetical | 1 | Nature of movements. Fixed value: N for Normal | N |
27 | Alphanumeric | 716 | Fixed value | See example file from position 305 to position 1021 |
28 | Alphabetical | 2 | Movement status according to the type of line: · Tax-free analytical: empty Tax-free: RI VAT / Credit: AL | AL |
29 | 104 | Empty | Empty | |
30 | Alphabetical | 3 | Line type: · Tax free analytical: DIV Tax-free: HT VAT: VAT · Credit: TTC | DIV |
40 | Alphanumeric | 278 | Fixed value | See example file from position 1130 to position 1408 |