cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Find the help you need to prepare your business, communicate with customers, and support your employees during the Coronavirus (COVID-19) outbreak. Click here
Highlighted
Intuit

The GSTR 9 report in QuickBooks

In this article, we will cover understanding details about GST Annual return and how you can extract GSTR 9 report in QuickBooks. GSTR-9 is an annual return form that needs to be filed once a year by registered taxpayers under GST disclosing a detailed summary of outward supply and taxes paid thereon, input tax credits claimed, taxes paid, and refund claimed in the financial year. The due date for filing GSTR 9 return for financial year 2017-2018 is August 30, 2019. The due date for filing GSTR 9 return for Financial year 2018-2019 is December 31 2019.

QuickBooks already provides GSTR 1, GSTR 3B and GSTR 2A reconciliation report for any given period. The GST portal also gives a pre-populated GSTR 9 report with details of outward supplies, input credit claimed, taxes paid automatically filled in for few tables.

GSTR 9 report in QuickBooks will give you all the tables filled in based on the books of accounts. It will also highlight the Input tax credit reconciliation difference to be reported in GSTR 9 return. You can extract GSTR 9 report in GST reports under reports category. Alternatively, you can also go to GSTR 9 report through the search bar and typing the report name.

Extracting GSTR 9 report

  1. From the left navigation bar, choose Reports.
  2. In the Find report by name search box, type in GSTR and select the report named GSTR 9 report.
  3. Choose the Report period and click Generate report.
  4. QuickBooks needs to access your GSTN account to be able to fetch the GSTR 2A report and put the difference in the corresponding table of GSTR 9. If you have not enabled API access so far, you will be prompted by a drawer on the right.
  • Click Enable API request to be redirected to the GSTN portal.
  • You can also click How to enable API access in the GST portal to see an instructional video on how to do this.
  1. Once done, click Generate report once again and select I’ve enabled API access in the GST portal.
  2. This will take you to the Add GST details You can enter your GSTIN and GSTN login username.
  3. Click Get OTP. Enter the OTP received on your registered mobile number in the Verify OTP page that follows.
  4. Once this is done, QuickBooks will pull the Input credit for the period as per your 2A and populate the same amount in Table 8A of GSTR 9.
  5. When the report is ready, you will see Completed in the Status/Progress
  6. Click the Download link in the Action column. This will help you download the GSTR 9 report in Excel format.

Interpreting GSTR 9 report extracted from QuickBooks

GSTR 9 report is the annual return report to be filed by every registered person under GST. In QuickBooks you can extract GSTR 9 report and get it downloaded in excel format. GSTR 9 report is divided into six parts and consists of 19 tables.

Part I contains basic details and company information, which is auto-populated in QuickBooks based on your GST and company information provided.

Part II  Table 4 and Table 5 contains outward supplies declared in GSTR 1 and GSTR 3B.  The outward supplies are categorised based on the type of customers selected in QuickBooks. If you have not selected the right customer category, for instance: Registered, Unregistered, SEZ, Overseas then GSTR 9 may not show accurate classification for outward supplies. It is strongly advisable to verify that the suppliers are classified properly before generating the report to avoid any incorrect bucketing of transactions.

All the inward supplies and Input tax credit availed as declared in the GSTR 3B report will be reported in Part III Table 6. For Input tax credit, QuickBooks classifies into Input, Input services and Capital goods. It is dependent on the account and product/service category. If a product/service is created as an inventory, it will go into the Inputs sub category and if it is created as a service/non inventory item, it will be categorised into Input services. All the Input tax credit for bills with category as Fixed Assets will be categorised as Input capital goods.

Part III Table 7 – If you have any reversal of Input tax credit as per GSTR 3B, it has to be reported here.

Part III Table 8 – This contains Input tax credit as per GSTR 2A. QuickBooks populates this number automatically based on the 2A data downloaded from the GST portal. This table will give you the difference in Input tax credit availed whether excess credit claimed, or credit not fully utilised.

Tables 8E, 8F, 8G and 8H are to be filled out manually based on the GSTR review

Part IV, Part V and Part VI – Quickbooks does not populate this information automatically as data is not available to capture this information. This has to be filled in manually except for “Table 17 – HSN summary of outward supplies” and “Table 18 – HSN summary of inward supplies” which are filled automatically.

** Please note that since 2017-18 being the first year of GST annual return, there are chances of heavy differences in 2A and inward supplies pertaining to 2017-2018 but availed in April 2018 to September 2018. **

**Please ensure that for transactions pertaining to 2017-2018, all the customer and supplies classification are done properly else Part II – Table 4 and 5 will not give the accurate reporting for GSTR 9 purpose**

Once you have reconciled your 2A differences (if any) and verified/checked your GSTR 9 as per books data and corrected any deviations you may have uncovered there, you can go to GST Portal and fill the information from GSTR9 report generated from QuickBooks.

 

 

Section Pt. I: Basic Details

