GSTR-2B vs Books Reconciliation in Excel | Power Query Automation (Step-by-Step) | Stop Manual Recon

In this video, we will learn how to reconcile GSTR-2B with Purchase Register (Books) using Power Query in Excel. This method will help you automate your GST reconciliation process and save hours of manual work every month. We have used a practical example where Purchase Register has 58 entries and GSTR-2B has 80 entries, and we identified mismatches using Power Query automation. 🔍 Topics Covered: GSTR-2B vs Books reconciliation Data cleaning in Power Query Merge Queries (Matching Logic) Identifying mismatch entries ITC Available vs Not Available Full automation process ⚡ Benefits: Save 4–5 hours every month Reduce manual errors Improve accuracy in ITC claims 🎯 This video is useful for: GST professionals Accountants Finance students Anyone working on GST reconciliation 🔔 Subscribe for more videos on: Power Query, Power BI, Excel Automation & GST Practical Learning #gst #gstr2b #powerquery #excelautomation #GSTReconciliation #powerbi #powerqueryeditor #automation #excel