{"id":34025,"date":"2026-07-27T17:02:23","date_gmt":"2026-07-27T10:02:23","guid":{"rendered":"\/tien-luong\/?post_type=ht_kb&#038;p=34025"},"modified":"2026-07-27T17:05:04","modified_gmt":"2026-07-27T10:05:04","slug":"lam-the-nao-de-chinh-sua-cong-thuc-bang-tinh-bao-cao-tren-phan-mem-ihos-tien-luong","status":"publish","type":"ht_kb","link":"\/tien-luong\/knowledge-base\/lam-the-nao-de-chinh-sua-cong-thuc-bang-tinh-bao-cao-tren-phan-mem-ihos-tien-luong\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c b\u1ea3ng t\u00ednh, b\u00e1o c\u00e1o tr\u00ean ph\u1ea7n m\u1ec1m iHOS Ti\u1ec1n l\u01b0\u01a1ng?"},"content":{"rendered":"<h3 id=\"1-tong-quan\"><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p>B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb c\u00e1ch \u0111\u1ec3 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c tr\u00ean c\u00e1c b\u1ea3ng t\u00ednh l\u01b0\u01a1ng, thu nh\u1eadp kh\u00e1c, ho\u1eb7c c\u00e1c m\u1eabu in b\u00e1o c\u00e1o tr\u00ean ph\u1ea7n m\u1ec1m iHOS Ti\u1ec1n l\u01b0\u01a1ng.<\/p>\n<h3 id=\"2-cac-buoc-thuc-hien\"><strong>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<h4 id=\"2-1-thiet-lap-cong-thuc-tren-cac-mau-bao-cao-hoac-bang-thanh-toan-so-20\"><strong>2.1. Thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c tr\u00ean c\u00e1c m\u1eabu b\u00e1o c\u00e1o ho\u1eb7c b\u1ea3ng thanh to\u00e1n s\u1ed1 20<\/strong><\/h4>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0M\u1edf m\u1eabu b\u00e1o c\u00e1o c\u1ea7n s\u1eeda<\/p>\n<ul>\n<li>V\u00e0o Menu\u00a0<strong>T\u00ednh l\u01b0\u01a1ng\\L\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p<\/strong><\/li>\n<li>Ch\u1ecdn v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng in, sau \u0111\u00f3 ch\u1ecdn M\u1eabu b\u00e1o c\u00e1o mu\u1ed1n in.<\/li>\n<li>Khai b\u00e1o tham s\u1ed1 b\u00e1o c\u00e1o, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>\u0110\u1ed3ng \u00fd<\/strong><\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0Nh\u1ea5n\u00a0<strong>S\u1eeda s\u1ed1 li\u1ec7u<\/strong><\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0Ri\u00eang v\u1edbi b\u1ea3ng thanh to\u00e1n s\u1ed1 20, c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp ngay t\u1ea1i giao di\u1ec7n l\u1eadp, \u0111\u1ec3 s\u1eeda l\u1ea1i b\u1ea3ng thanh to\u00e1n s\u1ed1 20 \u0111\u00e3 l\u1eadp anh\/ch\u1ecb ch\u1ec9 c\u1ea7n m\u1edf l\u1ea1i b\u1ea3ng thanh to\u00e1n 20 \u0111\u00e3 l\u1eadp v\u00e0 nh\u1ea5n S\u1eeda.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Th\u1ef1c hi\u1ec7n ch\u1ec9nh s\u1eeda, thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c cho c\u1ed9t tr\u00ean b\u00e1o c\u00e1o.<\/p>\n<p>\u0110\u1ec3 thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c anh\/ch\u1ecb t\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 m\u00e0u v\u00e0ng t\u1ea1i c\u1ed9t c\u1ea7n thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c\\Ch\u1ecdn\u00a0<strong>Thi\u1ebft l\u1eadp tr\u01b0\u1eddng d\u1eef li\u1ec7u<\/strong>. Ho\u1eb7c ch\u1ecdn chu\u1ed9t v\u00e0o \u00f4 m\u00e0u v\u00e0ng t\u1ea1i c\u1ed9t mu\u1ed1n \u0111\u1eb7t c\u00f4ng th\u1ee9c\\Ch\u1ecdn tab\u00a0<strong>D\u1eef li\u1ec7u\\\u00a0<\/strong>Nh\u1ea5n<strong>\u00a0Thi\u1ebft l\u1eadp tr\u01b0\u1eddng d\u1eef li\u1ec7u.<\/strong><\/p>\n<p>Anh\/ch\u1ecb ch\u1ecdn kho\u1ea3n l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p mu\u1ed1n \u0111i\u1ec1n v\u00e0o c\u1ed9t\\ Nh\u1ea5n\u00a0<strong>\u0110\u1ed3ng \u00fd<\/strong>\u00a0<em>V\u00ed d\u1ee5: T\u1ea1i c\u1ed9t Ph\u1ee5 c\u1ea5p l\u00e0m \u0111\u00eam mu\u1ed1n th\u1ec3 hi\u1ec7n kho\u1ea3n thu nh\u1eadp kh\u00e1c Ph\u1ee5 c\u1ea5p l\u00e0m th\u00eam.<\/em><\/p>\n<p>N\u1ebfu c\u1ed9t c\u1ea7n hi\u1ec3n th\u1ecb ch\u01b0a c\u00f3 tr\u01b0\u1eddng d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng nh\u01b0ng c\u00f3 th\u1ec3 t\u00ednh to\u00e1n t\u1eeb c\u00e1c tr\u01b0\u1eddng hi\u1ec7n c\u00f3, anh\/ch\u1ecb c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 Excel. V\u00ed d\u1ee5 17% t\u1ef7 l\u1ec7 b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i c\u01a1 quan \u0111\u00f3ng tr\u00ean b\u1ea3ng thanh to\u00e1n b\u1ea3o hi\u1ec3m \u0111\u01a1n v\u1ecb mu\u1ed1n t\u00e1ch ra 14% b\u1ea3o hi\u1ec3m h\u01b0u tr\u00ed, 3% thai s\u1ea3n,\u2026 th\u00ec c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp nh\u01b0 sau:<\/p>\n<ul>\n<li>C\u1ed9t 14% b\u1ea3o hi\u1ec3m h\u01b0u tr\u00ed = ([L_M\u0110.M\u0110BH] + [L_M\u0110T] + [TL_M\u0110.M\u0110BH] \u2013 [TT_M\u0110.M\u0110BH])*0,14<\/li>\n<li>C\u1ed9t 3% thai s\u1ea3n: ([L_M\u0110.M\u0110BH] + [L_M\u0110T] + [TL_M\u0110.M\u0110BH] \u2013 [TT_M\u0110.M\u0110BH])*0,03<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-39783 size-full\" src=\"https:\/\/salagov2help.misa.vn\/wp-content\/uploads\/2026\/06\/2026-06-18-4c-1.png\" alt=\"\" width=\"1264\" height=\"1011\" \/><\/p>\n<p><strong>L\u01b0u \u00fd:\u00a0<\/strong><\/p>\n<ul>\n<li>\n<ul>\n<li>Sau khi ch\u1ecdn c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 xem c\u00f4ng th\u1ee9c ch\u1ecdn \u0111\u00e3 \u0111\u00fang tr\u01b0\u1eddng, \u0111\u00fang b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n l\u1ea5y ch\u01b0a t\u1ea1i m\u1ee5c\u00a0<strong>Di\u1ec5n gi\u1ea3i c\u00f4ng th\u1ee9c.<\/strong><\/li>\n<li>C\u1ea7n ch\u1ecdn \u0111\u00fang, \u0111\u1ee7 c\u00f4ng th\u1ee9c t\u1eeb c\u00e1c b\u1ea3ng t\u00ednh c\u1ea7n l\u1ea5y d\u1eef li\u1ec7u: L (B\u1ea3ng l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p, TL (B\u1ea3ng truy l\u0129nh), TT (B\u1ea3ng truy thu), TNK (B\u1ea3ng thu nh\u1eadp kh\u00e1c). V\u00ed d\u1ee5 BHXH ng\u01b0\u1eddi lao \u0111\u1ed9ng \u0111\u00f3ng c\u00f3 c\u00e1c c\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c b\u1ea3ng nh\u01b0 sau:<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>[L_BHXH.NL\u0110\u0110]:<\/strong>\u00a0B\u1ea3ng l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p_BHXH.NL\u0110 \u0111\u00f3ng<\/p>\n<p><strong>[TL_BHXH.NL\u0110\u0110]:<\/strong>\u00a0B\u1ea3ng truy l\u0129nh_BHXH.NL\u0110 \u0111\u00f3ng<\/p>\n<p><strong>[TT_BHXH.NL\u0110\u0110]:<\/strong>\u00a0B\u1ea3ng truy thu_BHXH.NL\u0110 \u0111\u00f3ng<\/p>\n<p>=&gt;\u00a0 N\u1ebfu mu\u1ed1n l\u1ea5y b\u1ea3o hi\u1ec3m x\u00e3 h\u1ed9i tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh s\u1ebd \u0111\u1eb7t c\u00f4ng th\u1ee9c =\u00a0<strong><span class=\"field-chip field-green\">[L_BHXH.NL\u0110\u0110]\u00a0<\/span><span class=\"-operator\">+\u00a0<\/span><span class=\"field-chip field-green\">[TL_BHXH.NL\u0110\u0110]\u00a0<\/span><span class=\"-operator\">+\u00a0<\/span><span class=\"field-chip field-green\">[TT_BHXH.NL\u0110\u0110]<\/span><\/strong><\/p>\n<ul>\n<li>\n<ul>\n<li>Khi s\u1eeda m\u1eabu b\u1ea3ng t\u00ednh\/b\u00e1o c\u00e1o, c\u1ea7n ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c c\u1ea7n s\u1eed d\u1ee5ng. V\u00ed d\u1ee5, n\u1ebfu m\u1eabu b\u00e1o c\u00e1o c\u1ea7n l\u1ea5y c\u00f4ng th\u1ee9c t\u1eeb c\u1ea3 B\u1ea3ng l\u01b0\u01a1ng, Ph\u1ee5 c\u1ea5p v\u00e0 Truy l\u0129nh \u0111\u1ec3 d\u00f9ng cho tr\u01b0\u1eddng h\u1ee3p in t\u1eeb B\u1ea3ng l\u01b0\u01a1ng ho\u1eb7c Truy l\u0129nh, th\u00ec khi m\u1edf m\u1eabu \u0111\u1ec3 s\u1eeda ph\u1ea3i ch\u1ecdn \u0111\u1ea7y \u0111\u1ee7 c\u00e1c b\u1ea3ng t\u00ednh n\u00e0y.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Anh\/ch\u1ecb l\u00e0m theo h\u01b0\u1edbng d\u1eabn chi ti\u1ebft\u00a0<a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/knowledge-base\/huong-dan-lap-bao-cao\/#2-1-sua-mau-bao-cao\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0Nh\u1ea5n\u00a0<strong>In<\/strong><\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0C\u00f3 th\u1ec3 nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng h\u00ecnh c\u00e2y b\u00fat \u1edf t\u00ean b\u00e1o c\u00e1o \u0111\u1ec3 \u0111\u1eb7t t\u00ean m\u1edbi cho b\u00e1o c\u00e1o v\u1eeba ch\u1ec9nh s\u1eeda.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong>\u00a0Nh\u1ea5n\u00a0<strong>L\u01b0u<\/strong>\u00a0\u0111\u1ec3 l\u01b0u l\u1ea1i b\u00e1o c\u00e1o s\u1eed d\u1ee5ng cho l\u1ea7n sau<\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0Nh\u1eefng l\u1ea7n sau \u0111\u1ec3 in b\u00e1o c\u00e1o theo m\u1eabu \u0111\u00e3 ch\u1ec9nh s\u1eeda anh\/ch\u1ecb t\u00edch ch\u1ecdn In t\u1eeb m\u1eabu \u2026 \u0111\u00e3 c\u00f3.<\/p>\n<h4 id=\"2-2-thiet-lap-cong-thuc-cho-bang-tinh-thu-nhap-khac\"><strong>2.2. Thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c cho b\u1ea3ng t\u00ednh thu nh\u1eadp kh\u00e1c<\/strong><\/h4>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a b\u1ea3ng Thu nh\u1eadp kh\u00e1c \u0111\u01b0\u1ee3c l\u1ea5y t\u1eeb kho\u1ea3n Thu nh\u1eadp kh\u00e1c \u0111\u00e3 khai b\u00e1o trong Danh m\u1ee5c. V\u00ec v\u1eady, \u0111\u1ec3 ki\u1ec3m tra ho\u1eb7c ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c tr\u00ean b\u1ea3ng t\u00ednh, ho\u1eb7c kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng l\u1eadp b\u1ea3ng t\u00ednh thu nh\u1eadp kh\u00e1c b\u00e1o l\u1ed7i c\u00f4ng th\u1ee9c d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7, anh\/ch\u1ecb vui l\u00f2ng ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c t\u1ea1i kho\u1ea3n Thu nh\u1eadp kh\u00e1c \u0111\u00e3 khai b\u00e1o trong Danh m\u1ee5c:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0V\u00e0o\u00a0<strong>Danh m\u1ee5c\\Thu nh\u1eadp kh\u00e1c<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0T\u00edch \u0111\u00fap v\u00e0o kho\u1ea3n thu nh\u1eadp kh\u00e1c c\u1ea7n s\u1eeda c\u00f4ng th\u1ee9c\\Nh\u1ea5n\u00a0<strong>S\u1eeda<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Th\u1ef1c hi\u1ec7n ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c<\/p>\n<ul>\n<li>Anh\/ch\u1ecb c\u00f3 th\u1ec3 th\u00eam c\u1ed9t nh\u01b0 trong excel, v\u00e0 \u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh c\u1ed9ng tr\u1eeb c\u00e1c c\u1ed9t nh\u01b0 excel. V\u00ed d\u1ee5 C\u1ed9t Th\u00e0nh ti\u1ec1n s\u1ebd b\u1eb1ng c\u1ed9t \u0110\u01a1n gi\u00e1 l\u00e0m th\u00eam ng\u00e0y x S\u1ed1 gi\u1edd l\u00e0m th\u00eam ng\u00e0y l\u00e0m vi\u1ec7c, anh\/ch\u1ecb thi\u1ebft l\u1eadp h\u00e0m sum,\u2026 ho\u1eb7c c\u00f4ng th\u1ee9c +, -, *, \/ c\u00e1c c\u1ed9t nh\u01b0 excel.<\/li>\n<li>Tr\u01b0\u1eddng h\u1ee3p c\u1ea7n \u0111\u1eb7t c\u00f4ng th\u1ee9c c\u1ee7a c\u1ed9t l\u1ea5y t\u1eeb th\u00f4ng tin \u0111\u00e3 khai b\u00e1o nh\u01b0 h\u1ec7 s\u1ed1 l\u01b0\u01a1ng, m\u1ee9c l\u01b0\u01a1ng c\u01a1 s\u1edf,\u2026 anh\/ch\u1ecb Ch\u1ecdn chu\u1ed9t v\u00e0o \u00f4 m\u00e0u v\u00e0ng t\u1ea1i c\u1ed9t mu\u1ed1n \u0111\u1eb7t c\u00f4ng th\u1ee9c\\T\u00edch chu\u1ed9t ph\u1ea3i<strong>\\\u00a0<\/strong>ch\u1ecdn<strong>\u00a0Thi\u1ebft l\u1eadp tr\u01b0\u1eddng d\u1eef li\u1ec7u\\ G\u00f5 t\u00ean d\u1eef li\u1ec7u c\u1ea7n l\u1ea5y l\u00ean, v\u00e0 ch\u1ecdn c\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u1ee9ng\\<\/strong>Nh\u1ea5n\u00a0<strong>\u0110\u1ed3ng \u00fd.<\/strong><\/li>\n<\/ul>\n<p><strong>L\u01b0u \u00fd:<\/strong>\u00a0N\u1ebfu anh\/ch\u1ecb xem c\u00f4ng th\u1ee9c v\u1eabn \u0111\u00fang nh\u01b0ng l\u1eadp b\u1ea3ng t\u00ednh l\u1ea1i b\u00e1o l\u1ed7i c\u00f4ng th\u1ee9c th\u00ec anh\/ch\u1ecb th\u1ef1c hi\u1ec7n x\u00f3a c\u00f4ng th\u1ee9c c\u0169 v\u00e0 thi\u1ebft l\u1eadp l\u1ea1i r\u1ed3i l\u1eadp l\u1ea1i b\u1ea3ng t\u00ednh.<\/p>\n<ul>\n<li class=\"PDq2pG_selectionAnchorContainer\" data-start=\"63\" data-end=\"91\"><strong data-start=\"63\" data-end=\"91\">Thi\u1ebft l\u1eadp d\u00f2ng T\u1ed5ng c\u1ed9ng<\/strong><\/li>\n<\/ul>\n<p data-start=\"96\" data-end=\"273\">\u0110\u1ec3 t\u00ednh t\u1ed5ng cho m\u1ed9t c\u1ed9t, t\u1ea1i \u00f4\u00a0<strong data-start=\"128\" data-end=\"141\">T\u1ed5ng c\u1ed9ng<\/strong>\u00a0c\u1ee7a c\u1ed9t \u0111\u00f3, nh\u1eadp h\u00e0m\u00a0<strong data-start=\"163\" data-end=\"170\">SUM<\/strong>\u00a0tham chi\u1ebfu \u0111\u1ebfn\u00a0<strong data-start=\"186\" data-end=\"200\">\u00f4 m\u00e0u v\u00e0ng<\/strong>\u00a0\u1edf c\u00f9ng c\u1ed9t (\u00f4 d\u00f9ng \u0111\u1ec3 khai b\u00e1o c\u00f4ng th\u1ee9c cho c\u00e1c d\u00f2ng d\u1eef li\u1ec7u chi ti\u1ebft).<\/p>\n<p data-start=\"278\" data-end=\"353\"><strong data-start=\"278\" data-end=\"288\">V\u00ed d\u1ee5:<\/strong>\u00a0\u1ede c\u1ed9t\u00a0<strong data-start=\"295\" data-end=\"314\" data-is-only-node=\"\">Th\u00e0nh ti\u1ec1n (AR)<\/strong>, \u00f4 T\u1ed5ng c\u1ed9ng \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c:\u00a0<code data-start=\"358\" data-end=\"369\">=SUM(AR4)<\/code><\/p>\n<p data-start=\"374\" data-end=\"383\">Trong \u0111\u00f3:<\/p>\n<ul>\n<li>\n<ul data-start=\"386\" data-end=\"601\">\n<li data-section-id=\"zg4gq0\" data-start=\"386\" data-end=\"502\"><strong data-start=\"388\" data-end=\"395\">AR4<\/strong>\u00a0l\u00e0\u00a0<strong data-start=\"399\" data-end=\"413\" data-is-only-node=\"\">\u00f4 m\u00e0u v\u00e0ng<\/strong>\u00a0d\u00f9ng \u0111\u1ec3 khai b\u00e1o c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u00e1c d\u00f2ng d\u1eef li\u1ec7u chi ti\u1ebft c\u1ee7a c\u1ed9t\u00a0<strong data-start=\"487\" data-end=\"501\">Th\u00e0nh ti\u1ec1n<\/strong>.<\/li>\n<li data-section-id=\"2e69j\" data-start=\"505\" data-end=\"599\">H\u00e0m\u00a0<code data-start=\"511\" data-end=\"521\">SUM(AR4)<\/code>\u00a0s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c sinh ra t\u1eeb c\u00f4ng th\u1ee9c \u0111\u00e3 khai b\u00e1o t\u1ea1i \u00f4\u00a0<strong data-start=\"591\" data-end=\"598\">AR4<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p data-start=\"604\" data-end=\"873\" data-is-last-node=\"\"><strong data-start=\"604\" data-end=\"614\">L\u01b0u \u00fd:<\/strong>\u00a0Sau khi nh\u1eadp c\u00f4ng th\u1ee9c, c\u1ea7n ch\u1ecdn \u0111\u00fang\u00a0<strong data-start=\"653\" data-end=\"674\" data-is-only-node=\"\">\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u<\/strong>\u00a0cho \u00f4 T\u1ed5ng c\u1ed9ng l\u00e0\u00a0<strong data-start=\"694\" data-end=\"705\">S\u1ed1 ti\u1ec1n<\/strong>. Th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch ch\u1ecdn \u00f4 c\u1ea7n \u0111\u1ecbnh d\u1ea1ng, sau \u0111\u00f3 tr\u00ean thanh c\u00f4ng c\u1ee5 ch\u1ecdn\u00a0<strong data-start=\"780\" data-end=\"791\">S\u1ed1 ti\u1ec1n<\/strong>\u00a0t\u1ea1i danh s\u00e1ch \u0111\u1ecbnh d\u1ea1ng (\u00f4 n\u1eb1m c\u1ea1nh bi\u1ec3u t\u01b0\u1ee3ng\u00a0<strong data-start=\"839\" data-end=\"846\">.00<\/strong>), nh\u01b0 minh h\u1ecda trong h\u00ecnh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-43229 size-full\" src=\"https:\/\/salagov2help.misa.vn\/wp-content\/uploads\/2026\/07\/2026-07-10-226.png\" alt=\"\" width=\"1282\" height=\"508\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0Nh\u1ea5n\u00a0<strong>L\u01b0u<\/strong>\u00a0\u0111\u1ec3 l\u01b0u l\u1ea1i c\u00e1c thi\u1ebft l\u1eadp v\u00e0 l\u1eadp l\u1ea1i b\u1ea3ng t\u00ednh v\u00e0 ki\u1ec3m tra.<\/p>\n<h4 id=\"2-3-kiem-tra-chinh-sua-cong-thuc-cho-bang-tinh-luong-phu-cap-truy-linh\"><strong>2.3. Ki\u1ec3m tra, ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c cho b\u1ea3ng t\u00ednh l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p, truy l\u0129nh<\/strong><\/h4>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0Anh\/ch\u1ecb m\u1edf l\u1ea1i b\u1ea3ng l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p \u0111\u00e3 l\u1eadp nh\u1ea5n\u00a0<strong>S\u1eeda<\/strong>\u00a0ho\u1eb7c l\u1eadp b\u1ea3ng l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p theo h\u01b0\u1edbng d\u1eabn\u00a0<a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/knowledge-base\/ke-toan-don-vi-y-te-lap-bang-tinh-luong-phu-cap\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0T\u1ea1i b\u1ea3ng l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p khi c\u1ea7n ki\u1ec3m tra, ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c t\u00ednh t\u1ea1i c\u1ed9t n\u00e0o th\u00ec anh\/ch\u1ecb k\u00edch \u0111\u00fap chu\u1ed9t 2 l\u1ea7n v\u00e0o \u00f4 \u0111\u00f3 \u0111\u1ec3 hi\u1ec7n ra c\u00f4ng th\u1ee9c (t\u01b0\u01a1ng t\u1ef1 nh\u01b0 excel) r\u1ed3i ch\u1ec9nh s\u1eeda l\u1ea1i n\u1ebfu c\u1ea7n.<\/p>\n<p>Anh\/ch\u1ecb xem h\u01b0\u1edbng d\u1eabn chi ti\u1ebft\u00a0<a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/kb\/lam-the-nao-de-kiem-tra-duoc-cach-tinh-cac-cot-tren-bang-tinh\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n<p>L\u01b0u \u00fd: \u0110\u1ed1i v\u1edbi c\u00e1c kho\u1ea3n ph\u1ee5 c\u1ea5p l\u01b0\u01a1ng anh\/ch\u1ecb c\u00f3 th\u1ec3 s\u1eeda c\u00f4ng th\u1ee9c t\u00ednh ph\u1ee5 c\u1ea5p trong\u00a0<a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/knowledge-base\/phu-cap-luong\/\" target=\"_blank\" rel=\"noopener\"><strong>Danh m\u1ee5c\\Ph\u1ee5 c\u1ea5p<\/strong><\/a>.<\/p>\n<h3 id=\"3-luu-y\"><strong>3. L\u01b0u \u00fd<\/strong><\/h3>\n<p class=\"isSelectedEnd\">H\u01b0\u1edbng d\u1eabn n\u00e0y ch\u1ec9 \u00e1p d\u1ee5ng khi ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c t\u00ednh khi s\u1eeda m\u1eabu in b\u00e1o c\u00e1o, b\u1ea3ng t\u00ednh ho\u1eb7c l\u1eadp b\u1ea3ng thanh to\u00e1n s\u1ed1 20.<\/p>\n<p>N\u1ebfu s\u1ed1 li\u1ec7u tr\u00ean b\u1ea3ng t\u00ednh l\u01b0\u01a1ng, ph\u1ee5 c\u1ea5p ch\u01b0a \u0111\u00fang, th\u1ef1c hi\u1ec7n theo h\u01b0\u1edbng d\u1eabn\u00a0<a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/knowledge-base\/khi-lap-bang-luong-phu-cap-thay-so-lieu-khong-dung-thi-lam-the-nao\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a>. N\u1ebfu s\u1ed1 li\u1ec7u tr\u00ean b\u1ea3ng truy l\u0129nh ch\u01b0a \u0111\u00fang, th\u1ef1c hi\u1ec7n theo h\u01b0\u1edbng d\u1eabn\u00a0<a href=\"https:\/\/helpihos.misa.vn\/tien-luong\/knowledge-base\/khi-lap-bang-truy-linh-neu-so-tien-thuc-linh-chua-dung-thi-sua-nhu-the-nao\/\">t\u1ea1i \u0111\u00e2y<\/a>. Kh\u00f4ng \u00e1p d\u1ee5ng h\u01b0\u1edbng d\u1eabn n\u00e0y cho c\u00e1c tr\u01b0\u1eddng h\u1ee3p tr\u00ean.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb c\u00e1ch \u0111\u1ec3 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c tr\u00ean c\u00e1c b\u1ea3ng t\u00ednh l\u01b0\u01a1ng, thu nh\u1eadp kh\u00e1c, ho\u1eb7c c\u00e1c m\u1eabu in b\u00e1o c\u00e1o tr\u00ean ph\u1ea7n m\u1ec1m iHOS Ti\u1ec1n l\u01b0\u01a1ng. 2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n 2.1. Thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c tr\u00ean c\u00e1c m\u1eabu b\u00e1o c\u00e1o&#8230;<\/p>\n","protected":false},"author":59,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[64],"ht-kb-tag":[],"class_list":["post-34025","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cau-hoi-thuong-gap-tinh-luong"],"_links":{"self":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/34025","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\/59"}],"replies":[{"embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/comments?post=34025"}],"version-history":[{"count":2,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/34025\/revisions"}],"predecessor-version":[{"id":34029,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb\/34025\/revisions\/34029"}],"wp:attachment":[{"href":"\/tien-luong\/wp-json\/wp\/v2\/media?parent=34025"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=34025"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=34025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}