Accounting export template CielRimport
Jump to navigation
Jump to search
Introduction
This page described the accounting export template Rimport for Ciel software.
Output file description
- Encoding charset: ISO-8859-15
- 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 DD/MM/YYYY | |
| Export account | 13 | Filled with appended spaces to match length |
| Description | 35 | Filled with appended spaces to match length |
| Amount | Number with 2 digits after the decimal separator | |
| Character C or D | C for credit, D for debit | |
| Character B | ||
| Comments | 50 | Filled with appended spaces to match length |
Example of output file
000067 VT 01/01/2014 411000 Pilote CHRISTIAN CHRISTIAN 99.00 D B 000067 VT 01/01/2014 706BVOI Solo FBVOI 99.00 C B 000069 VT 01/01/2014 411000 Pilote Éléonore ÉLÉONORE 51.00 D B 000069 VT 01/01/2014 706BVOI Solo FBVOI 51.00 C B 000071 VT 01/01/2014 411000 Pilote Nadine NADINE 51.00 D B 000071 VT 01/01/2014 706BVOI Solo FBVOI 51.00 C B 000073 VT 02/01/2014 411000 Pilote Éléonore ÉLÉONORE 408.00 D B 000073 VT 02/01/2014 706BVOI Solo FBVOI 408.00 C B 000075 VT 03/01/2014 411000 Pilote Christophe LARATTE 99.00 D B 000075 VT 03/01/2014 706BVOI Solo FBVOI 99.00 C B 000077 VT 03/01/2014 411000 Pilote Marie-France MARIE-FRANCE 124.00 D B 000077 VT 03/01/2014 706BVOI Solo FBVOI 124.00 C B 000079 VT 05/01/2014 411000 Pilote Erwan ERWAN 99.00 D B 000079 VT 05/01/2014 706BVOI Solo FBVOI 99.00 C B 000343 VT 01/01/2014 411000 Pilote Susie SUSIE 159.00 D B 000343 VT 01/01/2014 706GNNB Solo FGNNB 159.00 C B 000459 VT 01/01/2014 411000 Pilote Thomas THOMAS 138.00 D B 000459 VT 01/01/2014 706GIKI Solo FGIKI 138.00 C B 000461 VT 01/01/2014 411000 Pilote firstTest4 lastTest4 110.00 D B 000461 VT 01/01/2014 706GIKI Solo FGIKI 110.00 C B 000463 VT 01/01/2014 411000 Pilote Thomas THOMAS 69.00 D B 000463 VT 01/01/2014 706GIKI Solo FGIKI 69.00 C B 000465 VT 01/01/2014 411000 Pilote Richard RICHARD 207.00 D B 000465 VT 01/01/2014 706GIKI Solo FGIKI 207.00 C B 000467 VT 02/01/2014 411000 Pilote Briac BRIAC 345.00 D B 000467 VT 02/01/2014 706GIKI Solo FGIKI 345.00 C B 000469 VT 03/01/2014 411000 Pilote firstTest5 lastTest5 138.00 D B 000469 VT 03/01/2014 706GIKI Solo FGIKI 138.00 C B 000471 VT 03/01/2014 411000 Pilote firstTest6 lastTest6 138.00 D B 000471 VT 03/01/2014 706GIKI Solo FGIKI 138.00 C B 000473 VT 05/01/2014 411000 Pilote tom TOM 110.00 D B 000473 VT 05/01/2014 706GIKI Solo FGIKI 110.00 C B