The conversion of json file into excel to be able to match and reconcile invoices with gstr2a is not required if you are using the cleartax gst software. This json file will be created using the data you fill in excel file provided along with offline utility. In the financial year dropdown list, select the financial year for which the return has to be uploaded. Then use it the gst portal to file your gstr 1 return. After uploading the data you need to create json file and upload the same on gst common portal. The gstn cannot recognise the json file which has been uploaded or there are structural errors in the uploaded json file. Upon successful import of the zip files in to the offline tool, the gstr 2 data downloaded from gst portal is populated section wise. Click on cleanup portal data button, and select the gstr1 file downloaded from govt portal. If the number of records is huge, then the details will be split into multiple files and the multiple files. In the financial year dropdown list, select the financial year.
Here tally erp 9 simplifies this procedure by placing this. How to download error file from gst portal and make. Select the month you would like to file gstr1 return from the dropdown menu. Sep 16, 2017 download the latest version of offline tool to generate the json file or ensure to validate your uploaded file against the template published at specification portal. The best alternative for gst offline tool without bothering about paise. Steps to generate gstr 9 through saral gst software. How to download gstr 9 offline utility in excel format on gst portal.
Use gstzens json to excel online tool to convert gstr 2a json file downloaded from the gst portal into excel format. Gst returns can be filed on the gst portal using a json file. While uploading the json file i am getting this message, file could not be uploaded. To upload the generated json file from the new return offline tool on the gst portal following steps as indicated below maybe undertaken. Steps to file gstr 2 guide for filling of gstr 2 on gst portal. The matching and reconciling is inbuilt in the software that makes your return filing process easier. This process takes place automatically because the supplier uploads his outward supplies on the gst portal on the monthlyquarterly basis in the form of various returns. To begin with, in the previous post, we had seen how to prepare gstr9c. Login to the gst portal using your username and password. Known problems while filing gstr1 and gstr3b returns. Bulk download of gstr1 files from gst portal using octa gst assistant. Upload the json prepared using offline tool using upload option in the return dashboard. Json viewer is a simple application to view json documents with highlighting and a tree view expansion.
Now, we will see the next part of gstr9c return filing. The other tabs on the right are the details that are going to go in our gstr1 return. Open the installed gst offline tool icon on desktop 2. Make sure that the gstin is specified in the json file.
If the problem still persists, download the latest version of the gst offline return tool or gst software and. The gstr1 return file can be downloaded from gst portal and viewed in the offline tool to modify, add or delete invoice details uploaded earlier by you on gst portal. If the problem still persists, download the latest version of the gst offline return tool or gst software and prepare the json file 4 no gross turnover details. Remember, you need to use the excel file provided along with utility otherwise you will get errors. You can export gstr 1 sales data as excel or csv files and import the same in offline tool. Dec 11, 2018 import from gstr 122a3b or import autocalculated json file downloaded from gst portal manual entry. With our latest update, you can directly generate a json file of your gstr 1 return and instantly upload it to the gst portal.
Error in uploading json file in gst portal gst forum. The gstr 9 form is an annual return which has to be filed by every taxpayer. Goto the required category and enter the details in the relevant fields. Import the excel data file in the above offline tool. Download the latest offline utility and file returns on the gst portal 1. Simply upload this cleanup file to gst portal and wait for 10 minutes. Json file is used by the gstn for gst return preparation and filing. Upload this json online when you check in online then data as per new json will be updated on portal.
Filing gst itc04 in gst portal how to file form itc 04 and. You will have the option to export the json file and import the same in gstn as well. In this post, we will explain the process of gstr9c json creation and upload to gst portal in saral gst. The government has provided an offline gst return preparation tool that generates json file that can be filed on the gst portal. Gst portal allows you to download the json file for gstr 2a for your inward supplies. Select the financial year, return filing period and click search. In this article, we look at the procedure for uploading json file on gst portal. Navigate to services returns new return trial select financial year, return filing period, formreturn and preparation mode from the dropdown list. Gstr6 json upload on gst portal steps by step guide. Download the latest version of offline tool to generate the json file or ensure to validate your uploaded file against the template published at specification portal.
Json file is a type of computer file based on java that is easy for humans to read and write. How to download return file from gst portal and modify. How to use offline utility for filing gstr1 return on gst. This excel file can then be imported in the offline tool and a json file prepared which can then be uploaded to the portal to prepare your gstr 2. Ensure that you have uploaded the most recent and correct json file in the gst portal under the correct gstin.
Sep, 2019 for upload json file gstr1, follow the stepsenter login details, then click loginclick file returnsselect month, then click searchclick prepare offlinechoose fileit showsclick back to returnsagain select month, then click searchclick details of outward supplies of goods and servicesthe summary displ. All about online upload and download of form gst anx2 json file. For download and use json file for annual return, follow the stepsenter login details, then click loginclick annual returnselect financial yearclick searchprepare offlineclick downloadclick generate json file to downloadit showsnow go to gst websiteclick downloadclick gstr9 offline toolsclick downl. When using the gst portal, here is a stepbystep guide to convert json to excel. Upload the json file by choosing prepare offline option. The government has provided an offline gst return preparation tool that generates json file that can be filed on the gst. May 28, 2019 the simple way to validate gstr 1 json file before filing on government gst portal by gen gst software. The uploaded json file would be validated and processed. If you like this tool, please share it with your friends. Online upload and download of form gst anx2 json file.
Sep 12, 2017 unsubscribe from shanu tiwari tax mitra. It consists of details regarding inwardoutward supplies during the year under the different tax headi. How to upload gstr 1 csv files to offline tool and generate. Gstr3b offline utility downloadjason upload on gst portal. May 20, 2019 the gstn cannot recognise the json file which has been uploaded or there are structural errors in the uploaded json file. Your new tool to convert excel files into gst json files gstr 1 within minutes. Gstr 2a captures the data automatically from the gstn database. Upload the json prepared using offline utility using upload option in the return dashboard. Use gstzens json to excel online tool to convert gstr 1 json file downloaded from the gst portal into excel format. The data in gst anx2 is majorly autopopulated from the data uploaded by the supplier in hisher form gst anx1, gstr5 and gstr6. Step 7 now you shall be able to see the summary of your return. Once form gst anx1 is prepared using offline tool, a json file can be created and the json file so created is required to be uploaded on the gst portal. A java based text file json file which can be uploaded to the gst portal, can. Before claiming input tax credit, you can check the eligible amount as per the gst portal and compare it against your books using gstr2 in tally.
Gstr 2a data is meant for a recipient of the goods and services or both. Earlier, customers had to import their return in an excel format, spend time validating the data and then convert it into json format using the govt. How to convert json file to excel for gstr 2a studycafe. Why do i need to download the gstanx 2 json file from the gst portal. Aug 28, 2017 sir, same problem of me, when we go to download option generate file, the system shows the file will be generated after 20 min, but we waiting 1hr, the file has not generated, what will do. Login to gst portal and select returns dashboard 2. In ledgers, access the gstr1 filing page from the top menu.
Guide to downloadupload json file using gstr 4 offline tool. How to upload json file gstr1 gst online procedure. Firstly, after preparing gstr9c details, go to gstr 9c in the dashboard. Oct 16, 2019 for download and use json file for annual return, follow the stepsenter login details, then click loginclick annual returnselect financial yearclick searchprepare offlineclick downloadclick generate json file to downloadit showsnow go to gst websiteclick downloadclick gstr9 offline toolsclick downl. Convert both json and zip files that you download from the gst portal into excel format. Gstr 1 format in excel and pdf download and prepare. By using an excel file, you save time as you dont need to importexport multiple csv files. To download the json file from the gst portal, navigate to returns new return trial. Nov 09, 2017 guide to downloadupload json file using gstr 4 offline tool. Lodge your grievance using selfservice help desk portal.
All about online upload download of form gst anx1 json file. Login to gst portal and select returns dashboard select the applicable financial year and taxperiod. Tips for downloading error file from gst portal consultease. To modify, add or delete details in invoices entered on gst portal one can. Download gstr2a json file of the required tax period. Gstr 1 json file validation process via gen gst software. How to download and use json file for annual return gst. Json file errors and possible suggestionsactions to be taken. Step 10 generate json file by clicking on view summary. Gst portal is providing you an offline tool for download, normally you should input data manually to the offline excel utility and generate json, then upload to the portal. First you need to download gstr1 json files from gst portal. Gstr9c json creation and upload with screenshots saral gst. This eliminates the chances of any error while uploading the json file on gst portal.
For upload json file gstr1, follow the stepsenter login details, then click loginclick file returnsselect month, then click searchclick prepare offlinechoose fileit showsclick back to returnsagain select month, then click searchclick details of outward supplies of. Aug 23, 2019 in this post, we will explain the process of gstr9c json creation and upload to gst portal in saral gst. Under the download tab, click the generate json file to download button to. Make sure that the uploaded json file is latest and correct in the gst portal in the gstin. A java based text file json file which can be uploaded to the gst portal, can be created using this software or tool.
Common errors in gstr 1 json on gst portal with solutions. Import from gstr 122a3b or import autocalculated json file downloaded from gst portal manual entry. The simple way to validate gstr 1 json file before filing on government gst portal by gen gst software. Gstr 2a return meaning view, download and reconcile. How to download gstr 1 return file from gst website and make. Under the download tab, click the generate json file to download button to download the details of all tables in one go or.
The comparison is based on the inward supply data provided by businesses in gstr3b and the values of inward supplies available in gstr2a. Launch the gst offline tool by double clicking on the gst offline tool icon on your desktop, and click on open and import the zip files in the offline tool. Gst offline tool download all gst offline tools and utility. This will generate a special cleanup json file in the same location as selected portal file.
29 692 1038 874 144 712 923 1289 335 18 1418 225 315 546 1288 877 1043 890 536 738 617 1217 835 1109 49 178 334 102 862 1097 377 1486 358 290 773 1032 495 190 8 550 1107 1397 587 1090 661 628 375 215