Excel Tutorials & Reconciliation

How to Download GSTR-2B in Excel Format: Step-by-Step Portal Guide & Tab Structure

By gstr2bmatch.in Compliance Team • Statutory Ref: Rule 60(7) & CGST Rule 36(4) • 8 min read

To download GSTR-2B in Excel format, log in to the GST Portal (services.gst.gov.in), navigate to Services > Returns > Returns Dashboard, select your Financial Year and Return Period, and click Search. On the Auto-drafted ITC Statement GSTR-2B tile, click "DOWNLOAD", then click the blue button labeled "GENERATE EXCEL FILE TO DOWNLOAD". The portal will initiate server-side file generation. After 2 to 15 minutes, re-open the screen or refresh, click the generated download link to receive a compressed ZIP file, and extract the official multi-tab .xlsx workbook containing your itemized B2B, B2BA, and CDNR records.

The main guide to GSTR-2B download covers the portal route and the file options.

The GSTR-2B Excel spreadsheet is the foundational working file utilized by finance managers, accountants, and tax advisors across India. Unlike static PDF summaries, the Excel workbook contains raw, unaggregated transaction rows—including supplier GSTINs, invoice dates, taxable values, IGST/CGST/SGST breakdowns, Place of Supply, reverse charge flags, and GSTR-1 filing dates. In this comprehensive guide, we provide a step-by-step walkthrough of the portal export process, dissect every worksheet tab inside the file, resolve common generation errors, and demonstrate how to use this data for instant reconciliation without manual formula fatigue.

Why Download GSTR-2B in Excel Format Instead of PDF or JSON?

While the GST portal offers three distinct formats for Form GSTR-2B, Excel remains the most versatile format for everyday finance workflows:

  • Granular Document Level Transparency: While the portal's PDF export is strictly an executive summary, the Excel file provides granular line-item data for every single invoice uploaded by your vendors.
  • Flexible Data Filtering & Pivot Analysis: Accounts teams can easily apply Excel filters to isolate specific high-value vendors, identify invoices with Place of Supply errors, or check which suppliers filed their GSTR-1 after the 13th cutoff.
  • Direct Audit Trail for Working Papers: Tax practitioners can archive monthly Excel workbooks directly within their statutory audit working paper files, cross-referencing invoice-level ITC with general ledger vouchers.
  • Zero Coding Barrier: Unlike JSON files, which require specialized parsers or offline tools to read, an Excel spreadsheet opens natively in Microsoft Excel, Google Sheets, LibreOffice, or WPS Office.

Step-by-Step Portal Walkthrough: Downloading GSTR-2B Excel File

Follow these precise steps on the official Goods and Services Tax portal to request and download your GSTR-2B Excel statement:

Statutory Timing: When Does Excel Generation Become Available?

Under Rule 60(7) of the Central Goods and Services Tax (CGST) Rules, 2017, GSTR-2B is computed by the GSTN on the 14th of each month following the GSTR-1/IFF filing deadline (13th midnight). Attempting to generate GSTR-2B before the 14th will either display an error or return previous month statements.

  1. Access the Official GST Portal: Navigate to https://www.gst.gov.in/ in your browser and log in with your valid registered credentials and security captcha.
  2. Navigate to Returns Dashboard: Click on Return Dashboard directly from the home dashboard, or select Services > Returns > Returns Dashboard from the primary navigation bar.
  3. Select Relevant Tax Period: Select the target Financial Year (e.g., 2026-27) and select the corresponding Return Filing Period (e.g., September). Click Search.
  4. Click "DOWNLOAD" on GSTR-2B: On the dashboard cards, find Auto-drafted ITC Statement for the month GSTR-2B. Click the DOWNLOAD button (do not click View).
  5. Request Excel Generation: Under the Offline Download section, locate the heading labeled Excel File and click the button: GENERATE EXCEL FILE TO DOWNLOAD.
  6. Handle the Queue Notification: The portal will display an informational banner: "Your request for generation has been accepted. Please check back after 20 minutes." (For small-to-medium businesses with fewer than 500 invoices, the file is usually ready within 1 to 3 minutes).
  7. Download the Compressed Archive: Refresh your browser tab or revisit the download page. The generation button will be replaced with a blue hyperlink: Click here to download Excel - File 1. Click this link to download the .zip package to your computer.
  8. Unpack the ZIP File: Locate the downloaded zip archive (typically named GSTR_2B_<GSTIN>_<PERIOD>.zip), right-click and select Extract All... to reveal the uncompressed .xlsx spreadsheet.

