CA Abhilove Sharda

small_Abhilove Picture - Abhilove Sharda.jpeg

thumbnail_Abhilove Picture - Abhilove Sharda.jpeg

Abhilove Picture - Abhilove Sharda.jpeg

The EDPMS caution list is a register of exporters whose export transactions show unrealized or unreported foreign exchange. That means payment has either not arrived or has not been matched and reported to the system within the permitted timeframe. The system behind it, the <a href="https://www.skydo.com/blog/understanding-edpms-full-form-and-its-essential-role-in-export-management">Export Data Processing and Monitoring System (EDPMS)</a>, is an RBI-mandated platform that tracks foreign exchange inflows against every export shipping bill filed by Indian exporters.

Think of the caution list as an administrative flag. It gets removed once the outstanding payment proof is submitted.

Here is how it plays out. A Pune-based garment exporter ships goods worth $5,000 to a UK buyer. If the equivalent inward remittance is not reported against that shipping bill within the allowed period, EDPMS flags the entry, and the exporter's Authorised Dealer (AD) bank, which handles the exporter's foreign exchange transactions, marks them on the caution list.

Who Gets Added to the EDPMS Caution List and Why?

Exporters get added to the EDPMS caution list when foreign exchange against a shipped consignment remains unrealized. Either the payment has not come in, or it has come in but has not been reported to the AD bank within the prescribed period. The most common triggers are payment through an intermediary that did not report the inward remittance to RBI, a Bank Realisation Certificate (BRC) that was not submitted or generated, a shipping bill left open in EDPMS, and a payment that has genuinely not arrived from the foreign buyer within the permitted timeframe.

Exporters across goods and services exports can be flagged, including software exporters, IT service providers, and merchandise exporters. It takes only one shipping bill that remains unreconciled.

