GST Return Reconciliation with Invoices & E-Way Bills

Reconciling your GST returns with invoices and e-way bills ensures that the sales, purchases, and movement of goods reported to the tax department match your actual business records. This process helps you avoid penalties, claim accurate input tax credit (ITC), and reduces the chance of receiving notices for mismatches. Before you start, ensure you have access to your GST portal login, your accounting software or sales/purchase register, and a consolidated list of all e-way bills generated during the period.

What You’ll Need

• GST portal login credentials (for GSTR-1, GSTR-3B, and GSTR-2B)
• Access to your accounting software or a manually maintained sales and purchase register
• A list of all e-way bills generated during the relevant period (available on the e-way bill portal or through your transport management system)
• A spreadsheet tool (like Excel or Google Sheets) or reconciliation software
• Copies of all tax invoices issued and received

Step-by-Step

1. Download your GSTR-1 and GSTR-3B from the GST portal. Go to the ‘Returns Dashboard’ for the relevant tax period, download the JSON or PDF files for GSTR-1 (outward supplies) and GSTR-3B (summary return). Also download GSTR-2B (auto-drafted ITC statement) for the same period.
2. Export your sales and purchase registers from your accounting software. Ensure the data includes invoice number, date, GSTIN of the counterparty, taxable value, GST rate, and the amount of CGST, SGST, and IGST.
3. Reconcile outward supplies (sales) between GSTR-1 and your sales register. Use a spreadsheet formula like VLOOKUP or a reconciliation tool to match invoices by invoice number and GSTIN. Flag any invoice that appears in one but not the other.
4. Verify the summary totals in GSTR-3B match GSTR-1. The total taxable value and tax liability reported in Table 3.1(a) of GSTR-3B should equal the sum of all outward supplies in GSTR-1. If they differ, identify the missing or extra invoices.
5. Reconcile inward supplies (purchases) between GSTR-2B and your purchase register. GSTR-2B shows the ITC that suppliers have reported in their GSTR-1. Match each purchase invoice to the corresponding entry in GSTR-2B. Note that GSTR-2B may not include all purchases if the supplier hasn’t filed their return, so you’ll need to follow up with them.
6. Cross-check e-way bills with outward invoices. For each e-way bill generated during the period, verify that it corresponds to a valid tax invoice. The invoice number, date, and consignor/consignee GSTIN should match. Also, ensure that the value on the e-way bill matches the invoice value.
7. Reconcile e-way bills with inward invoices. For purchases where transport was involved, check that the e-way bill details (especially the supplier’s GSTIN and invoice number) match your purchase invoice. This helps confirm that the supply was actually received.
8. Investigate and resolve discrepancies. For each mismatch, determine the cause: data entry errors, missing invoices, cancelled e-way bills, or supplier non-compliance. Correct the errors in your books and, if necessary, file a revised return (if the period is still open) or adjust in the next period.
9. Document your reconciliation. Keep a working paper that lists all matched and unmatched invoices, along with reasons for any differences. This is essential if you receive a notice from the tax department.
10. File your return only after reconciliation is complete. Ensure that the figures in GSTR-3B are accurate and consistent with GSTR-1 and your books before submitting.

Common Mistakes

• Reconciling only totals, not line items. A total can match even if individual invoices are wrong. Always match at the invoice level.
• Ignoring e-way bill expiry. An e-way bill that has expired before delivery may indicate a violation, but it doesn’t necessarily mean the sale is invalid. Still, you should note it.
• Not checking for duplicate invoices. Duplicate entries can inflate both sales and purchases. Use invoice number and date as a composite key to spot duplicates.
• Assuming GSTR-2B is complete. GSTR-2B only contains supplies reported by your suppliers. If a supplier hasn’t filed, you won’t see the ITC. You must follow up with them.
• Mixing up GSTINs, especially for branches. Each registered place of business has a distinct GSTIN. Ensure you are matching invoices to the correct GSTIN.

Tips

• Reconcile monthly, not just at year-end. It’s much easier to fix errors while the period is still open.
• Use a consistent invoice numbering scheme. Avoid gaps in numbering, as that makes reconciliation simpler.
• Automate the process with reconciliation software if you have a high volume of transactions. Many accounting tools have built-in GST reconciliation modules.
• Keep a separate register for e-way bills, noting the invoice number, e-way bill number, and date of generation.
• Train your staff on the importance of accurate data entry. Most mismatches are due to simple typos.

Troubleshooting

• Mismatch between GSTR-1 and GSTR-3B: If the totals don’t match, check if you’ve missed any amendments or debit/credit notes. Also, verify that you haven’t included any cancelled invoices in GSTR-1.
• Invoice not appearing in GSTR-2B: This means your supplier hasn’t filed their GSTR-1 or has reported the invoice incorrectly. Contact the supplier and ask them to file or correct. If they don’t, you may have to pay the ITC with interest, so act quickly.
• E-way bill details don’t match invoice: If the e-way bill was generated with a wrong invoice number, you can’t edit it. You may need to cancel and regenerate the e-way bill, but only if the goods are still in transit. If not, document the discrepancy.
• Duplicate entries in your register: Use conditional formatting in Excel to highlight duplicates based on invoice number and date. Remove the duplicates and adjust the totals.
• Negative values or credit notes: Ensure credit notes are properly recorded and reflected in both GSTR-1 and your books. A credit note reduces the taxable value, so it should be shown as a negative or in the appropriate section.

Frequently Asked Questions

What is the difference between GSTR-1 and GSTR-3B?

GSTR-1 is a detailed statement of all outward supplies (sales) filed by the 11th of the next month. GSTR-3B is a summary return filed by the 20th, which includes both outward supplies and ITC claimed. Both must be consistent.

Can I claim ITC if the supplier hasn’t filed GSTR-1?

No, you can only claim ITC if the supplier has filed GSTR-1 and the invoice appears in your GSTR-2B. Otherwise, the credit is not available.

What if I find a mismatch after filing GSTR-3B?

You can rectify the error in the next tax period’s return, provided you have not claimed excess ITC or underpaid tax. If the error is in your favor, you can adjust it; if not, you may need to pay interest.

Is it mandatory to reconcile e-way bills with GST returns?

While not explicitly required in the GST law, it’s a good practice because the tax department’s analytics often compare e-way bill data with returns to detect discrepancies.

How do I handle e-way bills for exempt or nil-rated goods?

E-way bills are required for goods with a value above a threshold (₹50,000) regardless of GST rate, unless exempted. For exempt goods, you still need an e-way bill if the value exceeds the threshold, but the GST liability is nil.

What is the penalty for mismatch in GST returns?

Penalties vary, but for incorrect or incomplete returns, a penalty of ₹10,000 (₹2,000 for CGST and ₹2,000 for SGST, up to ₹10,000 total) may apply. Additionally, interest at 18% per annum is charged on unpaid tax.

Related

• Borderlands 4: Defeat Dr. Elena Smith Boss
• TV-B-Gone: How It Works, Range & TV Compatibility
• Web Page Hijacking: Types & How It Happens