SIE4 to Excel

From March 2024 the tool is owned, maintained and supported by FinancialTemplateStore.com, hence this page is to consider advertising for them. You can access their store by clicking on the button on the right hand side or click here.

This is a solution to convert a SIE file into a structured Excel file. If you instead want to create a SIE file from an Excel file, check out this page instead.

I have developed an Excel VBA macro to convert SIE4 files into structured Excel files. The macro offers you a very simple way to import and convert SIE4 files (text file including accounting entries/transactions) into structured Excel files. The tool works in Excel for Windows and Excel for Mac.

The macro will create four sheets:

  1. A sheet showing accounts by account class as rows and the financial year’s months as columns (refer to the image below for an example). There is a section for year-to-date values as well as month-to-date values.
  2. A sheet presenting all transactions (#TRANS, #RTRANS and #BTRANS) included in the SIE file.
    1. On this sheet there is a button (“Audit tests”) which when clicked opens a pop-up userform which let you run common audit tests on the transactions, e.g. select a random sample, search for missing sequential journal entry numbers, verify that all journal entries balance, find transaction with largest amounts and search for postings made on a weekend. The audit test findings will be shown on a new sheet (“Findings”).
  3. A sheet with all dimensions (#DIM) specified in the SIE file. If no dimensions (#DIM) are declared in the SIE fle, this sheet will not be added.
  4. A sheet with all objects (#OBJEKT) specified in the SIE file. If no objects (#OBJEKT) are declared in the SIE fle, this sheet will not be added.

Screenshots

What is SIE?

SIE, or the Swedish standard for accounting information, is a widely used file format in Sweden for financial accounting information. It was developed by the SIE-Group (www.SIE.se) to provide a common structure for financial information, enabling compatibility and ease of data transfer between different accounting software programs. The SIE format is used for bookkeeping and financial reporting purposes and has become an industry standard in Sweden for financial data management. By providing a standardized format for financial information, SIE helps to streamline financial processes and ensures consistent, accurate reporting of financial data. The use of SIE helps to minimize errors and reduces the risk of data loss or corruption, making it a valuable tool for businesses and organizations of all sizes.