Unit Quantity Code (UQC) is a uniform measuring unit used by the department for measuring quantity in the returns filed. UQCs are used to maintain consistency and prevent variations in quantities in the returns filed by different businesses. This requires the businesses to measure the quantities of items using the UQC from the list given by the department.
Using Tally.ERP 9, you can map your unit of measurement to the UQC given by the department, and file the returns. This can be done in the UoM master as well as in the Map UoM-UQC report, which allows you to map all the UoMs at once. In case an item has more than one UoM, and thus linked to multiple UQCs, you will have to select the reporting UQC for such items to report in GST returns.
To map UoM to UQC
1. Go to Gateway of Tally > Display > Statutory Reports > GST > Map UoM - UQC.
2. Select the UoM that has to be mapped to its UQC, and click S: Map to UQC.
3. Select the right UQC from the predefined list.
4. Press Enter to map. Similarly, you can map each UoM to the right UQC.
The list of Unit Quantity Code provided by the department does not have the representative code for brass, carats, litres, running foot, and so on. Based on your business requirement, map the unit to the related UQC. For example, you can map litres to KLR-KILOLITRE. Before filing, change the quantity in the hsn worksheet of the template, or CSV file. Examples of mapping units to the related UQCs with the conversion factors are given below:
Unit of Measure |
Nearest UQC |
Conversion of Quantity in Template |
Litres |
KLR-KILOLITRE |
Multiply by 0.001 |
MLT-MILILITRE |
Multiply by 1000 |
|
Carat |
KGS-KILOGRAMS |
Multiply by 0.0002 |
GMS-GRAMMES |
Multiply by 0.2 |
|
Brass |
SQF-SQUARE FEET |
Multiply by 100 |
CBM-CUBIC METERS |
Multiply by 2.835 |
|
Running foot |
MTR-METERS |
Multiply by 0.3048 |
Cubic inches |
MLT-MILILITRE |
Multiply by 16.3871 |
Hanks |
YDS-YARDS |
For cotton, multiply by 840 |
For woolen, multiply by 560 |
||
Inches |
MTR-METERS |
Multiply by 0.0254 |
CMS-CENTIMETERS |
Multiply by 2.54 |
|
Pounds |
TON-TONNES |
Multiply by 0.000453592 |
KGS-KILOGRAMS |
Multiply by 0.453592 |
|
GMS-GRAMMES |
Multiply by 453.592 |
|
Lots |
TON-TONNES |
Multiply by 0.0000128 |
KGS-KILOGRAMS |
Multiply by 0.0128 |
|
GMS-GRAMMES |
Multiply by 12.8 |
|
Milligrams |
GMS-GRAMMES |
Multiply by 0.001 |
Decameter square |
SQY-SQUARE YARDS |
Multiply by 119.599 |
SQF-SQUARE FEET |
Multiply by 1076.39 |
|
Square inches |
SQM-SQUARE METERS |
Multiply by 0.00064516 |
SQY-SQUARE YARDS |
Multiply by 0.000771605 |
|
SQF-SQUARE FEET |
Multiply by 0.00694444 |
|
Tola |
GMS-GRAMMES |
Multiply by 11.6638125 |
Selecting the report UQC for an item, in case it has mulitple UQC's linked, is also made easy in Tally.ERP 9.
To select the reporting UQC for an item
1. In the Map UoM - UQC report, click U: Update RUQC.
2. Select an item and click A: Map to RUQC.
3. Select the reporting UQC (RUQC) from the list.
4. Press Enter to map the stock item to its RUQC.
The quantities of the selected stock item will be reported using the RUQC chosen in the GST returns.
F1: Detailed - Use this button to view the information in the report in the detailed mode.
F5: Show All/ Show Unmapped: Use this button to toggle between unmapped UoM or all UoMs in the report.
When you are upgrading from an earlier version of Tally.ERP 9 to Release 6.1, a message is displayed to inform you about the need to map your UoMs to the UQC. You can directly go to the Map UoM - UQC report to start mapping by pressing Enter.
