How to make ctc breakup (Cost to Company) explain by Mr. AKumar

The Institute of Payroll Training and Management, India

Подписаться 15 тыс.

Просмотров 120 тыс.

50% 1

Learn how to make cost to company, salary, allowances breackup in excel for employee. Terms like CTC, basic salary, gross salary, allowance, reimbursements, provident fund, insurance, etc. often create confusion for employees. In this video, we have attempted to delineate all the terms associated with the salary in order to make it simpler for you. Question: mail us :- ssd@iptm.org.in

Опубликовано:

6 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 86

@rajupattekar375 4 года назад

SirJi You are the best supporter, I Appreciate you, great..... 🙏🙏

@babumaclellan3063 4 года назад

PF, ESI contribution has revised.. and you are mentioned employee contribution in ctc instead of employer contribution..

@ghurahuprasadyadav3798 4 года назад

आदरणीय सर बहुत ही सरलतापूर्वक आपने समझाया है ।लेकिन मान लीजिए यदि इंक्रीमेंट होता है ।और इन हैंड जो आता है वह कम होकर आता है। और अन्य मे जुड जाता है ।जैसे इ पी यफ , बेसिक , हाउस एलाउंस, बढता है , लेकिन पहले जो हाउस रेंट मिलता है वह कम होजाता है।स्पेशल एलाउंस भी कम होजाता है । कृपया हमारा मार्गदर्शन करे।

@jacobantonio5830 4 года назад

Nice Explanition but please upload new video with new PF Rules

@hoihit 4 года назад

Thanks for the excellent Video Sir,,I have tried for different values of CTc but got a problem when a gave a monthly CTC of 12000,the difference is showing as -254,,kindly help me know where I went wrong..Thanks and Namaste

@TinyTummies-11 3 года назад

This is seriously learning video

@gursarandei 4 года назад

Aap Ka sheet is very good.but Protect sheet ko kis Tarah hats saktay hai....I want to build by myself and change according to my requirements...ya Esh Tarah Ka sheet Bana Kay video salary .

@rajendrakumarsethy3902 3 года назад

Respected Sir, Kindly put a video on 4 lakh package PA statement.

@jeet140686 2 года назад

It's very useful 👍

@sunitkumar4841 4 года назад

Thank you very much and appreciated your efforts.

@ashwaniKumar-nx2de 4 года назад

Very good information full but sir hum overtime kaise add karenge

@manjeetthakur5963 5 лет назад

Awesome .i really like and appreciate your efforts. Thank you 😊

@rspthatal 3 года назад

This is really awesome and very much useful. I have downloaded the excel sheet, it is really a work of professional and appreciable. I just want to know that how to change Tax computation from old to new regime. It is asking for the password

@ramanujnath4462 5 лет назад

Thank you sir ji for explaining

@richardmathew1 2 года назад

Excellent

@meghachand7946 3 года назад

sir can you add LTA, DA and Medical Allowances too. Annual Calculation can u just go slowly. Cant Understand that part

@kumarnengg7559 3 года назад

Sir, How to add payment due salary & advance payment salary in payslip. If suppose emp A taken advance of 5000 from actual sal per month 18000. How to add sir please let me know. And similarly emp B pending sal 10000 from actual sal 20000. Pls let me know sir

@jagadeeshangadi8187 5 лет назад

Very nice sir Explain gratuity, bonus to

@santoshkumaralways4u204 5 лет назад

Ur formula is super

@sanjeevkumar2495 5 лет назад

Sir MERI total salary 36500 h but basic 12500 h basic kyo Nahi plus Kar rahe kya Karu I worked in Pvt ltd company

@faizyabalam9199 2 месяца назад

New excel me f4 kaam ni kr rha. Uske jgh kon sa use karun?

@tallywalebhai 3 года назад

Jabardast lajavab🎉

@rkchopra2018 9 месяцев назад

What to do if basic salary is less than minimum wages

@veenukai2840 2 года назад

Awesome video sir

@kailastulaskar6319 2 года назад

Great efforts

@mohdaamir4068 4 года назад

Bindas Tricks!

@babumaclellan3063 4 года назад

What about leave benefits..I think it's part of CTC..but you are not mentioned in the table.

@sonalisoni288 5 лет назад

F4 function is not balancing the ctc, it would be great if you tell me solution of this problem ?

@Indianpayroll 5 лет назад

Sonali Soni First copy the difference amount and paste than press F4 (Fn function should be press if using laptop and fn on)

@sonalisoni288 5 лет назад

@@Indianpayroll okay , thanks

@SunitaDevi-hv3vt 3 года назад

Sir salary design krne me Cost Accounting ka use hota hai

@rakhitaliyan3605 5 лет назад

nice explanation,but please define the calculation and limit of gratutuity and bonus

@Indianpayroll 5 лет назад

Thanks Rakhi! Gratuity and bonus payment videos uploaded for the same. please watch these to understood.

