2025新个税专项扣除excel计算公式
2025年薪酬管理&工资表(新个税) - Sheet1 Unnamed: 0 Unnamed: 1 薪酬管理&工资表(新个税)基本信息姓名天天丽丽朱朱Unnamed: 2 应出勤天数262626Unnamed: 3 出勤天数302426Unnamed: 4 加班400-------------------------Unnamed: 5 缺勤020-------------------------Unnamed: 6 福利工资加班工资153.84615384615400-------------------------Unnamed: 7 底薪8000900010000Unnamed: 8 全勤200202204Unnamed: 9 奖金200202204Unnamed: 10 补贴200202204Unnamed: 11 津贴60Unnamed: 12 其它10100100Unnamed: 13 应发小计8823.84615384615970610712----......
2025年工资管理系统新个税 - 工资管理系统 1月 儿股份有限责任公司 员 工 工 资 信 息 统 计 表序号123456789Unnamed: 1 工号100001100002100003100004100005100006100007100008100009Unnamed: 2 部门财务部研发部市场部人事部生产部采购部财务部研发部总经办Unnamed: 3 姓名张三三李思思王五五李六六周奇奇猪一二丁一二张一二王四四Unnamed: 4 考勤 天数25Unnamed: 5 出勤 天数25Unnamed: 6 应发金额岗位工资1000096509650Unnamed: 7 工龄工资1000Unnamed: 8 全勤奖500Unnamed: 9 其他奖金0Unnamed: 10 制表人:应扣金额考勤扣款0Unnamed: 11 XXX社保800Unnamed: 12
2025年改革版新个税工资表(函数自动统) - Sheet1 Unnamed: 0 工资表(2018年新个税函数计算) 公司名称:这里添加您的公司名称工号NO-01NO-02NO-03NO-04NO-05NO-06NO-07NO-08NO-09NO-10NO-11NO-12NO-13NO-14NO-15NO-16NO-17NO-18NO-19NO-20NO-21合 计Unnamed: 2 姓名待用1待用2待用3待用4待用5待用6待用7待用8待用9待用10待用11待用12待用13待用14待用15待用16待用17待用18待用19待用20待用21制表:Unnamed: 3 应发工资基本工资800010000450045004500450045003200320032003200320032003200320032003200320032003200320085300Unnamed: 4 岗位工资0200000Unnamed: 5 绩效工资2002002
2025年新个税5000起征收工资表 - 工资表 Unnamed: 0 2018新个税工资表Unnamed: 1 工号12345678910111213141516171819202122--合 计Unnamed: 2 部门Unnamed: 3 姓 名待用1待用2待用3待用4待用5待用6待用7待用8待用9待用10待用11待用12待用13待用14待用15待用16待用17待用18待用19待用20待用21待用22待用23制表:Unnamed: 4 基本工资75008000600060006000600060006000600060006000600060006000600060006000600060006000600060006000141500Unnamed: 5 绩效工资0200000Unnamed: 6 加班费0复核:Unnamed: 7 缺勤扣发0Unnamed: 8 小计75001000060006000600060006000600060006
2025年新个税工资表 - 新个税工资表 2019年10月份职工工资明细表 序号 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748合计Unnamed: 1 姓名 Unnamed: 2 部门Unnamed: 3 职务Unnamed: 4 应发部分基本工资120001500027000Unnamed: 5 岗位工资0Unnamed: 6 绩效工资0Unnamed: 7 工龄工资0Unnamed: 8 加班费0Unnamed: 9 小计1200015000000000000000000000000000000000000000000000000027000Unnamed: 10 应扣部分缺勤扣款0Unnamed: 11 其他扣款0Unnamed: 12 个人综合所得合计12000150000000000000
2025年福利工资表(新个税) - Sheet1 Unnamed: 0 Unnamed: 1 福利工资表(新个税)姓名天天丽丽朱朱Unnamed: 2 应出勤天数262626Unnamed: 3 出勤天数302426Unnamed: 4 加班400-------------------------Unnamed: 5 缺勤020-------------------------Unnamed: 6 加班工资153.84615384615400-------------------------Unnamed: 7 底薪8000900010000Unnamed: 8 全勤200202204Unnamed: 9 奖金200202204Unnamed: 10 补贴200202204Unnamed: 11 备注10100100Unnamed: 12 应发小计8763.84615384615970610712-----------......
2025年新个税工资表 - 工资单 Unnamed: 0 工 资 表 序号12345678910111213141516171819202122232425262728293031323334353637383940合 计Unnamed: 2 姓名李华Unnamed: 3 基本工资2800Unnamed: 4 奖金15001500Unnamed: 5 取暖费12001200Unnamed: 6 加班费860Unnamed: 7 其他补助380380Unnamed: 8 应发数67400006740Unnamed: 9 养老200000200Unnamed: 10 医疗157000157Unnamed: 11 失业200000200Unnamed: 12 公积金200000200Unnamed: 13 税前工资200000000000000000000000200Unnamed: 14 个调税2000000000000000000000......
2025年新个税5000起征收函数工资表(验证正确) - Sheet1 Unnamed: 0 2018年函数工资表(5000起征收点) 公司名称:应发工资姓名代用名1代用名2代用名3代用名4代用名5代用名6代用名7代用名8代用名9代用名10代用名11代用名12代用名13代用名14代用名15代用名16代用名17代用名18审核: 财务总监签字:Unnamed: 2 基本工资600060005000300030003000300030003000300030003000300030003000300030003000Unnamed: 3 岗位工资120012001200120012001200120012001200120012001200120012001200120012001200Unnamed: 4 工龄工资60060060050050030032025新个税专项扣除excel计算公式
2025年员工工资表(新个税方法) - Sheet1 Unnamed: 0 Unnamed: 1 员工工资表员工ID10049767合计Unnamed: 2 姓名张三Unnamed: 3 基本工资40004000Unnamed: 4 绩效工资0Unnamed: 5 实习生工资0Unnamed: 6 业绩提成63846384Unnamed: 7 外派补助450450Unnamed: 8 其他补助100100Unnamed: 9 税前补发500500Unnamed: 10 事假扣款100100Unnamed: 11 病假扣款5050Unnamed: 12 税前扣款6060Unnamed: 13 应发工资112840000000000000000000000011284Unnamed: 14 五险一金代扣450450Unnamed: 15 个人所得税373.400000000000000000000000373.4Unnamed: 16 实发工资10460.600000000000000
2025年新个税工资表 - Sheet1 个税工资表 公司名称:会计:序号1234567891011121314151617181920212223242526272829303132333435363738394041424344454647Unnamed: 1 姓 名李华Unnamed: 2 基本工资4500Unnamed: 3 加班费2980Unnamed: 4 养老保险594Unnamed: 5 失业险124Unnamed: 6 审核人:日 期:医疗保险115Unnamed: 7 工伤险58Unnamed: 8 生育险95Unnamed: 9 公积金955Unnamed: 10 个税扣款198Unnamed: 11 考核扣款0 Unnamed: 12 打卡工资53410000000000000000000000000000000000000000000000Unnamed: 13 签字确认Unnamed: 14 备注
2025年工资表(新个税) - Sheet1 工资表(新个税) 序号制表人: 审核人: 财务主管: 单位负责人:Unnamed: 1 姓名Unnamed: 2 身份证号Unnamed: 3 银行卡账号Unnamed: 4 应发工资Unnamed: 5 五险一金养老Unnamed: 6 失业Unnamed: 7 医疗Unnamed: 8 住房Unnamed: 9 扣个人所得税子女教育Unnamed: 10 继续教育Unnamed: 11 大病医疗Unnamed: 12 住房贷款Unnamed: 13 住房租金Unnamed: 14 赡养老人Unnamed: 15 专项附
2025年工资明细表(新个税) - 累计已发已扣 序号 1.02.03.04.05.06.07.08.09.010.011.012.013.014.015.0姓名 小米累计已发收入 201912应发合计15000Unnamed: 3 202001应发合计Unnamed: 4 202002应发合计Unnamed: 5 202003应发合计Unnamed: 6 202004应发合计Unnamed: 7 202005应发合计Unnamed: 8 202006应发合计Unnamed: 9 202007应发合计Unnamed: 10 202008应发合计Unnamed: 11 202009应发合计Unnamed: 12 202010应发合计Unnamed: 13 202011应发合计Unnamed: 14 累计已发收入1500000000000000000累计免税收入(5000元/月) 本自然年度本人发工资次数1Unnamed: 16 累计免
2025年新个税员工工资发放明细表 - Sheet1 月份工资发放明细表 公司:编号123456789101112131415161718192021222324252627Unnamed: 1 姓名Unnamed: 2 部门Unnamed: 3 基本工资日/金额200Unnamed: 4 天数20Unnamed: 5 金额4000Unnamed: 6 岗位工资1000Unnamed: 7 绩效工资1000Unnamed: 8 车补餐补房补1200Unnamed: 9 其它补贴0Unnamed: 10 合计7200Unnamed: 11 扣出项目社保1000Unnamed: 12 事病事假0Unnamed: 13 公积金0Unnamed: 14 个税扣除36.00000000000001400000000000000000000000000Unnamed: 15 年 月 日实发金额616400000000000000000000000000Unnamed: 16 签
2025年简洁实用新个税工资表 - Sheet1 新个税员工工资表 编号1234567891011121314151617181920分栏合计Unnamed: 1 姓名Unnamed: 2 出勤(天)Unnamed: 3 应发工资基本工资基本工资7000700014000Unnamed: 4 交通饭补50010001500Unnamed: 5 奖金30010001300Unnamed: 6 合计(元)7800900000000000000000000016800Unnamed: 7 应扣工资请假迟到早退000Unnamed: 8 社保200200400Unnamed: 9 公积金5005001000Unnamed: 10 应扣合计7007000000000000000000001400Unnamed: 11 扣税63.00000000000001120000000000000000000183Unnamed: 12 实发工资70378180000000000000
2025年工资表(新个税+自动生成工资条) - Sheet1 Unnamed: 0 员工编号001002003004005006007008009010011012Unnamed: 1 员工姓名赵三李四王文英路斯杨涛张帅刘明姚涛朱六石榴高思李留Unnamed: 2 基本工资600070009000600060007000900060009000600060009000Unnamed: 3 提成5016030048016030030016030030050160Unnamed: 4 奖金200500100200400600500300200400400600Unnamed: 5 福利费15001700300400400420440460480500520540Unnamed: 6 合计77509360970070806960832010240692099807200697010300Unnamed: 7 考勤扣款420240420000000000Unnamed: 8 五险一金扣除620340550340550665.634
2025年财务报表-员工工资表(带新个税 - Sheet1 Unnamed: 0 Unnamed: 1 员工工资表(带新个税)单位名称:序号12345678910111213合计Unnamed: 2 姓名Unnamed: 3 职位Unnamed: 4 在职天数Unnamed: 5 应发工资基本工资80005000300020008000600032000Unnamed: 6 岗位工资300Unnamed: 7 加班工资0Unnamed: 8 其他津贴Unnamed: 9 合计830050003000200080006000000000032300Unnamed: 10 其他扣款迟到Unnamed: 11 早退Unnamed: 12 病扣......2025新个税专项扣除excel计算公式
2025年人事薪酬工资表(新个税)免费下载 - Sheet1 Unnamed: 0 Unnamed: 1 工 资 表(新个税)基 本 信 息姓名天天丽丽朱朱合计Unnamed: 2 入职时间2017-01-07 00:00:002016-01-08 00:00:002015-01-09 00:00:00Unnamed: 3 工龄123000000000000000000000000Unnamed: 4 出勤天数262626Unnamed: 5 员 工 福 利 加班工资Unnamed: 6 基本工资360030001000Unnamed: 7 岗位补贴200202204Unnamed: 8 绩效补贴200202......
2025年新个税职工工资表免费下载 - Sheet1 新个税职工工资表 序号1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374......
2025年新个税工资核算表免费下载 - Sheet1 Unnamed: 0 新个税工资核算表 姓名李华Unnamed: 2 基本工资35003500Unnamed: 3 加班工资18001800Unnamed: 4 全勤奖12001200Unnamed: 5 车补600600Unnamed: 6 其它0Unnamed: 7 应发工资71000000000000000000007100Unnamed: 8 五险一金0Unnamed: 9 缺勤扣款0Unnamed: 10 违纪罚款0Unnamed: 11 其它扣款0Unnamed: 12 税前工资710000000000