工资单计算的模板示例

admin · 发表于 2009-5-1 09:57:00

适用于魔方网表3.6.2.0001以上版本
个税计算公式参照
http://hi.baidu.com/lbb0917/blog/item/2231bf233907ca4cac34dead.html
个税起征点为2000
如有错失，欢迎大家提出。此模板主要是为了演示计算功能，未在实际工作中使用。
请下载附件导入查看

<table cellspacing="0" cellpadding="0" width="800" border="1">
<tbody>
<tr>
<td>姓名</td>
<td>月份</td>
<td>定级工资</td>
<td>四险一金扣款</td>
<td>考勤扣款</td>
<td>其他扣款</td>
<td>扣除后工资金额</td>
<td>应缴个税</td>
<td>实发工资</td>
</tr>
<tr>
<td>$MF(姓名)$</td>
<td> $MF(月份)$</td>
<td>$MF(定级工资)$</td>
<td>$MF(四险一金扣款)$</td>
<td>$MF(考勤扣款)$</td>
<td>$MF(其他扣款)$</td>
<td>
<div id="kchje"> </div>
</td>
<td>
<div id="yjgs"> </div>
</td>
<td>
<div id="sfgz"> </div>
</td>
</tr>
</tbody>
</table>
<p> </p>
<script language="javascript">
var djgz = $MF(定级工资)$;
var sxyjkk = $MF(四险一金扣款)$;
var kqkk = $MF(考勤扣款)$;
var qtkk = $MF(其他扣款)$;
var kchje = djgz - sxyjkk - kqkk - qtkk;
//2000为起征点
var jsje = kchje - 2000;
//计算个人所得税
var yjgs = 0;
if(jsje < 0) yjgs = 0
else if (jsje >0 && jsje <= 500) yjgs = jsje*0.05
else if (jsje >500 && jsje <= 2000) yjgs = jsje*0.1 - 25
else if (jsje >2000 && jsje <= 5000) yjgs = jsje*0.15 - 125
else if (jsje >5000 && jsje <= 20000) yjgs = jsje*0.2 - 375
else if (jsje >20000 && jsje <= 40000) yjgs = jsje*0.25 - 1375
else if (jsje >40000 && jsje <= 60000) yjgs = jsje*0.3 - 3375
else if (jsje >60000 && jsje <= 80000) yjgs = jsje*0.35 - 6375
else if (jsje >80000 && jsje <= 100000) yjgs = jsje*0.4 - 10375
else if (jsje >100000) yjgs = jsje*0.45 - 15375;
var sfgz = kchje - yjgs;
document.getElementById("kchje").innerHTML = kchje;
document.getElementById("yjgs").innerHTML = yjgs;
document.getElementById("sfgz").innerHTML = sfgz;
</script>

复制代码

工资单计算.mfd (2.52 KB, 下载次数: 2090)

		自动登录	找回密码
密码			注册

[原创] 工资单计算的模板示例

浏览过的版块