| ITC Component | Portal Data (2B) | Books Data (ERP) | Difference |
|---|---|---|---|
| IGST Component | ₹0.00 | ₹0.00 | ₹0.00 |
| CGST Component | ₹0.00 | ₹0.00 | ₹0.00 |
| SGST Component | ₹0.00 | ₹0.00 | ₹0.00 |
| Total Cumulative ITC | ₹0.00 | ₹0.00 | ₹0.00 |
How to Use the GST Reconciliation Tool
Click the "Download Template" button. You'll get a standard Excel file with Books_Data and Portal_Data sheets, each with a dedicated Date column.
Paste your ERP/books entries and GSTR-2B details into the respective sheets. Make sure invoice dates are filled in correctly, since the tool uses them to run timeline checks.
Upload your file and click "Start Reconciliation". Review the remarks shown on screen, then click the green button to download your clean, ad-free Excel report.
Why This Tool Matches Better Than a Manual VLOOKUP
- 100% Data Privacy: Your financial and client data never leaves your computer. Matching runs locally inside your browser — nothing is uploaded to any server.
- ₹2 Rounding Tolerance: Small paisa-level differences caused by rounding off don't get wrongly flagged — the tool treats anything within ₹2 as a genuine match.
- Cross-Month Spillover Check: If the same invoice value repeats across different months (say April and May), the tool won't auto-match them blindly — it flags the pair for you to review manually, so a genuine spillover bill doesn't get matched to the wrong month.
- Invoice Date Order Check: If a book entry shows a date earlier than the actual date the invoice appeared on the GST portal, the tool adds a remark flagging the entry so you can catch manual entry mistakes.
- Financial Year Boundary Check: Using an April-to-March cycle, entries that fall outside the current year get labelled "Last FY Bill" automatically, so they don't accidentally get claimed as this year's input tax credit.
- Typo-Tolerant Invoice Matching: Small formatting differences (like
INV-25vs25) are still matched correctly using string-similarity logic, within a 30-day matching window so it doesn't over-match unrelated invoices.
Pro Tip: Run this tool before filing your monthly GSTR-3B and annual GSTR-9. Catching timeline gaps and spillover mismatches early saves you from unnecessary department notices later.
About This GST Reconciliation Tool
This tool matches your GSTR-2B portal data against your own books, entirely inside your browser — no upload, no signup. It's built for small business owners, CAs, and accountants who need to check input tax credit mismatches at the invoice level without wrestling with a heavy desktop application or a manual VLOOKUP in Excel every month. Because everything runs client-side, your books and vendor data stay on your own computer the entire time — nothing is sent anywhere. It's a free way to stay on top of Section 16(2)(aa) compliance without extra software.
Comments
Post a Comment