Scribd
Upload
31 views33 pages

Ashok Dec GSTR 1

The document provides instructions for using an offline tool to generate a JSON file from data in Excel sheets related to GSTN portal entries. It emphasizes the importance of not modifying data after exporting from Tally.ERP 9 and suggests using separate workbooks for each month to avoid confusion during uploads. Additionally, it includes a summary of B2B transactions with GSTIN, invoice numbers, dates, values, and places of supply.

Uploaded by

AKSHAT KUMAR
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
31 views33 pages

Ashok Dec GSTR 1

The document provides instructions for using an offline tool to generate a JSON file from data in Excel sheets related to GSTN portal entries. It emphasizes the importance of not modifying data after exporting from Tally.ERP 9 and suggests using separate workbooks for each month to avoid confusion during uploads. Additionally, it includes a summary of B2B transactions with GSTIN, invoice numbers, dates, values, and places of supply.

Uploaded by

AKSHAT KUMAR
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 33

Help Instructions

1. The offline tool for generating the JSON file will not take the data available in the sheets exemp and docs
2. The values in these sheets are in the same order as in the portal.
3. You can manually enter the data from these sheets directly into the GSTN portal.

Visit TallyHelp for more information on:


1. GSTR1 Filing
2. Data captured in GSTR1 Return

Please Note
1. This Excel workbook works best with Microsoft Excel 2003 or later.
2. We recommend that you do not modify the data in Excel after exporting from Tally.ERP 9.
3. Use separate Excel workbooks for each month, with the month name as a part of the file name. In case there are multiple
if
4. you import
If any invoiceindata
data exists multipletool
the offline times in ayou
when taxare
period, followdata
importing a similar patternallforthe
from Excel, theexisting
JSON file
dataname.
will be overwritten.
mp and docs.

e. In case there are multiple uploads for a month, use Part A, Part B, and so on, in the file name to avoid confusion. Similarly,
ile name.
data will be overwritten.
d confusion. Similarly,
Summary For B2B(4)

