Reconcile Books Purchase Register CSV/Excel against GSTR-2B Portal data 100% locally in browser RAM. Matches Supplier GSTIN and normalized Invoice Numbers with rounding tolerance to pinpoint eligible ITC, mismatches, and missing invoices.
Reconcile two CSV spreadsheets side-by-side by primary key identifier. Pinpoint added, deleted, and modified rows with cell-level highlights and exportable delta audit reports.
Client-side mathematical verification of 12-digit Indian Aadhaar numbers via the Verhoeff algorithm (Dihedral D5 group), PAN card entity codes, and 15-character GSTIN tax identifiers without cloud server transmission.
Calculate GST amount and total billing value for 5%, 12%, 18%, and 28% slabs in both inclusive and exclusive modes.
Instantly inspect and audit CSV and Excel datasets in browser memory. Computes null percentages, distinct value cardinality, numeric min/max/mean/median, and inferred SQL types.
Sanitize and mask sensitive personally identifiable information (PII), names, emails, phone numbers, and IDs in CSV datasets locally in RAM before sharing with AI models or third parties.
Convert CSV spreadsheets and tabular files into optimized, syntactically escaped SQL INSERT statements for PostgreSQL, MySQL, SQLite, and BigQuery with type inference and batch chunking.
Automated GSTIN + Fuzzy Invoice Number matching, rounding tolerance analysis, and Section 16(2)(aa) Input Tax Credit verification
Under Section 16(2)(aa) of the CGST Act and Rule 36(4), businesses can only claim Input Tax Credit (ITC) in GSTR-3B if the supplier has reported the tax invoice in their GSTR-1/IFF and the invoice reflects in the recipient's auto-drafted GSTR-2B statement. Reconciling hundreds of purchase vouchers from Tally, Zoho Books, Busy, or SAP against the GST Portal GSTR-2B CSV/Excel manually takes hours of VLOOKUP work—and uploading client financial ledgers to cloud SaaS portals violates client confidentiality. VedKit performs the entire reconciliation 100% locally in your browser RAM.
Standard Excel VLOOKUP or XLOOKUP fails when a supplier enters INV/2026/0042 in GSTR-1 while your accountant records INV-2026-42 or 0042 in the Books Purchase Register.
VedKit's reconcileGst2bVsBooks engine constructs a dual composite key:
SupplierGSTIN + ExactInvoice_No/, -, spaces) and collapses leading zeros in numeric segments so INV/2026/0042 and INV-2026-42 match automatically while flagging the normalization in the audit remark!Every invoice across your Books and GSTR-2B is categorized into one of four actionable buckets:
How GSTR-2B vs Purchase Register Reconciliation Studio processes files securely inside your device memory
Every byte of your file is loaded directly into browser ArrayBuffers. Data is processed in volatile sandbox memory and flushed immediately when you close or refresh this tab.
Calculations and image matrix transformations leverage client-side GPU / Canvas2D engines for zero-latency output without server queuing or rate limits.
Generated files strictly follow international ISO specifications (JPEG JFIF, PDF 1.7, Web Crypto API) to guarantee acceptance on all official portals and banking systems.
Quick 4-step guide for instant results
Upload or paste your Books Purchase Register (.csv/.xlsx) and GSTR-2B statement (.csv/.xlsx), or click "Load Sample CA Audit Dataset" to test immediately.
Select your acceptable paise/rupee rounding tolerance (e.g. ±₹2.00) so minor rounding differences do not trigger false mismatch alerts.
Review Total Books ITC, GSTR-2B ITC, Claimable ITC, and ITC at Risk, and filter rows by Exact Match, Value Mismatch, Missing in 2B, or Missing in Books.
Download the complete reconciliation workpaper as a formatted Microsoft Excel (.xlsx) workbook or UTF-8 CSV file.
Common questions and verified answers about GSTR-2B vs Purchase Register Reconciliation Studio