Categories
Provident Fund (PF)

how to generate PF ECR text file automatic from excel – vba code

Hey!

Below Excel VBA code with ready made process to generate and check monthly PF provident fund ECR (Electronic Challan Report) automatic from Excel in 1 click.

How to use generate ECR text file from Excel: – Steps

  1. Follow the ECR Format as downloaded from Unified portal (PF Website)
  2. Fill the all columns e.g. wage, contribution and days etc
  3. Copy below given code and paste it in your VBA Module 1 a Explain in video
  4. change the very first loop counts in you wish you change
  5. Press F5 or run this code to generate ECR text file.
  6. That’s All.
Sub ECR_Creator_code()
'this code made by Ajit Sir
'Follow on www.99Excel.com
'Follow on payrollpedia.org
Application.ScreenUpdating = True
Dim fso As Object, oFile As Object, FilePath, i, c, Livevalue, FolderPath, FileName, e As Long
FolderPath = "C:\Examples"
FileName = "PFECR_" & UCase(Format(Now(), "DD_MMMM_YYYY")) & ".txt"
Set fso = CreateObject("Scripting.FileSystemObject")
If Not fso.FolderExists(FolderPath) Then fso.CreateFolder FolderPath
Set oFile = fso.CreateTextFile(FolderPath & "\" & FileName)


For i = 2 To (Application.WorksheetFunction.CountA(Range("A2:A60000")) + 1)
    For c = 3 To 8
    Cells(i, c).Select
        If Cells(i, c).Value < 0 Then
        Cells(i, c).Interior.Color = 255
        e = e + 1
        Else
        Cells(i, c).Interior.Pattern = xlNone
        End If
    Next c
Next i


If e = 0 Then

For i = 2 To (Application.WorksheetFunction.CountA(Range("A2:A60000")) + 1)
    For c = 1 To 11
        If c = 1 Then
        Livevalue = Cells(i, c).Value & "#~#"
        Else
        Livevalue = Livevalue & Cells(i, c).Value & "#~#"
        End If
        
        If Cells(i, c).Value < 0 Then
        Range("E3").Interior.Color = 255
        Else: End If
    Next c
oFile.WriteLine Livevalue
Cells(i, 1).Select
Next i



oFile.Close
Set fso = Nothing
Set oFile = Nothing
Application.ScreenUpdating = False
MsgBox " ECR Saved in C:\Examples"
Else
MsgBox "error in ECR"
End If
End Sub

Categories
Payroll Provident Fund (PF)

PROVIDENT FUND RULE’S FOR INTERNATIONAL WORKER’S

DEFINITION AND COVERAGE OF INTERNATIONAL WORKER UNDER PROVIDENT FUND

An International Worker (IW) is any employee who is a foreign national working in India under an employer registered with the EPFO or an Indian employee who is working in a foreign country with which India has a Social Security Agreement (SSA).  Every foreign worker employed with an establishment to whom the EPF applies must become a member of the provident fund (PF) from the first date of his/her employment. There is no minimum period of stay in India for activation of PF compliance. Hence, in relation to individuals working in India in establishments to which the EPF Act applies, an employee other than an Indian employee, holding other than an Indian passport, can be treated as an International Worker. One would also need to examine whether such an individual comes from a country with which India has signed a SSA, and if so, whether contributions need to be made in India or in the home country of this individual, based on the terms of the SSA.

If an employee is classified as an International Worker and provident fund contributions are payable in India (either because India does not have an SSA with the country from which such individual comes, or because the SSA benefits are not triggered based on various factors), the Indian employer will be required to make contributions under the EPF Act on the entire global income of such individuals (without any upper limit).

PF CONTRIBUTION RATE FOR INTERNATIONAL WORKERS

The PF contribution rate for foreign workers registered with EPF (or IWs) is 12 percent. The PF rate is calculated on full salary of the IW irrespective of whether the salary is remunerated in India or outside India, split payroll, or multiple country sources.

The major difference between regular Indian workers, and IWs, is that for Indian employees, companies are entitled to limit their provident fund contribution to 12% of INR 15,000 (i.e. INR 1,800 per month)(the upper limit), even if the ‘monthly pay’ (defined to mean basic wages, dearness allowance and retaining allowance) of the employee exceeds INR 15,000.  In case of IW’s there is no upper limit.

Therefore, in the event of any alleged non-compliance with the obligation to make PF contributions for IWs, organizations can face significantly greater liability to make hefty payment on pending contributions (along with interest and penalties).

Exemptions

IWs are exempt from contribution towards PF only if their home country has a social security agreement (SSA) or economic-bi-lateral treaty with India

ELIGIBLE SERVICE FOR INTERNATIONAL WORKERS UNDER THE EMPLOYEES’ PENSION SCHEME, 1952

By a notification dated 05 October 2012, the Ministry of Labour of Employment has introduced sub-paragraph 4A to paragraph 43-A of the Employees’ Pension Scheme, 1952 (EPS) which deals specifically with international workers. Under the EPS, an employee is eligible for pension upon his retirement, if the employee has rendered the minimum eligible service of 10 years.

By virtue of this notification, the Ministry has clarified that in respect of an international worker from a country with which India has executed an SSA, eligibility for pension is determined on the total number of years of service rendered by the international worker under the social security programme of his home country and the number of years of service rendered in India in an establishment covered under the EPS. For example, if an employee has been employed in his home country for a period of 20 years and in India for a period of 7 years, the employee’s eligible service in India would be considered as 27 years and he would be eligible for pension.

However, it is relevant to note that the calculation of pension is made only on the number of years during which contributions were made under the Employees Provident Fund and Miscellaneous Provisions Act, 1952 (EPF Act). In the example above, the international worker’s pension would be calculated on the 7 years during which contributions were made on his behalf under the EPF Act.

WITHDRAWAL RULES UNDER EPF

An international worker may withdraw the accumulated balance in the EPF account in one of the following situations:

1. at the time of retirements, that is, on or after 58 years of age.

2. in case of retirement due to permanent and total mental or physical incapacity to work.

3. in case of serious illness such as cancer, leprosy, or tuberculosis; or,

4. on completion of Indian employment, if the IW’s home country has an SSA with India.

The facility to receive PF refund on the date of completion of Indian employment is not available for IWs who are not covered under SSA.

WITHDRAWAL OF FUNDS UNDER EPS

The EPS regulations do not recognize the employer’s contribution to the pension scheme. Since only employer’s contributions are allocated to the EPF, the EPS does not entitle IWs to pension benefits when they leave India, regardless of accrued employer contributions.

The pension withdrawal is only available to employees who are covered under an SSA that has come to effect, and to employees who have not completed the eligible service of 10 years even after including the totalization of service under the respective SSAs.

Categories
80C Deductions 80DDB Excel VBA Dashboard Gratuity House Rent Allowance (HRA) Human Resource (HR) India Payroll Payroll Provident Fund (PF)

Income tax calculation sheet for the financial year 2019-20 [AY 2020-21] Automated Salary Tax Calculator along 15+ other Features

Click here to download automatic Complete Payroll Calculator in Excel. This Excel Software have includes most likely all part of Payroll Calculation. It’s Includes following Feature:-

  • You can calculate Cost to company CTC Automatic once you put total ctc.
  • You can restructuring of allowances and CTC components as per your need.
  • Income Tax  to be calculate automatic.
  • You can set your investment Declaration / Proofs Planing as per requirement.
  • This sheet will calculate House rent allowance ( HRA Rent Exemption calculation) under section 10(13A) automatic as per your rent paid and selected location.
  • You can customize your structure like add / less : PF (Employees’ Provident Fund), Employment State Insurance ( ESIC), Gratuity, Mediclaim, any other benefit, Bonus, Minwages.
  • You can control to deduct PF on Basic OR PF on Allowances or PF on min wages of PF or you can select No if you are not eligible for pf deduction.
  • You can Se-off loss / income from house property u/s 24(b) as per Income Tax Act.
  • You can add reimbursement components as per bills planing to get more benefit in tax.
  • This sheet will give you Net payment Automatically as per your change.
  • Best part of this software is that, you can generate  your salary pay slip from CTC in one click and change payslip in excel as per needs.
  • We have added logo on slip so that you can change it.
  • You can generate any month salary slip from excel format in one click even you can generate full and final slip.
  • Free download
  • Paid Support Available at :
  • Email: ajityadav121@gmail.com
  • Call/WhatsApp: +91 9654421288

Click here to Download Automated Excel Sheet to calculate cost to company (CTC), Income Tax Calculation for financial year 2019-20 along with all investment planning (Deduction U/C VI-A)  and all Major Exemptions allowed + reimbursement  in Salary.

This sheet will allowed to planning your tax saving, make salary structure as per your choice and know the Net in hand Automatically.

Thanks!

Categories
Provident Fund (PF)

PF (Provident Fund) on Special Allowances

The Supreme Court has held that special allowances paid by an employer to its employees have to be included in “basic wage” for deduction towards provident fund. Now All Allowances (Not HRA) will be part of PF wages.


However If  Basic Wages and other allowances collectively are more than 15,000/- per month than the employer has an option to limit wages for provident fund contribution to INR 15,000/- per month

This video about to how to calculation of PF on allowances and what amount come to as extra cost on employer side and net pay reduce for employee.

Regards – Team Payroll Pedia

Categories
Provident Fund (PF)

PF Admin Charges reduced and EDLI Admin Charges waived by EPFO

PF Admin charges have been further reduced to 0.5% applicable w.e.f. 1 June 2018, subject to a minimum of Rs. 500/ Rs. 75 in the case of functional/ non-functional organisations. Besides, EDLI Admin charges have already been waived w.e.f. 1 Apr. 2017.

 

PF Admin Charges reduced to 0.5% w.e.f. 1 June 2018

Click here to Download Notification.

In exercise of the powers conferred by the Explanation to paragraph 30 read with paragraph 39 of the Employees’ Provident Funds Scheme, 1952, and in supersession of the notification of the Government of India in the Ministry of Labour and Employment published in the Gazette of India, Extraordinary, Part II, section 3, sub-section (ii) vide number S.O. 827(E), dated the 15th March, 2017, except as respects things done or omitted to be done before such supersession, the Central Government, after consulting the Central Board and having regard to the resources of the Employees’ Provident Fund available for meeting its normal administrative expenses, hereby fixes the administrative charges payable by the employer for the purposes of paragraph 30 and sub-paragraph (1) of paragraph 38 of the said Scheme with effect from 1st June, 2018 at 0.50 per cent (zero point five zero per cent.) of the pay as referred to in the said paragraphs subject to a minimum sum of seventy-five rupees per month for every non-functional establishment having no contributory member and five hundred rupees per month per establishment for other establishments.

2. For the removal of doubts, it is hereby notified that nothing contained in this notification shall affect the administrative charges payable in respect of the period up to and inclusive of the 31st May, 2018 in respect of which the notification referred to in paragraph 1 herein shall continue to apply as if the same had not been superseded.

[amazon_link asins=’B075W6PSP1′ template=’ProductCarousel’ store=’akumar0a5-21′ marketplace=’IN’ link_id=’588b3263-746b-11e8-8932-a52442a21ae1′]

 

Categories
Provident Fund (PF)

Online Correction of Name/Date of Birth/Gender in Provident Fund Record

Dear All

 

We would like to bring your attention to Circular number NDC/2017/UAN/Pt./2741 dated 21st November 2017 (as attached) wherein EPFO has provided an Online facility for correction in the Member record w.r.t Name/Date of Birth and Gender as per Aadhar records. Earlier for all these correction employee and employer has to fill up Joint declaration manually

 

As per the new procedure a Member has to follow the following steps

 

  1. Login into Member UAN Portal through his UAN and Password (https://unifiedportal-mem.epfindia.gov.in/memberinterface/)
  2. Click on Manage>Modify Basis Details
  3. Provide all three details as being provided in Aadhar Card w.r.t Name/Date of Birth and Gender and the select employer from drop down you wish to approve the details
  4. Click Update details
  5. Request will be submitted to the employer for approvals
  6. Once approved by the employer than same shall be approved by Office of EPFO

 

Please note that System will verify the details entered with UIDAI-Aadhar Data so please ensure that correct information as per Aadhar Card is being feeded in the system

Categories
Provident Fund (PF)

UMANG Mobile App for Employee by Gov. of India

Hi All Employee,

 

We would like to bring to your kind attention that Mobile Application UMANG (Unified Mobile Application for New-age Governance)  has been launched by Government of India.

 

It is developed by Ministry of Electronics and Information Technology (MeitY) and National e-Governance Division (NeGD) to drive Mobile Governance in India

UMANG provides a single platform for all Indian Citizens to access pan India e-Gov services ranging from Central to Local Government bodies and other citizen centric services.

 

UMANG provides seamless integration with popular customer centric services like Aadhaar and Digilocker.

UMANG intends to provide major services offered by Central and State Government departments, Local bodies and other utility services from private organizations. It provides a unified approach where citizens can install one application to avail multiple government services.

UMANG service has been made available on multiple channels like mobile application, web, IVR and SMS which can be accessed through smartphones, feature phones, tablets and desktops. UMANG  has been created with a thought to add convenience to your lifestyle. UMANG will revolutionize the way how an Indian citizen avails government services today, because it leverages the current accelerated internet and smartphone penetration in our country.

 

UMANG app is available for download on Google Play (Andriod), App Store (IOS), Window Store (Windows)

 

EPFO mobile application, service offered Employees Provident Fund Organization is also available in UMANG.

 

Presently Employee can avail the following services through app available in UMANG. More and more services will be added to the application

 

Precondition to avail this facility is registration of UAN at EPFO Portal and linking of Mobile number to UAN to get the OTP

 

  1. View Passbook.
  2. Raise Claim for withdrawal of Pension, PF Settlement, PF part (Loan) withdrawal. (Facility can be availed subject to KYC is complete for employee which is linking of Aadhar, PAN and updated Bank details. Certain other conditions, as being stipulated while employee start doing a transaction, subject to nature of transaction being initiated.
  3. Track Claim filed through UMANG App

 

We may please request all stakeholders to disseminate this information to all employees in the organization enabling them to use this facility and get some of real time information

 

Below is the link provide to access UMANG

 

https://web.umang.gov.in/web/#/

Categories
80C Deductions ESIC Excel Formulas & VBA Code Gratuity House Rent Allowance (HRA) Human Resource (HR) India Payroll LTA Others Payroll Provident Fund (PF) Salary Tax Return (ITR)

List of acts applicable in india

Type _Act Act_Name
BankingLaw
Actuaries Act 2006
Bankers Book Evidence Act, 1891
The African Development bank Act, 1983
The Banking Regulation Act, 1949
The Banking Regulation (Amendment) and Miscellaneous Provisions Act, 2004
The Export-Import Bank of India Act, 1981
The Industrial Disputes (Banking and Insurance Companies) Act, 1949
The Industrial Disputes (Banking Companies) Decision Act, 1955
The State Bank of Sikkim (Acquisition of Shares) and Miscellaneous Provisions Act, 1982
The State Bank of Saurashtra (Repeal) and The State Bank of India (Subsidiary Banks) Amendment Act, 2009
The State Bank of India Act, 1955
State Bank of India (Subsidiary Banks Laws) Amendment Act, 2007
State Bank of India (Amendment) Act, 2010
State Bank of India (Amendment) Act, 2007
The Small Industries Development Bank of India Act, 1989
The State Bank of Hyderabad Act, 1956
The Unit Trust of India Act 1963
 Reserve Bank of India Act, 1934
 Reserve Bank of India (Amendment) Act, 2006
 The Regional Rural Banks Act, 1976
 The Recovery of Debts Due To Banks and Financial Institutions Act, 1993
Corporate Law
Companies (Foreign Interests) Act, 1918
Company Law Board Regulations, 1991
THE Companies (Amendment) Act, 2006
The Company Act, 1956
The Company Secretaries Act, 1980
The Companies (Donations To National Funds) Act, 1951
The Depositories Act, 1996
The Foreign Trade (Development and Regulation) Act, 1992
The Hire-Purchase Act, 1972
Indian Contract Act, 1872
The National Securities And Depositories Limited – ByeLaws, 1996
The Prevention of Money-Laundering Bill, 1999
Prevention of Money Laundering Act, 2002
Prevention of Money-Laundering (Amendment) Act, 2005
The Partnership Act, 1932
The Securities Contract (Regulation) Act, 1956
The Sick Industrial Companies Act, 1985
The Sale of Goods Act, 1930
 The Swadeshi Cotton Mills Company Limited (Acquisition and Transfer of Undertakings) Act, 1986
The Tea Act, 1953
The State Financial Corporation Act, 1951
The State Financial Corporations (Amendment) Act, 2000
Special Economic Zones Act, 2005
 The Tea Companies (Acquisition and Transfer of Sick Tea Units) Act, 1985
Tyre-Corporation-of-India-Limited-(Disinvestment-of-Ownership)-Act-2007
The Securities and Exchange Board of India Act, 1992
Securities and Insurance Laws (Amendment and Validation) Act, 2010
Securities and Insurance Laws (Amendment and Validation) Ordinance, 2010
The Securities Contracts (Regulation) Act, 1956
Securities Contracts (Regulation) Amendment Act, 2007
Securities Laws (Amendment) Act, 2004
Securitisation and Reconstruction of Financial Assets and Enforcement of Security Interest Act, 2002
The Rubber Act, 1947
The Faridabad Development Corporation Act,1956
The Rubber Amendment Act, 2009
Criminal and Motor Accident Laws
Indian Penal Code, 1860
Motor Vehicles Act, 1988
Motor Vehicles (AMENDMENT) Act 2000
Personal Injuries (Emergency Provisions) Act, 1962
 Prevention of Corruption Act, 1988
Prevention of Terrorism Act 2002
The Central Motor Vehicles Rules, 1989
The Code of Criminal Procedure, 1973
The Criminal Law Amendment Act, 1938
The Criminal Law Amendment Act, 1961
The Criminal Law Amendment Act, 1993
The Criminal Law Amendment Act, 1990
The Fatal Accidents Act, 1855
The Juvenile Justice Act, 1986
The Juvenile Justice (Care and Protection of Children) Act, 2000
The Negotiable Instruments Act, 1881
The Smugglers and Foreign Exchange Manipulators (Forfeiture of Property) Act, 1976
The Terrorist Affected Areas (Special Courts) Act 1984
The Terrorist and Disruptive Activities (Prevention) Act, 1987
The Unlawful Activities (Prevention) Amendment Act 2004
The Unlawful Activities (Prevention) Amendment Act 2008
The Unlawful Activities (Prevention) Act 1967
The Prisoners (Attendance in Courts) Act, 1955
The Prevention of Seditious Meetings Act, 1911
The Prisoners Act, 1900
The Prize Chits and Money Circulation Schemes (Banning) Act, 1978
The Probation of Offenders Act, 1958
Consumer Laws
The Competition Act, 2002
The Consumer Protection Act, 1986
The Essential Commodities Act, 1955
Jammu & Kashmir Consumer Protection Act 1987
The Prevention of Black Marketing and Maintenance of Supplies of Essential Commodities Act, 1980
Direct Tax Law
The Expenditure Tax Act, 1987
The Gift Tax Act, 1958( Abolished )
The Income Tax Act, 1961
The Interest Tax Act, 1974
The Taxation Laws (Amendment) Act, 2006
The Taxation Laws (Amendment) Act, 2005
The Wealth Tax Act, 1957
Education / Science and Technology
The All India Institute Of Medical Science Act 1956
The All India Council For Technical Education 1987
The University Grants Commession Act 1956
Tripura University Act 2006
The Sree Chitra Tirunal Institute for Medical Sciences and Technology, Trivandrum, Act, 1980
The Sikkim University Act, 2006
Rajiv Gandhi University Act, 2006
Rajiv Gandhi Institute of Petroleum Technology Act, 2007
The Rampur Raza Library Act, 1975
South Asian University Act, 2008
Sree Chitra Tirunal Institute for Medical Sciences and Technology, Trivandrum (Amendment) Act, 2005
The Technology Development Board Act, 1995
Science and Engineering Research Board Act, 2008
The Semiconductor Integrated Circuits Layout Design Act, 2000
The Tezpur University Act 1993
The Visva Bharati Act 1951
The Vaccination (Repeal)Act 2001
The Vaccination Act 1880
University of Allahabad Act 2005
University of Hyderabd Act 1974
Environment Law
 Air Crafts (Amendment) Act, 2007
 Air (Prevention and Control of Pollution) Act,1981
The Air Corporation (Transfer of Undertaking and Repeal) Act, 1994
The Delhi Prohibition of Smoking and Non-Smokers Health Protection Act, 1996
The Environment (Protection) Act, 1986
The Forest Conservation Act, 1980
The water (Prevention and Control of Pollution) Act, 1974
Wild Life (Protection) Amendment Act, 2006
Protection of Plant Varieties and Farmers Rights Act, 2001
Family Law
Protection of Women from Domestic Violence Act, 2005.
The Dowry Prohibition Act, 1961
The Family Courts Act,1984
The Foreign Marriage Act, 1969
The Guardians And Wards Act, 1890
The Hindu Marriage Act, 1955
The Hindu Minority and Gaurdianship Act, 1956
The Indian Divorce Act, 1869
The Maternity Benefits Act, 1961
The Muslim Personal Law (Shariat) Application Act, 1937
The Muslim Women (Protection of Rights on Divorce) Act, 1986
The Dissolution of Muslim Marriages Act, 1939
The Special Marriage Act, 1954
The Hindu Succession Act, 1956
The Hindu Adoptions and Maintenance Act, 1956
Indian and Colonial Divorce Jurisdiction Act, 1940
The Anand Marriage Act, 1909
The Arya Marriage Validation Act, 1937
Matrimonial Causes (War Marriages) Act, 1948
The Child Marriage Restraint Act, 1929
Administrators-General Act, 1963
Foreign Exchange Law
The Conservation of Foreign Exchange and Prevention of Smuggling Activities Act, 1974
The Foreign Exchange Maintenance Act, 1999
The Smugglers and Foreign Exchange Manipulators (Forfeiture of Property) Act, 1976
The Foreign Trade (Development and Regulation) Act, 1992
Indirect Tax Law
Additional Emoluments (Compulsory Deposit) Act, 1974
Central Sales Tax, 1956
Customs Act, 1962
Delhi Sales Tax, 1975
 Rajasthan Sales Tax Act, 1994
Service Tax : Statutory Provisions (1994)
The Additional Duties Of Excise (Textiles And Textile Articles) Act, 1978
The Central Excise Act,1944
The Medicinal And Toilet Preparation (Excise Duties) Act, 1955
The Tripura Land Revenue and Land Reforms Act, 1960
 Treasure Trove Act 1878
 The Seamen’s Provident Fund Act, 1966
 The Sales-Tax Laws Validation Act, 1956
Intellectual Property Law
The Copyright Act, 1957
The Trade Marks Act, 1999
Trade Marks (Amendment) Act, 2010
The Trade and Merchandise Marks Act, 1958
The Designs Act, 2000
The Designs Rules, 2001
The Designs (Amendment) Rules, 2008
The Geographical Indications of Goods (Registration and Protection) Act, 1999
IT Laws
Information Technology Act, 2000
Legal and Professional Law
Abolition of Privy Council Jurisdiction Act, 1949
Apprentices Act, 1961
The Acting Judges Act, 1867
The Advocates Act, 1961 TIPS for Lawyers on Advocates Act, 1961
The Advocates Welfare Fund Act , 2001
The Architects Act, 1972
The Company Secretaries Act, 1980
The Contempt of Courts Act, 1971
The Calcutta High Court (Jurisdictional Limits) Act, 1919
The Calcutta High Court (Extension Of Jurisdiction) Act, 1953
The Central Laws (Extension To Jammu And Kashmir) Act, 1968
The Central Laws (Extension To Arunachal Pradesh) Act, 1993
The Continuance Of Legal Proceedings Act, 1948
The Notaries Act, 1952
 Special Tribunals (Supplementary Provisions) Repeal Act, 2004
The Special Court (Trial of Offences Relating to Transactions Insecurities) Act, 1992
Tamil Nadu Legislative Council Act, 2010
Supreme Court Judges (Salaries and Conditions of Service) Act, 1958
Private Security Agencies (Regulation) Act, 2005
Media Laws
The Cable Television Networks(Regulation) Ordinance Act, 1995
The Cinematograph Act, 1952
Press Council Act, 1978
The Press and Registration of Books Act, 1867
Medical and Health
The Transplantation of Human Organ Act 1994
The Prevention Of Food Adulteration (Extension To Kohima And Mokokchung Districts) Act 1972
 The Prevention of Food Adulteration Act, 1954
Miscellanous Law
Arbitration and Conciliation Act, 1996
 Agricultural and Processed Food Products Export CESS Act, 1986
 Coffee Act
Citizenship Act, 1955
Charitable and Religious Trusts Act, 1920
 Charitable Endowments Act, 1890
Constitution of India
Collection of Statistics Act 1953
Coir Board Services (Classsification Control and Appeal ) Bye Laws 1969
Coir Board Services Bye Laws 1983
Coir Board General Provident Fund Bye Laws 1977
Coir Industry Act 1953
Coinage Act 1906
Coking Coal Mines (Nationalisation) Act 1972
The Indian Evidence Act, 1872
 The Antiquities and Art Treasures Act, 1972
The Arms Act, 1959
 The Cantonments Act, 2006
 The Carriage by Road Act, 2007
The Central Boards Of Revenue Act, 1963
 The Cencus Act, 1948
 The Central Road Fund Act, 2000
The Commissions of Inquiry Act, 1952
The Commanders In Chief Change in Designation Act 1955
The Court Fees Act, 1870
The Indian Trusts Act, 1882
The Delhi Co-operative Society Act, 1972
The Drugs and Cosmetics Act, 1940
The Explosives Act, 1884
The Export (Quality Control and Inspection) Act, 1963
The Extradition Act,1962
The General Clauses Act, 1897
The Government of National Capital Territory of Delhi Act, 1991
The Immoral Traffic Prevention Act – 1956
The Limitation Act, 1963
The Life Insurance Corporation Act, 1956
The Narcotic Drugs and PSYCHOTROPIC Substances Act 1985
The Narcotic Drugs and PSYCHOTROPIC Substances Act – Amendment 2001
The Suppression of Unlawful Acts Against Safety of Maritime Navigation and Fixed Platforms on Continental Shelf Act, 2002
 Sugarcane Cess (Validation) Repeal Act, 2001
Sugarcane Control (Additional Poweres) Repeal Act, 2000
The Sugarcane Control (Additional Powers) Act, 1962
The Sugar-Cane Act, 1934
The States Reorganisation Act, 1956
The State of Nagaland Act 1962
The State of Arunachal Pradesh Act, 1986
The State of Mizoram Act, 1986
The State of Himachal Pradesh Act, 1970
The Territorial Army Act, 1948
 The Telecom Regulatory Authority of India Act, 1997
 The State Agricultural Credit Corporations Act, 1968
 The Standards of Weights and Measures (Enforcement) Act, 1985
 The Stage-Carriages Act, 1861
 The St. John Ambulance Association (India) Transfer of Funds Act, 1956
 Sports Broadcasting Signals (Mandatory Sharing with Prasar Bharati) Act, 2007
 The Spirituous Preparations (Inter-State Trade and Commerce) Control Act, 1955
 Spirituous Preparations (Inter-State Trade and Commerce) Control (Repeal) Act, 2006
 The Spices Board Act, 1986
 The Specific Relief Act, 1963
 The Special Protection Group Act, 1988
 The Smith, Stanistreet and Company Limited (Acquisition and Transfer of Undertakings) Act, 1977
 The Shipping Development Fund Committee (Abolition) Act, 1986
 The Seeds Act, 1966
 The Scheduled Castes and The Scheduled Tribes (Prevention of Atrocities) Act, 1989
 Sashastra Seema Bal Act, 2007
 The Sarais Act, 1867
 State Emblem of India (Prohibition of Improper Use) Act, 2005
The Suits Valuation Act, 1887
The Societies Registration Act, 1860
Two Member Constituencies (Abolition)and Other Laws Repeal Act 2001
The Tobacco Board Act, 1975
The Textiles Committee Act, 1963
The Terrorist and Disruptive Activities (Prevention) Act, 1987
The Textile Undertakings (Taking Over of Management) Act, 1983
The Textile Undertakings (Nationalisation) Act, 1995
 U.P Sugarcane Cess (Validation) Repeal Act 2001
The Richardson and Cruddas Limited (Acquisition and Transfer of Undertaking) Act, 1972
 The Indian Rifles Act, 1920
 The Salar Jung Museum Act, 1961
 The Reformatory Schools Act, 1897
The Registration of Births and Deaths Act, 1969
 The Rehabilitation Council of India Act, 1992
 The Rehabilitation Finance Administration Act, 1948
 The Religious Endowments Act, 1863
 The Repatriation of Prisoners Act, 2003
 Repealing and Amending Act, 2001
The Rajghat Samadhi Act, 1951
The Raipur and Khattra Laws Act, 1879
The Partition Act, 1893
The Provincial Small Cause Courts Act, 1887
The Provisions of the Panchayats Extention to the Scheduled Areas) Act, 1996
The Provincial Insolvency Act, 1920
Prevention of Illicit Traffic in Narcotic Drugs and Psychotropic Substances Act, 1988
The Prevention of Cruelty to Animals Act, 1960
Produce Cess Laws (Abolition) Act, 2006
The Prize Competitions Act, 1955
The Prevention of Insults to National Honour Act, 1971
Prevention of Insults to National Honour (Amendment) Act, 2005
The Transformer and Switchgear Limited (Acquisition and Transfer of Undertakings) Act, 1983
The Transfer of Evacuee Deposits Act, 1954
The Acquired Territories (Merger) Act, 1960
The Foreign Trade (Development and Regulation) Act, 1992
 The Registration Act, 1908
Civil Procedure Code (CPC) 1908
Right to Information Act 2005 (RTI Act)
The Prison Act, 1894
The Agriculturists Loans Act, 1884
Agricultural Produce (Grading and Marking) Act, 1937
Administrators – General Act, 1963
The Indian Medicine Central Council Act, 1970
The Indian Succession Act, 1925
The Patents Act, 1970
The Patents Rules 2003
The River Boards Act, 1956
The Standards of Weights and Measures Act, 1976
The Presidency Small Cause Courts Act, 1882
NRI Related Laws
The Emigration Act, 1983
The Foreign Marriage Act, 1969
The Foreign Exchange Management Act, 1999
Political and Election Laws
The Presidential and Vice-Presidential Elections Act, 1952
Presidents Emoluments and Pension (Amendment) Act, 2008
The President (Discharge Of Functions) Act, 1969
The Representation of the People Act, 1951
The Representation of the People Act, 1950
Representation of the People (Amendment) Act, 2010
Representation of the People (Amendment) Act, 2009
Representation of the People (Amendment) Act, 2008
The Commissions of Inquiry Act, 1952
Property Law
Assam (Alteration Of Boundaries) Act, 1951
Assam Alienation Of Land (Regulation) Act, 1980
Assam State Legislature (Delegation Of Powers) Act, 1980
Assam State Legislature (Delegation Of Powers) Act, 1981
 The Administration of Evacuee Property (Central) Rules,1950
The Administration of Evacuee Property Act,1950
 The Benami Transactions(Prohibitions) Act, 1988
The Delhi (Delegation Of Powers) Act, 1964
The Delhi Development Authority (Validation Of Disciplinary Powers) Act, 1998
The Delhi Lands (Restrictions On Transfer) Act, 1972
The Delhi Laws Act, 1912
The Delhi Laws Act, 1915
The Delhi Municipal Corporation (Validation Of Electricity Tax) Act, 1966
The Delhi Apartment Ownership Act, 1986
The Delhi Land Reforms Act, 1954
The Delhi Land (Restrictions on Transfer) Act, 1972
The Delhi Land Revenue Act, 1954
The Delhi Rent Act, 1995
The Delhi Rent Control Act, 1958
The Hindu Disposition of Property Act, 1916
 Administrators-General Act, 1963
The Public Premises (Eviction of Unauthorised Occupants) Act, 1971
 Land Acquisition Act, 1894
Transfer of Property Act 1882
The Slum Areas (Improvement and Clearance) Act, 1956
The Territorial Waters, Continental Shelf, Exclusive Economic Zone and Other Maritime Zones Act, 1976
The Waste Lands (Claims) Act, 1863
The Uttar Pradesh Reorganization Act, 2000
The Uttar Pradesh cantonments (Control of Rent and Eviction)(Repeal)Act, 1971
The Urban land (Ceiling and regulation Act, 1999)
 The Requisitioned Land (Apportionment of Compensation) Act, 1949
 The Prevention of Damage to Public P roperty Act, 1984
The Presidency-Towns Insolvency Act, 1909
The Requisitioning and Acquisition of Immovable Property Act, 1952
The Requisitioning and Acquisition of Immovable Property Rules, 1953
Public Related Laws
The Public Wakfs (Extension of Limitation) Act, 1959
The Public Suits Validation Act, 1932
The Public Sector Iron and Steel Companies (Restructuring) and Miscellaneous Provisions Act, 1978
The Public Records Act, 1993
The Public Provident Fund Act, 1968
The Public Liability Insurance Act, 1991
The Public Gambling Act, 1867
The Public Financial Institutions (Obligation as To Fidelity and Secrecy) Act, 1983
The Public Employment (Requirement as To Residence) Act, 1957
Public Debt Act, 1944
The Public Accountants Default Act, 1850
Punjab State Laws
The Punjab Disturbed Areas Act, 1983
The Punjab Gram Panchayat, Samities and Zilla Parishad (Chandigarh Repeal) Act, 1994
The Punjab Legislative Council (Abolition) Act, 1969
The Punjab Pre-Emption (Chandigarh and Delhi Repeal) Act, 1989
The Punjab State Legislature (Delegation of Powers) Act, 1987
The Punjab Village Common Lands Regulation Act 1961
The Land Acquisition (East Punjab Amendment) Act, 1948
The Land Acquisition (Punjab Amendment) Act, 1953
The Land Acquisition Punjab Second Amendment Act, 1956
The Land Acquisition (Punjab Amendment) Act, 1962
The Land Acquisition (Punjab Amendment) Act, 1969
Punjab Colonization of Government Lands (Punjab) Act 1912
Punjab Reclamation of Land Act 1959
The Redemption of Mortgages (Punjab) Act, 1913
The Punjab Religious Premises and Land (Eviction and Rent Recovery) Act, 1997
The Punjab Resumption of Jagirs Act, 1957
The Punjab Restitution of Mortgaged Lands Act, 1938
The Punjab Land Improvement Schemes Act, 1963
The Punjab Land Reforms Act, 1972
Punjab Minor Canals Act, 1905
The Punjab Occupancy Tenants (Vesting of Proprietary rights) Act, 1952
The Punjab Public Premises and Land (Eviction and Rent Recovery) Act, 1973
The Punjab Revenue Appeals and Proceedings (Disposal and Restoration) Act 1956
 Punjab Utilization of Lands Act, 1949
The East Punjab War Awards Act, 1948
The Punjab Package Deal Properties (Disposal) Amendment Act, 2009
The Punjab Regulation of Accounts Act, 1930
The Armed Forces (Punjab and Chandigarh) Special Powers Act, 1983
The Punjab Cinemas (Regulation) Act, 1952
The East Punjab Control of Bricks Supplies Act, 1949
The Punjab Ice Price Control Act, 1968
 The Displaced Persons (Compensation and Rehabilitation) Act, 1954
Railways Law
The Railways Act, 1989
The Railways (Local Authorities Taxation) Act, 1941
The Railway Claims Tribunal Act, 1987
The Railway Companies (Emergency Provisions) Act, 1951
The Railway Companies (Substitution of Parties in Civil Proceedings) Act, 1946
The Railway Property (Unlawful Possession) Act, 1966
The Railway Protection Force Act, 1957
Railways (Amendment) Act, 2005
Railways (Amendment) Act, 2008
The Railways (Employment of Members of the Armed Forces) Act, 1965
Service and Labour Law
Andhra Pradesh Administrative Tribunal (Procedure) Rules, 1989
Bonded Labour System (Abolition) Act, 1976
Building and Other Construction Workers (Regulation of Employment and Conditions of Service) Act, 1996
Building and Other Construction Workers Welfare Cess Act, 1996
Contract Labour (Regulation and Abolition) Act, 1970
Employees Provident Fund and Miscellaneous Provisions Act, 1952
Employees State Insurance Act, 1948
Employers Liability Act, 1938
Equal Remuneration Act,1976
Factories Act, 1948
Indian Dock Labourers Act, 1934
Industrial Employment (Standing Orders) Act, 1946
Labour Law (Exemption from Furnishing Returns and Maintaining Registers by Certain Establishment) Act, 1988
Personal Injuries (Emergency Provisions) Act, 1962
Sale Promotion Employees (Conditions of Service) Act, 1976
The Administrative Tribunals Act, 1985
The Administrative Tribunals Rules, 2000
The All India Service Regulations (Indemnity)1975
The Child Labour (Prohibition and Regulation) Act, 1986
The Dangerous Machines (Regulation) Act, 1983
The Employment Exchange (Compulsory Notification of Vacancies) Act, 1959
The All India Services Act, 1951
The Industrial Disputes Act, 1947
The Industries (Development And Regulation) Act, 1951
The Maharashtra Mathadi, Hamal and Other Manual Workers (Regulation of Employment and Welfare) Act, 1969
The Maharashtra Recognition of Trade Union and Prevention Of Unfair Labour Practices Act, 1971
The Maternity Benefits Act, 1961
The Minimum Wages Act, 1948
The Payment of Bonus Act, 1965
The Payment of Gratuity Act, 1972
The Payment of Wages Act, 1936
The Plantation Labour Act, 1951
The Public Servants (Inquiries) Act, 1850
The Tea Districts Emigrant Labour (Repeal) Act 1971
The Trade Unions Act, 1926
The Weekly Holidays Act, 1942
 Unorganised Workers Social Security Act, 2008
Workmen’s Compensation Act, 1923
Workmen’s Compensation (Amendment) Act 2009
Works of Defence Act 1903
Working Journalists (Industrial Disputes )Act 1993
Salary, Allowances and Pension of Members of Parliament Act, 1954
 Salary, Allowances and Pension of Members of Parliament (Amendment) Act, 2010
 Salary, Allowances and Pension of Members of Parliament (Amendment) Act, 2006
 Salaries and Allowances of Officers of Parliament (Amendment) Act, 2008
 The Salaries and Allowances of Ministers (Amendment) Act, 2009
 The Sales Promotion Employees (Conditions of Service) Act, 1976
Stamp Law
The Promissory Notes (Stamp) Act, 1926
The Indian Stamp Act, 1899
Repealed Law
Air Corporations Act, 1953
The Monopolies And Restrictive Trade Practices Act, 1969
Defence Law
Air Force Act, 1950
The Army Act, 1950
The Reserve and Auxiliary Air Forces Act, 1952
The Armed Forces Tribunal Act 2007
The Navy Act, 1957
Air Traffic Law
Air Crafts Act, 1934
 The Airports Authority Of India Act, 1994
Human Rights Law
Commission for protection of Child Right Act 2005
The Protection of Human Rights Act, 1993
The Protection of Civil Rights Act, 1955
Protection of Human Rights (Amendment) Act, 2006
States Law
The Rajasthan State Legislature (Delegation of Power) Act, 1993
Categories
80C Deductions ESIC Excel Formulas & VBA Code Gratuity House Rent Allowance (HRA) Human Resource (HR) India Payroll LTA Others Payroll Provident Fund (PF) Salary Tax Return (ITR)

Know your job skill in your company?

Classification of skills Category (Employee)

 

(A) Highly skilled- Highly skilled work employee is one who does the work which involves skill or competence of extra-ordinary degree and possesses supervisory ability.

(B) Skilled- Skilled employee is one who is capable of working independently and efficiently and turning out accurate working. He must be capable of reading and working on simple drawing circuits and process, if necessary. (ELECTRICIN, MECHANIC, TAILORS, COOKS Comes in skilled category)

(C) Semi-skilled- Semi-skilled employee is one who has sufficient knowledge of the particular trade or above to do respective work and simple job with the help of simple tools and machines.( GATEKEEPER(CINEMA),ASST. OPERATOR, ASST ELECTRICIAN, BOOKBINDER
,WAITER OR BEARER, MALI WITH TECHNICAL EXPERIENCE comes in unskilled category)

(D) Un-skilled- Un-skilled employee is one who possesses no special training and whose work involves the performance of the simple duties which require the exercise of little or no independent judgment or previous experience although a familiarity with the occupational environment is necessary. (UNSKILLED: PEON, CHOWKIDAR, DURBAN, WATCHMAN, CLEANER, SWEEPER, LOADER, HELPER, MALI comes in unskilled category.)

CLERICAL AND SUPERVISIORY STAFF: BOOK CLERK, TYPIST, RECEPTIONIST, TELEPHONE OPERATOR, TRAVELLING SALESMAN, comes in this category.

Categories
80C Deductions ESIC Human Resource (HR) India Payroll LTA Others Payroll Provident Fund (PF) Salary Tax Return (ITR)

The generation of UAN for first time

Download Steps for generate UAN Onlinedragon-free-dwn-btn

A Universal Account Number (UAN) will be generated for each of the PF contributing members during the period 01/01/2014 to 30/06/2014 by EPFO. The UAN will act as an umbrella for the multiple Member Ids allotted to an individual by different establishments. The idea is to link multiple Member Identification Numbers (Member Id) allotted to a single member under single Universal Account Number. This will help the member to view details of all the Member Identification Numbers (Member Id) linked to it. If a member is already allotted Universal Account Number (UAN) then he / she is required to provide the same on joining new establishment to enable the employer to in-turn mark the new allotted Member Identification Number (Member Id) to the already allotted Universal Identification Number (UAN).

The main objective behind this new function is to capture KYC details of its members in order to eliminate the dependency on the employer and improve the quality of service. The KYC details will be tagged against the allotted UAN rather the member id thereby eliminating the redundancy.