CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

WG: Fiskalverzollung DUS525003875_KT35169+KT35275_997495/ ETA 26.10.

Verwerkt: 28-11-2025 15:20:31

Voltooid
Uitvoering ID: csv_6929afaf46007
Agent: Oscar

📊 Geëxtraheerde Ordergegevens

Kleurcodering: Groen = Zeker (>80%), Geel = Mogelijk (>50%), Rood = Onzeker (<50%)

0%

No template code was specified in the provided documents

100%

Total number of cartons stated in Bill of Lading and confirmed across all documents

100%

Total gross weight from Bill of Lading matches sum of both invoices (3892.99 + 307.11 = 4200.10 kg)

100%

Sum of net weights from both invoices: KT35275 (2455.30 kg) + KT35169 (212.15 kg)

100%

Sum of both invoice amounts: $18,129.52 (JRH2050625) + $5,175.84 (JRH2300606)

100%

All invoices denominated in US Dollars

0%

No representative code explicitly mentioned in documents

90%

MBS Logistics is handling customs clearance as stated in both clearance orders and email

100%

EORI number for HOME PRODUCT IMPORT GMBH stated in Bill of Lading and clearance orders

100%

Consignee on Bill of Lading and buyer on invoices

100%

Address from clearance orders and invoices

100%

Germany - stated as destination country across all documents

100%

Postcode from clearance orders

100%

City from clearance orders and invoices

0%

EORI number for MBS Logistics not provided in documents

100%

Named as customs representative in email and clearance orders

100%

Address from Bill of Lading consignee section

100%

Germany - from Bill of Lading

100%

Postcode from Bill of Lading

100%

City from Bill of Lading (Köln/Cologne)

0%

No identification number provided for exporter

100%

Exporter name from Certificate of Origin

100%

Address from Certificate of Origin

100%

China - stated in Certificate of Origin

0%

No postcode provided in Certificate of Origin

100%

City and province from Certificate of Origin

0%

No identification number provided for seller

100%

Seller name from commercial invoices

100%

Address from invoices

100%

Kwai Chung, N.T., HK, China from invoices

0%

No postcode provided in invoices

100%

City from invoices

100%

EORI number for HOME PRODUCT IMPORT GMBH

100%

Buyer name from invoices

100%

Address from invoices

100%

Germany from invoices

100%

Postcode from invoices

100%

City from invoices

95%

FOB Yantian stated in email and FOB Shenzhen in invoices

100%

All invoices denominated in US Dollars

100%

Sum of both invoice totals: $18,129.52 + $5,175.84

100%

Germany - destination stated across all documents

100%

China - Port of loading Yantian, China from Bill of Lading

100%

