Reconcile Export Invoices with GST Returns

This guide walks you through matching your export invoices against the figures reported in your GST returns before you file a refund claim. You’ll learn how to verify that every export is correctly recorded, that the right shipping documents support it, and that your refund application matches the data already filed with the tax authority. By the end, you’ll have a clear checklist that reduces the risk of rejection or delay.

What You’ll Need

• Copies of all export invoices issued during the relevant period
• Your filed GST returns (GSTR-1 and GSTR-3B, or the equivalent for your jurisdiction) for the same period
• Shipping bills or export manifests (proof of export)
• Bank statements or FIRC (Foreign Inward Remittance Certificate) showing receipt of export proceeds
• Your GST registration certificate and IEC (Import Export Code) number
• A spreadsheet or accounting software to track the reconciliation

Step-by-Step

1. Pull your export invoice list. Export all invoices marked as zero-rated or export from your accounting system for the period you want to claim. Include invoice number, date, buyer name, invoice value in foreign currency, exchange rate, and total amount in INR (or your local currency).
2. Extract the same data from your GST returns. In GSTR-1, go to Table 6A (or the export section) and list all export invoices you reported. Note the invoice numbers and values. In GSTR-3B, check that the total export turnover in Table 3.1(b) matches the sum of your export invoices.
3. Match each invoice one-to-one. For every export invoice, find the corresponding entry in GSTR-1. Verify that the invoice number, date, and value (after currency conversion) are identical. If any invoice is missing from the return, you must file a correction or amendment before claiming a refund.
4. Verify the export proof. For each invoice, match it with the shipping bill or export manifest. The shipping bill number and date should be recorded on the invoice or in your export documents. The goods must have actually left the country within the allowed time (usually 90 days from the invoice date, but check your local rules).
5. Check receipt of payment. Confirm that the foreign currency payment has been received in your bank account. If not received yet, you may still be eligible if you have a FIRC or a bank certificate showing the receipt within the prescribed period. If payment is late, you may need to pay interest or reverse input tax credit.
6. Calculate the refund amount. The refund for exports is typically the input tax credit (ITC) on inputs and input services used in making the exported goods. Sum up the eligible ITC from your GSTR-3B for the period. This should not exceed the export turnover multiplied by the rate of tax (for zero-rated supplies) or the accumulated ITC balance.
7. Prepare the refund application. In most jurisdictions, you file Form RFD-01 (or the equivalent) online. Attach the reconciliation statement (Annexure A) that lists each export invoice, the shipping bill number, and the amount claimed. Ensure the total claimed matches the sum of the invoices you’ve verified.
8. Submit and track. File the refund application on the GST portal. Note the ARN (Application Reference Number). Track its status. If the tax officer asks for clarification, respond promptly with the supporting documents you’ve already compiled.

Common Mistakes

• Missing invoices in GSTR-1: Often, export invoices are not reported in the return because they were accidentally omitted or recorded as domestic sales. This causes a mismatch and refund rejection.
• Currency conversion errors: Using the wrong exchange rate (e.g., the rate on the invoice date vs. the rate on the shipping bill date) leads to value mismatches. Always use the rate prescribed by the tax authority (usually the RBI reference rate on the date of invoice).
• Shipping bill not linked: The shipping bill number must be mentioned in the refund application. If it’s missing or incorrect, the claim is invalid.
• Claiming refund on unpaid exports: If the export proceeds are not received within the allowed period, you may have to reverse the ITC claimed or pay interest. Don’t claim refund until payment is received.
• Ignoring time limits: Refund applications must be filed within two years from the end of the quarter in which the export took place. Missing this deadline forfeits the claim.

Tips

• Reconcile monthly, not quarterly. Do this check every month to catch errors early, rather than facing a pile of mismatches at quarter-end.
• Use a reconciliation template. Create a spreadsheet with columns: Invoice No, Date, Buyer, Currency, Amount, Exchange Rate, INR Value, GSTR-1 Value, Shipping Bill No, Payment Received (Y/N). This makes the process systematic.
• Keep all documents in a single folder. Store invoices, shipping bills, bank statements, and FIRCs together, both physical and digital, for easy access during verification.
• Double-check the ITC eligibility. Ensure that the input tax credit you’re claiming is only on inputs that are directly used in the exported goods. Blocked credits (e.g., on motor vehicles, food, or personal expenses) cannot be refunded.
• File amendments promptly. If you find a missing invoice in GSTR-1, file a correction in the next return period. Don’t wait until you’re ready to claim the refund.

Troubleshooting

Mismatch between invoice and GSTR-1: If a specific invoice is not in GSTR-1, check if you accidentally reported it as a domestic sale. If so, you need to amend the return. If it’s genuinely missing, file a revision. Do not claim refund for that invoice until it appears in a corrected return.

Refund application rejected due to “invalid shipping bill”: This usually means the shipping bill number or date doesn’t match the customs data. Verify the exact number (including any prefixes) and the date. If the shipping bill was issued after the invoice date, ensure the gap is within the allowed period. Contact your customs broker if needed.

Payment not received but you need the refund: Some jurisdictions allow refunds before receipt of payment if you provide a bank guarantee. However, this is not common. The safest route is to wait for the payment to be credited, then claim. If the payment is overdue, consider following up with the buyer.

Refund amount less than expected: This could be because the ITC available is lower than your claim, or because the system has automatically reduced the claim due to a mismatch in the export turnover. Recalculate using the formula: Refund = (Eligible ITC) x (Export Turnover / Total Turnover). If the result is lower, adjust your claim accordingly.

Frequently Asked Questions

Can I claim a refund before the export proceeds are received?

In most cases, no. The refund is contingent on the export actually happening and the payment being received within the prescribed period (usually 90 days). If payment is delayed, you may need to reverse the ITC and claim later.

What is the time limit for filing a refund claim?

You must file the refund application within two years from the end of the quarter in which the export took place. For example, if the export occurred in July 2024 (Q2), the deadline is September 30, 2026.

Do I need to file a separate refund for each export invoice?

No, you can file one refund application covering multiple export invoices for the same period. The application should include a list of all invoices with their details.

What if I made a mistake in the GSTR-1 after filing?

You can amend the return in the next filing period. For exports, you can correct the details in the next GSTR-1. The refund claim should be based on the corrected figures.

Is there a minimum amount for a refund claim?

Some jurisdictions have a minimum threshold (e.g., ₹1000). If your claim is below that, you may not be able to file. Check your local rules.

Can I claim refund on services exported as well?

Yes, exports of services are also eligible for refund of input tax credit, provided you have the necessary documentation (e.g., export of services declaration, FIRC). The same reconciliation process applies.

Related

• Last Stop Events Schedule: What to Expect
• User Does Not Have Access Privileges: Fix
• WordPress MySQL and MariaDB Version Requirements