Hi All, Please need salary break up on Rs 1459999 L . I have some confusion please shot out. Regards Amit Mishra 8882531567
From India, Delhi
Acknowledge(1)
Amend(0)

what is confusion in salary breakup. please note that details. Regards Vishnu Pathak 09953564557
From India, Gurgaon
Acknowledge(0)
Amend(0)

Dear Amit, The attached document will help, just try to change your basic, HRA or other components?
From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls Salary Statement Annexure.xls (24.5 KB, 2271 views)

Acknowledge(1)
MH
Amend(0)

Dear Arvaan, I want to be add up some of HR -department employees in to account to ensure my knowledge so can i have your contact details like mobile number and mail id?
From India, Hyderabad
Acknowledge(0)
Amend(0)

Hi Amit,

The particulars of the CTC structure depend on the company policy and can vary. Without knowing that, it would be difficult to give you an accurate structure. However, some helpful individuals may still manage to assist you. ;) :)

From India, Karnal
Acknowledge(0)
Amend(0)

No one will force you to follow but the act will says. i agreed with Vivek Mishra’s comments but attached excel will give some knowledge.
From India, Hyderabad
Acknowledge(1)
R1
Amend(0)

Thank you very much!! I apologies I did not complete my question. Actually I need how I will calculate tax on 1459999 L Annual Pkg. Amit Mishra 8882531567
From India, Delhi
Acknowledge(0)
Amend(0)

Hi Ashok, The salary break up you attached is having formula error. How come an employee is earning 1.2 lac pm is eligible for ESIC. So pls be care ful when you share ctc format to others. Meenakshi
From India, Chennai
Acknowledge(0)
Amend(0)

Dear Mr. Ashok Negi,

It's commendable the assistance you provided to Mr. Amit Mishra, but in my opinion, there are some mistakes in the Excel attachment. Firstly, the travel allowance should be 10%, and ESIC is not deductible. Additionally, if an employee's salary exceeds 15,000/- per month, TDS should be deducted from their salary on an average basis.

Regards,
Brajesh Kumar Sharma

From India, Srinagar
Acknowledge(0)
Amend(0)

Mr Ashok, First Tx for response and help. In delhi PT is not applicable. We need breakup according Tax-Slab — TDS Regards Amit Mishra 8882532567
From India, Delhi
Acknowledge(0)
Amend(0)

Hi Friends, Pls find the CTC break up. Hope this will help you all. regards Shiva
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: docx Doc2.docx (1.02 MB, 86 views)

Acknowledge(0)
Amend(0)

Hi Ashok, Appreciate your reply but by deleting if salary above 15000 is not correct format. Instead u can use this formula in excel =IF(Gross<=15000,Gross*4.75%,0) for permanent format. Meenakshi
From India, Chennai
Acknowledge(0)
Amend(0)

Dear Meenakshi Your formula one problem no roundup value. so please you help full formula. THIS IS CORRECT FORMULA IN EXCEL =IF(GROSS>15000,0,ROUNDUP(GROSS*4.75%,0)) Vishnu
From India, Gurgaon
Acknowledge(0)
Amend(0)

Dear employee’s Share =IF(GROSS>15000,0,ROUNDUP(GROSS*1.75%,0)) employer’s Share =IF(GROSS>15000,0,ROUNDUP(GROSS*4.75%,0))
From India, Gurgaon
Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.