To solve this problem, I have developed a fully automated Excel-based GST Reconciliation Tool that reconciles Books data with GSTR-2B data at the click of a button — no manual formulas, no copy-pasting, no VLOOKUP headaches. What This Tool DoesThe tool works entirely inside Excel (macro-enabled) and has five simple buttons that automate the entire reconciliation workflow:1. Import 2B Data– Pulls your GSTR-2B data (downloaded from the GST Portal) into the tool. Step 4: Import 2B DataClick on the “Import 2B Data” button and select your cleaned GSTR-2B Excel file. 4 Always follow the sequence: Import Books → Import 2B → Run Reco.