';

Scope and Purpose of Standard Reports

You are here:
Estimated Reading Time: 15 Minutes
Sr.No.Report NameShort DescriptionSource of DataPurpose and Scope
Summary Reports
1Summary-1-Outward SuppliesTrend of outward supplies and tax liabilities. Inclusive of advances receivedGSTR 1 data uploaded in IRIS“This report will give you an overview of outward supplies and tax liability thereon.
Based on GSTR 1, in this report, you will get taxable values and total tax amounts.
So it will give you the insights of trend of outward supplies over periods. Help you to understand how your business is growing.”
2Summary-1-3B ComparisonComparing Taxable values from GSTR 1 and GSTR 3BGSTR 1 data uploaded in IRIS and GSTR 3B data downloaded from GST system“This report will give you period wise comparative view for taxable values provided in GSTR 1 and GSTR 3B for outward supplies.
So that by using this report you can find out discrepancies in two returns i.e. GSTR 1 and GSTR 3B. And you can take corrective action for the same.”
3Summary-2A- ITC EligibilitySummary of  ITC details bifurcated between eligible ITC and ineligible ITCGSTR 2A data downloaded from GST system“This report will give you the month-wise total tax amounts getting bifurcated between ITC eligible and ITC ineligible.
ITC eligibility is decided based on POS, CFS and reverse charge factor.
For deciding Eligibility based on POS factor, If taxpayers (i.e. Purchasers) State is not matched with POS mentioned in invoice then the ITC is ineligible. And if POS matches then it is ITC eligible. Also invoices having counterparty filing status (CFS) as Y and reverse charge should be N considered as eligible. Also provides ITC subject to reverse charge.”
41S-Supplies SectionwiseAnalysis of taxable value and tax amount based on invoice typesGSTR 1 data uploaded in IRIS“This report will give you section wise overview i.e. B2B, B2C, Nil rated, Zero-rated, Advance tax likewise.
Here you will get a view based upon Period wise.
Based on GSTR 1, in this report, you will get Taxable values and Total tax values bifurcated between various sections.
So by using this report, you will get an insight of section-wise supplies and also based on section B2B and B2C you will get a view of how much you are supplying goods/services to registered counterparties and unregistered counterparties.”
51F – Summary Outward Supplies (As Filed)The month-wise trend of outward supplies and Tax liability based on GSTR-1 filed with GSTNGSTR 1 Filed DataThis report will give you an overview of outward supplies within and outside the business and tax liability thereon.
Based on GSTR 1 Filed, in this report, you will get taxable values and total tax amounts.
So it will give you the insights of the trend of outward supplies over periods. Help you to understand how your business is growing.
61F – 3B Comparision Summary  (As Filed)Month-wise comparison of tax liability on outward supplies as per GSTR 1 and GSTR 3B filedGSTR 1 Filed DataThis report will give you period wise comparative view for tax liability provided in GSTR 1 as filed with GSTN and GSTR 3B for outward supplies.
So that by using these reports you can find out discrepancies in two returns i.e. GSTR 1 and GSTR 3B as filed with GSTN and can take corrective action for the same.
Comparative 1-2A-3B
71-3B Comparison-(Table3-Detailed-PeriodwiseComparing Taxable values and tax amounts from GSTR 1 and GSTR 3B GSTIN wiseGSTR 1 data uploaded in IRIS and GSTR 3B data downloaded from GST systemThis report will give you a comparative view for taxable values and tax amounts provided in GSTR 1 and GSTR 3B for outward supplies.
These details will be available GSTIN wise and Period wise.
So that by using this reports you can find out discrepancies in two returns i.e. GSTR 1 and GSTR 3B. And you can take corrective action for the same.
81-3B Comparison-(Table3-Cumulative)Comparing cumulative taxable values and tax amounts from GSTR 1 and GSTR 3BGSTR 1 data uploaded in IRIS and GSTR 3B data downloaded from GST systemThis report will give you cumulative comparative view for taxable values and tax amounts provided in GSTR 1 and GSTR 3B for outward supplies.
So that by using this reports you can find out discrepancies in two returns i.e. GSTR 1 and GSTR 3B. And you can take corrective action for the same.
92A-3B Comparison – Total TaxThis report compares the total ITC details as per GSTR 3B and the total ITC other than reverse charge as per GSTR 2A.GSTR 2A and GSTR 3B data downloaded from GSTNThis report will give you the total ITC details as per GSTR 3B and the total ITC other than reverse charge as per GSTR 2A.
There is one category in GSTR 3B i.e. ITC available others. So whatever the amount you mentioned for this category, your these ITC details will get compared with GSTR 2A and difference will get calculated for ITC other category.
These details will be available period wise.
This report will help you to reconcile total ITC details between GSTR 2A and GSTR 3B.
102A-3B Comparison – Tax type wiseThis report compares the GSTR-2A and GSTR-3BITC Values for each of the tax type.GSTR 2A and GSTR 3B data downloaded from GSTNA detailed report is similar as per above report i.e. “2A-3B Comparison – Total Tax” just the difference is that here tax amount bifurcated tax type-wise i.e. IGST, CGST, SGST and Cess
111F – 3B Comparison (Table 3 Cumulative) (As Filed)Taxable value and tax amounts comparison of GSTR-1 and 3B filed data for Table 3 of GSTR-3BGSTR 1 Filed DataThis report will give you cumulative comparative view for taxable values and tax amounts provided in GSTR 1 and GSTR 3B for outward supplies.
So that by using this report you can find out discrepancies in two returns i.e. GSTR 1 and GSTR 3B. And you can take corrective action for the same
121F – 3B Comparison-(Table3-Detailed-Periodwise) (As Filed)GSTIN and period level comparative view of taxable value and tax amounts for GSTR-1 and 3B as filed.GSTR 1 Filed DataThis report will give you a comparative view of taxable values and tax amounts provided in GSTR 1 and GSTR 3B for outward supplies.
These details will be available GSTIN wise and Period wise.
So that by using this report you can find out discrepancies in two returns i.e. GSTR 1 and GSTR 3B. And you can take corrective action for the same.
Sales Analysis
131U-Domestic and Export SuppliesAnalysis of taxable value and tax amount based on domestic and export. Advances included as a separate categoryGSTR 1 data uploaded in IRISThis report will give you a geo wise overview i.e. domestic and exported supplies breakup as well as advances as a separate category.
Here you will get a view based upon legal company name wise, GSTIN wise and Period wise.
Based on GSTR 1 uploaded data, in this report, you will get Taxable values bifurcated between Export, Domestic and Advance tax.
So by using this report, you will get insight of how much you are exporting your supplies and how much you are supplying domestically.
141S-Advance Tax and AdjustmentUsing GSTR 1 Summary data, the comparison of advances tax and adjustment period wise.GSTR 1 Summary downloaded from GSTNThis report will give you a view of advances received and advances adjusted over a period.
Here you will get a view based upon legal company name wise, GSTIN wise and Period wise.
Based on GSTR 1 uploaded data, in this report, you will get taxable values and total tax amounts bifurcated between advances received and advances adjusted.
151U-PoS wise outward suppliesThis report is an analysis of taxable value based on the area of supply.GSTR 1 data uploaded in IRISThis report will give you POS wise overview of your outward supplies
Here you will get a view based upon legal company name wise, GSTIN wise and Period wise.
Based on GSTR 1 uploaded data, in this report, you will get Taxable values and Total tax values bifurcated between various POS
So by using this report, you will get insight of in which state you are doing more business and less business. So you can take some actions how to increase your sale in the state where you are doing less business.
161U-Tax Rate Slab Wise suppliesAnalysis of taxable value based on tax rate slab wise.GSTR 1 data uploaded in IRISThis report will give you an overview of outward supplies on the basis of tax rate slabs.
Here you will get a view based upon legal company name wise, GSTIN wise and Period wise.
Based on GSTR 1 uploaded data, in this report, you will get taxable values bifurcated as per tax rate slabs.
So it will give you the insights of highly sale products of yours fall under which tax slab rate.
171U-Composition Of Tax AmountThis report reflects segregation of tax amounts for the tax expenditure during the reporting period.GSTR 1 data uploaded in IRISThis report will give you an overview of various type of tax liability on outward supplies
Here you will get a view based upon legal company name wise, GSTIN wise and Period wise.
Based on GSTR 1 uploaded data, in this report, you will get total tax amounts bifurcated between tax types i.e. IGST, CGST, SGST, and Cess.
181U-Inter and Intra SuppliesThis report classifies the sales into within and outside the filing entity’s state.GSTR 1 data uploaded in IRISThis report will give you an overview of interstate and intrastate supplies.
Here you will get a view based upon legal company name wise, GSTIN wise and Period wise.
Based on GSTR 1 uploaded data, in this report, you will get Taxable values bifurcated between Interstate supplies and intrastate supplies.
191F- Composition of Tax amountThe report provides composition of tax amounts for the tax expenditure incurred during the reporting periodGSTR 1 Filed DataThis report will give you an overview of various type of tax liabilities incurred on outward supplies.
Here you will get a view based upon legal company name wise, GSTIN wise and Period wise.
Based on GSTR 1 filed, in this report, you will get total tax amounts bifurcated between tax types i.e. IGST, CGST, SGST, and Cess.
Composition of Tax amount to know the concentration into the ITC ledger component is an additional dimension for the users.
201F – POS wise sales (As Filed)This report provides POS wise sales details across GSTINs for GSTR-1 filed.GSTR 1 Filed DataIt provides a Concentration of Sales effected for each place of supply.
Here you will get view based upon legal company name wise, GSTIN wise and Period wise.
This report provides POS wise sales details across GSTINs for GSTR-1 filed.
Based on GSTR 1 filed, in this report, you will get Taxable values and Total tax values bifurcated between various POS.
So by using this report, you will get the insight of in which state you are doing more business and less business. So you can take some actions on how to increase your sale in the state where you are doing less business.
211F – Section-wise Outward Supply Summary (As Filed)This report provides a section-wise spill of outward supplies for GSTR-1 filed.GSTR 1 Filed DataThis report provides a summary of section-wise outward supplies
The view is based upon Section only which reflects Taxable and tax value for each Supply section.
So by using this report, you will get the insight of section-wise supplies and also based on section B2B and B2C you will get a view of how much you are supplying goods/services to registered counterparties and unregistered counterparties.
221F – Tax Rate wise classification of outward supplies (As Filed)This report provides a tax rate wise classification of GSTR-1 filed.GSTR 1 Filed DataThis report will give you an overview of outward supplies on the basis of tax rate slabs.
Here you will get a view based upon GSTIN wise and Period wise.
Based on GSTR 1, in this report, you will get taxable values bifurcated as per tax rate slabs.
So it will give you the insights of highly sale products of yours fall under which tax slab rate.
Custom Field Reports
231U- Division Code Wise – SalesOutward sales categorised division wise as uploaded in IRIS invoice level formatsGSTR 1 data uploaded in IRISBased on GSTR-1 uploaded, this is a summary report providing division wise concentration of sales.
241U- Plant Code Wise – SalesOutward supplies categorised plant code-wise as uploaded using Invoice level input formatsGSTR 1 data uploaded in IRISBased on GSTR-1 uploaded, this is a summary report providing Plant wise concentration of sales.
251U- Counter-Party Code Wise – SalesOutward supplies categorised Counter-Party Code Wise as uploaded using Invoice level input formatsGSTR 1 data uploaded in IRISBased on GSTR-1 uploaded, this is a summary report providing Counter-Party Code wise concentration of sales.
Purchase Analysis
262A-Details of B2B PurchasesB2B purchases and tax amountsGSTR 2A downloaded from GST systemThis report will give you an overview of inward supplies and tax paid thereon.
Here you will get a view based upon legal company name wise, GSTIN wise and Period wise.
Based on GSTR 2A, in this report, you will get taxable values and tax amounts.
So it will give you the insights of the trend of inward supplies for B2B counterparties over periods.
272P – Summary ViewSummary of purchases based on GSTR 2PGSTR 2P Uploaded in IRIS SapphireThis report will give you an overview of purchase invoices uploaded on IRIS Sapphire GSTIN wise.
Details will be based on Document type, Document status, Invoice values, invoice counts.
So it will provide you an overall summary for uploaded purchase register data for all your GSTIN
282A-Purchases with ineligible ITCProvides a list of invoices with Ineligible ITCGSTR 2A data downloaded from GST systemThis report provides ineligible ITC for GSTR-2A invoices. Ineligibility based on POS difference, counterparty filing status no on this basis will get decide. Also, these ineligibility reasons will also get provided in the report.
Only regular original invoices considered for this report.
292A – Overview of PurchasesSummary of purchases as per GSTR 2A. Fin Year is the return period, while doc Fin year is based on invoice dateGSTR 2A data downloaded from GSTNThis report will provide you the overview of total of values appearing in GSTR 2A
Monthly Return (3B)
303B-ITC-ClassificationCategorisation of ITC claimed into imports, reverse charge and others.GSTR 3B downloaded from GST systemThis report will give you view of categorisation of ITC available.
Here you will get view based upon Period wise, Legal company name wise and GSTIN wise.
Based on GSTR 3B, in this report you will get input tax credit amounts available against import of goods/services, RCM inward supplies and other ITC available.
313B-ITC-CrossUtilisationUse of ITC to set off the taxes under various tax heads.GSTR 3B downloaded from GST systemThis report will give you view of utilization of ITC.
Here you will get view based upon tax name wise i.e. IGST, CGST, SGST and Cess.
Based on GSTR 3B, in this report you will get ITC utilized values against the various tax types.
323B – Net ITC availableCumulative ITC available, reversed, ineligible and netGSTR 3B downloaded from GST systemThis report will give you overview of net ITC available
Here you will get view based upon Period wise.
Based on GSTR 3B, in this report you will get input tax credit amounts bifurcated between total ITC available, ITC reversed, ITC ineligible and Net ITC available.
So it will give you the insights of Net ITC available over periods.
333B-SupplyDetailsBreak-up of table 3.1 of GSTR 3B at PAN level and drill down to GSTINGSTR 3B downloaded from GST systemThis report will give you an overview of taxable values and tax amounts of outward supplies and inward supplies on which reverse charge is applicable mentioned in Table 3.1 of GSTR 3B
Here you will get a view based upon Period wise, Legal PAN wise and GSTIN wise.
Based on GSTR 3B, in this report, you will get Outward supplies bifurcated between zero rated outward supplies, other outward supplies, Nil rated, exempted outward supplies and Inward supplies on which reverse charge is applicable
343B-Interest and Late FeeTaxpayers who have paid interest or late fee. Data will be shown only when there are some values for interest or late feeGSTR 3B downloaded from GST systemThis report will give you a view of interest and late fees paid by you.
Here you will get a view based upon Period wise, Legal company name wise and GSTIN wise.
Based on GSTR 3B, this report will give you an idea about how much interest and late fees you have paid. So based on this report you can take some actions to cut down this kind of late fees and do filing on time.
35Tax Liability on Outward and Inward (RCM)Composition of tax liability into paybale on outward supplies and inward subject to RCM.GSTR 3B downloaded from GST systemThis report will give you tax liability bifurcation between outward supplies and inward supplies liable to reverse charge based on details provided in GSTR 3B.
Here you will get view based upon Period wise
Top 10
36Top 10 vendors (2A)Top 10 vendors from whom purchases are made, in terms of value. Only for B2BGSTR 2A downloaded from GST systemThis report will give list of top 10 vendors from whom purchases are made by you. [Note – For this report only B2B counterparties are considered]
For this valuation, invoice value is considered and not the invoice count with that vendors.
Here you will get view based upon vendor GSTIN name wise.
Based on GSTR 2A, in this report you will get values including tax getting bifurcated between top 10 vendor wise.
37Top 10 customers (1U)Top 10 customers to whom sales are made, in terms of value. Only for B2BGSTR 1 data uploaded in IRISThis report will give list of top 10 customers to whom sales are made by you. [Note – For this report only B2B counterparties are considered]
For this valuation, invoice value is considered and not the invoice count with that customers.
Here you will get view based upon customer GSTIN name wise.
Based on GSTR 1, in this report you will get values including tax getting bifurcated between top 10 customers wise.
38Top10 HSN supplies – Value (1U)Top 10 goods/services sold. Ranking taxable value wiseGSTR 1 data uploaded in IRISThis report will give list of top 10 products and services sold. For top 10, the taxable value is considered
Based on GSTR 1 HSN Summary, in this report you will get quantity sold and taxable value for the HSN
39Top10 HSN supplies – Quantity (1U)Top 10 goods/services sold. Ranking quantity wiseGSTR 1 data uploaded in IRISThis report will give list of top 10 products and services sold. For top 10, the quantity is considered
Based on GSTR 1 HSN Summary, in this report you will get quantity sold, taxable value for top 10 HSN
40Top10 states where sales are made (1U)Top 10 states where sales are made. Ranking based upon taxable valuesGSTR 1 data uploaded in IRISThis report will give you list of top 10 POS where sales are made
Based on GSTR 1, in this report you will get Taxable values bifurcated between top 10 POS.
So by using this report, you will get insight of in which state you are doing maximum business
Counterparty Analysis
41New CustomersTrend of growth in B2B customers and business from them as observed every month. Based on GSTR 1 uploaded in IRISGSTR 1 data uploaded in IRISThis report will provide you the count of new customers added and sales done with them during period as per GSTR 1 data and further bifurcation of customers into within and outside business group.
These details are available Period wise.
42New Customers – DetailsDetails of new B2B customers and business. New customer indicates customer to whom supplies are made for first time.GSTR 1 data uploaded in IRISThis report will provide you the count of new customers added and sales done with them during period as per GSTR 1 data and further bifurcation of customers into within and outside business group.
These details are available Period wise.
43New VendorsTrend of growth in B2B vendors and purchases from them as observed month on month. Based on GSTR 2A available in IRISGSTR 2A data downloaded from GSTNThis report will provide you the count of new vendors added and purchases made from them during period as per GSTR 2A data and further bifurcation of vendors into within and outside business group.
These details are available Period wise.
44New Vendors – DetailsDetails of new B2B vendors and business. New vendor indicates vendor to whom supplies are made for first time.GSTR 2A data downloaded from GSTNThis report will provide you the count of new vendors added and purchases made from them during period as per GSTR 2A data and further bifurcation of vendors into within and outside business group.
These details are available Period wise.
ITC Analysis
452A-Vendors who yet filed their GSTR 1_ITC AnalysisThis report gives the list of vendors who haven’t filed their GSTR-1 for the filing period.GSTR 2A data downloaded from GSTNThis report will give you details of invoice count for the counterparty who not yet filed their GSTR 1.
Based on GSTR 2A, here we consider the details of counterparties who’s CFS =N i.e. counterparty filing status is “No”.
Here you will get view based upon period wise and counterparty wise.
This should help you to identify the cases where if you have claimed ITC, it might be subject to reversal if the counterparty does not file its return.
46GSTR 2A-ITC Eligibility-OriginalOnly-DetailedProvides ITC eligible details based on GSTR 2AGSTR 2A data downloaded from GSTNThis report will provide you details of ITC eligibility GSTIN wise and Period wise based on GSTR 2A data.
In this report only regular original invoices are considered.
Also eligibility decided based upon POS same as per taxpayer or same first two digits of GSTIN of Counterparty, Counterparty filing status “Y” and with Reverse charge as “N”.
47ITC ineligible due to PoS difference (detailed)Based on GSTR 2A, ITC ineligible due to PoS difference (detailed)GSTR 2A data downloaded from GSTNDetailed report based on GSTR-2A providing insight of Ineligible ITC due to difference in Place of Supply. This report will also provide counterparty GSTIN details.
As per Law, where there is a difference in POS, such ITC is not eligible to be claimed.
48ITC ineligible due to PoS difference (Month-wise)Based on GSTR-2A, ITC ineligible due to PoS difference (Month wise)GSTR 2A data downloaded from GSTNMonth-wise report based on GSTR-2A providing insight of Ineligible ITC due to a difference in Place of Supply.
As per Law, where there is a difference in POS, such ITC is not eligible to be claimed.
49ITC ineligible where CFS is N (Detailed)Based on GSTR-2A, ITC ineligible where CFS is N (detailed)GSTR 2A data downloaded from GSTNDetailed report based on GSTR-2A providing insight of Ineligible ITC due to non filed status of counter-parties. This report will also provide counterparty GSTIN details.
As per Law, where the counter-party filing status is “NO”, the Taxpayer is not eligible to claim such ITC. These invoices highlight the cases of Vendors to be followed up.
50ITC ineligible where CFS is N (Month-wise)Based on GSTR-2A, ITC ineligible where CFS is N (summary)GSTR 2A data downloaded from GSTNMonth-wise report based on GSTR-2A providing insight of Ineligible ITC due to non filed status of counter-parties.
As per Law, where the counter-party filing status is “NO”, the Taxpayer is not eligible to claim such ITC. This report highlights the cases of Vendors to be followed up.
Reconciliation
51Reconciled-CTIN-SummaryThis report gives the Counter-party wise reconciliation summary.Reconciliation collectionThis report classifies the reconciliation result based on Counter-party GSTIN.
This CTIN Summary is for B2B and CDN. i.e, the results are netted off
Document Type = RI, C, and D
Measures prefixed with ‘P’ are values corresponding to Purchase Data
Measures Prefixed with S are values corresponding from GSTR-2A fetched.
52Reconciliation Status – With in and Outside GroupReconciliation results categorized into within and outside PAN with drill down to GSTINReconciliation collectionThis report gives the reconciliation status for financial years within and outside a legal PAN.
53Reconciliation-OverviewSummary of invoices reconciled and ITC eligibility for the same. Cumulative for all periodsReconciliation collectionAn overall view of reconciliation as per reconciliation category.
For each of reconciliation category, this report reflects how much of ITC is eligible and Not eligible along with reasons of Ineligibility like due to POS difference, Only due to CFS or Subject to reverse charge and Due to POS and CFS=N.
54Analysis of ITC AvailedBased on ITC availed (IP, CP, etc.), a summary of tax amount as per supplier and ITC amount as per purchase registerReconciliation collectionAnalysis of the ITC availed during the financial period for each category of ip = input goods, cp = capital goods, is = input services, no = not eligible.
This report also provides a comparative view of ITC available and that availed as values are of GSTR-2A and 2P for given reconciliation type.