जीएसटीआर1 आॅफलाईन टूल
GSTR1 Offline Tool
सरकार ने जीएसटी से सम्बंधित विवरणी जीएसटीआर1 तैयार करने हेतु करदाताओं की सुविधा के लिए आॅफलाईन टूल जारी किया है। यह एक्सेल की एक फाईल है जिसमें 11 डाटा—इन्ट्री वर्कशीट, 1 मास्टर शीट और 1 हेल्प शीट है। कोई भी व्यक्ति अपने सभी लेन—देन सम्बंधी सूचनाओं को दर्ज कर इसे जीएसटी के आधिकारिक वेबसाईट पर अपलोड किया जा सकता है।
नीचे आॅफलाईन टूल के हेल्प शीट में दर्ज सूचनाओं को आपके जानकारी व सहायता हेतु यथावत साझा किया जा रहा है। पाठकों से अनुरोध है कि सूचना पर अमल करते समय आधिकारिक वेबसाईट से इसकी पुष्टि अवश्य कर लें।
Offline Tool डाउनलोड करने के लिए यहां क्लिक करें अथवा आधिकारिक वेबसाइट पर पधारें.
Introduction to Excel based template for data upload in Java offline tool.
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.
Data can be uploaded/entered to the offline tool in four ways:
1. Importing the entire excel workbook to the java tool where data in all sections (worksheets) of the excel file will be imported in the tool in one go.
2. Line by line data entry by return preparer on the java offline tool.
3. Copy from the excel worksheets from the top row including the summary and header and pasting it in the designated box in the import screen of the java offline tool. Precaution: All the columns including headers should be in the same format and have the same header as of the java offline tool.
4. Section by section of a particular return - using a .CSV file as per the format given along with the java tool. Many accounting software packages generate .CSV file in the specified format and the same can be imported in the tool."
1. Importing the entire excel workbook to the java tool where data in all sections (worksheets) of the excel file will be imported in the tool in one go.
2. Line by line data entry by return preparer on the java offline tool.
3. Copy from the excel worksheets from the top row including the summary and header and pasting it in the designated box in the import screen of the java offline tool. Precaution: All the columns including headers should be in the same format and have the same header as of the java offline tool.
4. Section by section of a particular return - using a .CSV file as per the format given along with the java tool. Many accounting software packages generate .CSV file in the specified format and the same can be imported in the tool."
Understanding the Excel Workbook Template
a) It is always recommended to download the excel workbook template from the GST portal only.
a) It is always recommended to download the excel workbook template from the GST portal only.
b) The taxpayer can fill the excel workbook template with different worksheet for the applicable sections of the return and then import the excel file to the java tool. Data has to be filled in the sections (worksheets) applicable to him and the others may be left blank.
c) The data in the excel file should be in the format specified below in respective sections.
d) In a case where the taxpayer does not have data applicable for all sections, those sections may be left blank and the java tool will automatically take care of the data to be filled in the applicable sections only.
e) For Group import (all worksheets of workbook) taxpayer need to fill all the details into downloaded standard format GSTR1_Excel_Workbook_Template-V1.0.xlsx file
d) In a case where the taxpayer does not have data applicable for all sections, those sections may be left blank and the java tool will automatically take care of the data to be filled in the applicable sections only.
e) For Group import (all worksheets of workbook) taxpayer need to fill all the details into downloaded standard format GSTR1_Excel_Workbook_Template-V1.0.xlsx file
f) User can export Data from local accounting software loaded in the above format as .CSV file and import it in the java tool to generate the file in .Json format for bulk. Warning: Your accounting software should generate .CSV file in the format specified by GST Systems.
g) In all the worksheets except hsn, the central tax, integrated tax, and state tax are not required to be furnished in the excel worksheets but would be computed on the furnished rate and taxable value in the java offline tool. The taxpayer can edit the tax amounts calculated in the java tool if the tax collected values are different.
h) In the "doc's worksheet, the net issued column has not been provided, this value will be computed in the java offline tool based on the total number of documents and the number of cancelled documents furnished in this worksheet.
g) In all the worksheets except hsn, the central tax, integrated tax, and state tax are not required to be furnished in the excel worksheets but would be computed on the furnished rate and taxable value in the java offline tool. The taxpayer can edit the tax amounts calculated in the java tool if the tax collected values are different.
h) In the "doc's worksheet, the net issued column has not been provided, this value will be computed in the java offline tool based on the total number of documents and the number of cancelled documents furnished in this worksheet.
إرسال تعليق