{"id":32985,"date":"2024-08-07T10:29:33","date_gmt":"2024-08-07T03:29:33","guid":{"rendered":"http:\/\/helpasp.misa.vn\/accounting\/?post_type=ht_kb&#038;p=32985"},"modified":"2025-12-13T16:48:34","modified_gmt":"2025-12-13T09:48:34","slug":"sao-chep-du-lieu-tu-excel-vao-chung-tu","status":"publish","type":"ht_kb","link":"http:\/\/helpasp.misa.vn\/accounting\/kb\/sao-chep-du-lieu-tu-excel-vao-chung-tu\/","title":{"rendered":"Sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb excel v\u00e0o ch\u1ee9ng t\u1eeb"},"content":{"rendered":"<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<p>B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn c\u00e1ch sao ch\u00e9p d\u1eef li\u1ec7u t\u1eebng c\u1ed9t t\u1eeb Excel v\u00e0o giao di\u1ec7n nh\u1eadp li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m \u0111\u1ec3 t\u0103ng t\u1ed1c \u0111\u1ed9 nh\u1eadp li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n t\u1ea1o file nh\u1eadp kh\u1ea9u.<\/p>\n<p>N\u1ed9i dung bao g\u1ed3m gi\u1edbi thi\u1ec7u t\u00ednh n\u0103ng, danh s\u00e1ch ch\u1ee9ng t\u1eeb h\u1ed7 tr\u1ee3 v\u00e0 c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n chi ti\u1ebft.<\/p>\n<p>Ph\u1ea1m vi \u00e1p d\u1ee5ng: K\u1ebf to\u00e1n, Nh\u00e2n vi\u00ean nh\u1eadp li\u1ec7u.<\/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<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<p>Ch\u01b0\u01a1ng tr\u00ecnh cho ph\u00e9p Anh\/Ch\u1ecb sao ch\u00e9p tr\u1ef1c ti\u1ebfp t\u1eebng c\u1ed9t d\u1eef li\u1ec7u tr\u00ean Excel \u0111\u1ec3 d\u00e1n v\u00e0o giao di\u1ec7n nh\u1eadp li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m, gi\u00fap nh\u1eadp li\u1ec7u nhanh ch\u00f3ng m\u00e0 kh\u00f4ng ph\u1ea3i t\u1ea1o file nh\u1eadp kh\u1ea9u t\u1eeb Excel.<\/p>\n<p><strong>C\u00e1c ch\u1ee9ng t\u1eeb h\u1ed7 tr\u1ee3 sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb Excel:<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>Ph\u00e2n h\u1ec7 Mua h\u00e0ng<\/strong><\/td>\n<td><strong>Ph\u00e2n h\u1ec7 B\u00e1n h\u00e0ng<\/strong><\/td>\n<td><strong>Ph\u00e2n h\u1ec7 Ti\u1ec1n m\u1eb7t\/ti\u1ec1n g\u1eedi<\/strong><\/td>\n<td><strong>Ph\u00e2n h\u1ec7 T\u1ed5ng h\u1ee3p<\/strong><\/td>\n<td><strong>Ph\u00e2n h\u1ec7 kho<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1. H\u1ee3p \u0111\u1ed3ng mua h\u00e0ng<br \/>\n2. Ch\u1ee9ng t\u1eeb mua h\u00e0ng ho\u00e1<br \/>\n3. Ch\u1ee9ng t\u1eeb mua h\u00e0ng ho\u00e1 nhi\u1ec1u ho\u00e1 \u0111\u01a1n<br \/>\n4. Ch\u1ee9ng t\u1eeb mua d\u1ecbch v\u1ee5.<\/td>\n<td>1. B\u00e1o gi\u00e1<br \/>\n2. \u0110\u01a1n \u0111\u1eb7t h\u00e0ng<br \/>\n3. Ch\u1ee9ng t\u1eeb b\u00e1n h\u00e0ng h\u00f3a, d\u1ecbch v\u1ee5<\/td>\n<td>1. Phi\u1ebfu thu ti\u1ec1n m\u1eb7t\/ti\u1ec1n g\u1eedi<br \/>\n2. Phi\u1ebfu chi ti\u1ec1n m\u1eb7t\/ti\u1ec1n g\u1eedi<\/td>\n<td>1. Ch\u1ee9ng t\u1eeb nghi\u1ec7p v\u1ee5\u00a0kh\u00e1c<\/td>\n<td>1. Phi\u1ebfu nh\u1eadp kho<br \/>\n2. Phi\u1ebfu xu\u1ea5t kho<br \/>\n3. L\u1ec7nh s\u1ea3n xu\u1ea5t<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn file Excel ch\u1ee9a c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n sao ch\u00e9p v\u00e0o ph\u1ea7n m\u1ec1m v\u00e0 th\u1ef1c hi\u1ec7n sao ch\u00e9p d\u1eef li\u1ec7u t\u1ea1i c\u1ed9t th\u00f4ng tin<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2024\/08\/1..png\" alt=\"\" width=\"861\" height=\"743\" \/><br \/>\n<strong>B\u01b0\u1edbc 2:<\/strong> Tr\u00ean giao di\u1ec7n c\u00e1c ch\u1ee9ng t\u1eeb c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u t\u1eeb file Excel (thu\u1ed9c danh s\u00e1ch ch\u1ee9ng t\u1eeb \u0111\u00e1p \u1ee9ng t\u00ednh n\u0103ng), d\u00e1n d\u1eef li\u1ec7u l\u00ean c\u1ed9t th\u00f4ng tin t\u01b0\u01a1ng \u1ee9ng<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2024\/08\/2-1600x882.png\" alt=\"\" width=\"1600\" height=\"882\" \/><br \/>\n<strong>B\u01b0\u1edbc 3:<\/strong> N\u1ebfu c\u00f3 nhi\u1ec1u c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n sao ch\u00e9p, th\u1ef1c hi\u1ec7n l\u1ea1i thao t\u00e1c l\u1ea7n l\u01b0\u1ee3t tr\u00ean t\u1eebng c\u1ed9t v\u00e0 khai b\u00e1o \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin ch\u1ee9ng t\u1eeb nh\u01b0 b\u00ecnh th\u01b0\u1eddng.<\/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<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>C\u00e1c c\u1ed9t c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ch\u1ee9c n\u0103ng sao ch\u00e9p t\u1eeb Excel bao g\u1ed3m: <strong>M\u00e3 h\u00e0ng; T\u00ean h\u00e0ng; \u0110\u01a1n v\u1ecb t\u00ednh; \u0110\u01a1n gi\u00e1; S\u1ed1 l\u01b0\u1ee3ng; Ti\u1ec1n chi\u1ebft kh\u1ea5u; T\u1ef7 l\u1ec7 chi\u1ebft kh\u1ea5u; % thu\u1ebf su\u1ea5t GTGT, Tr\u01b0\u1eddng m\u1edf r\u1ed9ng.<\/strong><\/li>\n<li><strong>Ch\u1ec9 c\u00f3 th\u1ec3 sao ch\u00e9p \u0111\u01b0\u1ee3c t\u1eebng c\u1ed9t, kh\u00f4ng th\u1ec3 sao ch\u00e9p nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac.<\/strong><\/li>\n<li>Sau khi sao ch\u00e9p c\u1ed9t <strong>M\u00e3 h\u00e0ng\u00a0<\/strong>ho\u1eb7c c\u1ed9t\u00a0<strong>T\u00ean h\u00e0ng<\/strong>, n\u1ebfu tr\u00f9ng v\u1edbi m\u1eb7t h\u00e0ng \u0111\u00e3 c\u00f3 trong danh m\u1ee5c, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng nh\u1eadn di\u1ec7n v\u00e0 \u0111i\u1ec1n c\u00e1c th\u00f4ng tin c\u00f2n l\u1ea1i nh\u01b0 T\u00ean h\u00e0ng\/M\u00e3 h\u00e0ng\/\u0110VT\/\u0110\u01a1n gi\u00e1\u2026<\/li>\n<li>N\u1ebfu\u00a0<strong>M\u00e3 h\u00e0ng\/T\u00ean h\u00e0ng\u00a0<\/strong>ch\u01b0a c\u00f3 trong danh m\u1ee5c, K\u1ebf to\u00e1n ph\u1ea3i t\u1ef1 ch\u1ecdn l\u1ea1i m\u00e3 h\u00e0ng \u0111\u00e3 c\u00f3 ho\u1eb7c t\u1ea1o m\u1edbi m\u00e3 h\u00e0ng.<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":114,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[20],"ht-kb-tag":[],"class_list":["post-32985","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-huong_dan_nghiep_vu"],"_links":{"self":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/32985","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\/114"}],"replies":[{"embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/comments?post=32985"}],"version-history":[{"count":5,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/32985\/revisions"}],"predecessor-version":[{"id":53113,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/32985\/revisions\/53113"}],"wp:attachment":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/media?parent=32985"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-category?post=32985"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-tag?post=32985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}