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

 

anoter-ROSE.png  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

 

Was this article helpful?

2 out of 2 found this helpful

Comments

Please sign in to leave a comment.