Accounting export template SageCoala
Jump to navigation
Jump to 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