{"id":1001,"date":"2018-12-25T17:48:19","date_gmt":"2018-12-25T10:48:19","guid":{"rendered":"http:\/\/help.smecloud.misa.local\/?post_type=ht_kb&#038;p=1001"},"modified":"2026-01-08T10:15:19","modified_gmt":"2026-01-08T03:15:19","slug":"html_10050000","status":"publish","type":"ht_kb","link":"http:\/\/helpasp.misa.vn\/accounting\/kb\/html_10050000\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nh\u1eadp c\u00e1c Danh m\u1ee5c, S\u1ed1 d\u01b0, Ch\u1ee9ng t\u1eeb t\u1eeb file excel v\u00e0o ph\u1ea7n m\u1ec1m?"},"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 n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1ch\u00a0<strong>nh\u1eadp d\u1eef li\u1ec7u k\u1ebf to\u00e1n t\u1eeb t\u1ec7p Excel v\u00e0o ph\u1ea7n m\u1ec1m<\/strong>, g\u1ed3m c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u: Danh m\u1ee5c, S\u1ed1 d\u01b0, Ch\u1ee9ng t\u1eeb. Thao t\u00e1c n\u00e0y gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m thi\u1ec3u thao t\u00e1c khi l\u00e0m vi\u1ec7c<\/p>\n<p><strong>N\u1ed9i dung:<\/strong><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Nh\u1eadp danh m\u1ee5c t\u1eeb Excel<\/li>\n<li>Nh\u1eadp s\u1ed1 d\u01b0 t\u1eeb Excel<\/li>\n<li>Nh\u1eadp ch\u1ee9ng t\u1eeb t\u1eeb Excel<\/li>\n<\/ul>\n<p><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong> K\u1ebf to\u00e1n, Qu\u1ea3n tr\u1ecb h\u1ec7 th\u1ed1ng, Ng\u01b0\u1eddi d\u00f9ng nh\u1eadp li\u1ec7u<\/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>Cho ph\u00e9p nh\u1eadp d\u1eef li\u1ec7u k\u1ebf to\u00e1n t\u1eeb t\u1ec7p Excel v\u00e0o ph\u1ea7n m\u1ec1m. G\u1ed3m c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u sau: <strong>Danh m\u1ee5c, S\u1ed1 d\u01b0, Ch\u1ee9ng t\u1eeb<\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\"><\/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<h4>2.1. Nh\u1eadp danh m\u1ee5c t\u1eeb file Excel<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o bi\u1ec3u t\u01b0\u1ee3ng b\u00e1nh r\u0103ng <span data-sheets-root=\"1\">\u2699<\/span> <strong>C\u00e1c ti\u1ec7n \u00edch v\u00e0 thi\u1ebft l\u1eadp\\T\u1ea5t c\u1ea3 danh m\u1ee5c<\/strong>, ch\u1ecdn danh m\u1ee5c c\u1ea7n th\u1ef1c hi\u1ec7n khai b\u00e1o<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-35907\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2025\/05\/3-5-1600x969.png\" alt=\"\" width=\"1600\" height=\"969\" srcset=\"\/accounting\/wp-content\/uploads\/2025\/05\/3-5-1600x969.png 1600w, \/accounting\/wp-content\/uploads\/2025\/05\/3-5-768x465.png 768w, \/accounting\/wp-content\/uploads\/2025\/05\/3-5-50x30.png 50w, \/accounting\/wp-content\/uploads\/2025\/05\/3-5-1536x930.png 1536w, \/accounting\/wp-content\/uploads\/2025\/05\/3-5-60x36.png 60w, \/accounting\/wp-content\/uploads\/2025\/05\/3-5-100x61.png 100w, \/accounting\/wp-content\/uploads\/2025\/05\/3-5.png 1816w\" sizes=\"(max-width: 1600px) 100vw, 1600px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn m\u0169i t\u00ean <span data-sheets-root=\"1\">\u23f7 \u1edf ch\u1ee9c n\u0103ng <strong>Th\u00eam<\/strong>, ch\u1ecdn<\/span>\u00a0<strong>Nh\u1eadp t\u1eeb excel<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24562\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/47.png\" alt=\"\" width=\"1010\" height=\"219\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/47.png 1010w, \/accounting\/wp-content\/uploads\/2018\/12\/47-768x167.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/47-50x11.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/47-60x13.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/47-100x22.png 100w\" sizes=\"(max-width: 1010px) 100vw, 1010px\" \/><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb giao di\u1ec7n<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24563\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/48.png\" alt=\"\" width=\"1209\" height=\"648\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/48.png 1209w, \/accounting\/wp-content\/uploads\/2018\/12\/48-768x412.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/48-50x27.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/48-60x32.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/48-100x54.png 100w\" sizes=\"(max-width: 1209px) 100vw, 1209px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3: Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Ch\u1ecdn file nh\u1eadp kh\u1ea9u t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh ho\u1eb7c c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u1ec1 \u0111\u1ec3 t\u1ea1o file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u.<\/li>\n<li>Ch\u1ecdn sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp v\u00e0 l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u.<\/li>\n<li>C\u00f3 3 l\u1ef1a ch\u1ecdn nh\u1eadp kh\u1ea9u th\u00f4ng tin:\n<ul style=\"list-style-type: circle;\">\n<li><strong>Th\u00eam m\u1edbi:<\/strong> D\u1eef li\u1ec7u m\u00e3 VTHH, NCC, kh\u00e1ch h\u00e0ng \u2026 tr\u00ean t\u1ec7p excel m\u00e0 ch\u01b0a c\u00f3 tr\u00ean h\u1ec7 th\u1ed1ng th\u00ec s\u1ebd \u0111\u01b0\u1ee3c th\u00eam m\u1edbi v\u00e0o. D\u1eef li\u1ec7u m\u00e3 VTHH, NCC, kh\u00e1ch h\u00e0ng \u2026 tr\u00ean t\u1ec7p m\u00e0 \u0111\u00e3 c\u00f3 tr\u00ean h\u1ec7 th\u1ed1ng s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt v\u00e0o.<\/li>\n<li><strong>C\u1eadp nh\u1eadt:<\/strong> C\u1eadp nh\u1eadt, b\u1ed5 sung th\u00eam c\u00e1c th\u00f4ng tin c\u1ee7a c\u00e1c m\u00e3 \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o t\u1eeb tr\u01b0\u1edbc tr\u00ean danh m\u1ee5c.<\/li>\n<li><strong>Ghi \u0111\u00e8:<\/strong> To\u00e0n b\u1ed9 d\u1eef li\u1ec7u tr\u00ean h\u1ec7 th\u1ed1ng s\u1ebd b\u1ecb x\u00f3a \u0111i v\u00e0 thay th\u1ebf b\u1eb1ng d\u1eef li\u1ec7u tr\u00ean t\u1ec7p excel.<\/li>\n<\/ul>\n<\/li>\n<li>Sau khi \u0111\u00e3 l\u1ef1a ch\u1ecdn xong, nh\u1ea5n <strong>Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n qua b\u01b0\u1edbc 2.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 4: Gh\u00e9p d\u1eef li\u1ec7u<\/strong><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Tr\u01b0\u1eddng h\u1ee3p l\u1ea5y t\u1eeb file m\u1eabu th\u00ec ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng gh\u00e9p c\u00e1c c\u1ed9t tr\u00ean file d\u1eef li\u1ec7u v\u00e0 c\u00e1c c\u1ed9t th\u00f4ng tin tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-15725\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/5.png\" alt=\"\" width=\"1038\" height=\"590\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/5.png 1038w, \/accounting\/wp-content\/uploads\/2018\/12\/5-768x437.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/5-50x28.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/5-60x34.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/5-100x57.png 100w\" sizes=\"(max-width: 1038px) 100vw, 1038px\" \/><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Tr\u01b0\u1eddng h\u1ee3p l\u00e0 file t\u1ef1 t\u1ea1o kh\u00f4ng theo m\u1eabu ch\u01b0\u01a1ng tr\u00ecnh c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n gh\u00e9p c\u1ed9t th\u1ee7 c\u00f4ng<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-15726\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/6.png\" alt=\"\" width=\"1042\" height=\"594\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/6.png 1042w, \/accounting\/wp-content\/uploads\/2018\/12\/6-768x438.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/6-50x29.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/6-60x34.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/6-100x57.png 100w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/p>\n<p><em><strong>L\u01b0u \u00fd<\/strong>:<\/em><\/p>\n<ul style=\"list-style-type: disc;\">\n<li><em>T\u1ea1i d\u00f2ng\u00a0<strong>c\u00f3 t\u00edch ch\u1ecdn<\/strong>\u00a0\u201c<strong>B\u1eaft bu\u1ed9c gh\u00e9p c\u1ed9t v\u00e0 nh\u1eadp th\u00f4ng tin\u201d\u00a0<\/strong>\u00a0th\u00ec\u00a0 ph\u1ea3i \u0111\u1ea3m b\u1ea3o c\u1ed9t tr\u00ean t\u1ec7p excel t\u01b0\u01a1ng \u1ee9ng c\u00f3 nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin li\u00ean quan.<\/em><\/li>\n<li><em>N\u1ebfu\u00a0<strong>kh\u00f4ng t\u00edch ch\u1ecdn<\/strong>\u00a0\u201c<strong>B\u1eaft bu\u1ed9c gh\u00e9p c\u1ed9t v\u00e0 nh\u1eadp th\u00f4ng tin\u201d<\/strong>, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd l\u1ea5y th\u00f4ng tin ng\u1ea7m \u0111\u1ecbnh ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng theo y\u00eau c\u1ea7u c\u1ee7a t\u1eebng tr\u01b0\u1eddng d\u1eef li\u1ec7u theo t\u1eebng danh m\u1ee5c, ch\u1ee9ng t\u1eeb.<\/em><\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/helpact.misa.vn\/wp-content\/uploads\/2018\/12\/DM_5.jpg\" \/><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Tr\u01b0\u1eddng h\u1ee3p l\u1ea5y th\u00eam ho\u1eb7c b\u1ecf b\u1edbt c\u00e1c th\u00f4ng tin tr\u00ean c\u00e1c m\u00e3 danh m\u1ee5c c\u1ea7n nh\u1eadp kh\u1ea9u th\u00ec c\u00f3 th\u1ec3 t\u00edch <strong>\u1ea8n\/hi\u1ec7n th\u00f4ng tin<\/strong><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-15727\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/7.png\" alt=\"\" width=\"1046\" height=\"760\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/7.png 1046w, \/accounting\/wp-content\/uploads\/2018\/12\/7-768x558.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/7-50x36.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/7-60x44.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/7-100x73.png 100w\" sizes=\"(max-width: 1046px) 100vw, 1046px\" \/><\/p>\n<p><strong style=\"font-family: inherit; font-size: inherit;\">B\u01b0\u1edbc 5: Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong><\/p>\n<ul style=\"list-style-type: disc;\">\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.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-15728\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/8.png\" alt=\"\" width=\"1366\" height=\"625\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/8.png 1366w, \/accounting\/wp-content\/uploads\/2018\/12\/8-768x351.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/8-50x23.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/8-60x27.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/8-100x46.png 100w\" sizes=\"(max-width: 1366px) 100vw, 1366px\" \/><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Khi \u0111\u00f3 c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:\n<ul>\n<li>Nh\u1ea5n <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 t\u1ea3i file k\u1ebft qu\u1ea3 \u0111\u1ec3 ki\u1ec3m tra l\u1ea1i. Sau \u0111\u00f3 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: K\u1ebft qu\u1ea3 nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u<\/strong><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c m\u00e3 \u0111\u00e3 nh\u1eadp th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra \u1edf b\u01b0\u1edbc 3<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-15729\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/9.png\" alt=\"\" width=\"1082\" height=\"594\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/9.png 1082w, \/accounting\/wp-content\/uploads\/2018\/12\/9-768x422.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/9-50x27.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/9-60x33.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/9-100x55.png 100w\" sizes=\"(max-width: 1082px) 100vw, 1082px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 7:<\/strong> Nh\u1ea5n <strong>\u0110\u00f3ng <\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u <strong>X<\/strong> \u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u danh m\u1ee5c.<\/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<h4>2.2. Nh\u1eadp s\u1ed1 d\u01b0 t\u1eeb file Excel<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o b\u00e1nh r\u0103ng <span data-sheets-root=\"1\">\u2699<\/span> <strong>C\u00e1c<\/strong> t<strong>i\u1ec7n \u00edch v\u00e0 thi\u1ebft l\u1eadp\\Nh\u1eadp s\u1ed1 d\u01b0 ban \u0111\u1ea7u<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-38157\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2025\/09\/1-3.png\" alt=\"\" width=\"1392\" height=\"561\" srcset=\"\/accounting\/wp-content\/uploads\/2025\/09\/1-3.png 1392w, \/accounting\/wp-content\/uploads\/2025\/09\/1-3-768x310.png 768w, \/accounting\/wp-content\/uploads\/2025\/09\/1-3-50x20.png 50w, \/accounting\/wp-content\/uploads\/2025\/09\/1-3-60x24.png 60w, \/accounting\/wp-content\/uploads\/2025\/09\/1-3-100x40.png 100w\" sizes=\"(max-width: 1392px) 100vw, 1392px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb danh s\u00e1ch c\u00e1c lo\u1ea1i s\u1ed1 d\u01b0 \u0111\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eadp<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24551\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/41.png\" alt=\"\" width=\"1267\" height=\"707\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/41.png 1267w, \/accounting\/wp-content\/uploads\/2018\/12\/41-768x429.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/41-50x28.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/41-60x33.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/41-100x56.png 100w\" sizes=\"(max-width: 1267px) 100vw, 1267px\" \/><\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong> Nh\u1eadp s\u1ed1 d\u01b0 t\u00e0i kho\u1ea3n t\u1eeb file excel:<\/p>\n<p>Tr\u00ean ch\u1ee9c n\u0103ng <strong>Nh\u1eadp s\u1ed1 d\u01b0<\/strong>, ch\u1ecdn ti\u1ec7n \u00edch<strong> Nh\u1eadp s\u1ed1 d\u01b0 ban \u0111\u1ea7u t\u1eeb Excel<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24554\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/43.png\" alt=\"\" width=\"1269\" height=\"184\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/43.png 1269w, \/accounting\/wp-content\/uploads\/2018\/12\/43-768x111.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/43-50x7.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/43-60x9.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/43-100x14.png 100w\" sizes=\"(max-width: 1269px) 100vw, 1269px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3: Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong>: T\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eadp kh\u1ea9u danh m\u1ee5c.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> <strong>Gh\u00e9p d\u1eef li\u1ec7u<\/strong>: Nh\u1eadp kh\u1ea9u <strong>Th\u00eam m\u1edbi<\/strong>,\u00a0 C\u00f3 th\u1ec3 gh\u00e9p \u0111\u01b0\u1ee3c c\u00e1c c\u1ed9t d\u1eef li\u1ec7u tr\u00ean file nh\u1eadp kh\u1ea9u v\u00e0 tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> <strong>Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong>: Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1eef li\u1ec7u h\u1ee3p l\u1ec7 ho\u1eb7c kh\u00f4ng h\u1ee3p l\u1ec7 tr\u00ean file d\u1eef li\u1ec7u c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh ho\u1eb7c ti\u1ebfn h\u00e0nh nh\u1eadp d\u1eef li\u1ec7u lu\u00f4n.<\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> <strong>Th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 nh\u1eadp li\u1ec7u<\/strong><\/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<h4>2.3. Nh\u1eadp ch\u1ee9ng t\u1eeb t\u1eeb file Excel<\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn ph\u00e2n h\u1ec7 c\u1ea7n th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb, tr\u00ean giao di\u1ec7n danh s\u00e1ch ch\u1ecdn m\u0169i t\u00ean <span data-sheets-root=\"1\">\u23f7<\/span> ch\u1ee9c n\u0103ng <strong>Th\u00eam,<\/strong> ch\u1ecdn ti\u1ec7n \u00edch <strong>Nh\u1eadp t\u1eeb excel<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24556\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/44.png\" alt=\"\" width=\"1271\" height=\"474\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/44.png 1271w, \/accounting\/wp-content\/uploads\/2018\/12\/44-768x286.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/44-50x19.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/44-60x22.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/44-100x37.png 100w\" sizes=\"(max-width: 1271px) 100vw, 1271px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u01b0\u01a1ng tr\u00ecnh hi\u1ec3n th\u1ecb giao di\u1ec7n t\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eadp kh\u1ea9u danh m\u1ee5c<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24557\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/45.png\" alt=\"\" width=\"1262\" height=\"540\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/45.png 1262w, \/accounting\/wp-content\/uploads\/2018\/12\/45-768x329.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/45-50x21.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/45-60x26.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/45-100x43.png 100w\" sizes=\"(max-width: 1262px) 100vw, 1262px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3: Ch\u1ecdn t\u1ec7p ngu\u1ed3n: <\/strong><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Ch\u1ecdn \u0111\u00fang lo\u1ea1i ch\u1ee9ng t\u1eeb tr\u01b0\u1edbc khi ch\u1ecdn file d\u1eef li\u1ec7u ho\u1eb7c t\u1ea3i file m\u1eabu \u0111\u1ec3 tr\u00e1nh ph\u00e1t sinh l\u1ed7i \u1edf c\u00e1c b\u01b0\u1edbc sau do sai \u0111\u1ecbnh d\u1ea1ng, th\u00f4ng tin d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp kh\u1ea9u c\u1ee7a m\u1ed7i lo\u1ea1i ch\u1ee9ng t\u1eeb.<\/li>\n<li>Ch\u1ec9 nh\u1eadp kh\u1ea9u th\u00eam m\u1edbi ch\u1ee9ng t\u1eeb.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> <strong>Gh\u00e9p d\u1eef li\u1ec7u<\/strong>: T\u01b0\u01a1ng t\u1ef1 nh\u01b0 khi nh\u1eadp kh\u1ea9u danh m\u1ee5c c\u00f3 th\u1ec3 gh\u00e9p \u0111\u01b0\u1ee3c c\u00e1c c\u1ed9t d\u1eef li\u1ec7u tr\u00ean file nh\u1eadp kh\u1ea9u v\u00e0 tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> <strong>Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong>: Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1eef li\u1ec7u h\u1ee3p l\u1ec7 ho\u1eb7c kh\u00f4ng h\u1ee3p l\u1ec7 tr\u00ean file d\u1eef li\u1ec7u c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh ho\u1eb7c ti\u1ebfn h\u00e0nh nh\u1eadp d\u1eef li\u1ec7u lu\u00f4n.<\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> <strong>Th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 nh\u1eadp li\u1ec7u<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\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><strong>3. L\u01b0u \u00fd<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>Sau khi nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng th\u00ec ch\u1ee9ng t\u1eeb s\u1ebd \u1edf tr\u1ea1ng th\u00e1i ch\u01b0a ghi s\u1ed5, c\u1ea7n th\u1ef1c hi\u1ec7n ghi s\u1ed5 ch\u1ee9ng t\u1eeb \u0111\u1ec3 ghi nh\u1eadn b\u00fat to\u00e1n l\u00ean c\u00e1c b\u00e1o c\u00e1o, s\u1ed5 s\u00e1ch k\u1ebf to\u00e1n.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-15733\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/13.png\" alt=\"\" width=\"872\" height=\"536\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/13.png 872w, \/accounting\/wp-content\/uploads\/2018\/12\/13-768x472.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/13-50x31.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/13-60x37.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/13-100x61.png 100w\" sizes=\"(max-width: 872px) 100vw, 872px\" \/><\/p>\n<p><strong>L\u01b0u \u00fd: <\/strong>Tr\u01b0\u1eddng h\u1ee3p khi nh\u1eadp kh\u1ea9u v\u00e0o ph\u1ea7n m\u1ec1m b\u00e1o l\u1ed7i kh\u00f4ng h\u1ee3p l\u1ec7 th\u00ec xem h\u01b0\u1edbng d\u1eabn x\u1eed l\u00fd <a href=\"https:\/\/helpasp.misa.vn\/accounting\/kb\/lam-the-nao-khi-nhap-khau-danh-muc-so-du-chung-tu-tu-file-excel-vao-phan-mem-bao-loi-khong-hop-le\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":115,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[3301],"ht-kb-tag":[],"class_list":["post-1001","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-chtg"],"_links":{"self":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/1001","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\/115"}],"replies":[{"embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/comments?post=1001"}],"version-history":[{"count":11,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/1001\/revisions"}],"predecessor-version":[{"id":56131,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/1001\/revisions\/56131"}],"wp:attachment":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/media?parent=1001"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-category?post=1001"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-tag?post=1001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}