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
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
Comments
Please sign in to leave a comment.