Month: February 2019

Categories
Haryana Minimum Wage Payroll

Revised Minimum wages in Haryana

The Minimum wages in Haryana has been revised with effect from 01st January’2019.The amended rates for all the categories are as below:-

Click here to download notification

HARYANA SHOPS AND ESTABLISHMENT ACT
MINIMUM WAGES W.E.F 01/01/2019
S.NO Categories of workers Basic (Rs.) Dated w.e.f 01.07.2018 minimum wages  A (Rs.) VDA w.e.f 01.01.2019              B (Rs.) Total Wages A+B (Rs.) Per day (Rs.)
             
1 Unskilled 7600 8541.64 285.76 8827.4 339.51
2 Semiskilled (A) 7980 8968.71 300.04 9268.75 356.49
  Semiskilled (B) 8379 9417.13 315.05 9732.18 374.31
3 Skilled        (A) 8797.95 9887.99 330.8 10218.79 393.03
  Skilled        (B) 9237.85 10382.4 347.34 10729.74 412.68
4 Highly Skilled 9699.74 10901.52 364.71 11266.23 433.31
5 Clerical and General Staff          
  Qualification and experience          
  (i) Below Matriculation 7980 8968.71 300.04 9268.75 356.49
  (ii) Matriculation but not Graduate 8379 9417.13 315.05 9732.18 374.31
  (iii) Graduate or above 8797.95 9887.99 330.8 10218.79 393.03
  (iv) Steno Typist 8379 9417.13 315.05 9732.18 374.31
  (v) Junior Scale Stenographer 8797.95 9887.99 330.8 10218.79 393.03
  (vi) Senior Scale Stenographer 9237.85 10382.4 347.34 10729.74 412.68
  (vii) Personal Assistant 9699.74 10901.52 364.71 11266.23 433.31
  (viii) Private Secretary 10184.73 11446.6 382.94 11829.54 454.98
6 Data Entry Operator 8797.95 9887.99 330.8 10218.79 393.03
7 Driver          
  Light Vehicle 9237.85 10382.4 347.34 10729.74 412.68
  Heavy Vehicle 9699.74 10901.52 364.71 11266.23 433.31
8 Security Guard          
  Without Weapon 7980 8968.71 300.04 9268.75 356.49
  With Weapon 9237.85 10382.4 347.34 10729.74 412.68
9 Security Inspector/Security Officer/Security Supervisor 9699.74 10901.52 364.71 11266.23 433.31
10 Safai Karamchari in any employment 8100 9103.59 304.56 9408.15 361.85

Click here to download notification

Categories
ESIC Payroll

ESIC Draft Rules to Reduce Contribution Rates

Ministry of Labour and Employment has issued Gazette Notification G.S.R 121 (E) dated 15/02/2019 notifying Draft Rules proposing to reduce Employee Contribution for ESIC to 1% from 1.75% and Employer Contribution to 4% from 4.75 %.

Currently, the employee’s ESI contribution rate is 1.75% of the wages and that of employer’s is 4.75% of the wages paid/payable in respect of the employees in every wage period.

Now, the Central Govt. is planning to lower the employee’s ESI contribution rate to 1% and that of employer’s to 4%. Draft Rules published on 15-02-2019, for information of all persons likely to be affected.

Any objection or suggestion, which may be received from any person in respect of the said draft rules within thirty days, will be considered by the Central Government. For more details please see the attached notification.

Any objection which may be received within 30 days, will be considered by the Central Government.

Click here to download notification

Categories
Excel VBA Dashboard

All Time best dashboard in Excel

Buy All Time Best Excel-VBA Dashboards from http://99excel.com/download/index.html

Download free amazing and ready to use dashboards! Free download dashboards ,
All Time Best Excel-VBA Dashboards :-

Excel Sheet Password Breaker,
Export Email from Outlook to Excel,
Get Comments to in cell text and text to comments in excel,
Move any type files in any folder as per excel data,
Save a sheet back-up automatic when you want,
Export Excel data in to HTML,
Convert any date or Time Zone to another Timezone,
Send mails from excel through outlook with separate or common attachment (s),
Bulk Email Validation In Vba Excel,
PDF Merger – Merge unlimited PDFs in one pdf file automatic,
Net in-hand automatic salary calculator in excel,
Merge excel files data in one sheet from multiple files automatic,
Set password in PDF files as per excel database separately with master password,
Rename or get all list of files from a folder and change the name as per sheet data automatic,
Excel formula to Get Numeric From alphabet Cells,
Payroll and CTC calculation as per Indian rules with all features along with payslip automatic,
Separate data from sheet in separate sheets or files,
Convertor for jpg,png data in excel or PDF,
Images file convert in PDF file,
Attendance system in Excel for local drive for unlimited users,
Language converter – translate any language excel data in English by formula,
Protect or Unprotect All Files In A Folder automatic as per sheet data,
Create PDF from word using mail merge from excel automatic,
VBA Project Password Breaker,
Export HTML data in to Excel,
Generate unlimited website pages automatic from excel

