Format SAGE 100C

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 displayed in the export file generated by Eurécia and intended for your accounting software.

Prerequisites

The export file contains 15 fields; none of them requires prior configuration.

  • You can define the journal code. 
  • You can enter the subsidiary account and the third-party account.

 

anoter-ROSE.png  The export described in this guide enables all the elements required by accounting to be sent to Sage 100C.

File format

  • TXT file (TXT extension)
  • separator: semicolon
  • Date format: DD/MM/YYYY

File content

 

File header

Journal;Date;Document number;General account;Third-party account;Description;Ref.;Debit;Credit;Due date;Tax code;Entry type;Analytical plan;Analytical section;Code_Oracle

Order

Columns

Comments

1

Journal

Toolbox

2

Date

Date entered in the export window

3

Document number

Toolbox

4

General account

See Specific features

5

Third-party account

See specific features

6

Description

Toolbox

7

Ref.

Toolbox

8

Debit

See specific features

9

Credit

See specific features

10

Due date

See specific features

11

Tax code

Toolbox

12

Entry type

See specific features

13

Analytical plan

Toolbox + Specific features

14

Analytical section

Toolbox + Specific features

15

Code_Oracle

Toolbox

 

Specific features

  • Grouping by general account
  • Order of the lines to be generated in the file:
    • For each expense account:

      • Expense account line

      • Analytical line

      • VAT lines

 

  • Only one credit line per expense claim after the expense lines

 

  • Account number column:
    • Net amount line processed: Expense account for the selected expense type.
    • VAT amount line processed: VAT account for the selected expense type.
    • Gross amount line processed: Centralising account for the payment method on the employee record.
  • Third-party account column:
    • Gross amount line processed: Third-party account for the payment method on the employee record.
    • Blank on the other lines
  • Debit:
    • Expense account line: net amount processed
    • Analytical line: net amount processed
    • VAT account line: VAT amount processed
    • Gross amount line processed: blank.
    • Swapped with credit in the case of a negative amount.
  •  Credit:
    • Gross amount line processed: gross amount processed
    • Blank for the remainder.
    • Swapped with debit in the case of a negative amount
  • Due date:
    • Date entered at the time of export on the gross amount lines.
    • Blank on the other lines.
  • Entry type:
    • G on general entry lines (net amount, VAT, gross amount).
    • A on analytical lines.
  • Analytical plan:
    • Value configured in the toolbox on analytical lines only.
    • Blank on the other lines.
  • Analytical section:
    • Value configured in the toolbox on analytical lines only.
    • Blank on the other lines.
  • Journal:

Journal code field in the file

  • Document number:

Description field in the file

The {NUM_NDF} key is available for this connector.

  • Description:

Description field in the file

  • Ref:

Description field in the file

The {NUM_NDF} key is available for this connector.

  • Tax code:

Analytical account field

The {CODE_CPL} key is available for this connector.

  • Analytical plan:

Free-text entry field

  • Analytical section:

Analytical account field 

Add the keys below:

{DPT_LVLX}

{STR_LVLX}

{DPT}

{STR}

  • Code_Oracle:

Analytical account field

Add the key below:

{CPT_GENERAL}

 

File examples

 

Pièces jointes

Was this article helpful?

0 out of 2 found this helpful

Comments

Please sign in to leave a comment.