Category: Payroll

Categories
Payroll

Due Date Compliance Calendar June 2019

Statutory compliances due dates calendar issued by #PayrollPedia for June 2019. Below are list of last dates Act wise: –

Date (by when) Applicable Act Details of Compliance
7st Jun Tax Deposie Monthly deposit tax Contribution
15th Jun TDS Certificate (Form 16) Issue Last date  Income From Salary, Income Tax Act , 1961
15th Jun ESIC Monthly deposit ESIC Contribution
15th Jun PROVIDENT FUND Monthly deposit PF Contribution
20-Jun  Professional Tax KARNATAKA (BANGALORE) [Monthly]
10-Jun  Professional Tax ANDHRA PRADESH (HYDERABAD) [Monthly]
21-Jun  Professional Tax WEST BENGAL (KOLKATA) [Monthly]
30-Jun  Professional Tax MAHARASHTRA  (MUMBAI) [Monthly]
15-Jun  Professional Tax GUJARAT (AHMEDABAD)   [Monthly]
30-Jun  Professional Tax ORISSA  (Monthly)
10-Jun  Professional Tax MADHYA  PRADESH  (INDORE) (Monthly Salary)
30-Jun  Professional Tax GUWAHATI (ASSAM) (Monthly)

 

Categories
Excel Formulas & VBA Code Excel VBA Dashboard India Payroll Payroll

Merge Part A and Part B of Form 16 in Excel

Greetings!

I believe, You are searching a free tool which can merge or combine Part A and Part B in 1 PDF in automation process. if yes, you are at right place.

As per Income tax India Form 16 TDS Certificate Part A should be download and convert from Trace website (tdscpc.gov.in) and Employer have to prepare Part B of Form 16. Both Should be Merged in One PDF for digital signature process.

Every Employee or professionals are looking a tools which can help in this process. Three are many software available in market / google search to do the same but they are paid.

But, trust me you can Merge any two more pdfs in 1 pdf in excel sheet without any wasting money in very simple way and fast.

I have developed a Excel sheet which can use N numbers of times and you can merge 2 different folders PDF files in 1 PDF as per your customization.

You can download this sheet from www.99Excel.Com and watch the below video to learn tutorial.

Direct Link to download sheet:
http://99excel.com/download/index.html

Thanks,

Kumar Ajit

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
Labour Welfare Fund Payroll punjab

Revised Labour Welfare Fund Punjab

Click here to download notification

This is to bring to your information that Haryana Government has amended the Punjab Labour Welfare Fund Act in its application to Haryana State. As per the notification from now onwards the contribution in Haryana with effect from March’2019, shall be

Employee = 0.2% of employee salary/wages every month (subject to a limit of Rs.25)

Employer =  Twice the employee contribution. Provided, that the limit specified above shall be indexed annually to the consumer price index beginning from 1st January every year. The notification is attached herewith for reference

Click here to download notification

Categories
Payroll

Due dates Compliance Calendar for March 2019

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

Date (by when) Applicable Act Details of Compliance
07th MAR TDS Deposit Last Date Income Tax Deduction On Salary
15th MAR ESIC Monthly deposit ESIC Contribution
15th MAR PROVIDENT FUND Monthly deposit PF Contribution
20th MAR Professional Tax KARNATAKA (BANGALORE) [Monthly]
10th MAR Professional Tax ANDHRA PRADESH (HYDERABAD) [Monthly]
21st MAR Professional Tax WEST BENGAL (KOLKATA) [Monthly]
31st MAR Professional Tax MAHARASHTRA  (MUMBAI) [Monthly]
15th MAR Professional Tax GUJARAT (AHMEDABAD)   [Monthly]
31st MAR Professional Tax ORISSA  (Monthly)
10th MAR Professional Tax MADHYA  PRADESH  (INDORE) (Monthly Salary)
31st MAR Professional Tax GUWAHATI (ASSAM) (Monthly)
31st MAR Professional Tax KERALA  (Half-Yearly)/COCHIN
31st MAR Professional Tax (CHENNAI) [Half – Yearly] 
31st MAR Professional Tax COIMBATORE (TAMIL NADU) [Half – Yearly] 
31st MAR Professional Tax Tenkasi, Tamil Nadu(Half-Yearly)
31st MAR Professional Tax Kancheepuram, Tamil Nadu(Half-Yearly)
31st MAR Professional Tax Hosur, Tamil Nadu(Half-Yearly)
31st MAR Professional Tax Erode , Tamil Nadu(Half-Yearly)
31st MAR Income Tax Act Last date of Submission Investment proofs Form 12BB

(Author can be reached at iptm.india@gmail.com)

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
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