【实例】某公司薪酬核算计算系统.xls
《【实例】某公司薪酬核算计算系统.xls》由会员分享,可在线阅读,更多相关《【实例】某公司薪酬核算计算系统.xls(19页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、LOGOLOGO XXXXXXXXXXXX 公公司司薪薪酬酬计计算算系系统统2009年12月制作说说明明:1:考勤表和薪酬构成为原始数据,考勤表的数据引用入“薪酬构成”后进行最终计算.2:应发工资和实发工资,及其社保、个税的扣缴均在“薪酬构成”工作表中完成3:报税和薪酬分析以及财务部报表的数据均直接引用至薪酬构成工作表.因此,各项数据均自动生成,一般不作手动更改,避免出错.4:日常更新数据时,只需更新考勤表即可,/人事行政部薪薪酬酬计计算算系系统统:/-工工资资总总额额=收入部分-扣款部分-社会保障-个税部分饭卡押金保保险险总总额额=养老保险+医疗保险+失业保险+工伤保险+生育保险+住房公积金
2、税税前前收收入入=应发工资总额-社会保险总额应应税税金金额额=应发工资-个税收缴基数(1600)个个人人所所得得税税=应税金额*适应税率-速算扣除系数/-社社会会保保障障体体系系:本本埠埠:外外埠埠:2006.11.17修改薪薪酬酬构构成成(收收入入部部分分-扣扣款款部部分分-社社会会保保障障-个个税税部部分分饭饭卡卡押押金金等等)基基本本信信息息收收入入部部分分扣扣款款部部分分结结算算社社会会保保险险系系统统(个个人人扣扣缴缴)个个人人所所得得税税手手机机费费/饭饭卡卡押押金金序序号号部部 门门姓姓 名名身身份份证证基基本本工工资资奖奖 金金福福 利利津津 贴贴职职务务津津贴贴值值班班补补贴
3、贴夜夜餐餐补补贴贴综综合合工工时时/加加班班周周六六日日加加班班 法法定定节节假假日日法法定定假假日日加加班班加加班班费费合合计计应应加加工工资资提提成成奖奖金金考考核核工工资资事事假假扣扣款款病病假假扣扣款款其其他他扣扣款款应应发发工工资资养养老老失失业业医医疗疗住住房房社社保保总总计计税税前前收收入入应应税税金金额额代代扣扣个个税税话话费费超超标标 扣扣饭饭卡卡押押金金退退饭饭卡卡押押金金1安管部杨一500020001000000.000.000.000.000.00008000.003202082.64450872.647127.365527.36730.4750.002安管部杨大500
4、020001000000.000.000.000.000.00008000.00000008000.006400.00905.00503安管部许少500020001000000.000.000.000.000.00008000.002401565.60320.67679.406079.40840.884安管部海海涛涛30001000500000.000.000.000.000.00004500.0020012.553260525.53974.502374.50231.185安管部杜杜辉辉30001000500000.000.000.000.000.00004500.004002555.6250
5、730.63769.402169.40200.416安管部杨杨宏宏30001000500000.000.000.000.000.00004500.00206.4812.9154.62250524.013975.992375.99231.407安管部张张兆兆30001000500000.000.000.000.000.00004500.001207.551.62200379.124120.882520.88253.138安管部霍霍钟钟30001000500000.000.000.000.000.00004500.002401539.04170464.044035.962435.96240.399
6、安管部郑郑斌斌30001000500000.000.000.000.000.00004500.0020012.541.58122376.084123.922523.92253.5910安管部韩韩生生30001000500000.000.000.000.000.00004500.004803038.76180728.763771.242171.24200.69安安管管部部合合计计36000360001300013000650065000 00 00 00 00 00 00 00 00 00 00 00 00 00 00 055500.0055500.002406.482406.48150.411
7、50.41482.46482.46188218824921.354921.3550578.6550578.6534578.6534578.654087.144087.14505050500 01工程部跃松600030001000000.000.000.000.000.000010000.00248.9615.5665.240329.769670.248070.241239.052工程部张君600030001000000.000.000.000.000.000010000.00272.4817.0371.12380740.639259.377659.371156.873工程部史史高高400020
8、00500000.000.000.000.000.00006500.00137.288.5837.320183.186316.824716.82582.524工程部刘刘晶晶40002000500000.000.000.000.000.00006500.002401535.80290.86209.204609.20566.385工程部郝郝向向阳阳400020505001000000.000.000.000.000.00007550.0020012.553200465.57084.505484.50721.906工程部于于大大强强400021005005001000000.000.000.000.
9、000.00008100.003202058.36250648.367451.645851.64795.337工程部郭郭小小华华400021505001000000.000.000.000.000.00007650.00179.8411.2447.96200439.047210.965610.96747.198工程部牛牛大大维维40002200500000.000.000.000.000.00006700.00000006700.005100.00645.009工程部田田五五一一40002250500000.000.000.000.000.00006750.0020012.535.813037
10、8.36371.704771.70590.7610工程部孙孙健健40002300500000.000.000.000.000.00006800.003202039.62100479.626320.384720.38583.06工工程程部部合合计计4400044000230502305060006000500500300030000 00 00 00 00 00 00 00 00 00 00 00 00 076550.0076550.002118.562118.56132.41132.41444.22444.22126012603955.193955.1972594.8172594.815659
11、4.8156594.817628.067628.060.000.000.000.000.000.001客服中心张立军500020002000000.000.000.000.000.00009000.004002580.625001005.627994.386394.38903.882客服中心伊兵400020001000000.000.000.000.000.00007000.003362135.8200592.86407.204807.20596.083客服中心吴吴军军400020001000000.000.000.000.000.00007000.003202035.8120495.8650
12、4.204904.20610.634客服中心郑郑福福敏敏400020001000000.000.000.000.000.00007000.0018411.535.8120351.36648.705048.70634.745客服中心张张雪雪400020001000000.000.000.000.000.00007000.00112.727.0535.80155.576844.435244.43673.896客服中心薛薛璐璐璐璐400020001000000.000.000.000.000.00007000.002401535.8120410.86589.204989.20623.387客服中心任
13、任楠楠楠楠400020001000000.000.000.000.000.00007000.0028017.535.8100433.36566.704966.70620.018客服中心韩韩雪雪400020001000000.000.000.000.000.00007000.001601035.8100305.86694.205094.20643.849客服中心李李勇勇400020001000000.000.000.000.000.00007000.0020012.535.8100348.36651.705051.70635.3410客服中心徐徐雯雯400020001000000.000.000
14、.000.000.00007000.0036022.535.80418.36581.704981.70622.26客客服服中中心心合合计计4100041000200002000011000110000 00 00 00 00.000.000.000.000.000.000.000.000.000.000 00 00 00 00 00 072000.0072000.002592.722592.72162.05162.05402.82402.82136013604517.594517.5967482.4167482.4151482.4151482.416564.036564.030.000.000
15、 00 01财务部伍国娥500020002000000.000.000.000.000.00009000.00000009000.007400.001105.002财务部高大勇500020001000000.000.000.000.000.00008000.0028017.558.360355.867644.146044.14833.833财务部傅傅小小悦悦产假500020001000000.000.000.000.000.00008000.0064435.80103.87896.206296.20884.244财务部高高芳芳500020001000000.000.000.000.000.00
16、008000.0080535.80120.87879.206279.20880.845财务部刘刘艳艳500020001000000.000.000.000.000.00008000.00724.535.80112.37887.706287.70882.546财务部严严莹莹500020001000000.000.000.000.000.00008000.00144935.80188.87811.206211.20867.247财务部张张洁洁500020001000000.000.000.000.000.00008000.00000008000.006400.00905.00财财务务部部管管理理处
17、处35000350001400014000800080000 00 00 00 00.000.000.000.000.000.000.000.000.000.000 00 00 00 00 00 057000.0057000.006406404040201.56201.560 0881.56881.5656118.4456118.4444918.4444918.446358.696358.690.000.000 00 01财务部张张莹莹300020001000000.000.000.000.000.00006000.002401536.7110401.75598.303998.30474.75
18、2财务部何何金金燕燕300020001000000.000.000.000.000.00006000.002401535.8120410.85589.203989.20473.383财务部李李香香月月300020001000000.000.000.000.000.00006000.002401535.8120410.85589.203989.20473.384财务部杨杨景景刚刚300020001000000.000.000.000.000.00006000.002401535.8120410.85589.203989.20473.385财务部刘刘佳佳佳佳300020001000000.000.
19、000.000.000.00006000.0020012.535.80248.35751.704151.70497.766财务部王王慧慧敏敏300020001000000.000.000.000.000.00006000.00240035.80275.85724.204124.20493.637财务部姜姜三三千千300020001000000.000.000.000.000.00006000.0024015002555745.004145.00496.758财务部曹曹文文燕燕300020001000000.000.000.000.000.00006000.0019212002045796.00
20、4196.00504.409财务部王王凤凤海海300020001000000.000.000.000.000.00006000.0024015002555745.004145.00496.7510财务部李李立立新新300020001000000.000.000.000.000.00006000.0028017.500297.55702.504102.50490.3811财务部赵赵秀秀灵灵300020001000000.000.000.000.000.00006000.0024015002555745.004145.00496.7512财财务务部部车车场场33000330002200022000
21、11000110000 00 00 00 00.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0066000.0066000.002592.002592.00147.00147.00215.70215.70470.00470.003424.703424.7062575.3062575.3044975.3044975.305371.305371.300.000.000.000.000.000.0013质管部朱朱青青50002000200000 00.000.000.000.0
22、00.000.000.000.000.00009000.00318.8819.9382.72400821.538178.476578.47940.69940.6914质管部任任佳佳佳佳400020001000000.000.000.000.000.00007000.00185.5211.649.38280526.56473.504873.50606.0315质管部王王芳芳400020001000000.000.000.000.000.00007000.00151.29.4540.8200401.456598.554998.55624.7816质管部黄黄璜璜400020001000000.000
23、.000.000.000.00007000.00724.535.80112.36887.705287.70682.5417质管部林林文文峰峰400020001000000.000.000.000.000.00007000.00000007000.005400.00705.00质质管管部部合合计计21000210001000010000600060000 00 00 00 00.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0037000.0037000.00727.6072
24、7.6045.4845.48208.70208.70880.00880.001861.781861.7835138.2235138.2227138.2227138.223559.043559.040.000.000.000.000.000.001人事行政部王三500020002000000.000.000.000.000.00009000.0016010001708830.007230.001071.002人事行政部宋月500020001000000.000.000.000.000.00008000.001601052.34230452.347547.665947.66814.533人事行政部
25、王王风风400020001000000.000.000.000.000.00007000.001601035.80205.86794.205194.20663.844人事行政部陈陈炼炼400020001000000.000.000.000.000.00007000.001601036.30206.36793.705193.70663.745人事行政部张张平平400020001000000.000.000.000.000.00007000.001601035.80205.86794.205194.20663.846人事行政部刘力文不发工资400020001000000.000.000.000.0
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 实例 某公司 薪酬 核算 计算 系统
限制150内