Advance License Analysis Report
Advance License Analysis Report - User Guide
1. Introduction đ
For export-oriented manufacturing units operating under Foreign Trade Policy (FTP) duty exemption schemes, the Advance License (Advance Authorization) allows duty-free import of raw materials required to produce export goods. However, this exemption carries mandatory, time-bound Export Obligations (EO) and strict input-output accounting. The Advance License Analysis Report is the dedicated compliance and financial tracking engine that monitors license utilization and obligation fulfillment in real time.
Core Objectives:
- Export Obligation Tracking: Ensure export shipments meet the mandated FOB value and quantity thresholds authorized for each license.
- Duty-Free Quota Monitoring: Monitor remaining import entitlements (CIF value and material quantity) before authorizations lapse.
- Redemption & Closure Readiness: Provide auditable documentation for obtaining the Export Obligation Discharge Certificate (EODC) from the DGFT.
- Financial Risk Mitigation: Prevent customs duty clawbacks, penalties, and interest by actively tracking import and export expiry dates.
Typically, this report is used by Export-Import (EXIM) Managers, International Logistics Heads, and Corporate Finance Teams.
2. Accessing the Report đ
Navigate to Manufacturing > Reports > Advance License Analysis Report.
3. Analysis Modules & Generated Workbooks â¨
The generation interface allows selection among three dedicated report modes:
A. License Register (Advance_License_Register.xlsx)
- Master Regulatory Directory: Consolidates all applications and licenses across their lifecycle states.
- Valuation Summary: Tracks total FOB values (exports) and CIF values (duty-free imports) in both foreign currency and INR.
- Timeline Monitoring: Audits critical milestones including Application Date, License Date, Import Expiry Date, and Export Expiry Date.
B. Export Analysis (Advance_License_Export_Analysis.xlsx)
- Obligation vs Actual Performance: Compares authorized export quantities against actual customer sales invoices and shipping bills.
- Sales Order Linking: Details confirmed sales orders currently reserved against open export commitments.
- Shortfall Audit: Highlights remaining export balances required to fulfill and close the authorization.
C. Import Analysis (Advance_License_Import_Analysis.xlsx)
- Duty-Free Material Tracking: Monitors physical raw material arrivals (via GRNs) against authorized import quotas.
- Indent Allocation: Tracks purchase indents utilizing the duty-free entitlement.
- Quota Enforcement: Ensures no material is imported beyond authorized CIF assessable limits.
4. Key Filters & Lifecycle Tracking đ ī¸
- Date Range Filtering: Filter by transaction and license dates (From Date / To Date).
- Status Lifecycle Filtering:
- Applied (A): Application submitted to DGFT; awaiting license number.
- Received (R): Active authorization; duty-free imports and export shipments underway.
- Submitted (S): Obligations completed; redemption / EODC application filed.
- Closed (C): EODC received; license officially discharged and closed.
- Expired (E): Statutory validity expired; highlights penalty exposure.
- Specific License Targeting: Generate dedicated audits for an individual license or across all active authorizations.
5. Best Practices / Tips đĄ
- Proactive Expiry Monitoring: Filter regularly by “Received” status to audit impending Export Expiry Dates. Prioritize shop floor manufacturing and dispatch for orders linked to licenses nearing expiration.
- Link Orders Early: Allocate confirmed customer orders to advance licenses immediately upon order booking to guarantee export commitments are scheduled in PPC plans.
- Streamline DGFT Redemption: When filing for license redemption and EODC, export the Export Analysis and Import Analysis sheets to provide customs authorities with an itemized, transaction-level trail.