GSTR1
Shows the tables of your GSTR-1 sales return for a month or quarter: your invoices to registered customers, and a summary by HSN. Download them to Excel to check before you file. The panel above the table does the filing itself.
This report is built for India's GST and tax deduction rules. It does not cover VAT, and Tax Reports has no VAT report. Your VAT rate and amount are on each document.
Quick look
- Go to Reports › Tax Reports and click the GSTR1 card.
- Pick the Form: b2b, sez, de for invoices, or hsn(b2b) for the HSN summary. Pick a Month or Quarters and click Run Report.
- Click the green spreadsheet icon above the table to download every row of the period as an Excel file.
- To file, use the GSTR-1 return panel above the table. See GSTR-1 filing.
Done. You have the table on screen and an Excel file of it.
Full guide
What it shows, and when to use it
This report has two parts. Above the table is the GSTR-1 return panel, where you export the file for the GST portal (JSON), mark the return filed, and download each GSTR-1 table as Excel or JSON. Those steps are in GSTR-1 filing. Below it is the table this page describes, a quick look at the same data for one period.
Filters and period
Fields in this section
| Field | Required | What to enter |
|---|---|---|
| Reports | No | Switch to another Tax report. |
| Form | No | b2b, sez, de (one row per invoice) or hsn(b2b) (one row per HSN, unit and rate). It opens on b2b, sez, de. |
| Year | No | Chooses which months and quarters the two lists below offer. The current year lists your latest 12 months and the latest four quarters; an earlier year lists January to December and its four calendar quarters. |
| Month | No | A single month, for example Oct-26. It opens on last month. |
| Quarters | No | A calendar quarter such as Jul-26 - Sep-26. Picking a quarter clears the month, and the reverse. |
The report opens already run for last month, with a tag above the table (for example Month: Oct-26) naming the period. Click Run Report to refresh after you change a filter. If you click it with neither a month nor a quarter chosen, a message asks you to pick one. The filter button beside Run Report shows or hides the filters.
The Return period inside the GSTR-1 return panel is separate from these filters. Changing the month here does not change the panel's period, so check both before you export.
If your business unit has a go-live date, a line under the filters says documents dated before it are not included, because they were reported from your previous system. See Entering documents from before go-live.
Columns
b2b, sez, de form:
Fields in this section
| Column | What it shows |
|---|---|
| GSTIN/UIN of Recipient* | The customer's GSTIN. |
| Name of Recipient | The customer's trade or legal name. |
| Invoice Number* | Click it to open the invoice. |
| Invoice Date* | The invoice date. |
| Invoice Value* | The invoice total, tax included. |
| Place of Supply(POS)* | The state code and name. |
| Applicable % of Tax Rate | Always a dash. |
| Reverse Charge* | Y or N. |
| Invoice Type* | Regular B2B, SEZ supplies with payment, SEZ supplies without payment or Deemed Export. |
| E-Commerce GSTIN* | Blank unless the invoice has one. |
| Rate* | The highest tax rate among the invoice's lines. |
| Taxable Value* | The invoice value before tax. |
| Cess Amount | Cess on the invoice. |
hsn(b2b) form: HSN, Description, UQC, Total Quantity, Total Value, Taxable Value, Integrated Tax Amount, Central Tax Amount, State/UT Tax Amount and Cess Amount, one row for each HSN code, unit and rate. An asterisk marks a field the GST portal requires.
How the figures are worked out
b2b, sez, de lists invoices that went to a registered customer with a GSTIN, and leaves out exports. Credit notes and debit notes are not in this table. It has one row per invoice, so an invoice with lines at different rates shows its highest rate against its whole taxable value. For rate-wise figures, use the file from the GSTR-1 return panel.
hsn(b2b) groups the invoice lines of the period by HSN code, unit of measure and rate, and adds the quantity, value and tax. Despite its name it covers every invoice of the period, not only those to registered customers. Credit notes are not in it.
An invoice counts in the month of its date, as it stands now.
A voided invoice, credit note or debit note leaves these reports completely, in every period including the one it was dated in, because voiding takes it out of your books. Bizconnekt refuses to void an invoice while it has an e-invoice (IRN) or a live e-way bill, a payment or an applied note. Cancelling an IRN alone does not remove the invoice: it still counts until you void it. Bills cannot be voided; deleting a bill removes it. If that period is already filed, raise a credit note instead of voiding.
Sorting, drill-down and export
The columns do not sort on this report. The b2b, sez, de rows come in date order, latest first; hsn(b2b) lists the highest rate first. Rows come 10 at a time; the pager at the bottom lets you change Items per page and jump to a page.
On b2b, sez, de, click the invoice number, or use Open Document, to open the invoice in a new tab. The hsn(b2b) form has no drill-down, so Open Document is not offered there.
Excel. The green spreadsheet icon above the table appears once there are rows, on both forms. It downloads every row of the period you chose, not only the page you see. The file is named GSTR1_B2B_SEZ_DE.xlsx or GSTR1_B2B_HSN.xlsx. Print, PDF and email are not available.
File for filing. The JSON file for the GST portal, and the Excel or JSON of each GSTR-1 table, come from the GSTR-1 return panel: see GSTR-1 filing.
Who can see it
Open the report with View on Tax Reports. Without it the report list shows a No Access page. Tax Reports has only View and Add/Edit, and a report changes no record, so Add/Edit makes no difference here. The report is for the business unit you are working in: switch business unit first if you keep more than one GSTIN. The GSTR-1 return panel needs Tax Compliance as well: View to see it, Add/Edit to export and file.
On mobile
In the mobile app open Reports, choose Tax Reports, then GSTR1. It has a Form filter with the same two forms, and Month, Quarters and Year lists. Choosing a Quarters value reports that quarter and replaces the month; choosing a Year switches the Month and Quarters lists to that year, as on the web. The download icon shares a CSV file of the rows on screen, not an Excel file. Filing is web only: the phone has no GSTR-1 return panel, and rows do not open the invoice. Same on iPhone and Android.
The Android app is on Google Play. The iPhone app is coming soon to the App Store.
Problems and fixes
I cannot find the export for filing
It is in the GSTR-1 return panel above the table, not in the table's spreadsheet icon. See GSTR-1 filing.
My invoice is missing from the b2b table
The table lists invoices to customers with a GSTIN, and leaves out exports. Check the customer's GSTIN and the invoice date, and clear any old invoice dated before go-live, which is not in these books.
An invoice with two rates shows one rate
The table shows one row per invoice, with its highest rate. The filing file carries the rates separately.
The hsn table has more than my B2B invoices
It covers every invoice of the period, despite its name.
The panel and the table show different periods
They have separate period pickers. Set both before you export.
The report page says No Access
Your role does not have View on Tax Reports. Ask an administrator to turn it on.