Skip to main content

GSTR1 returns Problems

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.

Comments

Popular posts from this blog

Different ways to make E-invoice using vfas

  Different ways to make E-invoice using vfas - JSON_preperation_FormA(version1.01).xlsm   - prepare your profile info enter invoice details This file can not be opened from vfas to fill data so data is exported to ANOTHER XLS file from vfas on bill screen OPEN THE FILE select the entire line or lines copy by ctrl C and paste it on Json_prep... xlsm file as shown below Then press validate button. It will show if any data needs correction. Prepare Json .

DATA PREPARATION FOR E-INVOICE

 DATA PREPARATION FOR E-INVOICE SELF DATA ( Seller Details)  vfas- 6.Tools - company details Buyer (Customer Details) Pincode , Place city be entered in place provided.

Two button E-invoice preparation in vfas

 TWO BUTTON E-INVOICE PREPARATION IN VFAS OPEN THE BILL CLICK ON Einv JSON button json file will be exported open the einvoice portal as shown below  click on bulk upload select the file from einv_2021 folder in your vfas data folder click the upload button click the download excel button goto bill screen click on Read IRN button vfas will read the downloaded file and save IRN, Ack.No,Ack dt, Eway bill NO