Accolet Advisors

Professional Tax Solutions
Advanced GSTR-2B JSON to Excel Processor with Professional Formatting

Note: IF YOU FIND ANY BUG OR ERROR PLEASE SEND JSON FILE AND SCREENSHOT TO BHARATH@ACCOLET.COM

Company Information

📄

Upload GSTR-2B JSON Files or ZIP Folders

Drag and drop your JSON files or ZIP folders containing JSON files here or click to browse

Advanced GSTR-2B Processing Features

📊

Complete Data Processing

Processes B2B, B2BA, CDNR, CDNRA, IMPG, IMPGSEZ, ISD, and E-commerce data with rejected records (docRejdata) including IMS Action tracking and status monitoring

💎

Professional Excel Formatting

Creates perfectly formatted Excel files with Book Antiqua font size 9, proper colors, merged headers, and auto-fit column widths for optimal viewing

📦

ZIP File Support

Upload ZIP folders containing JSON files with automatic extraction. Supports nested ZIP files up to 10 levels deep for complex folder structures

🏢

Smart Company Names

Default header shows "Accolet Advisors Private Limited" while Company Name field reflects manually entered names for flexible branding

Batch Processing

Process multiple JSON files and ZIP folders simultaneously. Automatically extracts and combines all data into a single comprehensive Excel file

🛡️

Advanced Error Handling

Robust error handling for corrupted JSON files, invalid ZIP archives, and nested extraction failures with detailed status reporting

🌐

State Mapping & Auto-Fit

Automatic state code to state name conversion with GSTIN-based location detection. All Excel columns auto-resize for optimal content display

📋

Enhanced Overview Sheet

Professional overview layout with merged and centered company header, structured data fields, and comprehensive file processing information

Data Types Processed

Invoice Data: B2B, B2BA (amendments), E-commerce invoices with complete supplier information and IMS Action tracking
Credit/Debit Notes: CDNR, CDNRA with proper negative value handling for credit notes and IMS Action monitoring
Import Data: IMPG, IMPGSEZ with port codes, ICEGATE integration, and IMS Action status
ISD Data: Input Service Distributor records with GSTR-6 filing details and IMS Action processing

Smart Processing

Rejected Data: Automatically processes docRejdata alongside regular data
Amendment Tracking: Identifies and processes amendment records with original document references
Tax Calculations: Auto-calculates GST rates from tax amounts when not provided
Date Formatting: Converts all dates to DD-MM-YYYY format consistently