How to create a new template mapping in JioGST Wizard

Template mapping in JioGST Wizard

Template mapping feature is provided as an interface between existing accounting application and JioGST Wizard.  User can download source data file from existing accounting application and map it to templates to create GST compliant data.

This is the Home page of JioGST Wizard. This Page displays the latest announcements about JioGST Wizard. In order to start using the features, user will first have to select a GSTIN from the icon next to ''Select GSTIN'' at the top of the page.

A dropdown with the list of the added GSTIN’s will appear. Select one GSTIN from the list on which you wish to do the compliance.

Once GSTIN is selected, it will be visible on the top of the screen. You can now start the compliance journey in JioGST Wizard under the selected GSTIN.

To create a mapping for your sales data, click on 'Outward Sales' tab from the menu and then select Template Mapping > GSTR 1

Below are the steps for creating template mapping:

1. Select the template type

Select the template type for which you want to create the mapping from the available templates.

JioGST Wizard provides the below mentioned templates for GSTR1:

B2B, B2CL, B2CS, Exports, Credit & Debit Note(CDNR), Advances(AT), Nil rated, HSN Summary (HSNSUM), Document Issued (DOCISS).
(In this blog we will create a mapping for B2B template)

2. Create a new mapping

If you are creating a mapping for the first time select 'New Mapping'.

You also have an option to select an 'Existing mapping' or 'Import' a mapping from a different GSTIN of the same account.

3. Select file type

Select the type of data file for which you are creating the mapping. Data file can be in .xls, .csv or .txt format. (In this blog we will map an excel data file)

4. Browse the data file for which you want to create mapping

Note- Do not keep the data file open, else you will get an error.

5.  Field mapping

• It is necessary to have Header columns in the source file so that mapping is done correctly.
• Below screen is mapping screen where fields in the left hand side are GSTN required fields and right hand side fields are from your source data file.
• For mapping of fields JioGST Wizard will display all the Header columns from your source data file in the drop down.
• Select a field from the dropdown and map it against the GSTN Field.
• Mandatory and Conditional Mandatory columns are differentiated by * and ** sign.
• Once all the fields are mapped, provide a mapping name and then click on 'Save' button

6. On clicking 'Save', the template gets saved in the database and you get a popup as shown in below screen. Click on 'Yes' button to create the mapping.

7. Your template mapping will be created successfully, click on 'OK' button.

8. You can see the template just created in the ''Existing'' template section.

You can use this template every time the data is uploaded from this source data file unless there are no changes made in the headers of the source data file.