{"id":31209,"date":"2025-06-26T14:25:13","date_gmt":"2025-06-26T07:25:13","guid":{"rendered":"http:\/\/salagov2help.misa.vn\/?post_type=ht_kb&#038;p=31209"},"modified":"2025-07-11T08:23:07","modified_gmt":"2025-07-11T01:23:07","slug":"ho-tro-cong-thuc-phuc-tap-cho-10-20-khoan-thu-nhap-khac","status":"publish","type":"ht_kb","link":"\/tien-luong\/knowledge-base\/ho-tro-cong-thuc-phuc-tap-cho-10-20-khoan-thu-nhap-khac\/","title":{"rendered":"H\u1ed7 tr\u1ee3 c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p cho 10 &#8211; 20 kho\u1ea3n thu nh\u1eadp kh\u00e1c"},"content":{"rendered":"<p><strong>1. M\u1ee5c \u0111\u00edch\u00a0<\/strong><\/p>\n<p data-start=\"78\" data-end=\"165\">Gi\u00fap k\u1ebf to\u00e1n \u0111\u01b0a nhanh c\u00f4ng th\u1ee9c t\u00ednh t\u1eeb c\u00e1c b\u1ea3ng t\u00ednh thu nh\u1eadp kh\u00e1c c\u1ee7a kh\u00e1ch h\u00e0ng v\u00e0o ph\u1ea7n m\u1ec1m.<\/p>\n<p><strong>2. Chi ti\u1ebft thay \u0111\u1ed5i<\/strong><\/p>\n<p>T\u1ea1i c\u00e1c \u0111\u01a1n v\u1ecb y t\u1ebf th\u01b0\u1eddng ph\u00e1t sinh r\u1ea5t nhi\u1ec1u b\u1ea3ng t\u00ednh thu nh\u1eadp kh\u00e1c, trung b\u00ecnh m\u1ed7i \u0111\u01a1n v\u1ecb kho\u1ea3ng 20 kho\u1ea3n. Trong m\u1ed7i kho\u1ea3n n\u00e0y s\u1ebd c\u00f3 r\u1ea5t nhi\u1ec1u c\u1ed9t (trung b\u00ecnh kho\u1ea3ng 26 c\u1ed9t) v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c nhau v\u00e0 \u0111\u01b0\u1ee3c chia th\u00e0nh c\u00e1c nh\u00f3m c\u1ed9t.<\/p>\n<p data-start=\"469\" data-end=\"507\"><em>V\u00ed d\u1ee5: Ph\u1ee5 c\u1ea5p tr\u1ef1c 24\/24 g\u1ed3m c\u00e1c c\u1ea5p:<\/em><\/p>\n<ul style=\"list-style-type: circle;\" data-start=\"510\" data-end=\"717\">\n<li data-start=\"510\" data-end=\"558\">\n<p data-start=\"513\" data-end=\"558\"><em>C\u1ea5p 1: Ti\u1ec1n tr\u1ef1c C\u00e1c khoa, Ti\u1ec1n tr\u1ef1c c\u1ea5p c\u1ee9u.<\/em><\/p>\n<\/li>\n<li data-start=\"561\" data-end=\"645\">\n<p data-start=\"564\" data-end=\"645\"><em>C\u1ea5p 2: Trong c\u00e1c c\u1ed9t n\u00e0y c\u00f3 th\u00eam c\u00e1c Tr\u1ef1c ng\u00e0y th\u01b0\u1eddng; ng\u00e0y T7, CN; ng\u00e0y L\u1ec5, t\u1ebft.<\/em><\/p>\n<\/li>\n<li data-start=\"648\" data-end=\"717\">\n<p data-start=\"651\" data-end=\"717\"><em>C\u1ea5p 3: Trong c\u00e1c c\u1ed9t n\u00e0y c\u00f3 c\u00e1c c\u1ed9t: S\u1ed1 ti\u1ec1n, \u0110\u01a1n gi\u00e1, Th\u00e0nh ti\u1ec1n.<\/em><\/p>\n<\/li>\n<\/ul>\n<p><strong>\u2013 Tr\u01b0\u1edbc phi\u00ean b\u1ea3n R8<\/strong><\/p>\n<p>Ph\u1ea7n m\u1ec1m hi\u1ec7n cho ph\u00e9p thi\u1ebft l\u1eadp c\u1ed9t v\u00e0 c\u00f4ng th\u1ee9c cho t\u1eebng c\u1ed9t trong b\u1ea3ng t\u00ednh thu nh\u1eadp kh\u00e1c. Tuy nhi\u00ean, c\u00e1c c\u1ed9t \u0111ang \u0111\u01b0\u1ee3c tr\u1ea3i ph\u1eb3ng, kh\u00f4ng h\u1ed7 tr\u1ee3 g\u1ed9p nh\u00f3m (c\u1ed9t cha \u2013 con), g\u00e2y kh\u00f3 kh\u0103n trong qu\u1ea3n l\u00fd. M\u1ed7i \u0111\u01a1n v\u1ecb c\u00f3 kho\u1ea3ng 20 kho\u1ea3n ph\u1ee5 c\u1ea5p, m\u1ed7i kho\u1ea3n ~26 c\u1ed9t v\u1edbi c\u00f4ng th\u1ee9c ri\u00eang. K\u1ebf to\u00e1n m\u1ea5t nhi\u1ec1u th\u1eddi gian khai b\u00e1o c\u1ed9t, \u0111\u1eb7c bi\u1ec7t khi \u0111\u1ed5i t\u00ean ti\u00eau \u0111\u1ec1 c\u1ed9t (ch\u1ec9 c\u1ea7n thay ch\u1eef c\u00e1i \u0111\u1ea7u), ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed5i m\u00e3 c\u1ed9t, khi\u1ebfn c\u00f4ng th\u1ee9c b\u1ecb sai v\u00e0 ph\u1ea3i s\u1eeda l\u1ea1i th\u1ee7 c\u00f4ng.<\/p>\n<p><strong>\u2013 T\u1eeb phi\u00ean b\u1ea3n R8<\/strong><\/p>\n<p data-start=\"1587\" data-end=\"1691\">K\u1ebf to\u00e1n c\u00f3 th\u1ec3 \u0111\u01b0a nhanh c\u00e1c c\u1ed9t v\u00e0 c\u00f4ng th\u1ee9c t\u00ednh t\u01b0\u01a1ng \u1ee9ng c\u1ee7a nhi\u1ec1u kho\u1ea3n thu nh\u1eadp kh\u00e1c v\u00e0o ph\u1ea7n m\u1ec1m.<\/p>\n<p><strong>C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/strong><\/p>\n<p>1. T\u1ea1i danh m\u1ee5c<strong> Thu nh\u1eadp kh\u00e1c<\/strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-31229 size-full\" src=\"\/wp-content\/uploads\/2025\/06\/2025-06-26_16-08-59.png\" alt=\"\" width=\"1923\" height=\"971\" srcset=\"\/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-08-59.png 1923w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-08-59-300x151.png 300w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-08-59-1024x517.png 1024w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-08-59-768x388.png 768w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-08-59-50x25.png 50w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-08-59-1536x776.png 1536w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-08-59-60x30.png 60w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-08-59-100x50.png 100w\" sizes=\"auto, (max-width: 1923px) 100vw, 1923px\" \/>2. Ch\u1ecdn <strong>Th\u00eam Thu nh\u1eadp kh\u00e1c<\/strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-31231 size-full\" src=\"\/wp-content\/uploads\/2025\/06\/2025-06-26_16-24-29.png\" alt=\"\" width=\"1697\" height=\"851\" srcset=\"\/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-24-29.png 1697w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-24-29-300x150.png 300w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-24-29-1024x514.png 1024w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-24-29-768x385.png 768w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-24-29-50x25.png 50w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-24-29-1536x770.png 1536w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-24-29-60x30.png 60w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_16-24-29-100x50.png 100w\" sizes=\"auto, (max-width: 1697px) 100vw, 1697px\" \/>3. Ch\u1ecdn <strong>Nh\u1eadp danh s\u00e1ch c\u1ed9t t\u1eeb b\u1ea3ng t\u00ednh<\/strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-31251 size-full\" src=\"\/wp-content\/uploads\/2025\/06\/2025-06-26_17-19-17.png\" alt=\"\" width=\"1122\" height=\"550\" srcset=\"\/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-19-17.png 1122w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-19-17-300x147.png 300w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-19-17-1024x502.png 1024w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-19-17-768x376.png 768w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-19-17-50x25.png 50w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-19-17-60x29.png 60w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-19-17-100x49.png 100w\" sizes=\"auto, (max-width: 1122px) 100vw, 1122px\" \/>4. K\u00e9o ho\u1eb7c th\u1ea3 t\u1ec7p excel b\u00e1o c\u00e1o thu nh\u1eadp kh\u00e1c&#8230; v\u00e0o ph\u1ea7n m\u1ec1m<\/p>\n<ul style=\"list-style-type: circle;\">\n<li>Ch\u1ecdn sheet d\u1eef li\u1ec7u l\u00e0 t\u00ean sheet trong file Excel ch\u1ee9a b\u1ea3ng c\u1ea7n l\u1ea5y<\/li>\n<li>D\u00f2ng b\u1eaft \u0111\u1ea7u ti\u00eau \u0111\u1ec1 l\u00e0 d\u00f2ng \u0111\u1ea7u ti\u00ean ch\u1ee9a t\u00ean c\u00e1c c\u1ed9t<\/li>\n<li>D\u00f2ng k\u1ebft th\u00fac ti\u00eau \u0111\u1ec1 l\u00e0 d\u00f2ng cu\u1ed1i c\u00f9ng ch\u1ee9a ph\u1ea7n ti\u00eau \u0111\u1ec1<\/li>\n<li>D\u00f2ng ch\u1ee9a c\u00f4ng th\u1ee9c: L\u00e0 d\u00f2ng trong b\u1ea3ng t\u00ednh c\u00f3 v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c (d\u1eef li\u1ec7u m\u1eabu)<\/li>\n<\/ul>\n<p><em>V\u00ed d\u1ee5: Em c\u00f3 file B\u00e1o c\u00e1o thu nh\u1ea1p kh\u00e1c m\u1eabu C10-HD, Sheet d\u1eef li\u1ec7u l\u00e0 C10-HD B\u00e1o c\u00e1o thu nh\u1eadp kh\u00e1c, d\u00f2ng b\u1eaft \u0111\u1ea7u ti\u00eau \u0111\u1ec1 l\u00e0 7, d\u00f2ng k\u1ebft th\u00fac ti\u00eau \u0111\u1ec1 l\u00e0 9, d\u00f2ng ch\u1ee9a c\u00f4ng th\u1ee9c l\u00e0 d\u00f2ng 12<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-31355 size-full\" src=\"\/wp-content\/uploads\/2025\/06\/2025-06-30_14-38-42.png\" alt=\"\" width=\"1554\" height=\"935\" srcset=\"\/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-30_14-38-42.png 1554w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-30_14-38-42-300x181.png 300w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-30_14-38-42-1024x616.png 1024w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-30_14-38-42-768x462.png 768w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-30_14-38-42-50x30.png 50w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-30_14-38-42-1536x924.png 1536w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-30_14-38-42-60x36.png 60w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-30_14-38-42-100x60.png 100w\" sizes=\"auto, (max-width: 1554px) 100vw, 1554px\" \/><\/em><\/p>\n<ul style=\"list-style-type: circle;\">\n<li>Sau khi \u0111i\u1ec1n xong c\u00e1c tr\u01b0\u1eddng, nh\u1ea5n <strong data-start=\"1463\" data-end=\"1477\">Ti\u1ebfp t\u1ee5c<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-31357 size-full\" src=\"\/wp-content\/uploads\/2025\/06\/2025-06-27_17-52-53-1.png\" alt=\"\" width=\"998\" height=\"617\" srcset=\"\/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-52-53-1.png 998w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-52-53-1-300x185.png 300w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-52-53-1-768x475.png 768w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-52-53-1-50x31.png 50w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-52-53-1-60x37.png 60w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-52-53-1-100x62.png 100w\" sizes=\"auto, (max-width: 998px) 100vw, 998px\" \/><\/strong><\/li>\n<li>Ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1ea5y c\u00f4ng th\u1ee9c t\u1eeb file Excel. N\u1ebfu c\u00f3 c\u00e1c c\u1ed9t \u0111\u1ecbnh danh (nh\u01b0 m\u00e3 CBNV, h\u1ecd t\u00ean&#8230;) b\u1ecb tr\u00f9ng, anh\/ch\u1ecb c\u1ea7n ki\u1ec3m tra v\u00e0 x\u00f3a b\u1edbt nh\u1eefng c\u1ed9t tr\u00f9ng \u0111\u1ec3 tr\u00e1nh b\u1ecb l\u1eb7p khi l\u00ean b\u1ea3ng t\u00ednh.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-31335 size-full\" src=\"\/wp-content\/uploads\/2025\/06\/2025-06-27_17-53-46.png\" alt=\"\" width=\"601\" height=\"233\" srcset=\"\/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-53-46.png 601w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-53-46-300x116.png 300w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-53-46-50x19.png 50w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-53-46-60x23.png 60w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-27_17-53-46-100x39.png 100w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/li>\n<li>Ch\u1ecdn <strong>L\u01b0u<\/strong>\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-31257 size-full\" src=\"\/wp-content\/uploads\/2025\/06\/2025-06-26_17-11-21-1.png\" alt=\"\" width=\"1695\" height=\"850\" srcset=\"\/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-11-21-1.png 1695w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-11-21-1-300x150.png 300w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-11-21-1-1024x514.png 1024w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-11-21-1-768x385.png 768w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-11-21-1-50x25.png 50w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-11-21-1-1536x770.png 1536w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-11-21-1-60x30.png 60w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-11-21-1-100x50.png 100w\" sizes=\"auto, (max-width: 1695px) 100vw, 1695px\" \/><em>L\u00fac n\u00e0y, khi l\u1eadp b\u1ea3ng thu nh\u1eadp kh\u00e1c ph\u1ea7n m\u1ec1m s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh theo c\u00f4ng th\u1ee9c anh\/ch\u1ecb m\u1edbi thi\u1ebft l\u1eadp \u1edf tr\u00ean\u00a0<\/em><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-31259 size-full\" src=\"\/wp-content\/uploads\/2025\/06\/2025-06-26_17-15-19-1.png\" alt=\"\" width=\"1698\" height=\"855\" srcset=\"\/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-15-19-1.png 1698w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-15-19-1-300x151.png 300w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-15-19-1-1024x516.png 1024w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-15-19-1-768x387.png 768w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-15-19-1-50x25.png 50w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-15-19-1-1536x773.png 1536w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-15-19-1-60x30.png 60w, \/tien-luong\/wp-content\/uploads\/2025\/06\/2025-06-26_17-15-19-1-100x50.png 100w\" sizes=\"auto, (max-width: 1698px) 100vw, 1698px\" \/><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>1. M\u1ee5c \u0111\u00edch\u00a0 Gi\u00fap k\u1ebf to\u00e1n \u0111\u01b0a nhanh c\u00f4ng th\u1ee9c t\u00ednh t\u1eeb c\u00e1c b\u1ea3ng t\u00ednh thu nh\u1eadp kh\u00e1c c\u1ee7a kh\u00e1ch h\u00e0ng v\u00e0o ph\u1ea7n m\u1ec1m. 2. Chi ti\u1ebft thay \u0111\u1ed5i T\u1ea1i c\u00e1c \u0111\u01a1n v\u1ecb y t\u1ebf th\u01b0\u1eddng ph\u00e1t sinh r\u1ea5t nhi\u1ec1u b\u1ea3ng t\u00ednh thu nh\u1eadp kh\u00e1c, trung b\u00ecnh m\u1ed7i \u0111\u01a1n v\u1ecb&#8230;<\/p>\n","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[181],"ht-kb-tag":[],"class_list":["post-31209","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r8"],"_links":{"self":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/31209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/comments?post=31209"}],"version-history":[{"count":4,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/31209\/revisions"}],"predecessor-version":[{"id":32979,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/31209\/revisions\/32979"}],"wp:attachment":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/media?parent=31209"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=31209"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=31209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}