How to Reconcile Export Payments in Tally? A Complete Guide
TL;DR - Summary
- What is export payment reconciliation in Tally? - Export payment reconciliation in Tally is the process of matching recorded export sales invoices against the actual INR amount credited by the bank, accounting for forex fluctuations, bank charges, and compliance documents.
- Why does export payment reconciliation matter for Indian exporters? - Export payment reconciliation matters because the bank credit rarely matches the invoice value, and each mismatch (bank charges, exchange rate differences, agreed deductions or discounts, partial payments) must be recorded separately in Tally or it shows up as an unexplained mismatch that flags during CA audits.
- What documents do you need before you start reconciling export payments in Tally? - Before reconciling export payments in Tally, you need updated Tally books, the official bank statement, and the previous reconciliation or opening BRS for bank reconciliation, plus sales and purchase data, GST portal returns or JSON files, and credit and debit notes for GST reconciliation.
- How do you reconcile export payments in Tally, step by step? - You reconcile export payments in Tally in four steps: record and verify export invoices, review the GSTR-1 export data in Table 6A, export the return file for portal matching, and reconcile bank realisation against the e-BRC or FIRC.
What Is Export Payment Reconciliation in Tally?
Export payment reconciliation in Tally is the process of matching your recorded export sales invoices against the actual INR amount credited by the bank. It accounts for forex fluctuations, bank charges, and compliance documents like the electronic Bank Realisation Certificate (e-BRC) and the Foreign Inward Remittance Certificate (FIRC).
After a foreign client pays a USD invoice, the INR credited to your bank account almost never equals the INR value booked at the time of invoicing. Reconciliation is what closes that gap in your books.
Here's how it plays out. A Bengaluru software exporter raises an invoice for $3,000 at a booked rate of ₹82.50/USD, which is ₹2,47,500. The bank credits ₹2,49,600 because the rate on settlement day is ₹83.20/USD. Reconciliation records that ₹2,100 difference and ties the bank credit back to the original invoice.
💡 QUICK INSIGHT
Export payment reconciliation is not the same as standard bank reconciliation. It requires matching the INR credited by the bank against a foreign-currency invoice amount, not just ticking off debits and credits.
Why Export Payment Reconciliation Matters?
Export payment reconciliation matters because the amount credited to your bank account when an international client pays an export invoice rarely matches the exact invoice value, and each mismatch has a specific cause that must be recorded separately in Tally. The causes are bank charges, exchange rate differences, agreed deductions or discounts, and partial payments.
- Bank charges: intermediary or correspondent banks deduct fees along the SWIFT route before the funds reach your account, which reduces the credited amount below the invoice value.
- Exchange rate differences: the rate the bank applies on the date of credit differs from the rate booked at invoicing. This gap becomes either a forex gain or a forex loss in Tally.
- Agreed deductions or discounts: credit notes, commercial discounts, or short-shipment adjustments mean the buyer intentionally pays less than the full invoice value. Each one must be documented and mapped in Tally.
- Partial payments: when a buyer pays in instalments or remits an advance against a shipping bill, each receipt must be matched to the correct invoice line rather than treated as a standalone credit.
If these differences aren't recorded correctly, Tally's bank reconciliation will show unexplained mismatches. These flag during CA audits and can delay FEMA compliance submissions.
What Documents Do You Need Before You Start Reconciling in Tally?
The documents you need before reconciling export payments in Tally fall into two categories. For bank reconciliation, you need updated Tally books, the official bank statement, and the previous reconciliation or opening BRS. For GST reconciliation (GSTR-1, GSTR-3B, or GSTR-2B), you need your sales and purchase data from the books of accounts, GST portal returns or JSON files, and credit and debit notes.
For Bank Reconciliation
- Updated Tally books: all receipts, payments, contra entries, bank charges, and interest entries for the specific period must already be recorded in Tally before reconciliation begins.
- Official bank statement: the latest statement for the exact period you're reconciling. It's accepted in digital formats (Excel, CSV, MT940 for auto-import) or as a printed or PDF statement for manual entry.
- Previous reconciliation or opening BRS: the closing balance and uncleared transaction list from the prior period, used to confirm that opening balances match before you reconcile the current period.
For GST Reconciliation (GSTR-1, GSTR-3B, or GSTR-2B)
- Books of accounts sales/purchase data: the sales and purchase registers exported from Tally for the matching return period.
- GST portal returns or JSON files: downloaded portal returns (GSTR-1 or GSTR-2B details) or direct portal sync data via TallyPrime's GST utility.
- Credit and debit notes: documentation for any returns, discounts, price adjustments, or cancellations issued during the period. These affect both the GST filing and the Tally ledger balance.
⚠️ COMMON MISCONCEPTION
Many exporters think the bank statement alone is enough. Without the prior period's BRS, opening balance mismatches go undetected and carry forward as errors.
How Export Reconciliation Works in Tally? A Step-by-Step Guide
Export reconciliation in Tally works by matching recorded export sales invoices, zero-rated GST data, shipping bills, port codes, and bank realisations (e-BRC/FIRC) against GST portal data and bank records. The goal is to confirm zero-rated or Letter of Undertaking (LUT) compliance and close every open invoice in the books. You do it in four steps: record and verify the export invoices, review the GSTR-1 export data, export the return file for portal matching, and reconcile the bank realisation.
Step 1: Record and Verify Export Invoices
- Go to Gateway of Tally > Vouchers > F8 (Sales).
- Select the foreign customer ledger and the sales ledger grouped under Sales Accounts, with the nature of transaction set to either "Exports without Payment of IGST" (for LUT-based exports) or "Exports with IGST."
- Enter the mandatory export parameters in the voucher: HSN/SAC code, GST rate, Shipping Bill Number, Shipping Bill Date, and Port Code.
- Press Ctrl + A to accept and save the voucher.
Exports are zero-rated supplies under GST. No tax is charged on the transaction, but exporters can claim input tax credit on purchases made for export production.
If your business has filed a Letter of Undertaking (LUT), it can export without paying IGST. This must be reflected in the voucher type selection.
Step 2: Access and Review the GSTR-1 Export Data (Table 6A)
- Go to Gateway of Tally > Display More Reports > Statutory Reports > GST > GSTR-1.
- Set the reporting period (F2) to match the filing quarter or month.
- Locate Table 6 – Exports Invoices (6A) to review recorded export entries: taxable values, LUT/Bond flags, port codes, and shipping bill details.
- Use Status Reconciliation (U: Status Reconciliation) to track whether vouchers are "To Be Uploaded," "Uploaded," or "Rejected" by the GST portal.
Step 3: Export the Return File for Portal Matching
- Press Alt + E and select E-Return from the GSTR-1 screen.
- Choose JSON (Data Interchange) or Excel/CSV as the file format and specify the local folder path.
- Cross-check the book-level export sales register against the downloaded summary or JSON from the GST portal. Look for missing shipping bills, mismatched invoice values, or unupdated port codes.
Step 4: Reconcile Bank Realization (e-BRC / FIRC)
- Match against e-BRC or FIRC: match your export commercial invoices against electronic Bank Realisation Certificates (e-BRC) or Foreign Inward Remittance Certificates (FIRC) to confirm that realisations have occurred within the statutory FEMA window (typically 9 months / 270 days).
- Adjustment vouchers: record any bank charges, currency conversion differences, or export incentives (such as RoDTEP or duty drawback scrips) via adjustment vouchers in Tally.
- Forex gain or loss entry: when the INR amount credited by the bank differs from the INR value booked at the invoice date because of exchange rate movement, a forex gain or forex loss entry is mandatory. Skipping this step creates a mismatch in Tally's bank reconciliation and flags during CA audit.
- Example: a $3,000 invoice booked at ₹82.50/USD (₹2,47,500) settles at ₹83.20/USD, crediting ₹2,49,600. The ₹2,100 difference must be recorded as a forex gain entry against the party ledger.
- Isolating export remittances: open Tally's Bank Reconciliation report (Gateway > Banking > Bank Reconciliation) and filter by the foreign currency bank ledger. This isolates only export remittances, so you can spot unmatched entries faster without scrolling through domestic transactions.
What You Need for Complete Export Payment Reconciliation in Tally
| Document | Where It Comes From | What It Proves |
|---|---|---|
| Export Sales Invoice | Tally (F8 Sales Voucher) | Amount owed by foreign buyer |
| Receipt Voucher | Tally (F6 Receipt entry) | Payment received and recorded |
| Bank Statement | Your bank | INR actually credited to account |
| FIRC / e-BRC | Bank / payment platform | Legal proof of foreign inward remittance |
| Forex Gain/Loss Entry | Tally (adjustment voucher) | Rate difference between invoice date and settlement date |
⚠️ COMMON MISCONCEPTION
Many exporters think reconciling Tally's books is enough for compliance. But the bank statement alone does not prove a foreign inward remittance. FIRC or e-BRC is the legal proof, and its reference must match the Tally voucher entry.
How Does Skydo Help Receive International Payments?
Traditional SWIFT wires come with heavy paperwork, unpredictable bank charges, and delayed documentation, and all of these directly slow down Tally reconciliation. Skydo helps Indian exporters receive international payments by acting as a cross-border payment processing layer that removes those three problems.
The core problem Skydo solves is cost you can't predict. Banks and services like PayPal charge up to 8% in hidden fees. Skydo charges a flat $19 under $2,000 and a flat $29 from $2,000 to $10,000, and 0.3% over $10,000. That makes the credited INR amount predictable before the payment even arrives, which removes one of the biggest variables in export reconciliation.
- Free virtual accounts: Skydo offers virtual accounts in USD, EUR, GBP, SGD, AUD, and CAD at no charge, and setup takes 5 minutes. Your foreign-currency bank ledger in Tally maps directly to a real virtual account, so you don't have to chase the bank for account details.
- FIRC for every payment: Skydo auto-generates the FIRC for every payment received, at no charge. This is the document that must match the Tally voucher reference for CA sign-off. Getting a FIRC from a traditional bank after every payment can take days and stall Tally reconciliation, whereas Skydo issues it instantly. It's already in the Skydo dashboard when the payment lands, which keeps the voucher reference and compliance document in sync.
- India-based support: reach the team via WhatsApp, call, and text with no global queue, if a payment or document issue is holding up your month-end reconciliation.
How do I reconcile the ledger difference caused by exchange rate fluctuations between the invoice date and the bank realization date?
Record the difference between the INR booked at the invoice date and the INR credited by the bank on the realisation date as a forex gain or forex loss entry via an adjustment voucher in Tally. This closes the open invoice balance against the actual bank receipt. For example, $3,000 booked at ₹82.50/USD is ₹2,47,500, and the bank credits ₹2,49,600 at ₹83.20/USD, so you pass a forex gain journal entry for ₹2,100 against the party ledger to clear the difference.
How do I account for foreign intermediary bank charges deducted from the total invoice value during bank reconciliation?
Where do I input the FIRC (Foreign Inward Remittance Certificate) or e-BRC reference number in Tally?
How do I adjust a single foreign bank remittance received against multiple export invoices?
How can I use Tally to track the 9-month FEMA deadline for pending export bank realizations?
What should I do if the final amount credited to my bank account doesn't match the shipping bill value?
How do I record an advance export payment received from a foreign client in Tally?
Should I create a separate bank ledger in Tally for an EEFC (Exchange Earners' Foreign Currency) account?
Why is my ledger balance showing a mismatch against the bank's generated e-BRC, and how do I audit it?
How do I handle a partial payment receipt from an overseas buyer in Tally's bank allocation?
