Export-Import Management (EXIM) in ERPNext
The Exim App is a comprehensive Export-Import management solution built for ERPNext that addresses critical gaps in managing export-import operations. Streamline your entire export cycle from proforma invoice generation to export benefit claims.
The Exim App is a comprehensive Export-Import management solution built for ERPNext that addresses critical gaps in managing export-import operations. This application streamlines the entire export cycle from proforma invoice generation to export benefit claims, ensuring compliance, accuracy, and profitability.
This app provides a complete guide to understanding, implementing, and utilizing the Exim App to manage your export-import business operations efficiently within ERPNext.
What is EXIM?
Contract management (LC - Letter of Credit) - Manage and track all LC contract terms, documents, and compliance requirements throughout the export lifecycle.
Documentation generation and verification - Automatically generate 9+ export document types with standardized formats, eliminating manual errors and ensuring compliance.
Export benefit claims (RoDTEP, Drawback, GST Refunds) - Automate the tracking and claiming of government incentives with balance sheet visibility and claims dashboard.
Currency risk management - Centralize forward contract tracking, utilization, and cancellation with automatic exchange gain/loss calculation and maturity notifications.
License tracking and compliance - Manage Advance Authorization Licenses with automatic validation, utilization tracking, and compliance enforcement to prevent penalties.
Problems Addressed
Execution Gaps Against LC Contracts - Detailed contract terms are often forgotten after 1-2 months when goods are shipped, leading to penalties and charges. The app provides a checklist reminder system to verify all documents and clauses.
Errors in Export Documents - Manual copy-pasting from Excel/Word leads to carried-over errors, missed critical details, and accidental sharing of sensitive information. Automated documentation eliminates these risks.
Missed Claims of RoDTEP and Drawback - Government incentives are often missed due to no automated tracking, busy schedules, and no visibility of pending receivables in the balance sheet. The app automates the entire claims process.
Unhedged Currency Risks - Exchange rate fluctuations, wrong forward contract usage, and forgotten maturities cause significant losses. Centralized forward contract management with proactive alerts addresses this.
Penalty for License Errors - Copy-pasting old license numbers, over/under utilization of Advance Authorization Licenses, and compliance violations lead to financial penalties. Automatic validation prevents these errors.
Key Features
- Comprehensive LC details capture
- Document requirements checklist
- Document specifications tracking
- Automated compliance reminders
- 9+ document types auto-generated
- Standardized formats
- Error-free documentation
- Complete audit trail
- RoDTEP management
- Duty Drawback tracking
- GST Refund processing
- Automatic journal entries
- Balance sheet visibility
- Claims dashboard
- Centralized contract repository
- Utilization tracking
- Cancellation handling
- Exchange gain/loss calculation
- Maturity notifications
- License details management
- Automatic validation
- Utilization tracking
- Compliance enforcement
- Penalty prevention
Complete Workflow
Proforma Invoice is the initial document sent to buyers before confirming the order. The EXIM App adds critical export-related fields like Port of Loading, Port of Discharge, Inco Terms, Payment Terms, and Shipping Terms. Once accepted, it converts to Sales Order with all fields auto-populated.
LC Contracts contain detailed terms agreed upon during sales order creation. The Contract Terms Document captures LC number, contract specifications, payment terms, shipping terms, and document requirements. When creating invoices later, the system displays a checklist reminder to verify all documents and checks.
Fill in export-related details in the structured EXIM section on the Sales Invoice. The system automatically generates all required export documents including Commercial Invoice, Packing List, Custom Invoice, Export Value Declaration, Drawback Declaration, Draft B/L, VGM, Annexure CI, and INR Export details. Eliminates copy-paste errors and creates system records for audit trail.
When creating an invoice, the system automatically captures RoDTEP and Duty Drawback rates and calculates benefit amounts. On submission, automatic Journal Vouchers are generated for receivables, with amounts appearing on the balance sheet. Create Customs Documents for claim periods, submit claims, record script numbers, manage licenses, and track payments through the dashboard.
Add forward contract details including contract number, currency, amount, exchange rate, maturity date, and bank details. At payment entry, select the appropriate forward contract from the dropdown. The system marks contracts as utilized, tracks remaining balance, and creates Journal Vouchers for exchange gain/loss on cancellation. Set up notifications for upcoming maturities to avoid penalties.
Create Advance Authorization License documents with license number, issue date, validity, permitted import items, and required export items. When creating Purchase Invoices (Import) or Sales Invoices (Export), add License Reference in the EXIM section. The system validates sufficient quantity, validity period, and item specifications. Automatic deduction from license balance with real-time view of remaining capacity.
Operational Benefits
Eliminate Manual Errors: Automated documentation prevents copy-paste mistakes across all export documents.
Ensure Compliance: Built-in validations for LC terms and licenses ensure regulatory compliance at every step.
Save Time: Auto-generation of 9+ export documents on a single click eliminates hours of manual work.
Reduce Penalties: Proactive alerts and validation checks prevent costly compliance violations.
Financial Benefits
Maximize Claims: Never miss RoDTEP or Drawback claims with automated tracking and dashboard visibility.
Improve Cash Flow: Track all government receivables on your balance sheet with clear visibility of blocked funds.
Manage Currency Risk: Systematic forward contract management with utilization tracking and maturity alerts.
Reduce Losses: Prevent contract cancellation fees with proactive maturity notifications and centralized tracking.
Better Working Capital: Visibility of blocked funds with government enables better cash flow planning.
Strategic Benefits
Scale Operations: Handle increasing export volumes efficiently with automated workflows and standardized processes.
Audit Trail: Complete documentation history provides full traceability for audits and compliance reviews.
Team Accountability: Checkbox verification system ensures every team member completes required checks.
Data-Driven Decisions: Reports and dashboards provide actionable insights for management decisions.
Professional Image: Error-free documentation enhances your reputation with international buyers and partners.
