DIVALTO STANDARD Format (V6)

Introduction

This article provides detailed instructions for configuring the expense export for your expense reports.

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, none of which requires prior configuration.

  • You can configure the journal code in the connector toolbox.
  • You can define the document number.

Configuration

Access: Admin Area > General settings > Company details -> Subscription tab

1. You can specify a journal code in the connector toolbox.

Access: Admin Area > Expenses > Advanced settings > Other settings

1. You can define the document number in your Excel file. To do this, you must fill in the "company code" field in the advanced expense settings so that it appears in the export file.



Under the Other settings section:

This field will be added to the expense number.

The procedure is complete

 

anoter-ROSE.png  The export described in this guide enables all the items required for accounting to be sent to Divalto Standard (V6).

 

File format

  • File name: ECRITURES.csv
  • Text file (CSV extension)
  • Separator;
  • Date format: DD/MM/YYYY
  • Decimal separator: comma

File header

1st line: Dossier;Type;Journal;Compte;Libellé;Date;Contrepartie;Reglement;Pièce;Échéance;Devise;Montant;MontantDoss;Sens;Chqno;Lett;LettDate;Axe1;Axe2;Axe3;Axe4;Collectif;

File contents

Order

Columns

Type

Comments

1

Dossier

String

1 hard-coded

2

Type

String

1 hard-coded

3

Journal

String

Journal code in the connector toolbox

4

Account

String

 

5

Description

String

Expense description + « - » + expense report description

6

Date

Date

Expense date

7

Counterpart

String

Third-party account from the employee record

8

Payment

 

String

C hard-coded

9

Document

String

Company record code + expense number

10

Due date

Date

Empty

11

Currency

String

Expense currency

12

Amount

Decimal

 

13

Dossier amount

Decimal

Amount in euros if the previous column is not in euros

14

Direction

Integer

1 if credit

2 if debit

15

Cheque number

String

Empty

16

Matching

String

Empty

17

Matching date

Date

Empty

18

Axis 1

String

Analytical code of the account for axis 1

19

Axis 2

String

Analytical code of the account for axis 2

20

Axis 3

String

Analytical code of the account for axis 3

21

Axis 4

String

Analytical code of the account for axis 4

22

Collective

String

Empty

 

Specific features

  • No grouping
  • Order of the lines to be generated in the file:
    • Processed net amount line
    • Reimbursed gross amount line
    • Processed VAT amount line

File examples

 

 

Was this article helpful?

0 out of 0 found this helpful

Comments

Please sign in to leave a comment.