Customs Excise Data

Excise Duty Management  •  Article  •  4/29/2023  •  4 min

There are several basic principles in customs clearance which are very important to ensure that everything runs smoothly. We must consider these principles while setting up and defining the right structure. Hence, it is necessary to set up the master data to support the handling of goods within the customs process.

Tariff Type: This entity defines the different Excise types that are applicable and the type of products which are covered with the excise module. In this entity you can categorize the item assortment into certain groups. An item is assigned to one tariff type. Wine, Beer, Cigarettes etc. are examples. The tariff type is also used to define checks, these checks can be used to check what Tariff Components are mandatory and optional, so the completeness of the data can be checked.

Tariff Components: This entity defines the type of excise covered with the excise module.You can define what kind of customs tariff components are possible. These tariff components can be assigned to a tariff type and it's also possible to assign the tariff component on a Tariff Group.

Tariff Type Component: This is a combination of Tariff type and Tariff components. With this relation, you can define that different products have different kinds of excise, if applicable.

Tariff Group: An item can have multiple Tariff Groups. You can define different groups under which items can be divided. These tariff groups are used to define all possible customs regulations. The tariff group is the base to calculate the excise amounts and quantities. It’s an important entity because it divides items into certain groups and group items with the same calculation base. At the tariff group level, checks can be defined with excise as the items can be divided into groups with similar characteristics. For example, beer items can exist in of 3 or 4 similar groups based on the alcohol percentage. An item can be assigned to multiple Tariff Groups.

Calculation Code: In this entity, you can only define a code and a description. With the help of this, you can calculate the required customs excise data, such as customs amount, customs quantity, customs quantity 100% etc. The calculation is defined in an underlying structure.

Calculation Lines: Calculation Lines entity defines how the calculation is executed using various values (operand A) and combining these with other values (operand B). It is possible to create formulas to calculate all kinds of values. For example, you can calculate the customs volume, customs quantity, customs quantity 100% and excise amount. As input for these formulas, data such as item beverage (volume percentage, content), excise calculation (tariff, tariff factor) and transaction data (trade quantity, trade amount) can be used.

Scale Code: This is a scale definition in the calculation formulas for certain components to deduce the calculation value.

Tariff Code: With this entity, you can define the generally used tariffs with a code and description.

Excise Version: You can use the excise version to organize the customs regulation for a certain period. In an excise version, you can manage the start and end date of the customs regulation and the status of the customs regulation. Tariff groups can be assigned to a particular excise version, this is possible in the entity Tariff Group Version.

Tariff Group Version: With this entity, you can define for what period a certain tariff group is valid. Under the tariff group version, the calculation of the excise can be defined. It is the basis for defining the calculation of excise amount and excise quantities. Calculation of excise and tariffs can vary depending on the country level and at this level, you can define a tariff group.

Excise Calculation: This is the combination of the Tariff Code, Calculation Code and Tariff for the Tariff Group Version. Under the tariff group version, the Excise Calculation can be defined. On this level, multiple calculation lines can be defined per tariff group version, where each calculation line has its own Calculation Formula and Tariff. The result of the calculation line is a single excise (sub) amount. If an excise amount exists out of different calculation rules and tariffs, multiple calculation lines must be defined.

For the customs process around excise, it is necessary to set up master data to support the handling of goods within the customs process.