# EPCG Export Obligation Tracker Worksheet for Indian Exporters

> Source: https://netray.co/tools/india-epcg-export-obligation-tracker-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable worksheet for EPCG licences showing export obligation, shipments to date, balance and fulfilment percentage.

## Category

regional

## Region

India

## Industry

Manufacturing

## Audience

- Export manager
- Finance manager
- EXIM executive

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** Rs 

**Columns:**

#### Authorisation no.

**Key:** auth

**Type:** text

#### Capital goods

**Key:** machine

**Type:** text

#### Issue date

**Key:** issue

**Type:** date

#### Duty saved

**Key:** duty_saved

**Type:** number

**Format:** currency

#### Export obligation (6x)

**Key:** eo

**Type:** number

**Expr:** duty_saved * 6

**Format:** currency

#### Exports achieved

**Key:** exported

**Type:** number

**Format:** currency

#### Balance obligation

**Key:** balance

**Type:** number

**Expr:** max(duty_saved * 6 - exported, 0)

**Format:** currency

#### Fulfilled

**Key:** fulfil

**Type:** number

**Expr:** min(exported / (duty_saved * 6) * 100, 100)

**Format:** percent

#### Block end date

**Key:** due

**Type:** date

**Rows:**

**Auth:** 3030012345

**Machine:** 5-axis machining centre

**Issue:** 2023-04-12

**Duty saved:** 1800000

**Exported:** 6200000

**Due:** 2029-04-11

**Auth:** 3030019876

**Machine:** Laser cutting line

**Issue:** 2024-01-20

**Duty saved:** 950000

**Exported:** 1800000

**Due:** 2030-01-19

**Auth:** 3030024410

**Machine:** Injection moulding press

**Issue:** 2024-09-05

**Duty saved:** 1200000

**Exported:** 900000

**Due:** 2030-09-04

**Auth:** 3030031207

**Machine:** CMM inspection system

**Issue:** 2025-06-18

**Duty saved:** 600000

**Exported:** 0

**Due:** 2031-06-17

**Totals:**

#### Total duty saved

**Key:** duty_saved

**Agg:** sum

**Format:** currency

#### Total obligation

**Key:** eo

**Agg:** sum

**Format:** currency

#### Total exports achieved

**Key:** exported

**Agg:** sum

**Format:** currency

#### Total balance

**Key:** balance

**Agg:** sum

**Format:** currency

**Summary:**

#### Overall fulfilment

**Key:** overall

**Expr:** sum_exported / sum_eo * 100

**Format:** percent

**Primary:** true

#### Average balance per licence

**Key:** avg_bal

**Expr:** sum_balance / count

**Format:** currency

**Notes:** The six-times duty saved obligation reflects the standard EPCG condition over six years from authorisation issue. Exports credited must meet DGFT rules, and the actual period and ratio depend on your authorisation terms. Replace the sample rows with your own and confirm against the DGFT portal.

## Content

**Intro:** The Export Promotion Capital Goods scheme lets manufacturers import capital goods at zero or concessional customs duty against a promise to export. This worksheet keeps every licence and its balance in one table.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per authorisation. Enter duty saved on the imported goods and the exports credited so far. The sheet computes the obligation at six times duty saved, the remaining balance and a percentage fulfilled. Totals at the bottom show your overall position, which is useful for monthly reviews with the finance team and before any regional authority application.

**Bullets:**

- Update exports after each shipping bill is realised
- Track the block end date to avoid shortfall
- Export to Excel for audit files

#### How the obligation works

**Body:** Under the scheme the holder must export goods worth a multiple of the duty saved, commonly six times, within a stated period from the authorisation issue date. Exports of the goods made with the capital equipment normally count, subject to scheme rules. On fulfilment you apply for an Export Obligation Discharge Certificate, which closes the licence.

#### Reading the results

**Body:** In the sample, the first licence saved Rs 18 lakh of duty, giving an obligation of Rs 1.08 crore, with Rs 62 lakh achieved and Rs 46 lakh balance, about 57 percent. A licence near its block end with low fulfilment needs action: shift product mix, add buyers, or consider an extension or composition fee under the policy.

#### Common mistakes and ERP notes

**Body:** Plants often lose track of which shipping bills are linked to which authorisation. Tagging export invoices and customs references to the licence number in the ERP sales module makes the fulfilment report almost automatic. Also confirm that realisation, not just shipment, is counted where the rules require it.

**Cta:** We can build a read-only ERP report that links export invoices and shipping bills to each authorisation automatically.

**Faq:**

#### What is the usual EPCG export obligation?

**Answer:** The usual condition is export of goods worth six times the duty saved on the imported capital goods, to be fulfilled within six years from the issue date of the authorisation. Terms can differ by policy period, so check the licence.

#### Can domestic supplies count?

**Answer:** Certain deemed exports and supplies to specific entities may be counted under the policy, but not all domestic sales qualify. Review the Foreign Trade Policy and Handbook of Procedures for your authorisation year.

#### What happens on shortfall?

**Answer:** If the obligation is not met, the holder may need to pay customs duty saved with interest, subject to the provisions. Regularisation options and extension fees exist. Seek advice before the block end date.

#### How do I close an EPCG licence?

**Answer:** Apply for the Export Obligation Discharge Certificate through the DGFT portal with the required statements and certificates after the obligation is fulfilled. The certificate allows release of bank guarantees or bonds.

## Search terms

epcg export obligation tracker, epcg six times duty saved, epcg authorisation excel, export obligation fulfilment, epcg eodc application, epcg scheme manufacturer, dgft epcg tracking sheet, capital goods import duty zero

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json