{"id":18280,"date":"2015-11-12T01:52:35","date_gmt":"2015-11-12T01:52:35","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=18280"},"modified":"2016-12-09T07:13:24","modified_gmt":"2016-12-09T07:13:24","slug":"huong-dan-lap-bang-can-doi-so-phat-sinh-tren-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=18280","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng C\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh tr\u00ean Excel"},"content":{"rendered":"<h2><img decoding=\"async\" loading=\"lazy\" class=\"alignright wp-image-19316\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/Huong-dan-lap-bang-can-doi-phat-sinh-tren-excel.png\" alt=\"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng C\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh tr\u00ean Excel\" width=\"201\" height=\"122\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/Huong-dan-lap-bang-can-doi-phat-sinh-tren-excel.png 496w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/Huong-dan-lap-bang-can-doi-phat-sinh-tren-excel-300x183.png 300w\" sizes=\"(max-width: 201px) 100vw, 201px\" \/><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">M<\/span><span style=\"font-size: 12pt;\"><span style=\"font-family: helvetica, arial, sans-serif;\">\u1ed9t s\u1ed1 c\u00e1c doanh nghi\u1ec7p v\u1eabn l\u1eadp B\u00e1o c\u00e1o t\u00e0i ch\u00ednh\u00a0tr\u00ean Excel m\u00e0 ch\u01b0a s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m \u0111\u1ec3 l\u00e0m. V\u1eady c\u00e1ch l\u1eadp B\u1ea3ng C\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh tr\u00ean Excel \u0111\u01b0\u1ee3c l\u1eadp nh\u01b0 th\u1ebf n\u00e0o?<\/span><span style=\"font-family: helvetica, arial, sans-serif;\"><a href=\"https:\/\/centax.dsoftware.vn\/gioi-thieu-ve-centax\/\"> K\u1ebf to\u00e1n thu\u1ebf Centax<\/a> xin chia s\u1ebb b\u00e0i H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng C\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh tr\u00ean Excel.<\/span><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">B\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh t\u00e0i kho\u1ea3n d\u00f9ng \u0111\u1ec3 ph\u1ea3n \u00e1nh t\u1ed5ng h\u1ee3p s\u1ed1 hi\u1ec7n c\u00f3 \u0111\u1ea7u n\u0103m, s\u1ed1 ph\u00e1t sinh t\u0103ng, gi\u1ea3m trong n\u0103m v\u00e0 s\u1ed1 hi\u1ec7n c\u00f3 cu\u1ed1i n\u0103m \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i theo t\u00e0i kho\u1ea3n k\u1ebf to\u00e1n c\u1ee7a c\u00e1c lo\u1ea1i t\u00e0i s\u1ea3n, ngu\u1ed3n v\u1ed1n ch\u1ee7 s\u1edf h\u1eefu, n\u1ee3 ph\u1ea3i tr\u1ea3, doanh thu, thu nh\u1eadp kh\u00e1c, chi ph\u00ed v\u00e0 k\u1ebft qu\u1ea3 ho\u1ea1t \u0111\u1ed9ng kinh doanh c\u1ee7a doanh nghi\u1ec7p.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt; color: #000000;\"><strong>1. C\u00e1ch l\u1eadp b\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh t\u00e0i kho\u1ea3n chi ti\u1ebft t\u1eebng ch\u1ec9 ti\u00eau<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">K\u1ebf to\u00e1n Centax xin \u0111\u01b0a ra v\u00ed d\u1ee5 v\u1ec1 m\u1eabu b\u1ea3ng C\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><a href=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-0.png\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18281 aligncenter\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-0.png\" alt=\"CDPS-0\" width=\"600\" height=\"147\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-0.png 1011w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-0-300x73.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u1ed9t 1: S\u1ed1 hi\u1ec7u t\u00e0i kho\u1ea3n: <\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Ghi s\u1ed1 hi\u1ec7u c\u1ee7a t\u1eebng T\u00e0i kho\u1ea3n c\u1ea5p 1 (ho\u1eb7c c\u1ea3 t\u00e0i kho\u1ea3n c\u1ea5p 1 v\u00e0 c\u1ea5p 2) doanh nghi\u1ec7p \u0111ang s\u1eed d\u1ee5ng trong n\u0103m b\u00e1o c\u00e1o.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">\u00a0C\u1ed9t 2: T\u00ean t\u00e0i kho\u1ea3n:\u00a0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Ghi t\u00ean c\u1ee7a t\u1eebng t\u00e0i kho\u1ea3n theo th\u1ee9 t\u1ef1 t\u1eebng lo\u1ea1i m\u00e0 DN \u0111ang s\u1eed d\u1ee5ng.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u1ed9t 3, 4 S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3:<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">&#8211; Ph\u1ea3n \u00e1nh s\u1ed1 d\u01b0 N\u1ee3 \u0111\u1ea7u n\u0103m v\u00e0 d\u01b0 C\u00f3 \u0111\u1ea7u n\u0103m theo t\u1eebng t\u00e0i kho\u1ea3n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">&#8211; S\u1ed1 li\u1ec7u \u0111\u1ec3 ghi \u0111\u01b0\u1ee3c c\u0103n c\u1ee9 v\u00e0o s\u1ed5 c\u00e1i ho\u1eb7c nh\u1eadt k\u00fd \u2013 s\u1ed5 c\u00e1i, ho\u1eb7c c\u0103n c\u1ee9 v\u00e0o s\u1ed1 li\u1ec7u ghi \u1edf c\u1ed9t 7, 8 c\u1ee7a B\u1ea3ng c\u00e2n \u0111\u1ed1i t\u00e0i kho\u1ea3n n\u0103m tr\u01b0\u1edbc.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u1ed9t 5, 6 S\u1ed1 ph\u00e1t sinh trong k\u1ef3:<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">&#8211; C\u0103n c\u1ee9 v\u00e0o t\u1ed5ng s\u1ed1 ph\u00e1t sinh b\u00ean N\u1ee3, s\u1ed1 ph\u00e1t sinh b\u00ean C\u00f3 c\u1ee7a t\u1eebng t\u00e0i kho\u1ea3n trong k\u1ef3 b\u00e1o c\u00e1o.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">&#8211; S\u1ed1 li\u1ec7u \u0111\u1ec3 ghi \u0111\u01b0\u1ee3c c\u0103n c\u1ee9 v\u00e0o t\u1ed5ng s\u1ed1 ph\u00e1t sinh b\u00ean N\u1ee3 v\u00e0 t\u1ed5ng s\u1ed1 ph\u00e1t sinh b\u00ean C\u00f3 c\u1ee7a t\u1eebng t\u00e0i kho\u1ea3n ghi tr\u00ean s\u1ed5 c\u00e1i ho\u1eb7c nh\u1eadt k\u00fd s\u1ed5 c\u00e1i trong k\u1ef3 b\u00e1o c\u00e1o.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">S\u1ed1 7, 8 S\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">&#8211; D\u00f9ng \u0111\u1ec3 ph\u1ea3n \u00e1nh s\u1ed1 d\u01b0 N\u1ee3 cu\u1ed1i k\u1ef3 v\u00e0 s\u1ed1 d\u01b0 C\u00f3 cu\u1ed1i k\u1ef3 theo t\u1eebng kho\u1ea3n m\u1ee5c c\u1ee7a k\u1ef3 b\u00e1o c\u00e1o.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">&#8211; S\u1ed1 li\u1ec7u ghi \u0111\u01b0\u1ee3c t\u00ednh nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #ff0000; font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><strong>S\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 = S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 + S\u1ed1 ph\u00e1t sinh t\u0103ng \u2013 S\u1ed1 ph\u00e1t sinh gi\u1ea3m<\/strong><\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt; color: #000000;\"><strong>2. C\u00e1ch l\u1eadp b\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh tr\u00ean Excel<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">K\u1ebf to\u00e1n Centax h\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u1ea3ng c\u00e2n \u0111\u1ed1i t\u00e0i kho\u1ea3n tr\u00ean Excel theo m\u1eabu nh\u01b0 h\u00ecnh minh h\u1ecda \u1edf tr\u00ean.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00e1c b\u01b0\u1edbc c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">2.1 C\u1ed9t M\u00e3 t\u00e0i kho\u1ea3n, T\u00ean T\u00e0i kho\u1ea3n: D\u00f9ng h\u00e0m Vlookup ho\u1eb7c Copy t\u1eeb Danh m\u1ee5c t\u00e0i kho\u1ea3n v\u1ec1 (L\u01b0u \u00fd v\u1edbi t\u00e0i kho\u1ea3n c\u1ea5p 2 c\u1ee7a c\u00e1c t\u00e0i kho\u1ea3n 333)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><span style=\"color: #ff0000;\"><strong>L\u01b0u \u00fd<\/strong><\/span>: Ph\u1ea3i \u0111\u1ea3m b\u1ea3o r\u1eb1ng danh m\u1ee5c t\u00e0i kho\u1ea3n lu\u00f4n \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt th\u01b0\u1eddng xuy\u00ean c\u00e1c TK v\u1ec1 Kh\u00e1ch h\u00e0ng v\u00e0 ph\u1ea3i \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">2.2 C\u1ed9t d\u01b0 N\u1ee3 \u0111\u1ea7u k\u1ef3 v\u00e0 d\u01b0 C\u00f3 \u0111\u1ea7u k\u1ef3: D\u00f9ng h\u00e0m Vlookup t\u00ecm \u1edf ph\u1ea7n s\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 c\u1ee7a b\u1ea3ng c\u00e2n \u0111\u1ed1i ph\u00e1t sinh c\u1ee7a Th\u00e1ng 1 ho\u1eb7c s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 tr\u01b0\u1edbc v\u1ec1 (Ph\u1ea7n d\u01b0 \u0111\u1ea7u k\u1ef3)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">V\u00ed d\u1ee5: N\u0103m 2014, doanh nghi\u1ec7p c\u0169ng s\u1eed d\u1ee5ng m\u1eabu B\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh nh\u01b0 tr\u00ean. C\u00e1c b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m Vlookup t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb s\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 b\u00ean N\u1ee3 c\u1ee7a T\u00e0i kho\u1ea3n 1111 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><a href=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-2.png\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18282\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-2.png\" alt=\"CDPS-2\" width=\"600\" height=\"174\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-2.png 1140w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-2-300x87.png 300w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-2-1024x296.png 1024w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">T\u1ea1i c\u1ed9t 3, s\u1ed1 d\u01b0 N\u1ee3 \u0111\u1ea7u k\u1ef3 c\u1ee7a T\u00e0i kho\u1ea3n 1111<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">=VLOOKUP(A7,&#8217;C\u0110PS 2014&#8242;!$A$4:$H$142,7,1)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Trong \u0111\u00f3: \u00a0A7: l\u00e0 M\u00e3 T\u00e0i kho\u1ea3n<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 &#8216;C\u0110PS 2014&#8217;!$A$4:$H$142: L\u00e0 b\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh n\u0103m 2014<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a07: Gi\u00e1 tr\u1ecb \u00f4 c\u1ea7n l\u1ea5y trong b\u1ea3ng C\u0110PS n\u0103m 2014, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 s\u1ed1 d\u01b0 N\u1ee3 cu\u1ed1i n\u0103m 2014<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01: D\u00f2 t\u00ecm gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00e1ch l\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi s\u1ed1 d\u01b0 C\u00f3 \u0111\u1ea7u k\u1ef3, Gi\u00e1 tr\u1ecb c\u1ea7n l\u1ea5y l\u00e0 \u00f4 s\u1ed1 8 trong b\u1ea3ng C\u0110PS n\u0103m 2014.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00e1c t\u00e0i kho\u1ea3n kh\u00e1c, c\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n copy c\u00f4ng th\u1ee9c xu\u1ed1ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">2.3 C\u1ed9t ph\u00e1t sinh N\u1ee3, Ph\u00e1t sinh C\u00f3 trong k\u1ef3: S\u1eed d\u1ee5ng h\u00e0m SUMIF t\u1ed5ng h\u1ee3p s\u1ed1 li\u1ec7u t\u1eeb b\u1ea3ng Nh\u1eadt k\u00fd chung c\u1ee7a t\u1eebng th\u00e1ng sang (d\u00e3y \u00f4 \u0111i\u1ec1u ki\u1ec7n v\u1eabn l\u00e0 c\u1ed9t \u00a0TK N\u1ee3\/ TK C\u00f3).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">V\u00ed d\u1ee5: N\u0103m 2014, doanh nghi\u1ec7p c\u0169ng s\u1eed d\u1ee5ng m\u1eabu B\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh nh\u01b0 tr\u00ean. C\u00e1c b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m SUMIF \u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 ph\u00e1t sinh trong k\u1ef3 b\u00ean C\u00f3 c\u1ee7a T\u00e0i kho\u1ea3n 1111 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><a href=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-3.png\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18283\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-3.png\" alt=\"CDPS-3\" width=\"600\" height=\"162\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-3.png 1139w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-3-300x81.png 300w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-3-1024x276.png 1024w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">T\u1ea1i c\u1ed9t 6, S\u1ed1 ph\u00e1t sinh trong k\u1ef3 b\u00ean C\u00f3 c\u1ee7a T\u00e0i Kho\u1ea3n 1111:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">=SUMIF(&#8216;NKC &amp; SC&#8217;!H4:H1152,C\u0110PS2015!A7,&#8217;NKC &amp; SC&#8217;!I4:I1152)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Trong \u0111\u00f3:\u00a0&#8216;NKC &amp; SC&#8217;!H4:H1152: l\u00e0 c\u1ed9t b\u00ean C\u00f3 c\u1ee7a s\u1ed5 Nh\u1eadt k\u00fd chung<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C\u0110PS2015!A7: T\u00e0i kho\u1ea3n c\u1ea7n t\u00ednh t\u1ed5ng l\u00e0 T\u00e0i kho\u1ea3n 1121<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0&#8216;NKC &amp; SC&#8217;!I4:I1152: V\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng t\u1ee9c l\u00e0 s\u1ed1 ti\u1ec1n ph\u00e1t sinh c\u1ee7a s\u1ed5 Nh\u1eadt k\u00fd chung<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00e1ch l\u00e0m t\u01b0\u1ee3ng t\u1ef1 nh\u01b0 c\u1ed9t ph\u00e1t sinh trong k\u1ef3 b\u00ean N\u1ee3 c\u1ee7a T\u00e0i kho\u1ea3n 1111.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00e1c t\u00e0i kho\u1ea3n kh\u00e1c, c\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n copy c\u00f4ng th\u1ee9c xu\u1ed1ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">2.4 S\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u1ed9t N\u1ee3 = Max (S\u1ed1 d\u01b0 N\u1ee3 \u0111\u1ea7u k\u1ef3 + S\u1ed1 PS N\u1ee3 trong k\u1ef3 &#8211; S\u1ed1 d\u01b0 C\u00f3 \u0111\u1ea7u k\u1ef3 &#8211; S\u1ed1 PS C\u00f3 trong k\u1ef3,0)<\/span><\/li>\n<li><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u1ed9t C\u00f3 = Max (S\u1ed1 d\u01b0 C\u00f3 \u0111\u1ea7u k\u1ef3 + S\u1ed1 PS C\u00f3 trong k\u1ef3 &#8211; S\u1ed1 d\u01b0 N\u1ee3 \u0111\u1ea7u l\u1ef3 &#8211; S\u1ed1 PS N\u1ee3 trong k\u1ef3, 0)<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">V\u00ed d\u1ee5,\u00a0N\u0103m 2014, doanh nghi\u1ec7p c\u0169ng s\u1eed d\u1ee5ng m\u1eabu B\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh nh\u01b0 tr\u00ean. C\u00e1c b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m Max t\u00ecm \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb S\u1ed1 d\u01b0 N\u1ee3 cu\u1ed1i k\u1ef3 c\u1ee7a T\u00e0i kho\u1ea3n 1111:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><a href=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-4.png\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18284\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-4.png\" alt=\"CDPS-4\" width=\"600\" height=\"165\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-4.png 1145w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-4-300x83.png 300w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-4-1024x282.png 1024w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/span><\/p>\n<p style=\"text-align: justify;\">\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">T\u1ea1i c\u1ed9t 7, S\u1ed1 d\u01b0 cu\u1ed1i n\u0103m b\u00ean N\u1ee3 c\u1ee7a T\u00e0i kho\u1ea3n 111:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">=MAX(C7+E7-D7-F7,0)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Trong \u0111\u00f3, C7: S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 b\u00ean N\u1ee3 c\u1ee7a T\u00e0i kho\u1ea3n 1111<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">E7: Ph\u00e1t sinh trong k\u1ef3 b\u00ean N\u1ee3 c\u1ee7a T\u00e0i kho\u1ea3n 1111<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">D7: S\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 b\u00ean C\u00f3 c\u1ee7a T\u00e0i kho\u1ea3n 1111<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">F7: Ph\u00e1t sinh trong k\u1ef3 b\u00ean C\u00f3 c\u1ee7a T\u00e0i kho\u1ea3n 1111<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00e1c t\u00e0i kho\u1ea3n kh\u00e1c, c\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n copy c\u00f4ng th\u1ee9c xu\u1ed1ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">\u0110\u1ed1i v\u1edbi b\u00ean C\u00f3 c\u1ee7a c\u00e1c T\u00e0i kho\u1ea3n, c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c nh\u01b0 m\u00ecnh \u0111\u00e3 n\u00eau \u1edf tr\u00ean nh\u00e9.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">2.5 D\u00f9ng h\u00e0m SUBTOTAL t\u00ednh l\u1ea1i t\u1ed5ng cho t\u1eebng TK c\u1ea5p 1 (Ch\u1ec9 c\u1ea7n t\u00ednh cho nh\u1eefng t\u00e0i kho\u1ea3n c\u00f3 ph\u00e1t sinh)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00fa ph\u00e1p = Subtotal(9, d\u00e3y \u00f4 c\u1ea7n t\u00ednh)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><span style=\"color: #ff0000;\"><strong>L\u01b0u \u00fd<\/strong><\/span>: S\u1eed d\u1ee5ng h\u00e0m SUBTOTAL cho TK 333)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">V\u00ed d\u1ee5,\u00a0N\u0103m 2014, doanh nghi\u1ec7p c\u0169ng s\u1eed d\u1ee5ng m\u1eabu B\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh nh\u01b0 tr\u00ean. C\u00e1c b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL \u0111\u1ec3 t\u00ednh t\u1ed5ng cho t\u1eebng TK c\u1ea5p 1 c\u1ee7a T\u00e0i kho\u1ea3n 1111:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\"><a href=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-5.png\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18292\" src=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-5.png\" alt=\"CDPS-5\" width=\"600\" height=\"170\" srcset=\"https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-5.png 1139w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-5-300x85.png 300w, https:\/\/centax.dsoftware.vn\/wp-content\/uploads\/2015\/11\/CDPS-5-1024x290.png 1024w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00e1c T\u00e0i kho\u1ea3n c\u00f2n l\u1ea1i, c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 T\u00e0i kho\u1ea3n 1111.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt; color: #000000;\">3. Nh\u1eefng l\u01b0u \u00fd khi l\u1eadp xong b\u1ea3ng c\u00e2n \u0111\u1ed1i ph\u00e1t sinh t\u00e0i kho\u1ea3n\u00a0<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Tr\u00ean C\u0110PS th\u00ec t\u1ed5ng ph\u00e1t sinh b\u00ean N\u1ee3 ph\u1ea3i b\u1eb1ng t\u1ed5ng ph\u00e1t sinh b\u00ean C\u00f3,<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00e1c t\u00e0i kho\u1ea3n lo\u1ea1i 1 v\u00e0 lo\u1ea1i 2 kh\u00f4ng c\u00f3 s\u1ed1 d\u01b0 b\u00ean C\u00f3. Tr\u1eeb m\u1ed9t s\u1ed1 t\u00e0i kho\u1ea3n nh\u01b0 131, 214,..<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00e1c t\u00e0i kho\u1ea3n lo\u1ea1i 3 v\u00e0 lo\u1ea1i 4 kh\u00f4ng c\u00f3 s\u1ed1 d\u01b0 b\u00ean N\u1ee3, tr\u1eeb m\u1ed9t s\u1ed1 t\u00e0i kho\u1ea3n nh\u01b0 331, 3331, 421,..<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">C\u00e1c t\u00e0i kho\u1ea3n lo\u1ea1i 5 \u0111\u1ebfn lo\u1ea1i 9 cu\u1ed1i k\u1ef3 kh\u00f4ng c\u00f3 s\u1ed1 d\u01b0.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">TK 112 ph\u1ea3i kh\u1edbp v\u1edbi S\u1ed5 ph\u1ee5 ng\u00e2n h\u00e0ng,<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">TK 133, 3331 ph\u1ea3i kh\u1edbp v\u1edbi ch\u1ec9 ti\u00eau tr\u00ean t\u1edd khai thu\u1ebf<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">TK 156 ph\u1ea3i kh\u1edbp v\u1edbi d\u00f2ng t\u1ed5ng c\u1ed9ng tr\u00ean B\u00e1o c\u00e1o NXT kho<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">TK 211 , 214 ph\u1ea3i kh\u1edbp v\u1edbi d\u00f2ng t\u1ed5ng c\u1ed9ng tr\u00ean B\u1ea3ng kh\u1ea5u hao 211<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: helvetica, arial, sans-serif; font-size: 12pt;\">Tr\u00ean \u0111\u00e2y l\u00e0 H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng C\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh tr\u00ean Excel, K\u1ebf to\u00e1n Centax xin g\u1eedi t\u1edbi c\u00e1c b\u1ea1n. Ch\u00fac c\u00e1c b\u1ea1n \u1ee9ng d\u1ee5ng th\u00e0nh c\u00f4ng.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea3ng C\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh c\u1ee7a m\u1ed9t s\u1ed1 c\u00e1c doanh nghi\u1ec7p v\u1eabn \u0111\u01b0\u1ee3c l\u1eadp tr\u00ean Excel m\u00e0 ch\u01b0a s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m \u0111\u1ec3 l\u00e0m. V\u1eady c\u00e1ch l\u1eadp B\u1ea3ng C\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh tr\u00ean Excel \u0111\u01b0\u1ee3c l\u1eadp nh\u01b0 th\u1ebf n\u00e0o? K\u1ebf to\u00e1n Centax xin chia s\u1ebb b\u00e0i H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng C\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh tr\u00ean Excel, M\u1eddi c\u00e1c b\u1ea1n tham kh\u1ea3o<\/p>\n","protected":false},"author":7,"featured_media":19316,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[2315],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/18280"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18280"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/18280\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/19316"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18280"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}