How to Convert GSTR2 Report to Excel Format

Today all the tax payers are taking lot of the time for reconciling the GSTR2 report with Purchase Invoice by checking one by using the offline utility software provided by the GST Portal, but here I am introducing the new utility created in the Microsoft Excel Format which will helps us to convert the Json File which is created by the GST Portal to Microsoft Excel Format and it will helps us to reconcile the data by using Vlookup formula in the less time and you can relax in the GSTR2 filing process.

Step-1

Download the GSTR2A Report from the GST Portal

Step-2
Download the Offline Utility software of the Json file convertor to Excel using the below link

(It will work only above version of Microsoft Excel 2010 and above)

Step-3

Convert the Json file to CSV Format by uploading the file to site
https://json-csv.com/

Step-4
Convert this to CSV Format

Step-5

Copy and Paste  the data in  the CSV File to the Excel Utility and pasting same using Paste Special  values

Step-6
Convert the same and generate the file , you can view the excel data in the Output folder

Comments

Post a Comment

Popular posts from this blog

Amendment of Non-Core Fields in GST Registration is now available

Image
For Amendment of Non-Core Fields in GST Registration: First login into www.gst.gov.in  then click "Services"  then click on "Registration" and  then Choose " Amendment of Registration Non-Core Fields " Amendment can be done in respect of :  i) Addition of Registration Nos of Pre-GST Act,  ii) Modification of Mobile Number and E-mail ID,  iii) Modification or addition of Authorized Signatory,  iv) Addition or modification in Goods and Services,  v) Addition or modification of bank details,  vi) Modification of personal details of Proprietor
Read more

India is a nice house on a bad street - J.P. Morgan

An introductory 5-minute speech was recently given in London at an event, by a young professional of Indian origin. His name is Dhritiman Biswas.   He spoke, extempore,  and the points are reproduced here. The topic was a round-table debate on: "India - is it a gigantic success or a colossal failure?"   This is what he said:  "Ladies and Gentleman,  I am glad I am merely introducing the debate and not participating in it as, in my humble opinion, the question itself is wrong.   India, unlike, many western paradigms cannot be analysed in black and white, in linear equations or algorithms such as this. We hate Test Cricket yet we are the No.1 Test Cricket ranked country;Our ranking in gender diversity is 134, yet the majority of our bank CEOs - the most misogynistic yet of industries -  are women;Our health services creak and crumble, yet 36% of all the UK's NHS consultants are Indians;We love Bollywood tamashas(shows), yet the New York Philharmonic concert sold
Read more

BALANCE SHEET FINALISATION CHECKLIST

Given below is the checklist for finalisation of Balance sheet hope this will help you for sure in finalising the balancesheet of all organisations. Must check the following things before finalising . 1. No Entry On National Holiday. 2. Confirmation of Secured Loans. 3. Confirmation of Unsecured Loans. 4. Confirmation of S.Creditors (Specialy Those With Debit Balance.) 5. Confirmation of S.Debtors (Specialy Those With Credit Balance) 6. Bonus Sheet To Be Tallied With Bonus Paid In Cash And By Cheque. 7. Check Cash For Negative Balance. 8. Electricity Charges For 12 Months Entered Or Not. 9. Salary Sheet – Tally With Salary Paid In Cash+Cheque. Salary of Employees Who Have Not Signed Salary Sheet Should Reflect As Payable. Tally With Salary Summary For Whole Year. 10. Copy of All Full & Final A/C Papers Required. 11. Insurance Exp. – Pre-Paid Entries To Be Done. Copy of All Cover Notes To Be Kept In Balance Sheet File. 12. Other Pre-Paid Exp. Entries Like Licence Fee, AM
Read more