The GSTR1 return ready report is available in QuickBooks as a summary along with a zoom-in capability that help you see the transactions that make up the report.

To open the GSTR1 return report, click Reports, select GSTR Reports and then click GSTR1 - Summary of outward supplies.

Know more about locating and exporting this report: Your Reports home page has changed ; How to export QuickBooks data for GSTR1

This article will help you understand the component reports in the GSTR1 - Summary of outward supplies report.

The first three sections of the GSTR1 need to be filled manually. The sections are described here briefly:

Section-1: Enter your company GSTIN.

Section-2a: Enter legal name of the registered person.

Section-2b: Enter trade name of the company.

  Important - We’re continuously working on refining your QuickBooks experience. To this end, we’ve made a decision to alter the GSTR1 - Summary of outward supplies report and revise it effective August 9. Forms of the type Credit Note will not be picked up by the GSTR1 - Summary of outward supplies report while this revision is in progress. We will keep you posted on reintroduction of this form in the GSTR1 - Summary of outward supplies report.

Section-3a: Aggregate turnover in the preceding Financial Year

For Section 3a, run the Profit and Loss Report from the previous FY i.e. 1st April 2016 to 31st March 2017. The sum in front of the Total Income will have to be populated in the section.

Section-3b: Aggregate Turnover - April to June, 2017

To get the value for Section 3b, run the Profit and Loss Report from 1st April 2017 to 30st June 2017. The sum in-front of the Total Income will have to be populated in the section.

GSTR1 Reports in QuickBooks will list data for section 4 onward:

Notes:

  • Currently QuickBooks does not support reports at a subsection level i.e. GSTR1- Section 4 is available but segregation at a subsection level (4A, 4B, 4C) is not available.
  • “Out of scope” tax code to be used for transactions with customer type as Overseas and SEZ only and where an LUT (Letter of Undertaking) has been obtained from the government.
  • These reports cannot be customised to include additional columns related to customers.
  • Shipping charges are captured only if they are entered along with the products/services in an invoice, i.e. in activity table. Shipping charges entered in the built-in Shipping field will not be captured by the GSTR1.

Section-4: Taxable outward supplies made to registered persons (including UIN-holders) other than supplies covered by Table 6.

Screenshot of GSTR1 sec 4

The above section includes all the transactions (Invoice, Sales Receipt, Credit Note) to the customer with GST registration type as GST registered- Regular or GST registered- Composition.

What QuickBooks does not capture in this report:

  • Whether reverse charge is applicable on an invoice or sales receipt
  • GSTIN of e-commerce operator
  • TCS that is deducted by e-commerce operator
  • Cess
  • Refund Receipt

Important

  • Section 4 will display invoices with line items that have been taxed at 0% GST, IGST and Exempt GST, IGST if a non-zero GST or IGST rate has been applied to another line item included in the same invoice. This has been done to facilitate display of all invoice content in the same location which in turn would ease reconciliation of this content when it is made available to your customer as a GSTR2 or equivalent report.
    • For example, if an invoice contains a line time being taxed at 18.0% IGST and another one being taxed at 0% IGST, both line items will display in the GSTR1 - 4.B2B INVOICES report. The 0% and Exempt line will also display in GSTR1 - 8. Nil rated, Exempted and Non-GST outward supplies.
  • Section 4 will not display invoices that have been taxes at 0% GST, IGST and Exempt GST, IGST if there are no non-zero GST or IGST rates applied on other line items in the invoice. In this case, the line items would only be displayed GSTR1-8.

Section-5: Taxable outward inter-State supplies to un-registered persons where the invoice value is more than Rs. 2.5 lakh.

Screenshot of GSTR1 sec 5

The above section includes all the transactions (Invoice, Sales Receipt, Credit Note) to the customer with GST registration type as GST unregistered or Consumer, with Invoice value greater than 2.5 lakhs and place of supply other than the state in which QuickBooks user’s business is registered. Only IGST is applicable on such transactions.

What QuickBooks does not capture in this report:

  • GSTIN of e-commerce operator
  • TCS that is deducted by e-commerce operator
  • Cess
  • Refund Receipt

 

Section-6: Zero-rated Supplies and Deemed Exports

screenshot of GSTR1 Section 6

The above section includes all the transactions (Invoice, Sales Receipt, Credit Note) to the customer with GST registration type as Overseas, SEZ or Deemed Exports.

What QuickBooks does not capture in this report:

  • Refund Receipt
  • Port Code
  • Note: Currently if a customer has chosen GST tax rates instead of IGST tax rate, the transaction will be shown in the report but with the blank IGST rate and IGST amount. User will have to correct these transaction for the transactions to be downloaded in the government excel utility.

 

Section-7: Taxable supplies (Net of debit notes and credit notes) to unregistered persons other than the supplies covered in Table 5.

Screenshot of GSTR1 sec 7

The above section includes all the transactions (Invoice, Sales Receipt, Credit Note) to the customer with GST registration type as GST unregistered or Consumer and excluding invoices and sales receipt of Section 5 (B2C large interstate transactions).

What QuickBooks does not capture in this report:

  • GSTIN of e-commerce operator
  • TCS that is deducted by e-commerce operator
  • Cess
  • Credit Notes and Refund Receipt

 

Section-8: Nil rated, exempt and non GST outward supplies

Screenshot of GSTR1 section 8

Above section includes all the transactions (Invoice, Sales Receipt, Credit Note) to the customer with GST registration type and tax code as:

  • GST registered- Regular or GST registered- Composition and transactions with only 0% GST, 0% IGST, Exempt GST 0% and Exempt GST 0% as tax codes applied in them.
  • GST unregistered or Consumer and transactions (Interstate and Invoice value greater than 2.5 lakhs) with only 0% GST, 0% IGST, Exempt GST 0% and Exempt GST 0%  as tax codes applied in them.
  • GST unregistered or Consumer and line items of the transactions (Interstate and Invoice value less than or equal to 2.5 lakhs/ all intrastate) with only 0% GST, 0% IGST, Exempt GST 0% and Exempt GST 0%  as tax codes applied in them.

What QuickBooks does not capture in this report:

  • Non-GST supplies
  • Refund Receipt.

 

 Section-12: HSN-wise summary of outward supplies

Screenshot of GSTR1 section 12

Above section includes the total quantity for all the HSN which have been included in transactions of the type Invoice, Sales Receipt and Credit Note for the filing period along with total value (before discount) and taxable value per HSN.

If the Product HSN codes are updated in QuickBooks and those products are used in the transaction they will be listed in this report.

What QuickBooks do not capture in this report:

  • Cess

 

Section-13: Documents issued during the tax period.

This section is not available in the GSTR-1 : Summary of Outward Supplies report. To see this section, click the Export icon in the GSTR-1 : Summary of Outward Supplies report and select Export to GST utility excel.

Screenshot of Section 13 in the GST Utility Excel

Above section includes count of document issued during the current tax filing period along with the starting and ending serial number for the respective transactions type.

Nature of document included in this report currently:

  • Invoices for outward supply (Invoices and sales receipt)
  • Credit Note
  • Payment Voucher (expense, checks)
  • Refund voucher (Refund Receipt)

Cancelled column will be empty for the report.

Note: Sections 9B, 10, 11 are not available in QuickBooks. 

Found this article helpful? Click Yes below and share your feedback!