Deepak Gupta demos reconciliation macro
- Chartered accountant Deepak Gupta posted a demo showing an Excel macro that reconciles Goods and Services Tax purchase data with GSTR-2B automatically. - Gupta said the workflow builds a unique invoice key, labels matches and mismatches, and treats differences of up to Rs. 20 separately. - The pitch targets firms still doing monthly GST checks by hand or with paid tools. (ai.icai.org)
Deepak Gupta’s demo shows a simple idea: use an Excel macro to match a company’s purchase records against GSTR-2B automatically. (ai.icai.org) GSTR-2B is the static tax statement businesses in India use to verify input tax credit, and reconciling it against internal books is a monthly compliance task. Gupta wrote that many chartered accountants still do that work manually or through paid software. (tallysolutions.com) (ai.icai.org) His version uses ChatGPT and VBA macros inside Excel rather than a separate reconciliation platform. Gupta said the process first cleans invoice numbers, combines them with the supplier’s Goods and Services Tax Identification Number, and creates a unique key for matching. (ai.icai.org) Once the two datasets are lined up, the macro writes comments directly into a result column. Gupta said exact matches are marked “Matched,” differences up to Rs. 20 are tagged “Nominal Difference,” and missing entries are labeled “Not in Our Data” or “Not in GSTR2B.” (ai.icai.org) The demo also uses color coding to make exceptions visible without reading every row. Gupta said “Difference” rows turn light red, records missing from internal data turn light blue, and records missing from GSTR-2B turn yellow. (ai.icai.org) That matters because reconciliation errors can trigger excess input tax credit claims, tax outflows, interest exposure, and audit or scrutiny notices. Tally Solutions says mismatches often stem from the fact that GSTR-2B is static, while internal books and supplier filings keep changing. (tallysolutions.com) (taxguru.in) Gupta has been presenting this as part of a broader campaign to automate repetitive accounting work. His YouTube channel includes recent clips on GSTR-2B processing and other audit and compliance workflows, and the Institute of Chartered Accountants of India’s AI portal also features his GST reconciliation use case. (youtube.com) (ai.icai.org) The thread around the demo is less about a new tax rule than about a cheaper workflow. Gupta’s claim is that firms can keep the work in Excel, cut hours spent on monthly matching, and leave staff to review the exceptions instead of building the reconciliation from scratch. (ai.icai.org)
