Know more:  How to export QuickBooks data for GSTR1 (India only)

Revised format for GSTR1 is now available on QuickBooks. This article will help you understand the various GSTR1 reports generated in QuickBooks.  
  
The first three sections of the GSTR1 need to be filled manually. The sections are described here briefly: 


Section-1 : Please enter your company GSTIN.  
  

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

Section-2b : Please enter trade name of the company.

    

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: 

Note: 

  1. 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. 

  2. “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.

  3. These reports cannot be customized to include additional columns related to customers.

Section-4Taxable 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 and Sales receipt) to the customer with GST registration type as GST registered- Regular or GST registered- Composition.
 
What QuickBooks does not capture in this report:
  1. Whether reverse charge is applicable on an invoice or sales receipt
  2. GSTIN of e-commerce operator.
  3. TCS that is deducted by e-commerce operator.
  4. Cess

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 and Sales receipt) 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:
  1. GSTIN of e-commerce operator.
  2. TCS that is deducted by e-commerce operator.
  3. Cess.

Section-6: Zero-rated Supplies and Deemed Exports 

 
screenshot of GSTR1 Section 6

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

What QuickBooks does not capture in this report:
  1. Port Code.
Note:
  1. 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 and Sales receipt) 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:
  1. GSTIN of e-commerce operator.
  2. TCS that is deducted by e-commerce operator.
  3. Cess.
  4. Credit Notes and Refund Voucher.

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


Above section includes all the transactions (Invoice and Sales receipt) to the customer with GST registration type and tax code as:
  1. 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.
  2. 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.
  3. 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.
Screenshot of GSTR1 section 8
 
What QuickBooks does not capture in this report:
 
  1. Non-GST supplies
  2. Credit Notes and Refund Voucher.


 Section-12: HSN-wise summary of outward supplies


Above section includes the total quantity for all the HSN which have been included in invoices and sales receipts 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. 
 
Screenshot of GSTR1 section 12

What QuickBooks do not capture in this report:
  1. Cess.
  2. UQC
 
Section-13: Documents issued during the tax period 


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. 
 
Screenshot of GSTR1 Section 13

Nature of document included in this report currently:
  1. Invoices for outward supply (Invoices and sales receipt)
  2. Credit Note
  3. Payment Voucher (expense, checks)
  4. Refund voucher
Cancelled column will be empty for the report. 

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