{"id":810,"date":"2020-08-31T10:33:55","date_gmt":"2020-08-31T03:33:55","guid":{"rendered":"http:\/\/helpbhxh.misa.vn\/?post_type=ht_kb&#038;p=810"},"modified":"2026-07-03T09:43:39","modified_gmt":"2026-07-03T02:43:39","slug":"them-moi-lao-dong-vao-don-vi-bang-cach-nhap-khau-tu-excel","status":"publish","type":"ht_kb","link":"\/amis-bhxh\/kb\/them-moi-lao-dong-vao-don-vi-bang-cach-nhap-khau-tu-excel\/","title":{"rendered":"Th\u00eam ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u00e0o \u0111\u01a1n v\u1ecb b\u1eb1ng c\u00e1ch nh\u1eadp kh\u1ea9u t\u1eeb file Excel"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>M\u1ee5c \u0111\u00edch:<\/strong> H\u01b0\u1edbng d\u1eabn ng\u01b0\u1eddi d\u00f9ng nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u lao \u0111\u1ed9ng t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m AMIS BHXH.<br \/>\n<strong>N\u1ed9i dung:<\/strong><br \/>\n&#8211; Ch\u1ecdn v\u00e0 c\u1eadp nh\u1eadt file m\u1eabu<br \/>\n&#8211; Ki\u1ec3m tra d\u1eef li\u1ec7u sau khi t\u1ea3i l\u00ean<br \/>\n&#8211; X\u1eed l\u00fd l\u1ed7i th\u01b0\u1eddng g\u1eb7p trong qu\u00e1 tr\u00ecnh nh\u1eadp kh\u1ea9u<br \/>\n<strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong> Nh\u00e2n s\u1ef1, k\u1ebf to\u00e1n, qu\u1ea3n tr\u1ecb ph\u1ea7n m\u1ec1m<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>T\u1ea1i ph\u00e2n h\u1ec7 <strong>Qu\u1ea3n l\u00fd lao \u0111\u1ed9ng<\/strong>, nh\u1ea5n v\u00e0o d\u1ea5u m\u0169i t\u00ean b\u00ean c\u1ea1nh m\u1ee5c <strong>Th\u00eam m\u1edbi lao \u0111\u1ed9ng, <\/strong>ch\u1ecdn<strong> Nh\u1eadp kh\u1ea9u t\u1eeb Excel<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-27317\" style=\"border-width: 1px; border-style: groove;\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/Nkhau-lao-don.png\" alt=\"\" width=\"1920\" height=\"919\" \/><\/p>\n<h4><b>2.1 Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/b><\/h4>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea3i file m\u1eabu sau \u0111\u00f3 c\u1eadp nh\u1eadt th\u00f4ng tin ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u00e0o file m\u1eabu.<\/p>\n<p><strong>L\u01b0u \u00fd: <\/strong>C\u1ea7n nh\u1eadp ch\u00ednh x\u00e1c th\u00f4ng tin theo c\u00e1c tr\u01b0\u1eddng trong m\u1eabu th\u00ec m\u1edbi c\u00f3 th\u1ec3 nh\u1eadp kh\u1ea9u l\u00ean ph\u1ea7n m\u1ec1m. C\u1ea7n \u0111i\u1ec1n th\u00f4ng tin v\u00e0o c\u00e1c sheet: Danh s\u00e1ch lao \u0111\u1ed9ng, Danh s\u00e1ch th\u00e0nh vi\u00ean kh\u00e1c trong gia \u0111\u00ecnh, Qu\u00e1 tr\u00ecnh tham gia BHXH.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-27325\" style=\"border-width: 1px; border-style: groove;\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/Tai-tep-mau-nkhau-lao-don.png\" alt=\"\" width=\"1920\" height=\"919\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1eadp kh\u1ea9u l\u00ean ph\u1ea7n m\u1ec1m b\u1eb1ng c\u00e1ch b\u1ea5m &#8220;ch\u1ecdn t\u1ec7p&#8221; ho\u1eb7c k\u00e9o file d\u1eef li\u1ec7u v\u00e0o kho\u1ea3ng tr\u1ed1ng \u0111\u01b0\u1ee3c khoanh \u0111\u1ecf.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-27341\" style=\"border-width: 1px; border-style: groove;\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/Chon-tep-nguon-nkhau-lao-don.png\" alt=\"\" width=\"1920\" height=\"919\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n <strong>Ti\u1ebfp theo<\/strong> \u0111\u1ec3 chuy\u1ec3n b\u01b0\u1edbc &#8220;Gh\u00e9p tr\u01b0\u1eddng th\u00f4ng tin&#8221;.<\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ul style=\"list-style-type: circle;\">\n<li>Gh\u00e9p th\u00f4ng tin \u1edf c\u1ea3 3 Tab: Danh s\u00e1ch lao \u0111\u1ed9ng, Th\u00e0nh vi\u00ean gia \u0111\u00ecnh, Qu\u00e1 tr\u00ecnh tham gia BHXH.<\/li>\n<li>X\u1eed l\u00fd khi g\u1eb7p d\u1eef li\u1ec7u tr\u00f9ng:\n<ul style=\"list-style-type: disc;\">\n<li>Ch\u1ecdn<strong> Nh\u1eadp th\u00eam:<\/strong> Ph\u1ea7n m\u1ec1m s\u1ebd kh\u00f4ng x\u00f3a d\u00f2ng lao \u0111\u1ed9ng c\u0169 b\u1ecb tr\u00f9ng theo m\u00e3 nh\u00e2n vi\u00ean v\u00e0 nh\u1eadp kh\u1ea9u th\u00eam d\u00f2ng m\u1edbi t\u1eeb t\u1ec7p nh\u1eadp kh\u1ea9u.<\/li>\n<li>Ch\u1ecdn <strong>Ghi \u0111\u00e8:<\/strong> Ph\u1ea7n m\u1ec1m s\u1ebd x\u00f3a d\u00f2ng lao \u0111\u1ed9ng tr\u00f9ng m\u00e3 nh\u00e2n vi\u00ean v\u00e0 thay th\u1ebf b\u1eb1ng d\u00f2ng tr\u00ean t\u1ec7p nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-27353\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/Ghep-truong-nkhau-lao-dong.png\" alt=\"\" width=\"1920\" height=\"919\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n <strong>Ti\u1ebfp theo<\/strong> \u0111\u1ec3 chuy\u1ec3n b\u01b0\u1edbc &#8220;Ki\u1ec3m tra th\u00f4ng tin&#8221;.<\/p>\n<h4><b>2.2 Ki\u1ec3m tra th\u00f4ng tin<\/b><\/h4>\n<p>H\u1ec7 th\u1ed1ng c\u1eadp nh\u1eadt danh s\u00e1ch ng\u01b0\u1eddi lao \u0111\u1ed9ng v\u1eeba \u0111\u01b0\u1ee3c t\u1ea3i l\u00ean th\u00e0nh c\u00f4ng tr\u00ean 3 Tab: Danh s\u00e1ch lao \u0111\u1ed9ng, Th\u00e0nh vi\u00ean gia \u0111\u00ecnh, Qu\u00e1 tr\u00ecnh tham gia BHXH.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-27355\" style=\"border-width: 1px; border-style: groove;\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/Kiem-tra-dl-lao-dong.png\" alt=\"\" width=\"1920\" height=\"919\" \/><\/p>\n<p>Tr\u00ean t\u1eebng Tab Danh s\u00e1ch lao \u0111\u1ed9ng, Th\u00e0nh vi\u00ean gia \u0111\u00ecnh, Qu\u00e1 tr\u00ecnh tham gia BHXH hi\u1ec3n th\u1ecb nh\u00f3m d\u1eef li\u1ec7u H\u1ee3p l\u1ec7, Kh\u00f4ng h\u1ee3p l\u1ec7. Nh\u1ea5n v\u00e0o t\u1eebng nh\u00f3m \u0111\u1ec3 xem chi ti\u1ebft.<\/p>\n<figure class=\"size-large\"><img decoding=\"async\" class=\"alignnone size-full wp-image-27357\" style=\"border-width: 1px; border-style: groove;\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/Hop-le.png\" alt=\"\" width=\"1920\" height=\"919\" \/><\/figure>\n<ul>\n<li><b>H\u1ee3p l\u1ec7: <\/b>Bao g\u1ed3m c\u00e1c d\u00f2ng d\u1eef li\u1ec7u c\u00f3 th\u00f4ng tin h\u1ee3p l\u1ec7. C\u00e1c d\u00f2ng d\u1eef li\u1ec7u n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\n<li><strong>Kh\u00f4ng h\u1ee3p l\u1ec7:<\/strong> Bao g\u1ed3m c\u00e1c d\u00f2ng d\u1eef li\u1ec7u c\u00f3 th\u00f4ng tin sai \u0111\u1ecbnh d\u1ea1ng ho\u1eb7c th\u00f4ng tin kh\u00f4ng n\u1eb1m trong danh s\u00e1ch \u0111\u00e3 c\u00f3 c\u1ee7a ch\u01b0\u01a1ng tr\u00ecnh. C\u00e1c d\u00f2ng d\u1eef li\u1ec7u n\u00e0y s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\n<li><strong>T\u1ea3i xu\u1ed1ng t\u1ec7p k\u1ebft qu\u1ea3<\/strong>: Khi file t\u1ea3i l\u00ean ch\u1ee9a c\u00e1c d\u1eef li\u1ec7u sai, anh\/ch\u1ecb th\u1ef1c hi\u1ec7n t\u1ea3i file b\u00e1o l\u1ed7i v\u1ec1 \u0111\u1ec3 ki\u1ec3m tra v\u00e0 ch\u1ec9nh s\u1eeda l\u1ea1i.<\/li>\n<\/ul>\n<p>=&gt; Sau khi \u0111\u00e3 ki\u1ec3m tra c\u00e1c nh\u00f3m d\u1eef li\u1ec7u, nh\u1ea5n <strong>Nh\u1eadp kh\u1ea9u<\/strong> \u0111\u1ec3 th\u00eam c\u00e1c lao \u0111\u1ed9ng v\u00e0o danh s\u00e1ch ng\u01b0\u1eddi lao \u0111\u1ed9ng c\u1ee7a \u0111\u01a1n v\u1ecb.<\/p>\n<figure class=\"size-large\"><img decoding=\"async\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/5-8.png\" alt=\"\" \/><\/figure>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>3. X\u1eed l\u00fd l\u1ed7i<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>L\u1ed7i:<\/strong> Tr\u00ean file nh\u1eadp kh\u1ea9u, ph\u1ea7n m\u1ec1m tr\u1ea3 k\u1ebft qu\u1ea3 <strong>Kh\u00f4ng h\u1ee3p l\u1ec7<\/strong> v\u00e0 ghi r\u00f5 chi ti\u1ebft l\u00fd do \u1edf c\u1ed9t<strong> Gi\u1ea3i th\u00edch<\/strong> \u0111\u1ec3 x\u1eed l\u00fd t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-27361\" src=\"\/amis-bhxh\/wp-content\/uploads\/2020\/08\/Kqua-khong-hop-le.png\" alt=\"\" width=\"1918\" height=\"1017\" \/><\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong>\u00a0Tr\u00ean file nh\u1eadp kh\u1ea9u, ph\u1ea7n m\u1ec1m tr\u1ea3 k\u1ebft qu\u1ea3 <strong>Kh\u00f4ng h\u1ee3p l\u1ec7<\/strong> v\u1edbi l\u00fd do &#8220;<strong>B\u1ed9 ph\u1eadn ph\u00f2ng ban kh\u00f4ng c\u00f3 trong danh m\u1ee5c<\/strong>&#8220;.<\/p>\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong> Gi\u00e1 tr\u1ecb b\u1ed9 ph\u1eadn\/ph\u00f2ng ban trong file Excel kh\u00f4ng t\u1ed3n t\u1ea1i trong danh m\u1ee5c C\u01a1 c\u1ea5u t\u1ed5 ch\u1ee9c c\u1ee7a ph\u1ea7n m\u1ec1m.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong><\/p>\n<ul>\n<li>Ki\u1ec3m tra v\u00e0 s\u1eeda l\u1ea1i file Excel, \u0111\u1ea3m b\u1ea3o c\u00e1c gi\u00e1 tr\u1ecb b\u1ed9 ph\u1eadn \u0111\u01b0\u1ee3c l\u1ea5y \u0111\u00fang t\u1eeb danh m\u1ee5c <strong>Thi\u1ebft l\u1eadp<\/strong>\\<strong>C\u01a1 c\u1ea5u t\u1ed5 ch\u1ee9c<\/strong>.<\/li>\n<li>N\u1ebfu ch\u01b0a c\u00f3 trong danh m\u1ee5c, c\u1ea7n th\u00eam m\u1edbi tr\u01b0\u1edbc khi nh\u1eadp kh\u1ea9u. Xem h\u01b0\u1edbng d\u1eabn t\u1ea1i: <a href=\"\/amis-bhxh\/kb\/thiet-lap-co-cau-to-chuc\/\" target=\"_blank\" rel=\"noopener\">Thi\u1ebft l\u1eadp c\u01a1 c\u1ea5u t\u1ed5 ch\u1ee9c<\/a>.<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-810","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb\/810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/comments?post=810"}],"version-history":[{"count":6,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb\/810\/revisions"}],"predecessor-version":[{"id":27931,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb\/810\/revisions\/27931"}],"wp:attachment":[{"href":"\/amis-bhxh\/wp-json\/wp\/v2\/media?parent=810"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb-category?post=810"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/amis-bhxh\/wp-json\/wp\/v2\/ht-kb-tag?post=810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}