Docs
ERP Crystal
MFG
Supply Chain
Reports
FEMA Compliance Report

FEMA Compliance Report

FEMA Compliance Report - User Guide

1. Introduction đŸ’ŗ🏛ī¸

For any Indian company involved in international trade, the Foreign Exchange Management Act (FEMA) sets strict guidelines on how foreign currency must be handled. The FEMA Compliance Report is a statutory audit tool that ensures every dollar or euro leaving or entering the company is linked to a valid commercial document (like an Invoice or Bill of Entry). This report acts as your internal “Regulatory Shield” during bank audits and GST/Customs inquiries.

ℹī¸

Purpose of this Report:

  • Statutory Reconciliation: Link foreign payments to physical shipping documents (AWB/BOE).
  • Bank Submission Tracking: Monitor which transactions have been finalized with your Authorised Dealer (AD) Bank.
  • Audit Readiness: Maintain a digital trail of ORM (Outward Remittance) and FIRC (Foreign Inward Remittance Certificate) numbers.
  • Risk Management: Identify “Open” cases where payments have been made but shipping documentation is still pending.

This report is essential for Finance Controllers, Exim Officers, and Legal Compliance Teams.

2. The Statutory Lifecycle 🚀

The report tracks the “Compliance Journey” of a foreign transaction across these critical stages:

  1. The Initiation: Starts with the Proforma Invoice (PI) where the intent to trade is recorded.
  2. The Commercial Phase: Logs the formal Commercial Invoice details and amounts.
  3. The Logistics Phase: Records the Airway Bill (AWB) No or Bill of Lading, proving the physical movement of goods.
  4. The Customs Phase: Captures the Bill of Entry (BOE) No and Date, required by the Reserve Bank of India (RBI).
  5. The Settlement Phase: Records the Outward Remittance (ORM) number provided by your bank after the payment is processed.
  6. The Closure: The case is marked “Closed” once the bank has accepted the documentation and confirmed compliance.

3. Key Analysis Features 🛠ī¸

  • “Open” Case Monitoring: The report highlights all transactions currently in “Open” status. These are high-priority items; failure to close these within 180 days (or as per current RBI rules) can lead to penalties.
  • Currency Integrity: Tracks transactions in their original foreign currency to ensure the bank remittance exactly matches the commercial invoice.
  • Notes & Comments: Allows compliance officers to record specific bank queries or reasons for delays in document submission.

4. Understanding Data Columns 📊

  • FEMA No: Your internal unique tracker for the compliance case.
  • ORM No & Date: Unique bank reference for the foreign payment.
  • BOE No & Date: The statutory customs document proving import.
  • Submit Date: When the documents were hand-delivered or uploaded to the bank portal.
  • Fema Status: “Open” (Audit Pending) or “Closed” (Compliant).

5. Source Transactions 🔄

The reporting engine synthesizes data from:

  1. FEMA Table: The core record where PI, Invoice, and ORM details are linked.
  2. Party Master: Information on the foreign vendor or customer.

6. Best Practices / Tips 💡

  • The Monthly FEMA Scrub: Run this report on the 1st of every month. Filter for “Open” status and prioritize getting the Bill of Entry (BOE) from your logistics provider for any transaction older than 30 days.
  • Bank Advice Matching: Always ensure the Debit Advice No in this report matches the one on your bank statement. This is the first thing a statutory auditor will check.
  • Note Consistency: Use the Notes field to record the “Courier Receipt Number” when you send physical documents to the bank. This provides an audit trail if the bank claims they haven’t received the documents.
  • Currency Verification: If the Commercial Invoice Amount and PI Amount differ significantly, record the justification in the notes. Banks often require a “Difference Justification Letter” for variances above 5-10%.
Inventory Valuation Report