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

 

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

 

Was this article helpful?

2 out of 2 found this helpful

Comments

Please sign in to leave a comment.