Accounting export template Sage
Jump to navigation
Jump to search
Introduction
This page described the accounting export template Sage.
Output file description
- Encoding charset: ISO-8859-15
- Field character separator: Tab
- First line contains client structure name
- Fields:
| Name | Length (in character) | Description |
|---|---|---|
| Export code | ||
| 1 space | ||
| Date | Format is DDMMYY | |
| 2 spaces | ||
| Export account | 13 | Filled with appended spaces to match length |
| 1 space | ||
| 13 spaces | ||
| id | 13 | Filled with appended spaces to match length |
| Description | 25 | Filled with appended spaces to match length |
| 1 space | ||
| 6 spaces | ||
| Character C or D | C for credit, D for debit | |
| Amount | 20 | Number with 20 digits before the decimal separator and 2 digits after |
| Character N | ||
| Flow id | 7 | Filled with prepended zeros to match length |
| 26 spaces |
Example of output file
demo VT 010114 411000 67 Pilote CHRISTIAN CHRISTIA D 99.00N0000067 VT 010114 706BVOI 68 Solo FBVOI C 99.00N0000067 VT 010114 411000 69 Pilote Éléonore ÉLÉONORE D 51.00N0000069 VT 010114 706BVOI 70 Solo FBVOI C 51.00N0000069 VT 010114 411000 71 Pilote Nadine NADINE D 51.00N0000071 VT 010114 706BVOI 72 Solo FBVOI C 51.00N0000071 VT 020114 411000 73 Pilote Éléonore ÉLÉONORE D 408.00N0000073 VT 020114 706BVOI 74 Solo FBVOI C 408.00N0000073 VT 030114 411000 75 Pilote Christophe LARATTE D 99.00N0000075 VT 030114 706BVOI 76 Solo FBVOI C 99.00N0000075 VT 030114 411000 77 Pilote Marie-France MARIE D 124.00N0000077 VT 030114 706BVOI 78 Solo FBVOI C 124.00N0000077 VT 050114 411000 79 Pilote Erwan ERWAN D 99.00N0000079 VT 050114 706BVOI 80 Solo FBVOI C 99.00N0000079 VT 010114 411000 343 Pilote Susie SUSIE D 159.00N0000343 VT 010114 706GNNB 344 Solo FGNNB C 159.00N0000343 VT 010114 411000 459 Pilote Thomas THOMAS D 138.00N0000459 VT 010114 706GIKI 460 Solo FGIKI C 138.00N0000459 VT 010114 411000 461 Pilote firstTest4 lastTes D 110.00N0000461 VT 010114 706GIKI 462 Solo FGIKI C 110.00N0000461 VT 010114 411000 463 Pilote Thomas THOMAS D 69.00N0000463 VT 010114 706GIKI 464 Solo FGIKI C 69.00N0000463 VT 010114 411000 465 Pilote Richard RICHARD D 207.00N0000465 VT 010114 706GIKI 466 Solo FGIKI C 207.00N0000465 VT 020114 411000 467 Pilote Briac BRIAC D 345.00N0000467 VT 020114 706GIKI 468 Solo FGIKI C 345.00N0000467 VT 030114 411000 469 Pilote firstTest5 lastTes D 138.00N0000469 VT 030114 706GIKI 470 Solo FGIKI C 138.00N0000469 VT 030114 411000 471 Pilote firstTest6 lastTes D 138.00N0000471 VT 030114 706GIKI 472 Solo FGIKI C 138.00N0000471 VT 050114 411000 473 Pilote tom TOM D 110.00N0000473 VT 050114 706GIKI 474 Solo FGIKI C 110.00N0000473