XLS《样板》

"业务种类","单位账号","启封人数","封存人数" "封存/启封","123456","3","1" "姓名","证件类型","证件号码","公积金账号","工资","缴存基数","单位汇缴比例","个人汇缴比例","单位汇缴额","个人汇缴额","汇缴额","用工单位编号","变更类型" "黄**","01","22*X","22*X00","5000","5000","10","10","500","500","1000",,

"02" "邱**","01","22*6","22*600","5000","5000","10","10","500","500","1000",,

"01" "黄**","01","22*2","22*200","1000","2100","10","10","210","210","420",,

"01" "李**","02","10*4","10*400","30000","24654","9","9","2219","2219","4438","01","01" "说明:" "(1)业务种类:单元格式为"文本"格式,左对齐;

本表格适用于住房公积金批量办理职工账户启封及封存变更业务,按业务种类填写;

不同类型的变更业务要分开表格填写;

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

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

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

单位批量办理职工账户启封手续的人数;

"(4)封存人数:单元格式为"文本"格式,左对齐;

单位批量办理职工账户封存手续的人数;

"(5)序号:单元格式为"数值"格式,单元格右对齐,按职工人数依次排列;

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

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

02-军官证;

03-护照;

04-外国人永久居留证;

05-通行证;

06-居住证;

99-其他"填写数字;

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

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

"(9)公积金账号:单元格式为"文本",单元格式左对齐,公积金账号是职工在本市缴存公积金的唯一账号,不因在本市范围内的工作变动而改变;

"(10)工资:单元格式为"数值",四舍五入到元,单元格右对齐;

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

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

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

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

"(13)单位汇缴额:单元格式为"数值"格式,单元格右对齐,四舍五入到元位,单位汇缴额=缴存基数*单位缴存比例;

"(14)个人汇缴额:单元格式为"数值"格式,单元格右对齐,四舍五入到元位,个人汇缴额=缴存基数*个人缴存比例;

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

是单位汇缴额与个人汇缴额的合计;

"(16)变更类型:单元格式为"文本",单元格式左对齐,办理启封业务的用01-启封;

办理封存业务的用02-封存;

"(17)用工单位编号:单元格式为"文本",单元格式左对齐. "使用说明:" "

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

" "

2、本电子表格适用于本表格适用于住房公积金批量办理职工账户启封及封存变更业务," "