Total gross weight from Bill of Lading

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": "",
            "reasoning": "No template code was specified in the provided documents",
            "certainty": 0
        },
        "control": {
            "packages": {
                "value": 1386,
                "reasoning": "Total number of cartons stated in Bill of Lading and confirmed across all documents",
                "certainty": 100
            },
            "grossmass": {
                "value": 4200.1,
                "reasoning": "Total gross weight from Bill of Lading matches sum of both invoices (3892.99 + 307.11 = 4200.10 kg)",
                "certainty": 100
            },
            "netmass": {
                "value": 2667.45,
                "reasoning": "Sum of net weights from both invoices: KT35275 (2455.30 kg) + KT35169 (212.15 kg)",
                "certainty": 100
            },
            "commodityValue": {
                "value": {
                    "value": 23305.36,
                    "reasoning": "Sum of both invoice amounts: $18,129.52 (JRH2050625) + $5,175.84 (JRH2300606)",
                    "certainty": 100
                },
                "currency": {
                    "value": "USD",
                    "reasoning": "All invoices denominated in US Dollars",
                    "certainty": 100
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": "",
                "reasoning": "No representative code explicitly mentioned in documents",
                "certainty": 0
            },
            "representativeName": {
                "value": "MBS Logistics GmbH",
                "reasoning": "MBS Logistics is handling customs clearance as stated in both clearance orders and email",
                "certainty": 90
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "DE4562526",
                "reasoning": "EORI number for HOME PRODUCT IMPORT GMBH stated in Bill of Lading and clearance orders",
                "certainty": 100
            },
            "name": {
                "value": "HOME PRODUCT IMPORT GMBH",
                "reasoning": "Consignee on Bill of Lading and buyer on invoices",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Graf-Zeppelin-Str. 5",
                    "reasoning": "Address from clearance orders and invoices",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany - stated as destination country across all documents",
                    "certainty": 100
                },
                "postcode": {
                    "value": "46149",
                    "reasoning": "Postcode from clearance orders",
                    "certainty": 100
                },
                "city": {
                    "value": "Oberhausen",
                    "reasoning": "City from clearance orders and invoices",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": "",
                "reasoning": "EORI number for MBS Logistics not provided in documents",
                "certainty": 0
            },
            "name": {
                "value": "MBS LOGISTICS GMBH",
                "reasoning": "Named as customs representative in email and clearance orders",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Hansestrasse 57",
                    "reasoning": "Address from Bill of Lading consignee section",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany - from Bill of Lading",
                    "certainty": 100
                },
                "postcode": {
                    "value": "51149",
                    "reasoning": "Postcode from Bill of Lading",
                    "certainty": 100
                },
                "city": {
                    "value": "Köln",
                    "reasoning": "City from Bill of Lading (Köln/Cologne)",
                    "certainty": 100
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "HKGFD3510500",
                        "reasoning": "Master Bill of Lading number from email and Bill of Lading",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "ONEYHKGFD3510500",
                        "reasoning": "Sea Waybill number from Bill of Lading",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "MSZOE2509192",
                        "reasoning": "Bill of Lading number referenced in clearance orders",
                        "certainty": 100
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": [
                {
                    "referenceNumber": {
                        "value": "JRH2050625",
                        "reasoning": "Invoice number for KT35275 order",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "JRH2300606",
                        "reasoning": "Invoice number for KT35169 order",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "C253040051770001",
                        "reasoning": "Certificate of Origin number referenced in both clearance orders",
                        "certainty": 100
                    }
                }
            ]
        },
        "exporter": {
            "identificationNumber": {
                "value": "",
                "reasoning": "No identification number provided for exporter",
                "certainty": 0
            },
            "name": {
                "value": "ZHONGSHAN DASHER LIGHTING TECHNOLOGY CO., LTD",
                "reasoning": "Exporter name from Certificate of Origin",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "No.9-1, Fuqing 2 Road, Yongxing Industrial Area, Henglan Town",
                    "reasoning": "Address from Certificate of Origin",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "China - stated in Certificate of Origin",
                    "certainty": 100
                },
                "postcode": {
                    "value": "",
                    "reasoning": "No postcode provided in Certificate of Origin",
                    "certainty": 0
                },
                "city": {
                    "value": "Zhongshan City, Guangdong Province",
                    "reasoning": "City and province from Certificate of Origin",
                    "certainty": 100
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": "",
                "reasoning": "No identification number provided for seller",
                "certainty": 0
            },
            "name": {
                "value": "J&R ELECTRONICS (H.K.) CO., LTD",
                "reasoning": "Seller name from commercial invoices",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "RM 706, 7/F., Seapower Centre, 73-77 Lemuk Road",
                    "reasoning": "Address from invoices",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "Kwai Chung, N.T., HK, China from invoices",
                    "certainty": 100
                },
                "postcode": {
                    "value": "",
                    "reasoning": "No postcode provided in invoices",
                    "certainty": 0
                },
                "city": {
                    "value": "Kwai Chung",
                    "reasoning": "City from invoices",
                    "certainty": 100
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "DE4562526",
                "reasoning": "EORI number for HOME PRODUCT IMPORT GMBH",
                "certainty": 100
            },
            "name": {
                "value": "HOME PRODUCT IMPORT GMBH",
                "reasoning": "Buyer name from invoices",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Graf-Zeppelin-Str. 5",
                    "reasoning": "Address from invoices",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany from invoices",
                    "certainty": 100
                },
                "postcode": {
                    "value": "46149",
                    "reasoning": "Postcode from invoices",
                    "certainty": 100
                },
                "city": {
                    "value": "Oberhausen",
                    "reasoning": "City from invoices",
                    "certainty": 100
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "FOB",
                "reasoning": "FOB Yantian stated in email and FOB Shenzhen in invoices",
                "certainty": 95
            }
        },
        "invoiceCurrency": {
            "value": "USD",
            "reasoning": "All invoices denominated in US Dollars",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": 23305.36,
            "reasoning": "Sum of both invoice totals: $18,129.52 + $5,175.84",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "DE",
            "reasoning": "Germany - destination stated across all documents",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "CN",
            "reasoning": "China - Port of loading Yantian, China from Bill of Lading",
            "certainty": 100
        },
        "grossMass": {
            "value": 4200.1,
            "reasoning": "Total gross weight from Bill of Lading",
            "certainty": 100
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "BMOU4915790",
                    "reasoning": "Container number stated throughout all documents",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 1911,
                    "reasoning": "Invoice amount for item DD-MA-280 (180.004414) from invoice JRH2050625",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "China stated in Certificate of Origin",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 195,
                    "reasoning": "Quantity in pieces for item DD-MA-280 (180.004414)",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 409.5,
                    "reasoning": "Gross weight from packing list for item DD-MA-280 (180.004414)",
                    "certainty": 100
                },
                "netMass": {
                    "value": 292.5,
                    "reasoning": "Net weight from invoice for item DD-MA-280 (180.004414)",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Pendant lamp",
                    "reasoning": "Description from invoice item DD-MA-280",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 195,
                        "reasoning": "Number of cartons for this item from packing list",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated in packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9405199090",
                        "reasoning": "HS code 9405 1990 900 stated in clearance order for pendant lamps from metal",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "BMOU4915790",
                    "reasoning": "Same container for all goods",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 1566,
                    "reasoning": "Invoice amount for item DD-MA-280 (180.004415) from invoice JRH2050625",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "China stated in Certificate of Origin",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 116,
                    "reasoning": "Quantity in pieces for item DD-MA-280 (180.004415)",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 406,
                    "reasoning": "Gross weight from packing list for item DD-MA-280 (180.004415)",
                    "certainty": 100
                },
                "netMass": {
                    "value": 232,
                    "reasoning": "Net weight from invoice for item DD-MA-280 (180.004415)",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Pendant lamp",
                    "reasoning": "Description from invoice item DD-MA-280",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 116,
                        "reasoning": "Number of cartons for this item from packing list",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated in packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9405199090",
                        "reasoning": "Same HS code category as other pendant lamps",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "BMOU4915790",
                    "reasoning": "Same container for all goods",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 6582.4,
                    "reasoning": "Invoice amount for item DD-MA-0068-3L from invoice JRH2050625",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "China stated in Certificate of Origin",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 272,
                    "reasoning": "Quantity in pieces for item DD-MA-0068-3L",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 1361.09,
                    "reasoning": "Gross weight from packing list for item DD-MA-0068-3L",
                    "certainty": 100
                },
                "netMass": {
                    "value": 761.6,
                    "reasoning": "Net weight from invoice for item DD-MA-0068-3L",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Pendant lamp",
                    "reasoning": "Description from invoice item DD-MA-0068-3L",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 272,
                        "reasoning": "Number of cartons for this item from packing list",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated in packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9405199090",
                        "reasoning": "Same HS code category as other pendant lamps",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "BMOU4915790",
                    "reasoning": "Same container for all goods",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 3494.82,
                    "reasoning": "Invoice amount for item DD-MA-0068/0280 from invoice JRH2050625",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "China stated in Certificate of Origin",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 314,
                    "reasoning": "Quantity in pieces for item DD-MA-0068/0280",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 659.4,
                    "reasoning": "Gross weight from packing list for item DD-MA-0068/0280",
                    "certainty": 100
                },
                "netMass": {
                    "value": 565.2,
                    "reasoning": "Net weight from invoice for item DD-MA-0068/0280",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Pendant lamp",
                    "reasoning": "Description from invoice item DD-MA-0068/0280",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 314,
                        "reasoning": "Number of cartons for this item from packing list",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated in packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9405199090",
                        "reasoning": "Same HS code category as other pendant lamps",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "BMOU4915790",
                    "reasoning": "Same container for all goods",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 4575.3,
                    "reasoning": "Invoice amount for item DD-MA-0068/0350 from invoice JRH2050625",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "China stated in Certificate of Origin",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 302,
                    "reasoning": "Quantity in pieces for item DD-MA-0068/0350",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 1057,
                    "reasoning": "Gross weight from packing list for item DD-MA-0068/0350",
                    "certainty": 100
                },
                "netMass": {
                    "value": 604,
                    "reasoning": "Net weight from invoice for item DD-MA-0068/0350",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Pendant lamp",
                    "reasoning": "Description from invoice item DD-MA-0068/0350",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 302,
                        "reasoning": "Number of cartons for this item from packing list",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated in packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9405199090",
                        "reasoning": "Same HS code category as other pendant lamps",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "BMOU4915790",
                    "reasoning": "Same container for all goods",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 2987.04,
                    "reasoning": "Invoice amount for item DL0506-001 from invoice JRH2300606",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "China stated in Certificate of Origin",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 3048,
                    "reasoning": "Quantity in pieces for item DL0506-001",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 118.11,
                    "reasoning": "Gross weight from packing list for item DL0506-001",
                    "certainty": 100
                },
                "netMass": {
                    "value": 82.55,
                    "reasoning": "Net weight from invoice for item DL0506-001",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "LED CANDLE LAMP",
                    "reasoning": "Description from invoice item DL0506-001",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 127,
                        "reasoning": "Number of cartons for this item from packing list",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated in packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9405494000",
                        "reasoning": "HS code 9405 4940 000 for LED tea lights from plastic stated in clearance order KT35169",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "BMOU4915790",
                    "reasoning": "Same container for all goods",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 2188.8,
                    "reasoning": "Invoice amount for item DL0506-002 from invoice JRH2300606",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "China stated in Certificate of Origin",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 1440,
                    "reasoning": "Quantity in pieces for item DL0506-002",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 189,
                    "reasoning": "Gross weight from packing list for item DL0506-002",
                    "certainty": 100
                },
                "netMass": {
                    "value": 129.6,
                    "reasoning": "Net weight from invoice for item DL0506-002",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "RGB LED CANDLE LAMP",
                    "reasoning": "Description from invoice item DL0506-002",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 60,
                        "reasoning": "Number of cartons for this item from packing list",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated in packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9405494000",
                        "reasoning": "Same HS code as other LED candle lamps",
                        "certainty": 95
                    }
                }
            }
        ]
    }
}