Monday, August 21, 2017

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.

how to fill gst waybill template for telangana vat dealers


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 gst waybill
How to fill Excel template for generate Telangana dealers_2

After entering all the fields save excel file for upload.


Share your doubts in comment box


12 comments:

  1. Thanks for information. I am filling correct GST no. in column B1 but getting message to fill correct GST no. I could not understand how to fill. Please help.

    ReplyDelete
    Replies
    1. Dear Telangana VAT Dealer,

      Please enter Your (Who generated waybill) GST number in column B.

      Tips:
      Use different browser.
      Use another system/laptop.
      Use speed internet for better performance and ignore mobile data.
      Cleanup your browser history and retry.

      Regards
      G.VASU



      Delete
  2. i have 2 different tax rate material in same invoice.how to fill excel template in this situation

    ReplyDelete
    Replies
    1. Dear Mr.Ali,

      Option 1) Use separate row for each tax rate.
      option 2) Create separate invoice for each tax rate.

      Delete
  3. when uploading excel tgct says fill all colum in excell

    ReplyDelete
    Replies
    1. Hi,

      Please fill all column invoice wise. Fill '0' with invoices if not applicable.

      Delete
  4. Use EZTax.in GST App for easy Accounting and e-way bill generation

    ReplyDelete
  5. I love the way you write and share your niche! Very interesting and different! Keep it coming! excel budget spreadsheets

    ReplyDelete
  6. Essay writing is something we've all been taught time after time in the many subjects we've had throughout our academic years. We are used to different guides and different "winning techniques" to help us write the best essay we can, however sometimes those guides are blurry and unclear. essay help

    ReplyDelete

Copyright © 2015 accounting tally taxation tutorials All Right Reserved
Subscribe by Email Get Free Updates
Don't Forget To Join US Our Community
×
blogger