《Excel模板：工資管理系統(tǒng)(簡單實用).xlsx》由會員分享，可在線閱讀，更多相關《Excel模板：工資管理系統(tǒng)(簡單實用).xlsx（122頁珍藏版）》請在匯文網上搜索。

1、職工基本信息基本工資表社會保險表考勤表計算比率表員工福利表工資結算表獎金計算表工資條工資管理系統(tǒng)(簡單實用版）員工查詢表使用說明工資管理系統(tǒng)(簡單實用版）職工基本信息表編號姓 名部門職務參加工作時間性別出生日期身份證號碼A001張三董事會董事長2015/1/1男1992/1/1A002李四行政部部門經理2005/1/1男1984/1/1戶口所在地聯系電話E-mail銀行賬號返回主頁職工福利費一覽表編號姓 名部門住房補貼伙食補貼交通補貼醫(yī)療補助A001張三董事會200010002000500A002李四行政部80060010003000000000000000000000000000000000

2、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

3、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000合計5500270000000000000000000000000000返回主頁000000

4、0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000工資計算比率表社會保險及住房公積金獎金計算標準扣繳比例項目單位個人出勤情況每天扣款（元）養(yǎng)老保險20%8%全勤0醫(yī)療保險8%2%病假15失業(yè)保險2%1%事假30住房公積金12%12%曠工60個人應稅所得稅工資費用分配表起征點2000項目扣除比例應稅所得額=應發(fā)合計-起征點職

5、工福利費14%級數全月應納稅所得額稅率速扣數工會經費2%1不超過500元的部分5.00%0教育經費2.5%2超過500元2000元的部分10.00%253超過2000元5000元的部分15.00%1254超過5000元20000元的部分20.00%375工齡工資計算標準5超過20000元40000元的部分25.00%1375年限每年金額6超過40000元60000元的部分30.00%33751307超過60000元80000元的部分35.00%63758超過80000元100000元的部分40.00%103759超過100000元的部分45.00%15375最高限500返回主頁獎金計算標準工資

6、費用分配表工齡工資計算標準職工工資一覽表編號姓 名部門基礎工資崗位工資工齡工資計劃獎金A001張三董事會200001000090500A002李四行政部60002000390150000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050

7、000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050

8、000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050

9、000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050

10、0000500000500000500000500000500000500000500000500000500000500000500000500工資合計300908390500500500500500500500500500500500500500500500500500500500500500500500500500500500500返回主頁500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500

11、500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500

12、500500500500500500500500500500500500500500500500500500500500500500500500500500500職工社會保險繳納情況一覽表編號姓 名部門養(yǎng)老保險醫(yī)療保險失業(yè)保險A001張三董事會2407.20601.80300.90A002李四行政部671.20167.8083.9000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005

13、.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.00

14、10.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000

15、040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.00

16、5.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.00000