GSTIN/UIN of Recipient Invoice Number Invoice date Invoice Value Place Of Supply
20AAACS8577K1Z3 158 1-Oct-17 22,585.20 20-Jharkhand
20AAACS8577K1Z3 159 1-Oct-17 3,540.00 20-Jharkhand
20AAACS8577K1Z3 160 1-Oct-17 28,737.72 20-Jharkhand
20AAACS8577K1Z3 162 1-Oct-17 11,954.58 20-Jharkhand
20AAACS8577K1Z3 163 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 164 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 165 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 166 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 167 1-Oct-17 4,543.00 20-Jharkhand
20AAACS8577K1Z3 168 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 169 1-Oct-17 4,543.00 20-Jharkhand
20AAACS8577K1Z3 170 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 171 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 174 1-Oct-17 1,947.00 20-Jharkhand
20AAACS8577K1Z3 175 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 176 1-Oct-17 4,543.00 20-Jharkhand
20AAACS8577K1Z3 177 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 178 1-Oct-17 4,543.00 20-Jharkhand
20AAACS8577K1Z3 179 1-Oct-17 19,158.48 20-Jharkhand
20AAACS8577K1Z3 180 1-Oct-17 19,158.48 20-Jharkhand
20AAACS8577K1Z3 181 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 182 1-Oct-17 4,543.00 20-Jharkhand
20AAACS8577K1Z3 183 1-Oct-17 4,543.00 20-Jharkhand
20AAACS8577K1Z3 184 1-Oct-17 8,301.30 20-Jharkhand
20AAACS8577K1Z3 186 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 187 1-Oct-17 8,142.00 20-Jharkhand
20AAACS8577K1Z3 188 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 189 1-Oct-17 9,086.00 20-Jharkhand
20AAACS8577K1Z3 190 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 191 1-Oct-17 11,292.60 20-Jharkhand
20AAACS8577K1Z3 192 1-Oct-17 12,620.10 20-Jharkhand
20AAACS8577K1Z3 193 1-Oct-17 4,543.00 20-Jharkhand
20AAACS8577K1Z3 194 1-Oct-17 19,158.48 20-Jharkhand
20AAACS8577K1Z3 195 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 196 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 197 1-Oct-17 7,788.00 20-Jharkhand
20AAACS8577K1Z3 198 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 199 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 200 1-Oct-17 1,947.00 20-Jharkhand
20AAACS8577K1Z3 201 1-Oct-17 19,158.48 20-Jharkhand
20AAACS8577K1Z3 202 1-Oct-17 3,894.00 20-Jharkhand
20AAACS8577K1Z3 204 1-Oct-17 20,720.80 20-Jharkhand
20AAACS8577K1Z3 205 1-Oct-17 22,585.20 20-Jharkhand
20AAACS8577K1Z3 210 1-Oct-17 14,160.00 20-Jharkhand
20AAACS8577K1Z3 211 1-Oct-17 9,579.24 20-Jharkhand
20AAACS8577K1Z3 212 1-Oct-17 9,086.00 20-Jharkhand
20AAACS8577K1Z3 214 1-Oct-17 29,181.40 20-Jharkhand
20AAACS8577K1Z3 215 1-Oct-17 5,192.00 20-Jharkhand
20AAACS8577K1Z3 217 1-Oct-17 11,109.70 20-Jharkhand
20AAACS8577K1Z3 219 1-Oct-17 9,086.00 20-Jharkhand
20AAACS8577K1Z3 220 1-Oct-17 4,543.00 20-Jharkhand
20AAACS8577K1Z3 221 1-Oct-17 1,298.00 20-Jharkhand
20AAACS8577K1Z3 223 1-Oct-17 16,603.78 20-Jharkhand
20AAACS8577K1Z3 229 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 230 1-Nov-17 9086.00 20-Jharkhand
20AAACS8577K1Z3 231 1-Nov-17 19796.86 20-Jharkhand
20AAACS8577K1Z3 232 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 233 1-Nov-17 11669.02 20-Jharkhand
20AAACS8577K1Z3 234 1-Nov-17 13040.18 20-Jharkhand
20AAACS8577K1Z3 235 1-Nov-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 236 1-Nov-17 19796.86 20-Jharkhand
20AAACS8577K1Z3 237 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 238 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 239 1-Nov-17 7788.00 20-Jharkhand
20AAACS8577K1Z3 240 1-Nov-17 30237.50 20-Jharkhand
20AAACS8577K1Z3 241 1-Nov-17 3894.00 20-Jharkhand
20AAACS8577K1Z3 242 1-Nov-17 20720.80 20-Jharkhand
20AAACS8577K1Z3 243 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 245 1-Nov-17 1947.00 20-Jharkhand
20AAACS8577K1Z3 246 1-Nov-17 23338.04 20-Jharkhand
20AAACS8577K1Z3 247 1-Nov-17 14160.00 20-Jharkhand
20AAACS8577K1Z3 248 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 249 1-Nov-17 9086.00 20-Jharkhand
20AAACS8577K1Z3 250 1-Nov-17 9086.00 20-Jharkhand
20AAACS8577K1Z3 251 1-Nov-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 252 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 253 1-Nov-17 8142.00 20-Jharkhand
20AAACS8577K1Z3 254 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 255 1-Nov-17 9086.00 20-Jharkhand
20AAACS8577K1Z3 259 1-Nov-17 12353.42 20-Jharkhand
20AAACS8577K1Z3 266 1-Nov-17 16603.78 20-Jharkhand
20AAACS8577K1Z3 267 1-Nov-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 268 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 269 1-Nov-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 270 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 271 1-Nov-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 272 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 273 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 274 1-Nov-17 1947.00 20-Jharkhand
20AAACS8577K1Z3 275 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 276 1-Nov-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 277 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 278 1-Nov-17 19796.86 20-Jharkhand
20AAACS8577K1Z3 279 1-Nov-17 19796.86 20-Jharkhand
20AAACS8577K1Z3 280 1-Nov-17 9899.02 20-Jharkhand
20AAACS8577K1Z3 281 1-Nov-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 282 1-Nov-17 8301.30 20-Jharkhand
20AAACS8577K1Z3 283 1-Nov-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 284 1-Nov-17 12564.64 20-Jharkhand
20AAACS8577K1Z3 285 1-Nov-17 1298.00 20-Jharkhand
20AAACS8577K1Z3 286 1-Nov-17 10360.40 20-Jharkhand
20AAACS8577K1Z3 287 1-Nov-17 5192.00 20-Jharkhand
20AAACS8577K1Z3 01/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 02/Nov/Ash/2017 1-Dec-17 11292.60 20-Jharkhand
20AAACS8577K1Z3 03/Nov/Ash/2017 1-Dec-17 9086.00 20-Jharkhand
20AAACS8577K1Z3 04/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 05/Nov/Ash/2017 1-Dec-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 07/Nov/Ash/2017 1-Dec-17 1298.00 20-Jharkhand
20AAACS8577K1Z3 08/Nov/Ash/2017 1-Dec-17 29181.40 20-Jharkhand
20AAACS8577K1Z3 09/Nov/Ash/2017 1-Dec-17 27911.72 20-Jharkhand
20AAACS8577K1Z3 010/Nov/Ash/2017 1-Dec-17 3894.00 20-Jharkhand
20AAACS8577K1Z3 011/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 012/Nov/Ash/2017 1-Dec-17 5192.00 20-Jharkhand
20AAACS8577K1Z3 013/Nov/Ash/2017 1-Dec-17 8142.00 20-Jharkhand
20AAACS8577K1Z3 014/Nov/Ash/2017 1-Dec-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 015/Nov/Ash/2017 1-Dec-17 9499.00 20-Jharkhand
20AAACS8577K1Z3 016/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 017/Nov/Ash/2017 1-Dec-17 7788.00 20-Jharkhand
20AAACS8577K1Z3 018/Nov/Ash/2017 1-Dec-17 9086.00 20-Jharkhand
20AAACS8577K1Z3 019/Nov/Ash/2017 1-Dec-17 17651.62 20-Jharkhand
20AAACS8577K1Z3 020/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 022/Nov/Ash/2017 1-Dec-17 17034.48 20-Jharkhand
20AAACS8577K1Z3 023/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 024/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 025/Nov/Ash/2017 1-Dec-17 1947.00 20-Jharkhand
20AAACS8577K1Z3 026/Nov/Ash/2017 1-Dec-17 18454.02 20-Jharkhand
20AAACS8577K1Z3 027/Nov/Ash/2017 1-Dec-17 19158.48 20-Jharkhand
20AAACS8577K1Z3 028/Nov/Ash/2017 1-Dec-17 26749.42 20-Jharkhand
20AAACS8577K1Z3 31/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 32/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 33/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 34/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 35/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 37/Nov/Ash/2017 1-Dec-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 38/Nov/Ash/2017 1-Dec-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 39/Nov/Ash/2017 1-Dec-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 040/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 041/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 042/Nov/Ash/2017 1-Dec-17 8302.48 20-Jharkhand
20AAACS8577K1Z3 043/Nov/Ash/2017 1-Dec-17 19158.48 20-Jharkhand
20AAACS8577K1Z3 044/Nov/Ash/2017 1-Dec-17 19158.48 20-Jharkhand
20AAACS8577K1Z3 046/Nov/Ash/2017 1-Dec-17 9579.24 20-Jharkhand
20AAACS8577K1Z3 047/Nov/Ash/2017 1-Dec-17 4543.00 20-Jharkhand
20AAACS8577K1Z3 048/Nov/Ash/2017 1-Dec-17 16603.78 20-Jharkhand
Reverse Charge Invoice Type E-Commerce GSTIN Rate Taxable Value Cess Amount
N Regular 18.00 19,140.00
N Regular 18.00 3,000.00
N Regular 18.00 24,354.00
N Regular 18.00 10,131.00
N Regular 18.00 8,118.00
N Regular 18.00 8,118.00
N Regular 18.00 8,118.00
N Regular 18.00 8,118.00
N Regular 18.00 3,850.00
N Regular 18.00 8,118.00
N Regular 18.00 3,850.00
N Regular 18.00 8,118.00
N Regular 18.00 8,118.00
N Regular 18.00 1,650.00
N Regular 18.00 8,118.00
N Regular 18.00 3,850.00
N Regular 18.00 8,118.00
N Regular 18.00 3,850.00
N Regular 18.00 16,236.00
N Regular 18.00 16,236.00
N Regular 18.00 8,118.00
N Regular 18.00 3,850.00
N Regular 18.00 3,850.00
N Regular 18.00 7,035.00
N Regular 18.00 8,118.00
N Regular 18.00 6,900.00
N Regular 18.00 8,118.00
N Regular 18.00 7,700.00
N Regular 18.00 8,118.00
N Regular 18.00 9,570.00
N Regular 18.00 10,695.00
N Regular 18.00 3,850.00
N Regular 18.00 16,236.00
N Regular 18.00 8,118.00
N Regular 18.00 8,118.00
N Regular 18.00 6,600.00
N Regular 18.00 8,118.00
N Regular 18.00 8,118.00
N Regular 18.00 1,650.00
N Regular 18.00 16,236.00
N Regular 18.00 3,300.00
N Regular 18.00 17,560.00
N Regular 18.00 19,140.00
N Regular 18.00 12,000.00
N Regular 18.00 8,118.00
N Regular 18.00 7,700.00
N Regular 18.00 24,730.00
N Regular 18.00 4,400.00
N Regular 18.00 9,415.00
N Regular 18.00 7,700.00
N Regular 18.00 3,850.00
N Regular 18.00 1,100.00
N Regular 18.00 14,071.00
N Regular 18.00 8,389.00
N Regular 18.00 7,700.00
N Regular 18.00 16,777.00
N Regular 18.00 8,389.00
N Regular 18.00 9,889.00
N Regular 18.00 11,051.00
N Regular 18.00 3,850.00
N Regular 18.00 16,777.00
N Regular 18.00 8,389.00
N Regular 18.00 8,389.00
N Regular 18.00 6,600.00
N Regular 18.00 25,625.00
N Regular 18.00 3,300.00
N Regular 18.00 17,560.00
N Regular 18.00 8,389.00
N Regular 18.00 1,650.00
N Regular 18.00 19,778.00
N Regular 18.00 12,000.00
N Regular 18.00 8,389.00
N Regular 18.00 7,700.00
N Regular 18.00 7,700.00
N Regular 18.00 3,850.00
N Regular 18.00 8,389.00
N Regular 18.00 6,900.00
N Regular 18.00 8,389.00
N Regular 18.00 7,700.00
N Regular 18.00 10,469.00
N Regular 18.00 14,071.00
N Regular 18.00 3,850.00
N Regular 18.00 8,389.00
N Regular 18.00 3,850.00
N Regular 18.00 8,389.00
N Regular 18.00 3,850.00
N Regular 18.00 8,389.00
N Regular 18.00 8,389.00
N Regular 18.00 1,650.00
N Regular 18.00 8,389.00
N Regular 18.00 3,850.00
N Regular 18.00 8,389.00
N Regular 18.00 16,777.00
N Regular 18.00 16,777.00
N Regular 18.00 8,389.00
N Regular 18.00 3,850.00
N Regular 18.00 7,035.00
N Regular 18.00 3,850.00
N Regular 18.00 10,648.00
N Regular 18.00 1,100.00
N Regular 18.00 8,780.00
N Regular 18.00 4,400.00
N Regular 18.00 8118.00
N Regular 18.00 9570.00
N Regular 18.00 7700.00
N Regular 18.00 8118.00
N Regular 18.00 3850.00
N Regular 18.00 1100.00
N Regular 18.00 24730.00
N Regular 18.00 23654.00
N Regular 18.00 3300.00
N Regular 18.00 8118.00
N Regular 18.00 4400.00
N Regular 18.00 6900.00
N Regular 18.00 3850.00
N Regular 18.00 8050.00
N Regular 18.00 8118.00
N Regular 18.00 6600.00
N Regular 18.00 7700.00
N Regular 18.00 14959.00
N Regular 18.00 8118.00
N Regular 18.00 14436.00
N Regular 18.00 8118.00
N Regular 18.00 8118.00
N Regular 18.00 1650.00
N Regular 18.00 15639.00
N Regular 18.00 16236.00
N Regular 18.00 22669.00
N Regular 18.00 8118.00
N Regular 18.00 8118.00
N Regular 18.00 8118.00
N Regular 18.00 8118.00
N Regular 18.00 8118.00
N Regular 18.00 3850.00
N Regular 18.00 3850.00
N Regular 18.00 3850.00
N Regular 18.00 8118.00
N Regular 18.00 8118.00
N Regular 18.00 7036.00
N Regular 18.00 16236.00
N Regular 18.00 16236.00
N Regular 18.00 8118.00
N Regular 18.00 3850.00
N Regular 18.00 14071.00
Summary For B2CL(5)

