SIE file parser

This action parses a Standard Import Export (SIE) file and returns an object with information and collections that can be used by other actions. Use this action to extract opening/closing balances, transactions, vouchers etc. from a SIE file.

The Swedish SIE (Standard Import and Export) file format is an open, text-based standard for transferring accounting data between different software systems in Sweden, acting as a de facto standard for companies, accountants, and auditors to exchange financial information like balances, transactions, and account details, with different types (SIE 1, 2, 3, 4) for varying data levels.

Example

The example above shows how a SIE file is read from the Fortnox REST API and parsed with the SIE file parser. From the parsed result object, a SIE DataReader action is then used to extract values that are inserted into an SQL Server table.

Properties

Name	Type	Description
Title	Optional	The title or name of the action.
Source	Required	A stream containing SIE file content.
Parser options	Optional	Optional settings about source file and parsing settings (see below).
Result variable name	Required	The name of the variable that contains the output from this action.
Description	Optional	Additional notes or comments about the action.

Parser options

Name	Description
Allow Missing Date	Allows missing dates in e.g. transactions.
Allow Unbalanced Voucher	Allows incomplete / unbalanced vouchers.
Throw Errors	Specifies whether parsing should throw errors or complete silently.
Encoding	Select the source encoding format (default: ISO-8859-1).
Date Format	Enter the source date format (default: yyyyMMdd).

Result

This action returns an SIEResultObject.

Object properties

Property	SIE tag	Type	Description
Format	#FORMAT	string	SIE file format version.
GeneratedDate	#GEN	DateTime	Date when the SIE file was generated.
GeneratedName	#GEN	string	Name of the user who generated the SIE file (signature).
Description	#PROSA	string	Description of the SIE file content.
ChartOfAccountType	#KPTYP	string	Type of chart of accounts.
PeriodToDate	#OMFATTN	DateTime	Date for period of period end balance (date up to and including).
TaxationYear	#TAXAR	Integer	Tax year for the exported data.
Currency	#VALUTA	string	Currency code for the exported data.
Company	#FNAMN	SieCompany	Company the data originates from.

Object collections