如何做好年度工资统计
<P>各位大侠,请教一下如何做好年度工资统计呀.比如我们有分基本工资、技能工资、业绩工资、工龄补贴、津贴补贴、降温费、其他列。员工太多了,不知如何做好各项工资的统计呢,有表格附件最好,谢谢各位了,小女子很心急,希望各位大侠的帮助哦!!!!</P><P> </P>
<P>
<TABLE style="WIDTH: 794pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1056 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1440" width=45>
<COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2368" width=74>
<COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 2944" width=92>
<COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 1952" width=61>
<COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 1920" width=60>
<COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 1952" span=2 width=61>
<COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2080" width=65>
<COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2016" width=63>
<COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1472" width=46>
<COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2368" width=74>
<COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1888" span=3 width=59>
<COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2656" width=83>
<COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3008" width=94>
<TBODY>
<TR style="HEIGHT: 24.75pt; mso-height-source: userset" height=33>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 34pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" width=45 height=33><FONT face=宋体 size=2>序号</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=74><FONT face=宋体 size=2>姓名</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 69pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=92><FONT face=宋体 size=2>岗位</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 46pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=61><FONT face=宋体 size=2>基本工资</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 45pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=60><FONT face=宋体 size=2>技能工资</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 46pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=61><FONT face=宋体 size=2>业绩工资</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 46pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=61><FONT face=宋体 size=2>其他</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 49pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=65><FONT face=宋体 size=2>烟龄补贴</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 47pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=63><FONT face=宋体 size=2>津贴补贴</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=46><FONT face=宋体 size=2>加班费</FONT></TD>
<TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=74><FONT face=宋体 size=2>应发合计</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=59><FONT face=宋体 size=2>扣缴住房公积金</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=59><FONT face=宋体 size=2>扣缴医保</FONT></TD>
<TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=59><FONT face=宋体 size=2>其他扣款</FONT></TD>
<TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 62pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=83><FONT face=宋体 size=2>统筹金</FONT></TD>
<TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 71pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=94><FONT face=宋体 size=2>实发合计</FONT></TD></TR></TBODY></TABLE></P>
回复:如何做好年度工资统计
没人回呀
页:
[1]