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

 

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

Was this article helpful?

6 out of 20 found this helpful

Comments

Please sign in to leave a comment.