=Sheet3!F2 - Sheet3!E2
, you can download the raw data in Excel format from the portal and use professional templates or Excel functions like Pivot Tables to reconcile them. GST.gov.in 1. Download Raw Data from GST Portal gstr 2a and 3b reconciliation in excel format download
: Export your internal purchase records from your accounting software (e.g., Tally, SAP, Zoho). Format Your Sheet : Create columns for: Supplier GSTIN Invoice Number & Date Taxable Value Tax Amount (IGST, CGST, SGST) Status (Matched, Mismatched, Missing in 2A, etc.). Apply Excel Formulas : =Sheet3