{"id":685,"date":"2026-05-20T11:22:31","date_gmt":"2026-05-20T04:22:31","guid":{"rendered":"https:\/\/dhhp.com.vn\/?p=685"},"modified":"2026-05-20T11:22:33","modified_gmt":"2026-05-20T04:22:33","slug":"xay-dung-bang-map-code-trong-bao-cao-quyet-toan","status":"publish","type":"post","link":"https:\/\/dhhp.com.vn\/en\/xay-dung-bang-map-code-trong-bao-cao-quyet-toan\/","title":{"rendered":"K\u1ef9 thu\u1eadt X\u00e2y d\u1ef1ng B\u1ea3ng Map Code trong B\u00e1o c\u00e1o Quy\u1ebft to\u00e1n"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Vi\u1ec7c x\u00e2y d\u1ef1ng\u00a0<strong>B\u1ea3ng Map Code<\/strong>\u00a0(b\u1ea3ng quy \u0111\u1ed5i m\u00e3) l\u00e0 b\u01b0\u1edbc then ch\u1ed1t \u0111\u1ec3 \u0111\u1ed3ng b\u1ed9 h\u00f3a m\u00e3 h\u00e0ng gi\u1eefa b\u1ed9 ph\u1eadn Xu\u1ea5t nh\u1eadp kh\u1ea9u (XNK) v\u00e0 b\u1ed9 ph\u1eadn K\u1ebf to\u00e1n\/Kho, nh\u1eb1m ph\u1ee5c v\u1ee5 b\u00e1o c\u00e1o quy\u1ebft to\u00e1n ch\u00ednh x\u00e1c.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc v\u00e0 ph\u01b0\u01a1ng ph\u00e1p c\u1ee5 th\u1ec3 \u0111\u1ec3 x\u00e2y d\u1ef1ng b\u1ea3ng n\u00e0y t\u1eeb d\u1eef li\u1ec7u Excel:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u v\u00e0 x\u00e1c \u0111\u1ecbnh quan h\u1ec7 m\u00e3<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Nguy\u00ean t\u1eafc c\u1ed1t l\u00f5i:<\/strong>\u00a0B\u00e1o c\u00e1o quy\u1ebft to\u00e1n ph\u1ea3i l\u1eadp theo m\u00e3 qu\u1ea3n tr\u1ecb c\u1ee7a\u00a0<strong><a href=\"https:\/\/dhhp.com.vn\/en\/khai-bao-hai-quan-cho-loai-hinh-gia-cong-xuat-khau\/\" data-type=\"post\" data-id=\"367\">t\u1edd khai H\u1ea3i quan<\/a> (ECUS)<\/strong>, nh\u01b0ng s\u1ed1 li\u1ec7u (l\u01b0\u1ee3ng) l\u1ea1i l\u1ea5y t\u1eeb\u00a0<strong>s\u1ed5 s\u00e1ch k\u1ebf to\u00e1n\/kho<\/strong>.<\/li>\n\n\n\n<li><strong>X\u00e1c \u0111\u1ecbnh t\u1ef7 l\u1ec7 \u0111\u1ed1i chi\u1ebfu:<\/strong>\u00a0Doanh nghi\u1ec7p c\u1ea7n x\u00e1c \u0111\u1ecbnh m\u00e3 c\u1ee7a m\u00ecnh thu\u1ed9c tr\u01b0\u1eddng h\u1ee3p n\u00e0o:\n<ul class=\"wp-block-list\">\n<li><strong>T\u1ef7 l\u1ec7 1:1:<\/strong>\u00a0M\u1ed9t m\u00e3 H\u1ea3i quan t\u01b0\u01a1ng \u1ee9ng m\u1ed9t m\u00e3 K\u1ebf to\u00e1n.<\/li>\n\n\n\n<li><strong>T\u1ef7 l\u1ec7 1:Nhi\u1ec1u:<\/strong>\u00a0M\u1ed9t m\u00e3 H\u1ea3i quan t\u01b0\u01a1ng \u1ee9ng v\u1edbi nhi\u1ec1u m\u00e3 K\u1ebf to\u00e1n l\u1ebb (do K\u1ebf to\u00e1n chia nh\u1ecf theo l\u00f4, ng\u00e0y nh\u1eadp&#8230;).<\/li>\n\n\n\n<li><strong>T\u1ef7 l\u1ec7 Nhi\u1ec1u:1:<\/strong>\u00a0Nhi\u1ec1u m\u00e3 H\u1ea3i quan (kh\u00e1c m\u00e0u s\u1eafc, k\u00edch th\u01b0\u1edbc) \u0111\u01b0\u1ee3c K\u1ebf to\u00e1n gom chung th\u00e0nh m\u1ed9t m\u00e3 qu\u1ea3n l\u00fd n\u1ed9i b\u1ed9.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">2. C\u00e1c ph\u01b0\u01a1ng ph\u00e1p k\u1ef9 thu\u1eadt tr\u00ean Excel<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A. S\u1eed d\u1ee5ng Pivot Table (Bay-post table) \u0111\u1ec3 t\u1ed5ng h\u1ee3p<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u00e2y l\u00e0 c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t \u0111\u1ec3 x\u1eed l\u00fd t\u1ef7 l\u1ec7&nbsp;<strong>1:Nhi\u1ec1u<\/strong>.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u1ea3 m\u00e3 H\u1ea3i quan, m\u00e3 K\u1ebf to\u00e1n v\u00e0 s\u1ed1 l\u01b0\u1ee3ng.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0V\u00e0o\u00a0<code>Insert<\/code>\u00a0-> ch\u1ecdn\u00a0<code>Pivot Table<\/code>.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0S\u1eafp x\u1ebfp c\u00e1c tr\u01b0\u1eddng (Fields): \u0110\u01b0a\u00a0<strong>M\u00e3 H\u1ea3i quan (ECUS)<\/strong>\u00a0v\u00e0o \u00f4 &#8220;Rows&#8221; \u0111\u1ea7u ti\u00ean, sau \u0111\u00f3 \u0111\u1ebfn\u00a0<strong>M\u00e3 K\u1ebf to\u00e1n<\/strong>\u00a0v\u00e0 cu\u1ed1i c\u00f9ng l\u00e0\u00a0<strong>S\u1ed1 l\u01b0\u1ee3ng<\/strong>\u00a0v\u00e0o \u00f4 &#8220;Values&#8221;.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0\u0110\u1ecbnh d\u1ea1ng l\u1ea1i (Design): Ch\u1ecdn\u00a0<code>Report Layout<\/code>\u00a0->\u00a0<code>Show in Tabular Form<\/code>\u00a0\u0111\u1ec3 c\u00e1c m\u00e3 hi\u1ec3n th\u1ecb song song, gi\u00fap d\u1ec5 d\u00e0ng theo d\u00f5i vi\u1ec7c gom nhi\u1ec1u m\u00e3 k\u1ebf to\u00e1n v\u1ec1 m\u1ed9t m\u00e3 H\u1ea3i quan t\u1ed5ng.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">B. S\u1eed d\u1ee5ng h\u00e0m VLOOKUP ho\u1eb7c INDEX &amp; MATCH<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D\u00f9ng \u0111\u1ec3 r\u00e1p m\u00e3 H\u1ea3i quan t\u01b0\u01a1ng \u1ee9ng v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a K\u1ebf to\u00e1n.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>T\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u K\u1ebf to\u00e1n (v\u00ed d\u1ee5 t\u00e0i kho\u1ea3n 152), ch\u00e8n th\u00eam m\u1ed9t c\u1ed9t g\u1ecdi l\u00e0\u00a0<strong>&#8220;M\u00e3 H\u1ea3i quan t\u01b0\u01a1ng \u1ee9ng&#8221;<\/strong>.<\/li>\n\n\n\n<li>S\u1eed d\u1ee5ng h\u00e0m\u00a0<code>=VLOOKUP(m\u00e3_k\u1ebf_to\u00e1n, b\u1ea3ng_quy_\u0111\u1ed5i, c\u1ed9t_m\u00e3_h\u1ea3i_quan, 0)<\/code>\u00a0\u0111\u1ec3 l\u1ea5y m\u00e3 H\u1ea3i quan g\u1eafn v\u00e0o t\u1eebng d\u00f2ng d\u1eef li\u1ec7u k\u1ebf to\u00e1n l\u1ebb.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">C. Ti\u1ec7n \u00edch F5 (Go to special) \u0111\u1ec3 l\u1ea5p \u0111\u1ea7y \u00f4 tr\u1ed1ng (Fill Blanks)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Khi xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb ph\u1ea7n m\u1ec1m n\u1ed9i b\u1ed9, m\u00e3 s\u1ea3n ph\u1ea9m th\u01b0\u1eddng ch\u1ec9 n\u1eb1m \u1edf d\u00f2ng \u0111\u1ea7u ti\u00ean, c\u00e1c d\u00f2ng nguy\u00ean li\u1ec7u ph\u1ee5 ph\u00eda d\u01b0\u1edbi b\u1ecb \u0111\u1ec3 tr\u1ed1ng. \u0110\u1ec3 map code h\u00e0ng lo\u1ea1t, b\u1ea1n l\u00e0m nh\u01b0 sau:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u c\u00f3 \u00f4 tr\u1ed1ng.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0B\u1ea5m\u00a0<code>Ctrl + G<\/code>\u00a0(ho\u1eb7c\u00a0<code>F5<\/code>) -> ch\u1ecdn\u00a0<code>Special<\/code>\u00a0-> ch\u1ecdn\u00a0<code>Blanks<\/code>.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Nh\u1eadp d\u1ea5u b\u1eb1ng v\u00e0 click v\u00e0o \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u ngay ph\u00eda tr\u00ean (v\u00ed d\u1ee5:\u00a0<code>=C12<\/code>).<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Ctrl + Enter<\/strong>\u00a0\u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n m\u00e3 cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u1ed1ng d\u1ef1a tr\u00ean m\u00e3 g\u1ed1c ph\u00eda tr\u00ean.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">3. L\u01b0u \u00fd quan tr\u1ecdng khi x\u00e2y d\u1ef1ng b\u1ea3ng<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u0110\u01a1n v\u1ecb t\u00ednh:<\/strong>\u00a0N\u1ebfu XNK khai b\u1eb1ng &#8220;m\u00e9t&#8221; nh\u01b0ng Kho qu\u1ea3n l\u00fd b\u1eb1ng &#8220;yard&#8221;, b\u1ea3ng Map Code c\u1ea7n c\u00f3 th\u00eam\u00a0<strong>c\u1ed9t t\u1ef7 l\u1ec7 quy \u0111\u1ed5i<\/strong>\u00a0(v\u00ed d\u1ee5: 1 m\u00e9t = 1.0936 yard) \u0111\u1ec3 nh\u00e2n\/chia s\u1ed1 l\u01b0\u1ee3ng cho kh\u1edbp.<\/li>\n\n\n\n<li><strong>Ngu\u1ed3n d\u1eef li\u1ec7u:<\/strong>\u00a0\u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p\u00a0<strong>Nhi\u1ec1u m\u00e3 H\u1ea3i quan : 1 m\u00e3 K\u1ebf to\u00e1n<\/strong>, b\u1ed9 ph\u1eadn XNK th\u01b0\u1eddng b\u1ecb \u0111\u1ed9ng, c\u1ea7n ph\u1ed1i h\u1ee3p ch\u1eb7t ch\u1ebd v\u1edbi K\u1ebf to\u00e1n \u0111\u1ec3 h\u1ecd cung c\u1ea5p b\u1ea3ng Map s\u1eb5n v\u00ec h\u1ecd l\u00e0 b\u00ean ch\u1ee7 \u0111\u1ed9ng gom m\u00e3.<\/li>\n\n\n\n<li><strong>L\u01b0u tr\u1eef:<\/strong>\u00a0B\u1ea3ng Map Code kh\u00f4ng c\u1ea7n n\u1ed9p c\u00f9ng b\u00e1o c\u00e1o quy\u1ebft to\u00e1n nh\u01b0ng\u00a0<strong>b\u1eaft bu\u1ed9c ph\u1ea3i l\u01b0u tr\u1eef t\u1ea1i doanh nghi\u1ec7p<\/strong>\u00a0\u0111\u1ec3 gi\u1ea3i tr\u00ecnh khi <a href=\"https:\/\/thuvienphapluat.vn\/cong-dong-dan-luat\/quy-dinh-kiem-tra-sau-thong-quan-tai-tru-so-co-quan-hai-quan-tai-tru-so-nguoi-khai-hai-quan-213646.html\" target=\"_blank\" rel=\"noopener\">H\u1ea3i quan ki\u1ec3m tra sau th\u00f4ng quan (th\u1eddi h\u1ea1n 5 n\u0103m)<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Vi\u1ec7c x\u00e2y d\u1ef1ng\u00a0B\u1ea3ng Map Code\u00a0(b\u1ea3ng quy \u0111\u1ed5i m\u00e3) l\u00e0 b\u01b0\u1edbc then ch\u1ed1t \u0111\u1ec3 \u0111\u1ed3ng b\u1ed9 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":686,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[45,95,48,46,94,47,44],"class_list":["post-685","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc","tag-bao-cao-quyet-toan","tag-bao-cao-quyet-toan-hai-quan","tag-che-xuat","tag-gia-cong","tag-map-code","tag-san-xuat-xuat-khau","tag-thu-tuc-hai-quan"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/posts\/685","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=685"}],"version-history":[{"count":1,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/posts\/685\/revisions"}],"predecessor-version":[{"id":687,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/posts\/685\/revisions\/687"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/media\/686"}],"wp:attachment":[{"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/media?parent=685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/categories?post=685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dhhp.com.vn\/en\/wp-json\/wp\/v2\/tags?post=685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}