---
title: "Sales/returns excluding excise duty (EF402000)"
description: "You can use this window to view the information needed when you report excise duty to the tax authorities."
lang: en
languages:
  en: https://docs.vismasoftware.no/visma-net-erp/help/excise-duty/excise-duty-windows/sales-returns-excluding-excise-duty-ef402000/index.md
lastmod: 2026-02-19
---

> Documentation index: https://docs.vismasoftware.no/visma-net-erp/help/excise-duty/excise-duty-windows/llms.txt


# Sales/returns excluding excise duty (EF402000)

Last modified February 19, 2026

> You can use this window to view the information needed when you report excise duty to the tax authorities.


This topic provides information about the elements in this window in Visma Net, such as fields, field values, buttons, and check boxes.

The transactions listed here are from invoiced customer locations that were excluded from excise duty calculation.

## The top part

In this area, you select the period for which you want to display the table.

<table class="vismanet-table">
  <colgroup>
    <col class="vismanet-table__col--key">
    <col>
  </colgroup>
<thead class="vismanet-table__head">
  <tr class="vismanet-table__header-row">
<th class="vismanet-table__cell vismanet-table__cell--header">Element</th>
<th class="vismanet-table__cell vismanet-table__cell--header">Description</th>
</tr>
</thead>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Excise duty factor</td>
<td class="vismanet-table__cell">The excise duty factor, which is <strong>0</strong> for sales and returns excluded from excise duty.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Period</td>
<td class="vismanet-table__cell">The month you want to display the sales and returns for.</td>
</tr>

</table>


## The table

Per transaction type **Sale** or **Return**, each excise duty group and type combination together with each unique customer location ID for the same postcode and city is displayed on one line, and the quantities of all invoiced items belonging to this unique combination are accumulated.

Note that, when an item is connected to several duties, its quantity is reported each time for each duty.

<table class="vismanet-table">
  <colgroup>
    <col class="vismanet-table__col--key">
    <col>
  </colgroup>
<thead class="vismanet-table__head">
  <tr class="vismanet-table__header-row">
<th class="vismanet-table__cell vismanet-table__cell--header">Column</th>
<th class="vismanet-table__cell vismanet-table__cell--header">Description</th>
</tr>
</thead>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Excise duty type</td>
<td class="vismanet-table__cell">The excise duty type ID.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Excise duty type description</td>
<td class="vismanet-table__cell">The excise duty type description.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Excise duty group</td>
<td class="vismanet-table__cell">The excise duty group ID.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Excise duty group description</td>
<td class="vismanet-table__cell">The excise duty group description.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Sum excise duty quantities</td>
<td class="vismanet-table__cell">The sum of all the item&rsquo;s quantities that have this type/group combination, expressed in the duty UoM.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Excise duty UoM</td>
<td class="vismanet-table__cell">The duty rate unit of measure used when calculating the duty.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Invoice customer location</td>
<td class="vismanet-table__cell">The customer&rsquo;s invoiced location ID.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Invoice customer location postcode</td>
<td class="vismanet-table__cell">The postcode for the invoiced customer location.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Invoice customer location city</td>
<td class="vismanet-table__cell">The city for the invoiced customer location.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Excise duty factor</td>
<td class="vismanet-table__cell">The excise duty factor, which is <strong>0</strong> for sales and returns excluded from excise duty.</td>
</tr>

<tr class="vismanet-table__row">
<td class="vismanet-table__cell">Sale/return</td>
<td class="vismanet-table__cell"><p>The transaction type of the quantities on the line, which can be one of the following:</p>
<dl>
<dt>Sale</dt>
<dd>,</dd>
<dt>Return</dt>
<dd>.</dd>
</dl></td>
</tr>

</table>




<h2>Related pages</h2><h3>Concepts</h3>
<ul><li><a href="/visma-net-erp/help/excise-duty/about-excise-duties/index.md">About excise duties</a></li>
</ul><h3>Tasks</h3>
<ul><li><a href="/visma-net-erp/help/excise-duty/enable-and-set-up-excise-duty/index.md">Enable and set up excise duty</a></li><li><a href="/visma-net-erp/help/excise-duty/reverse-an-invoice-with-excise-duty/index.md">Reverse an invoice with excise duty</a></li>
</ul><h3>Windows</h3>
<ul><li><a href="/visma-net-erp/help/excise-duty/excise-duty-windows/duty-types-ef204000/index.md">Duty types (EF204000)</a></li><li><a href="/visma-net-erp/help/excise-duty/excise-duty-windows/duty-groups-ef205000/index.md">Duty groups (EF205000)</a></li><li><a href="/visma-net-erp/help/excise-duty/excise-duty-windows/duty-items-ef208000/index.md">Duty items (EF208000)</a></li><li><a href="/visma-net-erp/help/excise-duty/excise-duty-windows/sales-returns-including-excise-duty-ef402000/index.md">Sales/returns including excise duty (EF402000)</a></li>
</ul>


---

[View this page](https://docs.vismasoftware.no/visma-net-erp/help/excise-duty/excise-duty-windows/sales-returns-excluding-excise-duty-ef402000/)