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

Reverse charge on goods or services taken form unregistered person

आओ GST सीखें: क्या आप जानते हैं कि अगर एक unregistered person किसी registered person को taxable goods या services supply करेगा तो GST उस registered person को देना होगा जिसने goods purchase किए हैं या सर्विसेज़ received की हैं। Section 9(4) के अनुसार: The central tax in respect of the supply of taxable goods or services or both by a supplier, who is not registered, to a registered person shall be paid by such person on reverse charge basis as the re...
Read more

GST में TDS के प्रावधानों का पोस्टमार्टम

आओ GST सीखें: दोस्तों आजकल GST का सबसे हॉट topic GST में TDS के प्रावधानों का एप्लीकेबल होना है। सब घबरा रहे हैं कि क्या सरकार ने अब GST में TDS रूपी नया compliance तो कहीं उन पर थोप तो नहीं दिया। रोज़ बहुत सारे फ़ोन आने शुरू हो चुके हैं। दोस्तों घबराएं मत, GST में TDS के प्रावधान सबके लिए नहीं हैं। ये केवल कुछ लोगों पर एप्लीकेबल हैं। सरल आम लोगों के शब्दों में यह कह सकते हैं कि ये सरकारी या उसके जैसी संस्था पर ही लागू होगी। Section 51 के अनुसार कुछ entity 2% GST TDS काट कर पेमेंट करेगी अगर टोटल basic contract amount 250000 से ज़्यादा है तो। आओ GST में TDS के प्रावधानों के 10 सवालों का पोस्टमार्टम करें। 1. TDS किसको काटना है : --------------------------- (a) a department or establishment of the Central Government or State Government; or (b) local authority; or (c) Governmental agencies; or (d) such persons or category of persons as may be notified by the Government on the recommendations of the Council अभी तक निम्न persons को नोटिफाई किया गया है: Perso...
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