GSTR-2B Reconciliation with Tally: Complete 2026 Guide
Founder, TrulyInvoice — Building AI invoice automation for Tally since 2026
"It's the 18th of the month. GSTR-3B filing is due in 3 days. You export GSTR-2B from the GST portal and compare it with your Tally purchase register. There are 45 invoices in Tally that don't appear in GSTR-2B. Three invoices have mismatched tax amounts. You have no idea which suppliers haven't filed GSTR-1, and no time to chase them before the deadline."
If this scenario sounds familiar, you're not alone. GSTR-2B reconciliation is one of the most time-consuming and error-prone tasks for CA firms and businesses in India. This guide walks through exactly how to reconcile GSTR-2B with Tally systematically, what to do when things don't match, and how to avoid the common mistakes that lead to GST notices.
What is GSTR-2B and Why It Matters
GSTR-2B is an auto-drafted statement generated by the GST portal on the 11th of every month. It shows all Input Tax Credit (ITC) available to you based on GSTR-1 and GSTR-5 returns filed by your suppliers up to the 10th of that month.
Unlike the old GSTR-2A (which was dynamic and changed as suppliers filed revised returns), GSTR-2B is static — once generated, it doesn't change. This makes it more reliable for ITC claims, but it also means you need to reconcile it every month to ensure you're claiming all eligible credit.
Key point: You can only claim ITC for invoices that appear in GSTR-2B. If a supplier hasn't filed GSTR-1 for your purchase, that invoice won't show in GSTR-2B, and you cannot claim ITC for it — even if you have a valid tax invoice.
The GSTR-2B Reconciliation Workflow
Here's the step-by-step process to reconcile GSTR-2B with your Tally purchase register:
Step 1 — Download GSTR-2B from GST Portal
Log in to the GST portal → Services → Returns → GSTR-2B. Select the tax period and download the statement in Excel or JSON format. The statement includes supplier GSTIN, invoice number, invoice date, taxable value, and ITC amount (IGST, CGST, SGST).
Step 2 — Export Purchase Register from Tally
In Tally, go to Display → Statement of Accounts → Purchase Register. Export this to Excel using the Export option. Ensure you include the relevant tax period. Your export should have invoice number, date, supplier GSTIN, taxable value, and tax amounts.
Step 3 — Match Invoices by Invoice Number and GSTIN
Use VLOOKUP or INDEX-MATCH in Excel to match invoices between GSTR-2B and Tally using invoice number and supplier GSTIN as the key. This will show you which invoices appear in both, which are only in Tally, and which are only in GSTR-2B.
Step 4 — Identify Mismatches
For matched invoices, compare the taxable value and ITC amounts. Flag any discrepancies. Common causes: rounding differences, incorrect tax rate application, or data entry errors in Tally.
Step 5 — Categorize Discrepancies
Create three categories: (1) Invoices in Tally but not in GSTR-2B (supplier hasn't filed GSTR-1), (2) Invoices in GSTR-2B but not in Tally (missing in your books), (3) Matched invoices with amount differences.
Step 6 — Take Corrective Action
For category 1: Follow up with suppliers to file GSTR-1. For category 2: Check if the invoice was recorded in a different period or needs to be entered. For category 3: Verify the correct amount and make rectification entries if needed.
Handling Common Reconciliation Issues
Issue: Invoice in Tally but not in GSTR-2B
This means your supplier hasn't filed GSTR-1 for that period. You cannot claim ITC until they file. Send a formal email to the supplier requesting GSTR-1 filing. If they don't respond or refuse, document this communication. You may need to reverse the ITC claimed and pay tax with interest.
Issue: Invoice in GSTR-2B but not in Tally
This could mean the invoice was recorded in a different period, was entered incorrectly, or was never recorded. Check your previous periods' purchase registers. If found, correct the period. If not found, enter the missing invoice with the correct date.
Issue: Taxable value matches but ITC doesn't
This usually indicates a tax rate error. Check if the invoice is interstate (IGST) or intrastate (CGST+SGST). Verify the tax rate applied in Tally matches the supplier's invoice. If the supplier made an error, request a revised GSTR-1.
Issue: Rounding differences of a few paise
Small rounding differences (1-2 paise) are common due to different calculation methods. These are generally acceptable if the difference is immaterial. Document the reason for audit purposes.
How to Reduce Reconciliation Time
Manual reconciliation takes hours. Here's how to speed it up:
- →Use AI invoice automation to reduce data entry errors in Tally
- →Reconcile monthly instead of quarterly — smaller batches are easier to manage
- →Set up Excel templates with pre-built VLOOKUP formulas
- →Use GST reconciliation software that integrates with Tally
- →Follow up with suppliers proactively — don't wait until filing deadline
Best Practices for Clean Reconciliation
- →Always enter the correct invoice date as per the supplier's invoice
- →Verify supplier GSTIN before entry — typos cause mismatches
- →Use the correct tax rate based on HSN code and invoice type
- →Don't claim ITC for invoices from composition dealers or non-GST suppliers
- →Maintain a supplier-wise tracking sheet for GSTR-1 filing status
Reduce Data Entry Errors with AI Automation
TrulyInvoice extracts purchase invoice data with 95%+ accuracy and syncs to Tally with correct GST splits. Start free with 300 vouchers.
Start FreeFrequently Asked Questions
What is GSTR-2B and why is it important for CA firms?
GSTR-2B is an auto-drafted statement of ITC available to a registered person based on GSTR-1 and GSTR-5 filed by suppliers. It shows what ITC you can claim. Reconciling GSTR-2B with your Tally purchase register is critical to ensure you're claiming all eligible ITC and avoid GST notices for mismatched claims.
How often should I reconcile GSTR-2B with Tally?
Ideally, reconcile GSTR-2B with Tally every quarter before filing GSTR-3B. This gives you time to identify missing invoices, follow up with suppliers for GSTR-1 filing, and make corrections before the filing deadline. Monthly reconciliation is even better for high-volume businesses.
What if a supplier hasn't filed GSTR-1 for my purchase invoice?
If an invoice exists in your Tally but not in GSTR-2B, it means the supplier hasn't filed GSTR-1 for that period. You should follow up with the supplier to file their GSTR-1. If they don't file, you cannot claim ITC for that invoice. Document this communication for audit purposes.
How do I handle invoices where the amount in GSTR-2B doesn't match Tally?
Amount mismatches can occur due to rounding differences, tax rate errors, or incorrect invoice details. First, verify the invoice details in both systems. If the error is in Tally, make a rectification entry. If the error is in the supplier's GSTR-1, request them to file a revised return. Document all mismatches for audit trail.
Can TrulyInvoice help with GSTR-2B reconciliation?
TrulyInvoice extracts purchase invoice data with high accuracy and syncs it to Tally with correct GST splits. This reduces data entry errors that cause GSTR-2B mismatches. While TrulyInvoice doesn't directly import GSTR-2B, it ensures your Tally data is clean and accurate, making reconciliation faster.
What is the difference between GSTR-2A and GSTR-2B?
GSTR-2A was a dynamic statement that changed as suppliers filed or revised GSTR-1. GSTR-2B replaced it in 2020 — it's a static, auto-drafted statement generated on the 11th of every month based on returns filed up to the 10th. GSTR-2B is more reliable for ITC claims since it doesn't change after generation.