This section covers the basic details of the company including the Financial Year, GSTIN, Legal Name and Trade Name (if any). These details are extracted directly from QuickBooks.

Section Pt. II: Details of outward and inward supplies declared during the financial year

This section covers the details like Nature of supplies, Taxable Value, IGST, CGST, SGST and Cess value.

4 (A): Supplies made to unregistered persons (B2C)

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)
  3. Credit Note

 

Customer GST Registration Type
  1. Unregistered
  2. Consumer
Tax Codes
  • Non zero GST or IGST tax codes generated by the system
  • GST - 0.25% 3% 5% 6% 12% 18% 28%
  • IGST - 0.25% 3% 5% 6% 12% 18% 28%

4 (B): Supplies made to registered persons (B2B)

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)

 

Customer GST Registration Type
  1. Registered Regular
  2. Registered Composition
Tax Codes
  • Non zero GST or IGST tax codes generated by the system
  • GST - 0.25% 3% 5% 6% 12% 18% 28%
  • IGST - 0.25% 3% 5% 6% 12% 18% 28%

4 (C): Zero rated supply (export) on payment of tax (except supplies to SEZs)

Values will be picked up from transactions where all the following conditions are true.

 

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)

 

Customer GST Registration Type
  1. Overseas
Tax Codes
  • Not Nil or Out of Scope IGST rates. All non-zero IGST tax codes, i.e.
  • IGST - 0.25% 3% 5% 6% 12% 18% 28%

4 (D): Supply to SEZs on payment of tax

 

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)

 

Customer GST Registration Type
  1. SEZ
Tax Codes
  • Not Nil or Out of Scope IGST rates. All non-zero IGST tax codes, i.e.
  • IGST - 0.25% 3% 5% 6% 12% 18% 28%

4 (E): Deemed exports

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)

 

Customer GST Registration Type
  1. Deemed Exports
Tax Codes
  • Non zero GST or IGST tax codes generated by the system
  • GST - 0.25% 3% 5% 6% 12% 18% 28%
  • IGST - 0.25% 3% 5% 6% 12% 18% 28%

4 (G): Inward supplies on which tax is to be paid on reverse charge basis

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Bill (Purchase Bill)
  2. Cheque
  3. Expense

 

Supplier GST Registration Type
  1. GST Registered - Regular
  2. GST Unregistered
Products and Services
  1. Transactions contain items of the type Inventory, Non-Inventory, Service and have 100% Reverse Charge enabled.
  2. Know more about enabling reverse charge in products and services. (How to enter transactions with reverse charge service tax in QuickBooks)

4 (I): Credit Notes issued in respect of transactions specified in (B) to (E) above (-)

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Credit Note issued in respect of transactions specified in (B) to (E)

4 (J): Debit Notes issued in respect of transactions specified in (B) to (E) above (+)

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Supplier Credit issued in respect of transactions specified in (B) to (E)

5 (A): Zero rated supply (Export) without payment of tax

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)
Customer GST Registration Type
  1. Overseas
Tax Codes
  • Nil IGST or Out of Scope rates. Nil includes all zero IGST tax codes, i.e.
  • IGST - Exempt IGST (0%) 0% IGST (0%)

 

5 (B): Supply to SEZs without payment of tax

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)
Customer GST Registration Type
  1. SEZ
Tax Codes
  • Nil IGST or Out of Scope rates. Nil includes all zero IGST tax codes, i.e.
  • IGST - Exempt IGST (0%) 0% IGST (0%)

5 (C): Supplies on which tax is to be paid by the recipient on reverse charge basis

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)
Customer GST Registration Type
  1. SEZ
Tax Codes Out of Scope rates
  1. Note that Out of Scope is to be set at the transaction level, i.e. in the Amounts are dropdown.
  2. Transactions where 0% GST/IGST and Exempt GST/IGST have been selected in the line item level are not included here.
Products and Services
  1. Transactions contain items of the type Inventory, Non-Inventory, Service and have 100% Reverse Charge enabled.
  2. Know more about enabling reverse charge in products and services. (How to enter transactions with reverse charge service tax in QuickBooks)

5 (D): Exempted

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)
Tax Codes
  • Exempt tax code. All zero tax codes GST and IGST tax codes, i.e.
  • GST - Exempt GST (0%)
  • IGST - Exempt IGST (0%)

5 (E): Nil rated

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)
Customer GST Registration Type
  1. GST registered- Regular
  2. GST registered- Composition
  3. GST unregistered
  4. Consumer
  5. Deemed Exports
Tax Codes
  • Nil GST or Nil IGST rates
  • GST - 0% GST (0%)
  • IGST - 0% IGST (0%)

 

5 (F): Non-GST supply

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Invoice
  2. Sales Receipt (Cash Memo)
Customer GST Registration Type
  1. GST registered- Regular
  2. GST registered- Composition
  3. GST unregistered
  4. Consumer
  5. Deemed Exports
