Summary

Under this feature format of GSTR -1 and GSTR-2 Return has been updated as per new format updated by one of the GSP ClearTax. 


As per new format Following CSV Files have been depreciated: 


GSTR-1 

GSTR1 Adjust multiple Advance Receipt for invoice 

GSTR1 Advance Receipt Format 

GSTR 1 Refund voucher 


GSTR-2: 

GSTR2 Adjust multiple Advance payment for Invoice. 

GSTR2 Advance payment format 

GSTR2 Refund voucher 


Following Files haven been retained and updated: 


GSTR1 

GSTR1 Invoice and Bill of Supply 

GSTR1 Credit Debit Note 


GSTR-2 

GSTR2 Invoice and Bill of Supply 

GSTR2 Credit Debit Note 


Changes in New Return format: 


GSTR-1 Return: 


Following additional columns have been added: -

Sales Invoice and Bill of Supply: 

image.png

Sales credit Debit note:

image.png

  GSTR-2 Return: 


Following additional columns have been added: -


• Purchase Invoice and Bill of supply: 

image.png

• Purchase Credit and Debit note: 

image.png
Steps for setups

These tasks will prepare Finance to reporting ANX-1:

  • Import and set up Electronic reporting (ER) configurations.

  • Mapping of reporting configuration in Tax setup

  • Provide report data for report generation.

    • ANX-1

    • Generate ANX-1 (10 CSV) files

  • Provide report data for report generation.

    • Purchase Register

    • Generate Purchase Register excel file.


Import tax configuration.

  • Taxable Document.version.82

  • Taxable Document (India). version 82.155

  • Tax (India GST). version.82.155.300


Overview

Import and set up Electronic reporting (ER) configurations.

To prepare Finance for GSTR Return reporting, you must import the following or higher versions of ER configurations in sequence provided below:

[Asset 4580282]

Import the latest versions of these configurations. The version description usually includes the changes that were introduced in the configuration version.

Note: After all the ER configurations from the preceding table are imported, user need to do mapping of Report configuration in the Tax setup

  image.png

Name

Version

Report Controller

Description (Pl)

GST ANX-1 Govt. Offline Tool

19.22

GST ANX-1 Govt. offline Tool

New GSTR return applicable from 1.4.2020 onward

GSTR-1 CSV (old)

16.32

GSTR-1 (old)

Existing GSTR-1 format

GSTR-1 Govt. Offline Tool CSV

19.10

GSTR-1 Govt. Offline Tool

Existing GSTR-1 offline tool. (Ineffective from 1.4.2020)

GSTR-2 CSV (old)

16.36

GSTR-2 (old)

Existing GSTR-2 format

Purchase register

19.7

Purchase Register

New Register for inward transaction applicable from 1.4.2020

GSTR-1 CSV (new)

16.41

GSTR-1 (new)

New GSTR-1 format

GSTR-2 CSV (new)

16.40

 GSTR-2 (new)

New GSTR-2 format

 

Important columns added in New GSTR-1  

Name

Report

File Format

Column Title

Description of Information  

GSTR-1

Sales Invoice and Bill of supply

CSV

Differential% of Tax rate 

If the supply is eligible to be taxed at lower % of the existing rate of tax, select "define%". For example, if normal tax rate is 12% and differential % of tax rate is 65% the applicable tax rate would be 7.8%

GSTR-1

Sales Invoice and Bill of supply

CSV

Supply covered under Section 7 of IGST Act

If the supply is covered under sec 7 of IGST act then select 'Yes' from dropdown; else blank. Supply covered under Section 7

(a) two different States.

(b) two different Union territories; or

 

(c) a State and a Union territory shall be treated as a supply of goods in the course of inter-State trade or commerce.

(d) Supply of goods imported into the territory of India, till they cross the customs frontiers of India, shall be treated to be a supply of goods in the course of inter-State trade or commerce.

 

GSTR-1

Sales Invoice and Bill of supply

CSV

Would you claim refund?

 

If you want to claim refund, then select 'Yes'; else select 'No' from the drop down.
 If supplies without payment of tax, then select only 'No' from the drop down

 

GSTR-1

Sales Invoice and Bill of supply

CSV

Return filling month

It will pick from the period range defined in GSTR report dialog box.

GSTR-1

Sales Invoice and Bill of supply

CSV

Return filling Quarter  

It will pick from the period range defined in GSTR report dialog box.


GSTR-1

Sales credit Debit note

CSV

Applicable % of tax rate

If the supply is eligible to be taxed at lower % of the existing rate of tax, select "define%" from dropdown; else blank

GSTR-1

Sales credit Debit note

CSV

Supply covered U/s 7 of IGST act

If place of supply of Invoice address and place of supply of shipping address are in different location including export /SEZ/DE

GSTR-1

Sales credit Debit note

CSV

Would you claim refund

If GST payment type is WOPAY than display No, else select Yes.

 

GSTR-1

Sales credit Debit note

CSV

Type of export

Provide one of the following 4 values.

  • Export with Payment of GST

  • Export without Payment of GST

  • SEZ

  • Deemed Export

GSTR-1

Sales credit Debit note

CSV

Shipping port code – export

Shipping port code will come from Shipping Bill

GSTR-1

Sales credit Debit note

CSV

Shipping Bill number -export

