XLS《样板》

"业务种类","单位账号","缴存人数","总汇缴额","个人总汇缴额" "个人开户","123456","3","5912","3372" "姓名","证件类型","证件号码","婚姻状况","是否本地户籍","工资","缴存基数","汇缴额","单位汇缴比例","个人汇缴比例","单位汇缴额","个人汇缴额","用工单位编号","手机号码" "韩*","01","2*X","10","1","5000","5000","850","8","9","400","450",,

"1*5" "李**","01","2*6","20","0","2000","2100","378","8","10","168","210",,

"1*8" "王*","02","1*5","20","0","30000","24654","4684","8","11","1972","2712","1","1*9" "说明:" "(1)业务种类:单元格式为"文本"格式,左对齐;

本表格适用于住房公积金批量新开个人户及批量变更新开户业务,按业务种类填写;

"(2)单位登记号:单元格式为"文本"格式,左对齐;

填写住房公积金中心经办网点核定的本单位在公积金系统中的登记号,共六位.

"(3)汇缴人数:单元格式为"文本"格式,左对齐;

单位办理开户时首次为职工设立个人账户的总人数;

"(4)总汇缴额:单元格式为"数值"格式,单元格右对齐,四舍五入到元位,是单位和个人的月缴存额总和:总汇缴额=单位月汇缴总额+个人月汇缴总额;

"(5)个人总汇缴额:单元格式为"数值"格式,单元格右对齐,四舍五入到元位,是所有职工月缴存额的合计;

"(6)姓名:单元格式为"文本",单元格式左对齐,如实填写,姓名字符中间不能录空格;

"(7)证件类型:单元格式为"文本",单元格式左对齐,证件类型按"01-身份证;

02-军官证;

03-护照;

04-外国人永久居留证;

05-居留证;

06-居住证;

99-其他"填写数字;

特殊说明:对于"警官证"和"文职干部证"均划归到军官证中;

"(8)证件号码:单元格式为"文本",单元格式左对齐,身份证按18位数字如实填写,英文字母"X"为大写格式;

"(9)婚姻状况:单元格式为"数值",单位格式左对齐,婚姻状况类型按"10-未婚;

20-已婚;

30-丧偶;

40-离婚;

90-未说明的婚姻情况" "(10)是否本地户籍:单元格式为"文本",如果是广州户籍填"1",如果非广州户籍填"0" "(10)工资:单元格式为"数值",四舍五入到元,单元格右对齐;

职工月平均工资总额=职工本人年工资总额÷实际发放工资月数;

"(11)汇缴额:单元格式为"数值",四舍五入到元,单元格右对齐;

单位与个人的月缴存额合计;

汇缴额=单位月汇缴额+个人月汇缴额;

计算单位月汇缴额及个人月汇缴额应分别四舍五入到元位;

"(12)个人汇缴额:单元格式为"数值",四舍五入到元,单元格右对齐;

个人汇缴额=缴存基数*个人缴存比例;

"(13)缴存基数:单元格式为"数值",四舍五入到元,单元格右对齐;

"(14)单位、个人缴存比例:单元格式为"数值",无小数点,无%号,单元格右对齐;

单位及个人缴存比例为5%―12%,原则上只能选择一个比例,个人比例应当等于或高于单位比例,缴存比例取1%的整数倍;

"(15)手机号码:单元格式为"数值",11位数字;

"(16)用工单位编号:单位格式为"数值";

如果个人职工要开在用工单位下,就须填写相应的用工单位编号,否则则无须填写;

"使用说明:" "

1、单位必须在工作簿""sheet1""内填写的数据,不可将电子表格复制到""sheet1""以后的工作薄填写;