--- title: "Duty Settlement, Reimbursement, and Reporting" slug: "duty-settlement-reimbursement-and-reporting" description: "Streamline your duty management with tools for duty settlement, reimbursement, and reporting, ensuring compliance and accurate financial tracking." updated: 2026-05-01T09:09:55Z published: 2026-05-01T09:11:29Z canonical: "docs.abakion.com/duty-settlement-reimbursement-and-reporting" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.abakion.com/llms.txt > Use this file to discover all available pages before exploring further. # Duty Settlement, Reimbursement, and Reporting ## Feature Overview Once duty entries are created by the system during normal item transactions, the periodic closing activities begin. The Duty Reporting app provides three distinct tools for this: **Create Duty Settlement** (for paying duty to the authority), **Create Duty Reimbursement** (for reclaiming duty on duty-free sales), and the **Duty Reporting** report (for generating the statutory duty declaration). A fourth tool, **Rolled-up Duty**, is used to keep the duty content of finished goods up to date when their Bill of Materials components carry duty. **Create Duty Settlement** is the primary periodic process. It scans all open, unsettled Imposition entries and creates Settlement entries against them. Optionally, it can also generate item charge lines on an existing purchase invoice, ready to be posted to the general ledger. The item charge lines use the Item Charge No. defined on the Duty Code and are linked to the original receipts or shipments via item charge assignments, giving full traceability from the GL posting back to the item transaction. **Create Duty Reimbursement** follows the same pattern but works on open Reimbursement entries — those created automatically when duty-subject items were sold to duty-free customers. It generates item charge lines on a purchase credit memo, which when posted reduces the company's net duty liability. The **Duty Reporting** report produces a summary per duty code and item showing purchase, sales, consumption, output, and adjustment quantities with their duty values. Sales are broken down by whether the customer had an exemption and by domestic/foreign — columns that correspond to the typical structure of an excise duty declaration. **Key Facts** | Topic | Detail | | --- | --- | | Settlement batch | Create Duty Settlement (from Duties page or search) | | Reimbursement batch | Create Duty Reimbursement (from Duties page or search) | | Settlement document | Purchase Invoice — item charge lines added to an existing open invoice | | Reimbursement document | Purchase Credit Memo — item charge lines added to an existing open credit memo | | Item Charge No. required | Must be set on the Duty Code before settlement/reimbursement lines can be created | | Settlement filters | Duty Code filter and posting date range filter available | | Shipment on Invoice setting | Sales & Receivables Setup must have Shipment on Invoice = off for reimbursement to work (sales must be posted as shipments, not invoices) | | Rolled-up Duty | Batch report that updates Qty. per Item Unit of Measure on finished goods by summing duty through the BOM | | Duty Reporting report | Produces period-based summary per duty code and item; filterable by duty code, item, and date | --- ## Getting Started 1. Ensure each Duty Code has an **Item Charge No.** set (see the Duty Setup article) — this is required before settlement or reimbursement lines can be generated. 2. Create an open **Purchase Invoice** from the authority (or internal liability account vendor) to which you will add the settlement lines. 3. Open the **Duties** page and choose **Create Settlement** from the actions, or search for **Create Duty Settlement**. 4. On the request page, optionally set a **Duty Code Filter** and a **Starting/Ending Date** to scope the settlement to a specific period. 5. Enable **Create Invoice Lines** and enter the **Purchase Invoice No.** you created in step 2. 6. Run the batch. Review the confirmation message showing how many entries were settled and the total amount. 7. Open the purchase invoice and verify the item charge lines. Post the invoice to record the duty payment in the general ledger. 8. For reimbursements, follow the same steps using a **Purchase Credit Memo** and the **Create Duty Reimbursement** batch instead. --- ## Related Features Settlement and Reimbursement depend on Imposition and Reimbursement duty entries created by the **Duty Entries and the Duty Lifecycle** feature — without open entries, the batches have nothing to process. The Item Charge No. on the Duty Code (configured in **Duty Setup**) is the bridge between the duty ledger and the financial ledger. The **Duty Reporting** report draws on item ledger entries (not duty entries directly) combined with the current duty rate from Item Duty Setup, so it reflects the reportable quantities and calculated duty values for the period. For finished goods assembled from duty-bearing components, the **Rolled-up Duty** batch should be run before the Duty Reporting report to ensure the conversion factors are current. --- ## User Stories ****US-01: Run a periodic duty settlement**** **As a** Accountant **I want to** run the Create Duty Settlement batch at the end of a duty period **So that** all open Imposition entries are settled and the corresponding purchase invoice lines are created ready for posting **Setup:** 1. Create an open **Purchase Invoice** for the duty authority vendor. 2. Open **Duties** and choose **Create Settlement**, or search for **Create Duty Settlement**. 3. Set **Duty Code Filter** if you want to settle a specific duty only. 4. Set **Starting Date** and **Ending Date** to limit which entries are included by posting date. 5. Enable **Create Invoice Lines** and enter the **Purchase Invoice No.**. 6. Confirm and run. The system creates Settlement duty entries and adds item charge lines to the invoice. 7. Open the invoice and review the lines, then post it. > **Note:** The batch processes all unsettled, open Imposition entries that match the filters. Settlement entries are created first (they appear in Duty Entries), and invoice lines are then added referencing the original item transactions. The invoice lines are grouped by Duty Code and Duty Rate, with one item charge line per unique combination. ****US-02: Run a periodic duty reimbursement**** **As a** Accountant **I want to** run the Create Duty Reimbursement batch to reclaim duty on duty-free sales **So that** purchase credit memo lines are generated for the duty amounts I am entitled to reclaim **Setup:** 1. Create an open **Purchase Credit Memo** for the duty authority vendor. 2. Open **Duties** and choose **Create Reimbursement**, or search for **Create Duty Reimbursement**. 3. Set **Duty Code Filter** and date filters as needed. 4. Enable **Create Credit Memo Lines** and enter the **Purchase Credit Memo No.**. 5. Confirm and run. 6. Open the credit memo and review the lines, then post it. > **Note:** Reimbursement entries are created automatically when items are shipped to duty-free customers. This batch collects those entries and converts them into credit memo lines. A prerequisite is that **Shipment on Invoice** in Sales & Receivables Setup must be disabled — sales must be posted as separate shipments (not invoices) so the item charge can be assigned to the shipment line. ****US-03: Settle a specific duty code only**** **As a** Accountant **I want to** run a settlement restricted to a single duty code **So that** I can file and pay each duty type on its own schedule without processing all duties at once **Setup:** 1. Create an open Purchase Invoice for the authority. 2. Open **Create Duty Settlement** and enter the specific duty code in the **Duty Code Filter** field. 3. Set the date range and invoice number as usual. 4. Run the batch. Only Imposition entries for the filtered duty code are included. ****US-04: Create settlement entries without generating invoice lines**** **As a** Accountant **I want to** run the settlement batch without adding lines to a purchase invoice **So that** I can review the settlement entries before committing to the financial posting **Setup:** 1. Open **Create Duty Settlement**. 2. Leave **Create Invoice Lines** disabled (do not enter a Purchase Invoice No.). 3. Set filters as needed and run the batch. 4. Settlement entries are created in Duty Entries. The Imposition entries are marked as settled. 5. Review the Duty Entries before proceeding. When ready, run the batch again with **Create Invoice Lines** enabled to generate the invoice. > **Note:** If settlement entries already exist for an Imposition entry but have not yet been linked to an invoice, the batch skips those entries. Entries are only processed once per settlement run. ****US-05: Run the Duty Reporting report for a period**** **As a** Accountant **I want to** run the Duty Reporting report for a specific period **So that** I have the summary I need to fill in the statutory duty declaration **Setup:** 1. Open **Duty Reporting** from the Duties page or search. 2. On the request page, filter on the relevant **Duty Code(s)** and set the **Date Filter** to the reporting period. 3. Optionally filter on specific items if you want a subset. 4. Run the report. 5. The report produces one section per duty code, broken down by item, with columns for Purchase Duty, Sales Duty (total, with exemptions, without exemptions, domestic, foreign), Consumption Duty, Output Duty, and Adjustment Duty. > **Note:** The report calculates duty amounts using the current duty rate from Item Duty Setup as of today's date, applied to the quantities from item ledger entries for the period. It does not read from the Duty Entries ledger directly. This means the report values are recalculated at run time based on the current rate — if rates have changed, the report reflects the new rate even for historical transactions. ****US-06: Understand how sales are split by exemption status in the report**** **As a** Accountant **I want to** understand the Sales Duty exemption and domestic/foreign columns in the Duty Reporting report **So that** I can correctly map the report output to the fields in my duty declaration form **Setup:** No setup action required. The report automatically splits sales into four sub-columns: - **Sales Duty exception**: Quantity sold to customers who have a Customer Duty Exemption for this duty code. - **Sales Duty without exceptions**: Quantity sold to customers who do not have a Customer Duty Exemption. - **Sales Duty domestic**: Quantity sold to customers whose Country/Region Code is blank or matches the domestic filter. - **Sales Duty foreign**: Quantity sold to customers outside the domestic country. The total Sales Duty column is the sum of all sales regardless of exemption or geography. ****US-07: Roll up duty values for finished goods with duty-bearing BOM components**** **As a** Production Planner **I want to** run the Rolled-up Duty batch after making changes to a Bill of Materials **So that** the Qty. per Item Unit of Measure on finished goods reflects the accumulated duty content from all components **Setup:** 1. Ensure Item Duty Setup lines exist for the raw material components (with the correct Qty. per Item Unit of Measure for each). 2. Open **Rolled-up Duty** from the Duties page, Item Duty Setup, or search. 3. On the request page, enable **Use active version** to use the active BOM version. Set **Active Date** if you want to roll up as of a specific date. 4. Optionally filter on specific items. 5. Run the batch. The system traverses each item's production BOM recursively and accumulates the component duty quantities into the finished item's Item Duty Setup. 6. Review Item Duty Setup for the finished item — the Qty. per Item Unit of Measure should now reflect the rolled-up value. > **Note:** The roll-up overwrites the existing Qty. per Item Unit of Measure on the finished item for each duty code. Use the **Roll-up Quantity Adjustment** field on Item Duty Setup to add a manual adjustment to the calculated roll-up value — for example, if there is a duty component not captured in the BOM (such as packaging material or processing waste). ****US-08: Add a manual adjustment to a rolled-up duty value**** **As a** Production Planner **I want to** apply a quantity adjustment to the rolled-up duty value for a finished item **So that** the calculated duty content accounts for factors not represented in the BOM, such as waste or packaging **Setup:** 1. Open **Item Duty Setup** and find the line for the finished item and the relevant duty code. 2. Enter the adjustment in the **Roll-up Quantity Adjustment** field. Positive values add to the rolled-up quantity; negative values reduce it. 3. Run **Rolled-up Duty** to apply the roll-up including the adjustment. 4. Verify the resulting Qty. per Item Unit of Measure reflects the expected total. > **Note:** The Roll-up Quantity Adjustment is preserved across roll-up runs — it is always added on top of the calculated BOM-based quantity. It is not cleared when the batch runs. ****US-09: Verify settlement status of duty entries after posting the invoice**** **As a** Accountant **I want to** confirm that duty entries are correctly marked as settled after posting the settlement invoice **So that** they are excluded from future settlement runs **Setup:** 1. Post the purchase invoice containing the settlement item charge lines. 2. Open **Duty Entries** and filter on the duty code and period. 3. Check that Settlement entries show **Settled = true** and **Open = false**. 4. Check that the corresponding Imposition entries also show **Settled = true**. > **Note:** The settlement status update happens automatically when the system detects that the item charge assignment linked to a Settlement entry has been posted (i.e., the purchase invoice has a posted invoice counterpart). The update runs as part of the next settlement batch execution. If you need to verify immediately, run **Create Duty Settlement** again — the status update logic runs at the start of every settlement batch execution. ****US-10: Handle a situation where a reimbursement entry cannot be created**** **As a** Accountant **I want to** understand why a reimbursement entry fails and how to resolve it **So that** the duty-free sale is correctly reflected in the duty ledger **Setup:** The most common cause of a reimbursement error is that the sale was posted as a **Sales Invoice** with **Shipment on Invoice** enabled in Sales & Receivables Setup. The reimbursement process requires the item charge to be assigned to a shipment document — not an invoice. To resolve: 1. In **Sales & Receivables Setup**, confirm that **Shipment on Invoice** is disabled. 2. For future sales, this ensures that a separate Sales Shipment document is created, which can carry the item charge assignment. 3. For already-posted invoices, the reimbursement cannot be processed retroactively via the batch — it must be handled manually if required. --- ## Field Reference | Field | Where to find it | What it does | Default | | --- | --- | --- | --- | | Create Invoice Lines | Create Duty Settlement request page | If enabled, item charge lines are added to the specified purchase invoice | On | | Purchase Invoice No. | Create Duty Settlement request page | The open purchase invoice to which settlement lines are added | — | | Create Credit Memo Lines | Create Duty Reimbursement request page | If enabled, item charge lines are added to the specified purchase credit memo | On | | Purchase Credit Memo No. | Create Duty Reimbursement request page | The open purchase credit memo to which reimbursement lines are added | — | | Duty Code Filter | Settlement/Reimbursement request page | Limits processing to entries for the specified duty code(s) | — | | Starting Date | Settlement/Reimbursement request page | Only entries with a posting date on or after this date are included | — | | Ending Date | Settlement/Reimbursement request page | Only entries with a posting date on or before this date are included | — | | Use active version | Rolled-up Duty request page | If enabled, uses the active BOM version for each item | On | | Active Date | Rolled-up Duty request page | The date used to determine the active BOM version | Work date | | Roll-up Quantity Adjustment | Item Duty Setup | Manual adjustment added to the rolled-up Qty. per Item Unit of Measure | 0 |