EBP ONLINE 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 displayed in the export file generated by Eurécia and intended for your accounting software.
Beforehand
The export file contains 12 fields, none of which require prior configuration.
- You can define the journal code.
- You can enter the subsidiary account and 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 so that it appears in the export file.
Under the Other settings section:
Access: Admin area > General settings > Employee record -> Employment tab
1. You should enter the "third-party account" in your employees' records.
The procedure is complete
The export described in this guide enables all the information required for accounting to be sent to EBP Online.
File format
- Name of file to be generated: EBP_OPENLINE_MMAAAA.csv
- Text file (CSV extension)
- Separator ;
- Number of decimal places: two
- Decimal separator: comma
Header row
A header row will be included in the file and will contain the column labels
File content
|
No. |
Description |
Format |
Details |
|
1 |
Journal code |
|
Journal code defined on the company record |
|
2 |
Day |
DD/MM/YYYY |
Date of the accounting export in Eurécia (pop-up) |
|
3 |
Document date |
DD/MM/YYYY |
Date approved by the manager (status changed to approved) |
|
4 |
Document |
|
« NDF » + MM/YY |
|
5 |
YOOZ number |
|
Corresponds to the document ID generated by Eurécia |
|
6 |
General account |
|
Depending on the lines: expense account, VAT account or centralising third-party account for the employee |
|
7 |
Subsidiary account |
|
Only on credit lines: employee's third-party account number (limited to 8 characters, truncated from the left) |
|
8 |
Third-party label |
|
Employee's « SURNAME + First name » (to appear on all lines) |
|
9 |
Label |
|
« NDF » + SURNAME + MM/YYYY |
|
10 |
Debit |
|
Amount excluding VAT on debit lines (in the currency entered) « 0.00 » on credit lines |
|
11 |
Credit |
|
Amount including VAT on credit lines (in the currency entered) « 0.00 » on debit lines |
|
12 |
Analytical item |
|
Only entered on expense lines excluding VAT |
File examples
Comments
Please sign in to leave a comment.