SIE4 file

About this article

The SIE4 module exports data for bookkeeping softwares to import. SIE format is mostly used by Swedish bookkeeping companies, which is why this module is written in Swenglish.

How it works

First make sure the module is activated. To do so go to 'MODULES' in the bottom menu bar and click 'SIE4v2'. If you don’t have it yet, please reach out to Centra support to activate the module for you. Once activated you need to make sure your user privileges are set to have access to the added module under 'SYSTEM' > 'USERS'

“Account” in this module refers to a bookkeeping account, not a Centra account.

How to set up the SIE4 template

  1. Go to 'MODULES' in the bottom menu bar and click 'SIE4v2'
  2. Click '+FILE' to generate a new template
  3. Fill in the fields:
    Status: Set the status to ‘Acvtie’ (green)
    Name: Name the file something suitable like “Dagsavslut”
    Store: Select the correctStore you want the sales figures to be extracted from
    Verifikationsserie: To structure your accounting, you can take advantage of different verification series for different type of accounting transactions. Add your Verification serie code/identifier here
    Verificationstext: Add your verification name/description here
    Header: Type in the header that needs to be in the file for your bookkeeping system to accept it
    Transaction Header: Type in your chosen “Kostnadsställe”

    Header, Verifikationsserie, Verifikationstext and Transaction Header fields are directly injected into the file and what they contain will depend on the bookkeeping software this file will be imported into.

    Divide accounts region: Here you select how your sales/discount/shipping accounts should be divided ‘Sweden separate + EU members combined + WorldWide combined’ or ‘EU members separately + WorldWide combined’

    Accounts Region Division

    We allow you to divide your sales up in a few different ways, based on where the order was shipped and what tax applied to it.

    • SE separate + EU members combined + WW combined
      • Will require setup of one account for Sweden, one combined account for all countries in EU, and one combined account for the rest of the world
    • EU Members separately + WW combined
      • Will require setup of one account per country that is in the EU and one for Worldwide

    Divide accounts tax: Here you select if you want either to ‘Do not divide tax’, ‘One account per tax percentage’ or ‘One account per region, per applicable tax percentage’.

    Tax Division

    • Do not divide tax
      • No extra divisions due to tax, also disables the tax dataset. If selected, all sales/discount/shipping prices reported will be including tax
    • One account per tax percentage
      • Divides sales/discount/shipping further to have one additional account per tax % available in that region
      • makes sales/discount/shipping excluding tax and adds a tax dataset for taxes, ignores region for tax and just has one account per tax percent.
    • One Account per region, per applicable tax percentage
      • Divides sales/discount/shipping further to have one additional account per tax % available in that region
      • Adds the tax account, makes sales/shipping/discount ex tax and has one tax account per region, per tax percent.

    Per 1st of July 2021 the new EU tax regulations want you to select: Divide accounts region - ‘EU members separately + WorldWide combined’.

    Auto Export: Here you can select if you want the report to be auto generated and how often Send Auto Export as Email: Here you can add the email address the file should be sent to when it’s auto generated

  4. Click 'SAVE'
  5. Now a list of all the accounts (KONTON) are shown. Click 'EDIT' to fill in which account each asset/type should be booked against
  6. Tick in 'Sum' if you want the transaction rows to be summarized in the file. We advise you to use this if you have a lot of transactions since some bookkeeping systems won’t accept very big files
  7. Click 'SAVE' when your done filling out the template

You can always export a test file by clicking 'TEST EXPORT FILE' to check how your file looks. It could look something like this:

A big part of bookkeeping is that everything needs to be balanced, so the values of this file should always equal 0. Payments balance with sales + shipping + tax - discount, and Stock balances with Item Cost and Rounding takes care of any discrepancy due to rounding errors. This module allows you to define templates which decide how the order and return data is divided on the different datasets that we export.

Datasets

Payment

  • One account for each payment plugin for the selected store
  • Contains a sum of all orders paid with this method
  • Orders treated as debit, return as credit

Sales

  • Summarizes original price of all items in the order
  • One account per division settings
  • Contains a sum of all orders shipped to this region (if we segregate on tax each item that matches this tax %)
  • Orders treated as credit and returns as debit

Discount

  • Summarizes the difference between original price and sale price, otherwise identical to how Sales work

Shipping

  • Summarizes the shipping costs of the order, otherwise identical to how Sales work

Tax

  • One account per tax division setting
  • Contains the sum of all tax in this tax percent
  • Orders treated as credit returns as debit

Stock

  • Always just one account
  • Summarizes the purchase price (cost) for each sold item
  • Orders treated as credit, refunds as debit

Item Cost

  • Always just one account
  • Summarizes the purchase price (cost) for each sold item
  • Orders treated as credit, refunds as debit

Rounding

  • A SIE file has to sum up to 0, so this value will contain the difference between payments and sales/discount/shipping and tax