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

 

anoter-ROSE.png  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

Configuration

  • Header fixed area
    • Free-entry field:
      • Default: ***
  • New CEGID Y2 analytical management
    • Free-entry field:
      • If old version: - (hyphen)
      • If new version: X
  • 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
  • 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

Sample files

 

Pièces jointes

Was this article helpful?

16 out of 22 found this helpful

Comments

Please sign in to leave a comment.