Tax Codes Out of Scope
  1. Note that Out of Scope is to be set at the transaction level, i.e. in the Amounts are dropdown.
  2. Transactions where 0% GST/IGST and Exempt GST/IGST have been selected in the line item level are not included here.
Products and Services
  1. Transactions contain items of the type Inventory and Non-Inventory which have not been enabled for Reverse Charge.
  2. Know more about enabling reverse charge in products and services. (How to enter transactions with reverse charge service tax in QuickBooks

5 (H): Credit Notes issued in respect of transactions specified in A to F above (-)

Values will be picked up from transactions where all the following conditions are true.

Transaction Type Credit Note issued in respect of transactions specified in A to F

5 (I): Debit Notes issued in respect of transactions specified in A to F above (+)

Values will be picked up from transactions where all the following conditions are true.

Transaction Type Supplier Credit issued in respect of transactions specified in A to F

6 (A): Total amount of input tax credit availed through FORM GSTR-3B (sum total of Table 4A of FORM GSTR-3B)

This data is obtained from the government and self-populated in the report.

6 (B): Inward supplies (other than imports and inward supplies liable to reverse charge but includes services received from SEZs)

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Bill (Purchase Bill)
  2. Cheque
  3. Expense
Supplier GST Registration Type
  1. GST Registered - Regular
  2. GST Unregistered
  3. GST Registered - Composition
  4. SEZ
Products and Services
  1. Transactions that contain items of the type Inventory and Non-Inventory which have not been enabled for Reverse Charge, will fall under the Inputs field.
  2. Transactions that contain items of the type Service which have not been enabled for Reverse Charge, will fall under the Input Services field.
  3. Know more about enabling reverse charge in products and services. (How to enter transactions with reverse charge service tax in QuickBooks 
  4. As the option to track Capital Goods purchases for GST filing is not currently available in QuickBooks, the Capital Goods section is left vacant.

6 (C): Inward supplies received from unregistered persons liable to reverse charge (other than B above) on which tax is paid & ITC availed

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Bill (Purchase Bill)
  2. Cheque
  3. Expense
Supplier GST Registration Type
  1. GST Unregistered
Products and Services
  1. Transactions contain items of the type Inventory, Non-Inventory, Service and have 100% Reverse Charge enabled.
    1. Transactions that contain items of the type Inventory and Non-Inventory will fall under the Inputs field.
    2. Transactions that contain items of the type Service will fall under the Input Services field.
  2. Know more about enabling reverse charge in products and services. (How to enter transactions with reverse charge service tax in QuickBooks)
  3. As the option to track Capital Goods purchases for GST filing is not currently available in QuickBooks, the Capital Goods section is left vacant.

6 (D): Inward supplies received from registered persons liable to reverse charge (other than B above) on which tax is paid and ITC availed

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Bill (Purchase Bill)
  2. Cheque
  3. Expense
Supplier GST Registration Type
  1. GST Registered
Products and Services
  1. Transactions contain items of the type Inventory, Non-Inventory, Service and have 100% Reverse Charge enabled.
    1. Transactions that contain items of the type Inventory and Non-Inventory will fall under the Inputs field.
    2. Transactions that contain items of the type Service will fall under the Input Services field.
  2. Know more about enabling reverse charge in products and services. (How to enter transactions with reverse charge service tax in QuickBooks)
  3. As the option to track Capital Goods purchases for GST filing is not currently available in QuickBooks, the Capital Goods section is left vacant.

6 (E): Import of goods (including supplies from SEZs)

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Bill (Purchase Bill)
  2. Cheque
  3. Expense
Supplier GST Registration Type
  1. Overseas
  2. SEZ
Products and Services
  1. Transactions contain items of the type Inventory, Non-inventory (regardless of Reverse Charge being enabled) will fall under the Inputs field.
  2. Know more about enabling reverse charge in products and services. (How to enter transactions with reverse charge service tax in QuickBooks
  3. As the option to track Capital Goods purchases for GST filing is not currently available in QuickBooks, the Capital Goods section is left vacant.

6 (F): Import of services (excluding inward supplies from SEZs)

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Bill (Purchase Bill)
  2. Cheque
  3. Expense
Supplier GST Registration Type
  1. Overseas
Products and Services
  1. Transactions contain items of the type Service (regardless of Reverse Charge being enabled).
  2. Know more about enabling reverse charge in products and services. (How to enter transactions with reverse charge service tax in QuickBooks

16 (A): Supplies received from Composition taxpayers

Values will be picked up from transactions where all the following conditions are true.

Transaction Type
  1. Bill (Purchase Bill)
  2. Cheque
  3. Expense
Supplier GST Registration Type
  1. GST Registered - Composition

17: HSN wise summary of outward supplies

All sales grouped by HSN, UQC and Tax Code.

18: HSN wise summary of inward supplies

All purchase grouped by HSN, UQC and Tax Code.

Was this helpful?

You must sign in to vote, reply, or post