CEGID BUSINESS PLACE format

Introduction 

This article provides a detailed procedure 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 displayed in the export file generated by Eurécia and intended for your accounting software. 

Prerequisites

The export file contains 22 fields, only one of which requires prior configuration:

  • Journal code: journal code referenced in your accounting software.

Configuration

Access: Admin area > Expense claims > Advanced settings > Other settings

1. The journal code must be entered in the advanced expense claim settings so that it appears in the export file.



Under the Other settings section: 

 

The procedure is complete

 

anoter-ROSE.png  The export described in this guide makes it possible to send all the items required by accounting to Cegid Business Place.

 

Technical specifications:

  • Flat .txt file

 

Header row:

  • The first row is a title (retrieve the company record code from the CODE field in the screenshot above)
  • Grouping of identical codes (VAT, accounting accounts and (if third party + centralising third party are identical on the same row))

Column descriptions: 

Order

Fields

Position

Length

 

Eurécia comment

 

1

Journal code 

1

3

Journal code (the “journal code” field in the company record, Settings tab)

2

Document date

4

8

Movement date, DDMMYYYY format

Posting date when clicking on accounting export

3

Movement type

12

2

OD

4

General account

14

17

 Accounting account from the reimbursement scale (class 6 accounts)

For the VAT line, VAT account (class 4)

Or the third-party account from the employee record (first line)

 5

 Movement line type

31

1

X = Auxiliary (always on the first line per employee); A = Analytical; H = Analytical + General; O = OD; Analytical; G = DMS

(Cases handled by the platform: X, A)

 6

 Centralising third-party account if type = X

32

17

Employee’s centralising third-party account if type = X

Analytical account code if type = A

If different from X, blank (first line)

7

Internal movement reference (accounting document number)

49

35

-          Expense claim number

8

Movement description

84

35

- Description of the expense claim and the person’s name

9

Payment method code

119

3

Possible codes:

CHQ for cheque, VIR for direct transfer, ESP for cash

Payment method to be retrieved if present in the expense claim; otherwise VIR by default

10

Due date

122

8

DDMMYYYY, same as document date (ref. 2)

11

Movement direction

130

1

“D” if amount >= 0, otherwise “C”, for the accounting account from the reimbursement scale and for the VAT account from the reimbursement scale /

 

 “C” if amount >= 0, otherwise “D”, for the employee’s third-party account or the employee’s centralising account

12

First AMOUNT (AMOUNT1)

131

20

If the expense is in the same currency as the company, only AMOUNT 1 is entered; otherwise, AMOUNT1 is in the foreign currency and AMOUNT2 in the company currency; the decimal separator is ,

separator “,”

13

Movement type

151

1

Always the letter N

14

Document number

152

8

- Expense line reference opposite the expenses, or blank opposite the third-party account or VAT

- When lines are grouped, this number is blank

15

Movement currency code

160

3

CURRENCY code if different from the currency

16

Currency rate

163

10

Currency rate if different from the company currency

separator “,”

17

Amount meaning coding

173

3

E--   if amount1 is in euros

DE-  if a currency is present.

18

AMOUNT2

176

20

Amount entered in the currency, number format with 2 decimal places, separator “,”

Otherwise blank

19

AMOUNT3

196

20

blank

20

Associated establishment

If not entered, default establishment

216

3

-          Structure code, otherwise blank

21

Analytical dimension code for CEGID software

219

2

-          Company record code field, value A1, A2, A3

-          +1 if dimension 2 +2 if dimension 3…

Always the code in the company record (the first two characters of the website field in the company record, no increment)

22

Multi-due-date management

221

2

-          Leave blank

 

File example: 

 

 

Was this article helpful?

0 out of 0 found this helpful

Comments

Please sign in to leave a comment.