SAGE LIGNE 100 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 know 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 8 fields, three of which require prior configuration.

  • You can define the journal code. 
  • You can enter the auxiliary account and third-party account.
  • You must set the VAT profile to "yes" in the toolbox.

Configuration

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

1. You must enter the "journal code" field in the advanced expense claim settings for it to appear 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 allows all the items required for accounting to be sent to Sage ligne 100 Online.

 

File format

  • TXT file

  • Date format: DDMMYYYY

  • Decimal separator: "full stop"

  • Column separator: "semicolon"

  • Number of decimal places: 2

File contents


Field no.

Description

Details

1

Journal code

Expense claim journal code

2

Export date

Accounting export date (DDMMYYYY format)

3

Document number

Eurécia document number (e.g. 17000002)

4

Accounting account

 

5

Third-party account

Employee's third-party account (only on line C)

6

Label

 

7

Direction

D = debit; C = credit

8

Amount

Amount excluding VAT for D lines

Amount including VAT for C lines

 

Specific features

Field 4 => Accounting account

For a debit line: Expense account/VAT account

For a credit line: Control account

  

Field 6 => Label

The label will be constructed according to the following rules:

  

For expense lines (direction D):

SURNAME + MONTH + YEAR + expense label

 Example: SURNAME FIRST NAME 102018 cafe marcel meal on 27/09

 

For credit lines (direction C):

SURNAME + MONTH + YEAR

Example: SURNAME FIRST NAME 102018

 

File examples 

Was this article helpful?

0 out of 1 found this helpful

Comments

Please sign in to leave a comment.