Standard Cegid Export
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 | TenantName_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 | Tenant 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 tenant currency (Amount after VAT - VAT recoverable) · VAT: Amount of recoverable VAT of the invoice in the currency of the tenant · Credit: · Amount reimbursable in the currency of the tenant if the invoice is reimbursable · Total amount in tenant 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 | Tenant 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 |
