{"id":31053,"date":"2025-06-24T10:39:46","date_gmt":"2025-06-24T03:39:46","guid":{"rendered":"http:\/\/salagov2help.misa.vn\/?post_type=ht_kb&p=31053"},"modified":"2025-06-27T08:30:32","modified_gmt":"2025-06-27T01:30:32","slug":"ke-toan-mong-muon-lap-bang-tinh-thue-tncn-theo-quy","status":"publish","type":"ht_kb","link":"\/tien-luong\/knowledge-base\/ke-toan-mong-muon-lap-bang-tinh-thue-tncn-theo-quy\/","title":{"rendered":"K\u1ebf to\u00e1n mong mu\u1ed1n l\u1eadp b\u1ea3ng t\u00ednh thu\u1ebf TNCN theo qu\u00fd"},"content":{"rendered":"

1. M\u1ee5c \u0111\u00edch\u00a0<\/strong><\/p>\n

Gi\u00fap k\u1ebf to\u00e1n l\u1eadp b\u1ea3ng t\u00ednh thu\u1ebf thu nh\u1eadp c\u00e1 nh\u00e2n (TNCN) theo qu\u00fd thay v\u00ec theo th\u00e1ng, ph\u00f9 h\u1ee3p v\u1edbi c\u00e1ch t\u00ednh v\u00e0 kh\u1ea5u tr\u1eeb thu\u1ebf th\u1ef1c t\u1ebf t\u1ea1i \u0111\u01a1n v\u1ecb.<\/p>\n

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

T\u1ea1i \u0111\u01a1n v\u1ecb, thay v\u00ec t\u00ednh thu\u1ebf TNCN cho CBNV theo th\u00e1ng v\u00e0o th\u1eddi \u0111i\u1ec3m nh\u1eadn l\u01b0\u01a1ng, k\u1ebf to\u00e1n \u0111\u01a1n v\u1ecb t\u00ednh thu\u1ebf theo Qu\u00fd. N\u1ebfu trong th\u00e1ng t\u00ednh thu\u1ebf TNCN CBNV ph\u1ea3i n\u1ed9p th\u00eam thu\u1ebf, k\u1ebf to\u00e1n s\u1ebd kh\u1ea5u tr\u1eeb lu\u00f4n v\u00e0o l\u01b0\u01a1ng c\u1ee7a th\u00e1ng \u0111\u00f3.<\/p>\n

\u2013 Tr\u01b0\u1edbc phi\u00ean b\u1ea3n R8<\/strong><\/p>\n

Ph\u1ea7n m\u1ec1m ch\u1ec9 h\u1ed7 tr\u1ee3 l\u1eadp b\u1ea3ng t\u00ednh thu\u1ebf TNCN theo th\u00e1ng. K\u1ebf to\u00e1n kh\u00f4ng th\u1ec3 l\u1eadp b\u1ea3ng t\u00ednh theo qu\u00fd n\u1ebfu \u0111\u01a1n v\u1ecb \u00e1p d\u1ee5ng c\u00e1ch t\u00ednh thu\u1ebf theo qu\u00fd.<\/p>\n

\u2013 T\u1eeb phi\u00ean b\u1ea3n R8<\/strong><\/p>\n

Ph\u1ea7n m\u1ec1m b\u1ed5 sung t\u00ednh n\u0103ng cho ph\u00e9p k\u1ebf to\u00e1n l\u1eadp b\u1ea3ng t\u00ednh thu\u1ebf theo qu\u00fd, linh ho\u1ea1t theo ph\u01b0\u01a1ng ph\u00e1p t\u00ednh thu\u1ebf c\u1ee7a t\u1eebng \u0111\u01a1n v\u1ecb.<\/p>\n

C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/strong><\/p>\n

Tr\u01b0\u1eddng h\u1ee3p 1: Th\u00eam m\u1edbi b\u1ea3ng t\u00ednh thu\u1ebf<\/strong><\/p>\n

V\u00e0o menu Thu\u1ebf TNCN\\B\u1ea3ng t\u00ednh thu\u1ebf\\Th\u00eam b\u1ea3ng Thu\u1ebf TNCN<\/strong> $\"\"$ <\/p>\n

\n
Ch\u1ecdn k\u1ef3 t\u00ednh thu\u1ebf: Anh\/ch\u1ecb ch\u1ecdn\u00a0k\u1ef3 t\u00ednh thu\u1ebf l\u00e0 theo Qu\u00fd<\/li>\n
N\u0103m:\u00a0M\u1eb7c \u0111\u1ecbnh l\u00e0 n\u0103m l\u00e0m vi\u1ec7c<\/li>\n
B\u1ea3ng t\u00ednh: Ch\u1ecdn b\u1ea3ng l\u01b0\u01a1ng ho\u1eb7c b\u1ea3ng d\u1eef li\u1ec7u m\u00e0 k\u1ebf to\u00e1n d\u00f9ng \u0111\u1ec3 t\u00ednh thu\u1ebf cho CBNV.<\/li>\n
T\u00ean b\u1ea3ng thu\u1ebf TNCN (b\u1eaft bu\u1ed9c): Nh\u1eadp t\u00ean b\u1ea3ng thu\u1ebf \u0111\u1ec3 d\u1ec5 nh\u1eadn di\u1ec7n<\/li>\n
Nh\u1ea5n \u0110\u1ed3ng \u00fd $\"\"$ <\/li>\n
Ph\u1ea7n m\u1ec1m s\u1ebd hi\u1ec3n th\u1ecb b\u1ea3ng t\u00ednh thu\u1ebf d\u1ef1a v\u00e0o c\u00e1c th\u00f4ng tin anh\/ch\u1ecb m\u1edbi khai b\u00e1o \u1edf tr\u00ean $\"\"$ <\/li>\n<\/ul>\n
Tr\u01b0\u1eddng h\u1ee3p 2: Sao ch\u00e9p b\u1ea3ng thu\u1ebf \u0111\u00e3 c\u00f3 tr\u00ean ph\u1ea7n m\u1ec1m<\/strong><\/p>\n
Tr\u01b0\u1eddng h\u1ee3p \u0111\u00e3 l\u1eadp b\u1ea3ng t\u00ednh thu\u1ebf tr\u00ean ph\u1ea7n m\u1ec1m, \u0111\u1ec3 sao ch\u00e9p s\u1ed1 li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh thu\u1ebf theo th\u00e1ng\/qu\u00fd \u0111\u00e3 l\u1eadp tr\u01b0\u1edbc \u0111\u00f3, anh\/ch\u1ecb vui l\u00f2ng th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n
V\u00e0o menu Thu\u1ebf TNCN\\B\u1ea3ng t\u00ednh thu\u1ebf\\Sao ch\u00e9p b\u1ea3ng Thu\u1ebf \u0111\u00e3 c\u00f3<\/strong> $\"\"$ <\/p>\n
\n
Ch\u1ecdn k\u00fd t\u00ednh thu\u1ebf mu\u1ed1n l\u1eadp<\/li>\n
Ch\u1ecdn b\u1ea3ng t\u00ednh thu\u1ebf c\u00e1c th\u00e1ng\/qu\u00fd \u0111\u00e3 l\u1eadp<\/li>\n
Ch\u1ecdn \u0110\u1ed3ng \u00fd $\"\"$ <\/li>\n
Ph\u1ea7n m\u1ec1m s\u1ebd hi\u1ec3n th\u1ecb b\u1ea3ng t\u00ednh thu\u1ebf d\u1ef1a v\u00e0o c\u00e1c th\u00f4ng tin anh\/ch\u1ecb m\u1edbi khai b\u00e1o \u1edf tr\u00ean $\"\"$ <\/li>\n<\/ul>\n
Tr\u01b0\u1eddng h\u1ee3p 3: Th\u00eam b\u1ea3ng Thu\u1ebf TNCN t\u1eeb t\u1ec7p excel<\/strong><\/p>\n
V\u00e0o menu Thu\u1ebf TNCN\\B\u1ea3ng t\u00ednh thu\u1ebf\\Th\u00eam b\u1ea3ng Thu\u1ebf TNCN t\u1eeb t\u1ec7p excel<\/strong> $\"\"$ <\/p>\n
\n
Ch\u1ecdn k\u00fd t\u00ednh thu\u1ebf mu\u1ed1n l\u1eadp<\/li>\n
T\u1ea3i b\u1ea3ng t\u00ednh thu\u1ebf c\u00e1c th\u00e1ng\/qu\u00fd \u0111\u00e3 l\u1eadp<\/li>\n
Nh\u1eadp d\u00f2ng ti\u00eau \u0111\u1ec1 b\u1eaft \u0111\u1ea7u, d\u00f2ng k\u1ebft th\u00fac ti\u00eau \u0111\u1ec1<\/li>\n
Ch\u1ecdn Ti\u1ebfp t\u1ee5c $\"\"$ <\/li>\n
Ch\u1ecdn c\u1ed9t d\u1eef li\u1ec7u tr\u00ean file nh\u1eadp kh\u1ea9u, ch\u1ecdn Ti\u1ebfp t\u1ee5c $\"\"$ <\/li>\n
Ph\u1ea7n m\u1ec1m s\u1ebd hi\u1ec3n th\u1ecb b\u1ea3ng t\u00ednh thu\u1ebf d\u1ef1a v\u00e0o file nh\u1eadp kh\u1ea9u \u1edf tr\u00ean $\"\"$ <\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
1. M\u1ee5c \u0111\u00edch\u00a0 Gi\u00fap k\u1ebf to\u00e1n l\u1eadp b\u1ea3ng t\u00ednh thu\u1ebf thu nh\u1eadp c\u00e1 nh\u00e2n (TNCN) theo qu\u00fd thay v\u00ec theo th\u00e1ng, ph\u00f9 h\u1ee3p v\u1edbi c\u00e1ch t\u00ednh v\u00e0 kh\u1ea5u tr\u1eeb thu\u1ebf th\u1ef1c t\u1ebf t\u1ea1i \u0111\u01a1n v\u1ecb. 2. Chi ti\u1ebft thay \u0111\u1ed5i T\u1ea1i \u0111\u01a1n v\u1ecb, thay v\u00ec t\u00ednh thu\u1ebf TNCN cho CBNV…<\/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-31053","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\/31053","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=31053"}],"version-history":[{"count":4,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/31053\/revisions"}],"predecessor-version":[{"id":31283,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/31053\/revisions\/31283"}],"wp:attachment":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/media?parent=31053"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=31053"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=31053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}