EBP COMPTA 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 appearing in the export file generated by Eurécia and intended for your accounting software.

Before you begin

The export file contains 11 fields, two of which require prior configuration.

  • You can define the journal code. 
  • You can define the third-party account.

Configuration

Access: Admin Area > Expense claims > Advanced settings > Other settings

1. You can define the journal code in your Excel file. To do this, you must enter the "journal code" field in the advanced expense claim settings.



Under the Other settings section: 

 

Access: Admin Area > General settings > Employee record -> Employment tab

1. You must enter the "third-party account" in your employees' records.

The procedure is complete

 

anoter-ROSE.png  The export described in this guide enables you to send all the information required for accounting to EBP Compta.

 

File format

  • Name of file to be generated: ECRITURES.TXT
  • Text file (CSV extension)
  • Separator ,
  • Date format: DD/MM/YYYY or DD/MM/YY
  • Decimal separator: full stop

File contents

FieldsPositionFormat

 

Eurécia comment

 

Line number 1NumericThis is a line number
Date2DDMMYYYYDate of the accounting entry, entered in a dialogue box when exporting (as with most existing exports)
Journal code3alphanumeric, up to 4 charactersAccounting journal code field (to be retrieved from the general tab of the company record)
General ledger account4alphanumeric, up to 15 characters Accounting account for the reimbursement scale (class 6 accounts). 
Or   VAT account4alphanumeric, up to 15 charactersVAT account for the reimbursement scale (account beginning with 445)
Or third-party account4alphanumeric, up to 15 charactersThird-party account in the general tab of the employee record
Automatic description5BlankLeave the field blank (nothing between two commas: ",,")
Manual description6in quotation marks and up to 40 characters

Defined in the application's translation file

{0}=expense claim description,

{1}=surname,

{2}=first name,

{3}=period start,

{4}=period end,

{6}= analytical code 2

-          For third-party accounts, only the underlined elements are active

Document number7in quotation marks and alphanumeric, up to 15 charactersExpense claim document no. generated by Eurécia
Amount8numeric, with a full stop as the decimal separator.Example: 58.95 for 58,95
Debit/credit9D for debit or C for credit"D" if amount >= 0 otherwise "C", for the accounting account of the reimbursement scale and for the VAT account of the reimbursement scale /  "C" if amount >= 0 otherwise "D", for the employee's third-party account or the employee's centralising account
Due date10DDMMYYYYSame as the date in field position 2
Currency11EUR by default

 

Specific features

  • One line per expense account for the amount excluding tax (sum of all expenses under the same expense account per employee and per expense claim document number)
  • One line per VAT account for the VAT amount (sum of all VAT accounts per employee and per expense claim document number)
  • One third-party account line representing the total amount including tax to be reimbursed to the employee (per expense claim document number).

 

Analytical accounting: 

  • The “Analytical line 1 - Field source” and “Analytical line 2 - Field source “Analytical code” fields can be populated using the following fields: 

    • analyticCode1: analytical code of the account on axis 1

    • *analyticCode2: analytical code of the account on axis 2

    • analyticCode3; analytical code of the account on axis 3

    • analyticCode4: analytical code of the account on axis 4
      analyticCode5: analytical code of the account on axis 5

    • codeRegroupement1: grouping code of the account on axis 1

    • codeRegroupement2: grouping code of the account on axis 2

    • codeRegroupement3: grouping code of the account on axis 3

    • codeRegroupement4: grouping code of the account on axis 4

    • codeRegroupement5: grouping code of the account on axis 5

“Analytical accounting management” must be ticked for the connector in the subscription tab of the company record

File examples:

 

Pièces jointes

Was this article helpful?

0 out of 1 found this helpful

Comments

Please sign in to leave a comment.