CEGID QUADRATUS ACCOUNTING 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 displayed in the export file generated by Eurécia and intended for your accounting software.
Prerequisites
The export file contains 23 fields, none of which requires prior configuration.
- You can configure the journal code in the connector toolbox.
Configuration
Access: Admin Area > General settings > Company details -> Configuration tab
1. You can specify a journal code in the connector toolbox. By default, the journal code is ND.

The procedure is complete
The export described in this guide enables all the elements required for accounting to be sent to Cegid Quadratus Accounting.
File format
- Text file (TXT extension)
- Positional file
- No header lines
- Date format: DDMMYY
File content
|
Order |
Columns |
Start |
Length |
Comments |
|
1 |
Line type |
1 |
1 |
M |
|
2 |
Account |
2 |
8 |
|
|
3 |
Journal code |
10 |
2 |
ND by default Configured in the connector toolbox |
|
4 |
Folio |
12 |
3 |
000 hard-coded |
|
5 |
Posting date |
15 |
6 |
Date selected during export |
|
6 |
Empty |
21 |
1 |
Empty |
|
7 |
Label |
22 |
20 |
Expense claim description |
|
8 |
Entry direction |
42 |
1 |
C for credit D for debit |
|
9 |
Sign |
43 |
1 |
+ or - |
|
10 |
Amount |
44 |
12 |
In cents |
|
11 |
Counterpart |
56 |
8 |
Empty |
|
12 |
Due date |
64 |
6 |
Expense date |
|
13 |
Lettering |
70 |
5 |
Empty |
|
14 |
Document number |
75 |
5 |
Empty |
|
15 |
Analytical code |
80 |
10 |
Code of the selected analytical account |
|
16 |
Quantity |
90 |
10 |
Empty |
|
17 |
Document number |
100 |
8 |
Expense claim number |
|
18 |
Currency |
108 |
3 |
User's currency |
|
19 |
Journal code |
111 |
3 |
ND by default Configured in the connector toolbox |
|
20 |
Empty |
114 |
3 |
Empty |
|
21 |
Entry label |
117 |
32 |
Expense description |
|
22 |
Document number |
149 |
10 |
Expense claim number completed with leading zeroes |
|
23 |
Empty |
159 |
73 |
Empty |
Specific features
-
Order of the lines to be generated in the file:
- Net amount processed line
- VAT amount processed line
- Gross amount reimbursed line
- The net and VAT lines for an expense follow one another
- Only one gross amount line per expense claim
File examples

Comments
Please sign in to leave a comment.