Simple solution for Excel tables
New data converter for customs declarations from Dakosy
When mapping customs processes, there is an increasing need for companies to transfer existing Excel or CSV data into customs applications and thus avoid double entries. The Hamburg-based software company Dakosy has responded to this market demand and has now created a web-based, platform-independent conversion tool with "Drag&Map Customs".
"Our new digital solution enables freight forwarders, logistics companies, retailers and industrial companies to independently and flexibly generate any customs declaration based on an Excel or CSV file in a matter of minutes," says Simon Lembke, Head of Customs and Forwarding Applications at Dakosy, outlining the product. Initial test runs with users show that they achieve production increases of 20 to 25 percent. In addition to the time savings, pilot customers report a significant improvement in the "perfect order rate", as the high data quality means that customs-related delays can be significantly reduced.
In "Drag&Map Customs", the user uploads their shipment data for the customs declaration in Excel or CSV format. They simply drag and drop the table into the Internet browser. There they select which columns are relevant (e.g. for the export declaration, transit declaration) and fill in the corresponding customs fields such as goods tariff number, goods value or gross mass. The process is completed in a matter of minutes at the click of a mouse.
Efficiency can be further increased through the individual creation of templates for identically structured order data or customer situations, as well as the option to include master data from the customs software. The entries are then automatically validated in the ZODIAK GE customs software, in which the customs applications created can also be supplemented and corrected with additional information.
Dakosy identified the need through an intensive exchange with the industry. Lembke reports: "In our experience, order-related data is often sent in the form of Excel files in freight forwarding practice, which vary from customer to customer and sometimes even from order to order. Hard-coded solutions do not help, as they cannot react flexibly to changes in columns and content."
The trend towards increasing demand for converting Excel and CSV files into customs declarations may seem surprising at first glance, as there are much newer file formats such as JSON or standardized XML interfaces for transferring data. However, practice shows that Excel and CSV data are often still the most common formats in day-to-day business.










