GSTR 1 CSV files to offline tool and generating JSON files for upload to GSTN?

How to upload GSTR 1 CSV files to offline tool and generate JSON file for upload to GSTN ?




You can export GSTR 1 (sales data) as excel or CSV files and import the same in an offline tool. By using an excel file, you save time as you don't need to import/export multiple CSV files. You will have the option to export the JSON file and import the same in GSTN as well.

Please note that when you generate GSTR 1, you will see a message list in the notepad informing you of any errors in data and using offline tools for GSTR 1. Please read it carefully and act accordingly.

How To Export and Upload GSTR1 Form In CSV Files

Please Follow the Steps for generating and uploading CSV files

Step 1:- Click On GST(Beta) Menu and Click On Generate GST Tax Summary:

Generate GST Tax Summary

Step 2:- Generate the GST Tax summary and check your Sale and Purchase Tax Wise If you find some discrepancies, please follow the steps written in notes at the bottom of the GST Tax Summary.

You can read this article: https://support.swildesk.com/portal/kb/articles/how-to-rectify-data-mismatch-in-tax-summary

Sale and Purchase TaxGST Tax Summary
Step 3:- Click on Export GSTR1 Details (CSV) Format and Select Date Rage:
Export GSTR1 DetailsSelect Date Range
Step 4:- Select Folder for saving these six CSV files.
saving these six CSV filesSelect folder
Step 5:- Open Govt. Offline Tool for Upload CSV Files and click on New Button:
Upload CSV Files and click on New ButtonGST Portal
Step 6:- Please fill all Fields as asked for: GSTIN No. and Tax Period
GSTIN No. and Tax PeriodGSTIN No. and Tax Period
Step 7:- Please Click on IMPORT FILES Button to import CSV files
IMPORT FILESImport CSV Files
Step 8:- Please Select all CSV files from you have saved folder one by one e.g. B2B.CSV
 Select all CSV filesSelect CSV Files
Step 9:- Select Files and click on Import CSV Button to Upload CSV Files
click on Import CSV ButtonUpload CSV Files
Step 10:- This is a warning screen to check your invoice number and some mandatory fields. Click on ok button 
check your invoice numberWarring screen
Step 11:- Click on View Summary Button to see your TAX Summary Details Please be sure that data is correct.
View Summary ButtonSummary button
Step 12:- Click on Generate File for Generate GSTN uploadable JSON format 
 Generate FileGenerate GSTN JSON Format File
Note:
Now you can upload this Generated file on Govt. Website and Relax from the heavy pressure of GSTR1 

When you upload on GSTN, there are error messages due to GSTIN or other problems. You need to rectify and repeat the process. If you remove the invoice from B2B or the invoice is not accepted in B2B, please add the values in B2C values.

You will be required to fill in additional details on GSTN before filing GST R1. You can take those details from excel export R1 or your books for last year and this year.

Please note that you can get support from us for software. We are unable to provide support for GSTN or Govt offline tool.

Please note the following regarding GSTR1 Excel or CSV Sheets:

  1. B2B contains all invoices raised to registered persons. We have not considered the GST registration date in customer master as GST can be taken within 30 days so ITC should be available to him. Even if it is not available, let GSTN take this decision. It will be discarded when you upload it to GSTN. Then you may add it to B2C. You have to check the GSTN response for the wrong GSTIN as well. It does not contain 0% items.
  2. B2CL contains interstate invoices to unregistered persons for more than Rs 2.5 lac. According to General practice in pharmaceuticals, we do not expect any data here. Similarly in the CD2NUR sheet, there may not be any data for credit notes against B2CL invoices.
  3. B2C contains only net value after deducting credit/debit notes. No invoice detail is uploaded for unregistered customers.
  4. HSN wise details contain only sales invoices (and debit note to customers) data.
  5. Debit notes to the customer are called supplementary invoices in the GST system and are always included in sales invoice data.
  6. Documents information is not imported and uploaded with CSV files.
  7. 0% of sales are not uploaded with CSV files. It includes all sales to B2B, B2C, and  B2CL.
*Please note that this is not legal advice. Please take help from your tax consultant. We are not tax experts.

Please read the following article for help to file GST return: 

Unisolve softw