Tips for using GSTR 1 offline utility

Started using offline GSTR-1 utility?
Make sure to keep in mind following tips to ensure smooth and headache free filing. These are from my own experience in last 15 days of usage of GSTR-1 offline utility.
a. Heavy Data? Use CSV files instead of provided Excel file template. CSV files are fast and less prone to failure.  Even data of more than 500 line items I will consider heavy. CSV file with approx. 13K line items will be imported in 3-4 minutes, whereas EXCEL file will most probably give you error even after 15 minutes of processing time
b. DATE. Make sure all dates are in dd-mmm-yyyy format only.
c. DECIMAL Values - Any value with more than 2 decimal will give you error at the time of upload of JSON file. Say for example, if you enter 1223345.123 instead of 1223345.12, even though data will be imported and even JSON file will be created, but GSTN system will not process such file giving "JSON structural error"
d. Consolidate your data, especially for invoices, where there are multiple line items in invoice for same rate.
Say for example, an invoice has 9 line items like this:
4 line items with 5% rate
3 line items with 12% rate
2 line items with 18% rate
Now if you try to punch in all 9 line items in excel/CSV template, only last line item of each rate will be picked by offline tool.
Solution: Use SUMIF/Pivots in excel and consolidate your line items of same rate within in invoice. 
Will post more, as I get to know this tool more.
Happy GST e-filing !!!
Regards,
Ca Lalit Aggarwal,
9999565491

Comments

Post a Comment

Popular posts from this blog

Big relief for Vodophone and Cairns in income tax

Big relief for Vodophone and Cairns The Taxation Laws (Amendment ) Bill, 2021 introduced by FM today in the Lok Sabha  is about withdrawing retrospective amendment made in 2012 of taxing capital gains arising from indirect transfer of assets located in India. This will settle issue of arbitration as under Indian Income Tax  Act itself no tax will be leviable on such capital gains up to 28th May,2012 when this amendment came into force . Full amount of tax will have to be refunded but without interest as a specific provision inserted of no interest on such refund under section 244A. Demand created before 28th May,2012 will be nullified in 17 cases including 2 cases where there is stay . Undertaking to be furnished by these entities that no claim , damages, interest etc shall be filed.
Read more

GST Return का पंचनामा: Contents of GST return utility GSTRN-1 in detail

आओ GST सीखें: 1. 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) 2. 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. 3. The appearance and functionalities of the Offline tool screens are similar to that of the return
Read more

CBDT extends Due Date for filing various Income Tax Forms

The  Central Board of Direct Taxes (CBDT) has issued an order extending due dates for various compliance forms including the Quarterly statement in Form No. 15CC, Equalization Levy Statement in Form No.1, the Statement of Income paid or credited by an investment fund to its unit holder in Form No. 64D and the Statement of Income paid or credited by an investment fund to its unit holder in Form No. 64C. (i) The Quarterly statement in Form No. 15CC to be furnished by an authorized dealer in respect of remittances made for the quarter ending on 30th June 2021 required to be furnished on or before 15th July 2021 under Rule 37BB of the Rules. as extended to 31° July 2021 vide Circular No 12 of 2021 dated 25.06.2021, may be filed on or before 31st August 2021. (ii) The Equalization Levy Statement in Form No.1 for the Financial Year 2020- 21, which was required to be filed on or before 30. June 2021. as extended to 31s1July, 2021 vide Circular No 12 of 2021 dated 25 06.2021. maybe filed on or
Read more