Standard Cegid Export

Chaïma Bnina 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

How did we do?

Quadratus Export

How to activate accounting export formats?

Contact