全部
搜索
稻壳儿首页 >

表格模板

 >当前作品

新税法工资自动化核算系统

收藏
  • 新税法工资自动化核算系统-表格模板XXXX有限公司工资核算系统,（全自动核算 新税法 按年核算个税 包含专项扣除计算）,power by XXX有限公司人力资源部,,员工当月工资查询页,当前月份11.0,应发款项本月专项应扣款项个税应扣合计实发款项,请输入姓名计薪天数基本工资岗位技能工资工龄工资话费补贴津贴综合工资应发,工资提成/奖金加班费应发全勤奖其他应发本月应发合计社保个人缴纳公积金个人缴纳本月罚款本月其他扣款本月专项应扣小计全年累计应缴个税上月累计已缴本月应缴本月应扣合计实发工资,四舍五入,员工121.01800.04700.0500.0200.07200.07200.0100.07300.0393.0700.01093.0499.0365.833333333133.1666666671226.166666676074.0,,XXXXXXX有限公司2020年11月工资表（自动核算）,44136.0————44165.0当月满勤月份11.0,基本信息应发款项本月专项应扣款项累计专项扣除专项附加扣除累计个税应扣合计实发款项,序姓名手机入职日期计薪天数基本工资岗位技能工资工龄工资话费补贴津贴综合工资应发,工资提成/奖金加班费应发全勤奖其他应发本月应发合计当前年度累计应发合计社保个人缴纳公积金个人缴纳本月罚款本月其他扣款本月专项应扣小计当前累计专项扣除当前专项附加扣除累计全年累计应缴个税上月累计已缴本月应缴本月应扣合计实发工资,四舍五入,员工140238.04700.0500.079920.0700.01093.08283.0499.0365.833333333133.1666666671226.166666676074.0,2.0员工241334.0500.010700.010700.010800.0103400.0700.01093.021163.0817.0630.833333333186.1666666671279.166666679521.0,3.0员工342430.05400.07700.06966.666666676966.6666666760388.30476196224.0,4.0员工442461.07500.07500.067203.251300.01693.08763.01693.05907.0,5.0员工542651.03000.015600.014114.285714314114.2857143124687.61904814813.040700.0425.0304.166666667120.833333333863.83333333313250.0,6.0员工642694.04800.01001.379310348301.3793103463671.62931037928.0765.07536.0,7.0员工742718.020.031255800.08000.07630.95238095999.08629.9523809579849.9523811393.013573.01401.07229.0,员工842842.019.58900.08264.285714298264.2857142972672.857142922000.07521.0,9.0员工943019.09400.09400.0626.89655172410126.896551780304.8965517600.08173.0514.0378.333333333135.6666666671128.666666678998.0,10.0员工1043036.020.010400.09904.7619047614904.761904887623.8095238741.0577.5163.5906.513998.0,11.0员工1143045.04400.0162.4827586216862.4827586257530.98275866119.0,12.0员工1243053.05400.0913.6551724148613.6551724166967.905172436000.07871.0,13.0员工1343085.017700.019800.019800.019900.0173680.020923.03956.03246.66666667709.3333333331452.3333333318448.0,14.0员工1443094.018.687514700.016800.014950.014950.0131510.68452426923.02439.01982.5456.51199.513751.0,15.0员工1543164.019.06254400.06500.05900.297619055900.2976190552092.34523815157.0,16.0员工1643167.01411.0344827612811.034482898916.034482821000.0450.0325.0125.0868.011943.0,17.0员工1743186.05200.07400.063020.06657.0,18.0员工1843186.020.8758700.010800.010735.714285710735.714285791576.1904762860.0666.666666667193.333333333936.3333333339799.0,员工1943189.020.514700.016800.0137961.9047626000.04384.03603.33333333780.6666666671523.6666666714876.0,20.0员工2043199.04500.055420.05500.05957.0,员工2143202.020.87700.09800.09706.666666679706.6666666781804.7619048566.0421.666666667144.333333333887.3333333338819.0,员工2243210.05200.0301.7241379317701.7241379362952.0991379744.06958.0,23.0员工2343215.0310.34482758612710.3448276106330.34482816500.0807.0622.5184.5927.511783.0,24.0员工2443222.010000.02471.8965517214671.8965517105593.8965521747.01405.83333333341.1666666671084.1666666713588.0,25.0员工2543241.05700.0743.5344827598643.5344827666249.116004516500.07901.0,26.0员工2643256.019.06256200.08300.07534.226190487534.2261904865493.27380958923.047.047.0790.06744.0,27.0员工2743278.018500.018500.018600.0157870.755875.04845.833333331029.166666671772.1666666716828.0,28.0员工2843297.0475.86206896612875.862069106495.8620691837.01480.83333333356.1666666671099.1666666711777.0,29.0员工2943339.012400.012400.01060.3448275913560.3448276100980.3448281286.01021.66666667264.3333333331007.3333333312553.0,30.0员工3043436.04700.06800.054146.43002727607.987684736057.0,31.0员工3143458.019.756900.06489.285714296489.2857142955128.33333337456.147783259000.05746.0,32.0员工3243481.082317.39130437304.30788177270.0175.095.0838.010462.0,33.0员工3343580.019.97513200.012555.714285712555.7142857109203.3333337152.4679803422.0299.166666667122.833333333865.83333333311690.0,34.0员工3443598.011400.0104660.0900.01293.07550.62807882933.0727.5205.51498.59902.0,35.0员工3543655.0504.3103448289804.3103448387320.31034486848.78817734764.0586.666666667177.333333333920.3333333338884.0,36.0员工3643685.09700.09700.01489.6551724111289.655172498993.65517246696.948275861210.0958.333333333251.666666667994.66666666710295.0,37.0员工3743690.03000.01036.551724146036.5517241451196.55172416545.108374385294.0,38.0员工3843691.0889.65517241413089.6551724123499.6551726393.268472913691.03025.83333333665.1666666671408.1666666711681.0,39.0员工3943696.012200.0119730.06241.4285714316000.01729.01423.33333333305.6666666671048.6666666711151.0,40.0员工4043731.010100.010100.0491.37931034510691.379310387311.37931036089.58866995787.0605.833333333181.166666667924.1666666679767.0,41.0员工4143746.07100.07100.065792.72727275937.74876847146.071.666666666774.3333333333817.3333333336383.0,42.0员工4243746.012.02200.04100.02342.857142862342.8571428654224.6753247600.06035.9088671350.0,43.0员工4343747.06100.05519.047619055519.0476190571648.13852815634.068965529000.060.060.0803.04716.0,44.0员工4443752.08600.010500.010500.010600.088040.05482.22906404827.0639.166666667187.833333333930.8333333339669.0,合计79200.0341100.09300.04100.0438700.0427814.76190513890.70689662900.0999.0450604.46880117292.018750.036042.0388208.625616385200.038120.030391.66666677728.3333333343770.3333333406834.0,制表：财务部复核：总经理审批：,,员工基本信息及薪资设置,核算起始日期 必填 填写不正确将影响核算结果,当前工资核算周期44136.0至44165.0,姓名手机部门岗位入职日期是否,转正拟定薪资基本工资岗位技能工资工龄工资话费补贴津贴综合工资提成/奖金其他应发本月罚款本月其他扣款备注工龄工资年增长额工龄工资封顶年数,员工140238.04700.0500.05.0,员工241334.0500.010700.0,员工342430.05400.07700.0,员工442461.01000.07500.0,员工542651.03000.015600.0,员工642694.04800.0,员工742718.07600.05800.08000.0999.0补发上月欠款,员工842842.08500.08900.0,员工943019.09000.09400.0,员工1043036.010400.05000.0,员工1143045.04400.0,员工1243053.05400.07600.0,员工1343085.019500.017700.019800.0,员工1443094.016500.014700.016800.0,员工1543164.04400.0,员工1643167.011300.0,员工1743186.07000.05200.07300.0,员工1843186.010500.08700.010800.0,员工1943189.016500.014700.016800.0,员工2043199.06300.04500.0,员工2143202.09500.07700.09800.0,员工2243210.07000.05200.07300.0,员工2343215.012300.0,员工2443222.011800.0,员工2543241.07500.05700.07800.0,员工2643256.08000.08300.0,员工2743278.018200.016400.018500.0,员工2843297.012300.0,员工2943339.012400.0,员工3043436.04700.0,员工3143458.04900.06900.0,员工3243481.011200.0,员工3343580.013000.011200.013200.0,员工3443598.011300.0,员工3543655.09000.0,员工3643685.09600.07800.09700.0,员工3743690.04800.03000.04900.0,员工3843691.0,员工3943696.0,员工4043731.010100.0,员工4143746.01000.07100.0,员工4243746.04000.02200.04100.0,员工4343747.06100.0,员工4443752.010400.08600.010500.0,,员工出勤数据及加班费核算,单位：天本月满勤天数含公休,姓名入职日期当月应出勤实际出勤计薪天数加班总时长平时加班1.5倍核算加班费周末加班2倍核算加班费法定节假日加班3倍核算加班费加班费工资基数(默认为员工拟定薪资)法定平均月工作天数每天基数加班费应发用于存休(除法定节假日外，可不计加班费调休)全勤奖备注全勤奖标准设置,员工140238.06500.0298.850574713,员工241334.0,员工342430.07200.0331.034482759,员工442461.0,员工542651.0,员工642694.023.152.152.00.156600.0303.4482758621001.37931034,员工742718.020.0312520.031257600.0349.425287356,员工842842.019.519.58500.0390.804597701,员工943019.022.0051.0051.019000.0413.793103448626.896551724,员工1043036.020.020.0,员工1143045.021.3750.386200.0285.057471264162.482758621,员工1243053.022.3751.3751.387200.0331.034482759913.655172414,员工1343085.019500.0896.551724138,员工1443094.018.687518.687516500.0758.620689655,员工1543164.06200.0285.057471264,员工1643167.021.931250.931250.931411.03448276,员工1743186.022.3751.3757000.0321.839080461.38,员工1843186.020.87520.87510500.0482.75862069,员工1943189.020.520.516500.0758.620689655,员工2043199.06300.0289.655172414,员工2143202.020.820.89500.0436.781609195,员工2243210.021.6250.6250.6257000.0321.83908046301.724137931,员工2343215.021.375310.344827586,员工2443222.024.03753.03753.037511800.0542.5287356322471.896551720.0025,员工2543241.022.43751.43751.43757500.0344.827586207743.5344827590.0025,员工2643256.08000.0367.816091954,员工2743278.018200.0836.781609195,员工2843297.021.5750.5750.575475.862068966-0.005,员工2943339.022.281251.281251.281251060.34482759-0.00125,员工3043436.06500.0298.850574713,员工3143458.019.7519.756700.0308.045977011,员工3243481.0,员工3343580.019.97519.97513000.0597.701149425,员工3443598.0,员工3543655.021.81250.81250.81259000.0413.793103448504.310344828-0.0025,员工3643685.023.252.252.259600.0441.3793103451489.65517241,员工3743690.024.131253.131253.131254800.0220.6896551721036.55172414-0.00125,员工3843691.022.0751.0751.075889.655172414,员工3943696.0,员工4043731.021.71250.71250.7125491.379310345-0.0025,员工4143746.0,员工4243746.012.012.04000.0183.908045977,员工4343747.0,员工4443752.010400.0478.16091954,,员工全年个税管理表,姓名1月已缴2月已缴3月已缴4月已缴5月已缴6月已缴7月已缴8月已缴9月已缴10月已缴11月已缴12月已缴上月累计已缴,员工1365.833333333,员工2630.833333333,员工3,员工4,员工5304.166666667,员工6,员工7,员工8,员工9378.333333333,员工10577.5,员工11,员工12,员工133246.66666667,员工141982.5,员工15,员工16325.0,员工17,员工18666.666666667,员工193603.33333333,员工20,员工21421.666666667,员工22,员工23622.5,员工241405.83333333,员工25,员工26,员工274845.83333333,员工281480.83333333,员工291021.66666667,员工30,员工31,员工32175.0,员工33299.166666667,员工34727.5,员工35586.666666667,员工36958.333333333,员工37,员工383025.83333333,员工391423.33333333,员工40605.833333333,员工4171.6666666667,员工42,员工43,员工44639.166666667,,全年累计应发工资统计表,姓名1月2月3月4月5月6月7月8月9月10月11月12月本月应发合计当前年度累计应发合计,员工17510.07510.07300.079920.0,员工211000.020000.010800.0103400.0,员工37023.27023.26966.6666666760388.3047619,员工47401.6257401.6257600.067203.25,员工512220.012220.014114.2857143124687.619048,员工67205.1257205.1258301.3793103463671.6293103,员工77610.07610.08629.9523809579849.952381,员工88990.08990.08264.2857142972672.8571429,员工98689.08689.010126.896551780304.8965517,员工108550.08550.014904.761904887623.8095238,员工116774.256774.256862.4827586257530.9827586,员工127817.1257817.1258613.6551724166967.9051724,员工1321490.021490.019900.0173680.0,员工1416455.937516455.937514950.0131510.684524,员工156611.56611.55900.2976190552092.3452381,员工1610612.510612.512811.034482898916.0344828,员工177410.07410.07400.063020.0,员工1810400.010400.010735.714285791576.1904762,员工1914900.014900.016400.0137961.904762,员工205920.05920.06700.055420.0,员工219706.6666666781804.7619048,员工227225.18757225.18757701.7241379362952.0991379,员工2312710.3448276106330.344828,员工2411621.011621.014671.8965517105593.896552,员工257002.790760877002.790760878643.5344827666249.1160045,员工267920.07920.07534.2261904865493.2738095,员工2717875.37517875.37518600.0157870.75,员工2812875.862069106495.862069,员工2913560.3448276100980.344828,员工305073.215013595073.215013596800.054146.4300272,员工315510.05510.06489.2857142955128.3333333,员工324308.695652174308.6956521711300.082317.3913043,员工3313320.013320.012555.7142857109203.333333,员工3415030.015030.011400.0104660.0,员工3513158.013158.09804.3103448387320.3103448,员工369200.09200.011289.655172498993.6551724,员工375940.05940.06036.5517241451196.5517241,员工3814177.014177.013089.6551724123499.655172,员工3913881.013881.012200.0119730.0,员工4010310.010310.010691.379310387311.3793103,员工418496.363636368496.3636363665792.7272727,员工4219540.909090919540.90909092342.8571428654224.6753247,员工4317864.545454517864.54545455519.0476190571648.1385281,员工449600.09600.010600.088040.0,,全年专项扣除累计统计,姓名1月2月3月4月5月6月7月8月9月10月11月12月本月专项应扣小计当前累计专项扣除,员工11093.08283.0,员工21093.021163.0,员工3,员工41693.08763.0,员工514813.0,员工67928.0,员工71393.013573.0,员工8,员工9993.08173.0,员工10,员工11,员工12,员工1320923.0,员工1426923.0,员工15,员工16,员工17,员工18,员工19,员工20,员工21,员工22,员工23,员工24,员工25,员工268923.0,员工27,员工28,员工29,员工307607.98768473,员工317456.14778325,员工327304.30788177,员工337152.4679803,员工341293.07550.62807882,员工356848.78817734,员工366696.94827586,员工376545.10837438,员工386393.26847291,员工396241.42857143,员工406089.58866995,员工415937.74876847,员工42993.06035.908867,员工435634.06896552,员工445482.22906404,,员工全年专项附加扣除统计表,姓名1-10月已扣子女教育支出e继续教育支出f住房贷款利息支出g住房租金支出h赡养老人支出j11月合计当前专项附加扣除累计,员工1,员工2,员工3,员工4,员工537000.0700.03700.040700.0,员工6,员工7,员工820000.022000.0,员工9,员工10,员工11,员工1232000.04000.036000.0,员工13,员工14,员工15,员工1619000.021000.0,员工17,员工18,员工195000.06000.0,员工205000.05500.0,员工21,员工22,员工2315000.016500.0,员工24,员工2515000.016500.0,员工26,员工27,员工28,员工29,员工30,员工31,员工32,员工33,员工34,员工35,员工36,员工37,员工38,员工3914000.016000.0,员工40,员工41,员工42,员工43,员工44,,2020年11月社保缴纳情况,序号姓名账户状态申报工资社保个人缴纳员工个人社保缴纳部分可登录当地人社政务网查询导出，请根据当地实际情况进行填写,1.0员工1,2.0员工2,3.0员工3,4.0员工4,5.0员工5,6.0员工6,7.0员工7,8.0员工8,9.0员工9,10.0员工10,11.0员工11,12.0员工12,13.0员工13,14.0员工14,15.0员工15,16.0员工16,17.0员工17,18.0员工18,19.0员工19,20.0员工20,21.0员工21,22.0员工22,23.0员工23,24.0员工24,25.0员工25,26.0员工26,27.0员工27,28.0员工28,29.0员工29,30.0员工30,31.0员工31,32.0员工32,33.0员工33,34.0员工34,35.0员工35,36.0员工36,37.0员工37,38.0员工38,39.0员工39,40.0员工40,41.0员工41,42.0员工42,43.0员工43,44.0员工44,合计17292.0,,2020年11月公积金汇缴情况,序号姓名账户状态缴纳基数汇缴比例月缴存额单位缴纳公积金个人缴纳,1.0员工17000.01400.0,2.0员工27000.01400.0,3.0员工3,4.0员工413000.02600.01300.01300.0,5.0员工5,6.0员工6,7.0员工710000.02000.01000.01000.0,8.0员工8,9.0员工96000.01200.0,10.0员工10,11.0员工11,12.0员工12,13.0员工13,14.0员工14,15.0员工15,16.0员工16,17.0员工17,18.0员工18,19.0员工19,20.0员工20,21.0员工21,22.0员工22,23.0员工23,24.0员工24,25.0员工25,26.0员工26,27.0员工27,28.0员工28,29.0员工29,30.0员工30,31.0员工31,32.0员工32,33.0员工33,34.0员工349000.01800.0900.0900.0,35.0员工35,36.0员工36,37.0员工37,38.0员工38,39.0员工39,40.0员工40,41.0员工41,42.0员工426000.01200.0,43.0员工43,44.0员工44,合计37500.018750.018750.0
  • 新税法工资自动化核算系统-表格模板
  • 新税法工资自动化核算系统-表格模板
  • 新税法工资自动化核算系统-表格模板
