telangana gst waybill - how to fill excel template file

Column B1: Enter Your GST Registration Number  (Who generated waybill)

Column A: Select Document Type: Tax Invoice/Bill of Supply/Delivery Challan

Column B: Enter Taxable Value (Before Tax Amount)

Column C: Select SGST Tax Percentage from the list (Example: 0, 2.5, 6, 9,14.)

Column D: Enter SGST Value

Column E: Select CGST Tax Percentage from the list (Example: 0, 2.5, 6, 9,14.)

Column F: Enter CGST Value

Note: Column C, D, E and F is only for intra State Supply (within Telangana State), else Select/Enter '0 (Zero)' in these fields.

Note: Column C & E tax Percentage should be same

Column G: Select IGST Tax Percentage from the list (Example: 0,3, 5, 12, 28.)

Column H: Enter IGST Value

Note: Column G and H is only for inter State Supply (Outside Telangana State), else Select/Enter '0 (Zero)' in these fields.

Column I: Enter Cess. If there is no CESS, enter '0 (Zero)'

Column J: Enter Total Tax Invoice/Bill of Supply/Delivery Challan Value

Column K: Enter Invoice/Bill of Supply/Delivery Challan Number
Column L: Enter Invoice/Bill of Supply/Delivery Challan Date

Note: Date Format must be (dd-mm-yyyy) [Example: Correct: 18-08-2017, Wrong: 18.08.2017]

Column M: Enter HSN Code

Note: Enter If you Know your product HSN Code enter, else enter 12345678

Column N: Select your Commodity from the list

Column O: Enter Qty (Example: 1,2,3...)

Column P: Select UOM from the list (Example: Box, Kg, Numbers...)

Note: Invoice contains more than one tax rates enter details on second row.

How to fill Excel template for generate Telangana dealers_2

After entering all the fields save excel file for upload.