How to create a CSV file for GSTR-1?

How to generate JSON file for GSTR-1 in Busy?

To generate a JSON file directly from BUSY, follow these steps: Go to Display > GST Reports > GST Returns > GSTR-1 eReturn. Clicking on GSTR-1 eReturn will open a new window where you can select the type of report you wish to generate (JSON, CSV, As per govt. template, or Plain Excel).

How to prepare GSTR-1 data?

Manual> Filing Nil Form GSTR-1 Online by Normal Taxpayers

1. Access the www.gst.gov.in URL. ...
2. The File Returns page is displayed. ...
3. Click the PREPARE ONLINE button in the GSTR1 tile.
4. The GSTR-1 – Details of outward supplies of goods or services page is displayed. ...
5. The Nil File GSTR-1 page will be displayed.

How to convert gstr-1 JSON file into excel?

How to Use the GSTR-1 JSON to Excel Utility

1. Open the Excel Workbook: Open the Excel workbook where the utility is saved. ...
2. Select the JSON File:
3. Convert to Excel:
4. Save the Excel File: Once conversion is complete, save the Excel file to your desired location.

Can excel create GST reports?

GST Tool Compatible

GST Reports are generated in excel formats that GST Offline tool recognises.

What is a CSV file and how do you create it?

A CSV (Comma Separated Values) file is a special type of file that you can create or edit in Excel. Rather than storing information in columns, CSV files store information separated by commas. When text and numbers are saved in a CSV file, it's easy to move them from one program to another.

Can Excel create a CSV file?

Underneath file name at the bottom of the save screen you will see option “Save as type.” In this field select “CSV (Comma delimited).” 4. Name your file and choose where to save it. Click “Save” (bottom right of save screen to the left of cancel).

How to file GSTR-1 for export?

Step 1: Login to GST portal.

1. Step 2: Go to 'Services' > ''Returns' > 'Return Dashboard' > 'GSTR-1'
2. Step 3: Select the month for which you want to file Table 6A of GSTR and click on 'SEARCH'.
3. Step 4: Click on the 'Table 6A of FORM GSTR-1' tile.
4. Step 5: Click on the button 'ADD INVOICE' to start filing the return.

How to open CSV directly in excel?

Opening a CSV File in Excel

1. Open Excel.
2. Click New, then click on Blank workbook.
3. Click on the Data tab.
4. Click Get External Data From Text.
5. Navigate to the CSV-formatted file saved on your system, select it, then click Import (When browsing to find the file, set browser to look for All Files or for Text Files)

What is the date format for Gstr-1 in excel?

The date format should bedd- mmm-yyyy only(eg 01-Jul-2017). ii. Incorrectinvoice format entered in excel. Invoice number should be maximum 16 digit and alphanumeric.

Can I convert a JSON file to CSV?

Yes, you can easily convert JSON to CSV using free online tools, programming libraries (like Python's pandas or R's jsonlite), desktop applications (Modern CSV), or even command-line utilities like PowerShell, allowing you to transform structured JSON data into flat, tabular CSV files for use in spreadsheets or databases. 

How to prepare a JSON file for GSTR-1?

Export the GSTR-1 report with document summary as a single JSON format, and import the same in the portal.

1. Press Alt+E (Export) > E-Return.
2. Select the File Format as JSON (Data Interchange).
3. Set Export separate files for each Section to No.
4. Set Export document summary to Yes.
5. Export the JSON file.

How to download GSTR-1 in bulk?

Downloading GSTR-1

1. Step 1: Log In. Visit the official GST portal: https://www.gst.gov.in/. ...
2. Step 2: Select 'Services' After logging in, you will find a menu bar. ...
3. Step 3: Choose 'Returns' ...
4. Step 4: Click on 'Returns Dashboard' ...
5. Step 5: Select Applicable Return Period. ...
6. Step 6: File and Download.

What are the common mistakes while filing GSTR1?

One such common mistake is reflecting wrong details under zero-rated supplies and deemed exports. Such mistake of mentioning details of outward supplies under the wrong head should be avoided while filing a GSTR-1 return.

How to download GSTR 1 filed data?

How to Download GSTR-1

1. Follow Steps 1 to 4 mentioned above.
2. Click on “GSTR-1” from the list of return forms.
3. Click on “Prepare Online” or “Download.”
4. If you choose “Prepare Online,” you can enter details and submit.
5. If you choose “Download,” the form will be saved on your device.

How do I upload the JSON file?

Upload Your JSON Files In 3 Easy Steps

1. Upload a file. Select your JSON file or drag and drop it onto our uploader.
2. Enter a link-name and customise. Choose a memorable name for your link and adjust any settings you need.
3. Publish and get a link to share. Click Publish and immediately receive a link to share your JSON file.

How to convert gstr 1 excel to JSON?

To convert GSTR-1 Excel to JSON, download the GST offline tool from the GST portal. Import your GSTR-1 Excel file into the tool, check the summary, and click “Generate File” to create a GSTR-1 JSON file. This JSON format is the only file type accepted for uploading GSTR-1 returns on the GST portal.

How to create a JSON file format?

Manually creating a JSON file

1. Open a text editor and enter data in the following Salesforce Analytics schema format: Copy. { "fileFormat" : { }, "objects" : [ { <object_detail>, "fields" : [ { <Field1 details> } { <Field2 details> }…… ] }] }
2. Save and close the file in the . json format.

What is the JSON file format in GST?

Where is the JSON file used under GST? The JSON file is used under GST for submitting invoice information on various government portals for GST compliance. It includes filing of GST returns and generation of e-way bills. In its latest application, it will be used for generating an e-invoice.