Automate GST Reconciliation in Minutes
Smart Excel add-in that matches 10,000+ invoices in seconds. Save 80% time on GSTR-2B and GSTR-1 reconciliation.
Complete GST Reconciliation Suite
Everything you need for accurate GST compliance
ITC Reconciliation for B2B Transactions
Reconcile GSTR-2B/2A portal data with your Purchase Register to verify Input Tax Credit (ITC) claims.
Matching Process:
- Exact Matching: Primary key matching on GSTIN + Invoice Number + Amount + Date
- Probable Matching: Fuzzy matching with configurable date and amount tolerances
- Invoice Normalization: Automatic case and punctuation handling
- Tax Components: Reconciles IGST, CGST, SGST, and CESS amounts
Generated Reports:
- Summary Sheet: Aggregate statistics and match counts
- Exact Matches: Perfect matches on all key fields
- Probable Matches: Close matches within configured tolerance
- Only in Portal: Invoices in GSTR-2B but missing in your books
- Only in Books: Invoices in your register but not in GSTR-2B
- Analytics Dashboard: Visual charts with KPIs and trends
Outward Supply Reconciliation for B2B Transactions
Reconcile GSTR-1 portal data with your Sales Register to verify outward supply declarations.
Key Features:
- Exact Matching: Primary key-based matching (GSTIN + Invoice Number + Amount + Date)
- Probable Matching: Fuzzy matching with configurable tolerances
- Customer Validation: Verify customer GSTIN and invoice details
- Tax Components: Complete IGST, CGST, SGST, and CESS reconciliation
- Compliance Check: Detect unreported or incorrectly reported sales
Output Reports:
- Summary sheet with reconciliation statistics
- Exact matches - All fields match perfectly
- Probable matches - Minor differences within tolerance
- Only in Portal - Invoices in GSTR-1 but not in books
- Only in Books - Invoices in books but not filed in GSTR-1
- Visual analytics dashboard with trends and insights
Dedicated Credit Notes Reconciliation
Specialized reconciliation for credit notes between GSTR portal and your books for accurate ITC adjustments.
Key Features:
- Negative Amount Handling: Properly handles credit note negative values
- Original Invoice Linking: Match credit notes against original invoices
- ITC Reversal Tracking: Track ITC reversals accurately
- Partial Credit Notes: Handle partial credit notes and adjustments
- Smart Matching: Exact and probable matching with tolerances
Output Reports:
- Summary with credit note statistics
- Matched credit notes with original invoice references
- Unmatched credit notes requiring attention
- ITC reversal summary by GSTIN
- Analytics dashboard with credit note trends
- Comprehensive audit trail for compliance
Dedicated Debit Notes Reconciliation
Specialized handling for debit note reconciliation and tax liability adjustments.
Key Features:
- Adjustment Tracking: Track debit note adjustments and corrections
- Source Document Linking: Link debit notes to original transactions
- Additional ITC Claims: Track additional ITC claims from debit notes
- Compliance Validation: Validate debit note compliance with GST rules
- Smart Matching: Exact and probable matching algorithms
Output Reports:
- Summary with debit note reconciliation statistics
- Matched debit notes with source references
- Unmatched debit notes requiring review
- Additional ITC claims summary
- Variance analysis by GSTIN and period
- Detailed audit trail for tax compliance
Settings & Configuration
Easy to configure and customize
Customize default reconciliation behavior through the Settings panel:
Default Matching Options:
- Date Tolerance (days): Set acceptable date variance for probable matching (default: configurable)
- Amount Tolerance: Configure acceptable amount differences for rounding variations
- Use Taxable Value for Matching: Choose to match on taxable value instead of total value
- Ignore Case in Invoice Number: Treat "INV001" and "inv001" as the same invoice
- Ignore Punctuation in Invoice Number: Treat "INV-001" and "INV001" as the same
- Enable Probable Matching: Toggle fuzzy matching with tolerance-based matching
General Settings:
- Create reports in new workbook: Export results to a new workbook instead of adding to current workbook
Note: Summary reports and analytics dashboards are automatically generated for all reconciliations.
All settings are saved automatically and applied as defaults for new reconciliations. You can override these settings during the reconciliation wizard for specific needs.
How It Works
Simple 6-step process to complete reconciliation
Install Add-in
Download XLL file and load into Excel 2016+
Import Data
Load GSTR and Register into separate sheets
Select Type
Choose reconciliation type from ribbon
Map Columns
Auto-suggested field mappings
Configure Rules
Set tolerances and options
Get Results
Instant detailed reports
Why Choose UnleashedGST
Built for accuracy, speed, and ease of use
Smart Matching
Exact and probable matching with configurable tolerances for dates and amounts
Lightning Fast
Process 10,000 invoices in 5-15 seconds with optimized performance
Analytics Dashboard
Visual charts and KPIs with pivot tables for instant insights
Simple Pricing
One-time payment, lifetime access
Lifetime License
One-time payment • No recurring fees
- Unlimited reconciliations
- Process unlimited invoices
- GSTR-2B/2A vs Purchase
- GSTR-1 vs Sales
- Credit & Debit Notes
- Smart auto-mapping
- Professional reports
- Analytics dashboard
- Email support
- Life time updates
Ready to Transform Your GST Workflow?
Join thousands of businesses automating their GST reconciliation