Master GST Reconciliation Tool — Excel Workbook + 2 PDF Guides
Master GST Reconciliation Tool — GSTR-2B vs Purchase Register
Simplify your invoice-level GST reconciliation with a practical, formula-driven Excel workbook designed for Indian accounting professionals, bookkeepers, GST practitioners and small businesses.
WHAT DOES THIS TOOL HELP YOU DO?
Compare your purchase-register records with GSTR-2B data and identify differences that need attention.
KEY FEATURES
- Compare invoice records using Supplier GSTIN, Document Type and normalized Document Number.
- Identify invoices present in your books but not found in GSTR-2B.
- Identify GSTR-2B records missing from your purchase register.
- Highlight taxable-value and individual tax-component differences.
- Identify duplicate, ambiguous and incomplete records for manual review.
- Use configurable comparison tolerances.
- Review reconciliation results, exceptions and summary metrics through the workbook dashboard.
WHAT YOU WILL RECEIVE
- Master GST Reconciliation Tool — Excel workbook.
- Customer User Guide — PDF.
- GST Excel Formulas Handbook — PDF.
WHO IS THIS FOR?
Indian accountants, GST practitioners, bookkeepers, accounting freelancers, finance executives and small-business owners who want a structured way to review purchase-register and GSTR-2B differences.
HOW TO USE IT
Prepare invoice-level purchase-register data and download the relevant GSTR-2B records from the GST Portal. Map and paste the records into the designated workbook input sheets, review the reconciliation results and investigate the exceptions.
IMPORTANT PRODUCT INFORMATION
- Verified initial capacity: up to 200 rows per input source.
- One row per invoice/document is supported in the first version. Consolidate purchase-register line items to invoice level before pasting.
- Manual data preparation and exception review are required.
- The workbook does not automatically connect to the GST Portal, file GST returns or change portal records.
- It does not make final Input Tax Credit (ITC) eligibility decisions. A matched invoice does not automatically establish ITC eligibility.
- Compatibility with desktop Microsoft Excel and LibreOffice has not yet been independently verified.
This is a GST reconciliation support tool, not a replacement for professional tax advice or statutory review.
ONE-TIME PRICE: ₹99 INR
You receive the Excel workbook and both PDF guides as digital downloads.