工资核算表 工资表工资核算系统.xlsx

工资核算系统税率表查询员工工资员工资料表银行发放表考勤统计表工资条工资明细表工资凭证表部门汇总设计说明部门汇总设计说明个人所得税税率表序号应纳税工薪范围上限范围扣税百分率扣除数起征额1-3%-3,500.0021,500.0010%105.0034,500.0020%555.0049,000.0025%1,005.00535,000.0030%2,755.00655,000.0035%5,505.00780,000.0045%13,505.0089不超过1500元的超过1500元至4500元部分超过4500元至9000元部分超过9000元至35000元部分超过35000元至55000元部分超过55000元至80000元部分超过80000元部分员工基础资料表员工代码姓名部门卡号进厂时间基础工资绩效工资工龄工资16001卞悦涵办公室60138261080000012342003-02-193,300.002,500.001,050.0016002陈鸿博办公室60138261080000012351999-12-063,300.002,900.001,200.0016003陈泽宇办公室60138261080000012362003-11-271,900.001,500.001,000.0016004方艺瞳办公室60138261080000012372005-07-241,300.003,300.00900.0016005何汶泽技术部60138261080000012382002-05-072,000.003,200.001,100.0016006黄潇雅技术部60138261080000012392003-02-053,300.003,200.001,050.0016007黄梓钰技术部60138261080000012402005-03-012,600.002,700.00950.0016008吉言技术部60138261080000012412004-02-294,000.003,500.001,000.0016009蒋鹏博技术部60138261080000012422000-10-172,000.002,800.001,150.0016010李博文营销部60138261080000012432005-04-302,600.002,800.00950.0016011李畅营销部60138261080000012442005-03-104,000.003,600.00950.0016012李方宇营销部60138261080000012452000-06-082,000.002,900.001,200.0016013李如好营销部60138261080000012462003-02-261,300.002,900.001,050.0016014李祥瑞营销部60138261080000012472002-04-193,300.002,400.001,100.0016015李宣蓉人力资源部60138261080000012482003-10-114,000.003,000.001,000.0016016李宇泽人力资源部60138261080000012492003-02-122,000.002,800.001,050.0016017李梓睿人力资源部60138261080000012501999-12-311,300.003,500.001,200.0016018林圣智人力资源部60138261080000012522001-10-173,300.003,100.001,100.0016019林芯羽人力资源部60138261080000012532004-08-162,600.002,500.00950.00考勤统计表员工代码姓名部门通讯补助16001卞悦涵办公室24240.9150.0016002陈鸿博办公室2424116003陈泽宇办公室241230.9516004方艺瞳办公室24240...