{"id":27850,"date":"2023-11-24T10:52:40","date_gmt":"2023-11-24T03:52:40","guid":{"rendered":"http:\/\/helpasp.misa.vn\/accounting\/?post_type=ht_kb&#038;p=27850"},"modified":"2025-12-09T09:37:59","modified_gmt":"2025-12-09T02:37:59","slug":"khi-sua-lai-mau-bang-luong-thi-phan-mem-van-tu-dong-ghep-duoc-voi-cac-cot-tuong-ung-tren-excel-khi-nhap-khau-bang-luong","status":"publish","type":"ht_kb","link":"http:\/\/helpasp.misa.vn\/accounting\/kb\/khi-sua-lai-mau-bang-luong-thi-phan-mem-van-tu-dong-ghep-duoc-voi-cac-cot-tuong-ung-tren-excel-khi-nhap-khau-bang-luong\/","title":{"rendered":"Khi nh\u1eadp kh\u1ea9u b\u1ea3ng t\u00ednh l\u01b0\u01a1ng t\u1eeb excel, ph\u1ea7n m\u1ec1m t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt c\u00e1c c\u1ed9t d\u1eef li\u1ec7u theo m\u1eabu b\u1ea3ng l\u01b0\u01a1ng m\u1edbi nh\u1ea5t tr\u00ean ph\u1ea7n m\u1ec1m v\u00e0 t\u1ef1 \u0111\u1ed9ng gh\u00e9p v\u1edbi c\u00e1c c\u1ed9t t\u01b0\u01a1ng \u1ee9ng tr\u00ean t\u1ec7p 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>1. T\u1ed5ng quan<\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>B\u00e0i vi\u1ebft gi\u00fap Anh\/Ch\u1ecb hi\u1ec3u r\u00f5 m\u1ee5c \u0111\u00edch v\u00e0 c\u00e1ch s\u1eeda m\u1eabu b\u1ea3ng l\u01b0\u01a1ng tr\u00ean ph\u1ea7n m\u1ec1m \u0111\u1ec3 \u0111\u1ed3ng b\u1ed9 v\u1edbi file Excel, \u0111\u1ea3m b\u1ea3o qu\u00e1 tr\u00ecnh nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u l\u01b0\u01a1ng di\u1ec5n ra nhanh ch\u00f3ng, ch\u00ednh x\u00e1c v\u00e0 t\u1ef1 \u0111\u1ed9ng gh\u00e9p c\u1ed9t d\u1eef li\u1ec7u.<\/p>\n<p><strong>N\u1ed9i dung:<\/strong><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Gi\u1edbi thi\u1ec7u v\u1ec1 vi\u1ec7c s\u1eeda m\u1eabu b\u1ea3ng l\u01b0\u01a1ng \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u c\u1ee7a \u0111\u01a1n v\u1ecb<\/li>\n<li>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n tr\u00ean ph\u1ea7n m\u1ec1m<\/li>\n<li>L\u01b0u \u00fd v\u1ec1 vi\u1ec7c c\u1eadp nh\u1eadt m\u1eabu b\u1ea3ng l\u01b0\u01a1ng v\u00e0 t\u1ef1 \u0111\u1ed9ng gh\u00e9p d\u1eef li\u1ec7u<\/li>\n<\/ul>\n<p><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong> K\u1ebf to\u00e1n, nh\u00e2n s\u1ef1, qu\u1ea3n tr\u1ecb vi\u00ean<\/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>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>\u0110\u01a1n v\u1ecb c\u00f3 m\u1eabu b\u1ea3ng l\u01b0\u01a1ng ri\u00eang v\u00e0 t\u00ednh l\u01b0\u01a1ng tr\u00ean excel s\u1ebd c\u1ea7n s\u1eeda l\u1ea1i m\u1eabu b\u1ea3ng l\u01b0\u01a1ng tr\u00ean ph\u1ea7n m\u1ec1m cho kh\u1edbp n\u1ed9i dung c\u00e1c c\u1ed9t tr\u00ean file excel v\u00e0 tr\u00ean ph\u1ea7n m\u1ec1m. Khi \u0111\u00f3 Anh\/Ch\u1ecb c\u1ea7n th\u1ef1c hi\u1ec7n <a href=\"https:\/\/helpasp.misa.vn\/accounting\/kb\/sua-mau-bang-luong\/?fbclid=IwAR1sFmVi2r2W67G-3rgJ6mItQ0GdrHT9blBvoDhfct9B4_0-gcufoMvwizM\" target=\"_blank\" rel=\"noopener\">s\u1eeda m\u1eabu b\u1ea3ng l\u01b0\u01a1ng<\/a> tr\u01b0\u1edbc khi nh\u1eadp kh\u1ea9u b\u1ea3ng l\u01b0\u01a1ng v\u00e0o ph\u1ea7n m\u1ec1m.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Tr\u00ean giao di\u1ec7n B\u1ea3ng t\u00ednh l\u01b0\u01a1ng, ch\u1ecdn <strong>Nh\u1eadp t\u1eeb excel<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n <a href=\"https:\/\/helpasp.misa.vn\/accounting\/kb\/nhap-khau-bang-tinh-luong-tu-excel\/\" target=\"_blank\" rel=\"noopener\">nh\u1eadp kh\u1ea9u b\u1ea3ng t\u00ednh l\u01b0\u01a1ng t\u1eeb excel<\/a>.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-27941\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2023\/11\/0-2-1600x796.png\" alt=\"\" width=\"1600\" height=\"796\" srcset=\"\/accounting\/wp-content\/uploads\/2023\/11\/0-2-1600x796.png 1600w, \/accounting\/wp-content\/uploads\/2023\/11\/0-2-768x382.png 768w, \/accounting\/wp-content\/uploads\/2023\/11\/0-2-50x25.png 50w, \/accounting\/wp-content\/uploads\/2023\/11\/0-2-1536x764.png 1536w, \/accounting\/wp-content\/uploads\/2023\/11\/0-2-60x30.png 60w, \/accounting\/wp-content\/uploads\/2023\/11\/0-2-100x50.png 100w, \/accounting\/wp-content\/uploads\/2023\/11\/0-2.png 1630w\" sizes=\"(max-width: 1600px) 100vw, 1600px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> T\u1ea1i b\u01b0\u1edbc gh\u00e9p d\u1eef li\u1ec7u, ph\u1ea7n m\u1ec1m s\u1ebd hi\u1ec3n th\u1ecb T\u00ean c\u00e1c c\u1ed9t c\u1ea7n gh\u00e9p theo t\u00ean c\u1ed9t sau khi \u0111\u00e3 s\u1eeda m\u1eabu b\u1ea3ng l\u01b0\u01a1ng, thay v\u00ec v\u1eabn hi\u1ec3n th\u1ecb t\u00ean c\u1ed9t ng\u1ea7m \u0111\u1ecbnh c\u1ee7a ch\u01b0\u01a1ng tr\u00ecnh nh\u01b0 tr\u01b0\u1edbc \u0111\u00e2y.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-27945\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2023\/11\/buoc-ghep-cot.png\" alt=\"\" width=\"1584\" height=\"745\" srcset=\"\/accounting\/wp-content\/uploads\/2023\/11\/buoc-ghep-cot.png 1584w, \/accounting\/wp-content\/uploads\/2023\/11\/buoc-ghep-cot-768x361.png 768w, \/accounting\/wp-content\/uploads\/2023\/11\/buoc-ghep-cot-50x24.png 50w, \/accounting\/wp-content\/uploads\/2023\/11\/buoc-ghep-cot-1536x722.png 1536w, \/accounting\/wp-content\/uploads\/2023\/11\/buoc-ghep-cot-60x28.png 60w, \/accounting\/wp-content\/uploads\/2023\/11\/buoc-ghep-cot-100x47.png 100w\" sizes=\"(max-width: 1584px) 100vw, 1584px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Khi t\u00ean c\u1ed9t \u0111\u00e3 s\u1eeda tr\u00ean ph\u1ea7n m\u1ec1m v\u00e0 t\u00ean c\u1ed9t tr\u00ean t\u1ec7p excel gi\u1ed1ng nhau th\u00ec ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng gh\u00e9p lu\u00f4n m\u00e0 Anh\/Ch\u1ecb kh\u00f4ng c\u1ea7n ph\u1ea3i t\u1ef1 gh\u00e9p b\u1eb1ng tay.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-27946\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2023\/11\/bang-luong-sau-khi-nhap-khau-excel.png\" alt=\"\" width=\"1582\" height=\"744\" srcset=\"\/accounting\/wp-content\/uploads\/2023\/11\/bang-luong-sau-khi-nhap-khau-excel.png 1582w, \/accounting\/wp-content\/uploads\/2023\/11\/bang-luong-sau-khi-nhap-khau-excel-768x361.png 768w, \/accounting\/wp-content\/uploads\/2023\/11\/bang-luong-sau-khi-nhap-khau-excel-50x24.png 50w, \/accounting\/wp-content\/uploads\/2023\/11\/bang-luong-sau-khi-nhap-khau-excel-1536x722.png 1536w, \/accounting\/wp-content\/uploads\/2023\/11\/bang-luong-sau-khi-nhap-khau-excel-60x28.png 60w, \/accounting\/wp-content\/uploads\/2023\/11\/bang-luong-sau-khi-nhap-khau-excel-100x47.png 100w\" sizes=\"(max-width: 1582px) 100vw, 1582px\" \/><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Ngo\u00e0i ra, ngay sau khi Anh\/Ch\u1ecb s\u1eeda m\u1eabu b\u1ea3ng l\u01b0\u01a1ng tr\u00ean ph\u1ea7n m\u1ec1m th\u00e0nh c\u00f4ng, th\u00ec t\u1ec7p m\u1eabu d\u1eef li\u1ec7u b\u1ea3ng l\u01b0\u01a1ng tr\u00ean ph\u1ea7n m\u1ec1m c\u0169ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt. Anh\/Ch\u1ecb c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n <strong>T\u1ea3i t\u1ec7p d\u1eef li\u1ec7u b\u1ea3ng l\u01b0\u01a1ng<\/strong> v\u1ec1 \u0111\u1ec3 nh\u1eadp li\u1ec7u cho kh\u1edbp v\u1edbi m\u1eabu b\u1ea3ng l\u01b0\u01a1ng tr\u00ean ph\u1ea7n m\u1ec1m.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-27947\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2023\/11\/tai-tep-bang-luong.png\" alt=\"\" width=\"1585\" height=\"744\" srcset=\"\/accounting\/wp-content\/uploads\/2023\/11\/tai-tep-bang-luong.png 1585w, \/accounting\/wp-content\/uploads\/2023\/11\/tai-tep-bang-luong-768x360.png 768w, \/accounting\/wp-content\/uploads\/2023\/11\/tai-tep-bang-luong-50x23.png 50w, \/accounting\/wp-content\/uploads\/2023\/11\/tai-tep-bang-luong-1536x721.png 1536w, \/accounting\/wp-content\/uploads\/2023\/11\/tai-tep-bang-luong-60x28.png 60w, \/accounting\/wp-content\/uploads\/2023\/11\/tai-tep-bang-luong-100x47.png 100w\" sizes=\"(max-width: 1585px) 100vw, 1585px\" \/><\/p>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":114,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[3522],"ht-kb-tag":[],"class_list":["post-27850","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r47"],"_links":{"self":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/27850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/users\/114"}],"replies":[{"embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/comments?post=27850"}],"version-history":[{"count":4,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/27850\/revisions"}],"predecessor-version":[{"id":47685,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/27850\/revisions\/47685"}],"wp:attachment":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/media?parent=27850"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-category?post=27850"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-tag?post=27850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}