原创 excel 工资表

saiqibaleno

ddddddddddddd

天才白痴

vb

w1098

看看，学习

w1098

<p>好象有点错误呀，你的个税扣多了。</p><p><table cellspacing="0" cellpadding="0" width="581" border="0" xstr="" style="WIDTH: 436pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="69" style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2208;"></col><col width="187" style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 5984;"></col><col width="88" style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 2816;"></col><col width="108" style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3456;"></col><col width="129" style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4128;"></col></colgroup><tbody><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl24" width="69" height="26" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 52pt; BORDER-BOTTOM: #ffffff; HEIGHT: 19.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.</font></td><td width="512" colspan="4" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 384pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体">应纳个人所得税额=（<font class="font6" color="#ff0000">应纳税所得额</font><font class="font0">-扣除标准）*适用税率-速算扣除数</font></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td colspan="4" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td align="right" height="26" xnum="" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 19.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">2</font></td><td class="xl25" colspan="4" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"><font color="#ff0000">.应纳税所得额</font><font class="font0">=当月总收入-五险一金后的余额</font></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td colspan="4" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="24" style="HEIGHT: 18pt; mso-height-source: userset;"><td align="right" height="24" xnum="" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 18pt; BACKGROUND-COLOR: transparent;"><font face="宋体">3</font></td><td class="xl25" colspan="4" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"><font color="#ff0000">.五险</font><font class="font0">是：养老保险，事业保险，医疗保险，工伤保险和生育保险，</font></font></td></tr><tr height="23" style="HEIGHT: 17.25pt; mso-height-source: userset;"><td height="23" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td colspan="4" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td align="right" height="26" xnum="" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 19.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">4</font></td><td class="xl25" colspan="4" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"><font color="#ff0000">.一金</font><font class="font0">是：住房公积金</font></font></td></tr><tr height="21" style="HEIGHT: 15.75pt; mso-height-source: userset;"><td height="21" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td colspan="4" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="25" style="HEIGHT: 18.75pt; mso-height-source: userset;"><td align="right" height="25" xnum="" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">5</font></td><td colspan="4" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体">.2008年3月1日起征点调整为2000元</font></td></tr></tbody></table></p>

[此贴子已经被作者于2008-9-2 15:19:54编辑过]

honjo1

<p>看看</p><p></p>

hcyun2007

<p>well</p>

lixuesong

学习

jsfdl

rhf rhf

leodan

<a href="http://www.excelpx.com/dispbbs.asp?BoardID=38&amp;replyID=744908&amp;ID=60288&amp;skin=1"><font size="+0">看看</font></a>

zlzm123

,