{"id":33227,"date":"2025-01-13T16:09:10","date_gmt":"2025-01-13T09:09:10","guid":{"rendered":"https:\/\/helpmimosa.misa.vn\/2025\/?post_type=ht_kb&p=33227"},"modified":"2026-07-14T17:12:30","modified_gmt":"2026-07-14T10:12:30","slug":"nhap-khau-du-lieu-tu-excel","status":"publish","type":"ht_kb","link":"https:\/\/helpmimosa.misa.vn\/2025\/kb\/nhap-khau-du-lieu-tu-excel\/","title":{"rendered":"Nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb excel"},"content":{"rendered":"

1. T\u1ed5ng quan<\/h3>\n
B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn Anh\/Ch\u1ecb nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u <\/span>Danh m\u1ee5c<\/span><\/strong>, <\/span>S\u1ed1 d\u01b0<\/span><\/strong> ho\u1eb7c <\/span>Ch\u1ee9ng t\u1eeb<\/span><\/strong> t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m MISA Mimosa 2025, \u00e1p d\u1ee5ng khi c\u1ea7n \u0111\u01b0a nhanh d\u1eef li\u1ec7u c\u00f3 s\u1eb5n (kh\u00e1ch h\u00e0ng\/nh\u00e0 cung c\u1ea5p, c\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5, t\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh, v\u1eadt t\u01b0 h\u00e0ng h\u00f3a, s\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3, ch\u1ee9ng t\u1eeb ph\u00e1t sinh…) v\u00e0o h\u1ec7 th\u1ed1ng thay v\u00ec nh\u1eadp tay t\u1eebng d\u00f2ng.<\/span><\/p>\n

2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/h3>\n
L\u01b0u \u00fd:<\/strong>\u00a0Tr\u01b0\u1edbc khi nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u, anh\/ch\u1ecb c\u1ea7n\u00a0sao l\u01b0u d\u1eef li\u1ec7u k\u1ebf to\u00e1n<\/strong><\/a>, v\u00ec thao t\u00e1c s\u1ebd \u0111\u01b0a d\u1eef li\u1ec7u t\u1eeb t\u1ec7p excel v\u00e0o c\u01a1 s\u1edf d\u1eef li\u1ec7u hi\u1ec7n t\u1ea1i v\u00e0 c\u00f3 th\u1ec3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn d\u1eef li\u1ec7u \u0111ang c\u00f3.<\/p>\n
B\u01b0\u1edbc 1: Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong><\/h4>\n
1. V\u00e0o T\u1ec7p<\/strong>, ch\u1ecdn Nh\u1eadp kh\u00e2\u0309u d\u01b0\u0303 li\u00ea\u0323u t\u1eeb excel<\/strong>.<\/p>\n
$\"\"$ <\/p>\n
2. T\u1ea1i m\u1ee5c Lo\u1ea1i d\u1eef li\u1ec7u<\/strong>, ch\u1ecdn 1 trong 3: Danh m\u1ee5c<\/strong>, S\u1ed1 d\u01b0<\/strong>, Ch\u1ee9ng t\u1eeb<\/strong>.<\/p>\n
3. T\u00edch ch\u1ecdn lo\u1ea1i c\u1ee5 th\u1ec3<\/p>\n
\n
Ch\u1ecdn lo\u1ea1i danh m\u1ee5c nh\u1eadp kh\u1ea9u ho\u1eb7c:<\/strong> Kh\u00e1ch h\u00e0ng nh\u00e0 cung c\u1ea5p, C\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5, T\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh, V\u1eadt t\u01b0 h\u00e0ng h\u00f3a.<\/li>\n
Ch\u1ecdn lo\u1ea1i s\u1ed1 d\u01b0 nh\u1eadp kh\u1ea9u<\/strong>: S\u1ed1 d\u01b0 t\u00e0i kho\u1ea3n, s\u1ed1 d\u01b0 ban \u0111\u1ea7u CCDC, S\u1ed1 d\u01b0 ban \u0111\u1ea7u V\u1eadt t\u01b0 h\u00e0ng h\u00f3a<\/li>\n
Ch\u1ecdn lo\u1ea1i ch\u1ee9ng t\u1eeb nh\u1eadp kh\u1ea9u:\u00a0<\/strong>\n
\n
Ti\u1ec1n m\u1eb7t\n
\n
Phi\u1ebfu thu<\/li>\n
Phi\u1ebfu thu r\u00fat d\u1ef1 to\u00e1n nh\u1eadp qu\u1ef9<\/li>\n
Phi\u1ebfu chi<\/li>\n
Phi\u1ebfu chi n\u1ed9p ti\u1ec1n v\u00e0o NH,KB<\/li>\n<\/ul>\n<\/li>\n
Ti\u1ec1n g\u1eedi\n
\n
Thu ti\u1ec1n g\u1eedi<\/li>\n
Chi ti\u1ec1n g\u1eedi<\/li>\n<\/ul>\n<\/li>\n
Kho b\u1ea1c\n
\n
R\u00fat d\u1ef1 to\u00e1n ti\u1ec1n g\u1eedi<\/li>\n
R\u00fat d\u1ef1 to\u00e1n chuy\u1ec3n kho\u1ea3n<\/li>\n
R\u00fat d\u1ef1 to\u00e1n chuy\u1ec3n kho\u1ea3n l\u01b0\u01a1ng, b\u1ea3o hi\u1ec3m<\/li>\n
Chuy\u1ec3n kho\u1ea3n kho b\u1ea1c<\/li>\n<\/ul>\n<\/li>\n
S\u1ed5 c\u00e1i\n
\n
Ch\u1ee9ng t\u1eeb nghi\u1ec7p v\u1ee5 kh\u00e1c<\/li>\n<\/ul>\n<\/li>\n
V\u1eadt t\u01b0 h\u00e0ng h\u00f3a\n
\n
Nh\u1eadp kho<\/li>\n
Xu\u1ea5t kho<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
4. N\u1ebfu ch\u01b0a c\u00f3 t\u1ec7p ngu\u1ed3n, nh\u1ea5n T\u1ea3i t\u1ec7p m\u1eabu ng\u1ea7m \u0111\u1ecbnh<\/strong> \u0111\u1ec3 t\u1ea3i file Excel m\u1eabu, sau \u0111\u00f3 \u0111i\u1ec1n d\u1eef li\u1ec7u v\u00e0o file n\u00e0y.<\/p>\n
$\"\"$ <\/p>\n
5. Nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng th\u01b0 m\u1ee5c t\u1ea1i **\u0110\u01b0\u1eddng d\u1eabn \u0111\u1ebfn t\u1ec7p d\u1eef li\u1ec7u(*)<\/strong> \u0111\u1ec3 ch\u1ecdn file Excel \u0111\u00e3 \u0111i\u1ec1n d\u1eef li\u1ec7u.<\/p>\n**
\n
Ch\u1ecdn sheet ch\u1ee9a d\u1eef li\u1ec7u()<\/strong> v\u00e0 khai b\u00e1o D\u00f2ng ti\u00eau \u0111\u1ec1 l\u00e0 d\u00f2ng()<\/strong> (m\u1eb7c \u0111\u1ecbnh d\u00f2ng 1 -> c\u00f3 th\u1ec3 ch\u1ecdn l\u1ea1i t\u00f9y theo d\u00f2ng ti\u00eau \u0111\u1ec1 tr\u00ean file nh\u1eadp kh\u1ea9u).<\/li>\n<\/ul>\n
6. Nh\u1ea5n Ti\u1ebfp theo<\/strong> \u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc 2<\/p>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 2: Gh\u00e9p c\u1ed9t d\u1eef li\u1ec7u<\/strong><\/h4>\n
L\u01b0u \u00fd<\/strong>: N\u1ebfu anh\/ch\u1ecb s\u1eed d\u1ee5ng file m\u1eabu ng\u1ea7m \u0111\u1ecbnh c\u1ee7a ph\u1ea7n m\u1ec1m \u0111\u1ec3 nh\u1eadp kh\u1ea9u v\u00e0o ph\u1ea7n m\u1ec1m th\u00ec t\u1ea1i b\u01b0\u1edbc n\u00e0y kh\u00f4ng c\u1ea7n ph\u1ea3i th\u1ef1c hi\u1ec7n gh\u00e9p c\u1ed9t d\u1eef li\u1ec7u.<\/em><\/p>\n
\n
Th\u1ef1c hi\u1ec7n gh\u00e9p\u00a0Th\u00f4ng tin d\u1eef li\u1ec7u ph\u1ea7n m\u1ec1m<\/strong>\u00a0(t\u00ean c\u00e1c c\u1ed9t d\u1eef li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m) v\u1edbi\u00a0Th\u00f4ng tin trong t\u1ec7p excel<\/strong>\u00a0(t\u00ean c\u00e1c c\u1ed9t tr\u00ean file excel c\u1ea7n nh\u1eadp kh\u1ea9u).\u00a0<\/li>\n
N\u1ebfu danh m\u1ee5c c\u00f3 nhi\u1ec1u nh\u00f3m d\u1eef li\u1ec7u li\u00ean quan (v\u00ed d\u1ee5 Kh\u00e1ch h\u00e0ng, Nh\u00e0 cung c\u1ea5p k\u00e8m T\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng), c\u1ea7n gh\u00e9p c\u1ed9t l\u1ea7n l\u01b0\u1ee3t theo t\u1eebng tab t\u01b0\u01a1ng \u1ee9ng.<\/li>\n
Ch\u1ecdn c\u00e1ch X\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00f9ng<\/strong>: Nh\u1eadp kh\u1ea9u b\u1ed5 sung<\/strong> (ch\u1ec9 th\u00eam m\u1edbi) ho\u1eb7c Nh\u1eadp kh\u1ea9u ghi \u0111\u00e8<\/strong> (c\u1eadp nh\u1eadt \u0111\u00e8 l\u00ean d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3).<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Nh\u1ea5n\u00a0Ti\u1ebfp t\u1ee5c<\/strong>\u00a0\u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc 3.<\/li>\n<\/ul>\n
B\u01b0\u1edbc 3: Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong><\/h4>\n
\n
Ph\u1ea7n m\u1ec1m hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u chu\u1ea9n b\u1ecb nh\u1eadp kh\u1ea9u \u0111\u1ec3 Anh\/Ch\u1ecb r\u00e0 so\u00e1t (k\u1ec3 c\u1ea3 c\u00e1c nh\u00f3m d\u1eef li\u1ec7u li\u00ean quan, hi\u1ec3n th\u1ecb theo tab ri\u00eang).<\/li>\n
N\u1ebfu ph\u00e1t hi\u1ec7n l\u1ed7i, nh\u1ea5n S\u1eeda t\u1ec7p d\u1eef li\u1ec7u<\/strong> \u0111\u1ec3 ch\u1ec9nh tr\u1ef1c ti\u1ebfp tr\u00ean Excel, L\u01b0u v\u00e0 \u0111\u00f3ng file, sau \u0111\u00f3 nh\u1ea5n Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u<\/strong>.<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Nh\u1ea5n Nh\u1eadp kh\u1ea9u<\/strong>, ph\u1ea7n m\u1ec1m h\u1ecfi x\u00e1c nh\u1eadn \u2192 nh\u1ea5n \u0110\u1ed3ng \u00fd<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n.<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 4: Nh\u1eadp kh\u1ea9u<\/strong><\/h4>\n
\n
Ph\u1ea7n m\u1ec1m th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 nh\u1eadp kh\u1ea9u: S\u1ed1 b\u1ea3n ghi nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng, s\u1ed1 b\u1ea3n ghi nh\u1eadp kh\u1ea9u kh\u00f4ng th\u00e0nh c\u00f4ng (c\u00f3 th\u1ec3 nh\u1ea5n Xem chi ti\u1ebft<\/strong> \u0111\u1ec3 ki\u1ec3m tra danh s\u00e1ch).<\/li>\n
C\u00f3 th\u1ec3 nh\u1ea5n Nh\u1eadp kh\u1ea9u t\u1ec7p m\u1edbi<\/strong> n\u1ebfu mu\u1ed1n ti\u1ebfp t\u1ee5c nh\u1eadp file kh\u00e1c, ho\u1eb7c nh\u1ea5n \u0110\u00f3ng<\/strong> \u0111\u1ec3 k\u1ebft th\u00fac.<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\u00a03. L\u01b0u \u00fd<\/h3>\n
\n
Sau khi nh\u1eadp kh\u1ea9u: <\/strong>V\u00e0o Ti\u1ec7n \u00edch\\B\u1ea3o tr\u00ec d\u1eef li\u1ec7u<\/strong>, ch\u1ecdn kho\u1ea3ng th\u1eddi gian b\u1ea3o tr\u00ec (v\u00ed d\u1ee5: N\u0103m nay<\/strong>, T\u1eeb 01\/01\/2025 \u2013 \u0110\u1ebfn 31\/12\/2025), t\u00edch ch\u1ecdn Ghi s\u1ed5 c\u00e1c ch\u1ee9ng t\u1eeb ch\u01b0a ghi s\u1ed5<\/strong>, nh\u1ea5n Th\u1ef1c hi\u1ec7n<\/strong> \u0111\u1ec3 ph\u1ea7n m\u1ec1m ghi s\u1ed5 S\u1ed1 d\u01b0 v\u00e0 Ch\u1ee9ng t\u1eeb v\u1eeba nh\u1eadp kh\u1ea9u.\u00a0<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
C\u00e1c c\u1ed9t c\u00f3 d\u1ea5u (*) tr\u00ean file ngu\u1ed3n kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng.<\/li>\n
V\u1edbi Ch\u1ee9ng t\u1eeb<\/strong>, sau khi nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng, ch\u1ee9ng t\u1eeb \u1edf tr\u1ea1ng th\u00e1i ch\u01b0a ghi s\u1ed5<\/strong> \u2014 b\u1eaft bu\u1ed9c ph\u1ea3i ch\u1ea1y B\u1ea3o tr\u00ec d\u1eef li\u1ec7u\\Ghi s\u1ed5 c\u00e1c ch\u1ee9ng t\u1eeb ch\u01b0a ghi s\u1ed5<\/strong> th\u00ec m\u1edbi l\u00ean \u0111\u01b0\u1ee3c s\u1ed5 s\u00e1ch, b\u00e1o c\u00e1o.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
1. T\u1ed5ng quan B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn Anh\/Ch\u1ecb nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u Danh m\u1ee5c, S\u1ed1 d\u01b0 ho\u1eb7c Ch\u1ee9ng t\u1eeb t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m MISA Mimosa 2025, \u00e1p d\u1ee5ng khi c\u1ea7n \u0111\u01b0a nhanh d\u1eef li\u1ec7u c\u00f3 s\u1eb5n (kh\u00e1ch h\u00e0ng\/nh\u00e0 cung c\u1ea5p, c\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5, t\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh,…<\/p>\n","protected":false},"author":71,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"ht-kb-category":[963],"ht-kb-tag":[],"class_list":["post-33227","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-tep"],"_links":{"self":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb\/33227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/users\/71"}],"version-history":[{"count":5,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb\/33227\/revisions"}],"predecessor-version":[{"id":55327,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb\/33227\/revisions\/55327"}],"wp:attachment":[{"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/media?parent=33227"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb-category?post=33227"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpmimosa.misa.vn\/2025\/wp-json\/wp\/v2\/ht-kb-tag?post=33227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}