{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":[" Salary break up Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":" Salary break up Calculator","index":0,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,9,0,12],[8,1,8,6],[17,3,25,3],[29,3,34,3],[17,6,25,6],[29,6,34,6]],"flags":["formulas_cached_only"]}
[{"$nulls":9},"working side"]
["TO BE HIDE",249360,null,null,null,"EPF"]
["TO BE HIDE",0,124680,null,null,"ESIC"]
["TO BE HIDE",0,{"$nulls":7},"Bonus",6000]
["TO BE HIDE",null,null,6000,null,"Bonus",null,null,null,"LTA",2000,null,{"$error":"#REF!"}]
["TO BE HIDE",null,null,2000,null,"L T A"]
["TO BE HIDE",null,null,8000]
[{"$nulls":9},"Grand CTC",257360,"ESIC",20000]
[null,"Yearly & Monthly Break Up of  Salary for F.Y. 2008-09"]
[null,"            Basic                            50%"]
[null,"            HRA                             20%"]
[null,"            Medical                        10%",{"$nulls":9},"ESIC Diff amount",0]
[null,"            Misc.                             1%"]
[null,"            Conveyance                  6%"]
[null,"            Education.                    (13% - E P F + ESIC)"]
[]
[null,"Particulars","Yearly","Grand Totals",null,"Monthly Salary Break up","Monthly Salary Total"]
[null,"Annual CTC without Bonus & L. T. A.",249360,null,null,20780,0]
[null,"Basic ",124680,null,null,10390,null,null,null,14961.599999999999,null,null,1246.8]
[null,"H. R. A.",49872,null,null,4156]
[null,"Misc. Allowance",2493.6,null,null,207.79999999999998]
[null,"Medical Allowance",24936,null,null,2078]
[null,"Conveyance Allowance",14961.599999999999,null,null,1246.8]
[null,"Education Allowance",23056.800000000003,null,null,1921.4000000000003]
[null,"Conveyance Re-imbursement",null,null,null,0]
[null,"Mobile and Car Expense ( On Actual)",null,null,null,0,null,null,null,"Cross Check"]
[null,"*Gratuity"]
[null,"**Superannuation"]
[null,"Gross Salary (A)",null,240000,null,null,20000,"(A)",null,257360]
[null,"Performance Bonus + L.T.A.",8000,null,null,null,0,null,null,21447]
[null,"Less : Deduction (B)",{"$nulls":7},667,20000]
[null,"PF - Employers Contribution 12% of basic or Rs. 780/- whichever is less",9360,null,null,780,null,null,null,780]
[null,"P.F. ( Employees Contribution 12% of Basic or Rs 780/- whicever is less)",9360,null,null,780,null,null,null,780]
[null,"ESIC - Employers Contribution 4.75% of Gross Salary.",0,null,null,0,null,null,null,0]
[null,"ESIC - Employees Contribution 1.75% of Gross Salary.",0,null,null,0,null,null,null,0]
[null,"Professional Tax",2500,11860,null,200,980,"(B)",null,200,980]
[null,"Net Salary Payable (A-B)",null,228140,null,null,19020,"(A-B)",null,19020,19020]
[null,"Conveyance Re-imbursement",null,0,null,null,0]
[null,"Total Cost to the Company (Annual)",null,257360,null,null,19020]
[]
[]
[null,"NOTES:"]
[null,"There are 6 variables (mark in yellow cells) in this file only that we need to punch the figure."]
[1,20000,"Insert the Gross Salary in the mentioned cell      (Extreme right).","Cell \"M8\""]
[2,"20000*12+8000+9360","Insert Monthy Salary multiply by 12 months + 8000 (yearly Bonus +LTA) +9360 P.F. Yearly. If E.S.I.C is applicable you have to insert that amount as well from Diff column","Cell \"K8\""]
[3,0,"ESIC Diff. amount - It will show us the difference if any for ESIC. (for their Addition and Substraction .On basis of that we have add or substract.)","Cell \"M12\""]
[4,null,"Mobile and Car Expense ( On Actual)","Cell \"C26\""]
[5,null,"*Gratuity (Eligibility for Gratuity: 5 years of Service )","Cell \"C27\""]
[6,null,"*Superannuations (Eligibility for Superannuation: 10 years of Service )","Cell \"C28\""]