The GST Reconciliation Skill is a powerful automation tool designed specifically for Chartered Accountants, tax consultants, and finance professionals in India. It transforms Claude AI into your personal GST reconciliation assistant, automating the tedious process of matching GSTR-2A/2B portal data with your purchase register.
Simply upload your GST Portal download and Tally/Books export, and Claude will instantly analyze thousands of invoices, identify mismatches, flag missing entries, and generate a comprehensive Excel report with actionable insights.
Whether you're preparing for monthly GST filing, conducting tax audits, or working on GSTR-9/9C annual returns, this skill eliminates manual data comparison and reduces reconciliation time from hours to minutes.
Built by a practicing Chartered Accountant who understands the real challenges of GST compliance, this skill handles the nuances of Indian GST data formats, invoice number variations, and common reconciliation pain points that generic tools miss.
GST Recinciliation Skill
Automate GSTR-2A/2B vs Books reconciliation with Claude AI. Instantly identify ITC mismatches, missing invoices, and vendor discrepancies. Save hours of manual work every month.
Description
Key Features
- GSTR-2B vs Books Reconciliation
- GSTR-2A vs Books Reconciliation
- Automatic Column Detection for GST Portal & Tally Formats
- Smart Invoice Number Normalization (INV-001 = INV/001 = INV 001)
- Multiple Date Format Support (DD-MM-YYYY, DD/MM/YYYY, DD-MMM-YYYY)
- Configurable Amount Tolerance for Rounding Differences
- Vendor-wise GSTIN Summary Report
- Multi-sheet Excel Output with Actionable Insights
- Matched Invoices Identification
- Amount Mismatch Detection with Difference Calculation
- Missing in Books Report (Only in Portal)
- Missing in Portal Report (Only in Books)
- Tax Audit Ready Output (Clause 44 Compatible)
- GSTR-9/9C Preparation Support
- No Software Installation Required
- Works with Standard Tally Export Formats
- Secure Processing within Claude Environment
- Instant Results for Thousands of Invoices
System Requirements
- Active Claude Pro or Claude Team subscription
- Claude Skills feature enabled in your account
- Modern web browser (Chrome, Firefox, Safari, or Edge)
- GSTR-2A/2B Excel file downloaded from GST Portal
- Purchase Register exported from Tally or accounting software in Excel format (.xlsx)
- Stable internet connection
- Files should be under 25MB each
Setup Guide
Step 1: Download the Skill
Download the gst-reconciliation.skill file from your purchase confirmation email or download link.
Step 2: Log in to Claude
Open your browser and go to claude.ai. Log in with your Claude Pro or Team account.
Step 3: Open Settings
Click the gear icon (⚙️) in the bottom-left corner of the Claude interface to open Settings.
Step 4: Navigate to Skills
In the Settings menu, click on "Skills" in the left sidebar.
Step 5: Upload the Skill
Click the "Upload Skill" button or drag and drop the gst-reconciliation.skill file into the upload area. Wait for the upload to complete – you'll see a success message.
Step 6: Start Using
Open a new chat with Claude. The skill is now active and ready to use!
Step 7: Test the Installation
Type "Help me with GST reconciliation" to verify the skill is working. Claude should recognize your request and offer assistance.
How to Run Your First Reconciliation
Prepare your GSTR-2B Excel file (download from GST Portal → Returns → GSTR-2B → Download)
Prepare your Purchase Register Excel file (export from Tally → GST Reports → Purchase Register)
Start a new chat with Claude
Upload both files using the attachment button (📎)
Type: "Please reconcile my GSTR-2B with purchase register"
Wait for Claude to process and generate the reconciliation report
Download the output Excel file with all reconciliation sheets