GSTR-2B Reconciliation in TallyPrime 6.0: 8 Mins to Match

The GST portal's GSTR-2B is live, but your purchase entries in TallyPrime 6.0 might not match. This mismatch can lead to denied Input Tax Credit (ITC) claims. Many CAs spend hours manually comparing lists. By the end of this article, you will know how to reconcile your GSTR-2B data in TallyPrime 6.0 in under 10 minutes. You will learn to identify missing invoices and correct discrepancies efficiently.

What is GSTR-2B Reconciliation?

Think of GSTR-2B reconciliation like matching your bank statement to your cheque book. GSTR-2B shows ITC available from suppliers' filings. Your TallyPrime purchase entries are your cheque book. Reconciliation ensures these two match precisely. This prevents claiming ITC you aren't eligible for. It also helps you claim all eligible ITC. Proper reconciliation is key for accurate GST returns.

How to Reconcile GSTR-2B in TallyPrime 6.0 — Step by Step

1. Download GSTR-2B JSON from GST Portal. Log in to the GST portal. Navigate to Services > Returns Dashboard. Select the period and click 'Download GSTR-2B'. Choose the JSON format. Save it to an accessible folder. Tally tip: Keep a dedicated folder for your monthly GST downloads.
2. Import JSON into TallyPrime 6.0. From the Gateway of Tally, press 'I' for Import. Select 'GST Returns'. Choose 'GSTR-2B'. TallyPrime 6.0 will prompt for the file path. Browse and select your downloaded JSON file. Watch out: Ensure you select the correct JSON file for the period.
3. Access the GSTR-2B Reconciliation Report. After import, TallyPrime 6.0 often navigates here automatically. If not, go to Gateway of Tally > Display More Reports > Statutory Reports > GST > GSTR-2B Reconciliation. Press 'F2' to confirm the period. Tally tip: Use 'F3' for multi-GST registration if applicable.
4. Analyse the Reconciliation Screen. You'll see portal data (blue) and your book data (default colour). Key sections are 'Transactions Available in Books', 'Transactions Available on Portal', and 'Transactions Available on Portal Only'. Watch out: 'Portal Only' items are potential missing purchase vouchers.
5. Investigate Mismatches. Click on 'Transactions Available on Portal Only' to see missing invoices. Compare details with your purchase register. If a supplier has filed, but it's not in your TallyPrime 6.0, create the voucher. Tally tip: Ensure GSTINs and invoice numbers are exact.
6. Review 'Mismatched Transactions'. These appear in both your books and the portal but have differences. Drill down to identify the exact mismatch type (e.g., value, date). Correct your TallyPrime 6.0 entries as needed. Watch out: Don't simply ignore these; they impact your ITC claim.

Mistakes That Cost Indian CAs Hours

• Mistake: Manually comparing Excel exports from Tally and the GST portal. What breaks: Massive time loss, high error rate. Fix: Use TallyPrime 6.0's direct JSON import feature. It automates 90% of the matching.
• Mistake: Not investigating invoices appearing only on the GST portal. What breaks: You miss eligible ITC, and suppliers might have filed incorrectly. Fix: Create missing purchase vouchers in TallyPrime 6.0 for all valid 'Portal Only' items.
• Mistake: Reconciling April's GSTR-2B with March's Tally data. What breaks: False mismatches and confusion. Fix: Always use 'F2' in TallyPrime 6.0 to set the exact month for both portal download and report viewing.
• Mistake: Assuming all supplier GSTINs in GSTR-2B are correct. What breaks: If a GSTIN is wrong on the portal, your ITC might be blocked. Fix: Cross-check supplier GSTINs in GSTR-2B against your vendor master in TallyPrime 6.0.

Pro Tips for 2026

Schedule reconciliation for the 1st week of every month. This aligns with the GSTR-2B availability. Automating the import process significantly speeds up your workflow. For complex cases with many mismatches, consider dedicated tools that streamline data handling. Synergy Automation offers a free way to post directly to TallyPrime 6.0 without XML files, simplifying the import step.