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