GSTR-2BHow to Reconcile GSTR-2B Using Pivot Table in Excel (2026 Guide)
To reconcile GSTR-2B using an Excel Pivot Table, combine your cleaned Purchase Register (Books) and your GSTR-2B statement into a single Excel worksheet with standardized column headers (Supplier GSTIN, Invoice Number, Invoice Date, Taxable Value, IGST, CGST, and SGST), and add a "Source" column labeling each row as either "Books" or "GSTR-2B"

