=SUM(Sheet1!E2:G2) (CGST+SGST+IGST)
To pull portal values directly into your Purchase Register tab, use an formula matching both the Supplier GSTIN and Invoice Number:
In your sheet, add new columns to pull data from the Portal Data sheet using your unique lookup key. gstr 2a and 3b reconciliation in excel format download
This is a free browser extension that helps users bulk download GST data (GSTR1, GSTR2A, GSTR2B, GSTR3B, GSTR9) in Excel, PDF & JSON formats. It can be a time-saver for downloading multiple returns at once.
| Issue | Excel Fix | |-------|------------| | Supplier changed GSTIN | Use fuzzy matching or manually verify | | Invoice date format mismatch | Use DATEVALUE and standardize | | Duplicate entries in GSTR-3B | Use Remove Duplicates based on invoice number + GSTIN | | IGST treated as CGST+SGST | Create helper column to normalize tax type | | Missing debit/credit notes | Append separate sheet for amendments | =SUM(Sheet1
Extract your internal purchase register (or "GSTR-3B ITC Claimed Ledger") directly from your accounting software (like Tally, Zoho Books, or SAP).
– This is your primary dashboard where the matching calculations occur. 2. Standardize Your Data Layout | Issue | Excel Fix | |-------|------------| |
Go to the Official GST Portal and log in with your credentials. Navigate to > Returns > Returns Dashboard .