Anatomy of the Downloaded GSTR-2B Excel File: Dissecting the Worksheets

When you open the unzipped GSTR-2B Excel workbook, you will find multiple dedicated tabs. Understanding each tab's role is critical for accurate Input Tax Credit claiming under Section 16(2)(aa):

Worksheet Name Underlying Content Relevance for ITC Reconciliation
Read Me System notes, table mapping rules, and glossary of statutory terms. Provides official definitions of columns like GSTR-1 filing status, supplier return type, and POS rules.
ITC Available Summary Aggregated table matching Part A of Form GSTR-2B (B2B, B2BA, CDNR, ISD, Imports). Matches figures that auto-populate into Form GSTR-3B Table 4(A).
ITC Unavailable Summary Aggregated table matching Part B (Ineligible supplies under Sec 16(4) or POS restrictions). Must be reported under Table 4(B) or Table 4(D) of Form GSTR-3B; cannot be claimed.
B2B Regular inward taxable supplies received from registered regular suppliers. Primary matching tab: Contains supplier GSTIN, invoice number, invoice date, taxable value, IGST, CGST, SGST, Cess, and filing date.
B2BA Amendments made by suppliers to previously filed regular B2B invoices. Important for identifying invoice number changes, value revisions, or rate corrections made by vendors.
B2B-CDNR Credit and Debit Notes issued by registered vendors. Essential for adjusting ITC. Credit notes reduce your eligible credit, while debit notes increase it.
B2B-CDNRA Amendments to previously issued Credit and Debit Notes. Captures alterations to credit/debit note values or tax rates.
ISD & ISDA ITC distributed by an Input Service Distributor (and corresponding amendments). Reconciled by corporate head offices allocating service credits across multiple state branches.
IMPG & IMPGSEZ Import of goods from overseas or inward supplies from Special Economic Zone units. Pulls data from ICEGATE Bill of Entry filings to support Table 4(A)(1) claims.

Key Columns in the B2B Sheet & What They Mean

When executing invoice reconciliation, the B2B worksheet requires meticulous scrutiny. The table below explains the most critical fields:

  • GSTIN of Supplier: The 15-digit alphanumeric tax identifier of your vendor. A single character typo in your ERP ledger will cause an automated match failure.
  • Trade/Legal Name: The official registered business name of the supplier.
  • Invoice Number: The exact invoice serial number uploaded by the supplier in GSTR-1. Special characters (e.g. INV/2026/045 vs INV-2026-045) frequently cause manual lookup formulas to fail.
  • Invoice Date & Invoice Value: Date of supply and gross invoice amount (Taxable Value + Taxes).
  • Place of Supply (POS): The 2-digit state code indicating where the supply took place. If the POS matches your supplier's state but differs from your factory/office location, ITC may be restricted to Part B (ITC Unavailable).
  • Supply Attract Reverse Charge: Indicates whether tax liability must be paid by the recipient under Section 9(3) or 9(4) of the CGST Act.
  • GSTR-1/IFF Filing Date: The precise date on which the vendor filed their return. If this date is on or before the 13th, the invoice sits in GSTR-2B; if filed later, it shifts to subsequent tax periods.
  • ITC Availability (Yes/No): Explicit flag indicating whether the invoice is legally eligible for credit.

Troubleshooting Common GSTR-2B Excel Download Problems

Accounting teams frequently encounter specific technical hurdles when requesting Excel files on the GST portal:

1. "Generation in Progress" Message Persisting for Hours

During the peak filing crunch between the 15th and 18th of the month, hundreds of thousands of businesses trigger Excel generation simultaneously. If your status remains stuck on "Generation in Progress" for over 45 minutes, do not keep spamming the generate button. Log out, clear your browser cache, re-login, and check the download tab. In 90% of cases, the link has been created in the database even if the UI banner failed to update.

2. "Corrupt File" or "Invalid ZIP Archive" Error

If Windows File Explorer reports that the downloaded zip archive is invalid or damaged, the download was prematurely terminated by network instability. Do not attempt to repair the file using third-party zip fixers. Return to the portal and re-download the generated zip archive.

3. Number Formatting & Leading Zero Truncation in Excel

When opening CSV or unformatted text exports in Excel, invoice numbers containing leading zeros (e.g., 000452) are frequently converted by Excel's auto-format engine into plain integers (452). Fortunately, the official GSTR-2B .xlsx download formats invoice numbers as explicit Text strings, preventing leading zero loss. If you copy data into another workbook, ensure you preserve text column formats.

