Advance License Analysis Report

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.