@dipk0286 3 года назад

CTC main dono tarf ka esi pf aata hain

@abhilashajangid4406 3 года назад

F4 function is not balancing the CTC, guide me where i am wrong ?

@babun6958 4 года назад

Good & Nice.,

@sandeephr8676 Год назад

Sir mere employee ki 36000 hain ab company usko epf aur esi facility dene ka bol rahi to isko kaise manage kare pls reply jarur karna

@damyantipatkar1481 5 лет назад

Please the calculation sheet as per the new Pf and esic rules

@Radhasvaahmi 3 года назад

employee contribution of pf and esi is not there

@smtlabs7710 3 года назад

If the company do not provide Bonus, gratuity and variable the what will do

@rahulkshirsagar3191 2 года назад

Sir pls share salary calculator as it not showing on site

@hiteshchavda6542 3 года назад

Superb

@suvodhsharma5554 4 года назад

Hello Sir, I hope you very well. I visit your website payroll pedia i go on esi act then i saw no amendment in esi both side employees and employers. Please update for new learner's.

@Indianpayroll 4 года назад

Corrected

@kishorehr567 3 года назад

Where is the employer contributions Pf and esi for ctc

@rahuldhanuk5534 3 года назад

Can you tell me is this salary Breakdown is as per the 2020-2021 govt shared rules? Please calculate 23560

@SONUGUPTA-je2be 3 года назад

Sir , where is the calculation of absent

@shashikant1969 4 года назад

Awesome

@Akshay-kb7lc 4 года назад

Sir Basic KO 14,800 Rakho or CTC banoooo...????

@gauravthakur1292 3 года назад

i cannot open payrollpedia why it is not getting open tell me ??

@yudichakma3523 2 года назад

Can you provide CTC calculator link?

@naniraos5780 4 года назад

Sir if 18000 CTC per month what is the gross salary sir plz tell me

@VikasKumar-rn5uy 5 лет назад

Sir, what is the reason to calculate gratuity basic divide by 26 multiply by 15?

@saurabhbahuguna9420 5 лет назад

The ratio 15/26 represents 15 days out of the 26 working days in a month

@neha-ew9eb 4 года назад

That formula use to calculatr leve encashment

@ritikathakur8065 2 года назад

Payroll pedia isn't working

@chetangaikwad1997 5 лет назад

Thanks Sir

@lily_761 4 года назад

Sir accidental insurance premium with coverage is it taxable or not?

@dollysasmal3429 4 года назад

Hi sir PF, ESI contribution has revised please calculation for same in excel sheet.

@Indianpayroll 4 года назад

Ok use latest one

@carinishabafna8751 4 года назад

@@Indianpayroll where is the latest sheet available?

@dilipkumartandan1651 2 года назад

CTC GOOD THANKS

@shamimkhan6439 4 года назад

Employee contribution not shown here

@paulkrishan720 4 года назад

sir ye file site se download nahi ho rahi hai kya ap ye file send kr skte hai soft copy me.. please reply sir

@ritikathakur8065 2 года назад

I want this Excel sheet sir

@sudamasharma666 Год назад

Sir,2.76 k ctc banaye pl.

@babumaclellan3063 4 года назад

As per statutory bonus act 8.33% on M.W those who are eligible less than 21000 basic+DA...

@pallavimehta9445 4 года назад

MW means?

@babumaclellan3063 4 года назад

@@pallavimehta9445 Minimum wage

@pallavimehta9445 4 года назад

babu maclellan ye bonus yearly dete hai company profits pe?

@babumaclellan3063 4 года назад

@@pallavimehta9445 Yes...but bonus pay is depends on the company decision.. Monthly/Annual.. But it should be calculated on monthly basis as it's part of CTC.

@pallavimehta9445 4 года назад

babu maclellan oh! A lil confusing

@sahajadamalla4338 3 года назад

i didnt get the dowd file

@gajananpaighan592 3 года назад

4.2 ctc and 35k monthly sa

@rakhitaliyan3605 5 лет назад

Gratuity to after 5 yrs milti h

@swatiagarwal2292 4 года назад

i need this breakup in excel

@Indianpayroll 4 года назад

Download it from PayrollPedia

@SKumar-lq1cd 5 лет назад

Sir, what is 38000

@khateejashameem3380 2 года назад

Can I get an amount of 1600

@jiyabasicpro 5 лет назад

👍

@gulfamraja648 4 года назад

PF formula is applicable when Basic is less than or equal to15000, in manager CTC structure basic is 45000 and your breakup showing pf amount there that's wrong.

@ravikumar-pq4rt 5 лет назад

Sir 230000 ka Bata dijiy

@GauravGupta-ie3il 5 лет назад

Please make the CTC of 5.6 L

@manishsurve22 4 года назад

Dear Gaurav, Its simple..You just make sure that your basic would be in between 40% to 50% of your 5.6 L CTC....and rest of allowances you can adjust accordingly as per adjustments.