Accounting export template CsvDebitCreditWithCommaDecimal

Revision as of 15:03, 17 February 2017 by Jcheng (Talk | contribs) (Introduction)

Jump to: navigation, search

Introduction

This page describes the generic accounting export template CSVDebitCredit with comma.

It's recommended to not use the following characters in any name/comment/text because they are removed in the export file :

  • &
  • <
  • >
  •  ;

Output file description

  • Decimal separator: ,
  • Encoding charset: UTF-8
  • Field character separator: Tab
  • Fields:
Name Length (in character) Description
Flow number 6 Filled with prepended zeros to match length
Export code
Date Format is YYYYMMDD
Export account 13 Filled with appended spaces to match length
Description 35 Filled with appended spaces to match length
Amount 8 Number 2 digits after the decimal separator and filled with prepended zeros to match length

Example of output file

000067;VT;20140101;411000;Pilote CHRISTIAN CHRISTIAN ;00099,00;
000067;VT;20140101;706BVOI;Solo FBVOI ;;00099,00
000069;VT;20140101;411000;Pilote Éléonore ÉLÉONORE ;00051,00;
000069;VT;20140101;706BVOI;Solo FBVOI ;;00051,00
000071;VT;20140101;411000;Pilote Nadine NADINE ;00051,00;
000071;VT;20140101;706BVOI;Solo FBVOI ;;00051,00
000073;VT;20140102;411000;Pilote Éléonore ÉLÉONORE ;00408,00;
000073;VT;20140102;706BVOI;Solo FBVOI ;;00408,00
000075;VT;20140103;411000;Pilote Christophe LARATTE ;00099,00;
000075;VT;20140103;706BVOI;Solo FBVOI ;;00099,00
000077;VT;20140103;411000;Pilote Marie-France MARIE-FRANCE ;00124,00;
000077;VT;20140103;706BVOI;Solo FBVOI ;;00124,00
000079;VT;20140105;411000;Pilote Erwan ERWAN ;00099,00;
000079;VT;20140105;706BVOI;Solo FBVOI ;;00099,00
000343;VT;20140101;411000;Pilote Susie SUSIE ;00159,00;
000343;VT;20140101;706GNNB;Solo FGNNB ;;00159,00
000459;VT;20140101;411000;Pilote Thomas THOMAS ;00138,00;
000459;VT;20140101;706GIKI;Solo FGIKI ;;00138,00
000461;VT;20140101;411000;Pilote firstTest4 lastTest4 ;00110,00;
000461;VT;20140101;706GIKI;Solo FGIKI ;;00110,00
000463;VT;20140101;411000;Pilote Thomas THOMAS ;00069,00;
000463;VT;20140101;706GIKI;Solo FGIKI ;;00069,00
000465;VT;20140101;411000;Pilote Richard RICHARD ;00207,00;
000465;VT;20140101;706GIKI;Solo FGIKI ;;00207,00
000467;VT;20140102;411000;Pilote Briac BRIAC ;00345,00;
000467;VT;20140102;706GIKI;Solo FGIKI ;;00345,00
000469;VT;20140103;411000;Pilote firstTest5 lastTest5 ;00138,00;
000469;VT;20140103;706GIKI;Solo FGIKI ;;00138,00
000471;VT;20140103;411000;Pilote firstTest6 lastTest6 ;00138,00;
000471;VT;20140103;706GIKI;Solo FGIKI ;;00138,00
000473;VT;20140105;411000;Pilote tom TOM ;00110,00;
000473;VT;20140105;706GIKI;Solo FGIKI ;;00110,00