The AD bank (Authorised Dealer bank, the exporter's bank that handles foreign exchange transactions) is responsible for flagging the exporter once the prescribed period lapses without payment evidence.

What Documents Do You Need to Get Off the EDPMS Caution List?

To get off the EDPMS caution list, you need four documents: the FIRC, the BRC, the relevant shipping bill(s), and a covering letter addressed to your AD bank. If the payment was delayed or partially received, the bank may also ask for supporting correspondence with the foreign buyer.

The FIRC is the anchor document in almost every caution list removal case. If you have it, the rest of the process is largely administrative.

How to Get Removed from the EDPMS Caution List: Step-by-Step

To get removed from the EDPMS caution list, you need to identify the outstanding shipping bills and resolve the reason they remain open. This could involve matching payments already received to the correct shipping bills or seeking a permitted write-off for export proceeds that could not be realised. The process depends on your circumstances and must be handled through your Authorised Dealer (AD) bank.

1. Get a List of Outstanding Shipping Bills

Contact your AD bank’s forex or trade finance team and request a list of the shipping bills that remain outstanding in EDPMS against your IEC. Check the shipping bill numbers, dates, export values, amounts received and pending balances. This will help you identify which entries need to be reconciled.

Review the outstanding entries and group them by the reason they remain unresolved:

Identifying the reason for each entry helps you determine what documents or corrective action your AD bank will require.

3. Submit Documents to Reconcile Received Payments

If you have received payment but the shipping bill remains open, gather the relevant bank credit advice, inward remittance records, FIRC (where applicable), payment platform statements and export invoices. Prepare a reconciliation statement linking each remittance to the corresponding shipping bill and submit it to your AD bank with a request to update the EDPMS record.

If a remittance has been reported but not correctly mapped, ask the bank what additional information is needed to complete the reconciliation.

4. Explore a Permitted Write-Off for Unrealisable Export Proceeds

If the buyer has defaulted and the outstanding amount cannot be recovered, ask your AD bank whether the case qualifies for a write-off under the applicable RBI export regulations. Depending on the circumstances, you may need to provide evidence of collection efforts, correspondence with the buyer and documents supporting the reason for non-realisation.

Write-offs are subject to eligibility conditions, limits and documentation requirements. They are not automatic, and the applicable route depends on the nature of the export and the reason the proceeds remain unrealised.

5. Follow Up Until the EDPMS Entries Are Resolved

After you submit the documents, follow up with your AD bank to confirm that the remittances have been reconciled and the relevant shipping bills have been closed, or that an approved write-off or other permitted resolution has been recorded. If any entries remain outstanding, ask the bank what is preventing closure.

Keep the bank's written confirmation and supporting documents for your records.

Once the outstanding entries have been resolved, check with your AD bank that your caution-list status has been updated. In standard cases, de-cautioning follows when the applicable conditions are met, but cases involving other grounds for caution-listing may require additional action.

The timeline depends on the number of outstanding entries, the completeness of your documents and whether further approvals or corrections are needed. Ask your AD bank for the expected timeline rather than assuming that removal will happen in a fixed quarterly cycle.

Should You Go to Your AD Bank or RBI to Get Removed?

In almost all cases, you should go to your AD bank, not RBI, to get removed from the EDPMS caution list. EDPMS entries are managed at the bank level, so once you submit the FIRC and BRC, the bank updates the realization status of each shipping bill directly in the system.

Think of your AD bank as the gateway. All EDPMS entries are opened and closed by the bank, and the system is administered through AD banks, not directly by RBI.

RBI escalation is only relevant in specific situations:

If your payment came through an intermediary platform that did not report to RBI, which is common with PayPal or informal aggregators, the correct path is still your bank's FEMA compliance desk. The bank acts as the interface between you and RBI in these cases.

If the AD bank is genuinely unresponsive, you can approach the Regional Office of RBI under whose jurisdiction the AD bank falls. Treat this as a last resort, after documented follow-ups with the bank.

How Long Does EDPMS Caution List Removal Take?

EDPMS caution list removal depends on how quickly you submit complete documentation and how promptly your AD bank processes it. If the FIRC, BRC, shipping bill reference, and covering letter are submitted together and are in order, the bank can process the closure and update EDPMS within a few working days to a few weeks.

If the FIRC is missing and needs to be reconstructed or reissued by the payment platform, this alone can add days or weeks to the timeline.

There is no fixed statutory deadline by which the bank must process a caution list removal. That is why proactive follow-up with the bank's FEMA or trade finance desk matters.

Can You Continue Exporting While on the EDPMS Caution List?

Yes, you can generally continue to export goods and services while on the EDPMS caution list, because the listing does not automatically suspend export operations. It can still create practical friction with your bank and may affect your access to certain export incentives.

Some AD banks become more cautious about processing new foreign exchange inflows for exporters with open EDPMS entries. Certain banks may require resolution of outstanding entries before processing new transactions smoothly.

The listing can also affect your ability to avail export incentives and schemes that require a clean FEMA compliance record, including certain DGFT benefits. It does not by itself constitute a DGFT license suspension or cancellation, but unresolved entries that escalate into formal FEMA proceedings can have broader consequences.

Treat caution listing as urgent even if your exports are not immediately blocked. The longer entries remain open, the more complex resolution becomes, and the greater the risk of formal regulatory attention.

How Does Using a Compliant Payment Platform Prevent Re-entry on the EDPMS Caution List?

A compliant payment platform prevents re-entry on the EDPMS caution list because it automatically generates the documentation, specifically the FIRC, that closes each shipping bill in EDPMS as soon as payment is received. The root cause of most caution list entries is a documentation gap. Payment arrives but no compliant FIRC is issued, which leaves the shipping bill open and unrealized in EDPMS. A compliant platform eliminates that gap at the point of receipt.

That is the gap <a href="https://www.skydo.com/">Skydo</a> is built to close. Here is what it does for your EDPMS entries:

Proforma Invoice: Meaning, Format And Template

large_Proforma Invoice: Meaning, Format And Template

medium_Proforma Invoice: Meaning, Format And Template

small_Proforma Invoice: Meaning, Format And Template

thumbnail_Proforma Invoice: Meaning, Format And Template

What Is Export Payment Reconciliation in Zoho Books?

Export payment reconciliation in Zoho Books is the process of matching the foreign currency payments you receive from international clients against the invoices you raised in Zoho Books, so your books reflect exactly what landed in your bank account.

Indian freelancers and exporters use it to confirm that every foreign inward remittance is accounted for, correctly valued in INR, and supported by the right compliance documents.

Say a Bengaluru-based developer invoices a US client $2,000. By the time the payment settles, exchange rate movement and intermediary bank charges mean only ₹1,63,500 reaches the account instead of the expected ₹1,66,000. Reconciliation is the step that explains and records that gap.

Why Export Payment Reconciliation Matters?

Export payment reconciliation matters because the amount credited to your bank account from an international client rarely matches the exact invoice value, and that gap has to be explained and recorded accurately. Four things cause the mismatch: bank charges, exchange rate differences, agreed deductions or discounts, and partial payments.

Without reconciliation, your ledger will show phantom profit or unexplained losses, which makes it impossible for your CA or GST authorities to verify your export earnings. Even a ₹500 gap between your invoice value and the bank credit needs a journal entry, because leaving it unrecorded distorts your annual P&amp;L.

There is a compliance side too. FEMA requires <a href="https://www.skydo.com/blog/export-realisation-guide">export proceeds to be realised and repatriated</a> within a prescribed period, and an unmatched entry is a red flag during scrutiny.

Reconcile each foreign payment the same week it settles, not at month-end. The bank's settlement rate is easier to confirm when the advice is fresh.

What Documents Do You Need Before You Start Reconciling in Zoho Books?

Before you reconcile in Zoho Books, gather five things: your bank or credit card statement, the closing balance figure, records of deposited cheques and receipts, records of payments and bills, and bank fee and interest notices.

Download your bank statement and your Foreign Inward Remittance Certificate (FIRC) for the same date range before you open Zoho Books. Having all your documents open at once cuts reconciliation time significantly.

How Export Reconciliation Works in Zoho Books? A Step-by-Step Guide

Reconciliation in Zoho Books for export payments covers four tasks: exporting reconciliation reports, reconciling your bank account, reconciling GST/tax data, and exporting raw module data. For export payments, the core is bank reconciliation: you open the account, set the statement details, match transactions, record the exchange rate and any forex gain or loss, attach the FIRC, and finalize.

Part 1: How to Export Reconciliation Reports (Bank/Card Accounts)

To download matched, unmatched, reconciled, or unreconciled bank transactions, follow these steps.

Part 2: How Bank Reconciliation Works in Zoho Books

Part 3: How GSTR / Tax Reconciliation and Module Data Export Work

For GST reconciliation (GSTR-2A/2B), follow these steps.

Zoho Books then auto-categorises and matches purchase invoices against portal data, so you can spot missing ITC entries.

To export raw records (invoices, bills, customers) for external reconciliation, follow these steps. Each export is limited to 25,000 rows.

How Does Skydo Help Receive International Payments?

The problems this guide works through, exchange rate mismatches, missing FIRC documents, and unpredictable INR settlement amounts, start before Zoho Books. They start at the payment collection layer.

<a href="https://www.skydo.com/">Skydo</a> is a cross-border payment platform built specifically for Indian freelancers and exporters to <a href="https://www.skydo.com/blog/payment-gateway-for-international-payments-india">receive international payments</a>. It acts as the payment layer before Zoho Books, eliminating the heavy paperwork, unpredictable bank charges, and delayed documentation associated with traditional SWIFT wires.

Traditional banks and platforms like PayPal charge hidden fees of up to 8%. Skydo's fee model means the gap between your invoice value and the INR credited is small, known in advance, and easy to record as a single line in your Zoho Books journal.

How Saas exporters can claim GST refund with FIRA

large_How Saas exporters can claim GST refund with FIRA

medium_How Saas exporters can claim GST refund with FIRA

small_How Saas exporters can claim GST refund with FIRA

thumbnail_How Saas exporters can claim GST refund with FIRA

Why Is It Important to Discuss Export Compliance With Your CA?

Discussing export compliance with your CA matters because it covers more than just receiving money. For Indian service exporters, it spans GST treatment, documentation, remittance reporting, and bank record reconciliation, and each of these can create problems if handled incorrectly from the start.

Getting the requirements right from your first transaction makes invoicing, tax filing, payment reconciliation, and future audits significantly easier to manage.

A CA who understands export compliance helps you tell which rules apply to your specific business type and which don't, so you aren't following a generic checklist built for goods exporters.

Without this conversation, freelancers and service exporters often discover compliance gaps only when they face an RBI scrutiny or a bank query. Correcting backdated records at that point is far harder.

Here are the key questions worth asking your CA to ensure your export business meets the relevant GST, FEMA, documentation, and foreign payment compliance requirements.

1. Do I Have All the Registrations Required to Export?

As an Indian service exporter running an <a href="https://www.skydo.com/blog/how-to-start-export-business-in-india">export business in India</a>, you need at minimum an Import Export Code (IEC) and GST registration before you can legally export and receive foreign remittances. Your CA should also confirm whether an AD Code or any sector-specific license applies to your situation.

2. How Should I Handle GST on My Exports?

Under GST, <a href="https://www.skydo.com/blog/export-of-services-under-gst">export of services</a> qualifies as a zero-rated supply, which means no GST is charged on the invoice. You still need the right mechanism in place to export without paying IGST first, and for most freelancers the more practical route is exporting under a <a href="https://www.skydo.com/blog/all-you-need-to-know-about-lut-for-tech-service-export">Letter of Undertaking (LUT)</a>.

GST gives you 2 options for zero-rated exports:

The LUT must be filed on the GST portal before the first export invoice of each financial year. Ask your CA to confirm that it has been filed, that it is valid for the current year, and that it covers your category of service export.

An LUT is not permanent. It must be renewed at the start of every financial year, and a lapse means you may inadvertently be required to pay IGST on exports.

3. What Documents Should I Maintain for Every Export?

For every export transaction, you should maintain a minimum set of <a href="https://www.skydo.com/blog/export-documents-attestation">export documents</a> covering the contract, invoice, payment receipt, bank certificate, and tax records. Your CA should confirm which of them apply to each transaction type.

Finally, ask your CA how these documents are matched to each other, from invoice to bank credit to FIRC to eBRC, and how long each must be retained for audit purposes.

4. How Should I Record and Reconcile Payments From Foreign Clients?

Every inward foreign remittance must be linked to a specific export invoice using the correct RBI <a href="https://www.skydo.com/blog/p0108-purpose-code-merchanting-trade-export-receipts">purpose code</a>. Your CA should confirm that all incoming payments are being matched, recorded, and reported correctly.

<a href="https://www.skydo.com/">Skydo</a> auto-generates FIRC and BIRC certificates for every inward remittance and assigns purpose codes at the transaction level, so your CA is reviewing strategy instead of chasing bank paperwork or correcting purpose code mismatches after the fact.

5. What Are My FEMA and Export-Realisation Obligations?

Under FEMA, Indian exporters are required to <a href="https://www.skydo.com/blog/export-realisation-guide">realize and repatriate export proceeds</a> within a specified period from the date of export. Ask your CA to confirm the applicable deadline for your transaction type and what happens if it is not met.

6. Are There Any Foreign Withholding-Tax or DTAA Issues?

Yes, they can arise: some countries require overseas clients to deduct withholding tax before remitting payment to an Indian service exporter. Your CA should confirm whether this applies to your client's country and what <a href="https://www.skydo.com/blog/cross-border-tax-compliance">cross-border tax compliance</a> documentation you need to avoid double taxation.

7. How Should I Handle Foreign-Exchange Gains, Losses and Charges?

Every export transaction involves at least 2 exchange rates, the rate on the invoice date and the rate on the date payment is received. The difference must be correctly accounted for as a forex gain or loss in your books.

8. What Should I Do to Stay Compliant as My Export Business Grows?

Compliance obligations change as your export volumes, client geographies, and service types evolve, so revisit this conversation with your CA at least annually and after any significant change in your business.

<a></a>How Can Skydo Help Simplify Export Payment Compliance?

Managing export compliance involves more than receiving payments from overseas clients. You also need to track remittances, obtain the right certificates, assign correct purpose codes, and maintain records that your CA can use for reconciliation and reporting.

Skydo helps Indian freelancers and service exporters simplify the process of receiving international payments and managing remittance documentation.

Skydo does not replace your CA or remove your GST, FEMA, or income tax obligations. Instead, it helps simplify the payment and documentation side of export compliance, making it easier for you and your CA to keep your records organised.

<a href="https://www.skydo.com/">Explore Skydo</a> to simplify international payments and spend less time chasing remittance paperwork.

Negotiating International Payment Terms: A Guide for Indian Exporters & Freelancers 

large_Negotiating International Payment Terms: A Guide for Indian Exporters & Freelancers 

medium_Negotiating International Payment Terms: A Guide for Indian Exporters & Freelancers 

small_Negotiating International Payment Terms: A Guide for Indian Exporters & Freelancers 

thumbnail_Negotiating International Payment Terms: A Guide for Indian Exporters & Freelancers 

A purpose code is a short alphanumeric code that identifies the nature of a foreign exchange transaction, such as whether a payment received from abroad is for software services, goods export, consultancy, or another category. In India, Authorised Dealer (AD) banks collect purpose codes and report them to the RBI as part of Balance of Payments (BoP) reporting, so every inward remittance must be tagged with the correct code at the time it is credited.

Take a Bengaluru-based freelancer who receives $3,000 from a US client for IT consulting. That payment must carry the correct service-export purpose code. If it carries the wrong one, an incorrect transaction type shows up in RBI's records as well as in the bank's internal ledger. You can read more about the <a href="https://www.skydo.com/blog/rbi_purpose_code_for_inward_remittance">RBI purpose code for inward remittance</a> in our separate guide.

What Happens If You Use the Wrong Purpose Code?

Using the wrong purpose code does not block the payment, and the money is still credited to your Indian bank account, but the transaction is reported to RBI under the wrong category. Because AD banks submit purpose-code data to RBI's BoP reporting system, the error enters a regulatory filing. It can create mismatches in export reporting, affect the accuracy of your FIRC/FIRA, complicate Electronic Bank Realisation Certificate (eBRC) generation, and cause reconciliation issues when your income is scrutinised for GST refunds or income-tax filings.

Leaving a wrong code uncorrected leaves the incorrect category in RBI's BoP data permanently, unless a formal amendment is made through the AD bank.

Here is how that can play out.A Bengaluru freelancer codes an IT support payment as P0807 (Off-site software exports) instead of P0803 (Data base, data processing charges). The reported category no longer matches the actual service provided, which may cause issues with GST refund eligibility.

To correct a wrong purpose code, you work through five steps in order: identify the incorrect code on your remittance advice, determine the correct code, contact your AD bank, submit supporting documents, and get written confirmation that the code has been updated.

Check the remittance advice or credit advice from your bank. The purpose code that was reported should be visible on this document. Confirm the code that was actually used and note the transaction or UTR reference number.

Step 2: Determine the Correct Purpose Code

Work out the actual nature of the payment: goods export, software services, IT-enabled services, consultancy, royalty, and so on. Then cross-check it against the RBI master list of purpose codes to find the exact applicable code. Do not pick a code that merely sounds similar.

These are commonly confused purpose-code pairs for Indian freelancers and exporters:

Write to the branch or relationship manager handling your foreign-currency account and ask them to amend the purpose code for the specific inward remittance. Give them the transaction reference number, the incorrect code that was reported, and the correct code you are requesting.

Attach the documents the bank asks for to show the nature of the payment. The full list is in the documents section below.

Banks have no standardised correction form. Some require a letter on company letterhead, while others use an internal format, so ask your relationship manager what the bank requires before you draft anything.

Step 5: Get Written Confirmation of the Correction

Ask the bank to confirm in writing that the purpose code has been updated in its records. Check whether the correction also requires an amended FIRC/FIRA or an updated eBRC, and keep all confirmation documents on file.

Can a Bank Change the Purpose Code After the Payment Is Credited?

Yes. Crediting the payment to your account and reporting the purpose code to RBI are two separate processes, so the reported code can be amended even after the money has been received. Whether your bank can make the change depends on its internal procedures and how far the transaction has progressed in downstream reporting.

Not all banks handle this the same way. The exact process, and whether the amendment is possible at all, depends on the bank, the transaction date, and the stage of RBI reporting. There is no universal rule.

The bank will typically require supporting documents that prove the actual nature of the transaction before it makes any amendment. If a FIRA or FIRC has already been issued, the bank will need to assess whether the correction also requires re-issuance of that document, so ask your relationship manager about it explicitly.

Documents You May Need for Purpose-Code Correction

<a href="https://www.skydo.com/blog/ad-code">AD banks</a> typically ask for some or all of these documents when processing a purpose-code correction: the invoice, the contract or agreement, the remittance or credit advice, the UTR or transaction reference number, the FIRA or FIRC, shipping or export documents where the payment relates to goods exports, and a written declaration or correction request. Not every bank asks for all of them.

The exact list depends on the bank's internal process and the nature of the transaction, so confirm with your relationship manager before you start gathering documents.

What If the Wrong Purpose Code Has Already Been Used for eBRC?

If an eBRC has already been generated with the wrong purpose code, the underlying inward remittance record that feeds the eBRC may need to be corrected first. The eBRC is generated from the realisation data the bank submits to DGFT, so a wrong code in that data carries forward into the eBRC. Ask your AD bank explicitly whether the eBRC needs to be amended or reissued after the purpose-code correction.

Skydo's <a href="https://www.skydo.com/blog/p1401-purpose-code-guide">P1401 purpose code guide</a> covers that code in detail.

Three scenarios come up for freelancers and exporters: a service export reported under the wrong service category, an export payment reported under an incorrect broad category, and a payment received through a payment platform that is classified incorrectly. In each case the fix runs through your AD bank, with documents that show what the payment was actually for.

The most common mix-up for Indian freelancers is between P0802 and P0806. They sound similar but sit in different regulatory categories, with different implications for GST and export reporting. Our <a href="https://www.skydo.com/blog/p0807-purpose-code-guide">P0807 purpose code guide</a> covers another code in detail.

You can also avoid the correction hassle upstream. <a href="https://www.skydo.com/">Skydo</a> shows you the purpose code at the point of receiving payment, so you can confirm it is correct before it enters your AD bank's records. Skydo also issues a free FIRC/BIRC for every transaction, so there is no ambiguity in the remittance documentation from the start.

Pricing is a flat $19 for payments under $2,000, a flat $29 for payments from $2,000 to $10,000, and 0.3% above $10,000. There are no monthly fees.

How Long Does Purpose-Code Correction Take?

There is no fixed or guaranteed turnaround for a purpose-code correction. Processing time varies by bank, transaction, and how complete your documentation is.

<b>The timeline depends on three variables:</b>

If a FIRA or eBRC amendment is needed in addition to the purpose-code change, the overall process takes longer because it involves additional verification steps within the bank.

In practice, raise the correction request as early as possible and submit all required documents in one go. Incomplete submissions are the most common cause of delays, and every additional document exchange adds days. Follow up with your relationship manager proactively, especially if an eBRC or FIRC amendment is also involved.

large_Eximpe reviews

medium_Eximpe reviews

small_Eximpe reviews

thumbnail_Eximpe reviews

Eximpe reviews

What Is Export Payment Reconciliation in QuickBooks?

Export payment reconciliation in QuickBooks is the process of matching the international payment entries recorded in your QuickBooks books against the actual credits shown on your bank statement for the same period.

If you are an Indian freelancer or service exporter, this means verifying that every foreign-currency invoice you raised is fully accounted for in INR in your books, including any fees deducted or exchange rate differences that reduced the final amount credited.

Here is an example. A Bengaluru-based UX designer invoices a US client $1,000. By the time the payment clears her Indian bank account, she receives ₹81,400 instead of the expected ₹83,000. The difference comes from SWIFT charges and the bank's conversion spread. Reconciliation is the step that explains and records that ₹1,600 gap.

Export payment reconciliation matters because the amount credited to your Indian bank account after an international wire almost never equals the invoice value, and without reconciliation your books will show a permanent, unexplained difference. Four causes create the mismatch: intermediary or correspondent bank charges, exchange rate differences, agreed deductions or discounts, and partial payments. Each one must be recorded separately in QuickBooks.

SWIFT charges, conversion spread, and platform fees each take a cut before settlement. Your reconciliation task is to name and record each deduction separately.

Leaving these differences unrecorded distorts your profit figures and creates compliance issues with FEMA's <a href="https://www.skydo.com/blog/export-realisation-guide">export realization requirements</a>. It also makes it impossible to generate an accurate Foreign Inward Remittance Certificate (FIRC) or eBRC for each transaction.

Export payment reconciliation also differs from domestic bank reconciliation. Foreign-currency invoices, realized gain/loss entries, and FIRC compliance add steps, which makes it a fundamentally different process.

What Documents Do You Need Before You Start Reconciling in QuickBooks?

Before you start reconciling in QuickBooks, gather five things: your bank or credit card statement, the previous reconciliation report or opening balance, supporting transaction documents, bank charge and interest notices, and an updated QuickBooks register with all entries categorized.

How Export Reconciliation Works in QuickBooks? A Step-by-Step Guide

Export reconciliation in QuickBooks works in two stages: first you generate the reconciliation report inside QuickBooks Online (QBO) or QuickBooks Desktop (QBDT), and then you export it for record-keeping or audit purposes. The reconciliation itself follows six steps: create a foreign-currency invoice, record the payment in the received currency, log the bank deposit in INR, record the exchange gain or loss, match against the bank statement, and attach the FIRC reference.

Stage 1 is running and viewing the reconciliation report. The menu path depends on which version you use.

Stage 2 is exporting the reconciliation report. The method differs between the two versions.

Method 1: Direct Export from QuickBooks Desktop

Method 2: Manual Export from QuickBooks Online (Copy-Paste Workaround)

QBO does not have a native Excel export button for reconciliation reports, so use this workaround instead.

Alternative: Saving as PDF in QuickBooks Online

Step-by-Step Reconciliation for a $1,000 USD Export Invoice

The six steps below use a $1,000 USD invoice as the running example. They apply whether you use QBO or QBDT. The menu paths differ, as covered above, but the accounting logic is identical.

Most of the unexplained differences in Steps 3 to 5 (unpredictable INR credits, missing SWIFT fee records, uncertain exchange amounts) originate at the payment stage, before the money even reaches your account. Fixing reconciliation at the source, the payment method, eliminates the problem upstream. That is where <a href="https://www.skydo.com/">Skydo</a> comes in: it is a cross-border payment aggregator that helps Indian freelancers and service exporters receive international payments. It does not send money abroad.

In the context of export reconciliation, Skydo removes the root cause of most QuickBooks discrepancies: unpredictable settlement amounts caused by hidden SWIFT fees, correspondent bank deductions, and opaque conversion spreads.