The universal CSV text format designated for the exchange of table data. The file in the CSV format is comprised of lines in which the individual items are separated by a semi-colon ;. Thanks to the simplicity and readability of the information even without a specialized software, this format is used for the exchange among various systems. Such exported data may be easily used as a source for other accounting systems, or be easily imported into a table processor for further processing.
Structure of exported CSV file
The file comprises of lines which represent individual invoices, and values separated by semi-colons, which represent invoice items.
The first seven fields are always the values relating to an issued invoice:
Field 1 - SS
Field 2 - VS
Field 3 - Issue date
Field 4 - Due date
Field 5 - Taxable fulfilment date
Field 6 - Rounding
Field 7 - Price incl. VAT
Then there are four fields which describe one invoice item. These repeat according to the number of items on the invoice:
Field 8 - Service type
Field 9 - Description
Field 10 - Price excl. VAT
Field 11 - VAT
Data example
SS;VS;Issue date;Due date;Taxable fullfilment date;Rounding;Price incl.VAT;Service type; Description; Price excl.VAT;VAT;
56159;11252;1.7.2010;21.7.2010;1.7.2010;0.00;100,00;7;Service ii for 07/10 ;84.03;15.97;
56159;11253;1.7.2010;21.7.2010;1.7.2010;0.00;595,00;6;Hosting;500.00;95.00;
20011111001;11249;1.7.2010;21.7.2010;1.7.2010;0.06;14,00;1;Internet BASIC for 07/10 ;11.71;2.23;
090124;11244;1.7.2010;21.7.2010;1.7.2010;0.00;660,00;2;Cable TV TAR1 for 07-09/10 ;554.62;105.38;
1420;11236;1.7.2010;21.7.2010;1.7.2010;-0.26;2 154,00;1;Internet for 07/10 ;27.88;5.30;1;Internet for 07/10;4.18;0.80;1;
Internet 10Mb for 07/10 ;390.00;74.10;3;DVBC - Promo package;242.86;46.14;3;DVBC–HBO package;209.24;39.76;3;DVBC-Cable TV
aio for 07/10 ;923.53;175.47;99;Postal fee ;12.61;2.39;