Shipping Bill number information flow from Posted shipping bill order

GSTR-1

Sales credit Debit note

CSV

Shipping bill date-export

Shipping Bill number information flow from Posted shipping bill order

GSTR-1

Sales credit Debit note

CSV

Return filling month

Month for which transactions report is generated.

GSTR-1

Sales credit Debit note

CSV

Return filling quarter

It will pick from the period range defined in GSTR report dialog box.

GSTR-1

Sales credit Debit note

 

GSTN of e-commerce marketplace

GSTIN of e-commerce operator from the e-commerce operator tax information from masters

 

 

 

Important columns added in New GSTR-2  

Name

Report

File Format

Column Title

Information Description 

GSTR-2

Purchase Invoice and Bill of Supply

CSV

Differential % of Tax Rate

 

If the supply is eligible to be taxed at lower % of the existing rate of tax, select "define%" from dropdown; else blank. "Applicable percentage of rate " in the rate set up for Tax component.

GSTR-2

Purchase Invoice and Bill of Supply

CSV

Supply covered under Section 7 of IGST Act

If place of supply of Invoice address and place of supply of shipping address are in different location including export /SEZ/DE.

GSTR-2

Purchase Invoice and Bill of Supply

CSV

Would you claim refund?

 

If you want to claim refund, then select 'Yes'; else select 'No' from the drop down.
 If supplies without payment of tax, then select only 'No' from the drop down

 

GSTR-2

Purchase Invoice and Bill of Supply

CSV

Return filling month

It will pick from the period range defined in GSTR report dialog box.

GSTR-2

Purchase Invoice and Bill of Supply

CSV

Return filling Quarter  

It will pick from the period range defined in GSTR report dialog box.

GSTR-2

Purchase Credit Debit Note

CSV

Supply covered under Section 7 of IGST Act

If in the Tax document "Inter-state" is yes this field will be displayed as "Yes"

 

GSTR-2

Purchase Credit Debit Note

CSV

Would you claim refund

If you want to claim refund, then select 'Yes'; else select 'No' from the drop down.
 If supplies without payment of tax, then select only 'No' from the drop down

 

GSTR-2

Purchase Credit Debit Note

CSV

Type of Import

Provide one of the following 4 values.

  • Import with Payment of GST

  • Import without Payment of GST

  • SEZ

  • Deemed Export

 

GSTR-2

Purchase Credit Debit Note

CSV

Bill of Entry port code – Import

Bill of entry code will come from Bill of entry 

GSTR-2

Purchase Credit Debit Note

CSV

Bill of Entry number -Import

Bill of entry   number information flow from Posted Bill of Entry

GSTR-2

Purchase Credit Debit Note

CSV

Bill of Entry date-Import

Bill of entry   date information flow from Posted Bill of Entry

GSTR-2

Purchase Credit Debit Note

CSV

Bill of Entry Value -Import

The Assessable value displayed in the Bill of entry form.

GSTR-2

Purchase Credit Debit Note

CSV

Return filling month

It will pick from the period range defined in GSTR report dialog box.

GSTR-2

Purchase Credit Debit Note

CSV

Return filling quarter

It will pick from the period range defined in GSTR report dialog box

 


Setup

Process to Generate data in .CSV file.

(a)   Load Report configuration in the workspaces

Path: Workspaces>Electronic reporting >Reporting configurations>exchange. Load configurations

Import configuration files in the sequence provided above.

  image.png

 

(b)  Mapping of Report configuration in the Tax setup

Path: Click Tax > Setup > Tax configuration > Tax setup > Configurations > Report configurations > Select report configuration

Import following files:

  1. GSTR for New Return

      • GST Returns model 16

      • GST Returns model mapping 16.7

      • GSTR-1 for Old Return 16.32

      • GSTR-1 for new Return 16.41

      • GSTR-2 for Old Return 16.36

      • GSTR-2 for new Return 16.40

  image.png

 

  1. Click Configurations > Report configuration tab.

  2. Mark Select checkbox.

  3. Select the value in Report data provider field.

  4. Click Close.

Note: In case user does not select any Report under report controller than report will not be available for generation under Sales tax reports.

 

(c)   Generate New GSTR-1 report and New GSTR-2 report.

GSTR-1 Report:

  • Navigate to Tax > Sales Tax reports > India > GER export to GSTR CSV

  • Define From date

  • Define To date

  • Select GSTIN Registration number

  • Select Configuration ‘GSTR-1 for New Return.’

  • Define file name “GSTR-1 for New Return” to save the report with name.  image.png

  • Click OK

CSV files for GSTR-1 generated as below: -

image.png 

(d)  GSTR-2 Return New format:

  • Navigate to Tax > Sales Tax reports > India > GER export to GSTR CSV

  • Define From date

  • Define To date

  • Select GSTIN Registration number

  • Select Configuration ‘GSTR-2 for New Return.’

  • Define file name “GSTR-2 for New Return” to save the report with name.  

      image.png


  • Click OK

  • CSV files for GSTR-1 generated as below: -

 

  image.png



More information

You can contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

Partners

https://mbs.microsoft.com/partnersource/resources/support/supportinformation/Global+Support+Contacts

Customers

https://mbs.microsoft.com/customersource/northamerica/help/help/contactus

In special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.



Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×