Accounting export template SageCoala

Revision as of 10:13, 18 July 2016 by Jcheng (Talk | contribs) (Text replacement - "[[Accounting_export_template_list|" to "[[Accounting-export-template-list|")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Introduction

This page described the accounting export template Sage Coala.

Output file description

  • Encoding charset: UTF-8
  • Field character separator: ;
  • Decimal separator: ,
  • Fields:
Name Length (in character) Description
Date Format is DD/MM/YYYY
Export code
Flow number
Export account
Debit Number with 2 digits after the decimal separator
Credit Number with 2 digits after the decimal separator
Description 50 Filled with appended spaces to match length and character , is removed
Flow number
Character E


Example of output file

01/01/2014;VT;67;411000;99,00;0,00;Pilote CHRISTIAN CHRISTIAN                        ;67;E
01/01/2014;VT;67;706BVOI;0,00;99,00;Solo FBVOI                                        ;67;E
01/01/2014;VT;69;411000;51,00;0,00;Pilote Éléonore ÉLÉONORE                          ;69;E
01/01/2014;VT;69;706BVOI;0,00;51,00;Solo FBVOI                                        ;69;E
01/01/2014;VT;71;411000;51,00;0,00;Pilote Nadine NADINE                              ;71;E
01/01/2014;VT;71;706BVOI;0,00;51,00;Solo FBVOI                                        ;71;E
02/01/2014;VT;73;411000;408,00;0,00;Pilote Éléonore ÉLÉONORE                          ;73;E
02/01/2014;VT;73;706BVOI;0,00;408,00;Solo FBVOI                                        ;73;E
03/01/2014;VT;75;411000;99,00;0,00;Pilote Christophe LARATTE                         ;75;E
03/01/2014;VT;75;706BVOI;0,00;99,00;Solo FBVOI                                        ;75;E
03/01/2014;VT;77;411000;124,00;0,00;Pilote Marie-France MARIE-FRANCE                  ;77;E
03/01/2014;VT;77;706BVOI;0,00;124,00;Solo FBVOI                                        ;77;E
05/01/2014;VT;79;411000;99,00;0,00;Pilote Erwan ERWAN                                ;79;E
05/01/2014;VT;79;706BVOI;0,00;99,00;Solo FBVOI                                        ;79;E
01/01/2014;VT;343;411000;159,00;0,00;Pilote Susie SUSIE                                ;343;E
01/01/2014;VT;343;706GNNB;0,00;159,00;Solo FGNNB                                        ;343;E
01/01/2014;VT;459;411000;138,00;0,00;Pilote Thomas THOMAS                              ;459;E
01/01/2014;VT;459;706GIKI;0,00;138,00;Solo FGIKI                                        ;459;E
01/01/2014;VT;461;411000;110,00;0,00;Pilote firstTest4 lastTest4                       ;461;E
01/01/2014;VT;461;706GIKI;0,00;110,00;Solo FGIKI                                        ;461;E
01/01/2014;VT;463;411000;69,00;0,00;Pilote Thomas THOMAS                              ;463;E
01/01/2014;VT;463;706GIKI;0,00;69,00;Solo FGIKI                                        ;463;E
01/01/2014;VT;465;411000;207,00;0,00;Pilote Richard RICHARD                            ;465;E
01/01/2014;VT;465;706GIKI;0,00;207,00;Solo FGIKI                                        ;465;E
02/01/2014;VT;467;411000;345,00;0,00;Pilote Briac BRIAC                                ;467;E
02/01/2014;VT;467;706GIKI;0,00;345,00;Solo FGIKI                                        ;467;E
03/01/2014;VT;469;411000;138,00;0,00;Pilote firstTest5 lastTest5                       ;469;E
03/01/2014;VT;469;706GIKI;0,00;138,00;Solo FGIKI                                        ;469;E
03/01/2014;VT;471;411000;138,00;0,00;Pilote firstTest6 lastTest6                       ;471;E
03/01/2014;VT;471;706GIKI;0,00;138,00;Solo FGIKI                                        ;471;E
05/01/2014;VT;473;411000;110,00;0,00;Pilote tom TOM                                    ;473;E
05/01/2014;VT;473;706GIKI;0,00;110,00;Solo FGIKI                                        ;473;E