How to set the correct file format for Elkjöp

This guide shows you how to set the correct file format for Elkjöp POS reports for upload to effectmanager.

The POS files from Elkjöp contain Sales data on a weekly level. The sales data for weekly POS reports are stored on Sundays.

Accepted file format: .xlsx
Accepted number format: 1.000,00
VAT: Excluding VAT.
Denmark: The VAT is added to the cube 25%.
Sweden: The VAT is added to the cube 25%.
Norway: The VAT is added to the cube 25%.
Finland: The VAT is added to the cube 24%.
Accepted date format: YYYY-MM eg. 2021-01

🔴OBS! Elkjöp POS upload is located under Sweden, but POS data for each country will be placed under their own country code in the cube.

Sales data for the Faroe Island is stored under the Danish country code.

If you need a guide that shows you how to upload POS data for Elkjöp, please see our guide How to upload POS reports for Elkjöp

Elkjöp POS reports for effectmanager

The file format for Elkjöp POS reports is Excel.xlsx files. The reports must contain the following headers in the file in the order given below.
POS data for the Faroe Island is stored under Denmark.

NB! If you need to know what data is read into the cube, please see our printer download.

🔴OBS! Due to an agreed internal rule, POS data with zero sales in both volumes and turnover will not be read into the cube.

Column A: Month Desc
Column B: Week
Column C: Country
Column D: Operational Chain
Column E: Store Code SAP
Column F: Store
Column G: Category
Column H: CG Name
Column I: CGM Name
Column J: Brand
Column K: Supplier Group Code
Column L: Article Code
Column M: Article
Column N: Item Code Manufacturer
Column O: GTIN Primary
Column P: Qty Sold
Column Q: Revenue excl. VAT incl Commision
Column R: Local Currency