{"id":12533,"date":"2015-09-06T09:50:17","date_gmt":"2015-09-06T09:50:17","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=12533"},"modified":"2015-09-08T23:34:57","modified_gmt":"2015-09-08T23:34:57","slug":"phan-mem-ke-toan-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=12533","title":{"rendered":"Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n excel"},"content":{"rendered":"

\"Ph\u1ea7n<\/h2>\n

Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n excel \u0111\u01b0\u1ee3c l\u00e0m b\u1edfi b\u1ea1n Phan Thinh – K\u1ebf to\u00e1n Centax<\/a>, gi\u00fap cho c\u00e1c b\u1ea1n k\u1ebf to\u00e1n trong c\u00f4ng t\u00e1c ghi s\u1ed5 \u0111\u01b0\u1ee3c d\u1ec5 d\u00e0ng thu\u1eadn ti\u1ec7n.<\/span><\/p>\n

Ph\u1ea7n m\u1ec1m phi\u00ean b\u1ea3n 2.1.5 \u0111\u01b0\u1ee3c b\u1ed5 sung \u0111i\u1ec1u ch\u1ec9nh theo nh\u1eefng quy \u0111\u1ecbnh m\u1edbi nh\u1ea5t, v\u00e0 ti\u1ec7n d\u1ee5ng nh\u1ea5t, v\u1edbi vi\u1ec7c c\u1ed1 g\u1eafng ti\u1ec7n \u00edch h\u00f3a nh\u1eefng c\u00f4ng th\u1ee9c, nh\u1eefng \u0111\u1ecbnh kho\u1ea3n, nh\u1eb1m gi\u00fap c\u00e1c b\u1ea1n ghi s\u1ed5, \u0111\u1ecbnh kho\u1ea3n v\u00e0 ki\u1ec3m tra m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u1edbi nh\u1eefng t\u00ednh n\u0103ng sau:<\/span>
\n PTACCOUNT_CENTAX_2.1.5<\/span><\/p>\n

Link t\u1ea3i :PTACCOUNT_CENTAX_2.1.5<\/a><\/span><\/p>\n

T\u00ednh n\u0103ng m\u1edbi c\u1eadp nh\u1eadt :<\/span><\/p>\n

1. Ho\u1ea1t \u0111\u1ed9ng \u0111\u1ed9c l\u1eadp v\u1edbi c\u00e1c file excel kh\u00e1c ( ti\u1ec7n l\u1ee3i tra th\u00f4ng tin n\u1ebfu c\u1ea7n khi nh\u1eadp tr\u00ean form m\u00e0 c\u1ea7n m\u1edf file excel kh\u00e1c ) c\u00e1c ph\u1ea7n m\u1ec1mexcel kh\u00e1c khi b\u1eadt form th\u00ec form \u0111\u00f3 s\u1ebd chi\u1ebfm t\u00f2an quy\u1ec1n s\u1eed d\u1ee5ngexcel c\u1ee7a b\u1ea1n)<\/span><\/p>\n

2. Th\u00eam Form l\u1ecbch \u00e2m d\u01b0\u01a1ng vi\u1ec7t nam \u0111\u1ec3 ti\u1ec7n xem ng\u00e0y ch\u1ea5m c\u00f4ng ( th\u00eam v\u00e0 s\u1eeda t\u1eeb ngu\u1ed3n tr\u00ean m\u1ea1ng)<\/span><\/p>\n

3. Th\u00eam v\u00e0o ph\u00e2n h\u1ec7 Qu\u1ea3n l\u00fd thu\u1ebf theo d\u00f5i s\u1ed1 d\u01b0 133 v\u00e0 s\u1ed1 thu\u1ebf ph\u1ea3i n\u1ed9p ti\u1ec7n \u0111\u1ed1i chi\u1ebfu v\u1edbi HTKK ( ngu\u1ed3n tr\u00ean m\u1ea1ng)<\/span><\/p>\n

4.Thay \u0111\u1ed5i giao di\u1ec7n r\u01b0\u1eddm r\u00e0 c\u1ee7a excel khi ph\u1ea3i \u0111\u1ed1i m\u1eb7t v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c sheet tr\u00ean excel (nh\u00ecn v\u00e0o th\u1ea5y r\u1ed1i) kh\u00f4ng bi\u1ebft \u0111i \u0111\u00e2u v\u1ec1 \u0111\u00e2u v\u00ec qu\u00e1 nhi\u1ec1u sheet = c\u00e1ch r\u00fat g\u1ecdn v\u00e0 ch\u1ec9 c\u1ea7n v\u00e0o giao di\u1ec7n ch\u00ednh m\u1edf t\u1eebng ph\u00e2n h\u1ec7 v\u00e0 ph\u1ea7n m\u1ec1m s\u1ebd ch\u1ea1y v\u00e0 c\u1ea5t \u0111i khi kh\u00f4ng c\u1ea7n thi\u1ebft<\/span><\/p>\n

5. H\u1ed7 tr\u1ee3 th\u00eam in b\u00eca s\u1ed5<\/span><\/p>\n

