Combine GSTR-1 Multiple Months to Clean Excel
Consolidate all 12 monthly GSTR-1 portal returns from JSON, ZIP, PDF, or Excel into a single multi-sheet master workbook with an executive horizontal April–March summary matrix.
Combine GSTR 1 (All 23 Tables & Summary Matrix): Statutory Rules, Formula & Slabs
Direct factual rules, statutory mathematical formulas, and official statutory compliance guidelines.
Combine GSTR 1 (All 23 Tables & Summary Matrix) is a free, 100% client-side statutory utility by D BIZ CONSULTANCY PVT. LTD. that computes consolidate all 12 monthly GSTR-1 portal returns from JSON, ZIP, PDF, or Excel into a single multi-sheet master workbook with an executive horizontal April–March summary matrix. It operates using the verified formula Resultant Outward Supplies = ∑(Outward Tables: B2B + B2CL + B2CS + EXP) − Net CDNR (Credit Notes − Debit Notes) + Advances (AT − TXPD). All calculations and file parsing execute directly inside your local web browser.
Statutory Rule & Legal Thresholds
Under Section 37 of the CGST Act and Rule 59, taxpayers furnish outward supplies monthly or quarterly. During year-end statutory audit, GSTR-9 annual return filing, and CA certification under Section 44, reconciling 12 individual monthly GSTR-1 filings against audited financial statements is mandatory. Manual copy-pasting across dozens of sheets leads to omission of credit notes or advance adjustments; this automated in-browser engine guarantees 100% mathematical accuracy without exposing confidential turnover data to external cloud servers.
Mathematical Equation & Calculation Logic
Monthly GSTR-1 portal files isolate outward supplies and debit/credit notes into separate tables. The D BIZ Combiner aligns each month chronologically (April to March), computes the statutory net CDNR adjustment, and produces an audit-verified resultant outward supply total matching Table 4 of GSTR-9.
Statutory Slabs, Parameters & Rate Matrix
| Statutory Parameter & Capability | D BIZ Verified Specification | Execution & Compliance Standard |
|---|---|---|
| Primary Statutory Equation | Resultant Outward Supplies = ∑(Outward Tables: B2B + B2CL + B2CS + EXP) − Net CDNR (Credit Notes − Debit Notes) + Advances (AT − TXPD) | Statutory Mathematical Precision |
| Multi-Format Batch Ingestion | Drag & drop 12+ months of GSTR-1 returns in Excel (.xlsx), Portal JSON (.json), ZIP archives (.zip), or official PDF format simultaneously | 100% Client-Side In-Browser Engine |
| All 23+ Statutory Tables Preserved | Extracts B2B, B2BA, B2CL, B2CLA, B2CS, B2CSA, CDNR, CDNRA, CDNUR, CDNURA, EXP, EXPA, AT, ATA, TXPD, TXPDA, NIL, ECO, HSN, and DOCS into individual sheets | 100% Client-Side In-Browser Engine |
| Executive Horizontal Summary Matrix | Auto-aligns all 12 FY months (April to March) with 6 standard metric columns per section (Taxable Value, IGST, CGST, SGST, Cess, Total) | 100% Client-Side In-Browser Engine |
| CDNR Netting Logic | Automatically nets Credit Notes (C) against Debit Notes (D), calculating clean Resultant Outward Supplies for hassle-free GSTR-9 Table 4/5 annual return filing | 100% Client-Side In-Browser Engine |
| High-Performance In-Browser Engine | Process millions of records in seconds with zero data upload—your turnover, GSTINs, and customer data never leave your computer | 100% Client-Side In-Browser Engine |
| Dual Output Formats | Download the complete combined multi-sheet Excel (.xlsx) workbook or export individual section CSV files on demand | 100% Client-Side In-Browser Engine |
| Privacy & Security | Private In-Browser Execution | No login, no OTP wall, instant PDF/Excel export |
How to Use the Combine GSTR 1 (All 23 Tables & Summary Matrix) in 4 Easy Steps
Select or Drop GSTR-1 Files
Upload all your monthly GSTR-1 returns (.xlsx, .json, .zip, or .pdf) from across the financial year.
In-Browser Consolidation
The engine instantly unzips archives, parses statutory tables, and aligns months chronologically from April to March.
Inspect Summary & Detail Sheets
Review the horizontal summary matrix and browse individual tables (B2B, B2CS, CDNR, EXP, HSN, etc.) in the interactive viewer.
Download Master Excel Workbook
Click 'Download Consolidated Excel' to receive a comprehensive, audit-ready multi-sheet workbook with the horizontal summary and all populated sheets.
Key Highlights & Statutory Capabilities
Frequently Asked Questions (FAQs) — Combine GSTR 1 (All 23 Tables & Summary Matrix)
Need Custom Corporate Advisory or Tax Filing?
Senior Corporate Advisors, Tax Specialists, and Legal Advocates at D BIZ are available for direct advisory sessions in Trivandrum, Kochi & across India.
Related GST Reconciliation & Invoicing Tools
Frequently used together with Combine GSTR 1 (All 23 Tables & Summary Matrix)
Combine GSTR 2B (Multi-Month ITC Consolidator)
Merge multiple months of GSTR-2B returns (.xlsx, .json, .zip) into an audit-ready master workbook. Clean portal headers, aggregate invoice subtotals, and verify cumulative annual ITC under Rule 36(4).
Combine GSTR 2A (Annual Multi-Month Consolidator)
Consolidate 12 months of dynamic GSTR-2A portal downloads into a clean master spreadsheet with auto-header cleanup and customizable rate-wise or invoice-level subtotals for GSTR-9 Table 8A.
GSTR 3B Summary Matrix & Pivot Generator
Compile all 12 monthly GSTR-3B returns into an executive horizontal April–March matrix and statutory pivot table covering Outward Taxable, Eligible ITC, and Cash Paid.
Explore All 79 Free Business & Tax Tools
Filter by specialized category or click any tool card to launch its client-side workspace immediately.
GST Reconciliation & Invoicing
Rule 42/43 ITC reversals, Rule 89 inverted duty & LUT refunds, Sec 50 net cash interest, Sec 47 late fees, Rule 88A set-off optimizer, POS wizard, HSN/SAC everyday finder, GSTR combiner & 10L+ reconcilers.
Combine GSTR 1 (All 23 Tables & Summary Matrix)
Consolidate 12+ months of GSTR-1 files (Excel, JSON, ZIP, PDF) into a single master workbook with horizontal Apr-Mar summary matrix and all 23 statutory tables.
Combine GSTR 2B (Multi-Month ITC Consolidator)
Merge multiple months of GSTR-2B returns (.xlsx, .json, .zip) into an audit-ready master workbook. Clean portal headers, aggregate invoice subtotals, and verify cumulative annual ITC under Rule 36(4).
Combine GSTR 2A (Annual Multi-Month Consolidator)
Consolidate 12 months of dynamic GSTR-2A portal downloads into a clean master spreadsheet with auto-header cleanup and customizable rate-wise or invoice-level subtotals for GSTR-9 Table 8A.
GSTR 3B Summary Matrix & Pivot Generator
Compile all 12 monthly GSTR-3B returns into an executive horizontal April–March matrix and statutory pivot table covering Outward Taxable, Eligible ITC, and Cash Paid.
GST Multi-Month Combiner Suite (GSTR-1, 2A, 2B, 3B)
All-in-one suite to combine GSTR-1, GSTR-2A, GSTR-2B, and GSTR-3B returns across multiple months into clean Excel workbooks with zero server upload.
GSTR 2A vs GSTR 2B Reconciliation (Portal vs Portal)
Cross-match dynamic GSTR-2A supplier filings against static auto-drafted GSTR-2B statements. Handles up to 10 Lakh+ rows with zero computer freeze, real-time speed, and instant cancellation.
GSTR 2B vs Books Reconciliation (Rule 36(4) ITC)
Match monthly purchase registers from Tally, Busy, SAP, Zoho or Excel against static GSTR-2B. Maximize eligible ITC under Rule 36(4), avoid automated DRC-01C notices, and download reconciled Excel sheets.
GSTR 2A vs Books Reconciliation (Annual Table 8A Audit)
Cross-match dynamic GSTR-2A portal statements against Books of Accounts for Form GSTR-9 Table 8A annual return preparation, statutory tax audit, and unbooked ITC identification.
GSTR 1 vs GSTR 3B Reconciliation (DRC-01B Notice Check)
Convert GSTR-1 JSON files to structured Excel sheets and cross-verify outward tax liability against GSTR-3B to prevent automated Rule 88C DRC-01B notices.
Smart GST Invoice & Voucher Generator
Generate GST Tax Invoices (Rule 46), Payment Vouchers (Rule 52), Receipt Vouchers, Bills of Supply, and Delivery Challans with logo and instant PDF print.
GST Calculator (CGST, SGST, IGST)
Calculate GST, CGST, SGST, IGST, and price inclusive/exclusive breakdown across 5%, 12%, 18%, and 28% slabs.
GST Late Fee & Interest Calculator
Compute Section 47 late fee and 18% p.a. Section 50 interest on delayed GSTR-3B filings.
GST Turnover Threshold & Registration Checker
Evaluate Section 22 aggregate turnover limits (Goods ₹40L, Services ₹20L, Special States ₹10L) and Section 24 compulsory non-threshold triggers.
HSN & SAC Code Finder (Everyday Item Search & Slab Rates)
Search 200+ goods and services using common everyday words (e.g. laptop, t-shirt, footwear, hotel, cement) with statutory GST rates as of 16th October 2026, slab-based rules, and live unit price calculator.
Possible GSTIN Validator & Generator
Validate 15-digit GSTIN structures and test checksum algorithms using official Luhn Modulo-36 logic.
GST Rate Comparison Matrix
Compare GST rates across 5%, 12%, 18%, and 28% categories with historical comparisons.
Rule 42 Common Credit Reversal Calculator
Apportion input tax between business, exempt, and non-business supplies. Computes common credit C2 and mandatory monthly reversals D1 and D2.
Rule 43 Capital Goods Credit Reversal Calculator
Calculate 60-month useful life capital goods ITC reversals for assets shifting between taxable and exempt manufacturing per Rule 43(1)(h).
Rule 37 & 37A 180-Day Payment Reversal Calculator
Track supplier invoices unpaid beyond 180 days. Calculate statutory ITC reversal and 18% p.a. Section 50(1) interest, plus Rule 37A supplier non-filing re-claim.
Inverted Duty Structure Refund Calculator (Rule 89(5))
Compute maximum statutory refund for inverted tax structures applying the amended formula (Notification No. 14/2022-CT) restricting Net ITC solely to input goods.
Zero-Rated Export Refund Calculator (LUT - Rule 89(4))
Calculate maximum eligible refund for zero-rated exports under Letter of Undertaking (LUT) with statutory 1.5x domestic turnover capping rule.
Section 50 Net Cash Liability Interest Calculator
Calculate 18% p.a. statutory interest strictly on net cash liability paid via Electronic Cash Ledger per the retrospective amendment to Section 50(1).
Section 47 Late Fee Calculator (GSTR-3B & GSTR-1)
Compute per-day late fees for delayed GSTR-3B and GSTR-1 filings capped according to official turnover slabs (Nil return ₹500 cap; ₹2,000 for < ₹1.5 Cr).
Rule 86B (1% Mandatory Cash Payment) Checker
Check whether monthly taxable supplies exceed ₹50 Lakhs and verify the 4 statutory exemptions (Income tax > ₹1L, export refund, cumulative cash > 1%).
Reverse GST & MRP Price Extractor (RCM / Inclusive)
Deconstruct inclusive MRP or final contract payouts into exact base taxable value, CGST, SGST, IGST, and Reverse Charge Mechanism (RCM) splits.
Composition Scheme vs Regular Scheme Comparator
Evaluate whether to opt for the 1%/5%/6% GST composition scheme or regular scheme with full ITC pass-through based on B2B vs B2C mix and profit margins.
ITC Set-off & Utilization Priority Optimizer
Simulate statutory credit utilization order under Rule 88A & Sections 49, 49A & 49B (exhaust IGST credit first before touching CGST and SGST) to minimize cash outflow.
E-Commerce TCS & Government TDS Calculator
Compute Section 52 TCS (1% or 0.5%) on net e-commerce supplies and Section 51 TDS (2%) on public procurement contracts exceeding ₹2.5 Lakhs.
Place of Supply (POS) Interactive Decision Tool
Interactive statutory logic tree based on Sections 10, 11, 12, and 13 of the IGST Act to determine whether a transaction is Intra-State (CGST+SGST) or Inter-State (IGST).
Legal Drafts, NOCs & Brand IP
Rule 8(1) CGST NOC & Consent Letter, Kerala Commercial Rent Agreement, GST Board Resolution & Authorization Letter, WIPO Madrid Protocol Calculator, and Trademark Class Finder.
GST NOC & Consent Letter Generator
Generate legally valid No Objection Certificates (NOC) and Consent Letters for GST registration under Rule 8(1) CGST Rules. Download in Word (.docx / .doc) and PDF.
Kerala Commercial Rent Agreement Generator
Generate legally compliant 11-month Commercial Rent/Lease Agreements for Kerala business premises. Formatted with Municipal/Panchayat door numbers, KSEB consumer numbers, and Rule 8(1) CGST landlord consent clauses. Download in Word (.doc) and PDF.
Trademark Class Finder
Search all 45 Nice trademark classes and find the exact statutory class for your brand, goods, or services.
Business Name Generator
Generate legally compliant, unique brand and company names ready for MCA RUN / SPICe+ CRC approval.
WIPO Madrid Protocol International Trademark Fee Calculator
Calculate official WIPO Swiss Franc (CHF) basic fees, country-specific Individual Designation Fees (USA, EUIPO, UK, UAE, Australia, China, Japan, Canada), and Indian Registry Form MM2 handling charges.
GST Board Resolution & Authorization Letter Generator
Generate legally certified Board Resolutions for Companies and Letters of Authorization for LLPs and Partnerships appointing the Primary Authorized Signatory for GST REG-01.
Incorporation, ROC & Kerala Clearances
Kerala MOA/AOA stamp duty & ROC fee calculator, MCA SPICe+ Document Checklist, Pvt Ltd vs LLP 3-year TCO, K-SWIFT clearance navigator, plus US, UAE, EU & KSA entity selectors.
Company Registration Kerala Statutory Stamp Duty & Govt Fee Calculator
Calculate exact Kerala statutory stamp duty on MOA/AOA, Central MCA name approval (RUN), statutory PAN & TAN, and ROC fee exemptions.
MCA SPICe+ Founder Document Readiness Checklist
Interactive MCA V3 incorporation document checklist for Resident Indians, NRIs, Foreign Nationals, and Registered Office premises (KSEB Bill, NOC, Apostille).
Pvt Ltd vs. LLP vs. OPC Comparison
Compare side-by-side 3-Year Total Cost of Ownership across Pvt Ltd, LLP, OPC, and Proprietorship with tax rates and VC readiness scoring.
Business Setup Cost Estimator
Estimate company registration cost (Pvt Ltd, LLP, Dubai, US) with instant statutory quote breakdown.
Authorized Capital & ROC Fee Calculator
Estimate statutory ROC filing fees (Form SH-7) and state stamp duty to increase authorized share capital.
Statutory Compliance Calendar & Google Sync
Generate a custom statutory compliance calendar with Companies Act, GST, Income Tax, TDS, PF, and ESI deadlines with 1-click Google Calendar sync.
K-SWIFT Kerala Industrial Permits Checker
Official CPCB & KSPCB pollution category classifier (White, Green, Orange, Red) and Kerala MSME Facilitation Act 3-year permit exemption checker.
Kerala Professional Tax & Stamp Duty
Compute Kerala Municipal Corporation half-yearly P-Tax slabs (₹1,250 cap) and commercial lease stamp duty under Kerala Stamp Act.
NBFC 50-50 & NOF Compliance Checker
Verify RBI 50-50 Principal Business Test, minimum Net Owned Funds (₹2 Cr / ₹10 Cr / ₹25 Cr), and Scale-Based Regulation (SBR) tier.
US Company State & Entity Selector (Delaware C-Corp vs Wyoming LLC)
Interactive US incorporation decision engine comparing Delaware C-Corp (VC/QSBS standard) vs Wyoming LLC ($60/yr report, pass-through Form 5472).
UAE Dubai Mainland (DET) vs Free Zone Selector
Compare Dubai Mainland (DET LLC) vs UAE Free Zones (IFZA, DMCC, Meydan, RAKEZ) by activity, visa quota, Ejari vs Flexi-Desk, and 0% QFZP tax.
EU Company Jurisdiction & Tax Selector (Estonia, Ireland, NL)
Compare European Union company incorporation across Estonia OÜ (0% retained profit tax), Ireland LTD (12.5% trading tax), Netherlands BV, and Cyprus LTD.
Saudi Arabia (KSA) MISA License & ZATCA Tax Calculator
Evaluate Saudi Arabia MISA 100% foreign ownership license capital rules and ZATCA Corporate Tax (20% foreign share) vs Zakat (2.5% Saudi/GCC share).
Income Tax, TDS & Global Tax
New vs Old Tax Regime (Sec 115BAC), TDS 194J/C/I/H/Q, 12.5% LTCG, Sec 40(b) Partner Remuneration, MSME Sec 43B(h), NGO 12AB/80G 85% Rule, Form 15CA/15CB, plus UAE, UK & Canada Corporate Tax.
Income Tax (ITR) Calculator
Compare New Tax Regime (with ₹75,000 standard deduction) vs Old Tax Regime for FY 2024-25 & FY 2025-26.
TDS Deduction Calculator
Calculate Section 194J, 194C, 194I, 194H, 194Q TDS deductions by service type, bill value, and GST segregation.
Advance Tax Installment Calculator
Calculate quarterly advance tax installments (15%, 45%, 75%, 100%) and avoid Section 234B/C interest.
Capital Gains Tax Calculator (LTCG & STCG)
Calculate Short-Term (STCG) and Long-Term (LTCG) taxes with 12.5% unified rate and ₹1.25L exemption.
Partnership Remuneration Calculator (Sec 40b)
Calculate maximum allowable partner remuneration and 12% capital interest under Section 40(b) of the Income Tax Act.
MSME 45-Day Payment Rule (Sec 43B(h))
Calculate statutory due dates (15 vs 45 days), Section 16 penal compound interest (3x RBI Rate), and Section 43B(h) tax disallowances.
NGO 12AB & 80G Tax Exemption & 85% Rule Calculator
Calculate NGO & Charitable Trust tax savings under Section 11 & 12AB, track the mandatory 85% income application rule, Corpus exemptions, and 50% donor 80G deductions.
Foreign Remittance Form 15CA & 15CB Checker
Determine exact Part A, B, C, or D filing path under Rule 37BB and statutory certification requirements.
UAE Corporate Tax & Free Zone Calculator
Calculate UAE Federal Corporate Tax (0% up to AED 375k, 9% standard) and evaluate Qualifying Free Zone Person (QFZP) 0% tax eligibility.
UK Corporation Tax & VAT Calculator
HMRC Finance Act rules: 19% small profits, 25% main rate, marginal relief taper, and £90,000 / £0 NETP VAT thresholds.
Canada Corporate Tax (CCPC vs Foreign Owned) Calculator
Compare Canadian Federal + Provincial T2 corporate tax across Alberta (23%), Ontario (26.5%), and BC (27%) for CCPC (9% SBD) vs Non-Resident corporations.
Startup Valuation & Fundraising
5-Level Founder Business Readiness diagnostic (100 Qs), Pre/Post-Money Valuation & Cap Table Dilution, Burn Rate & Zero-Cash Runway date, Real Loan APR & Debt Fundraising Cost, and Business ROI.
Founder Business Readiness & Mindset Diagnostic
5-Level psychometric test (100 standard questions) evaluating founder grit, cash flow discipline, crisis agility, sales conviction, and Kerala ground realities.
Startup Valuation & Dilution Calculator
Compute Pre/Post-Money valuation, cap table dilution, and investor equity stake for fundraising.
Startup Runway & Zero-Cash Date Calculator
Calculate gross vs net burn rate, forecast exact zero-cash insolvency dates, and estimate required angel / VC fundraising buffer.
Cost of Fund Raising & Real Loan APR Calculator
Calculate the true cost of raising debt funds and loans. Uncovers hidden upfront processing cuts, implied monthly rate, nominal annual APR, and effective annual cost (EIR) on actual bank credit.
Business ROI Calculator
Calculate Return on Investment, annualized ROI, and CAGR on business capital expenditures.
Salary, HR Payroll & Benefits
CTC to monthly in-hand take-home salary calculator, Section 10(13A) HRA exemption, Payment of Gratuity Act 1972 (15/26 formula), and EPF 8.25% retirement corpus compounding.
Salary In-Hand & CTC Take-Home Calculator
Convert annual CTC into monthly take-home salary after EPF, Professional Tax, and TDS under the New Tax Regime.
HRA Exemption Calculator
Calculate Section 10(13A) House Rent Allowance tax exemption and taxable salary component for metro and non-metro cities.
Gratuity Payout Calculator
Calculate mandatory gratuity payout based on 15/26 formula and service tenure under the Payment of Gratuity Act.
EPF Retirement Corpus Calculator
Project employee provident fund corpus at retirement age 58 with 8.25% compounding.
Banking, Loans & Wealth
Personal, business, and home loan EMI amortization schedules, Loan vs Own Funds decision engine, SIP & Lumpsum mutual fund compounding, PPF 7.1% tax-free wealth, NPS, FD, and RD.
Loan EMI Calculator
Calculate monthly EMI installments, total interest, and amortized repayment schedules for personal or business loans.
Home Loan EMI & Tax Saver
Calculate housing loan EMI and tax deduction benefits under Section 24(b) and 80C.
Loan vs. Own Funds Decision Calculator
Compare whether taking a loan or paying from own funds is more profitable for cars, homes, or machinery. Includes PDF & Excel exports.
SIP Compounding Calculator
Calculate returns on monthly mutual fund SIP investments with compound growth projections.
Mutual Fund & Lumpsum Calculator
Estimate future returns for one-time lumpsum mutual fund and equity investments.
PPF Wealth Calculator
Calculate guaranteed returns on Public Provident Fund with 7.1% tax-free compounding.
NPS Pension Calculator
Compute National Pension System retirement corpus, 60% lumpsum, and monthly annuity.
Retirement Planning Calculator
Calculate the exact inflation-adjusted corpus required to retire comfortably.
Fixed Deposit (FD) Calculator
Calculate quarterly compounded maturity value and senior citizen bonus returns.
Recurring Deposit (RD) Calculator
Calculate total maturity proceeds on monthly recurring deposits in banks.
Simple vs Compound Interest Calculator
Side-by-side comparison of simple interest vs compounded returns over any period.
Have a statutory calculation, Kerala municipal fee rule, Excel reconciliation, or return filing utility you need for your business or practice? Tell us below. Any requested tools will be integrated and deployed to this hub.
Tool Request & Feedback Desk
Choose whether you would like to request a new tool, or share feedback on an existing utility. Any requested tools will be integrated.
Need Help Executing Your Business or Tax Filings?
Corporate Advisors, Tax Specialists, and Legal Professionals at D BIZ are available for direct advisory sessions in Trivandrum, Kochi & across India.