{"id":507,"date":"2026-07-14T15:57:47","date_gmt":"2026-07-14T08:57:47","guid":{"rendered":"\/khoan-thu\/?post_type=ht_kb&#038;p=507"},"modified":"2026-07-20T08:17:55","modified_gmt":"2026-07-20T01:17:55","slug":"xuat-khau-danh-sach-thu-tien-ra-file-excel-moi-lop-1-file-nhu-the-nao","status":"publish","type":"ht_kb","link":"\/khoan-thu\/knowledge-base\/xuat-khau-danh-sach-thu-tien-ra-file-excel-moi-lop-1-file-nhu-the-nao\/","title":{"rendered":"Xu\u1ea5t kh\u1ea9u danh s\u00e1ch thu ti\u1ec1n ra file Excel m\u1ed7i l\u1edbp 1 file nh\u01b0 th\u1ebf n\u00e0o?"},"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>\u0110\u1ec3 theo d\u00f5i danh s\u00e1ch h\u1ecdc ph\u00ed theo t\u1eebng l\u1edbp ho\u1eb7c t\u1ed5ng h\u1ee3p danh s\u00e1ch h\u1ecdc sinh ph\u00e1t sinh \u1edf nhi\u1ec1u \u0111\u1ee3t thu kh\u00e1c nhau, anh\/ch\u1ecb c\u00f3 th\u1ec3 xu\u1ea5t Danh s\u00e1ch thu ti\u1ec1n (theo h\u1ecdc sinh) ra file Excel. B\u00e1o c\u00e1o h\u1ed7 tr\u1ee3 l\u1ef1a ch\u1ecdn nhi\u1ec1u \u0111\u1ee3t thu \u0111\u1ec3 g\u1ed9p d\u1eef li\u1ec7u tr\u00ean c\u00f9ng m\u1ed9t danh s\u00e1ch, gi\u00fap theo d\u00f5i h\u1ecdc sinh \u0111\u00e3 thu ti\u1ec1n\/c\u00f2n ph\u1ea3i thu trong c\u1ea3 n\u0103m ho\u1eb7c trong nhi\u1ec1u \u0111\u1ee3t thu kh\u00e1c nhau.<\/p>\n<p><b>N\u1ed9i dung:<\/b><\/p>\n<ul>\n<li>H\u01b0\u1edbng d\u1eabn c\u00e1c b\u01b0\u1edbc xu\u1ea5t danh s\u00e1ch thu ti\u1ec1n theo h\u1ecdc sinh ra file Excel, m\u1ed7i l\u1edbp 1 file.<\/li>\n<li>Gi\u1edbi thi\u1ec7u c\u00e1c t\u00f9y ch\u1ecdn in v\u00e0 khai b\u00e1o tham s\u1ed1 b\u00e1o c\u00e1o.<\/li>\n<li>L\u01b0u \u00fd v\u1ec1 ph\u1ea1m vi \u00e1p d\u1ee5ng ch\u1ee9c n\u0103ng xu\u1ea5t kh\u1ea9u.<\/li>\n<\/ul>\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\u0110\u1ec3 xu\u1ea5t \u0111\u01b0\u1ee3c <strong>Danh s\u00e1ch thu ti\u1ec1n<\/strong> ra file Excel m\u1ed7i l\u1edbp 1 sheet th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea1i tab menu ch\u1ecdn <strong>B\u00e1o c\u00e1o<\/strong>, t\u00ecm m\u1ee5c <strong>B\u00e1o c\u00e1o t\u00f9y ch\u1ec9nh<\/strong>, ch\u1ecdn <strong>Danh s\u00e1ch thu ti\u1ec1n (theo h\u1ecdc sinh)<\/strong>. Nh\u1ea5n <strong>Xem<\/strong> ho\u1eb7c k\u00edch \u0111\u00fap chu\u1ed9t v\u00e0o <strong>Danh s\u00e1ch thu ti\u1ec1n (theo h\u1ecdc sinh).<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/wp-content\/uploads\/2025\/12\/266.png\" alt=\"\" width=\"1324\" height=\"769\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/wp-content\/uploads\/2025\/12\/267.png\" alt=\"\" width=\"1451\" height=\"785\" \/><br \/>\n<strong>B\u01b0\u1edbc 2:<\/strong> T\u00edch ch\u1ecdn m\u1ee5c<strong> Xu\u1ea5t kh\u1ea9u<\/strong>. L\u0103n chu\u1ed9t xu\u1ed1ng, t\u1ea1i m\u1ee5c <strong>T\u00f9y ch\u1ecdn in<\/strong>, t\u00edch ch\u1ecdn <strong>M\u1ed7i l\u1edbp 1 sheet<\/strong>. Nh\u1ea5n <strong>\u0110\u1ed3ng \u00fd<\/strong>.<br \/>\n<em>Khai b\u00e1o tham s\u1ed1 b\u00e1o c\u00e1o kh\u00e1c <a href=\"https:\/\/helpemis.misa.vn\/khoan-thu\/knowledge-base\/hp-bc01-danh-sach-thu-tien\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a><\/em><\/p>\n<ul>\n<li>Ch\u1ecdn <strong>\u0110\u1ee3t thu\u00a0<\/strong>c\u1ea7n xu\u1ea5t kh\u1ea9u ra file Excel: Anh\/ch\u1ecb c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111\u1ee3t thu \u0111\u1ec3 g\u1ed9p danh s\u00e1ch h\u1ecdc sinh tr\u00ean c\u00f9ng m\u1ed9t b\u00e1o c\u00e1o, thu\u1eadn ti\u1ec7n theo d\u00f5i t\u00ecnh h\u00ecnh thu ti\u1ec1n c\u1ee7a h\u1ecdc sinh trong c\u1ea3 n\u0103m ho\u1eb7c qua nhi\u1ec1u \u0111\u1ee3t thu kh\u00e1c nhau.<\/li>\n<li>Ch\u1ecdn\u00a0<strong>Ph\u1ea1m vi thu<\/strong>\u00a0<strong><em>(To\u00e0n tr\u01b0\u1eddng; Kh\u1ed1i; L\u1edbp)\u00a0<\/em><\/strong><\/li>\n<li>Ch\u1ecdn\u00a0<strong>Xem theo:<\/strong>\u00a0<em><strong>T\u1ed5ng h\u1ee3p<\/strong>\u00a0<\/em>(ch\u1ec9 hi\u1ec3n th\u1ecb c\u1ed9t s\u1ed1 ti\u1ec1n c\u1ee7a t\u1ed5ng t\u1ea5t c\u1ea3 kho\u1ea3n thu);\u00a0<em><strong>Kho\u1ea3n thu<\/strong><\/em>\u00a0ho\u1eb7c\u00a0<em><strong>Nh\u00f3m kho\u1ea3n thu.<\/strong><\/em><\/li>\n<li>Ch\u1ecdn <strong>Kho\u1ea3n thu<\/strong> trong \u0111\u1ee3t thu c\u1ea7n xu\u1ea5t ra file Excel.<\/li>\n<li>L\u1ef1a ch\u1ecdn<strong>\u00a0H\u00ecnh th\u1ee9c thu<\/strong>\u00a0mu\u1ed1n l\u00ean b\u00e1o c\u00e1o:\u00a0<strong>Ti\u1ec1n m\u1eb7t, Chuy\u1ec3n kho\u1ea3n<\/strong>\u00a0ho\u1eb7c\u00a0<strong>T\u1ea5t c\u1ea3.<\/strong><\/li>\n<li>Ngo\u00e0i \u0111\u1ee3t thu \u0111\u00e3 ch\u1ecdn, c\u00f3 th\u1ec3 thu b\u00f9 nh\u1eefng \u0111\u1ee3t thu ch\u01b0a \u0111\u1ee7 b\u1eb1ng c\u00e1ch ch\u1ecdn trong danh s\u00e1ch\u00a0<strong>Th\u00eam \u0111\u1ee3t thu kh\u00e1c c\u00f2n ph\u1ea3i thu.<\/strong><\/li>\n<li>Nh\u1eadp <strong>Ng\u00e0y l\u1eadp bi\u1ec3u<\/strong> mu\u1ed1n hi\u1ec3n th\u1ecb \u1edf ch\u00e2n b\u00e1o c\u00e1o.<\/li>\n<li>T\u00f9y ch\u1ecdn in:\n<ul style=\"list-style-type: disc;\">\n<li>M\u1ed7i l\u1edbp 1 t\u1ec7p; M\u1ed7i l\u1edbp 1 sheet; To\u00e0n tr\u01b0\u1eddng 1 sheet;<\/li>\n<li>Hi\u1ec3n th\u1ecb h\u1ecdc sinh kh\u00f4ng ph\u1ea3i n\u1ed9p;<\/li>\n<li>Hi\u1ec3n th\u1ecb h\u1ecdc sinh th\u1ea5t thu.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"\/wp-content\/uploads\/2025\/12\/271.png\" alt=\"\" width=\"1247\" height=\"876\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Ph\u1ea7n m\u1ec1m s\u1ebd t\u1ea1o m\u1ed9t t\u1ec7p n\u00e9n \u201cDanh_sach_thu_tien\u201d. Th\u1ef1c hi\u1ec7n gi\u1ea3i n\u00e9n \u0111\u1ec3 xem d\u1eef li\u1ec7u b\u00ean trong. <\/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>Ch\u1ee9c n\u0103ng xu\u1ea5t Excel ch\u1ec9 h\u1ed7 tr\u1ee3 \u0111\u1ed1i v\u1edbi m\u1eabu \u201cDanh s\u00e1ch thu ti\u1ec1n (theo h\u1ecdc sinh)\u201d, trong \u0111\u00f3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch theo t\u1eebng l\u1edbp, m\u1ed7i l\u1edbp t\u01b0\u01a1ng \u1ee9ng m\u1ed9t sheet trong file Excel.<\/li>\n<li>C\u00e1c m\u1eabu \u201cDanh s\u00e1ch thu ti\u1ec1n\u201d hi\u1ec3n th\u1ecb t\u1ea1i ph\u1ea7n B\u00e1o c\u00e1o v\u00e0 m\u1eabu \u201cDanh s\u00e1ch thu ti\u1ec1n (theo l\u1edbp)\u201d hi\u1ec7n kh\u00f4ng h\u1ed7 tr\u1ee3 xu\u1ea5t ra file Excel.<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":17,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[55],"ht-kb-tag":[],"class_list":["post-507","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-faq-bao-cao"],"_links":{"self":[{"href":"\/khoan-thu\/wp-json\/wp\/v2\/ht-kb\/507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/khoan-thu\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/khoan-thu\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/khoan-thu\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"\/khoan-thu\/wp-json\/wp\/v2\/comments?post=507"}],"version-history":[{"count":1,"href":"\/khoan-thu\/wp-json\/wp\/v2\/ht-kb\/507\/revisions"}],"predecessor-version":[{"id":513,"href":"\/khoan-thu\/wp-json\/wp\/v2\/ht-kb\/507\/revisions\/513"}],"wp:attachment":[{"href":"\/khoan-thu\/wp-json\/wp\/v2\/media?parent=507"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/khoan-thu\/wp-json\/wp\/v2\/ht-kb-category?post=507"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/khoan-thu\/wp-json\/wp\/v2\/ht-kb-tag?post=507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}