Glossary For Bulk Upload

This glossary explains each column in the kolum imports bulk upload template, ensuring you enter data correctly and avoid upload errors. It is designed for users of all backgrounds so you can confidently prepare your import files.

EORI Number (Mandatory)

What it is: A unique identifier assigned to your importing company for customs purposes within the EU. It helps authorities track imports.

What to enter: Enter your exact EORI number as registered in your kolum account (e.g., DE123456789). If the number does not match your registered company in kolum, the upload will fail.

CN Code (Mandatory)

What it is: The 8-digit Combined Nomenclature (CN) code used for classifying your goods for customs duties and reporting.

What to enter: Enter the full 8-digit CN code (e.g., 72024190). Ensure it precisely matches the goods you are importing according to your customs documentation.

Article Reference Number (Optional)

What it is: The unique identifier for your article as created in kolum.

What to enter: Use the exact article reference identifier as it exists in kolum (e.g., ART-001). Articles must be created in kolum before bulk upload.

Country of Origin (Mandatory)

What it is: The country where the imported goods were manufactured or produced.

What to enter: Always use the two-letter ISO country code (e.g., CN for China, IN for India). Do not write the full country name. Incorrect codes will cause upload failures.

Supplier Identifier (Mandatory)

What it is: The identifier of the supplier from whom you are importing the goods.

What to enter: Use the exact supplier identifier already created in kolum (e.g., SUP-01). If the supplier does not exist in kolum, you need to add it before uploading.

Production Facility Identifier (Optional)

What it is: The identifier for the production facility where the goods were produced, if tracked in your system.

What to enter: Use the exact identifier as created in kolum (e.g., FAC-01). This helps link your imports with emissions and facility tracking.

Applied Customs Procedure (Mandatory)

What it is: A code indicating the customs procedure under which your goods are being imported (e.g., release for free circulation).

What to enter: Enter the customs procedure code (e.g., CP01). If not relevant, leave this cell blank.

Previous Customs Procedure (Optional)

What it is: If the goods were previously under another customs procedure before the current one, indicate that code here.

What to enter: Enter the previous customs procedure code (e.g., CP42). If not applicable, leave blank.

Internal Reference Number (Optional)

What it is: Your own internal identifier or tracking number for this import.

What to enter: Enter a text reference (e.g., INT#001). This is for your internal tracking only.

ATC Number (Optional)

What it is: An Administrative Reference Code for customs tracking, if available.

What to enter: Enter the ATC number (e.g., IMP#123) or leave blank if not used.

Quantity (Mandatory)

What it is: The quantity of goods imported, expressed in tonnes.

What to enter: Enter as a numerical value only (e.g., 25). Do not add text.

Date (Mandatory)

What it is: The date of import for your goods.

What to enter: Use the YYYY-MM-DD format (e.g., 2025-06-30). Do not use other date formats.

Deadline for Submission of Bill of Discharge (Optional)

What it is: If your goods are under inward processing, this is the deadline for submitting the bill of discharge to customs.

What to enter: Use the YYYY-MM-DD format or leave blank.

Globalization Time Start (Optional)

What it is: For inward processing, this indicates when the globalization period for the goods starts.

What to enter: Use the YYYY-MM-DD format or leave blank.

Globalization Time End (Optional)

What it is: The end date of the globalization period for inward processing.

What to enter: Use the YYYY-MM-DD format or leave blank.

Member State of Inward Processing Authorization (Mandatory if inward processing is used, otherwise leave blank)

What it is: The EU Member State code where the inward processing authorization was issued.

What to enter: Use the two-letter ISO country code (e.g., DE for Germany, FR for France). Do not write full country names.

Inward Processing Authorization (Optional)

What it is: The authorization number for inward processing, if applicable.

What to enter: Enter the authorization code (e.g., AUTH-001) or leave blank.

Inward Processing Discharge Bill Waiver (Optional)

What it is: Indicates whether a waiver has been granted for submitting a bill of discharge under inward processing.

What to enter: Enter TRUE if a waiver applies, FALSE if it does not, or leave blank if not relevant.

Customs Value (Optional)

What it is: The customs value of the imported goods in Euros (€).

What to enter: Enter a numeric value only (e.g., 15000). Do not include currency symbols or commas.

Practical Tips for Success

• Ensure mandatory fields are always filled accurately before uploading.

• Use correct two-letter ISO country codes only.

• Verify that suppliers, production facilities, and articles already exist in kolum with the exact identifiers you use.

• Format all dates as YYYY-MM-DD.

• Do not add extra spaces before or after entries.

• Check your data to avoid upload rejections and rework.