GSTN portal provided GSTR1 offline utility in order to upload date in specified format which support java utility on GSTN portal and you can feed your data offline and than upload the same in one go at GSTN portal www.gst.gov.in. I show you here the details which you have to keep in my mind while uploading data for your GSTR 1.
Below are Instruction of GSTR 1 Offline Utility:-
The Offline tool comes bundled with MS Excel Template and a java tool.
This Excel workbook template has 11 data entry worksheets, 1 master sheet and 1 Help Instruction sheet i.e. total 13 worksheets. The 11 data entry worksheets are named: b2b, b2cl, b2cs, cdnr, cdnur exp, at, atadj, exemp, hsn and doc in which day-to-day business transaction required to be reported in GSTR 1 can be recorded or entered by the taxpayers. At desired interval, the data entered in the MS-Excel worksheet can be uploaded on the GST Portal using the java offline tool which will import the data from excel workbook and convert the same into a Json file which is understood by GST portal. (www.gst.gov.in)
It has been designed to enable taxpayers to prepare GSTR 1 in offline mode (without Internet). It can also be used to carry out bulk upload of invoice/other details to GST portal.
The appearance and functionalities of the Offline tool screens are similar to that of the returns filing screens on the GST Portal.
Approximately 19,000 line items can be uploaded in one go using the java tool. In case a taxpayer has more invoice data, he can use the tool multiple times to upload the invoice data.
My Smart home channel link:
To download GST Excel Template file click below:-
for GST registration process than click below:
For checking your GST registration status click below:
For GST Planning and Implementation doubts click below video:
Mail us at firstname.lastname@example.org
IProducts I use for video recording and more, Link to buy are below. Please click:
Budget Mike for Audio recording:
Generic 57000928MG Silica Gel Professional Condenser Microphone Mic Sound Studio Recording Dynamic (Works with Phantom Power Supply Or Sound Card Only)
iball Rocky with mike, headphone and speakers:
Redme note 4 (xiaomi)
Coolpad Cool 1 (Gold, 3GB RAM + 32GB memory)
Coolpad Note 5 (Royal Gold, 32 GB)
memore Mini Tripod Universal YT-228 For Digital Camera & All Mobile Phones- Black (YT-228 Tripod)
Lenovo Ideapad 320E 80XH01GKIN 15.6-inch Laptop (6th Gen Core i3-6006U/4GB/1TB/FreeDOS/Integrated Graphics)
HP HP 15 HP Notebook 15-BS549TU 2017 15.6-inch Laptop (Celeron N3060/4GB/500GB/Windows 10 Home Single Language(64 bit)/Integrated Graphics), Jet Black
Lenovo 510S-08IAP 90GB000QIN 21.5-inch All-in-One Desktop (Intel Core i3 7th Gen/7100/4GB/1TB/DOS/Integrated Graphics) LED IPS Monitor:
Tegh Computers Complete Desktop Computers Intel Core 2 Duo/2 GB/160 GB/15 Inch Led
Please Like, Share and Subscribe
Thanks for watching