| Column | Description |
|---|---|
| Duty type | The duty type ID. |
| Duty type description | The duty type description. |
| Element | Description |
|---|---|
| Duty type | A two-letter code. The duty type is the ID for the duty type, usually the foundation (e.g. product type) of the duty. |
| Duty group | The division into different duty groups within the individual duty type is a division of different rates within the same duty. |
| Duty group description | A description of the Duty group. |
| Unit | The unit of measure for the Duty group, e.g. litre, kg. |
| Calculation rule | Use these alternatives to select the rule to calculate the Excise duty for the Duty type. Alternatives:
Currently, only alcohol uses the Multiple factors calculation rule. Example Factor 1 can be Piece. Conversion factor can be 20 kg/piece. Example Factor 2 can be Volum% (used for selling alcohol). |
| Column name | Description |
|---|---|
| Start date | The date when the duty will start to take effect. |
| Duty rate | The fee rate. |
| Customer class | Customer class for the duty rate (optional). |
| Deduction % | The deduction in per cent. |
| Max. amount | The maximum amount that the tax can calculate. |
| Tax free | This check mark indicates when used that the types of goods are not taxed. |
| Column name | Description |
|---|---|
| Fee additional code | An additional code for the fee. |
| Additional code description | A description of the Fee additional code. |
| Type |
|
| Factor | Factor alternatives:
Note
If you receive returns from a combination of customers, some subject to excise duty and some not subject to excise duty, you must enter return Type 0 and Type -1.
|
| Column | Description |
|---|---|
| Duty type | The duty type ID. |
| Duty type description | The duty type description. |
| Duty group | The duty group ID. |
| Duty group description | The duty group description. |
| Item ID | The ID of the item. |
| Description | The description of the item. |
| Element | Description |
|---|---|
| Excise duty factor | The excise duty factor, which is 0 for sales and returns excluded from excise duty. |
| Period | The month you want to display the sales and returns for. |
| Column | Description |
|---|---|
| Excise duty type | The excise duty type ID. |
| Excise duty type description | The excise duty type description. |
| Excise duty group | The excise duty group ID. |
| Excise duty group description | The excise duty group description. |
| Sum excise duty quantities | The sum of all the item’s quantities that have this type/group combination, expressed in the duty UoM. |
| Excise duty UoM | The duty rate unit of measure used when calculating the duty. |
| Invoice customer location | The customer’s invoiced location ID. |
| Invoice customer location postcode | The postcode for the invoiced customer location. |
| Invoice customer location city | The city for the invoiced customer location. |
| Excise duty factor | The excise duty factor, which is 0 for sales and returns excluded from excise duty. |
| Sale/return | The transaction type of the quantities on the line, which can be one of the following:
|
| Element | Description |
|---|---|
| Excise duty factor | The excise duty factor, which can be one of the following options:
|
| Period | The month you want to display the sales and returns for. |
| Column | Description |
|---|---|
| Excise duty type | The excise duty type ID. |
| Excise duty type description | The excise duty type description. |
| Excise duty group | The excise duty group ID. |
| Excise duty group description | The excise duty group description. |
| Sum excise duty quantities | The sum of all the item’s quantities that have this type/group combination, expressed in the duty UoM. |
| Excise duty UoM | The duty rate unit of measure used when calculating the duty. |
| Sum excise duty amounts | The sum of all the excise duty amounts for this type/group combination. |
| Excise duty factor | The factor indicates whether the excise duty amount is to be paid or to be reimbursed. It can be one of the following options:
|