New offline tool was 1.2 was put on GSTN website on 1-9-17
The JSON file created by previous tools can not be read as there are structure changes.
Offline java tool which imports excel sheet or csv sheets has problem importing
multi rate GST in 1 invoice it accepts only the last line of that bill
eg.
Bill No taxable GST
G-005 1000 5%
G-005 2000 12%
when complete excel sheet is imported it accepts only the second line.
So if you make bill with MIX GST do not import the excel file it imports without errors but there will be problems afterwards.
Instead of this import import b2b.csv
Other important point is with HSN viz summary
If you are selling edible oil
HSN description measure UQC (unit quantity)
1508 xyz oil 15KgTin
1508 xyz oil 15lit tin
1508 xyz oil 5lit jar
1508 xyz oil 1lit bottle
it will accept only 1 line per HSN so at present you have to manually
sum the quantity , taxable Rs. cgst Rs sgst rs igst rs
so prepare a xls sheet from our hsn.csv and make a sum line for this item
give appropriate UQC convert all measures to reflect correct conversion to selected UQC. This final prepared sheet can be entered in offline java tool.
Reverse Charge Bills
In these bills we have to mention receipients GST no.
Reverse charge bills arise in 2 ways
1. Billers who have TIN No ( Transport agency)
2. Un registered billers URD who do not have GST no.
At present the java utility does not allow blank GSTNo or it does not allow your own GST no.
The JSON file created by previous tools can not be read as there are structure changes.
Offline java tool which imports excel sheet or csv sheets has problem importing
multi rate GST in 1 invoice it accepts only the last line of that bill
eg.
Bill No taxable GST
G-005 1000 5%
G-005 2000 12%
when complete excel sheet is imported it accepts only the second line.
So if you make bill with MIX GST do not import the excel file it imports without errors but there will be problems afterwards.
Instead of this import import b2b.csv
Other important point is with HSN viz summary
If you are selling edible oil
HSN description measure UQC (unit quantity)
1508 xyz oil 15KgTin
1508 xyz oil 15lit tin
1508 xyz oil 5lit jar
1508 xyz oil 1lit bottle
it will accept only 1 line per HSN so at present you have to manually
sum the quantity , taxable Rs. cgst Rs sgst rs igst rs
so prepare a xls sheet from our hsn.csv and make a sum line for this item
give appropriate UQC convert all measures to reflect correct conversion to selected UQC. This final prepared sheet can be entered in offline java tool.
Reverse Charge Bills
In these bills we have to mention receipients GST no.
Reverse charge bills arise in 2 ways
1. Billers who have TIN No ( Transport agency)
2. Un registered billers URD who do not have GST no.
At present the java utility does not allow blank GSTNo or it does not allow your own GST no.
Comments
Post a Comment