{"id":34759,"date":"2026-10-12T14:17:46","date_gmt":"2026-10-12T07:17:46","guid":{"rendered":"\/tien-luong\/?post_type=ht_kb&#038;p=34759"},"modified":"2026-10-12T14:19:27","modified_gmt":"2026-10-12T07:19:27","slug":"lam-the-nao-de-tao-file-mau-excel-dung-de-nhap-khau-cap-nhat-thong-tin-cho-can-bo-nhan-vien-da-khai-bao","status":"publish","type":"ht_kb","link":"\/tien-luong\/knowledge-base\/lam-the-nao-de-tao-file-mau-excel-dung-de-nhap-khau-cap-nhat-thong-tin-cho-can-bo-nhan-vien-da-khai-bao\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o file m\u1eabu excel d\u00f9ng \u0111\u1ec3 nh\u1eadp kh\u1ea9u c\u1eadp nh\u1eadt th\u00f4ng tin cho c\u00e1n b\u1ed9 nh\u00e2n vi\u00ean \u0111\u00e3 khai b\u00e1o?"},"content":{"rendered":"<h3 id=\"1-tong-quan\"><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p class=\"x1yc453h xma8rkl xgoqxah xutxfr x1fie51u xgyxj25 x1xobyvs x1elgs31 x1fv8qjw xcy5tzr x1ht4adc xnvauns x1c2l018 x14l7nz5 xuw7688 x1pjt2rx x160d6zm xrxpjvj\" dir=\"ltr\">B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb <strong class=\"x7amdea\">t\u1ea1o\/l\u1ea5y file m\u1eabu Excel \u0111\u1ec3 nh\u1eadp kh\u1ea9u v\u00e0 c\u1eadp nh\u1eadt th\u00f4ng tin h\u00e0ng lo\u1ea1t cho c\u00e1n b\u1ed9, nh\u00e2n vi\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c khai b\u00e1o tr\u00ean ph\u1ea7n m\u1ec1m<\/strong> th\u00f4ng qua ch\u1ee9c n\u0103ng <strong class=\"x7amdea\">C\u1eadp nh\u1eadt th\u00f4ng tin h\u00e0ng lo\u1ea1t.<\/strong><\/p>\n<p class=\"x1yc453h xma8rkl xgoqxah xutxfr x1fie51u xgyxj25 x1xobyvs x1elgs31 x1fv8qjw xcy5tzr x1ht4adc xnvauns x1c2l018 x14l7nz5 xuw7688 x1pjt2rx x160d6zm xrxpjvj\" dir=\"ltr\"><strong class=\"x7amdea\">L\u01b0u \u00fd:<\/strong> H\u01b0\u1edbng d\u1eabn n\u00e0y ch\u1ec9 \u00e1p d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p anh\/ch\u1ecb c\u1ea7n l\u1ea5y file m\u1eabu \u0111\u1ec3 <strong class=\"x7amdea\">nh\u1eadp kh\u1ea9u c\u1eadp nh\u1eadt th\u00f4ng tin h\u00e0ng lo\u1ea1t t\u1eeb Excel cho danh s\u00e1ch c\u00e1n b\u1ed9, nh\u00e2n vi\u00ean \u0111\u00e3 c\u00f3 tr\u00ean ph\u1ea7n m\u1ec1m<\/strong>, th\u1ef1c hi\u1ec7n th\u00f4ng qua ch\u1ee9c n\u0103ng <strong class=\"x7amdea\">C\u1eadp nh\u1eadt th\u00f4ng tin h\u00e0ng lo\u1ea1t<\/strong> theo h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/knowledge-base\/lam-the-nao-de-cap-nhat-thong-tin-hang-loat-cho-can-bo-nhan-vien\/\"><strong class=\"x7amdea\">t\u1ea1i \u0111\u00e2y<\/strong><\/a>.<\/p>\n<p class=\"x1yc453h xma8rkl xgoqxah xutxfr x1fie51u xgyxj25 x1xobyvs x1elgs31 x1fv8qjw xcy5tzr x1ht4adc xnvauns x1c2l018 x14l7nz5 xuw7688 x1pjt2rx x160d6zm xrxpjvj\" dir=\"ltr\">Tr\u01b0\u1eddng h\u1ee3p anh\/ch\u1ecb c\u1ea7n <strong class=\"x7amdea\">l\u1ea5y file m\u1eabu \u0111\u1ec3 nh\u1eadp kh\u1ea9u th\u00eam m\u1edbi c\u00e1n b\u1ed9, nh\u00e2n vi\u00ean ch\u01b0a c\u00f3 tr\u00ean ph\u1ea7n m\u1ec1m<\/strong>, vui l\u00f2ng th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng <strong class=\"x7amdea\">Nh\u1eadp kh\u1ea9u<\/strong> tr\u00ean \u1ee9ng d\u1ee5ng <strong class=\"x7amdea\">H\u1ec7 th\u1ed1ng<\/strong>, sau \u0111\u00f3 nh\u1ea5n <strong class=\"x7amdea\">T\u1ea3i file m\u1eabu<\/strong> theo h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/knowledge-base\/lam-the-nao-de-them-moi-hang-loat-can-bo-nhan-vien-tu-file-excel\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n<h3 id=\"2-cac-buoc-thuc-hien\"><strong>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0Hi\u1ec7n t\u1ea1i ph\u1ea7n m\u1ec1m ch\u01b0a c\u00f3 file m\u1eabu \u0111\u1ec3 nh\u1eadp kh\u1ea9u, anh\/ch\u1ecb c\u00f3 th\u1ec3 t\u1ef1 thi\u1ebft k\u1ebf file m\u1eabu c\u00f3 c\u00e1c c\u1ed9t th\u00f4ng tin c\u1ea7n c\u00f3 \u0111\u1ec3 nh\u1eadp kh\u1ea9u ho\u1eb7c th\u1ef1c hi\u1ec7n nh\u01b0 sau \u0111\u1ec3 l\u1ea5y file m\u1eabu<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o <strong>C\u00e1n b\u1ed9 nh\u00e2n vi\u00ean.<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Ti\u1ec7n \u00edch<\/strong>\\ Ch\u1ecdn\u00a0<strong>C\u1eadp nh\u1eadt th\u00f4ng tin h\u00e0ng lo\u1ea1t.<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn <strong>th\u00f4ng tin c\u1ea7n c\u1eadp nh\u1eadt<\/strong><strong>\\\u00a0<\/strong>Nh\u1ea5n<strong> Ti\u1ebfp t\u1ee5c.<\/strong><\/p>\n<p>Mu\u1ed1n c\u1eadp nh\u1eadt th\u00f4ng tin n\u00e0o th\u00ec ch\u1ecdn th\u00f4ng tin \u0111\u00f3:<\/p>\n<ul>\n<li>Ch\u1ecdn Lo\u1ea1i th\u00f4ng tin c\u1ea7n c\u1eadp nh\u1eadt:<\/li>\n<\/ul>\n<ul>\n<li>\n<ul>\n<li><strong>Th\u00f4ng tin chung:<\/strong>\u00a0Ng\u00e0y v\u00e0o \u0111\u01a1n v\u1ecb, lo\u1ea1i c\u00e1n b\u1ed9, ph\u00f2ng ban, tr\u1ea1ng th\u00e1i l\u00e0m vi\u1ec7c, bi\u00ean ch\u1ebf, mail, s\u1ed1 t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng,\u2026<\/li>\n<li><strong>Qu\u00e1 tr\u00ecnh l\u01b0\u01a1ng:<\/strong>\u00a0Th\u00f4ng tin ch\u01b0\u01a1ng kho\u1ea3n, ti\u1ec3u m\u1ee5c c\u1ee7a c\u00e1c qu\u00e1 tr\u00ecnh l\u01b0\u01a1ng,\u2026<\/li>\n<li><strong>Qu\u00e1 tr\u00ecnh ph\u1ee5 c\u1ea5p:<\/strong>\u00a0Th\u00f4ng tin qu\u00e1 tr\u00ecnh ph\u1ee5 c\u1ea5p theo t\u1eebng lo\u1ea1i ph\u1ee5 c\u1ea5p t\u1ea1i \u0111\u01a1n v\u1ecb<\/li>\n<li><strong>Th\u00f4ng tin b\u1ea3o hi\u1ec3m:<\/strong>\u00a0Thay \u0111\u1ed5i ho\u1eb7c\u00a0<b data-path-to-node=\"8,2,0,0\" data-index-in-node=\"14\">x\u00f3a b\u1ecf danh s\u00e1ch<\/b>\u00a0n\u1ed9p Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (KPC\u0110) hay ch\u00ednh l\u00e0 s\u1eeda, x\u00f3a t\u1ef7 l\u1ec7 c\u01a1 quan \u0111\u00f3ng, ng\u01b0\u1eddi lao \u0111\u1ed9ng \u0111\u00f3ng, c\u00f4ng th\u1ee9c t\u00ednh t\u1eebng lo\u1ea1i b\u1ea3o hi\u1ec3m (BHXH, BHYT, BHTN) v\u00e0\u00a0<b data-path-to-node=\"10,3,2,0\" data-index-in-node=\"112\">2% Kinh ph\u00ed c\u00f4ng \u0111o\u00e0n (KPC\u0110)<\/b><\/li>\n<li><strong>Th\u00f4ng tin thu\u1ebf TNCN:<\/strong>\u00a0Th\u00f4ng tin v\u1ec1 c\u00e1 nh\u00e2n c\u01b0 tr\u00fa, m\u00e3 s\u1ed1 thu\u1ebf, s\u1ed1 CCCD,\u2026<\/li>\n<li><strong>Ng\u01b0\u1eddi ph\u1ee5 thu\u1ed9c:<\/strong> C\u1eadp nh\u1eadt th\u00f4ng tin v\u1ec1 ng\u01b0\u1eddi ph\u1ee5 thu\u1ed9c<\/li>\n<\/ul>\n<\/li>\n<li>Ch\u1ecdn th\u00f4ng tin chi ti\u1ebft trong t\u1eebng lo\u1ea1i th\u00f4ng tin c\u1ea7n c\u1eadp nh\u1eadt.<\/li>\n<li>Nh\u1ea5n <strong>Ti\u1ebfp t\u1ee5c<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44133 size-large\" src=\"https:\/\/helpsalagov.misa.vn\/wp-content\/uploads\/2026\/08\/7-4-1024x410.png\" alt=\"\" width=\"1024\" height=\"410\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Ph\u1ea7n m\u1ec1m hi\u1ec3n th\u1ecb b\u1ea3ng Excel v\u1edbi c\u00e1c c\u1ed9t th\u00f4ng tin t\u01b0\u01a1ng \u1ee9ng v\u1edbi nh\u00f3m th\u00f4ng tin \u0111\u00e3 ch\u1ecdn. Anh\/ch\u1ecb c\u00f3 th\u1ec3 copy to\u00e0n b\u1ed9 b\u1ea3ng v\u00e0 paste v\u00e0o Excel \u0111\u1ec3 t\u1ea1o file m\u1eabu, ho\u1eb7c thi\u1ebft k\u1ebf file Excel c\u00f3 c\u00e1c c\u1ed9t gi\u1ed1ng b\u1ea3ng n\u00e0y \u0111\u1ec3 nh\u1eadp th\u00f4ng tin.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44137 size-full\" src=\"https:\/\/helpsalagov.misa.vn\/wp-content\/uploads\/2026\/08\/8-3.png\" alt=\"\" width=\"1144\" height=\"505\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb t\u1ea1o\/l\u1ea5y file m\u1eabu Excel \u0111\u1ec3 nh\u1eadp kh\u1ea9u v\u00e0 c\u1eadp nh\u1eadt th\u00f4ng tin h\u00e0ng lo\u1ea1t cho c\u00e1n b\u1ed9, nh\u00e2n vi\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c khai b\u00e1o tr\u00ean ph\u1ea7n m\u1ec1m th\u00f4ng qua ch\u1ee9c n\u0103ng C\u1eadp nh\u1eadt th\u00f4ng tin h\u00e0ng lo\u1ea1t. L\u01b0u \u00fd: H\u01b0\u1edbng d\u1eabn n\u00e0y&#8230;<\/p>\n","protected":false},"author":59,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[191],"ht-kb-tag":[],"class_list":["post-34759","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-can-bo-nhan-vien"],"_links":{"self":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/34759","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/users\/59"}],"replies":[{"embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/comments?post=34759"}],"version-history":[{"count":2,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/34759\/revisions"}],"predecessor-version":[{"id":34765,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/34759\/revisions\/34765"}],"wp:attachment":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/media?parent=34759"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=34759"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=34759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}