How to Reconcile GST Returns with Purchase Invoices

Reconciling your GST returns with purchase invoices before filing ensures that the input tax credit (ITC) you claim matches the invoices your suppliers have actually reported. This prevents mismatches, reduces the risk of notices, and keeps your books accurate. You’ll need your GSTR-2B or equivalent purchase register, your purchase invoice ledger, and a GST reconciliation tool or spreadsheet.

What You’ll Need

Your GSTR-2B (auto-drafted purchase data) or your purchase register from your accounting software.
The list of purchase invoices for the tax period (both inward and reverse charge).
Your GST login credentials (for the GST portal).
A spreadsheet (Excel, Google Sheets) or accounting software with reconciliation features.
Supplier-wise GSTIN and invoice numbers for cross-verification.

Step-by-Step

Download your GSTR-2B for the period. Log in to the GST portal, go to Returns > GSTR-2B, and download the PDF or Excel file for the relevant tax period. This shows all supplier invoices that have been reported by your suppliers.
Export your purchase register. From your accounting software, export a list of all purchase invoices for the same period, including supplier GSTIN, invoice number, date, taxable value, and GST amount.
Set up a reconciliation sheet. In a spreadsheet, create columns for: Supplier GSTIN, Invoice Number, Invoice Date, Taxable Value, CGST, SGST, IGST, and a status column. Paste both your purchase register and the GSTR-2B data into this sheet, side by side.
Match each invoice. Use a VLOOKUP or a simple sort to match invoices by supplier GSTIN and invoice number. Mark each as ‘Matched’ if the details (taxable value, GST amount) match exactly.
Identify missing invoices. Highlight invoices that appear in your purchase register but not in GSTR-2B. These are ‘missing’ – your supplier may not have filed their return or may have reported a different invoice.
Identify extra invoices. Highlight invoices in GSTR-2B that are not in your purchase register. These could be duplicate entries, or you may have missed recording them.
Check for mismatches. For invoices that appear in both but with different amounts, note the difference. Common reasons: supplier reported a different taxable value, or you claimed a different rate.
Reconcile with suppliers. Contact your suppliers for any missing or mismatched invoices. Ask them to file or amend their returns so that the correct invoice appears in your GSTR-2B.
Adjust your books. If a supplier cannot correct the data before the due date, you may need to reverse the ITC claimed on that invoice in your current return, or claim it in a later period once it appears.
File your return. Once all differences are resolved or documented, file your GSTR-3B (or equivalent) claiming ITC only on the matched invoices, plus any that you are confident are correct but not yet in GSTR-2B (if you have proper evidence).

Common Mistakes

Ignoring small mismatches. Even a ₹1 difference can cause a notice. Always investigate and resolve.
Claiming ITC on invoices not in GSTR-2B. This is risky; if the supplier hasn’t filed, you may have to reverse it later with interest.
Not checking reverse charge. For reverse charge purchases, you must pay tax and claim ITC yourself – these may not appear in GSTR-2B but must be recorded.
Using the wrong period. Ensure you are reconciling the correct tax period – invoices dated in the previous period might appear in the next GSTR-2B.
Forgetting to reconcile IGST vs CGST/SGST. A mismatch in tax type can cause the same issue as a value mismatch.

Tips

Reconcile monthly, not annually. Doing it monthly keeps the task manageable and prevents backlog.
Use a tool. Many accounting software have built-in GST reconciliation that auto-matches invoices. If you use spreadsheets, learn VLOOKUP or XLOOKUP.
Keep a log of unresolved items. Maintain a separate sheet for ‘pending’ items with notes on supplier contact and expected resolution date.
Download GSTR-2B early. The portal generates it by the 12th of the next month, but it may update later. Check again before filing.
Prioritize high-value invoices. If you have many invoices, focus on the largest ones first – they have the biggest impact on your ITC.

Troubleshooting

Invoice appears in GSTR-2B but not in your books. This could be a purchase you forgot to record, or a duplicate by the supplier. Check your records; if it’s genuine, record it and claim ITC. If not, ask the supplier to reverse it.
Invoice in your books but not in GSTR-2B. First, confirm the supplier has filed their return. If they haven’t, ask them to file. If they have, ask them to check if they reported the correct invoice number – a typo can cause a mismatch.
Amounts differ. Compare the taxable value and tax rate. The supplier may have applied a different rate (e.g., 12% instead of 18%). Ask them to amend their return.
GSTR-2B is not updated. Sometimes suppliers file late, so GSTR-2B may not include their invoices until after the 12th. Wait a few days and re-download.
You can’t log in to the portal. Clear your cache, try a different browser, or use the ‘Forgot Password’ option. If the portal is down, wait and try later.

Frequently Asked Questions

Q: What if I claim ITC on an invoice that is not in GSTR-2B?
A: You can claim it if you have the invoice and the supplier has filed their return, but it’s not yet reflected. However, if the supplier hasn’t filed, you may need to reverse it later. It’s safer to wait or claim only after confirming.

Q: Do I need to reconcile every single invoice?
A: Yes, it’s best practice. Even small mismatches can trigger notices. Automate the process if possible.

Q: What is the due date for reconciling?
A: You should reconcile before filing your GSTR-3B, which is typically due by the 20th of the next month. But GSTR-2B is available by the 12th, so you have about a week.

Q: Can I claim ITC on a debit note?
A: Yes, debit notes are treated as invoices. They should be reconciled similarly, and they appear in GSTR-2B as a separate document type.

Q: What if a supplier refuses to correct a mismatch?
A: You can still claim ITC if you have the invoice and evidence of payment, but you may face a notice. It’s better to resolve it. If not, you may have to reverse the ITC to avoid penalties.

Q: Is there a time limit to claim ITC?
A: Yes, you can claim ITC for a financial year up to the due date of filing the return for September of the next year. After that, you lose the ITC.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →