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
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
| Fields | Position | Format |
Eurécia comment
|
| Line number | 1 | Numeric | This is a line number |
| Date | 2 | DDMMYYYY | Date of the accounting entry, entered in a dialogue box when exporting (as with most existing exports) |
| Journal code | 3 | alphanumeric, up to 4 characters | Accounting journal code field (to be retrieved from the general tab of the company record) |
| General ledger account | 4 | alphanumeric, up to 15 characters | Accounting account for the reimbursement scale (class 6 accounts). |
| Or VAT account | 4 | alphanumeric, up to 15 characters | VAT account for the reimbursement scale (account beginning with 445) |
| Or third-party account | 4 | alphanumeric, up to 15 characters | Third-party account in the general tab of the employee record |
| Automatic description | 5 | Blank | Leave the field blank (nothing between two commas: ",,") |
| Manual description | 6 | in 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 number | 7 | in quotation marks and alphanumeric, up to 15 characters | Expense claim document no. generated by Eurécia |
| Amount | 8 | numeric, with a full stop as the decimal separator. | Example: 58.95 for 58,95 |
| Debit/credit | 9 | D 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 date | 10 | DDMMYYYY | Same as the date in field position 2 |
| Currency | 11 | EUR 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 5codeRegroupement1: 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:
Comments
Please sign in to leave a comment.