In the technology-enabled GST Regime, the Government is already talking about applying data analytics to compare GSTR-1 Sales returns and GSTR-2A Purchase returns with data reported in GSTR-3B Returns. Also, the Government intends to compare Income Tax Returns (Direct Taxes) with GST Returns (Indirect Taxes). It is useful for every tax payer to have a year-to-date summary of their various GST Returns and monitor them for inconsistencies and take corrective action sooner, rather than later.
Click on the check box and click on the blue “Download from Government portal”
Note – You will only be allowed to download the Summary level details when downloading for the first time. Once the summary level details are downloaded, you will see checkbox without tick mark below the section present for download. Click on the checkbox where applicable and proceed to download from Government Portal.
On downloading the Summary, the other sections (B2B invoices, B2CS invoices, B2CL invoices, etc) which have data available on the Government portal becomes available for download. You can select the checkbox for which even section you want to download and proceed to do the same. Sections where the data is not available in the Government portal, no checkbox is seen. Data for sections which has already been downloaded shows a Green Tick mark. Sections which has data available on Government portal but NOT DOWNLOADED will be seen with a Yellow dot in a circle. You can select the corresponding Checkbox below and download the same from the Government portal.
Once the data is downloaded, the Download Status will show a green tick mark with time of download
Now click on the Download YTD Consolidated Report XLS and Download the report for the full year.
You can also download Invoice-level reconciliation of your Sales Register against GSTR-1 and your Purchase Register against GSTR-2A month-by-month or for the full year.
An excel report will be downloaded.
STEP 7 – This will give you the final Excel output with its various sheets
STEP 8 – How to customize your GSTR-1 vs GSTR-2A vs GSTR-3B Report in Microsoft Excel and Upload it back into GSTZen
GSTZen provides you with a comprehensive report in XLS format comparing GSTR-1, GSTR-2A, GSTR-3B returns as well as comparing against your Sales and Purchase Registers. This section provides screenshots and explanations of the various sheets in GSTZen’s report.
The consolidated GSTR-1 Report gives a Year to Date, month-wise summary of GSTR-1 summary data from the Government Portal. Please note that the Government Portal summary does not exactly match the format of the GSTR-1 return. Therefore, there will be some minor differences between the GSTR-1 Return and this report.
This is a comparison of the first two sheets. Here the monthwise GSTR-1 and GSTR-3B data are compared and differences are show month-wise and year-wise.
GSTR-2A summary sheet gives month wise summary at vendor level for the whole year downloaded from the Government portal ( and also your own books if you run GSTZen GSTR-2A reconciliation). To know about GSTR2A reconciliation on GSTZen, click here GSTR-2A Reconciliation with GSTZen
The GSTR-1 Return has sections such as B2B Invoices, B2C Small Invoices, B2C Large Invoices, Export Invoices, Credit Notes to Registered Tax Payers, and Amendment sections. Usually, one a few sections in the return are used by Tax Payers. You can choose to only download those sections that are applicable.
After downloading the GSTR-1 Return Summary, GSTZen will show you which sections are applicable / not applicable. As an example, see the picture shown below.
