Update HSN Master by Purchase Invoice and Purchase CSV File in Unisolve

How to update HSN in Product Master



SWIL


How to update HSN in Product Master 


The 1st Proviso to Rule 46 of CGST Rules 2017 has been amended, vide Notification No.79/2020-CT dated 15-10-2020, for declaration of HSN code in invoice. Under this amended Proviso, Notification No. 78/2020 – Central Tax, dated 15.10.2020 has been issued to make HSN code mandatory up to 4 digits in the B2B invoices with effect from 01.04.2021 issued by taxpayers whose aggregate turnover in the preceding financial year is upto Rs. 5 crores. For the taxpayers whose turnover in the preceding financial year is more than Rs. 5 crores, the HSN code is mandatory up to 6 digits in invoices with effect from 01.04.2021.

In this article, we have explained to you how to update HSN (6/8 Digits) in Product Master at the time of Import Purchase through CSV files or also update HSN Master in Product Master through already our old Purchase CSV Files. 

Maximum Companies update HSN with 6 digits in his Product Master, that’s why when they send any Purchase Invoice in CSV Format then HSN auto comes in 6 Digits. If any of your Companies/Suppliers does not send 6 Digit HSN in the Purchase CSV file, then you can ask your Companies/Suppliers for this. 

Firstly, for this please install the latest patch of Unisolve to update the same & run Update GST Tax Master through GST-> GST Updates menu.

In Unisolve/Cross there are many options to update HSN in Product Master, We have explained to you 3 options as per the following. 

First Option: Update HSN through Purchase Invoice at the time of entering Purchase. 

In our new path, we have provided a new option to enter your new HSN at the time of entering your Purchase Invoice. For this Please enable “Edit in Purchase Invoice (HSN)” through System-> System Maintenance-> System Parameters-> Edit Tab. Screen as per below:


Edit in Purchase Invoice (HSN)


After that when you enter your Purchase Invoice, the software stops the cursor on the HSN field also. Please enter your new HSN in this column. If the HSN Code does not exist in your HSN Master then software auto-creates this HSN in your HSN Master as per Purchase Tax Type when you enter HSN No. in this column & press Esc. key. Screen as per below: 


HSN No


Please check software auto-creates HSN in HSN Master as per Tax also which you entered in Purchase Invoice. Screen as per below: 


Purchase Invoice


Second Option: Auto Update HSN in Product Master while Import Purchase through CSV File. 

If you received the CSV format file as in the Standard format of AIOCD, then please select Format Name “SWIL Format (GST)” At the time of Import Purchase through CSV File. Currently, when you did not select format name but still our software Import your Purchase Invoice properly but not Import HSN, but now if you select format name then software also auto-updates HSN as per your Purchase CSV file in your Product Master. Screen as per below:


Product Master


Third Option: Update HSN through old/existing Purchase CSV Files. 


If you want to update HSN through your old CSV Files then the software gives you a new option “Update HsnCodes in Product” in System-> Facilities-> Product menu. For this option you can just select your Purchase CSV File, Supplier Name & CSV Format name then press OK then software auto-update HSN Codes in your Product Master as per CSV File. Screen as per below:


Update HsnCodes in Product


You can also make a new CSV Format with the name of "HSN" through Utility-> Import CSV Master option to Import HSN with any CSV/Excel file (No need to Standard format of CSV file). Screen as per below:


 Import CSV Master


CSV file



Fourth Option: Create HSN manually in HSN Master & change all new HSN as compare with old HSN. 

If you want to update your new HSN (6/8 Digits) in Product Master as compare with your old HSN then firstly please create/enter a new HSN (6/8 Digits) in HSN Master (System-> Master Data-> Product Information-> HSN List). Screen as per below:


HSN List


After creating this you can update the new HSN as compare with the old HSN through the “Update Product HSN Code” option.  This option is available in the GST-> GST Updates menu. 

When you open this option, then you can select Master Group, Group, HSN, Product then enter Show Products. Then software shows your entire selected Product list in the below window. If you select particular HSN’s Products (Like 3004) then the software shows only those products in this list. If you want to update all products in a particular HSN then select your new HSN (6/8 Digits) in “Product HSN(SAC)”. After that press on “Update HSN(SAC) to All” then software updates the new HSN in all selected products. Now press “Update HSN(SAC)” which shows on the bottom side of this window. Screen as per below: 


Update Product HSN Code


Through this option, if you want to change HSN manually one by one in all Products, then you can also click on HSN(SAC) in front of Product in this window, then software opens the HSN window & you can able to select a new HSN (6/8 Digits) as per. Screen as per below:


HSN


Fifth Option: Update/Import HSN through Product CSV/Excel File.

Through this option, if your supplier/company sending you an Excel file of Products & you want to update your all HSN's as per this excel file, then please convert/save this file in CSV format. After that please select "Import HSN(SAC) from Personal UPC Master" through GST->GST Updates menu. Screen as per below:  

 
Import HSN



After that, Please select your CSV file in "Import CSV File Path", then select columns of UPC, Product Code, Product Name, HSN & Tax Rate as per your CSV/Excel File & press OK to mapped your products as per compare with CSV/Excel file.  "Product Code, Product Name, HSN" is the compulsory column to select in this column. Screen as per below:  


Import CSV File Path


After that software opens a new window to mapped your Products as per CSV/Excel file. Press OK to import all HSN as per CSV/Excel file. Screen as per below:


import all HSN



SWIL suggested you, please update all HSN in your Product Master before 01/04/2021 to avoid any future issues.


After update HSN (6/8 Digits) in your Product Master, If you want to print 6/8 digits HSN in reports also then please mention HSN width (6/8) in “HSN width for Reports” (System-> System Maintenance-> System Parameters-> GST tab). By default, the width is 4. Screen as per below: 


HSN width for Reports


After that when you check any report then please enable “Print HSN” in the report, the software prints HSN width as given to you in System Parameters. Screen as per below:


Reports



Print HSN


If you require support please read:  How to get online support (Guide & Video)


To avail of this facility, Please download our Latest Patch of Unisolve Software. To download the last patch please read: How to Download Last Patch (Guide)


For more details, please make a ticket at swildesk.com.


Thanks



SWIL Team


Unisolve software




      • Related Articles

      • How to update HSN Code in Unisolve-Cross

        The following document was updated on July 07, 2017 In GST Tax Regime, tax is defined using the HSN code.HSN (Homogeneous System Nomenclature) is meant for identifying a particular product at the global level. It does not identify a brand or value of ...
      • GST - How to update Rate and HSN in products

        Please download attached PDF file and follow steps after installation of new version 16,2. After downloading the patch, run Update GST Tax Master from System-GST Updates menu to update tax codes. You can update product HSN and product rates using ...
      • How to Set Discount Master in Cross for Customers/Patients

        How to Set Discount Master in Cross Software for Customers/Patients In Cross software, a new feature has been added of discount master. This option allows users to set the sale discount(%) on a particular Category, Patient, Group or Product by ...
      • How to Create Lock MRP Master According to DPCO's New Issued Restricted MRP in Unisolve & Cross

        How to Create Lock MRP Master According to DPCO's New Issued Restricted MRP The DPCO (Drug Price Control Order) declared a new ceiling price for essential and life saving medicines (as per a prescribed formula). According to the government's new ...
      • Unisolve Shows Product Information in Sales Menu

        How to View Product Information in Unisolve's Sales Invoice Section In the Unisolve software, users can conveniently access product details within the sales invoice section. During the billing process, users can easily view the customer sales ...