ARCOLE 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 know how to modify the data appearing in the export file generated by Eurécia and intended for your accounting software.

Prerequisites

The export file contains 19 fields; only seven of them require prior configuration:

  • The company code(s) defined in your accounting software.
  • Journal codes: the journal code referenced in your accounting software.
  • MOV_INITIAL value (column 12): Can be modified by the EURECIA teams
  • MOV_TRANSAC value (column 13): Can be modified by the EURECIA teams
  • MOV_A2 value (column 15): Can be modified by the EURECIA teams
  • MOV_A3 value (column 16): Can be modified by the EURECIA teams
  • MOV_MAT value (column 17): Can be modified by the EURECIA teams

Configuration

1. The company code(s) defined in your accounting software.

Access: Admin Area > General settings > Company record -> Organisation tab -> Departments -> Company code

2. Configuration options when setting up the connector.

 

The procedure is complete

 

anoter-ROSE.png  The export described in this guide allows all the elements required for accounting to be sent to Arcole.

 

Technical information regarding the file format expected by your payroll application:

  • File name: EURECIA_ARCOLE_YYYY-MM-DD.csv
  • YYYY-MM-DD = day, month and year of the extraction

Type

CSV

Column separator

Semicolon

Decimal separator

comma

Number of decimal places

two

End of line

CRLF

 

File header:

A header row will be present in the file and will contain the column labels, as described in the table below.

Grouping:

  • No grouping of rows will be applied to the export.
  • There will be one net amount row and one VAT row (if required) for each expense.
  • There is one gross amount row per VAT row if the expenses were made using a bank card (personal card or business card).
  • There is one gross total row for other expenses.

Specific features:

  • The Mov_Name column starts with CB if the expenses were made using a bank card (personal card or business card).
  • The Mov_Name column starts with VIR in all other cases.
  • There is one gross amount row per net amount row if the expense was made using a company card.

File contents:

No.

Column header

Description

Comments

1

Company

Company code

Retrieval source

Eurécia company record -> Organisation -> Department -> Company code

2

Mov_Dpt

CB if “Company” = CF
otherwise ALT

 

3

Journal

Journal code

Configurable when setting up the connector

4

Mov_Date_Mov

Export date

Date selected by the customer when performing the accounting export (pop-up)

The default date will be the current date

5

Mov_Date_Init

Expense claim date

Date on which the expense claim was approved by the manager

6

Mov_Name

 

Concatenation of fields

CB (if company card) or VIR (otherwise) +

Expense type code + Employee structure (label)

7

Mov_Acct

Accounting account

 

8

Mov_Db_Cur

Net amount

Only on debit rows

9

Mov_Cr_Cur

Gross amount

Only on credit rows

10

Mov_Sense

Direction

D = debit

C = credit

11

Mov_Cur

Currency

Based on the default currency of the expense claim

12

Mov_Initial

 

Configurable when setting up the connector

13

Mov_Transac

 

Configurable when setting up the connector

14

Mov_A1

Analytical field (only on net amount rows)

Concatenation of fields

Field1 + Field2 + 00

15

Mov_A2

Analytical field (only on net amount rows)

Concatenation of fields

Analytical code (employee) + Absence type code + Code of the selected analytical account 2

16

Mov_A3

Analytical field (only on net amount rows)

Hard-coded value

PROPRE

17

Mov_Matr

Analytical field (only on net amount rows)

Retrieval source

Code of the selected analytical account 1

18

Mov_Tax_Code

VAT code (only on VAT rows)

Retrieval source

Additional VAT rate code

19

Mov_Type

 

Hard-coded value

2 for VAT rows

1 in all other cases

 

File example:

 

Was this article helpful?

0 out of 1 found this helpful

Comments

Please sign in to leave a comment.