{"id":24473,"date":"2022-04-13T15:40:24","date_gmt":"2022-04-13T08:40:24","guid":{"rendered":"http:\/\/helpsme.misa.vn\/2022\/?post_type=ht_kb&#038;p=24473"},"modified":"2026-04-23T11:42:09","modified_gmt":"2026-04-23T04:42:09","slug":"lam-the-nao-de-nhap-khau-cac-danh-muc-so-du-chung-tu-tu-file-excel-vao-phan-mem","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2026\/kb\/lam-the-nao-de-nhap-khau-cac-danh-muc-so-du-chung-tu-tu-file-excel-vao-phan-mem\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nh\u1eadp kh\u1ea9u 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":"<p><b>Xem phim h\u01b0\u1edbng d\u1eabn<\/b><\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/DqdPVehb9tc\" width=\"860\" height=\"484\"><\/iframe><\/p>\n<p><b>T\u1ea3i phim h\u01b0\u1edbng d\u1eabn: <a href=\"https:\/\/vimeo.com\/198329302\">T\u1ea1i \u0111\u00e2y<\/a><\/b> (<a href=\"xem_va_tai_phim_huong_dan\">Xem h\u01b0\u1edbng d\u1eabn t\u1ea3i phim<\/a>)<br \/>\n<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<b>M\u1ee5c \u0111\u00edch:<\/b> H\u01b0\u1edbng d\u1eabn nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u k\u1ebf to\u00e1n t\u1eeb t\u1ec7p Excel v\u00e0o ph\u1ea7n m\u1ec1m, bao g\u1ed3m c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u: Danh m\u1ee5c, S\u1ed1 d\u01b0, Ch\u1ee9ng t\u1eeb.<br \/>\n<b>N\u1ed9i dung:<\/b><\/p>\n<ul>\n<li>H\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb Excel v\u00e0o ph\u1ea7n m\u1ec1m.<\/li>\n<li>Gi\u1ea3i th\u00edch c\u00e1c h\u00ecnh th\u1ee9c nh\u1eadp kh\u1ea9u v\u00e0 c\u00e1ch gh\u00e9p d\u1eef li\u1ec7u.<\/li>\n<li>L\u01b0u \u00fd khi nh\u1eadp kh\u1ea9u t\u1eebng lo\u1ea1i d\u1eef li\u1ec7u, nh\u1eadp kh\u1ea9u 1 ch\u1ee9ng t\u1eeb\/ h\u00f3a \u0111\u01a1n c\u00f3 2 d\u00f2ng ho\u1eb7c nhi\u1ec1u d\u00f2ng h\u00e0ng h\u00f3a d\u1ecbch v\u1ee5<\/li>\n<\/ul>\n<p><b>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/b> K\u1ebf to\u00e1n, qu\u1ea3n tr\u1ecb d\u1eef li\u1ec7u, ng\u01b0\u1eddi d\u00f9ng nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u k\u1ebf to\u00e1n <\/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<ul>\n<li>V\u00e0o menu <b>T\u1ec7p\\Nh\u1eadp kh\u1ea9u t\u1eeb Excel<\/b>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/2026\/wp-content\/uploads\/2022\/04\/A4-Copy.jpg\" alt=\"\" width=\"454\" height=\"317\" \/><\/p>\n<ul>\n<li>Tr\u00ean b\u1ea3ng Nh\u1eadp kh\u1ea9u, th\u1ef1c hi\u1ec7n <b>04 b\u01b0\u1edbc<\/b> nh\u01b0 sau:<\/li>\n<\/ul>\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><b>2.1 Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn lo\u1ea1i d\u1eef li\u1ec7u l\u00e0 <b>Danh m\u1ee5c<\/b> ho\u1eb7c <b>S\u1ed1 d\u01b0<\/b> ho\u1eb7c <b>Ch\u1ee9ng t\u1eeb<\/b><\/li>\n<li><strong>B\u01b0\u1edbc 2: <\/strong>Ch\u1ecdn chi ti\u1ebft c\u1ee7a <b>Danh m\u1ee5c<\/b>\/<b>S\u1ed1 d\u01b0<\/b>\/<b>Ch\u1ee9ng t\u1eeb<\/b> c\u1ea7n nh\u1eadp kh\u1ea9u. (VD: danh m\u1ee5c Kh\u00e1ch h\u00e0ng)<\/li>\n<li><strong>B\u01b0\u1edbc 3: <\/strong>\u0110\u01b0\u1eddng d\u1eabn \u0111\u1ebfn t\u1ec7p d\u1eef li\u1ec7u: Ch\u1ecdn t\u1ec7p excel c\u1ea7n nh\u1eadp kh\u1ea9u b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/2022\/wp-content\/uploads\/2019\/12\/nhap_khau_tu_excel_02.png&quot;\" alt=\"\" width=\"31\" height=\"26\" \/>\n<ul style=\"list-style-type: disc;\">\n<li><strong>L\u01b0u \u00fd:<\/strong> sau khi ch\u1ecdn t\u1ec7p excel c\u1ea7n nh\u1eadp kh\u1ea9u th\u00ec t\u1ea1i m\u1ee5c <strong>Ch\u1ecdn sheet ch\u1ee9a d\u1eef li\u1ec7u<\/strong> c\u1ea7n \u0111\u1ea3m b\u1ea3o \u0111\u00e3 ch\u1ecdn \u0111\u00fang sheet tr\u00ean file excel m\u00e0 kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng v\u00ec s\u1ebd g\u1eb7p l\u1ed7i b\u00e1o: <strong>Sheet ch\u1ee9a d\u1eef li\u1ec7u kh\u00f4ng \u0111\u01b0\u1ee3c b\u1ecf tr\u1ed1ng<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large\" src=\"\/2026\/wp-content\/uploads\/2018\/12\/86-800x615.png\" alt=\"\" width=\"800\" height=\"615\" \/><br \/>\n<b><em>L\u01b0u \u00fd:<\/em><\/b> <em>T\u1ec7p d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u c\u00f3 th\u1ec3 l\u00e0 t\u1ec7p d\u1eef li\u1ec7u b\u1eb1ng excel c\u00f3 s\u1eb5n c\u1ee7a Doanh nghi\u1ec7p ho\u1eb7c c\u00f3 th\u1ec3 nh\u1ea5n <b>T\u1ea3i t\u1ec7p d\u1eef li\u1ec7u m\u1eabu&#8230;<\/b> \u0111\u1ec3 l\u1ea5y t\u1ec7p m\u1eabu c\u1ee7a ch\u01b0\u01a1ng tr\u00ecnh. Sau \u0111\u00f3 sao ch\u00e9p c\u00e1c c\u1ed9t d\u1eef li\u1ec7u tr\u00ean T\u1ec7p c\u00f3 s\u1eb5n v\u00e0o c\u00e1c c\u1ed9t t\u01b0\u01a1ng \u1ee9ng c\u1ee7a T\u1ec7p m\u1eabu nh\u1eadp kh\u1ea9u.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"\/2026\/wp-content\/uploads\/2022\/08\/Nhap_khau_tu_Excel_03-700x492.png\" alt=\"\" width=\"700\" height=\"492\" \/><\/p>\n<ul>\n<li><b><strong>B\u01b0\u1edbc 4: <\/strong><\/b>Ch\u1ecdn h\u00ecnh th\u1ee9c nh\u1eadp kh\u1ea9u:\n<ul>\n<li><em>Nh\u1eadp kh\u1ea9u <b>Th\u00eam m\u1edbi<\/b>: S\u1eed d\u1ee5ng h\u00ecnh th\u1ee9c n\u00e0y n\u1ebfu danh m\u1ee5c\/s\u1ed1 d\u01b0\/ch\u1ee9ng t\u1eeb tr\u00ean file excel nh\u1eadp kh\u1ea9u ch\u01b0a t\u1ed3n t\u1ea1i tr\u00ean ph\u1ea7n m\u1ec1m, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd th\u00eam m\u1edbi c\u00e1c danh m\u1ee5c\/s\u1ed1 d\u01b0\/ch\u1ee9ng t\u1eeb tr\u00ean file excel v\u00e0o ph\u1ea7n m\u1ec1m<\/em><\/li>\n<li><em>Nh\u1eadp kh\u1ea9u <b>C\u1eadp nh\u1eadt<\/b>: S\u1eed d\u1ee5ng h\u00ecnh th\u1ee9c n\u00e0y n\u1ebfu mu\u1ed1n nh\u1eadp kh\u1ea9u l\u1ea1i \u0111\u1ec3 b\u1ed5 sung th\u00eam th\u00f4ng tin ho\u1eb7c \u0111i\u1ec1u ch\u1ec9nh l\u1ea1i gi\u00e1 tr\u1ecb \u0111\u00e3 nh\u1eadp kh\u1ea9u tr\u01b0\u1edbc \u0111\u00f3, ch\u1ee9c n\u0103ng nay kh\u00f4ng h\u1ed7 tr\u1ee3 c\u1eadp nh\u1eadt l\u1ea1i c\u00e1c th\u00f4ng tin li\u00ean quan \u0111\u1ebfn m\u00e3 nh\u01b0 m\u00e3 h\u00e0ng, m\u00e3 \u0111\u1ed1i t\u01b0\u1ee3ng, m\u00e3 kh\u00e1ch h\u00e0ng, m\u00e3 nh\u00e0 cung c\u1ea5p,&#8230;(ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd kh\u00f4ng x\u00f3a c\u00e1c th\u00f4ng tin \u0111\u00e3 c\u00f3 tr\u00ean ph\u1ea7n m\u1ec1m m\u00e0 kh\u00f4ng c\u00f3 tr\u00ean file excel nh\u1eadp kh\u1ea9u l\u1ea1i).<\/em><\/li>\n<li><em>Nh\u1eadp kh\u1ea9u <b>Ghi \u0111\u00e8<\/b>: S\u1eed d\u1ee5ng h\u00ecnh th\u1ee9c n\u00e0y n\u1ebfu mu\u1ed1n x\u00f3a to\u00e0n b\u1ed9 th\u00f4ng tin \u0111\u00e3 nh\u1eadp kh\u1ea9u \u0111\u1ec3 nh\u1eadp kh\u1ea9u l\u1ea1i theo file excel m\u1edbi. H\u00ecnh th\u1ee9c n\u00e0y kh\u00f4ng \u00e1p d\u1ee5ng cho lo\u1ea1i Ch\u1ee9ng t\u1eeb v\u00e0 Danh m\u1ee5c.<\/em><\/li>\n<li>L\u01b0u \u00fd khi th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb th\u00ec ph\u1ea7n m\u1ec1m s\u1ebd m\u1eb7c \u0111\u1ecbnh h\u00ecnh th\u1ee9c l\u00e0 th\u00eam m\u1edbi v\u00e0 ch\u01b0a h\u1ed7 tr\u1ee3 h\u00ecnh th\u1ee9c C\u1eadp nh\u1eadt ho\u1eb7c Ghi \u0111\u00e8. \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u1eadp nh\u1eadt l\u1ea1i ch\u1ee9ng t\u1eeb \u0111\u00e3 nh\u1eadp kh\u1ea9u excel th\u00ec ph\u1ea3i th\u1ef1c hi\u1ec7n x\u00f3a ch\u1ee9ng t\u1eeb \u0111\u00e3 nh\u1eadp kh\u1ea9u tr\u01b0\u1edbc \u0111\u00f3 nh\u1eadp kh\u1ea9u th\u00eam m\u1edbi l\u1ea1i<\/li>\n<\/ul>\n<\/li>\n<li><strong>B\u01b0\u1edbc 5: <\/strong>Nh\u1ea5n <b>Ti\u1ebfp theo<\/b> \u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc <b>Gh\u00e9p d\u1eef li\u1ec7u<\/b>.<\/li>\n<\/ul>\n<p><strong>L\u01b0u \u00fd:<\/strong> Hi\u1ec7n t\u1ea1i ph\u1ea7n m\u1ec1m \u0111\u00e1p \u1ee9ng nh\u1eadp kh\u1ea9u excel c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u sau:<\/p>\n<ul>\n<li><strong>Danh m\u1ee5c:<\/strong> Nh\u00f3m kh\u00e1ch h\u00e0ng, nh\u00e0 cung c\u1ea5p, Kh\u00e1ch h\u00e0ng, Nh\u00e0 cung c\u1ea5p, Nh\u00e2n vi\u00ean, Nh\u00f3m v\u1eadt t\u01b0, h\u00e0ng h\u00f3a, V\u1eadt t\u01b0 h\u00e0ng h\u00f3a, \u0110\u1ed1i t\u01b0\u1ee3ng THCP, C\u00f4ng tr\u00ecnh, M\u00e3 th\u1ed1ng k\u00ea, C\u01a1 c\u1ea5u t\u1ed5 ch\u1ee9c, Kho, Kho\u1ea3n m\u1ee5c chi ph\u00ed, M\u1ee5c thu\/chi.<\/li>\n<li><strong>S\u1ed1 d\u01b0: <\/strong>S\u1ed1 d\u01b0 t\u00e0i kho\u1ea3n, S\u1ed1 d\u01b0 t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng, C\u00f4ng n\u1ee3 kh\u00e1ch h\u00e0ng, C\u00f4ng n\u1ee3 nh\u00e0 cung c\u1ea5p, C\u00f4ng n\u1ee3 nh\u00e2n vi\u00ean, T\u1ed3n kho v\u1eadt t\u01b0, h\u00e0ng h\u00f3a, Chi ph\u00ed d\u1edf dang theo \u0110T t\u1eadp h\u1ee3p CP, Chi ph\u00ed d\u1edf dang theo c\u00f4ng tr\u00ecnh, Chi ph\u00ed d\u1edf dang theo \u0111\u01a1n \u0111\u1eb7t h\u00e0ng, Chi ph\u00ed d\u1edf dang theo h\u1ee3p \u0111\u1ed3ng b\u00e1n, Khai b\u00e1o t\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh \u0111\u1ea7u k\u1ef3, Khai b\u00e1o CCDC \u0111\u1ea7u k\u1ef3, Doanh thu nh\u1eadn tr\u01b0\u1edbc \u0111\u1ea7u k\u1ef3, Chi ph\u00ed tr\u1ea3 tr\u01b0\u1edbc \u0111\u1ea7u k\u1ef3.<\/li>\n<li><strong>Ch\u1ee9ng t\u1eeb:<\/strong>\n<ul style=\"list-style-type: disc;\">\n<li>\u00a0T\u00edch \u0111\u00fap v\u00e0o Q\u0169y \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb:\u00a0 Phi\u1ebfu thu, Phi\u1ebfu chi.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o Ng\u00e2n h\u00e0ng \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb: Thu ti\u1ec1n g\u1eedi, Chi ti\u1ec1n g\u1eedi, Chuy\u1ec3n ti\u1ec1n n\u1ed9i b\u1ed9.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o Kh\u1ebf \u01b0\u1edbc vay \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb: H\u1ee3p \u0111\u1ed3ng t\u00edn d\u1ee5ng, Kh\u1ebf \u01b0\u1edbc vay, Kh\u1ebf \u01b0\u1edbc vay \u0111\u1ea7u k\u1ef3.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o Mua h\u00e0ng \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb:\u00a0 \u0110\u01a1n mua h\u00e0ng, H\u1ee3p \u0111\u1ed3ng mua h\u00e0ng, Mua h\u00e0ng qua kho, Mua h\u00e0ng kh\u00f4ng qua kho, Mua h\u00e0ng nhi\u1ec1u h\u00f3a \u0111\u01a1n qua kho, Mua h\u00e0ng nhi\u1ec1u h\u00f3a \u0111\u01a1n kh\u00f4ng qua kho, Mua d\u1ecbch v\u1ee5, H\u00e0ng mua tr\u1ea3 l\u1ea1i qua kho, H\u00e0ng mua tr\u1ea3 l\u1ea1i kh\u00f4ng qua kho, H\u00e0ng mua gi\u1ea3m gi\u00e1.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o B\u00e1n h\u00e0ng \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb: B\u00e1o gi\u00e1, \u0110\u01a1n \u0111\u1eb7t h\u00e0ng, B\u00e1n h\u00e0ng, H\u00f3a \u0111\u01a1n b\u00e1n h\u00e0ng, H\u00f3a \u0111\u01a1n kh\u1edfi t\u1ea1o t\u1eeb m\u00e1y t\u00ednh ti\u1ec1n, H\u00e0ng b\u00e1n tr\u1ea3 l\u1ea1i, H\u00e0ng b\u00e1n gi\u1ea3m gi\u00e1, Doanh thu nh\u1eadn tr\u01b0\u1edbc \u0111\u1ea7u k\u1ef3, Doanh thu nh\u1eadn tr\u01b0\u1edbc.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o Kho \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb: Nh\u1eadp kho, Chuy\u1ec3n kho, Xu\u1ea5t kho, L\u1ec7nh s\u1ea3n xu\u1ea5t, L\u1eafp r\u00e1p, th\u00e1o d\u1ee1.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o C\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5 \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb:\u00a0 Ghi t\u0103ng CCDC.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o T\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb: Ghi t\u0103ng TSC\u0110.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o Thu\u1ebf \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb: Ch\u1ee9ng t\u1eeb kh\u1ea5u tr\u1eeb thu\u1ebf TNCN.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o G\u00eda th\u00e0nh \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb: \u0110\u1ecbnh m\u1ee9c nguy\u00ean v\u1eadt li\u1ec7u c\u00f4ng tr\u00ecnh, \u0110\u1ecbnh m\u1ee9c gi\u00e1 th\u00e0nh th\u00e0nh ph\u1ea9m, \u0110\u1ecbnh m\u1ee9c ph\u00e2n b\u1ed5 theo \u0111\u1ed1i t\u01b0\u1ee3ng THCP, \u0110\u1ecbnh m\u1ee9c ph\u00e2n b\u1ed5 theo c\u00f4ng tr\u00ecnh.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o T\u1ed5ng h\u1ee3p \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb: Ch\u1ee9ng t\u1eeb NVK, Ch\u1ee9ng t\u1eeb quy\u1ebft to\u00e1n t\u1ea1m \u1ee9ng, Chi ph\u00ed tr\u1ea3 tr\u01b0\u1edbc \u0111\u1ea7u k\u1ef3, Chi ph\u00ed tr\u1ea3 tr\u01b0\u1edbc.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o H\u1ee3p \u0111\u1ed3ng \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb: H\u1ee3p \u0111\u1ed3ng b\u00e1n.<\/li>\n<li>T\u00edch \u0111\u00fap v\u00e0o M\u00e3 quy c\u00e1ch \u0111\u1ec3 nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb: Nh\u1eadp kh\u1ea9u m\u00e3 quy c\u00e1ch cho ch\u1ee9ng t\u1eeb nh\u1eadp kho, Nh\u1eadp kh\u1ea9u m\u00e3 quy c\u00e1ch cho ch\u1ee9ng t\u1eeb b\u00e1n h\u00e0ng, xu\u1ea5t kh\u1ea9u, Nh\u1eadp kh\u1ea9u m\u00e3 quy c\u00e1ch cho ch\u1ee9ng t\u1eeb Chuy\u1ec3n kho.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li data-section-id=\"1ows0ki\" data-start=\"396\" data-end=\"498\">M\u1ed7i <strong data-start=\"402\" data-end=\"427\">lo\u1ea1i ch\u1ee9ng t\u1eeb\/d\u1eef li\u1ec7u<\/strong>\u00a0s\u1eed d\u1ee5ng <strong data-start=\"445\" data-end=\"477\">01 file Excel m\u1eabu ri\u00eang bi\u1ec7t<\/strong> (kh\u00e1c c\u1ea5u tr\u00fac c\u1ed9t). <strong data-start=\"501\" data-end=\"556\">Kh\u00f4ng g\u1ed9p nhi\u1ec1u lo\u1ea1i ch\u1ee9ng t\u1eeb v\u00e0o c\u00f9ng 1 file Excel<\/strong>. File Excel ph\u1ea3i \u0111\u01b0\u1ee3c t\u1ea3i \u0111\u00fang theo <strong data-start=\"595\" data-end=\"635\">m\u1eabu t\u01b0\u01a1ng \u1ee9ng v\u1edbi t\u1eebng lo\u1ea1i ch\u1ee9ng t\u1eeb<\/strong>.<\/li>\n<li>\n<p data-start=\"638\" data-end=\"644\">V\u00ed d\u1ee5:<\/p>\n<ul style=\"list-style-type: disc;\" data-start=\"645\" data-end=\"866\">\n<li data-section-id=\"zvxabw\" data-start=\"645\" data-end=\"710\"><strong data-start=\"647\" data-end=\"667\">Mua h\u00e0ng qua kho<\/strong> \u2192 d\u00f9ng file Excel m\u1eabu <em data-start=\"690\" data-end=\"708\">Mua h\u00e0ng qua kho<\/em><\/li>\n<li data-section-id=\"1l1f9sj\" data-start=\"711\" data-end=\"866\"><strong data-start=\"713\" data-end=\"739\">Mua h\u00e0ng kh\u00f4ng qua kho<\/strong> \u2192 d\u00f9ng file Excel m\u1eabu <em data-start=\"762\" data-end=\"786\">Mua h\u00e0ng kh\u00f4ng qua kho<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\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><b>2.2 Gh\u00e9p d\u1eef li\u1ec7u<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Th\u1ef1c hi\u1ec7n gh\u00e9p t\u00ean c\u1ee7a <b>C\u1ed9t tr\u00ean ph\u1ea7n m\u1ec1m<\/b> t\u01b0\u01a1ng \u1ee9ng v\u1edbi t\u00ean c\u1ee7a <b>C\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u<\/b>. Trong \u0111\u00f3:<\/p>\n<ul>\n<li>C\u1ed9t tr\u00ean ph\u1ea7n m\u1ec1m: t\u1ee9c l\u00e0 c\u00e1c lo\u1ea1i th\u00f4ng tin m\u00e0 ph\u1ea7n m\u1ec1m MISA cho ph\u00e9p nh\u1eadp kh\u1ea9u.C\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u: t\u1ee9c l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ed9t tr\u00ean file Excel.<\/li>\n<li>H\u1ec7 th\u1ed1ng \u0111\u00e3 m\u1eb7c \u0111\u1ecbnh t\u1ef1 \u0111\u1ed9ng gh\u00e9p nh\u1eefng c\u1ed9t m\u00e0 c\u00f3 th\u1ec3 nh\u1eadn d\u1ea1ng \u0111\u01b0\u1ee3c.<\/li>\n<li>V\u1edbi nh\u1eefng m\u1ee5c c\u00f2n tr\u1ed1ng \u1edf C\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u, k\u1ebf to\u00e1n t\u1ef1 ch\u1ecdn l\u00ean \u0111\u1ec3 gh\u00e9p c\u1ed9t.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large\" src=\"\/2026\/wp-content\/uploads\/2018\/12\/87-800x615.png\" alt=\"\" width=\"800\" height=\"615\" \/><br \/>\n<b><em>L\u01b0u \u00fd:<\/em><\/b><\/p>\n<ul>\n<li><em>1. V\u1edbi c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c t\u00edch ch\u1ecdn <b>B\u1eaft bu\u1ed9c<\/b>, k\u1ebf to\u00e1n b\u1eaft bu\u1ed9c ph\u1ea3i gh\u00e9p c\u1ed9t tr\u00ean ph\u1ea7n m\u1ec1m v\u1edbi c\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp kh\u1ea9u. N\u1ebfu kh\u00f4ng gh\u00e9p th\u00ec s\u1ebd kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c b\u01b0\u1edbc ti\u1ebfp theo. =&gt; H\u1ec7 th\u1ed1ng cho ph\u00e9p k\u1ebf to\u00e1n ch\u1ecdn th\u00eam c\u00e1c c\u1ed9t b\u1eaft bu\u1ed9c ph\u1ea3i gh\u00e9p.<\/em><\/li>\n<li><em>2. V\u1edbi c\u00e1c c\u1ed9t kh\u00f4ng c\u00f3 nhu c\u1ea7u c\u1ea7n nh\u1eadp kh\u1ea9u, k\u1ebf to\u00e1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <a href=\"html_10050100\" target=\"_blank\" rel=\"noopener\">\u1ea8n\/hi\u1ec7n th\u00f4ng tin<\/a> \u0111\u1ec3 gi\u1ea3m b\u1edbt c\u00e1c c\u1ed9t c\u1ea7n gh\u00e9p.<\/em><\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n <b>Ti\u1ebfp theo<\/b> \u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc <b>Ki\u1ec3m tra d\u1eef li\u1ec7u<\/b>.<\/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><b>2.3 Ki\u1ec3m tra d\u1eef li\u1ec7u<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul>\n<li>B\u01b0\u1edbc n\u00e0y, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd th\u1ef1c hi\u1ec7n ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a d\u1eef li\u1ec7u tr\u00ean t\u1ec7p nh\u1eadp kh\u1ea9u.<\/li>\n<li>Sau khi ch\u01b0\u01a1ng tr\u00ecnh ki\u1ec3m tra xong, l\u1ecdc tr\u00ean c\u1ed9t T\u00ecnh tr\u1ea1ng, n\u1ebfu c\u00f3 c\u1ed9t d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7 th\u00ec nh\u1ea5n n\u00fat <b>S\u1eeda l\u1ea1i t\u1ec7p d\u1eef li\u1ec7u&#8230;<\/b> \u0111\u1ec3 m\u1edf t\u1ec7p d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u, c\u0103n c\u1ee9 v\u00e0o l\u00fd do kh\u00f4ng h\u1ee3p l\u1ec7 tr\u00ean t\u1eebng d\u00f2ng kh\u00f4ng h\u1ee3p l\u1ec7 \u0111\u1ec3 s\u1eeda l\u1ea1i ho\u1eb7c nh\u1ea5n <b>Xu\u1ea5t kh\u1ea9u<\/b> \u0111\u1ec3 xu\u1ea5t ra excel k\u1ebft qu\u1ea3 ki\u1ec3m tra d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u, gi\u00fap \u0111\u1ed1i chi\u1ebfu nhanh v\u00e0 nhi\u1ec1u d\u1eef li\u1ec7u h\u01a1n.<\/li>\n<li>Tr\u01b0\u1eddng h\u1ee3p nh\u1eadp kh\u1ea9u b\u00e1o kh\u00f4ng th\u00e0nh c\u00f4ng, c\u00f3 c\u00e1c d\u00f2ng kh\u00f4ng h\u1ee3p l\u1ec7: xem h\u01b0\u1edbng d\u1eabn x\u1eed l\u00fd c\u00e1c nguy\u00ean nh\u00e2n <b><a href=\"https:\/\/helpsme.misa.vn\/2026\/kb\/xu-ly-truong-hop-nhap-khau-excel-phan-mem-bao-khong-thanh-cong-co-cac-dong-khong-hop-le\/\" target=\"_blank\" rel=\"noopener\">T\u1ea1i \u0111\u00e2y<\/a><\/b>.<\/li>\n<li>Sau khi c\u1ea5t t\u1ec7p d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u \u0111\u00e3 s\u1eeda, nh\u1ea5n <b>Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u&#8230;<\/b>, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd th\u1ef1c hi\u1ec7n ki\u1ec3m tra l\u1ea1i t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u.<\/li>\n<li>Nh\u1ea5n <b>Th\u1ef1c hi\u1ec7n<\/b>, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u v\u00e0o ph\u1ea7n m\u1ec1m v\u00e0 th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"\/2022\/wp-content\/uploads\/2022\/04\/xk-excel-700x525.png\" alt=\"\" width=\"700\" height=\"525\" \/><br \/>\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><b>2.4 K\u1ebft qu\u1ea3 nh\u1eadp kh\u1ea9u<\/b><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd b\u00e1o k\u1ebft qu\u1ea3 s\u1ed1 d\u00f2ng nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng (n\u1ebfu c\u00f3).<\/li>\n<li>N\u1ebfu c\u00f3 d\u00f2ng Kh\u00f4ng th\u00e0nh c\u00f4ng:\n<ul>\n<li>Nh\u1ea5n n\u00fat &#8220;<b>T\u1ea3i v\u1ec1 d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u kh\u00f4ng th\u00e0nh c\u00f4ng<\/b>&#8221; \u0111\u1ec3 t\u1ea3i file excel D\u1eef li\u1ec7u l\u1ed7i.<\/li>\n<li>M\u1edf file Excel v\u1eeba t\u1ea3i v\u1ec1, k\u00e9o \u0111\u1ebfn <b>c\u1ed9t cu\u1ed1i c\u00f9ng<\/b> v\u00e0 xem nguy\u00ean nh\u00e2n t\u1ea1i c\u1ed9t &#8220;<b>Th\u00f4ng tin k\u1ef9 thu\u1eadt<\/b>&#8220;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"\/2026\/wp-content\/uploads\/2022\/04\/A2-700x388.jpg\" alt=\"\" width=\"700\" height=\"388\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/2026\/wp-content\/uploads\/2022\/04\/A3.jpg\" alt=\"\" width=\"1365\" height=\"330\" \/><\/p>\n<ul>\n<li>Nh\u1ea5n <b>Nh\u1eadp kh\u1ea9u ti\u1ebfp<\/b> \u0111\u1ec3 ti\u1ebfp t\u1ee5c v\u1edbi c\u00e1c d\u1eef li\u1ec7u kh\u00e1c, ho\u1eb7c nh\u1ea5n <b>\u0110\u00f3ng<\/b> \u0111\u1ec3 k\u1ebft th\u00fac nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/2026\/wp-content\/uploads\/2018\/12\/89-700x525.png\" alt=\"\" width=\"565\" height=\"424\" \/><\/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><b>3. L\u01b0u \u00fd<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul>\n<li><strong>V\u1edbi danh m\u1ee5c:<\/strong><\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">Tr\u01b0\u1eddng h\u1ee3p nh\u1eadp kh\u1ea9u <b>Th\u00e0nh ph\u1ea9m<\/b> v\u00e0 <b>c\u00f3 Nguy\u00ean v\u1eadt li\u1ec7u \u0110\u1ecbnh m\u1ee9c<\/b>: V\u00ed d\u1ee5 1 m\u00e3 th\u00e0nh ph\u1ea9m c\u00f3 3 m\u00e3 Nguy\u00ean v\u1eadt li\u1ec7u \u0111\u1ecbnh m\u1ee9c th\u00ec nh\u1eadp 3 d\u00f2ng, v\u1edbi c\u00e1c c\u1ed9t Th\u00f4ng tin nh\u01b0 M\u00e3 TP, T\u00ean TP,&#8230; th\u00ec nh\u1eadp gi\u1ed1ng nhau; v\u1edbi c\u00e1c c\u1ed9t Nguy\u00ean v\u1eadt li\u1ec7u \u0111\u1ecbnh m\u1ee9c th\u00ec nh\u1eadp chi ti\u1ebft (Tham kh\u1ea3o h\u00ecnh b\u00ean d\u01b0\u1edbi)<\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/2026\/wp-content\/uploads\/2022\/04\/A6.jpg\" alt=\"\" width=\"1365\" height=\"443\" \/><\/p>\n<ul>\n<li><strong>V\u1edbi ch\u1ee9ng t\u1eeb:<\/strong><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: disc;\">\n<li>T\u1eebng lo\u1ea1i ch\u1ee9ng t\u1eeb, trong c\u00f9ng 01 file Excel c\u00f3 th\u1ec3 nh\u1eadp cho nhi\u1ec1u ch\u1ee9ng t\u1eeb. M\u1ed7i ch\u1ee9ng t\u1eeb t\u01b0\u01a1ng \u1ee9ng 1 d\u00f2ng.<\/li>\n<li>Sau khi nh\u1eadp kh\u1ea9u xong ch\u1ee9ng t\u1eeb s\u1ebd c\u00f3 tr\u00ean danh s\u00e1ch ch\u1ee9ng t\u1eeb theo ph\u00e2n h\u1ec7 m\u00e0 anh\/ch\u1ecb nh\u1eadp v\u00ed d\u1ee5 Kho\/ Nh\u1eadp, xu\u1ea5t kho; Mua h\u00e0ng\/ Mua h\u00e0ng h\u00f3a, d\u1ecbch v\u1ee5; B\u00e1n h\u00e0ng\/ B\u00e1n h\u00e0ng&#8230; v\u00e0 ch\u1ee9ng t\u1eeb s\u1ebd \u1edf tr\u1ea1ng th\u00e1i ch\u01b0a ghi s\u1ed5.<\/li>\n<li>N\u1ebfu c\u00f9ng 01 ch\u1ee9ng t\u1eeb\/ h\u00f3a \u0111\u01a1n c\u00f3 2 ho\u1eb7c nhi\u1ec1u d\u00f2ng H\u00e0ng h\u00f3a d\u1ecbch v\u1ee5: c\u00e1c c\u1ed9t th\u00f4ng tin chung S\u1ed1 ch\u1ee9ng t\u1eeb ho\u1eb7c S\u1ed1 th\u1ee9 t\u1ef1 nh\u1eadp gi\u1ed1ng nhau, c\u00e1c c\u1ed9t chi ti\u1ebft (M\u00e3 h\u00e0ng, S\u1ed1 l\u01b0\u1ee3ng&#8230;) nh\u1eadp t\u01b0\u01a1ng \u1ee9ng cho t\u1eebng d\u00f2ng m\u1eb7t h\u00e0ng. (Tham kh\u1ea3o h\u00ecnh b\u00ean d\u01b0\u1edbi)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/2026\/wp-content\/uploads\/2022\/04\/A5.jpg\" alt=\"\" width=\"1360\" height=\"463\" \/><\/p>\n<ul>\n<li>Tr\u01b0\u1eddng h\u1ee3p nh\u1eadp kh\u1ea9u b\u00e1o kh\u00f4ng th\u00e0nh c\u00f4ng, c\u00f3 c\u00e1c d\u00f2ng kh\u00f4ng h\u1ee3p l\u1ec7: xem h\u01b0\u1edbng d\u1eabn x\u1eed l\u00fd c\u00e1c nguy\u00ean nh\u00e2n <b><a href=\"https:\/\/helpsme.misa.vn\/2026\/kb\/xu-ly-truong-hop-nhap-khau-excel-phan-mem-bao-khong-thanh-cong-co-cac-dong-khong-hop-le\/\" target=\"_blank\" rel=\"noopener\">T\u1ea1i \u0111\u00e2y<\/a><\/b>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Xem phim h\u01b0\u1edbng d\u1eabn T\u1ea3i phim h\u01b0\u1edbng d\u1eabn: T\u1ea1i \u0111\u00e2y (Xem h\u01b0\u1edbng d\u1eabn t\u1ea3i phim)<\/p>\n","protected":false},"author":133,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2618,2622,2568],"ht-kb-tag":[3809,4885,4829],"class_list":["post-24473","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cau-hoi-thuong-gap-khi-bat-dau-su-dung","ht_kb_category-khac-cau-hoi-thuong-gap-khi-bat-dau-su-dung","ht_kb_category-cau-hoi-thuong-gap","ht_kb_tag-nhap-khau-chung-tu","ht_kb_tag-nhap-khau-danh-muc","ht_kb_tag-nhap-khau-excel"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/24473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/users\/133"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/comments?post=24473"}],"version-history":[{"count":8,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/24473\/revisions"}],"predecessor-version":[{"id":70511,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/24473\/revisions\/70511"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/media?parent=24473"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb-category?post=24473"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb-tag?post=24473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}