Free EDPMS & e-BRC Reconciliation Calculator for Indian Exporters
Export payment reconciliation can become surprisingly difficult when shipping-bill data, invoice records, bank realisation details and e-BRC information live in separate files. Our Free EDPMS & e-BRC Reconciliation Calculator is a browser-based planning tool that helps Indian exporters identify fully realised, partially realised and still-open export transactions from two pasted datasets.
The tool is deliberately designed as a reconciliation aid rather than a fake “live EDPMS checker”. You paste a simplified export register and a corresponding realisation/e-BRC register, choose the reference key, and the calculator aggregates realised amounts against expected export proceeds. It then reports matched records, partial receipts, open records, unrealised amounts and realisation coverage. This makes it useful for internal finance reviews, export receivables follow-up, bank reconciliation and pre-compliance checks.
What is EDPMS?
EDPMS, or Export Data Processing and Monitoring System, is used in India's export monitoring ecosystem for tracking export transactions and the status of export proceeds through authorised dealer banks and related records. RBI reporting and bank workflows connect export bills, shipment information and realisation status, which is why exporters often need to reconcile internal shipping records with bank information rather than relying on a single accounting ledger.
Because EDPMS data is transaction-specific and access-controlled, a generic public page cannot safely claim to show a user's live EDPMS position. This tool therefore works on the records the exporter supplies. The model is particularly useful for businesses maintaining an internal list of shipping bills and another list of actual foreign-currency realisations.
What is e-BRC?
An electronic Bank Realisation Certificate, commonly called e-BRC, is connected with the authorised dealer bank's reporting of export proceeds and the export transaction record. DGFT has used the e-BRC framework for linking export realisation information to trade and benefit workflows, while banks maintain the underlying banking evidence. The exact operational workflow can depend on the transaction and banking system.
Our Free BRC Rate Calculator India focuses on the money side: bank rate, charges and net INR realisation. This reconciliation tool focuses on the record side: which expected export proceeds have been realised, which are partial, and which remain open. Together they cover two different parts of the same export receivable workflow.
Why exporters need shipping-bill versus realisation reconciliation
An export business may have hundreds or thousands of shipments across different currencies, customers, banks and accounting periods. A simple sales ledger can show that an invoice exists, while the bank ledger can show that money arrived, but linking the two can be difficult when references differ. Partial payments make the problem even harder.
A reconciliation process creates a controlled bridge between the expected value and the realised value. This can reveal a short receipt, a missing realisation record, an unlinked invoice, a duplicate entry or a record that needs investigation. It can also help a finance team focus follow-up on the genuinely open transactions instead of manually checking every export.
How this free reconciliation calculator works
The tool accepts two datasets. The first is an export register containing a shipping-bill or invoice reference, currency, expected export proceeds and export date. The second is a realisation register containing the matching reference, currency, realised amount and realisation date. The tool groups the realisation records by the selected reference and compares the total realised amount with the expected export amount.
A transaction within the entered tolerance is treated as fully matched. A lower realised value is classified as partial, and an export with no realised amount is classified as open. Where realised value exceeds expected value, the tool flags it for investigation because that can indicate a duplicate line, wrong reference, foreign-exchange conversion issue or another data problem.
Partial realisation is important
Export payments do not always arrive in one transfer. A buyer may pay in multiple instalments, or bank and intermediary charges may change the amount that appears in the receiving account. A reconciliation tool that only compares “invoice paid” versus “not paid” misses this middle category.
This calculator aggregates all realisation rows that share the chosen key. For example, if an export record expects USD 10,000 and two bank rows show USD 4,000 and USD 6,000 against that reference, the transaction can reconcile as fully realised. If only USD 4,000 is present, the calculator identifies a partial balance of USD 6,000.
Choose a reliable reconciliation key
The best key is the reference that exists consistently in both datasets. Some exporters may have a shipping-bill number in both systems, while others may rely more heavily on invoice or bill references. If your bank file uses a different reference format, you may need to normalise the data before pasting it into the tool.
Reference normalisation is often the hidden step in reconciliation. Extra spaces, prefixes, leading zeros and inconsistent punctuation can make two visually similar references behave like different values. Clean the key columns before assuming a transaction is genuinely open.
How to investigate an open export receipt
When the calculator shows an open transaction, start with the bank and export documents rather than immediately assuming the buyer has not paid. Check whether the remittance used a different invoice reference, whether the bank file omitted a field, whether payment was routed through an intermediary, whether the transaction is pending posting, or whether the receipt belongs to a combined payment that needs allocation across multiple invoices.
For service exports and transactions where foreign-exchange realisation evidence is important, also review the supporting remittance records and the documentation required for the specific tax or regulatory purpose. A calculator can identify the gap; it cannot decide why the gap exists.
Realisation coverage
The coverage metric in this tool is total realised amount divided by total expected amount, expressed as a percentage. It is a useful management KPI, but it should not be confused with a statutory compliance ratio or an official EDPMS status. A portfolio can show 95% coverage while containing one strategically important overdue or disputed transaction.
For that reason, use the count of open and partial records alongside the percentage. A finance team may care more about three large open invoices than twenty tiny fully realised exports.
Why currency matching matters
Currency is a critical reconciliation dimension. USD 10,000 and EUR 10,000 are not the same value, so a naive amount-only comparison can create false matches. This tool keeps the currency field visible in the pasted structure and allows native-currency comparison as the default planning mode.
For multi-currency books, maintain one consistent rule for how expected and realised amounts are represented. If one file is in original currency and another is converted to INR, they should not be reconciled as though they were native-currency amounts. Convert consistently first or prepare separate reconciliation batches by currency.
e-BRC reconciliation and export incentives
Export-realisation data can matter beyond finance. Exporters may use realised-proceeds records when reviewing documentation, bank follow-up, taxation and incentive workflows. Government trade systems can link shipment-level data to benefit processes, so data mismatches can become operational issues.
For incentive planning, connect this reconciliation with the Free Duty Drawback & RoDTEP Calculator India and the Free GST Export Refund Calculator India. Those tools estimate potential benefit amounts; this tool helps identify whether the export-receivable record itself is reconciled.
Do not confuse e-BRC with BRC rate
“BRC” can be used in exporter conversations in more than one way. A Bank Realisation Certificate concerns export-proceeds evidence, while a “BRC rate” in commercial discussions can refer to the exchange rate used to convert the receipt into INR. These are related operationally but are not the same thing.
Use the Free BRC Rate Calculator for rate and deduction scenarios, and this reconciliation calculator for transaction matching. Keeping those concepts separate prevents a common spreadsheet mistake where an exchange-rate calculation is mixed into the record-matching logic.
How to prepare your data for reconciliation
- Export or copy the shipping-bill/invoice register for the period being reviewed.
- Keep one stable transaction key such as shipping-bill number or invoice number.
- Keep the original currency and expected proceeds for each export line.
- Export the bank/e-BRC realisation records with the same key where possible.
- Keep multiple remittances as separate rows so the calculator can aggregate them.
- Remove unrelated columns if the source file is extremely wide.
- Check any unmatched or over-realised rows against the source documents.
The parser accepts common separated formats for convenience, but a clean four-to-five-column dataset is much easier to audit. Do not paste confidential banking credentials, passwords, access tokens or unrelated sensitive information into any public calculator.
What this tool does not do
This tool does not connect to RBI, DGFT, ICEGATE, EDPMS, your bank or PFMS. It cannot tell you whether a live government record is pending, rejected, credited or closed. It also does not issue an e-BRC, alter a bank record or file any regulatory return.
Its purpose is internal reconciliation. The final authoritative status should always be checked in the relevant bank, government or authorised-dealer systems. This design also means your pasted dataset remains in the browser page rather than being sent to Today Adviser by the tool's own JavaScript.
Use this with your export finance workflow
Once the open and partial transactions are identified, the next step is follow-up. Record the buyer contact, bank query, remittance advice and expected resolution date in the internal receivables tracker. When a new bank realisation arrives, rerun the reconciliation and see whether the balance moves from open to partial or full match.
For commercial analysis, connect the result with your Free Export Profit Calculator and Free Last Free Day Calculator where shipment delays or cash-flow timing affect the economics of an order. For documentation, use the Free Commercial Invoice Generator, Free Certificate of Origin Generator India and other Today Adviser export-document tools.
Best practice for monthly EDPMS reconciliation
Run the reconciliation on a fixed monthly cadence, preserve the source files used for each run, and keep a separate exception list for open, partial and over-realised records. Avoid editing the source register immediately without retaining the original extract. That creates a traceable reconciliation history and makes it easier to explain why a balance changed.
For a larger exporter, group exceptions by age, value and customer. A small open receipt that is only a few days old may be normal; a high-value receipt that remains unreconciled across reporting periods deserves priority. The calculator helps surface the exceptions, while the business process determines how they are resolved.
Important disclaimer
This is a free reconciliation and planning tool from Today Adviser. It is not an official EDPMS, e-BRC, RBI, DGFT, ICEGATE or bank portal. It does not provide legal or regulatory confirmation. Use official and bank records as the source of truth for actual export-proceeds status, compliance deadlines and certificate issuance.
Free EDPMS & e-BRC Reconciliation FAQ
What does this EDPMS reconciliation calculator do?
It compares a pasted export register with a pasted realisation register, groups matching references, aggregates realisations and classifies transactions as matched, partial, open or potentially over-realised.
Does it check my live EDPMS account?
No. It is a browser-based reconciliation aid. It does not connect to EDPMS or your bank and cannot display a live regulatory status.
Can I reconcile multiple partial payments?
Yes. Keep each payment as a separate realisation row using the same transaction reference. The calculator adds the rows together before comparing them with expected export proceeds.
What should I use as the reconciliation key?
Use the reference that appears consistently in both your export and realisation datasets, such as a shipping-bill number or invoice/bill reference.
What does “over-realised” mean here?
It means the aggregated realisation amount is greater than the expected amount for that key. That is an exception to investigate for duplicates, wrong references, combined payments or data-format issues.
Can I paste Excel data?
Yes. Copying tab-separated rows from a spreadsheet generally works. Comma-separated and pipe-separated rows are also supported by the parser.
Does this generate an e-BRC?
No. It only reconciles data. An official e-BRC process is handled through the authorised dealer bank and applicable trade systems.
Can exporters use this for services?
Yes for internal record reconciliation, although service-export rules and evidence can differ from goods exports. Use the actual bank and regulatory records for compliance decisions.
Why is the currency field important?
Because an amount in USD cannot be directly treated as equal to the same nominal amount in EUR or GBP. Keep expected and realised values in the same currency for a native-currency comparison.
How often should an exporter reconcile EDPMS/e-BRC records?
A fixed monthly reconciliation is a practical management control for many exporters, with additional checks for high-value or time-sensitive transactions.