Impact of Invoice Management System (IMS) on Excel Exports

Under GSTN Advisory 624, the Invoice Management System allows buyers to accept, reject, or mark vendor invoices as pending. If you take actions in your IMS dashboard, your initial GSTR-2B Excel downloaded on the 14th will not reflect those changes until you manually click Recompute GSTR-2B on the portal and generate a fresh Excel download. Always reconcile against the recomputed file before filing GSTR-3B.

Why Manual Excel Matching (VLOOKUP) Fails at Scale

Many internal accountants still attempt to reconcile GSTR-2B Excel against their ERP purchase register using manual spreadsheets and VLOOKUP or INDEX/MATCH formulas. In practical operations, this manual approach suffers from four critical flaws:

  1. Formatting Variations in Invoice Numbers: Vendors frequently enter invoice numbers with prefixes, spaces, or slashes (e.g., GST/24-25/089), while your internal data entry clerk entered 89. Exact-match Excel formulas report these as missing invoices, leading to unnecessary vendor payment holds.
  2. Round-off Differences: Under Section 170 of the CGST Act, amounts are rounded to the nearest rupee. If your ERP calculates tax as ₹1,450.48 (rounded to ₹1,450.00) while the vendor billed ₹1,450.52 (rounded to ₹1,451.00), formula matching marks a mismatch.
  3. Multi-Line Item Consolidation: A single supplier invoice may contain three line items at 5%, 12%, and 18% GST. The GSTR-2B B2B sheet aggregates these into a single invoice entry, whereas your purchase register may record them across three distinct voucher rows.
  4. Excessive Time Consumption: For a business with 300 to 2,000 monthly purchase bills, manual VLOOKUP matching, filtering, and discrepancy tagging consumes 8 to 14 staff hours every single tax cycle.

The Modern Alternative: Instant In-Browser Matching with Zero Cloud Uploads

Rather than building fragile Excel spreadsheets or paying expensive subscriptions for cloud-based GST software that uploads your proprietary supplier pricing to third-party databases, use gstr2bmatch.in.

Simply export your GSTR-2B Excel file from the portal and export your Purchase Register from Tally, Busy, or Zoho Books. Drop both files directly into our browser-based matching engine. In under 5 seconds, our intelligent matching algorithm:

  • Applies fuzzy matching logic to bridge invoice numbering discrepancies (ignoring leading zeros, slashes, and spaces).
  • Applies legal round-off tolerance (Section 170 compliant) so 50-paisa variations don't trigger false flags.
  • Separates records cleanly into: Fully Matched, Invoice Number Discrepancies, Tax Amount Mismatches, Invoices Missing in GSTR-2B, and Invoices in 2B Not in Books.
  • Operates 100% locally in your browser RAM—zero data is sent across the internet, guaranteeing total compliance with ICAI confidentiality ethics and data protection laws.

Reconcile Your Downloaded GSTR-2B Excel in Seconds

Tired of manual VLOOKUP formulas breaking on invoice numbers? Drop your GSTR-2B Excel file and ERP purchase register directly into our free tool and get a complete mismatch report instantly.

Match GSTR-2B Excel Free →

Frequently Asked Questions (FAQs)

Can I download GSTR-2B Excel for an entire financial year at once?

The GST portal does not currently provide a single-click button to download consolidated GSTR-2B Excel files for an entire financial year. You must download each month individually. However, you can combine monthly sheets using power query or drag multiple monthly files into automated client-side reconciliation tools.

Is the GSTR-2B Excel download password protected?

No. Unlike Form GSTR-1 or certain e-way bill exports that may require your PAN or GSTIN as a password, the GSTR-2B Excel (.xlsx) file downloaded from the GST portal is completely unprotected and opens directly upon extraction.

Does the Excel file include Reverse Charge (RCM) invoices?

Yes. Inward supplies liable to reverse charge are listed in the B2B tab with a column titled "Supply Attract Reverse Charge" marked as "Y". They are also summarized in the "ITC Available Summary" tab under the Reverse Charge section for reporting in Table 4(A)(3) of GSTR-3B.

What should I do if my supplier says they filed GSTR-1, but the invoice is missing from my GSTR-2B Excel?

Check the vendor's actual GSTR-1 filing date. If the vendor filed on the 14th or later, the invoice will not appear in this month's GSTR-2B; it will be pushed into next month's GSTR-2B. Alternatively, check your Invoice Management System (IMS) dashboard to verify if the invoice was kept in "Pending" status.

Related guides