————————————————————————————<\/span>
\n T\u00ednh n\u0103ng c\u00f3 trong PT Account phi\u00ean b\u1ea3n c\u0169<\/span>
\n + Xem s\u1ed5 s\u00e1ch d\u1ec5 d\u00e0ng h\u01a1n : Chu\u1ed9t ph\u1ea3i v\u00f9ng tr\u1eafng ho\u1eb7c v\u00e0o thanh c\u00f4ng c\u1ee5 c\u1ee7a excel ho\u1eb7c v\u00e0o Menu<\/span>
\n + M\u1ed9t s\u1ed1 s\u1ed5 quan tr\u1ecdng s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c khi m\u1ea5t c\u00f4ng th\u1ee9c s\u1eb5n c\u00f3 v\u00e0o Menu ch\u1ecdn b\u1ea3o tr\u00ec \u0111\u1ec3 kh\u00f4i ph\u1ee5c c\u00f4ng th\u1ee9c \u0111\u00fang cho file.<\/span>
\n + K\u1ebft chuy\u1ec3n t\u1ef1 \u0111\u1ed9ng : l\u00e0m theo c\u00e1c b\u01b0\u1edbc trong Form K\u1ebft chuy\u1ec3n<\/span>
\n + S\u1eeda ch\u1eefa s\u1ed5 s\u00e1ch k\u1ebf to\u00e1n b\u1eb1ng c\u00e1ch v\u00e0o tr\u1ef1c ti\u1ebfp sheet Data ho\u1eb7c Nh\u1eadp Li\u1ec7u ( n\u1ebfu s\u1eeda kho) Th\u00eam d\u00f2ng ;X\u00f3a d\u00f2ng d\u1eef li\u1ec7u t\u00f9y \u00fd ||| sau khi s\u1eeda xong b\u1ea5m \u0111\u1ecbnh d\u1ea1ng c\u00f4ng th\u1ee9c chu\u1ea9n \u1edf Menu.<\/span>
\n + Phi\u1ebfu Thu chi ; Nh\u1eadp Xu\u1ea5t t\u1ef1 \u0111\u1ed9ng & ** In t\u1ef1 \u0111\u1ed9ng<\/span>
\n + Ch\u1ec9 nh\u1eadp 1 Form c\u00f3 c\u00e1c s\u1ed5 s\u00e1ch k\u1ebf to\u00e1n ;T\u1ed5ng h\u1ee3p,chi ti\u1ebft kho;<\/span>
\n +H\u1ed7 tr\u1ee3 in h\u1ee3p \u0111\u1ed3ng lao \u0111\u1ed9ng ;Ch\u1ea5m c\u00f4ng<\/span>
\n + Ph\u00e2n b\u1ed5 CCDC ;Chi Ph\u00ed tr\u1ea3 tr\u01b0\u1edbc 142,242 ( t\u00ednh n\u0103ng trong pm k\u1ebf to\u00e1n V8)<\/span>
\n +T\u00e0i S\u1ea3n C\u1ed1 \u0111inh: Kh\u1ea5u hao t\u1ef1 \u0111\u1ed9ng ( t\u00ednh n\u0103ng trong pm k\u1ebf to\u00e1n V8)<\/span>
\n + T\u00ednh n\u0103ng b\u1ea3o m\u1eadt b\u1eb1ng \u0111\u0103ng nh\u1eadp t\u00e0i kho\u1ea3n k\u1ebft h\u1ee3p b\u1ea3o v\u1ec7 d\u1eef li\u1ec7u khi kh\u00f4ng s\u1eed d\u1ee5ng file<\/span><\/p>\n

M\u1eddi c\u00e1c b\u1ea1n xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau:<\/span><\/p>\n

T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m Excel hay d\u00f9ng trong k\u1ebf to\u00e1n<\/a><\/span><\/p>\n

M\u00f4 t\u1ea3 c\u00f4ng vi\u1ec7c c\u1ee7a k\u1ebf to\u00e1n t\u1ed5ng h\u1ee3p<\/a><\/span><\/p>\n

Ph\u1ea7n m\u1ec1m ph\u00e2n t\u00edch chi ti\u1ebft BCTC c\u1ee7a doanh nghi\u1ec7p<\/a><\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<\/a><\/span><\/p>\n

K\u1ef9 n\u0103ng ki\u1ec3m tra nhanh b\u00e1o c\u00e1o t\u00e0i ch\u00ednh cu\u1ed1i n\u0103m<\/a><\/span><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

K\u1ebf to\u00e1n Centax xin gi\u1edbi thi\u1ec7u Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n excel \u0111\u1ec3 gi\u00fap c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng excel trong c\u00f4ng t\u00e1c k\u1ebf to\u00e1n \u0111\u01b0\u1ee3c d\u1ec5 d\u00e0ng v\u00e0 thu\u1eadn ti\u1ec7n h\u01a1n. <\/p>\n","protected":false},"author":7,"featured_media":12591,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1564],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/12533"}],"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=12533"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/12533\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/12591"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12533"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}