How to Reconcile GSTR-2B with Tally Prime

Your input tax credit isn’t just based on what you’ve recorded as purchases in Tally Prime — it’s also dependent on your suppliers actually reporting those same invoices in their own GST filings. GSTR-2B is the auto-generated statement that shows what your suppliers have reported against your GSTIN, and reconciling it against your own purchase records is one of the most important regular checks for protecting your input tax credit.

This guide covers how to approach this reconciliation using your Tally Prime purchase data.

Why GSTR-2B Reconciliation Matters

Under current GST rules, input tax credit is generally available only to the extent it’s reflected in your GSTR-2B (subject to specific conditions and exceptions, so always confirm current rules for edge cases). This means a purchase you’ve correctly recorded in Tally Prime, with a perfectly valid invoice, can still create a credit mismatch if your supplier hasn’t filed their return on time, or has reported the invoice incorrectly on their end.

Doing this reconciliation regularly — not just before filing GSTR-3B — gives you time to follow up with suppliers before deadlines, rather than discovering a gap at the last moment.

What You Need Before You Start

• Tally Prime installed, with your purchase entries recorded for the period — see our guide on how to record purchase and sales entries in Tally Prime
• Your GSTR-2B downloaded from the GST portal for the relevant period
• A consistent way of identifying invoices across both sources — typically invoice number, supplier GSTIN, and invoice date

Step 1: Export Your Purchase Register from Tally Prime

1. Gateway of Tally, then Display More Reports, then Day Book or the relevant Purchase Register, filtered for the period you’re reconciling
2. Export this in a format suitable for comparison — Excel is commonly used for this manual reconciliation step
3. Make sure the export includes supplier GSTIN, invoice number, invoice date, taxable value, and tax amounts split by CGST/SGST/IGST

Step 2: Download GSTR-2B for the Same Period

1. Log in to the GST portal
2. Navigate to Returns Dashboard, then GSTR-2B for the relevant period
3. Download the detailed statement, which lists every invoice your suppliers have reported against your GSTIN

Step 3: Match Invoices Between the Two Sources

1. Match each invoice from your Tally Prime purchase register against the corresponding entry in GSTR-2B, primarily using supplier GSTIN and invoice number as the matching keys
2. Confirm the taxable value and tax amounts align between both sources for matched invoices
3. Flag any invoice from Tally Prime that doesn’t appear in GSTR-2B at all
4. Flag any invoice in GSTR-2B that doesn’t appear in your Tally Prime records

Step 4: Investigate Invoices in Tally Prime but Missing from GSTR-2B

This is the category that most directly affects your available input tax credit:

1. Confirm the purchase was genuinely recorded correctly in Tally Prime (correct GSTIN, invoice number, date)
2. Reach out to the supplier to check whether they’ve actually filed their GSTR-1 for the relevant period, or whether they reported the invoice with an error (wrong GSTIN, wrong invoice number) that’s preventing it from matching
3. Follow up for correction if the supplier hasn’t filed, or has filed incorrectly, since this credit may not be available to you until it’s properly reflected in GSTR-2B
4. Keep a log of unresolved invoices and follow up periodically rather than letting them sit indefinitely

Step 5: Investigate Invoices in GSTR-2B but Missing from Tally Prime

1. Check whether this is a genuine purchase you simply haven’t recorded yet in Tally Prime — if so, record it
2. Check whether it’s a transaction that doesn’t actually belong to your business (an error on the supplier’s end, reporting against the wrong GSTIN)
3. If it’s not yours, don’t claim credit on it, and consider informing the supplier of their reporting error

Step 6: Reconcile Before Filing GSTR-3B

1. Use the results of this reconciliation to inform what input tax credit you actually claim in that period’s GSTR-3B — see our guide on how to file GSTR-3B from Tally Prime
2. Where credit isn’t yet reflected in GSTR-2B, consult your tax advisor on current rules regarding whether and when you can claim it, since timing rules for this have been subject to change

Step 7: Build a Recurring Reconciliation Routine

1. Rather than treating this as a once-a-period scramble, set a recurring schedule (commonly monthly, alongside your regular purchase recording) to download and compare GSTR-2B against your Tally Prime records
2. The earlier a mismatch is caught, the more time you have to resolve it with the supplier before it affects your filing

Common Mistakes to Avoid

• Claiming input tax credit purely based on having a valid-looking invoice, without checking whether the supplier has actually reported it in their GSTR-1
• Only reconciling right before the GSTR-3B deadline, leaving no time to chase suppliers for correction before you need to file
• Not maintaining a consistent invoice numbering and recording practice in Tally Prime, making automated or even manual matching against GSTR-2B harder than it needs to be
• Assuming a mismatch is always the supplier’s fault, when sometimes the error is on your own recording side (wrong GSTIN entered, incorrect invoice number)
• Letting unresolved mismatches accumulate across many periods without follow-up, turning a manageable monthly task into an overwhelming backlog

FAQs

Can I claim input tax credit on an invoice that’s in my books but not yet in GSTR-2B? This depends on current GST rules, which have specific provisions and conditions around this. It’s an area worth confirming with your tax advisor for your specific situation, since rules around provisional or conditional credit have changed over time.

How often should I reconcile GSTR-2B against my Tally Prime records? Monthly is generally recommended, ideally aligned with your regular purchase recording cycle, so mismatches are caught and addressed early rather than discovered at filing deadlines.

What’s the difference between GSTR-2A and GSTR-2B? GSTR-2A is a dynamic, continuously updated statement reflecting supplier filings as they happen. GSTR-2B is a more static, period-locked statement generated at a specific point, generally used as the reference for claiming input tax credit for a given period. Always confirm current rules on which one governs your credit eligibility.

What should I do if a supplier refuses to correct a reporting error? Document your communication attempts and the discrepancy clearly, and consult your tax advisor on the appropriate next steps, since unresolved supplier-side errors can have a direct impact on your available credit.

Does Tally Prime automatically reconcile against GSTR-2B for me? Depending on your release and any connected GST reconciliation tools or services, some automation may be available. The manual comparison process described in this guide applies broadly regardless of whether you’re using such tools, since understanding the underlying process helps you verify any automated results too.