: Serves as a documented record of due diligence, which is crucial when responding to tax notices like GST ASMT-10. assets1.cleartax-cdn.com How to Download from the GST Portal
: A supplier might have filed an invoice under CGST/SGST instead of IGST by mistake. The total tax matches, but the component categories fail reconciliation. Streamlining the Process gstr 2a and 3b reconciliation in excel format download
– Paste your internal books of accounts data here. : Serves as a documented record of due
: A community-contributed Excel tool that identifies missing ITC and shortage/excess filing by suppliers. Download from TaxGuru CAclubindia Utility Streamlining the Process – Paste your internal books
Invoice No | Supplier | 2A Tax | 3B Claim | Diff | Status INV-001 | 27AAACA123 | 1800 | 1800 | 0 | Matched INV-002 | 27AAACB456 | 900 | 0 | -900 | ITC Missed INV-003 | 27AAACC789 | 5400 | 5400 | 0 | Matched TOTAL | | =SUM(C2:C4) | =SUM(D2:D4) | =C5-D5 |
: Export your purchase data from your accounting software (e.g., Tally) into a standard Excel format. Use Key Formulas VLOOKUP / XLOOKUP