Categories
Payroll

Revised Minimum wages in Maharashtra (Special Allowances)

The Minimum wages in Maharashtra (Special Allowances) has been revised with effect from  January’2019.The amended rates for all the categories are as below:-

MAHARASHTRA SHOPS AND COMMERCIAL ESTABLISHMENTS

Minimum Wages
             

Category

Zone 1

Basic

Special Allowances w.e.f 01.07.2018

Total

Basic

Special Allowances w.e.f 01.01.2019

Total

Skilled

5800

3645

9445

5800

4104

9904

Semi-skilled

5400

3645

9045

5400

4104

9504

Un-skilled

5000

3645

8645

5000

4104

9104

Click here to download notification 1

Click here to download notification 2

Categories
kerala Minimum Wage Payroll

Revised Minimum wages in Kerala (CPI Index)

The Minimum wages in Kerala (CPI Index) has been revised with effect from November’18.The amended rates for all the categories are as below:-

KERALA Shops and Commercial Establishments

(Cochin Minimum Wages)
         

S.NO

CLASS OF EMPLOYMENT

Monthly

BASIC

DA (w.e.f Nov’18)

TOTAL

Special Grade

1

Manager

9330

2054

11384

 

 

 

 

 

Grade ‘A’

1

Head Clerk

9120

2054

11174

2

Sales Supervisor/Supervisor

3

Stenographer

4

Electrician

Grade ‘B’

1

Accountant

8910

2054

10964

2

Clerk

3

Typist

4

Cashier

5

Booking Clerk

6

Bill Collector

7

Salesman/Sales women

Grade C

1

Shop Assistant

8700

2054

10754

Grade D

1

Attender

8490

2054

10544

2

Peon

3

Watchman

Grade E

1

Office Assistant/Sales Assistant(Commercial Establishment)

8280

2054

10334

2

Sweeper

 

Click here to download notification 1

click here to download notification 2

    Categories
    Payroll

    Revised Minimum wages in West Bengal

    The Minimum wages in West Bengal has been revised with effect from  January’2019.The amended rates for all the categories are as below:-

    WEST BENGAL SHOPS & ESTABLISHMENT

    		  

    Minimum Wages Rates

    		  
                 

    S.No

    Categories

    MONTHLY MINIMUM WAGES RATES w.e.f 01.07.2018 to 31.12.2018

    MONTHLY MINIMUM WAGES RATES w.e.f 01.01.2019 to 30.06.2019

    		  

    ZONE A

    ZONE B

    ZONE A

    ZONE B

    		  
     

    1

    Unskilled

    7775.00

    7202.00

    8005.00

    7245.00

    		  

    2

    Semi Skilled

    8554.00

    7920.00

    8806.00

    7968.00

    		  

    3

    Skilled

    9409.00

    8713.00

    9687.00

    8765.00

    		  

    4

    Highly skilled

    10349.00

    9586.00

    10655.00

    9643.00

    		  

    Categories
    monthly Compliance Calendar

    Compliance Calendar February 2019

    Statutory compliances dues date calendar issued by Payrollpedia for February 2019. Below are list of last dates Act wise:

    FEBRUARY
    Date (by when) Applicable Act Form Details of Compliance
    01st FEB MINIMUM WAGE ACT Form III Annual return ending 31st Dec
    01st FEB PAYMENT OF WAGE ACT Form VIII Annual return ending 31st Dec
    01st FEB MATERNITY BENEFIT L,M,N,O Annual return ending 31st Dec
    01st FEB EMPLOYEE COMPENSATION ACT   Annual return ending 31st Dec
    07th FEB Tax Deposit Challan Monthly deposit
    15th FEB CONTRACT LABOUR (R & A) ACT Form XXV Annual return ending 31st Dec
    15th FEB ESIC Challan Monthly deposit 
    15th FEB PROVIDENT FUNDS Challan Monthly deposit
    28thFEB S& E ANNUAL RETURN IN MAHARSHTRA Form R Yearly Return ending 31st Dec
    Labour welfare fund
    State  Contribution period (month) Last Day for submission
    Haryana Monthly 28-Feb
     Professional Tax
    KARNATAKA (BANGALORE) [Monthly] 20-Feb
    ANDHRA PRADESH (HYDERABAD) [Monthly] 10-Feb
    WEST BENGAL (KOLKATA) [Monthly] 21-Feb
    MAHARASHTRA  (MUMBAI) [Monthly] 28-Feb
    GUJARAT (AHMEDABAD)   [Monthly] 15-Feb
    ORISSA  (Monthly) 28-Feb
    MADHYA  PRADESH  (INDORE) (Monthly Salary) 10-Feb
    GUWAHATI (ASSAM) (Monthly) 28-Feb