GSTZen - GSTR1 vs 2A vs 3B Sample

Aug 31, 2026

Upload by Rowan

This spreadsheet sample provides GSTIN and company identification details alongside a structured set of GST return fields for the 2017-18 financial year. It includes outward taxable supplies broken into categories such as other than zero/nil/exempt and zero rated, plus inward supplies subject to reverse charge. It also records tax components including IGST, CGST, SGST, and Cess, along with ITC availability, reversed ITC, net ITC, ineligible ITC, and payment of tax figures such as tax, interest, and late fees.

LanguageEnglish

CategoryInvoices

FormatXLSX

Pages1

AccessFree to download

GST Return Fields Overview

Tax Payment and Interest/Late Fee

Outward Supplies and Tax Components

ITC Availability and Ineligible ITC

0 1 2 3 4 5 6 7 8 43522 9 10 11 43430 9 12 13 43419 9 14 15 43416 9 16 17 43410 9 18 19 43399 9 20 21 43378 9 22 23 43361 9 24 25 43361 9 GSTIN 37ABCDE1234A17 Name Demo Company Ltd. Financial Year 2017-18 26 3 27 28 29 30 31 32 417413674.38 4410214.75 8672575.47 8672575.47 0 33 0 0 34 34 0 35 4582.14 0 274.93 274.93 0 36 93061 0 34 34 34 37 0 34 34 34 34 38 30855243.11 34 34 34 34 39 27317374.01 34 34 34 34 40 -427268 -76908.24 0 0 0 41 0 0 34 34 0 42 57142.86 0 1428.57 1428.57 0 43 57142.86 0 1428.57 1428.57 0 44 0 0 0 0 0 45 0 0 34 34 0 46 0 0 0 0 0 47 0 0 34 34 34 48 0 0 0 0 0 49 0 0 34 34 0 50 0 0 0 0 0 51 0 0 0 0 0 52 3 27 28 29 30 31 32 411171069.38 4410214.75 8672575.47 8672575.47 0 33 0 0 34 34 0 35 4582.14 0 274.93 274.93 0 36 93061 0 34 34 34 37 0 34 34 34 34 38 30855243.11 34 34 34 34 39 27317374.01 34 34 34 34 40 -427268 -76908.24 0 0 0 41 0 0 34 34 0 42 57142.86 0 1428.57 1428.57 0 43 57142.86 0 1428.57 1428.57 0 GSTIN 37ABCDE1234A17 Name Demo Company Ltd. Financial Year 2017-18 53 3 27 28 29 30 31 54 411175651.35 4410214.61 8672850.28 8672850.28 0 55 6335666 0 34 34 0 56 0 34 34 34 34 57 503779704.02 0 12662982.96 12662982.96 0 58 0 34 34 34 34 59 34 0 34 34 0 60 34 0 34 34 0 61 34 0 12662982.96 12662982.96 0 62 34 10075.58 9057322.9 9057322.9 0 63 34 122588.63 17154699.24 19098501.24 0 64 34 0 0 0 0 65 34 0 0 1943802 0 66 34 132664.21 38875005.1 38875005.1 0 67 34 0 0 0 0 68 34 0 0 0 0 69 30734243.11 34 34 34 34 70 0 34 34 34 34 71 27365108.01 34 34 34 34 72 0 34 34 34 34 6.1 Payment of Tax - Total Tax Paid 34 4410214 21335831 21335831 0 73 34 132664 4119218 158332 34 74 34 0 7722740 34 34 75 34 0 7718778 34 34 76 34 34 34 34 0 77 34 34 34 34 34 78 34 0 13613091 13617053 0 6.1 Payment of Tax - Interest paid in Cash 34 0 0 0 0 6.1 Payment of Tax - Late Fee paid in Cash 34 34 0 0 34 79 34 34 34 34 34 80 34 34 34 34 34 3 42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 81 3.1 (a) Outward taxable supplies (other than zero rated, nil rated and exempted) Taxable Value 0 0 0 40683631 2090789.45 11000 2200 19100249.68 26163201.79 79474142.77 132848711.51 110801725.15 411175651.35 IGST 0 0 0 107656 103940.37 0 0 1184449.28 38632.5 1997145.13 235915.97 742475.36 4410214.61 CGST 0 0 0 968085 719 660 132 311598.31 633363.3 1005343.23 3212725.15 2540224.29 8672850.28 SGST 0 0 0 968085 719 660 132 311598.31 633363.3 1005343.23 3212725.15 2540224.29 8672850.28 Cess 0 0 0 0 0 0 0 0 0 0 0 0 0 3.1 (b) Outward taxable supplies (zero rated) Taxable Value 0 0 0 0 0 0 0 426637 5668427 93061 88071 59470 6335666 IGST 0 0 0 0 0 0 0 0 0 0 0 0 0 Cess 0 0 0 0 0 0 0 0 0 0 0 0 0 3.1 (c) Other outward supplies (Nil rated, exempted) Value 0 0 0 0 0 0 0 0 0 0 0 0 0 3.1 (d) Inward supplies (liable to reverse charge) Taxable Value 0 0 0 44000 391821 377832 0 105266523.7 60675401.23 212069927.25 74691309.89 50262888.95 503779704.02 IGST 0 0 0 0 0 0 0 0 0 0 0 0 0 CGST 0 0 0 3960 35264 34005 0 2631663.4 1516885.26 5301749.99 1882882.92 1256572.39 12662982.96 SGST 0 0 0 3960 35264 34005 0 2631663.4 1516885.26 5301749.99 1882882.92 1256572.39 12662982.96 Cess 0 0 0 0 0 0 0 0 0 0 0 0 0 3.1 (e) Non-GST outward supplies Value 0 0 0 0 0 0 0 0 0 0 0 0 0 4 (A) ITC Available - (1) Import of goods IGST 0 0 0 0 0 0 0 0 0 0 0 0 0 Cess 0 0 0 0 0 0 0 0 0 0 0 0 0 4 (A) ITC Available - (2) Import of services IGST 0 0 0 0 0 0 0 0 0 0 0 0 0 Cess 0 0 0 0 0 0 0 0 0 0 0 0 0 4 (A) ITC Available - (3) Inward supplies liable to reverse charge (other than 1 and 2) IGST 0 0 0 0 0 0 0 0 0 0 0 0 0 CGST 0 0 0 3960 35264 34005 0 2631663.4 1516885.26 5301749.99 1882882.92 1256572.39 12662982.96 SGST 0 0 0 3960 35264 34005 0 2631663.4 1516885.26 5301749.99 1882882.92 1256572.39 12662982.96 Cess 0 0 0 0 0 0 0 0 0 0 0 0 0 4 (A) ITC Available - (4) Inward supplies from ISD IGST 0 0 0 0 0 0 0 0 0 0 10075.58 0 10075.58 CGST 0 0 0 0 0 0 0 0 0 0 9057322.9 0 9057322.9 SGST 0 0 0 0 0 0 0 0 0 0 9057322.9 0 9057322.9 Cess 0 0 0 0 0 0 0 0 0 0 0 0 0 4 (A) ITC Available -

FAQs

What GSTIN and company details are included in the sample?

The sample lists GSTIN and the company name as part of the header information, along with the financial year (2017-18).

How does the sample separate outward taxable supplies?

Outward supplies are grouped into categories such as other than zero rated, nil rated and exempted, zero rated, and other outward supplies like nil rated or exempted.

What ITC sections are shown in the sample?

The sample includes ITC available (by import of goods, import of services, and reverse charge inward supplies), ITC reversed, net ITC available, and ineligible ITC sections.

Aug 31, 2026

Upload by Rowan