{"id":15013,"date":"2021-07-16T17:50:57","date_gmt":"2021-07-16T10:50:57","guid":{"rendered":"http:\/\/helpact.misa.vn\/?post_type=ht_kb&p=15013"},"modified":"2025-12-12T11:16:33","modified_gmt":"2025-12-12T04:16:33","slug":"nhap-khau-he-thong-tai-khoan-tu-excel","status":"publish","type":"ht_kb","link":"http:\/\/helpasp.misa.vn\/accounting\/kb\/nhap-khau-he-thong-tai-khoan-tu-excel\/","title":{"rendered":"Nh\u1eadp kh\u1ea9u h\u1ec7 th\u1ed1ng t\u00e0i kho\u1ea3n t\u1eeb Excel"},"content":{"rendered":"
\n
<\/span><\/p>\n

1. T\u1ed5ng quan<\/b><\/h3>\n

<\/div>

\n

M\u1ee5c \u0111\u00edch:<\/b> H\u01b0\u1edbng d\u1eabn c\u00e1ch nh\u1eadp kh\u1ea9u h\u1ec7 th\u1ed1ng t\u00e0i kho\u1ea3n t\u1eeb Excel v\u00e0o ph\u1ea7n m\u1ec1m \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian nh\u1eadp li\u1ec7u, n\u00e2ng cao n\u0103ng su\u1ea5t l\u00e0m vi\u1ec7c.
\nN\u1ed9i dung:<\/b><\/p>\n

    \n
  • Gi\u1edbi thi\u1ec7u t\u00ednh n\u0103ng nh\u1eadp kh\u1ea9u h\u1ec7 th\u1ed1ng t\u00e0i kho\u1ea3n t\u1eeb Excel.<\/li>\n
  • H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n tr\u00ean ph\u1ea7n m\u1ec1m.<\/li>\n
  • L\u01b0u \u00fd v\u1ec1 c\u00e1c tr\u01b0\u1eddng h\u1ee3p nh\u1eadp kh\u1ea9u kh\u00f4ng th\u00e0nh c\u00f4ng v\u00e0 c\u00e1ch x\u1eed l\u00fd.<\/li>\n<\/ul>\n

    Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/b> K\u1ebf to\u00e1n, Qu\u1ea3n tr\u1ecb d\u1eef li\u1ec7u, Ng\u01b0\u1eddi d\u00f9ng qu\u1ea3n l\u00fd danh m\u1ee5c t\u00e0i kho\u1ea3n<\/p>\n<\/div><\/div>\n

    <\/span><\/p>\n

    2. Chi ti\u1ebft thay \u0111\u1ed5i<\/strong><\/h3>\n

    <\/div>

    \n
      \n
    • T\u1eeb tr\u01b0\u1edbc phi\u00ean b\u1ea3n R21:\u00a0<\/strong>Tr\u01b0\u1eddng h\u1ee3p h\u1ec7 th\u1ed1ng t\u00e0i kho\u1ea3n c\u1ee7a \u0111\u01a1n v\u1ecb c\u00f3 nhi\u1ec1u ti\u1ebft kho\u1ea3n con, khi chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u l\u00ean AMIS K\u1ebf to\u00e1n th\u00ec ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i th\u1ef1c hi\u1ec7n nh\u1eadp th\u1ee7 c\u00f4ng c\u00e1c ti\u1ebft kho\u1ea3n v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh r\u1ea5t m\u1ea5t th\u1eddi gian.<\/li>\n
    • T\u1eeb phi\u00ean b\u1ea3n R21:<\/strong>\u00a0Ch\u01b0\u01a1ng tr\u00ecnh b\u1ed5 sung ti\u1ec7n \u00edch\u00a0Nh\u1eadp t\u1eeb Excel<\/strong> \u0111\u1ed1i v\u1edbi danh m\u1ee5c h\u1ec7 th\u1ed1ng t\u00e0i kho\u1ea3n.<\/li>\n<\/ul>\n<\/div><\/div>\n
      <\/span><\/p>\n

      3. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/b><\/h3>\n

      <\/div>

      \n

      B\u01b0\u1edbc 1:<\/strong> V\u00e0o D<\/strong>anh m\u1ee5c<\/strong>\\H\u1ec7 th\u1ed1ng t\u00e0i kho\u1ea3n<\/b>, ch\u1ecdn m\u0169i t\u00ean \u23f7 c\u1ea1nh ch\u1ee9c n\u0103ng <\/span>Th\u00eam\\Nh\u1eadp t\u1eeb Excel<\/b>:
      \n\"\"<\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn T\u1ec7p<\/b> \u0111\u1ec3 t\u1ea3i l\u00ean ch\u01b0\u01a1ng tr\u00ecnh.<\/p>\n

        \n
      • C\u00f3 th\u1ec3 T\u1ea3i t\u1ec7p m\u1eabu<\/b> \u0111\u1ec3 nh\u1eadp nhanh h\u01a1n.<\/li>\n
      • C\u00e1c thi\u1ebft l\u1eadp trong qu\u00e1 tr\u00ecnh nh\u1eadp s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u l\u1ea1i \u0111\u1ec3 s\u1eed d\u1ee5ng cho nh\u1eefng l\u1ea7n sau.<\/li>\n
      • T\u1ea1i m\u1ee5c Ph\u01b0\u01a1ng th\u1ee9c nh\u1eadp<\/b>, t\u00edch ch\u1ecdn Th\u00eam m\u1edbi<\/b> ho\u1eb7c C\u1eadp nh\u1eadt<\/b>:\n
          \n
        • Th\u00eam m\u1edbi:<\/b> C\u00e1c d\u1eef li\u1ec7u tr\u00ean t\u1ec7p nh\u1eadp kh\u1ea9u ch\u01b0a t\u1ed3n t\u1ea1i tr\u00ean h\u1ec7 th\u1ed1ng th\u00ec ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam m\u1edbi v\u00e0o. C\u00e1c d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean h\u1ec7 th\u1ed1ng s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt.<\/li>\n
        • C\u1eadp nh\u1eadt:<\/b> C\u00e1c d\u1eef li\u1ec7u tr\u00ean t\u1ec7p nh\u1eadp kh\u1ea9u ch\u01b0a t\u1ed3n t\u1ea1i tr\u00ean h\u1ec7 th\u1ed1ng th\u00ec ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam m\u1edbi v\u00e0o. \u0110\u1ed3ng th\u1eddi, c\u00e1c d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean h\u1ec7 th\u1ed1ng s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt.\"\"<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

          B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/b>, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd th\u1ef1c hi\u1ec7n t\u1ef1 \u0111\u1ed9ng gh\u00e9p c\u00e1c c\u1ed9t tr\u00ean ph\u1ea7n m\u1ec1m v\u1edbi c\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u.<\/p>\n

          \"\"<\/p>\n

          => <\/b>Nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/b>, ch\u01b0\u01a1ng tr\u00ecnh hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o nh\u01b0 sau:<\/p>\n

          “Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd chuy\u1ec3n to\u00e0n b\u1ed9 ph\u00e1t sinh c\u1ee7a c\u00e1c danh m\u1ee5c, ch\u1ee9ng t\u1eeb ch\u01b0a ghi s\u1ed5 t\u1eeb t\u00e0i kho\u1ea3n t\u1ed5ng h\u1ee3p …”<\/strong>
          \n\"\"<\/p>\n

          B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n C\u00f3<\/b> \u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc Ki\u1ec3m tra d\u1eef li\u1ec7u<\/b>. T\u1ea1i b\u01b0\u1edbc n\u00e0y ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd th\u1ef1c hi\u1ec7n t\u1ef1 \u0111\u1ed9ng ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a c\u00e1c d\u00f2ng th\u00f4ng tin tr\u00ean t\u1ec7p nh\u1eadp kh\u1ea9u v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 ki\u1ec3m k\u00ea.
          \n\"\"<\/p>\n

          L\u01b0u \u00fd:<\/strong> \u0110\u1ed1i v\u1edbi c\u00e1c d\u00f2ng th\u00f4ng tin nh\u1eadp kh\u1ea9u kh\u00f4ng th\u00e0nh c\u00f4ng, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd ch\u1ec9 r\u00f5 nguy\u00ean nh\u00e2n \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng n\u1eafm \u0111\u01b0\u1ee3c v\u00e0 \u0111\u01b0a ra c\u00e1ch kh\u1eafc ph\u1ee5c (n\u1ebfu c\u1ea7n).<\/em><\/p>\n

          B\u01b0\u1edbc 5:<\/strong> Nh\u1ea5n Nh\u1eadp d\u1eef li\u1ec7u<\/b>, ch\u01b0\u01a1ng tr\u00ecnh hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 nh\u1eadp kh\u1ea9u:<\/p>\n

          \"\"<\/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":[3304],"ht-kb-tag":[],"class_list":["post-15013","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r21-ngay-phat-hanh-21-07-2021"],"_links":{"self":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/15013","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=15013"}],"version-history":[{"count":5,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/15013\/revisions"}],"predecessor-version":[{"id":52373,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/15013\/revisions\/52373"}],"wp:attachment":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/media?parent=15013"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-category?post=15013"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-tag?post=15013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}