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 |

To simplify your monthly filing process, we have created an automated Excel template designed to handle large datasets, auto-populate formulas, and highlight discrepancies.

To run a manual reconciliation, open Microsoft Excel and structure your workbook into three distinct sheets. Sheet 1: Data from GSTR-2A (Portal Data)