模板介绍：
这个模板还没有相关介绍

关注稻壳领福利

相关推荐 查看更多
人事财务核算工资表-自动计算.xls
人事财务核算工资表-自动计算.xls

人事财务核算工资表-自动计算

小微企业自动核算工资表.xlsx
小微企业自动核算工资表.xlsx

小微企业自动核算工资表

工资核算表.xlsx
工资核算表.xlsx

工资核算表

工资单-全自动化表格.xls
工资单-全自动化表格.xls

工资单-全自动化表格

工资管理系统（自动生成工资条）.xlsx
工资管理系统（自动生成工资条）.xlsx

工资管理系统（自动生成工资条）

工资核算表.xlsx
工资核算表.xlsx

工资核算表

工资表-自动化核算工资表.xlsx
工资表-自动化核算工资表.xlsx

工资表-自动化核算工资表

工资表（自动核算）.xlsx
工资表（自动核算）.xlsx

工资表（自动核算）

工资核算表.xlsx
工资核算表.xlsx

工资核算表

实用自动计算工资表.xlsx
实用自动计算工资表.xlsx

实用自动计算工资表

全面自动化管理工资表.xlsx
全面自动化管理工资表.xlsx

全面自动化管理工资表

工资表（自动化计件工资表）.xlsx
工资表（自动化计件工资表）.xlsx

工资表（自动化计件工资表）

模板单价：￥29.99
开通会员可免费下载任意模板与19项权益包
登录后使用
以29.99元购买此模板
  • 页数：11页
  • 时间：2020-10-10
  • 编号：20470769
  • 类型：VIP模板
  • 格式：et
  • 提示：数字产品不支持退货
    数字产品本身（包括但不限于文字模板、表格模板、演示模板等）及其包含的全部素材 （包括但不限于字体、图片、图标、文本框、艺术字等）均不支持商用，仅能为个人学习、研究或欣赏目的使用。

听雨轩工作室

设计作品7

举报

猜你在找

    我的

    关注稻壳领福利

    福利

    反馈

    微信咨询在线客服

    客服