{"id":5951,"date":"2012-06-14T05:02:03","date_gmt":"2012-06-14T05:02:03","guid":{"rendered":"http:\/\/www.yourhrworld.com\/formats\/?p=5951"},"modified":"2012-06-14T12:22:15","modified_gmt":"2012-06-14T12:22:15","slug":"ctc-format-attached","status":"publish","type":"post","link":"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/","title":{"rendered":"Cost To Company or CTC Salary Format in Excel"},"content":{"rendered":"<p><strong>Attached herewith CTC format that may help u to identify net take home salary, monthly CTC, yearly CTC in Excel.<br \/>\n<\/strong><\/p><div class=\"69eb924294c115e6505da44099e8df92\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script type=\"text\/javascript\"><!--\r\ngoogle_ad_client = \"pub-0867779017855679\";\r\n\/* 300x250, created 4\/20\/11 *\/\r\ngoogle_ad_slot = \"1035864135\";\r\ngoogle_ad_width = 300;\r\ngoogle_ad_height = 250;\r\n\/\/-->\r\n<\/script>\r\n<script type=\"text\/javascript\"\r\nsrc=\"http:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\r\n<\/script>\n<\/div>\n\n<table width=\"1249\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"198\" \/>\n<col width=\"137\" \/>\n<col width=\"132\" \/>\n<col width=\"151\" \/>\n<col width=\"204\" \/>\n<col width=\"81\" \/>\n<col width=\"112\" \/>\n<col width=\"81\" \/>\n<col width=\"89\" \/>\n<col width=\"64\" \/><\/colgroup>\n<tbody>\n<tr>\n<td width=\"198\" height=\"18\">company&#8217;s Logo<\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\">ANNEXURE-I<\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\">Notes:-<\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td colspan=\"4\" width=\"618\" height=\"28\">SALARY BREAK-UP<\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\">value<\/td>\n<td colspan=\"2\">PF deposited in PF department<\/td>\n<td><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">NAME<\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\">ANNUAL BENEFITS:-<\/td>\n<td width=\"81\"><\/td>\n<td colspan=\"2\">ESIC deposited with ESIC dept<\/td>\n<td><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">DESIGNATION<\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\">Individual Component (IC)<\/td>\n<td width=\"81\"><\/td>\n<td colspan=\"2\">Prof tax paid to PT department<\/td>\n<td><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">DEPARTMENT<\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\">Bonus<\/td>\n<td width=\"81\"><\/td>\n<td colspan=\"3\">Lumpsum LTA payable in <span>August in some company<\/span><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">DATE OF JOINING<\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td colspan=\"2\">Bonus paid at the time of <span>Diwali<\/span><\/td>\n<td><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"18\"><\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td colspan=\"3\">Gratuity will be paid after 5 yrs services<\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\" width=\"335\" height=\"22\">EARNINGS<\/td>\n<td colspan=\"2\" width=\"283\">DEDUCTIONS<\/td>\n<td width=\"204\">Exgratia<\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">SALARY HEAD<\/td>\n<td width=\"137\">AMOUNT (Rs.)<\/td>\n<td width=\"132\">SALARY HEAD<\/td>\n<td width=\"151\">AMOUNT (Rs.)<\/td>\n<td width=\"204\">canteen subsidy<\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Basic<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12,000<\/td>\n<td width=\"132\">PF Employee<\/td>\n<td width=\"151\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,440<\/td>\n<td width=\"204\">Company Component (CC)<\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"34\">H R A<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4,800<\/td>\n<td width=\"132\">ESI Employee<\/td>\n<td width=\"151\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8211;<\/td>\n<td width=\"204\">Coverage towards Group Mediclaim Policy (GMP)<\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"34\">Conv. All<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 800<\/td>\n<td width=\"132\">Profession Tax(PT)<\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\">Coverage towards Health insurance scheme (HIS)<\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"60\">Leave Travel Allowance(LTA)<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 840<\/td>\n<td width=\"132\">Income Tax<\/td>\n<td width=\"151\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2,946<\/td>\n<td width=\"204\">Coverage towards Group Saving Linked Insurance (GSLI)<\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"34\">Child Education Allowance(CEA)<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 600<\/td>\n<td width=\"132\">HIS<\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\">Coverage towards personal accident<\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"34\">Site Allowance<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4,750<\/td>\n<td width=\"132\">GSLI<\/td>\n<td width=\"151\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 280<\/td>\n<td width=\"204\">Employee deposit Linked insurance (EDLI)<\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"34\">Special Pay<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5,950<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\">Coverage towards Group Term Life (GTL)<\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Medical Allowance<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,250<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\">Term Insurance<\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Personal Pay<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15,361<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Additional Allowance<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7,500<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\"><\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\"><\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">SALARY (GROSS) \/ PM<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 53,851<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"34\">Pension Employer(8.33% of Minimum (basic or 6500))<\/td>\n<td align=\"right\" width=\"137\">541<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"34\">PF Employer( PF employee-pension Employer)<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 899<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">ESI Employer<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8211;<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Gratuity<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 500<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Superannuation<\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Company Component (CC)<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2,541<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Medical (Reimb)<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8211;<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Conv (Reimb)<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8211;<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Telephone (Reimb)<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8211;<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Others (Reimb)<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8211;<\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"21\">SALARY (CTC) \/ PM<\/td>\n<td width=\"137\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 58,332<\/td>\n<td width=\"132\">TOTAL DEDUCTION<\/td>\n<td width=\"151\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4,666<\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"20\"><\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"21\">Cash in Hand (PM)<\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 49,185<\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"21\">SALARY (CTC) \/ PA<\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 699,984<\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"21\"><\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Notes:<\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td colspan=\"4\" width=\"618\" height=\"17\">1. TDS \/ FBT Deduction &#8211; as applicable<\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\"><\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\"><\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"17\">Prepared by<\/td>\n<td colspan=\"2\" width=\"269\">Checked by<\/td>\n<td width=\"151\">Authorised by<\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<tr>\n<td width=\"198\" height=\"18\"><\/td>\n<td width=\"137\"><\/td>\n<td width=\"132\"><\/td>\n<td width=\"151\"><\/td>\n<td width=\"204\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"112\"><\/td>\n<td width=\"81\"><\/td>\n<td width=\"89\"><\/td>\n<td width=\"64\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><a href=\"https:\/\/www.yourhrworld.com\/formats\/wp-content\/uploads\/2012\/06\/CTC-Format-Attached.xls\">Click Here To Download CTC Format Attached<\/a><\/strong><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Attached herewith CTC format that may help u to identify net take home salary, monthly CTC, yearly CTC in Excel. company&#8217;s Logo ANNEXURE-I Notes:- SALARY BREAK-UP value PF deposited in PF department NAME ANNUAL BENEFITS:- ESIC deposited with ESIC dept DESIGNATION Individual Component (IC) Prof tax paid to PT department DEPARTMENT Bonus Lumpsum LTA payable in August in some company DATE OF JOINING Bonus paid at the time of Diwali Gratuity will be paid after 5 yrs services EARNINGS DEDUCTIONS Exgratia SALARY HEAD AMOUNT (Rs.) SALARY HEAD AMOUNT (Rs.) canteen subsidy Basic \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12,000 PF Employee \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,440 Company Component<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[45],"tags":[1267,315,47],"class_list":["post-5951","post","type-post","status-publish","format-standard","hentry","category-hr","tag-attached","tag-ctc","tag-format"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cost To Company or CTC Salary Format in Excel - HR Letter Formats<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cost To Company or CTC Salary Format in Excel - HR Letter Formats\" \/>\n<meta property=\"og:description\" content=\"Attached herewith CTC format that may help u to identify net take home salary, monthly CTC, yearly CTC in Excel. company&#8217;s Logo ANNEXURE-I Notes:- SALARY BREAK-UP value PF deposited in PF department NAME ANNUAL BENEFITS:- ESIC deposited with ESIC dept DESIGNATION Individual Component (IC) Prof tax paid to PT department DEPARTMENT Bonus Lumpsum LTA payable in August in some company DATE OF JOINING Bonus paid at the time of Diwali Gratuity will be paid after 5 yrs services EARNINGS DEDUCTIONS Exgratia SALARY HEAD AMOUNT (Rs.) SALARY HEAD AMOUNT (Rs.) canteen subsidy Basic \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12,000 PF Employee \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,440 Company Component\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/\" \/>\n<meta property=\"og:site_name\" content=\"HR Letter Formats\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-14T05:02:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-06-14T12:22:15+00:00\" \/>\n<meta name=\"author\" content=\"Hrformats\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hrformats\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/ctc-format-attached\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/ctc-format-attached\\\/\"},\"author\":{\"name\":\"Hrformats\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#\\\/schema\\\/person\\\/12e40c15a77b1929a013a8c83de187ee\"},\"headline\":\"Cost To Company or CTC Salary Format in Excel\",\"datePublished\":\"2012-06-14T05:02:03+00:00\",\"dateModified\":\"2012-06-14T12:22:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/ctc-format-attached\\\/\"},\"wordCount\":244,\"commentCount\":4,\"keywords\":[\"Attached\",\"CTC\",\"Format\"],\"articleSection\":[\"HR\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/ctc-format-attached\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/ctc-format-attached\\\/\",\"url\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/ctc-format-attached\\\/\",\"name\":\"Cost To Company or CTC Salary Format in Excel - HR Letter Formats\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#website\"},\"datePublished\":\"2012-06-14T05:02:03+00:00\",\"dateModified\":\"2012-06-14T12:22:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#\\\/schema\\\/person\\\/12e40c15a77b1929a013a8c83de187ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/ctc-format-attached\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/ctc-format-attached\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/ctc-format-attached\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cost To Company or CTC Salary Format in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#website\",\"url\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/\",\"name\":\"HR Letter Formats\",\"description\":\"Free Human Resource Forms, Formats &amp; Questionnaires\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#\\\/schema\\\/person\\\/12e40c15a77b1929a013a8c83de187ee\",\"name\":\"Hrformats\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g\",\"caption\":\"Hrformats\"},\"url\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/author\\\/hrformats\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cost To Company or CTC Salary Format in Excel - HR Letter Formats","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/","og_locale":"en_US","og_type":"article","og_title":"Cost To Company or CTC Salary Format in Excel - HR Letter Formats","og_description":"Attached herewith CTC format that may help u to identify net take home salary, monthly CTC, yearly CTC in Excel. company&#8217;s Logo ANNEXURE-I Notes:- SALARY BREAK-UP value PF deposited in PF department NAME ANNUAL BENEFITS:- ESIC deposited with ESIC dept DESIGNATION Individual Component (IC) Prof tax paid to PT department DEPARTMENT Bonus Lumpsum LTA payable in August in some company DATE OF JOINING Bonus paid at the time of Diwali Gratuity will be paid after 5 yrs services EARNINGS DEDUCTIONS Exgratia SALARY HEAD AMOUNT (Rs.) SALARY HEAD AMOUNT (Rs.) canteen subsidy Basic \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12,000 PF Employee \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1,440 Company Component","og_url":"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/","og_site_name":"HR Letter Formats","article_published_time":"2012-06-14T05:02:03+00:00","article_modified_time":"2012-06-14T12:22:15+00:00","author":"Hrformats","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Hrformats","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/#article","isPartOf":{"@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/"},"author":{"name":"Hrformats","@id":"https:\/\/www.yourhrworld.com\/formats\/#\/schema\/person\/12e40c15a77b1929a013a8c83de187ee"},"headline":"Cost To Company or CTC Salary Format in Excel","datePublished":"2012-06-14T05:02:03+00:00","dateModified":"2012-06-14T12:22:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/"},"wordCount":244,"commentCount":4,"keywords":["Attached","CTC","Format"],"articleSection":["HR"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/","url":"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/","name":"Cost To Company or CTC Salary Format in Excel - HR Letter Formats","isPartOf":{"@id":"https:\/\/www.yourhrworld.com\/formats\/#website"},"datePublished":"2012-06-14T05:02:03+00:00","dateModified":"2012-06-14T12:22:15+00:00","author":{"@id":"https:\/\/www.yourhrworld.com\/formats\/#\/schema\/person\/12e40c15a77b1929a013a8c83de187ee"},"breadcrumb":{"@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/ctc-format-attached\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yourhrworld.com\/formats\/"},{"@type":"ListItem","position":2,"name":"Cost To Company or CTC Salary Format in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.yourhrworld.com\/formats\/#website","url":"https:\/\/www.yourhrworld.com\/formats\/","name":"HR Letter Formats","description":"Free Human Resource Forms, Formats &amp; Questionnaires","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yourhrworld.com\/formats\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.yourhrworld.com\/formats\/#\/schema\/person\/12e40c15a77b1929a013a8c83de187ee","name":"Hrformats","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g","caption":"Hrformats"},"url":"https:\/\/www.yourhrworld.com\/formats\/author\/hrformats\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/posts\/5951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/comments?post=5951"}],"version-history":[{"count":0,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/posts\/5951\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/media?parent=5951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/categories?post=5951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/tags?post=5951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}