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
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:
Comments
Please sign in to leave a comment.