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.
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.
How do you currently reconcile GSTR-2B — do you use this free portal tool, an Excel macro, or third-party paid software? Let me know in the comments!
📌 Key Takeaways & Quick Links:
• Don't claim ITC directly from books without 2B matching to avoid Sec 50 interest & demand notices.
• Always match invoice numbers & GSTINs before filing GSTR-3B.
🔔 Subscribe for practical GST, Income Tax, TDS, TCS & Accountancy updates:
https://www.youtube.com/@cadeveshthakur?sub_confirmation=1
📚 Join my WhatsApp Channel for FREE resources, notes, PDFs and more:
https://whatsapp.com/channel/0029Va6GOVE9MF92Ylmo7e0L