Free GSTR 2B Reconciliation Tool

CA Devesh Thakur

CA Devesh Thakur

34,796 views

Learn how to reconcile GSTR-2B with your Purchase Register using the 100% Free GST Offline Matching Tool provided by the GST Portal. ‪@cadeveshthakur‬

If your books show an ITC of ₹2,11,000 but your GSTR-2B only shows ₹1,40,000, you could be sitting on costly mismatches or missed credit notes! In this video, CA Devesh Thakur walks you step-by-step through exporting purchase data from Tally, downloading your GSTR-2B JSON, setting up the official Excel template, and resolving unmatched invoices, round-off differences, and credit note adjustments to avoid Section 50 interest and GST notices.

📌 What You Will Learn in This Video:
How to export purchase registers with GSTIN & supplier invoice numbers from Tally
How to download GSTR-2B JSON files correctly from the GST Portal
Step-by-step guide to installing & using the Free GST Matching Offline Tool (v2.9)
Identifying Exact Matches, Unmatched Invoices, and Credit Notes in GSTR-2B vs Books
How to treat excess ITC and prevent GST notice under Section 16(2)(aa)
⏱️ Timestamps / Video Chapters:
00:00 - The ₹70,000 ITC Mismatch Problem
01:03 - Step 1: Export Purchase Register from Tally (Columnar Settings)
02:59 - Step 2: Download GSTR-2B JSON from GST Portal
04:21 - Step 3: Download & Setup Free GST Offline Matching Tool
05:53 - How to Fill the Excel Template & Avoid Common Errors
07:04 - Step 4: Import Data & Run 2B vs PR Matching
08:54 - Reading Results: Exact Matches vs Unmatched Invoices
10:39 - Handling Credit Notes & Invoices Not in Books
12:30 - Final ITC Summary & Avoiding Section 50 Interest

💡 Useful GST Resources & Queries Solved:
GSTR 2B Reconciliation Kaise Kare
Free GSTR 2B Matching Offline Tool Tutorial
Purchase Register vs GSTR-2B Matching in Tally
GST ITC Reconciliation Process for Accountants & CAs
👍 Don't forget to Like, Share, and Subscribe to CA Devesh Thakur for practical GST, Income Tax, and accounting tutorials!

#GST #GSTR2B #GSTR2BReconciliation #InputTaxCredit #GSTOfflineTool #TallyPrime #CADeveshThakur #Accounting

🔔 Subscribe for practical GST, Income Tax, TDS, TCS & Accountancy updates:
[@cadeveshthakur]

📚 Join my WhatsApp Channel for FREE resources, notes, PDFs and more:
[https://whatsapp.com/channel/0029Va6G...]

🌐 Connect Everywhere:

📌 Instagram → [Instagram: cadeveshthakur.official]
📌 YouTube → [@cadeveshthakur]
📌 LinkedIn → [LinkedIn: cadeveshthakur]
📌 Facebook → [Facebook: cadevesh]
📌 X (Twitter) → [https://x.com/cadeveshthakur]
📌 Pinterest → [Pinterest: cadevesht]
📌 Threads → [https://www.threads.com/@cadeveshthak...]
📌 WhatsApp Channel → [https://whatsapp.com/channel/0029Va6G...]
🔔 Subscribe & Follow to stay ahead in GST, Income Tax & Finance.

Disclaimer: The content shared on this channel is purely for educational purposes. As a Chartered Accountant, I strive to provide accurate and insightful information related to GST, income tax, accounting, and tax planning. However, please note that the content should not be considered as professional advice or a substitute for personalized consultation.