How to export HSN wise sales invoice data to excel for GSTR 1/GSTR 2 ?
GST Data is generated by Generating Tax Summary. You can provide this GST summary data to a tax consultant, using this data your accountant/tax consultant or CA will be able to prepare R1/R2 using his software or excel offline tool provided by Government. For this, you can go to GST Menu, Generate Tax Summary, then go to GST reports, select the GST Summary Data report. You have to enter dates here and click on Get Data. After this click on the Raw Data tab. You have the option to export this raw data to excel. You can provide this data for the preparation of returns to your CA or tax consultant. This option provides you analysis option like a pivot table in excel. You can check your data for any dimension in rows and columns and generate a summary like HSN wise totals.
There is one more option - GST Summary data export to excel. It will provide you raw data in four sheets of the same excel file.
Based on feedback and following the basic principle of providing choice to people, we are providing R1/R2 data on excel (R1 format for GSTN Upload as defined by Govt. offline tool) as well for annual charge Rs 2000 plus GST. This charge will be added to AMC. If you register with Karvy or another GSP, you will not require this option. Your data will go to Karvy directly from the software. Using this GSTR1 excel file you will be able to upload your return to GSTN.
Still, we do not consider it a feasible option for business, but as some of you think that it can save some money or allow you to be more independent, this option is being provided.
Related articles:
|
|
Related Articles
How to Import Sales Invoice in Cross Software through RGHS (Govt. Portal) Excel Files
How to Import Sales Invoice in Cross through RGHS (Pensioners Billing Govt. Portal) Excel Files In this article, We have explained to you "How to Import Sales Invoice through RGHS (Pensioners) Excel Files " in Cross. Please install the Latest Patch ...HOW TO CHANGE SERIES OF SALES INVOICE in Unisolve
HOW TO CHANGE SERIES OF SALES INVOICE You may want to change series of sales invoice with starting of new financial year. At present your invoices are using 1CC or xSS as invoice series depending upon whether your data is having multiple principals ...Generate & Export GSTR-9 Details in Excel File in Unisolve
How to Generate & Export GSTR-9 Details in Excel File in Unisolve Software The GSTR 9 is a document or statement that has to be filed once a year by a registered taxpayer. This document will contain the details of all supplies made and received under ...How to reconcile and file GSTR 2 with purchase data ?
YouTube Video Link for GSTR2 Upload How to Download new patch for Unisolve-Cross Please download last patch (Release 31 or later) for Unisolve/Cross version 16.2 We have provided offline reconciliation option for GSTR 2 in this release. This is ...How to Export Sales Invoice in CSV format in Cross
How to Export Sales Invoice in CSV format in Cross CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables, such as ...