Format SAGE COMPTA I7 SQL 8.5
Introduction
This article provides detailed instructions for configuring the expense export for your expense claims.
The aim is to enable you to configure or understand 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 12 fields, 1 of which requires prior configuration.
- You must enter the third-party account number in the employee record.
Configuration
Access: Admin area > General settings > Employee record -> Employment tab


The procedure is complete
The export described in this guide allows all the items required for accounting to be sent to Sage Compta i7 SQL 8.5.
File format
- Text file (TXT extension)
- Separator: tabs
- No header row
- Date format: DD/MM/YYYY
- Number of decimal places: 2
File contents
|
Order |
Columns |
Comments |
|
1 |
Journal code |
Toolbox |
|
2 |
Document date |
Date entered in the export window |
|
3 |
Invoice number |
Expense claim number |
|
4 |
General account no. | |
|
5 |
Third-party account no. |
Third-party account from the employee record for Credit lines if there is a centralising account; otherwise blank Blank for Debit lines |
|
6 |
Entry description |
Toolbox |
|
7 |
Free information 1 |
Toolbox for Debit lines Blank for Credit lines |
|
8 |
Debit amount |
0.00 for Credit lines (if credit is positive) Net amount/VAT on Debit lines (if credit is positive) Reverse if negative |
|
9 |
Credit amount |
Gross amount for Credit lines (if credit is positive) 0.00 on Debit lines (if credit is positive) Reverse if negative |
|
10 |
Entry type |
G for General A for Analytical |
|
11 |
Section no. 1 |
For A-type lines only. Toolbox |
|
12 |
Analytical plan no. |
Toolbox If there is no plan, do not include the column |
Specific features
- No account grouping
-
Order of the lines to be generated in the file:
- Processed Gross Amount line
- Processed Net Amount line for the general account
- Processed Net Amount line for the analytical account
- Processed VAT Amount line
-
Account number column:
- Processed Net Amount line: Expense account for the selected expense type.
- Processed VAT Amount line: VAT account for the selected VAT rate.
- Processed Gross Amount line: Centralising account for the payment method in the employee record, if one exists; otherwise, the third-party account from the employee record.
- Balance between the general account lines
- Amount of the analytical lines = Amount of the general lines
- Reverse credit/debit amounts if the amount is negative
File example

Comments
Please sign in to leave a comment.