{"id":648,"date":"2026-05-14T14:47:20","date_gmt":"2026-05-14T07:47:20","guid":{"rendered":"https:\/\/dhhp.com.vn\/?p=648"},"modified":"2026-05-18T14:00:11","modified_gmt":"2026-05-18T07:00:11","slug":"bang-map-code-cau-noi-du-lieu-hai-quan-va-ke-toan","status":"publish","type":"post","link":"https:\/\/dhhp.com.vn\/en\/bang-map-code-cau-noi-du-lieu-hai-quan-va-ke-toan\/","title":{"rendered":"B\u1ea3ng Map Code: C\u1ea7u N\u1ed1i D\u1eef Li\u1ec7u H\u1ea3i Quan V\u00e0 K\u1ebf To\u00e1n"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><strong>B\u1ea3ng Map Code<\/strong>&nbsp;(hay b\u1ea3ng quy \u0111\u1ed5i m\u00e3) \u0111\u00f3ng vai tr\u00f2 l\u00e0 &#8220;c\u1ea7u n\u1ed1i&#8221; gi\u1ea3i quy\u1ebft s\u1ef1 l\u1ec7ch pha v\u1ec1 m\u00e3 qu\u1ea3n tr\u1ecb gi\u1eefa h\u1ec7 th\u1ed1ng H\u1ea3i quan v\u00e0 s\u1ed5 s\u00e1ch k\u1ebf to\u00e1n, \u0111\u1eb7c bi\u1ec7t l\u00e0 trong tr\u01b0\u1eddng h\u1ee3p&nbsp;<strong>t\u1ef7 l\u1ec7 1:Nhi\u1ec1u<\/strong>&nbsp;(m\u1ed9t m\u00e3 H\u1ea3i quan t\u01b0\u01a1ng \u1ee9ng v\u1edbi nhi\u1ec1u m\u00e3 K\u1ebf to\u00e1n\/Kho).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch B\u1ea3ng Map Code gi\u1ea3i quy\u1ebft t\u1ef7 l\u1ec7 n\u00e0y:<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1. B\u1ea3n ch\u1ea5t c\u1ee7a vi\u1ec7c gi\u1ea3i quy\u1ebft t\u1ef7 l\u1ec7 1:Nhi\u1ec1u<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Trong th\u1ef1c t\u1ebf, b\u1ed9 ph\u1eadn Xu\u1ea5t nh\u1eadp kh\u1ea9u (XNK) th\u01b0\u1eddng khai b\u00e1o m\u1ed9t m\u00e3 nguy\u00ean ph\u1ee5 li\u1ec7u duy nh\u1ea5t tr\u00ean t\u1edd khai, nh\u01b0ng b\u1ed9 ph\u1eadn K\u1ebf to\u00e1n\/Kho l\u1ea1i chia nh\u1ecf th\u00e0nh nhi\u1ec1u m\u00e3 n\u1ed9i b\u1ed9 \u0111\u1ec3 qu\u1ea3n l\u00fd chi ti\u1ebft (theo l\u00f4 s\u1ea3n xu\u1ea5t, m\u00e0u s\u1eafc, ho\u1eb7c ng\u00e0y nh\u1eadp). B\u1ea3ng Map Code gi\u00fap&nbsp;<strong>h\u1ee3p nh\u1ea5t c\u00e1c d\u1eef li\u1ec7u ph\u00e2n t\u00e1n<\/strong>&nbsp;n\u00e0y v\u1ec1 \u0111\u00fang m\u00e3 qu\u1ea3n tr\u1ecb m\u00e0 H\u1ea3i quan y\u00eau c\u1ea7u.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. C\u00e1ch th\u1ee9c tri\u1ec3n khai c\u1ee5 th\u1ec3<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u1ec3 x\u1eed l\u00fd t\u1ef7 l\u1ec7 1:Nhi\u1ec1u, doanh nghi\u1ec7p th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc k\u1ef9 thu\u1eadt sau:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Th\u00eam c\u1ed9t \u0111\u1ed1i chi\u1ebfu:<\/strong>&nbsp;Trong d\u1eef li\u1ec7u k\u1ebf to\u00e1n (v\u00ed d\u1ee5 t\u00e0i kho\u1ea3n 152), doanh nghi\u1ec7p ch\u00e8n th\u00eam m\u1ed9t c\u1ed9t g\u1ecdi l\u00e0&nbsp;<strong>&#8220;M\u00e3 H\u1ea3i quan t\u01b0\u01a1ng \u1ee9ng&#8221;<\/strong>.<\/li>\n\n\n\n<li><strong>G\u00e1n m\u00e3 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng:<\/strong>&nbsp;S\u1eed d\u1ee5ng c\u00e1c h\u00e0m nh\u01b0&nbsp;<code>VLOOKUP<\/code>&nbsp;ho\u1eb7c&nbsp;<code>INDEX &amp; MATCH<\/code>&nbsp;\u0111\u1ec3 r\u00e1p c\u00e1c m\u00e3 K\u1ebf to\u00e1n l\u1ebb v\u00e0o m\u00e3 H\u1ea3i quan t\u1ed5ng t\u01b0\u01a1ng \u1ee9ng d\u1ef1a tr\u00ean b\u1ea3ng Map Code \u0111\u00e3 x\u00e2y d\u1ef1ng.<\/li>\n\n\n\n<li><strong>S\u1eed d\u1ee5ng Pivot Table \u0111\u1ec3 t\u1ed5ng h\u1ee3p:<\/strong>&nbsp;\u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu hi\u1ec7u nh\u1ea5t. Doanh nghi\u1ec7p s\u1ebd \u0111\u01b0a m\u00e3 H\u1ea3i quan l\u00e0m tr\u01b0\u1eddng d\u1eef li\u1ec7u ch\u00ednh (\u0111\u1ee9ng \u0111\u1ea7u), sau \u0111\u00f3 \u0111\u1ebfn m\u00e3 K\u1ebf to\u00e1n v\u00e0 s\u1ed1 l\u01b0\u1ee3ng. Khi \u0111\u00f3, h\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng&nbsp;<strong>c\u1ed9ng d\u1ed3n s\u1ed1 l\u01b0\u1ee3ng<\/strong>&nbsp;c\u1ee7a nhi\u1ec1u m\u00e3 k\u1ebf to\u00e1n v\u1ec1 th\u00e0nh m\u1ed9t d\u00f2ng t\u1ed5ng duy nh\u1ea5t cho m\u00e3 H\u1ea3i quan \u0111\u00f3.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">3. Vai tr\u00f2 trong B\u00e1o c\u00e1o quy\u1ebft to\u00e1n v\u00e0 Ki\u1ec3m tra sau th\u00f4ng quan<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u0110\u00e1p \u1ee9ng quy \u0111\u1ecbnh ph\u00e1p lu\u1eadt:<\/strong>\u00a0Theo <a href=\"https:\/\/vanban.chinhphu.vn\/?pageid=27160&amp;docid=193970\" data-type=\"link\" data-id=\"https:\/\/vanban.chinhphu.vn\/?pageid=27160&amp;docid=193970\" target=\"_blank\" rel=\"noopener\">Th\u00f4ng t\u01b0 39\/2018<\/a>, doanh nghi\u1ec7p b\u1eaft bu\u1ed9c ph\u1ea3i l\u1eadp b\u00e1o c\u00e1o quy\u1ebft to\u00e1n theo m\u00e3 qu\u1ea3n tr\u1ecb c\u1ee7a t\u1edd khai h\u1ea3i quan. N\u1ebfu kh\u00f4ng c\u00f3 b\u1ea3ng Map Code, b\u1ed9 ph\u1eadn XNK s\u1ebd kh\u00f4ng th\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c s\u1ed1 li\u1ec7u (l\u01b0\u1ee3ng) t\u1eeb s\u1ed5 k\u1ebf to\u00e1n \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o c\u1ed9t s\u1ed1 6 (nh\u1eadp trong k\u1ef3) ho\u1eb7c c\u1ed9t s\u1ed1 9 (xu\u1ea5t kho \u0111\u1ec3 s\u1ea3n xu\u1ea5t) c\u1ee7a <a href=\"https:\/\/dhhp.com.vn\/en\/cac-form-mau-bao-cao-quyet-toan-hai-quan\/\" data-type=\"post\" data-id=\"327\">m\u1eabu 15<\/a>.<\/li>\n\n\n\n<li><strong>C\u00f4ng c\u1ee5 gi\u1ea3i tr\u00ecnh:<\/strong>&nbsp;B\u1ea3ng Map Code kh\u00f4ng n\u1ed9p c\u00f9ng b\u00e1o c\u00e1o quy\u1ebft to\u00e1n nh\u01b0ng ph\u1ea3i \u0111\u01b0\u1ee3c&nbsp;<strong>l\u01b0u tr\u1eef t\u1ea1i doanh nghi\u1ec7p<\/strong>. Khi H\u1ea3i quan v\u00e0o ki\u1ec3m tra sau th\u00f4ng quan (th\u1eddi h\u1ea1n l\u00ean \u0111\u1ebfn 5 n\u0103m), \u0111\u00e2y l\u00e0 t\u00e0i li\u1ec7u quan tr\u1ecdng nh\u1ea5t \u0111\u1ec3 ch\u1ee9ng minh r\u1eb1ng l\u01b0\u1ee3ng nguy\u00ean ph\u1ee5 li\u1ec7u xu\u1ea5t d\u00f9ng t\u1eeb nhi\u1ec1u m\u00e3 kho th\u1ef1c t\u1ebf ho\u00e0n to\u00e0n kh\u1edbp v\u1edbi m\u00e3 \u0111\u00e3 khai b\u00e1o mi\u1ec5n thu\u1ebf tr\u00ean t\u1edd khai.<\/li>\n\n\n\n<li><strong>X\u1eed l\u00fd \u0111\u01a1n v\u1ecb t\u00ednh:<\/strong>&nbsp;Ngo\u00e0i vi\u1ec7c kh\u1edbp m\u00e3, b\u1ea3ng n\u00e0y c\u00f2n gi\u00fap quy \u0111\u1ed5i n\u1ebfu \u0111\u01a1n v\u1ecb t\u00ednh gi\u1eefa c\u00e1c b\u1ed9 ph\u1eadn kh\u00e1c nhau (v\u00ed d\u1ee5: H\u1ea3i quan qu\u1ea3n l\u00fd b\u1eb1ng &#8220;m\u00e9t&#8221; nh\u01b0ng Kho qu\u1ea3n l\u00fd b\u1eb1ng &#8220;da\/yard&#8221;) th\u00f4ng qua t\u1ef7 l\u1ec7 quy \u0111\u1ed5i trong b\u1ea3ng.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">T\u00f3m l\u1ea1i, B\u1ea3ng Map Code gi\u00fap doanh nghi\u1ec7p&nbsp;<strong>\u0111\u1ed3ng nh\u1ea5t d\u1eef li\u1ec7u<\/strong>&nbsp;b\u1eb1ng c\u00e1ch gom c\u00e1c m\u00e3 n\u1ed9i b\u1ed9 l\u1ebb c\u1ee7a K\u1ebf to\u00e1n v\u1ec1 m\u00e3 H\u1ea3i quan th\u1ed1ng nh\u1ea5t, \u0111\u1ea3m b\u1ea3o t\u00ednh trung th\u1ef1c v\u00e0 kh\u1ea3 n\u0103ng gi\u1ea3i tr\u00ecnh cho b\u00e1o c\u00e1o quy\u1ebft to\u00e1n<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>B\u1ea3ng Map Code&nbsp;(hay b\u1ea3ng quy \u0111\u1ed5i m\u00e3) \u0111\u00f3ng vai tr\u00f2 l\u00e0 &#8220;c\u1ea7u n\u1ed1i&#8221; gi\u1ea3i quy\u1ebft [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":649,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[45,48,46,47,44,65],"class_list":["post-648","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc","tag-bao-cao-quyet-toan","tag-che-xuat","tag-gia-cong","tag-san-xuat-xuat-khau","tag-thu-tuc-hai-quan","tag-xuat-nhap-khau"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/posts\/648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/comments?post=648"}],"version-history":[{"count":2,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/posts\/648\/revisions"}],"predecessor-version":[{"id":664,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/posts\/648\/revisions\/664"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/media\/649"}],"wp:attachment":[{"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/media?parent=648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/categories?post=648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/tags?post=648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}