{"id":31365,"date":"2023-07-18T08:24:21","date_gmt":"2023-07-18T01:24:21","guid":{"rendered":"http:\/\/mimosahelp.misa.vn\/?post_type=ht_kb&#038;p=31365"},"modified":"2026-04-22T13:54:36","modified_gmt":"2026-04-22T06:54:36","slug":"ke-toan-muon-nhap-khau-danh-sach-can-bo-nang-luong-de-lam-viec-nhanh-chong-hon","status":"publish","type":"ht_kb","link":"\/ke-toan\/kb\/ke-toan-muon-nhap-khau-danh-sach-can-bo-nang-luong-de-lam-viec-nhanh-chong-hon\/","title":{"rendered":"K\u1ebf to\u00e1n mu\u1ed1n nh\u1eadp kh\u1ea9u danh s\u00e1ch c\u00e1n b\u1ed9 n\u00e2ng l\u01b0\u01a1ng \u0111\u1ec3 l\u00e0m vi\u1ec7c nhanh ch\u00f3ng h\u01a1n"},"content":{"rendered":"<h3 data-start=\"199\" data-end=\"219\"><strong data-start=\"203\" data-end=\"219\">1. T\u1ed5ng quan<\/strong><\/h3>\n<p>B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1ch <strong data-start=\"588\" data-end=\"634\">nh\u1eadp nhanh to\u00e0n b\u1ed9 danh s\u00e1ch c\u00e1n b\u1ed9 truy l\u0129nh n\u00e2ng l\u01b0\u01a1ng t\u1eeb file Excel<\/strong>, ti\u1ebft ki\u1ec7m th\u1eddi gian nh\u1eadp li\u1ec7u v\u00e0 \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt ch\u00ednh x\u00e1c, \u0111\u1ed3ng b\u1ed9 tr\u00ean h\u1ec7 th\u1ed1ng.<\/p>\n<h3 id=\"2-chi-tiet-thay-doi\">2. C\u00e1ch th\u1ef1c hi\u1ec7n<\/h3>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o ph\u00e2n h\u1ec7 <strong>Ti\u1ec1n l\u01b0\u01a1ng\\Truy l\u0129nh l\u01b0\u01a1ng\\Truy l\u0129nh n\u00e2ng l\u01b0\u01a1ng, <\/strong>tr\u00ean m\u00e0n h\u00ecnh x\u00e1c \u0111\u1ecbnh c\u00e1n b\u1ed9 truy l\u0129nh<strong>, ch\u1ecdn Nh\u1eadp kh\u1ea9u<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31375\" src=\"\/ke-toan\/wp-content\/uploads\/2023\/07\/R6-70.jpg\" alt=\"\" width=\"893\" height=\"665\" srcset=\"\/ke-toan\/wp-content\/uploads\/2023\/07\/R6-70.jpg 893w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-70-300x223.jpg 300w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-70-768x572.jpg 768w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-70-50x37.jpg 50w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-70-60x45.jpg 60w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-70-100x74.jpg 100w\" sizes=\"auto, (max-width: 893px) 100vw, 893px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>T\u1ea3i t\u1ec7p m\u1eabu<\/strong> \u0111\u1ec3 t\u1ea3i file m\u1eabu excel v\u1ec1 v\u00e0 nh\u1eadp th\u00f4ng tin v\u00e0o file m\u1eabu.<\/p>\n<p><strong>B\u01b0\u1edbc 3: <\/strong>Nh\u1ea5n <strong>Ch\u1ecdn t\u1ec7p<\/strong> v\u00e0 ch\u1ecdn file excel v\u1eeba ho\u00e0n thi\u1ec7n \u0111\u1ec3 nh\u1eadp kh\u1ea9u v\u00e0o<\/p>\n<ul>\n<li>Ch\u1ecdn <strong>Sheet ch\u1ee9a d\u1eef li\u1ec7u, D\u00f2ng ti\u00eau \u0111\u1ec1<\/strong><\/li>\n<li>Nh\u1ea5n\u00a0<strong>Ti\u1ebfp t\u1ee5c.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31373\" src=\"\/ke-toan\/wp-content\/uploads\/2023\/07\/R6-68.jpg\" alt=\"\" width=\"1175\" height=\"673\" srcset=\"\/ke-toan\/wp-content\/uploads\/2023\/07\/R6-68.jpg 1175w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-68-300x172.jpg 300w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-68-1024x587.jpg 1024w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-68-768x440.jpg 768w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-68-50x29.jpg 50w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-68-60x34.jpg 60w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-68-100x57.jpg 100w\" sizes=\"auto, (max-width: 1175px) 100vw, 1175px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4: <\/strong>Gh\u00e9p d\u1eef li\u1ec7u<\/p>\n<ul>\n<li data-start=\"1251\" data-end=\"1370\">\n<p data-start=\"1253\" data-end=\"1370\">N\u1ebfu d\u00f9ng file m\u1eabu: ph\u1ea7n m\u1ec1m s\u1ebd <strong data-start=\"1284\" data-end=\"1300\">t\u1ef1 \u0111\u1ed9ng gh\u00e9p<\/strong> c\u00e1c c\u1ed9t d\u1eef li\u1ec7u t\u1eeb file v\u1edbi c\u00e1c tr\u01b0\u1eddng th\u00f4ng tin tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh.<\/p>\n<\/li>\n<li data-start=\"1371\" data-end=\"1510\">\n<p data-start=\"1373\" data-end=\"1510\">N\u1ebfu d\u00f9ng file t\u1ef1 t\u1ea1o: k\u1ebf to\u00e1n c\u00f3 th\u1ec3 <strong data-start=\"1410\" data-end=\"1440\">ch\u1ee7 \u0111\u1ed9ng gh\u00e9p c\u1ed9t th\u1ee7 c\u00f4ng<\/strong> (v\u00ed d\u1ee5: c\u1ed9t \u201cM\u00e3 c\u00e1n b\u1ed9\u201d, \u201cH\u1ecd v\u00e0 t\u00ean\u201d, \u201cH\u1ec7 s\u1ed1 m\u1edbi\u201d, &#8220;H\u1ec7 s\u1ed1 c\u0169&#8221;,&#8230;).<\/p>\n<\/li>\n<li>Nh\u1ea5n\u00a0<strong>Ti\u1ebfp t\u1ee5c.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31374\" src=\"\/ke-toan\/wp-content\/uploads\/2023\/07\/R6-69.jpg\" alt=\"\" width=\"1175\" height=\"669\" srcset=\"\/ke-toan\/wp-content\/uploads\/2023\/07\/R6-69.jpg 1175w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-69-300x171.jpg 300w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-69-1024x583.jpg 1024w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-69-768x437.jpg 768w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-69-50x28.jpg 50w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-69-60x34.jpg 60w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-69-100x57.jpg 100w\" sizes=\"auto, (max-width: 1175px) 100vw, 1175px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> <strong>Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong>:\u00a0<\/p>\n<ul>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o s\u1ed1 b\u1ea3n ghi h\u1ee3p l\u1ec7\/kh\u00f4ng h\u1ee3p l\u1ec7 cho anh\/ch\u1ecb n\u1eafm \u0111\u01b0\u1ee3c:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31378\" src=\"\/ke-toan\/wp-content\/uploads\/2023\/07\/R6-72.jpg\" alt=\"\" width=\"1175\" height=\"667\" srcset=\"\/ke-toan\/wp-content\/uploads\/2023\/07\/R6-72.jpg 1175w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-72-300x170.jpg 300w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-72-1024x581.jpg 1024w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-72-768x436.jpg 768w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-72-50x28.jpg 50w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-72-60x34.jpg 60w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-72-100x57.jpg 100w\" sizes=\"auto, (max-width: 1175px) 100vw, 1175px\" \/><\/p>\n<ul>\n<li>Khi \u0111\u00f3 anh\/ch\u1ecb c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: square;\">\n<li>Nh\u1ea5n\u00a0<strong>Nh\u1eadp d\u1eef li\u1ec7u<\/strong>: ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd b\u1ecf qua c\u00e1c m\u00e3 kh\u00f4ng h\u1ee3p l\u1ec7 v\u00e0 ch\u1ec9 nh\u1eadp l\u00ean h\u1ec7 th\u1ed1ng c\u00e1c m\u00e3 c\u00f3 t\u00ecnh tr\u1ea1ng h\u1ee3p l\u1ec7.<\/li>\n<li>Ki\u1ec3m tra th\u00f4ng tin chi ti\u1ebft l\u1ed7i tr\u00ean giao di\u1ec7n ho\u1eb7c nh\u1ea5n\u00a0<strong>T\u1ea3i t\u1ec7p ki\u1ec3m tra<\/strong>\u00a0\u0111\u1ec3 t\u1ea3i file k\u1ebft qu\u1ea3 v\u1ec1 m\u00e1y v\u00e0 ki\u1ec3m tra l\u1ea1i. Sau \u0111\u00f3 anh\/ch\u1ecb c\u00f3 th\u1ec3 quay l\u1ea1i b\u01b0\u1edbc 1 \u0111\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i file nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> <strong>Th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 nh\u1eadp li\u1ec7u<\/strong><\/p>\n<ul>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c b\u1ea3n ghi \u0111\u00e3 nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra \u1edf <strong>B\u01b0\u1edbc 5.<\/strong><\/li>\n<li>Nh\u1ea5n\u00a0<strong>\u0110\u00f3ng\u00a0<\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u\u00a0<strong>X<\/strong> \u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u danh s\u00e1ch c\u00e1n b\u1ed9 n\u00e2ng l\u01b0\u01a1ng.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31377\" src=\"\/ke-toan\/wp-content\/uploads\/2023\/07\/R6-71.jpg\" alt=\"\" width=\"1175\" height=\"673\" srcset=\"\/ke-toan\/wp-content\/uploads\/2023\/07\/R6-71.jpg 1175w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-71-300x172.jpg 300w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-71-1024x587.jpg 1024w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-71-768x440.jpg 768w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-71-50x29.jpg 50w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-71-60x34.jpg 60w, \/ke-toan\/wp-content\/uploads\/2023\/07\/R6-71-100x57.jpg 100w\" sizes=\"auto, (max-width: 1175px) 100vw, 1175px\" \/><\/p>\n<p><em>Xem th\u00eam h\u01b0\u1edbng d\u1eabn T\u00ednh l\u01b0\u01a1ng truy l\u0129nh<strong><a href=\"https:\/\/helpihos.misa.vn\/ke-toan\/kb\/tinh-luong-truy-linh\/\" target=\"_blank\" rel=\"noopener\"> t\u1ea1i \u0111\u00e2y<\/a><\/strong><\/em><\/p>\n<p><em>Xem th\u00eam h\u01b0\u1edbng d\u1eabn nh\u1eadp kh\u1ea9u exel <strong><a href=\"https:\/\/helpihos.misa.vn\/ke-toan\/kb\/lam-the-nao-de-nhap-cac-danh-muc-tu-file-excel-vao-phan-mem\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y\u00a0<\/a><\/strong><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1ch nh\u1eadp nhanh to\u00e0n b\u1ed9 danh s\u00e1ch c\u00e1n b\u1ed9 truy l\u0129nh n\u00e2ng l\u01b0\u01a1ng t\u1eeb file Excel, ti\u1ebft ki\u1ec7m th\u1eddi gian nh\u1eadp li\u1ec7u v\u00e0 \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt ch\u00ednh x\u00e1c, \u0111\u1ed3ng b\u1ed9 tr\u00ean h\u1ec7 th\u1ed1ng. 2. C\u00e1ch th\u1ef1c hi\u1ec7n B\u01b0\u1edbc&#8230;<\/p>\n","protected":false},"author":20,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"ht-kb-category":[854],"ht-kb-tag":[],"class_list":["post-31365","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r6"],"_links":{"self":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb\/31365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/comments?post=31365"}],"version-history":[{"count":5,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb\/31365\/revisions"}],"predecessor-version":[{"id":76379,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb\/31365\/revisions\/76379"}],"wp:attachment":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/media?parent=31365"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb-category?post=31365"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb-tag?post=31365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}