Quikchex Ctc Calculator April

Quikchex: Your Payroll Outsourcin

Instructions: Please Read Carefully Step 1 Step 2 Step 3 Step 4

Turn on “Iterative Calculations” by going to Fi In Row 14, enter the CTC amounts as Annua In Row 21, you can alter the minimum wage o In cell C12, choose which salary strucure you

*This Salary Calculator is as per the Which Salary working apply…

2

1 Range

Enter Annual CTC Amount:

Upto 2,77,300/with ESIC 250000

PF Applied (If PF to deduct 12% flat on PF wage (Basic) ---Yes/No) 15000 PF Ceiling Applied (If PF dedcution to limit on 15,000/- ---Yes/No)

Yes Yes

Annual Salary Component

250000

Monthly Salary Component

20833

Minimum Wage as per State…. a) Enter the Basic amount: b) Enter the DA/Special Allowance amount: Srno Components

9500 0

Type

Monthly Salary Component 1 Basic 2 House Rent Allowance 3 Conveyance Allowance 4 Medical Allowance 5 Leave Travel Allowance 6 Education Allowance 7 CCA

Salary - Fully taxable/PF App Salary Exempt Salary - Fully taxable Salary - Fully taxable Salary Exempt Salary Exempt Salary - Fully taxable

9500 4750 1600 1250 0 200 1500

0 8 Books & Periodicals 9 Fuel Reimbursement 10 Driver Salary 11 Telephone & Internet Reimbursement 12 Food Allowance Gross CTC Add :

Reimbursement Reimbursement Reimbursement Reimbursement Reimbursement

0 0 0 0 0 18800

PF Employer 12%

1140

ESIC Employer 4.75% Total CTC Less : PF Employee 12% ESIC Employee 1.75% Professional Tax Net Take Home

893 20833

checking Diff

20833 0

1140 329 200 17131

© Quikchex India Pvt. Ltd. Not to be dist

l Outsourcing and HR Software Partner

Sign Up with Quikchex Today!

www.quikchex.in

ions” by going to File -- > Options -- > Formulas -- > Enable-- > Iterative Calculations. amounts as Annual Amounts (not monthly Amounts) he minimum wage on a state by state basis; you can check min wages here http://www.paycheck.in/main salary strucure you would like to show in your Annexure

tor is as per the new guidelines effective April 2018 onwards % or Amt

% or Amt

2 From 1,20,000/to 5,00,000/without ESIC

40% 50% 1600 1250 0% 200 Balance

3

% or Amt

900000 Yes

Yes

Yes

% or Amt

Above 10,00,000/ -

From 5,00,000/to 10,00,000/-

500000 Yes

4

1500000 Yes Yes

500000

900000

1500000

41667

75000

125000

9500

15100

15100

0

NA

NA

16670 40% 8335 50% 1600 1600 1250 1250 0 0% 200 200 10812 Balance

30000 40% 15000 50% 1600 1600 1250 1250 4500 15% 200 200 14150 Balance

0 0 0 0 0 0 1000 1000 0 0 39867

2000 0 0 2000 2500 73200

2000 0 0 2000 2500

50000 40% 25000 50% 1600 1600 1250 1250 7500 15% 200 200 13150 Balance 2000 10000 8000 2000 2500 123200

2000 10000 8000 2000 2500

4.75%

1.75%

1800

1800

1800

0 41667

0 75000

0 125000

1800 0 200 37867

1800 0 200 71200

1800 0 200 121200

41667 0

75000 0

125000 0

vt. Ltd. Not to be distributed or duplicated without permission

with Today!

ww.paycheck.in/main/salary

Data Filling Annexure

16670 8335 1600 1250 0 200 10812 0 0 0 1000 0 39867

1800 0 41667 1800 0 200 37867 41667 0

Salary Components

Monthly (Rs)

Annual (Rs)

16670 8335 1600 1250 0 200 10812

200040 100020 19200 15000 0 2400 129744

0 0 0 1000 0

0 0 0 12000 0

39867

478404

1800 0

21600 0

41667

500004

Status R

Monthly Salary Component Basic House Rent Allowance Conveyance Allowance Medical Allowance Leave Travel Allowance Education Allowance CCA 0 Books & Periodicals Fuel Reimbursement Driver Salary Telephone & Internet Reimbursement Food Allowance Gross CTC Employer Contributions PF Employer 12% ESIC Employer 4.75% Total CTC Less Deduction from salary: PF Employee 12% ESIC Employee 1.75% Professional Tax Net Take Home

1800 0 200 37867

Annual Variable Cash (as applicable) Performance Bonus

Cost to Company (CTC)

500004

Err:5

Total as per CTC Totals as per components

Status Report Err:508

Total as per CTC Totals as per components

39867 39867