Invoice Number Invoice date Invoice Value Place Of Supply Rate


Taxable Value Cess Amount E-Commerce GSTIN
Summary For B2CS(7)

Type Place Of Supply Rate Taxable Value Cess Amount


E-Commerce GSTIN
Summary For CDNR(9B)

GSTIN/UIN of Recipient Invoice/Advance Receipt Number Invoice/Advance Receipt date


Note/Refund Voucher Number Note/Refund Voucher date Document Type
Reason For Issuing document Place Of Supply Note/Refund Voucher Value Rate Taxable Value
Cess Amount Pre GST
Summary For CDNUR(9B)

UR Type Note/Refund Voucher Number Note/Refund Voucher date


Document Type Invoice/Advance Receipt Number Invoice/Advance Receipt date
Reason For Issuing document Place Of Supply Note/Refund Voucher Value Rate
Taxable Value Cess Amount Pre GST
Summary For EXP(6)

Export Type Invoice Number Invoice date Invoice Value Port Code
Shipping Bill Number Shipping Bill Date Rate Taxable Value
Summary For
Advance Received
(11B)

Place Of Supply Rate Gross Advance Received Cess Amount


Summary For
Advance Adjusted
(11B)

Place Of Supply Rate Gross Advance Adjusted Cess Amount


Summary For Nil rated, exempted and non
GST outward supplies (8)

Description Nil Rated Supplies Exempted (other than nil


rated/non GST supply )
Inter-State supplies to registered persons
Intra-State supplies to registered persons
Inter-State supplies to unregistered persons
Intra-State supplies to unregistered persons
Non-GST supplies
Summary For HSN(12)

HSN Description UQC Total Quantity Total Value Taxable Value


Integrated Tax Amount Central Tax Amount State/UT Tax Amount Cess Amount
Summary of documents issued during the tax period (13)

Nature of Document Sr. No. From Sr. No. To Total Number


Cancelled

You might also like