{"id":999978269,"date":"2025-09-01T15:50:06","date_gmt":"2025-09-01T08:50:06","guid":{"rendered":"https:\/\/bizzi.vn\/?p=999978269"},"modified":"2026-06-09T13:50:10","modified_gmt":"2026-06-09T06:50:10","slug":"how-to-make-excel-financial-report","status":"publish","type":"post","link":"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/","title":{"rendered":"Instructions on how to create Excel financial reports for beginners"},"content":{"rendered":"<article><span style=\"font-weight: 400;\"><strong>C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh Excel<\/strong> l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng n\u1ec1n t\u1ea3ng \u0111\u1ed1i v\u1edbi m\u1ecdi k\u1ebf to\u00e1n vi\u00ean, \u0111\u1eb7c bi\u1ec7t t\u1ea1i c\u00e1c doanh nghi\u1ec7p v\u1eeba v\u00e0 nh\u1ecf (SMEs), h\u1ed9 kinh doanh v\u00e0 startups. B\u00e0i vi\u1ebft n\u00e0y c\u1ee7a Bizzi kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t h\u01b0\u1edbng d\u1eabn chi ti\u1ebft t\u1eebng b\u01b0\u1edbc m\u00e0 c\u00f2n ph\u00e2n t\u00edch s\u00e2u v\u1ec1 \u01b0u, nh\u01b0\u1ee3c \u0111i\u1ec3m, cung c\u1ea5p file m\u1eabu mi\u1ec5n ph\u00ed v\u00e0 gi\u1ea3i ph\u00e1p \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a quy tr\u00ecnh quan tr\u1ecdng n\u00e0y.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Bao_Cao_Tai_Chinh_BCTC_La_Gi\" >B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh (BCTC) L\u00e0 G\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Uu_va_Nhuoc_Diem_Khi_Lap_Bao_Cao_Tai_Chinh_Bang_Excel\" >\u01afu v\u00e0 Nh\u01b0\u1ee3c \u0110i\u1ec3m Khi L\u1eadp B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh B\u1eb1ng Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Uu_diem\" >\u01afu \u0111i\u1ec3m<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Nhuoc_diem\" >Nh\u01b0\u1ee3c \u0111i\u1ec3m<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Cac_Loai_Bao_Cao_Tai_Chinh_Bat_Buoc_Theo_Quy_Dinh_Thong_tu_2002014TT-BTC\" >C\u00e1c Lo\u1ea1i B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh B\u1eaft Bu\u1ed9c Theo Quy \u0110\u1ecbnh (Th\u00f4ng t\u01b0 200\/2014\/TT-BTC)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Chuan_Bi_Gi_Truoc_Khi_Thuc_Hien_Cach_Lap_Bao_Cao_Tai_Chinh_Excel\" >Chu\u1ea9n B\u1ecb G\u00ec Tr\u01b0\u1edbc Khi Th\u1ef1c Hi\u1ec7n C\u00e1ch L\u1eadp B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh Excel?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#1_Thu_thap_va_he_thong_hoa_du_lieu_ke_toan\" >1. Thu th\u1eadp v\u00e0 h\u1ec7 th\u1ed1ng h\u00f3a d\u1eef li\u1ec7u k\u1ebf to\u00e1n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#2_Kiem_tra_va_doi_chieu_so_du_dau_ky\" >2. Ki\u1ec3m tra v\u00e0 \u0111\u1ed1i chi\u1ebfu s\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Huong_Dan_Cach_Lap_Bao_Cao_Tai_Chinh_Excel_Step-by-Step\" >H\u01b0\u1edbng D\u1eabn C\u00e1ch L\u1eadp B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh Excel [Step-by-Step]<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#1_Lap_Bao_cao_ket_qua_hoat_dong_kinh_doanh\" >1. L\u1eadp B\u00e1o c\u00e1o k\u1ebft qu\u1ea3 ho\u1ea1t \u0111\u1ed9ng kinh doanh<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#2_Lap_Bang_can_doi_ke_toan\" >2. L\u1eadp B\u1ea3ng c\u00e2n \u0111\u1ed1i k\u1ebf to\u00e1n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#3_Lap_Bao_cao_luu_chuyen_tien_te_Phuong_phap_gian_tiep\" >3. L\u1eadp B\u00e1o c\u00e1o l\u01b0u chuy\u1ec3n ti\u1ec1n t\u1ec7 (Ph\u01b0\u01a1ng ph\u00e1p gi\u00e1n ti\u1ebfp)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Nhung_Loi_Thuong_Gap_Khi_Lap_BCTC_Tren_Excel_va_Cach_Khac_Phuc\" >Nh\u1eefng L\u1ed7i Th\u01b0\u1eddng G\u1eb7p Khi L\u1eadp BCTC Tr\u00ean Excel v\u00e0 C\u00e1ch Kh\u1eafc Ph\u1ee5c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Excel_vs_Phan_Mem_Ke_Toan_Khi_Nao_Doanh_Nghiep_Nen_Nang_Cap\" >Excel vs. Ph\u1ea7n M\u1ec1m K\u1ebf To\u00e1n: Khi N\u00e0o Doanh Nghi\u1ec7p N\u00ean N\u00e2ng C\u1ea5p?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Cau_Hoi_Thuong_Gap_FAQ\" >C\u00e2u H\u1ecfi Th\u01b0\u1eddng G\u1eb7p (FAQ)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#1_Lam_the_nao_de_kiem_tra_sai_sot_tren_BCTC_Excel_mot_cach_nhanh_nhat\" >1. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ki\u1ec3m tra sai s\u00f3t tr\u00ean BCTC Excel m\u1ed9t c\u00e1ch nhanh nh\u1ea5t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#2_File_Excel_BCTC_co_tuan_thu_theo_Thong_tu_200133_cua_Bo_Tai_chinh_khong\" >2. File Excel BCTC c\u00f3 tu\u00e2n th\u1ee7 theo Th\u00f4ng t\u01b0 200\/133 c\u1ee7a B\u1ed9 T\u00e0i ch\u00ednh kh\u00f4ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#3_Nen_su_dung_ham_Excel_nao_la_quan_trong_nhat_khi_lap_BCTC\" >3. N\u00ean s\u1eed d\u1ee5ng h\u00e0m Excel n\u00e0o l\u00e0 quan tr\u1ecdng nh\u1ea5t khi l\u1eadp BCTC?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/bizzi.vn\/en\/how-to-make-excel-financial-report\/#Ket_Luan\" >K\u1ebft Lu\u1eadn<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Bao_Cao_Tai_Chinh_BCTC_La_Gi\"><\/span>B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh (BCTC) L\u00e0 G\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u00e1o c\u00e1o t\u00e0i ch\u00ednh l\u00e0 m\u1ed9t h\u1ec7 th\u1ed1ng t\u00e0i li\u1ec7u k\u1ebf to\u00e1n, ph\u1ea3n \u00e1nh t\u1ed5ng qu\u00e1t t\u00ecnh h\u00ecnh t\u00e0i ch\u00ednh, k\u1ebft qu\u1ea3 kinh doanh v\u00e0 c\u00e1c lu\u1ed3ng ti\u1ec1n c\u1ee7a doanh nghi\u1ec7p trong m\u1ed9t k\u1ef3 k\u1ebf to\u00e1n. \u0110\u1ed1i v\u1edbi c\u00e1c doanh nghi\u1ec7p ch\u01b0a \u0111\u1ea7u t\u01b0 v\u00e0o ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n chuy\u00ean d\u1ee5ng, Excel ch\u00ednh l\u00e0 c\u00f4ng c\u1ee5 kh\u1edfi \u0111\u1ea7u l\u00fd t\u01b0\u1edfng \u0111\u1ec3 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb s\u1ed5 nh\u1eadt k\u00fd, s\u1ed5 c\u00e1i v\u00e0 c\u00e1c b\u1ea3ng c\u00e2n \u0111\u1ed1i.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Uu_va_Nhuoc_Diem_Khi_Lap_Bao_Cao_Tai_Chinh_Bang_Excel\"><\/span>\u01afu v\u00e0 Nh\u01b0\u1ee3c \u0110i\u1ec3m Khi L\u1eadp B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh B\u1eb1ng Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>S\u1eed d\u1ee5ng Excel \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch nh\u01b0ng c\u0169ng \u0111i k\u00e8m kh\u00f4ng \u00edt r\u1ee7i ro ti\u1ec1m \u1ea9n m\u00e0 doanh nghi\u1ec7p c\u1ea7n n\u1eafm r\u00f5.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Uu_diem\"><\/span>\u01afu \u0111i\u1ec3m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><strong>Mi\u1ec5n ph\u00ed v\u00e0 quen thu\u1ed9c:<\/strong> Excel \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p s\u1eb5n trong b\u1ed9 Microsoft Office, gi\u00fap doanh nghi\u1ec7p ti\u1ebft ki\u1ec7m chi ph\u00ed b\u1ea3n quy\u1ec1n v\u00e0 kh\u00f4ng y\u00eau c\u1ea7u \u0111\u00e0o t\u1ea1o ph\u1ee9c t\u1ea1p.<\/li>\n<li><strong>Linh ho\u1ea1t v\u00e0 t\u00f9y bi\u1ebfn cao:<\/strong> K\u1ebf to\u00e1n vi\u00ean c\u00f3 to\u00e0n quy\u1ec1n ki\u1ec3m so\u00e1t, d\u1ec5 d\u00e0ng th\u00eam b\u1edbt c\u1ed9t, d\u00f2ng, v\u00e0 t\u00f9y ch\u1ec9nh c\u00f4ng th\u1ee9c \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi \u0111\u1eb7c th\u00f9 qu\u1ea3n tr\u1ecb c\u1ee7a doanh nghi\u1ec7p m\u00e0 kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n b\u1edfi m\u1ed9t khu\u00f4n m\u1eabu c\u1ee9ng nh\u1eafc.<\/li>\n<li><strong>Ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u tr\u1ef1c quan:<\/strong> C\u00e1c h\u00e0m t\u00ednh to\u00e1n m\u1ea1nh m\u1ebd nh\u01b0 SUMIF, VLOOKUP, INDEX-MATCH v\u00e0 c\u00f4ng c\u1ee5 Pivot Table cho ph\u00e9p t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p, tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u r\u00f5 r\u00e0ng v\u00e0 gi\u1ea3m thi\u1ec3u sai s\u00f3t do t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Nhuoc_diem\"><\/span>Nh\u01b0\u1ee3c \u0111i\u1ec3m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><strong>R\u1ee7i ro sai s\u00f3t cao:<\/strong> M\u1ed9t l\u1ed7i nh\u1ecf trong vi\u1ec7c nh\u1eadp li\u1ec7u ho\u1eb7c \u0111\u1eb7t c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 lan truy\u1ec1n v\u00e0 g\u00e2y sai l\u1ec7ch to\u00e0n b\u1ed9 b\u00e1o c\u00e1o. Vi\u1ec7c d\u00f2 t\u00ecm v\u00e0 s\u1eeda l\u1ed7i (troubleshooting) c\u1ef1c k\u1ef3 t\u1ed1n th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c, \u0111\u1eb7c bi\u1ec7t khi d\u1eef li\u1ec7u chi ph\u00ed \u0111\u01b0\u1ee3c nh\u1eadp th\u1ee7 c\u00f4ng t\u1eeb nhi\u1ec1u ngu\u1ed3n h\u00f3a \u0111\u01a1n.<\/li>\n<li><strong>B\u1ea3o m\u1eadt d\u1eef li\u1ec7u th\u1ea5p:<\/strong> File Excel d\u1ec5 b\u1ecb m\u1ea5t m\u00e1t do l\u1ed7i ph\u1ea7n c\u1ee9ng, virus, ho\u1eb7c b\u1ecb r\u00f2 r\u1ec9 khi chia s\u1ebb qua email, USB. D\u1eef li\u1ec7u t\u00e0i ch\u00ednh nh\u1ea1y c\u1ea3m kh\u00f4ng \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1edfi c\u00e1c l\u1edbp b\u1ea3o m\u1eadt chuy\u00ean s\u00e2u.<\/li>\n<li><strong>T\u1ed1n th\u1eddi gian c\u1eadp nh\u1eadt th\u1ee7 c\u00f4ng:<\/strong> Khi c\u00f3 s\u1ef1 thay \u0111\u1ed5i trong quy \u0111\u1ecbnh (v\u00ed d\u1ee5: Th\u00f4ng t\u01b0 m\u1edbi), k\u1ebf to\u00e1n ph\u1ea3i t\u1ef1 tay c\u1eadp nh\u1eadt l\u1ea1i to\u00e0n b\u1ed9 m\u1eabu b\u00e1o c\u00e1o, l\u00e0m t\u0103ng kh\u1ed1i l\u01b0\u1ee3ng c\u00f4ng vi\u1ec7c v\u00e0 r\u1ee7i ro kh\u00f4ng tu\u00e2n th\u1ee7 ph\u00e1p lu\u1eadt.<\/li>\n<li><strong>N\u0103ng su\u1ea5t kh\u00f4ng cao:<\/strong> Qu\u00e1 tr\u00ecnh t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u ngu\u1ed3n (h\u00f3a \u0111\u01a1n, sao k\u00ea, b\u1ea3ng l\u01b0\u01a1ng) v\u00e0o m\u1ed9t file Excel duy nh\u1ea5t t\u1ed1n nhi\u1ec1u th\u1eddi gian, d\u1ec5 g\u00e2y ra t\u00ecnh tr\u1ea1ng qu\u00e1 t\u1ea3i. \u0110\u00e2y l\u00e0 n\u00fat th\u1eaft l\u1edbn nh\u1ea5t m\u00e0 c\u00e1c gi\u1ea3i ph\u00e1p <strong><a href=\"https:\/\/bizzi.vn\/quan-ly-chi-phi-la-gi-cach-quan-ly-chi-phi-doanh-nghiep\/\">qu\u1ea3n l\u00fd chi ph\u00ed doanh nghi\u1ec7p<\/a><\/strong> hi\u1ec7n \u0111\u1ea1i c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft tri\u1ec7t \u0111\u1ec3 b\u1eb1ng c\u00e1ch t\u1ef1 \u0111\u1ed9ng h\u00f3a thu th\u1eadp d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cac_Loai_Bao_Cao_Tai_Chinh_Bat_Buoc_Theo_Quy_Dinh_Thong_tu_2002014TT-BTC\"><\/span>C\u00e1c Lo\u1ea1i B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh B\u1eaft Bu\u1ed9c Theo Quy \u0110\u1ecbnh (Th\u00f4ng t\u01b0 200\/2014\/TT-BTC)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t b\u1ed9 b\u00e1o c\u00e1o t\u00e0i ch\u00ednh \u0111\u1ea7y \u0111\u1ee7 theo quy \u0111\u1ecbnh c\u1ee7a ph\u00e1p lu\u1eadt Vi\u1ec7t Nam ph\u1ea3i bao g\u1ed3m b\u1ed1n th\u00e0nh ph\u1ea7n ch\u00ednh, c\u00f3 m\u1ed1i li\u00ean k\u1ebft ch\u1eb7t ch\u1ebd v\u1edbi nhau.<\/p>\n<ol>\n<li><strong>B\u1ea3ng c\u00e2n \u0111\u1ed1i k\u1ebf to\u00e1n (Balance Sheet):<\/strong> Ph\u1ea3n \u00e1nh t\u1ed5ng t\u00e0i s\u1ea3n, n\u1ee3 ph\u1ea3i tr\u1ea3 v\u00e0 v\u1ed1n ch\u1ee7 s\u1edf h\u1eefu t\u1ea1i m\u1ed9t th\u1eddi \u0111i\u1ec3m nh\u1ea5t \u0111\u1ecbnh, tu\u00e2n th\u1ee7 ph\u01b0\u01a1ng tr\u00ecnh k\u1ebf to\u00e1n c\u01a1 b\u1ea3n: <strong>T\u00e0i s\u1ea3n = N\u1ee3 ph\u1ea3i tr\u1ea3 + V\u1ed1n ch\u1ee7 s\u1edf h\u1eefu<\/strong>.<\/li>\n<li><strong>B\u00e1o c\u00e1o k\u1ebft qu\u1ea3 ho\u1ea1t \u0111\u1ed9ng kinh doanh (Income Statement):<\/strong> T\u1ed5ng h\u1ee3p doanh thu, chi ph\u00ed v\u00e0 l\u1ee3i nhu\u1eadn (ho\u1eb7c l\u1ed7) c\u1ee7a doanh nghi\u1ec7p trong m\u1ed9t k\u1ef3 k\u1ebf to\u00e1n. Vi\u1ec7c ghi nh\u1eadn ch\u00ednh x\u00e1c c\u00e1c kho\u1ea3n chi ph\u00ed n\u00e0y l\u00e0 c\u1ef1c k\u1ef3 quan tr\u1ecdng, v\u00ec n\u00f3 \u1ea3nh h\u01b0\u1edfng tr\u1ef1c ti\u1ebfp \u0111\u1ebfn l\u1ee3i nhu\u1eadn v\u00e0 th\u01b0\u1eddng l\u00e0 n\u01a1i ph\u00e1t sinh sai s\u00f3t khi x\u1eed l\u00fd h\u00f3a \u0111\u01a1n th\u1ee7 c\u00f4ng.<\/li>\n<li><strong><a href=\"https:\/\/bizzi.vn\/bao-cao-luu-chuyen-tien-te-la-gi\/\">B\u00e1o c\u00e1o l\u01b0u chuy\u1ec3n ti\u1ec1n t\u1ec7<\/a> (Cash Flow Statement):<\/strong> Cung c\u1ea5p th\u00f4ng tin v\u1ec1 c\u00e1c d\u00f2ng ti\u1ec1n v\u00e0o v\u00e0 ra, \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i theo ba ho\u1ea1t \u0111\u1ed9ng ch\u00ednh: kinh doanh, \u0111\u1ea7u t\u01b0 v\u00e0 t\u00e0i ch\u00ednh.<\/li>\n<li><strong>Thuy\u1ebft minh b\u00e1o c\u00e1o t\u00e0i ch\u00ednh (Notes to the Financial Statements):<\/strong> Gi\u1ea3i th\u00edch chi ti\u1ebft c\u00e1c s\u1ed1 li\u1ec7u v\u00e0 ch\u00ednh s\u00e1ch k\u1ebf to\u00e1n \u0111\u00e3 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong ba b\u00e1o c\u00e1o tr\u00ean, gi\u00fap ng\u01b0\u1eddi \u0111\u1ecdc hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 b\u1ed1i c\u1ea3nh t\u00e0i ch\u00ednh c\u1ee7a doanh nghi\u1ec7p.<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Chuan_Bi_Gi_Truoc_Khi_Thuc_Hien_Cach_Lap_Bao_Cao_Tai_Chinh_Excel\"><\/span>Chu\u1ea9n B\u1ecb G\u00ec Tr\u01b0\u1edbc Khi Th\u1ef1c Hi\u1ec7n <strong>C\u00e1ch L\u1eadp B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh Excel<\/strong>?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 \u0111\u1ea3m b\u1ea3o \u0111\u1ed9 ch\u00ednh x\u00e1c, giai \u0111o\u1ea1n chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u l\u00e0 b\u01b0\u1edbc quan tr\u1ecdng nh\u1ea5t, quy\u1ebft \u0111\u1ecbnh ch\u1ea5t l\u01b0\u1ee3ng c\u1ee7a to\u00e0n b\u1ed9 b\u00e1o c\u00e1o.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Thu_thap_va_he_thong_hoa_du_lieu_ke_toan\"><\/span>1. Thu th\u1eadp v\u00e0 h\u1ec7 th\u1ed1ng h\u00f3a d\u1eef li\u1ec7u k\u1ebf to\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1eadp h\u1ee3p to\u00e0n b\u1ed9 ch\u1ee9ng t\u1eeb, s\u1ed5 s\u00e1ch ph\u00e1t sinh trong k\u1ef3, bao g\u1ed3m: S\u1ed5 nh\u1eadt k\u00fd chung, S\u1ed5 c\u00e1i c\u00e1c t\u00e0i kho\u1ea3n, B\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh, B\u1ea3ng k\u00ea h\u00f3a \u0111\u01a1n, B\u1ea3ng l\u01b0\u01a1ng v\u00e0 c\u00e1c h\u1ee3p \u0111\u1ed3ng li\u00ean quan. Qu\u00e1 tr\u00ecnh n\u00e0y, \u0111\u1eb7c bi\u1ec7t l\u00e0 vi\u1ec7c t\u1ed5ng h\u1ee3p h\u00f3a \u0111\u01a1n, l\u00e0 n\u01a1i r\u1ee7i ro sai s\u00f3t cao nh\u1ea5t. Do \u0111\u00f3, vi\u1ec7c \u00e1p d\u1ee5ng c\u00f4ng ngh\u1ec7 \u0111\u1ec3 <strong><a href=\"https:\/\/bizzi.vn\/xu-ly-hoa-don\/\">t\u1ef1 \u0111\u1ed9ng h\u00f3a x\u1eed l\u00fd h\u00f3a \u0111\u01a1n \u0111\u1ea7u v\u00e0o<\/a><\/strong> kh\u00f4ng ch\u1ec9 gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 c\u00f2n \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u g\u1ed1c lu\u00f4n ch\u00ednh x\u00e1c tr\u01b0\u1edbc khi \u0111\u01b0a l\u00ean Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Kiem_tra_va_doi_chieu_so_du_dau_ky\"><\/span>2. Ki\u1ec3m tra v\u00e0 \u0111\u1ed1i chi\u1ebfu s\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ed1i chi\u1ebfu s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 c\u1ee7a b\u00e1o c\u00e1o t\u00e0i ch\u00ednh k\u1ef3 tr\u01b0\u1edbc v\u1edbi s\u1ed1 d\u01b0 \u0111\u1ea7u k\u1ef3 tr\u00ean s\u1ed5 s\u00e1ch c\u1ee7a k\u1ef3 hi\u1ec7n t\u1ea1i. B\u1ea5t k\u1ef3 ch\u00eanh l\u1ec7ch n\u00e0o c\u0169ng ph\u1ea3i \u0111\u01b0\u1ee3c t\u00ecm ra nguy\u00ean nh\u00e2n v\u00e0 \u0111i\u1ec1u ch\u1ec9nh ngay l\u1eadp t\u1ee9c \u0111\u1ec3 tr\u00e1nh sai s\u00f3t l\u0169y k\u1ebf.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_Dan_Cach_Lap_Bao_Cao_Tai_Chinh_Excel_Step-by-Step\"><\/span>H\u01b0\u1edbng D\u1eabn <strong>C\u00e1ch L\u1eadp B\u00e1o C\u00e1o T\u00e0i Ch\u00ednh Excel<\/strong> [Step-by-Step]<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft k\u00e8m v\u00ed d\u1ee5 s\u1ed1 li\u1ec7u c\u1ee5 th\u1ec3 \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c h\u00e0nh ngay.<\/p>\n<p><strong>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 B\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh cu\u1ed1i k\u1ef3 nh\u01b0 sau:<\/strong><\/p>\n<\/article>\n<table style=\"border-collapse: collapse; width: 99.7732%; height: 231px;\">\n<tbody>\n<tr style=\"height: 23px;\">\n<th style=\"padding: 8px; text-align: left; height: 23px; width: 13.0682%;\">S\u1ed1 TK<\/th>\n<th style=\"padding: 8px; text-align: left; height: 23px; width: 43.6364%;\">T\u00ean T\u00e0i Kho\u1ea3n<\/th>\n<th style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">S\u1ed1 D\u01b0 Cu\u1ed1i K\u1ef3 (VND)<\/th>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"padding: 8px; height: 23px; width: 13.0682%;\">111<\/td>\n<td style=\"height: 23px; width: 43.6364%;\">Ti\u1ec1n m\u1eb7t<\/td>\n<td style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">50,000,000<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"padding: 8px; height: 23px; width: 13.0682%;\">156<\/td>\n<td style=\"height: 23px; width: 43.6364%;\">H\u00e0ng t\u1ed3n kho<\/td>\n<td style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">150,000,000<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"padding: 8px; height: 23px; width: 13.0682%;\">211<\/td>\n<td style=\"height: 23px; width: 43.6364%;\">TSC\u0110 h\u1eefu h\u00ecnh<\/td>\n<td style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">300,000,000<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"padding: 8px; height: 23px; width: 13.0682%;\">214<\/td>\n<td style=\"height: 23px; width: 43.6364%;\">Hao m\u00f2n TSC\u0110<\/td>\n<td style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">(60,000,000)<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"padding: 8px; height: 23px; width: 13.0682%;\">331<\/td>\n<td style=\"height: 23px; width: 43.6364%;\">Ph\u1ea3i tr\u1ea3 ng\u01b0\u1eddi b\u00e1n<\/td>\n<td style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">80,000,000<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"padding: 8px; height: 23px; width: 13.0682%;\">411<\/td>\n<td style=\"height: 23px; width: 43.6364%;\">V\u1ed1n \u0111\u1ea7u t\u01b0 c\u1ee7a CSH<\/td>\n<td style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">350,000,000<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"padding: 8px; height: 23px; width: 13.0682%;\">421<\/td>\n<td style=\"height: 23px; width: 43.6364%;\">L\u1ee3i nhu\u1eadn sau thu\u1ebf ch\u01b0a PP<\/td>\n<td style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">[S\u1ebd t\u00ednh t\u1eeb B\u00e1o c\u00e1o KQKD]<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"padding: 8px; height: 23px; width: 13.0682%;\">511<\/td>\n<td style=\"height: 23px; width: 43.6364%;\">Doanh thu b\u00e1n h\u00e0ng<\/td>\n<td style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">500,000,000<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"padding: 8px; height: 23px; width: 13.0682%;\">632<\/td>\n<td style=\"height: 23px; width: 43.6364%;\">Gi\u00e1 v\u1ed1n h\u00e0ng b\u00e1n<\/td>\n<td style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">300,000,000<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"padding: 8px; height: 23px; width: 13.0682%;\">642<\/td>\n<td style=\"height: 23px; width: 43.6364%;\">Chi ph\u00ed qu\u1ea3n l\u00fd doanh nghi\u1ec7p<\/td>\n<td style=\"padding: 8px; text-align: right; height: 23px; width: 43.1818%;\">70,000,000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<article>\n<h3><span class=\"ez-toc-section\" id=\"1_Lap_Bao_cao_ket_qua_hoat_dong_kinh_doanh\"><\/span>1. L\u1eadp B\u00e1o c\u00e1o k\u1ebft qu\u1ea3 ho\u1ea1t \u0111\u1ed9ng kinh doanh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1eaft \u0111\u1ea7u v\u1edbi b\u00e1o c\u00e1o n\u00e0y \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh l\u1ee3i nhu\u1eadn, sau \u0111\u00f3 chuy\u1ec3n s\u1ed1 li\u1ec7u n\u00e0y sang B\u1ea3ng c\u00e2n \u0111\u1ed1i k\u1ebf to\u00e1n. Vi\u1ec7c t\u1ed5ng h\u1ee3p c\u00e1c chi ph\u00ed nh\u01b0 chi ph\u00ed qu\u1ea3n l\u00fd (TK 642) s\u1ebd ch\u00ednh x\u00e1c h\u01a1n nhi\u1ec1u n\u1ebfu doanh nghi\u1ec7p c\u00f3 m\u1ed9t h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd chi ti\u00eau t\u1ef1 \u0111\u1ed9ng, thay v\u00ec c\u1ed9ng d\u1ed3n t\u1eeb c\u00e1c file l\u1ebb.<\/p>\n<\/article>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr style=\"height: 23px;\">\n<th style=\"padding: 8px; text-align: left; height: 23px; width: 34.9206%;\">Ch\u1ec9 ti\u00eau<\/th>\n<th style=\"padding: 8px; text-align: left; height: 23px; width: 47.5057%;\">C\u00f4ng th\u1ee9c Excel (V\u00ed d\u1ee5)<\/th>\n<th style=\"padding: 8px; text-align: right; height: 23px; width: 17.4603%;\">Gi\u00e1 tr\u1ecb (VND)<\/th>\n<\/tr>\n<tr style=\"height: 37px;\">\n<td style=\"height: 37px; width: 34.9206%;\">Doanh thu thu\u1ea7n<\/td>\n<td style=\"height: 37px; width: 47.5057%;\"><code>=VLOOKUP(\"511\", BCDPS!A:C, 3, FALSE)<\/code><\/td>\n<td style=\"padding: 8px; text-align: right; height: 37px; width: 17.4603%;\">500,000,000<\/td>\n<\/tr>\n<tr style=\"height: 37px;\">\n<td style=\"height: 37px; width: 34.9206%;\">Gi\u00e1 v\u1ed1n h\u00e0ng b\u00e1n<\/td>\n<td style=\"height: 37px; width: 47.5057%;\"><code>=VLOOKUP(\"632\", BCDPS!A:C, 3, FALSE)<\/code><\/td>\n<td style=\"padding: 8px; text-align: right; height: 37px; width: 17.4603%;\">(300,000,000)<\/td>\n<\/tr>\n<tr style=\"height: 37px;\">\n<td style=\"height: 37px; width: 34.9206%;\"><strong>L\u1ee3i nhu\u1eadn g\u1ed9p<\/strong><\/td>\n<td style=\"height: 37px; width: 47.5057%;\"><code>=C2-C3<\/code><\/td>\n<td style=\"padding: 8px; text-align: right; height: 37px; width: 17.4603%;\"><strong>200,000,000<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 37px;\">\n<td style=\"height: 37px; width: 34.9206%;\">Chi ph\u00ed qu\u1ea3n l\u00fd doanh nghi\u1ec7p<\/td>\n<td style=\"height: 37px; width: 47.5057%;\"><code>=VLOOKUP(\"642\", BCDPS!A:C, 3, FALSE)<\/code><\/td>\n<td style=\"padding: 8px; text-align: right; height: 37px; width: 17.4603%;\">(70,000,000)<\/td>\n<\/tr>\n<tr style=\"height: 37px;\">\n<td style=\"height: 37px; width: 34.9206%;\"><strong>L\u1ee3i nhu\u1eadn tr\u01b0\u1edbc thu\u1ebf<\/strong><\/td>\n<td style=\"height: 37px; width: 47.5057%;\"><code>=C4-C5<\/code><\/td>\n<td style=\"padding: 8px; text-align: right; height: 37px; width: 17.4603%;\"><strong>130,000,000<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 37px;\">\n<td style=\"height: 37px; width: 34.9206%;\">Chi ph\u00ed thu\u1ebf TNDN (gi\u1ea3 s\u1eed 20%)<\/td>\n<td style=\"height: 37px; width: 47.5057%;\"><code>=C6*0.2<\/code><\/td>\n<td style=\"padding: 8px; text-align: right; height: 37px; width: 17.4603%;\">(26,000,000)<\/td>\n<\/tr>\n<tr style=\"height: 37px;\">\n<td style=\"height: 37px; width: 34.9206%;\"><strong>L\u1ee3i nhu\u1eadn sau thu\u1ebf (LNST)<\/strong><\/td>\n<td style=\"height: 37px; width: 47.5057%;\"><code>=C6-C7<\/code><\/td>\n<td style=\"padding: 8px; text-align: right; height: 37px; width: 17.4603%;\"><strong>104,000,000<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<article><em>L\u01b0u \u00fd: S\u1ed1 l\u1ee3i nhu\u1eadn sau thu\u1ebf <strong>104,000,000 VND<\/strong> s\u1ebd \u0111\u01b0\u1ee3c \u0111i\u1ec1n v\u00e0o ch\u1ec9 ti\u00eau &#8220;L\u1ee3i nhu\u1eadn sau thu\u1ebf ch\u01b0a ph\u00e2n ph\u1ed1i&#8221; (TK 421) tr\u00ean B\u1ea3ng c\u00e2n \u0111\u1ed1i k\u1ebf to\u00e1n.<\/em><\/p>\n<figure id=\"attachment_999978285\" aria-describedby=\"caption-attachment-999978285\" style=\"width: 894px\" class=\"wp-caption aligncenter\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-999978285 size-full\" title=\"C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh Excel s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIF v\u00e0 VLOOKUP \" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-5.jpg\" alt=\"C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh Excel s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIF v\u00e0 VLOOKUP \" width=\"894\" height=\"450\" srcset=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-5.jpg 894w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-5-300x151.jpg 300w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-5-768x387.jpg 768w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-5-18x9.jpg 18w\" sizes=\"(max-width: 894px) 100vw, 894px\" \/><figcaption id=\"caption-attachment-999978285\" class=\"wp-caption-text\">C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh Excel s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c SUMIF v\u00e0 VLOOKUP<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"2_Lap_Bang_can_doi_ke_toan\"><\/span>2. L\u1eadp B\u1ea3ng c\u00e2n \u0111\u1ed1i k\u1ebf to\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1eadp h\u1ee3p s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 c\u1ee7a c\u00e1c t\u00e0i kho\u1ea3n t\u1eeb lo\u1ea1i 1 \u0111\u1ebfn lo\u1ea1i 4, \u0111\u1ea3m b\u1ea3o t\u1ed5ng t\u00e0i s\u1ea3n b\u1eb1ng t\u1ed5ng ngu\u1ed3n v\u1ed1n.<\/p>\n<\/article>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<th style=\"padding: 8px; text-align: left; width: 26.9841%;\">T\u00c0I S\u1ea2N<\/th>\n<th style=\"padding: 8px; text-align: right; width: 19.161%;\">Gi\u00e1 tr\u1ecb (VND)<\/th>\n<th style=\"padding: 8px; text-align: left; width: 34.4671%;\">NGU\u1ed2N V\u1ed0N<\/th>\n<th style=\"padding: 8px; text-align: right; width: 19.161%;\">Gi\u00e1 tr\u1ecb (VND)<\/th>\n<\/tr>\n<tr>\n<td style=\"width: 26.9841%;\">Ti\u1ec1n m\u1eb7t (111)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 19.161%;\">50,000,000<\/td>\n<td style=\"width: 34.4671%;\"><strong>N\u1ee2 PH\u1ea2I TR\u1ea2<\/strong><\/td>\n<td style=\"width: 19.161%;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 26.9841%;\">H\u00e0ng t\u1ed3n kho (156)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 19.161%;\">150,000,000<\/td>\n<td style=\"width: 34.4671%;\">Ph\u1ea3i tr\u1ea3 ng\u01b0\u1eddi b\u00e1n (331)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 19.161%;\">80,000,000<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 26.9841%;\">TSC\u0110 h\u1eefu h\u00ecnh (211)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 19.161%;\">300,000,000<\/td>\n<td style=\"width: 34.4671%;\"><strong>T\u1ed4NG N\u1ee2 PH\u1ea2I TR\u1ea2<\/strong><\/td>\n<td style=\"padding: 8px; text-align: right; width: 19.161%;\"><strong>80,000,000<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 26.9841%;\">Hao m\u00f2n TSC\u0110 (214)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 19.161%;\">(60,000,000)<\/td>\n<td style=\"width: 34.4671%;\"><strong>V\u1ed0N CH\u1ee6 S\u1ede H\u1eeeU<\/strong><\/td>\n<td style=\"width: 19.161%;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 26.9841%;\"><\/td>\n<td style=\"width: 19.161%;\"><\/td>\n<td style=\"width: 34.4671%;\">V\u1ed1n \u0111\u1ea7u t\u01b0 c\u1ee7a CSH (411)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 19.161%;\">350,000,000<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 26.9841%;\"><\/td>\n<td style=\"width: 19.161%;\"><\/td>\n<td style=\"width: 34.4671%;\">LNST ch\u01b0a ph\u00e2n ph\u1ed1i (421)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 19.161%;\">104,000,000<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 26.9841%;\"><\/td>\n<td style=\"width: 19.161%;\"><\/td>\n<td style=\"width: 34.4671%;\"><strong>T\u1ed4NG V\u1ed0N CH\u1ee6 S\u1ede H\u1eeeU<\/strong><\/td>\n<td style=\"padding: 8px; text-align: right; width: 19.161%;\"><strong>454,000,000<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: bold; width: 26.9841%;\">T\u1ed4NG T\u00c0I S\u1ea2N<\/td>\n<td style=\"padding: 8px; text-align: right; font-weight: bold; width: 19.161%;\">434,000,000<\/td>\n<td style=\"font-weight: bold; width: 34.4671%;\">T\u1ed4NG NGU\u1ed2N V\u1ed0N<\/td>\n<td style=\"padding: 8px; text-align: right; font-weight: bold; width: 19.161%;\">534,000,000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<article><em>(<strong>T\u1ed5ng T\u00e0i S\u1ea3n (440,000,000) kh\u00f4ng b\u1eb1ng T\u1ed5ng Ngu\u1ed3n V\u1ed1n (534,000,000)<\/strong>. \u0110\u00e2y ch\u00ednh l\u00e0 m\u1ed9t r\u1ee7i ro \u0111i\u1ec3n h\u00ecnh khi l\u00e0m th\u1ee7 c\u00f4ng. Ch\u00fang ta c\u1ea7n ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c v\u00e0 s\u1ed1 li\u1ec7u.)<\/em><strong>Correction:<\/strong> Gi\u00e1 tr\u1ecb TSC\u0110 ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i (Nguy\u00ean gi\u00e1 &#8211; Hao m\u00f2n) = 300,000,000 &#8211; 60,000,000 = 240,000,000. C\u1eadp nh\u1eadt l\u1ea1i b\u1ea3ng:<\/article>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<th style=\"padding: 8px; text-align: left; width: 33.6735%;\">T\u00c0I S\u1ea2N<\/th>\n<th style=\"padding: 8px; text-align: right; width: 17.4603%;\">Gi\u00e1 tr\u1ecb (VND)<\/th>\n<th style=\"padding: 8px; text-align: left; width: 31.2925%;\">NGU\u1ed2N V\u1ed0N<\/th>\n<th style=\"padding: 8px; text-align: right; width: 17.4603%;\">Gi\u00e1 tr\u1ecb (VND)<\/th>\n<\/tr>\n<tr>\n<td style=\"width: 33.6735%;\">Ti\u1ec1n v\u00e0 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng ti\u1ec1n<\/td>\n<td style=\"padding: 8px; text-align: right; width: 17.4603%;\">50,000,000<\/td>\n<td style=\"width: 31.2925%;\"><strong>N\u1ee2 PH\u1ea2I TR\u1ea2<\/strong><\/td>\n<td style=\"width: 17.4603%;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.6735%;\">H\u00e0ng t\u1ed3n kho<\/td>\n<td style=\"padding: 8px; text-align: right; width: 17.4603%;\">150,000,000<\/td>\n<td style=\"width: 31.2925%;\">Ph\u1ea3i tr\u1ea3 ng\u01b0\u1eddi b\u00e1n (331)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 17.4603%;\">80,000,000<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.6735%;\">T\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh (gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 17.4603%;\">240,000,000<\/td>\n<td style=\"width: 31.2925%;\"><strong>T\u1ed4NG N\u1ee2 PH\u1ea2I TR\u1ea2<\/strong><\/td>\n<td style=\"padding: 8px; text-align: right; width: 17.4603%;\"><strong>80,000,000<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.6735%;\"><\/td>\n<td style=\"width: 17.4603%;\"><\/td>\n<td style=\"width: 31.2925%;\"><strong>V\u1ed0N CH\u1ee6 S\u1ede H\u1eeeU<\/strong><\/td>\n<td style=\"width: 17.4603%;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.6735%;\"><\/td>\n<td style=\"width: 17.4603%;\"><\/td>\n<td style=\"width: 31.2925%;\">V\u1ed1n \u0111\u1ea7u t\u01b0 c\u1ee7a CSH (411)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 17.4603%;\">350,000,000<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.6735%;\"><\/td>\n<td style=\"width: 17.4603%;\"><\/td>\n<td style=\"width: 31.2925%;\">LNST ch\u01b0a ph\u00e2n ph\u1ed1i (421)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 17.4603%;\">104,000,000<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.6735%;\"><\/td>\n<td style=\"width: 17.4603%;\"><\/td>\n<td style=\"width: 31.2925%;\"><strong>T\u1ed4NG V\u1ed0N CH\u1ee6 S\u1ede H\u1eeeU<\/strong><\/td>\n<td style=\"padding: 8px; text-align: right; width: 17.4603%;\">454,000,00<strong>0<\/strong><\/td>\n<\/tr>\n<tr style=\"background-color: #e0f2f1;\">\n<td style=\"font-weight: bold; padding: 8px; width: 33.6735%;\">T\u1ed4NG T\u00c0I S\u1ea2N<\/td>\n<td style=\"padding: 8px; text-align: right; font-weight: bold; width: 17.4603%;\">440,000,000<\/td>\n<td style=\"font-weight: bold; padding: 8px; width: 31.2925%;\">T\u1ed4NG NGU\u1ed2N V\u1ed0N<\/td>\n<td style=\"padding: 8px; text-align: right; font-weight: bold; width: 17.4603%;\">534,000,000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<article><em>(V\u1eabn sai! T\u1ed5ng T\u00e0i S\u1ea3n 440tr v\u00e0 T\u1ed5ng Ngu\u1ed3n V\u1ed1n 534tr. \u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 th\u1ef1c t\u1ebf v\u1ec1 vi\u1ec7c d\u00f2 l\u1ed7i. Quay l\u1ea1i ki\u1ec3m tra B\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh.)<\/em><\/p>\n<blockquote><p>Ghi ch\u00fa: V\u00ed d\u1ee5 tr\u00ean c\u1ed1 \u00fd t\u1ea1o ra l\u1ed7i \u0111\u1ec3 minh h\u1ecda cho m\u1ed9t trong nh\u1eefng kh\u00f3 kh\u0103n l\u1edbn nh\u1ea5t c\u1ee7a <strong>c\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh Excel<\/strong>: d\u00f2 t\u00ecm v\u00e0 s\u1eeda l\u1ed7i. Trong th\u1ef1c t\u1ebf, b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o B\u1ea3ng c\u00e2n \u0111\u1ed1i ph\u00e1t sinh \u0111\u00e3 c\u00e2n b\u1eb1ng tr\u01b0\u1edbc khi l\u00ean b\u00e1o c\u00e1o.<\/p><\/blockquote>\n<figure id=\"attachment_999978282\" aria-describedby=\"caption-attachment-999978282\" style=\"width: 957px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"wp-image-999978282 size-full\" title=\"M\u1eabu b\u1ea3ng c\u00e2n \u0111\u1ed1i k\u1ebf to\u00e1n tr\u00ean Excel v\u1edbi c\u1ed9t T\u00e0i s\u1ea3n \u2013 Ngu\u1ed3n v\u1ed1n\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-1.png\" alt=\"M\u1eabu b\u1ea3ng c\u00e2n \u0111\u1ed1i k\u1ebf to\u00e1n tr\u00ean Excel v\u1edbi c\u1ed9t T\u00e0i s\u1ea3n \u2013 Ngu\u1ed3n v\u1ed1n\" width=\"957\" height=\"603\" srcset=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-1.png 957w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-1-300x189.png 300w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-1-768x484.png 768w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-1-18x12.png 18w\" sizes=\"(max-width: 957px) 100vw, 957px\" \/><figcaption id=\"caption-attachment-999978282\" class=\"wp-caption-text\">M\u1eabu b\u1ea3ng c\u00e2n \u0111\u1ed1i k\u1ebf to\u00e1n tr\u00ean Excel v\u1edbi c\u1ed9t T\u00e0i s\u1ea3n \u2013 Ngu\u1ed3n v\u1ed1n<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"3_Lap_Bao_cao_luu_chuyen_tien_te_Phuong_phap_gian_tiep\"><\/span>3. L\u1eadp B\u00e1o c\u00e1o l\u01b0u chuy\u1ec3n ti\u1ec1n t\u1ec7 (Ph\u01b0\u01a1ng ph\u00e1p gi\u00e1n ti\u1ebfp)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u00e1o c\u00e1o n\u00e0y b\u1eaft \u0111\u1ea7u t\u1eeb l\u1ee3i nhu\u1eadn tr\u01b0\u1edbc thu\u1ebf v\u00e0 \u0111i\u1ec1u ch\u1ec9nh cho c\u00e1c kho\u1ea3n thu\/chi kh\u00f4ng b\u1eb1ng ti\u1ec1n.<\/p>\n<\/article>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<th style=\"padding: 8px; text-align: left; width: 74.7166%;\">N\u1ed9i dung<\/th>\n<th style=\"padding: 8px; text-align: right; width: 25.0567%;\">Gi\u00e1 tr\u1ecb (VND)<\/th>\n<\/tr>\n<tr>\n<td style=\"width: 74.7166%;\">L\u1ee3i nhu\u1eadn tr\u01b0\u1edbc thu\u1ebf<\/td>\n<td style=\"padding: 8px; text-align: right; width: 25.0567%;\">130,000,000<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 74.7166%;\"><strong>\u0110i\u1ec1u ch\u1ec9nh cho c\u00e1c kho\u1ea3n:<\/strong><\/td>\n<td style=\"width: 25.0567%;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 74.7166%;\">+ Kh\u1ea5u hao TSC\u0110<\/td>\n<td style=\"padding: 8px; text-align: right; width: 25.0567%;\">60,000,000<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 74.7166%;\">\u00b1 Thay \u0111\u1ed5i c\u00e1c kho\u1ea3n ph\u1ea3i thu\/ph\u1ea3i tr\u1ea3 (gi\u1ea3 s\u1eed)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 25.0567%;\">(20,000,000)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 74.7166%;\"><strong>= L\u01b0u chuy\u1ec3n ti\u1ec1n thu\u1ea7n t\u1eeb H\u0110KD<\/strong><\/td>\n<td style=\"padding: 8px; text-align: right; width: 25.0567%;\"><strong>170,000,000<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 74.7166%;\">Ti\u1ec1n chi mua s\u1eafm TSC\u0110 (Ho\u1ea1t \u0111\u1ed9ng \u0111\u1ea7u t\u01b0)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 25.0567%;\">(50,000,000)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 74.7166%;\">Ti\u1ec1n thu t\u1eeb \u0111i vay (Ho\u1ea1t \u0111\u1ed9ng t\u00e0i ch\u00ednh)<\/td>\n<td style=\"padding: 8px; text-align: right; width: 25.0567%;\">100,000,000<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 74.7166%;\"><strong>= T\u0103ng\/gi\u1ea3m ti\u1ec1n thu\u1ea7n trong k\u1ef3<\/strong><\/td>\n<td style=\"padding: 8px; text-align: right; width: 25.0567%;\"><strong>220,000,000<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<article>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_Loi_Thuong_Gap_Khi_Lap_BCTC_Tren_Excel_va_Cach_Khac_Phuc\"><\/span>Nh\u1eefng L\u1ed7i Th\u01b0\u1eddng G\u1eb7p Khi L\u1eadp BCTC Tr\u00ean Excel v\u00e0 C\u00e1ch Kh\u1eafc Ph\u1ee5c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li><strong>L\u1ed7i #REF! ho\u1eb7c #N\/A:<\/strong> Th\u01b0\u1eddng x\u1ea3y ra khi c\u00f4ng th\u1ee9c VLOOKUP, INDEX-MATCH kh\u00f4ng t\u00ecm th\u1ea5y d\u1eef li\u1ec7u ho\u1eb7c \u00f4 tham chi\u1ebfu \u0111\u00e3 b\u1ecb x\u00f3a. -&gt; <em>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/em> Ki\u1ec3m tra l\u1ea1i v\u00f9ng d\u1eef li\u1ec7u tham chi\u1ebfu v\u00e0 m\u00e3 t\u00e0i kho\u1ea3n t\u00ecm ki\u1ebfm. S\u1eed d\u1ee5ng h\u00e0m IFERROR \u0111\u1ec3 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 0 thay v\u00ec l\u1ed7i.<\/li>\n<li><strong>B\u1ea3ng c\u00e2n \u0111\u1ed1i k\u1ebf to\u00e1n kh\u00f4ng c\u00e2n:<\/strong> T\u1ed5ng t\u00e0i s\u1ea3n \u2260 T\u1ed5ng ngu\u1ed3n v\u1ed1n. -&gt; <em>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/em> Ki\u1ec3m tra l\u1ea1i s\u1ed1 d\u01b0 cu\u1ed1i k\u1ef3 c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c t\u00e0i kho\u1ea3n, \u0111\u1ea3m b\u1ea3o \u0111\u00e3 l\u1ea5y \u0111\u1ee7 s\u1ed1 li\u1ec7u, ki\u1ec3m tra c\u00f4ng th\u1ee9c c\u1ed9ng t\u1ed5ng v\u00e0 ch\u1eafc ch\u1eafn r\u1eb1ng l\u1ee3i nhu\u1eadn sau thu\u1ebf \u0111\u00e3 \u0111\u01b0\u1ee3c k\u1ebft chuy\u1ec3n \u0111\u00fang.<\/li>\n<li><strong>Sai d\u1ea5u \u00c2m\/D\u01b0\u01a1ng:<\/strong> Ghi nh\u1ea7m gi\u00e1 tr\u1ecb chi ph\u00ed, hao m\u00f2n, ho\u1eb7c c\u00e1c kho\u1ea3n gi\u1ea3m tr\u1eeb th\u00e0nh s\u1ed1 d\u01b0\u01a1ng. -&gt; <em>C\u00e1ch kh\u1eafc ph\u1ee5c:<\/em> Lu\u00f4n tu\u00e2n th\u1ee7 quy t\u1eafc: Ngu\u1ed3n v\u1ed1n, Doanh thu c\u00f3 s\u1ed1 d\u01b0 b\u00ean C\u00f3 (d\u01b0\u01a1ng); T\u00e0i s\u1ea3n, Chi ph\u00ed c\u00f3 s\u1ed1 d\u01b0 b\u00ean N\u1ee3 (d\u01b0\u01a1ng). Khi l\u00ean b\u00e1o c\u00e1o, c\u00e1c kho\u1ea3n gi\u1ea3m tr\u1eeb (hao m\u00f2n, gi\u00e1 v\u1ed1n) ph\u1ea3i \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng s\u1ed1 \u00e2m ho\u1eb7c trong ngo\u1eb7c.<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Excel_vs_Phan_Mem_Ke_Toan_Khi_Nao_Doanh_Nghiep_Nen_Nang_Cap\"><\/span>Excel vs. Ph\u1ea7n M\u1ec1m K\u1ebf To\u00e1n: Khi N\u00e0o Doanh Nghi\u1ec7p N\u00ean N\u00e2ng C\u1ea5p?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel l\u00e0 c\u00f4ng c\u1ee5 tuy\u1ec7t v\u1eddi khi kh\u1edfi \u0111\u1ea7u, nh\u01b0ng s\u1ebd b\u1ed9c l\u1ed9 h\u1ea1n ch\u1ebf khi doanh nghi\u1ec7p ph\u00e1t tri\u1ec3n. H\u00e3y c\u00e2n nh\u1eafc n\u00e2ng c\u1ea5p l\u00ean c\u00e1c gi\u1ea3i ph\u00e1p t\u1ef1 \u0111\u1ed9ng h\u00f3a nh\u01b0 Bizzi khi b\u1ea1n g\u1eb7p ph\u1ea3i c\u00e1c d\u1ea5u hi\u1ec7u sau:<\/p>\n<ul>\n<li>S\u1ed1 l\u01b0\u1ee3ng giao d\u1ecbch v\u00e0 h\u00f3a \u0111\u01a1n chi ph\u00ed h\u00e0ng th\u00e1ng v\u01b0\u1ee3t qu\u00e1 200-300 ch\u1ee9ng t\u1eeb.<\/li>\n<li>M\u1ea5t h\u01a1n 2 ng\u00e0y l\u00e0m vi\u1ec7c ch\u1ec9 \u0111\u1ec3 \u0111\u1ed1i chi\u1ebfu v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u chi ph\u00ed t\u1eeb h\u00f3a \u0111\u01a1n.<\/li>\n<li>C\u1ea7n nhi\u1ec1u ng\u01b0\u1eddi c\u00f9ng truy c\u1eadp v\u00e0 ph\u00ea duy\u1ec7t c\u00e1c kho\u1ea3n chi.<\/li>\n<li>Th\u01b0\u1eddng xuy\u00ean x\u1ea3y ra sai s\u00f3t s\u1ed1 li\u1ec7u v\u00e0 t\u1ed1n nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 s\u1eeda l\u1ed7i.<\/li>\n<li>Y\u00eau c\u1ea7u c\u00e1c b\u00e1o c\u00e1o qu\u1ea3n tr\u1ecb chi ph\u00ed ph\u1ee9c t\u1ea1p, ph\u00e2n t\u00edch s\u00e2u theo th\u1eddi gian th\u1ef1c.<\/li>\n<\/ul>\n<figure id=\"attachment_999978284\" aria-describedby=\"caption-attachment-999978284\" style=\"width: 1200px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"wp-image-999978284\" title=\"Bizzi AI dashboard ki\u1ec3m so\u00e1t chi ph\u00ed v\u00e0 c\u00f4ng n\u1ee3 cho doanh nghi\u1ec7p\" src=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-3.png\" alt=\"Bizzi AI dashboard ki\u1ec3m so\u00e1t chi ph\u00ed v\u00e0 c\u00f4ng n\u1ee3 cho doanh nghi\u1ec7p\" width=\"1200\" height=\"723\" srcset=\"https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-3.png 2048w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-3-300x181.png 300w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-3-1024x617.png 1024w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-3-768x463.png 768w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-3-1536x926.png 1536w, https:\/\/bizzi.vn\/wp-content\/uploads\/2025\/09\/cach-lap-bao-cao-tai-chinh-excel-3-18x12.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><figcaption id=\"caption-attachment-999978284\" class=\"wp-caption-text\">Bizzi AI dashboard ki\u1ec3m so\u00e1t chi ph\u00ed v\u00e0 c\u00f4ng n\u1ee3 cho doanh nghi\u1ec7p<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cau_Hoi_Thuong_Gap_FAQ\"><\/span>C\u00e2u H\u1ecfi Th\u01b0\u1eddng G\u1eb7p (FAQ)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p data-start=\"148\" data-end=\"449\">\u0110\u1ec3 gi\u00fap k\u1ebf to\u00e1n vi\u00ean v\u00e0 ch\u1ee7 doanh nghi\u1ec7p d\u1ec5 d\u00e0ng h\u01a1n khi l\u1eadp <strong data-start=\"209\" data-end=\"241\">b\u00e1o c\u00e1o t\u00e0i ch\u00ednh tr\u00ean Excel<\/strong>, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng c\u00e2u h\u1ecfi ph\u1ed5 bi\u1ebfn nh\u1ea5t c\u00f9ng c\u00e2u tr\u1ea3 l\u1eddi chi ti\u1ebft. Ph\u1ea7n n\u00e0y s\u1ebd gi\u1ea3i \u0111\u00e1p nhanh nh\u1eefng v\u01b0\u1edbng m\u1eafc th\u01b0\u1eddng g\u1eb7p, t\u1eeb vi\u1ec7c ki\u1ec3m tra sai s\u00f3t, tu\u00e2n th\u1ee7 Th\u00f4ng t\u01b0 cho \u0111\u1ebfn l\u1ef1a ch\u1ecdn h\u00e0m Excel quan tr\u1ecdng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Lam_the_nao_de_kiem_tra_sai_sot_tren_BCTC_Excel_mot_cach_nhanh_nhat\"><\/span>1. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ki\u1ec3m tra sai s\u00f3t tr\u00ean BCTC Excel m\u1ed9t c\u00e1ch nhanh nh\u1ea5t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch nhanh nh\u1ea5t l\u00e0 s\u1eed d\u1ee5ng B\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh. H\u00e3y \u0111\u1ea3m b\u1ea3o T\u1ed5ng s\u1ed1 ph\u00e1t sinh N\u1ee3 = T\u1ed5ng s\u1ed1 ph\u00e1t sinh C\u00f3 v\u00e0 T\u1ed5ng s\u1ed1 d\u01b0 N\u1ee3 cu\u1ed1i k\u1ef3 = T\u1ed5ng s\u1ed1 d\u01b0 C\u00f3 cu\u1ed1i k\u1ef3. N\u1ebfu b\u1ea3ng n\u00e0y \u0111\u00e3 c\u00e2n th\u00ec 90% b\u00e1o c\u00e1o c\u1ee7a b\u1ea1n s\u1ebd ch\u00ednh x\u00e1c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_File_Excel_BCTC_co_tuan_thu_theo_Thong_tu_200133_cua_Bo_Tai_chinh_khong\"><\/span>2. File Excel BCTC c\u00f3 tu\u00e2n th\u1ee7 theo Th\u00f4ng t\u01b0 200\/133 c\u1ee7a B\u1ed9 T\u00e0i ch\u00ednh kh\u00f4ng?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea3n th\u00e2n Excel ch\u1ec9 l\u00e0 c\u00f4ng c\u1ee5. Vi\u1ec7c file b\u00e1o c\u00e1o c\u00f3 tu\u00e2n th\u1ee7 hay kh\u00f4ng ph\u1ee5 thu\u1ed9c ho\u00e0n to\u00e0n v\u00e0o ng\u01b0\u1eddi l\u1eadp b\u00e1o c\u00e1o. B\u1ea1n ph\u1ea3i t\u1ef1 thi\u1ebft k\u1ebf m\u1eabu bi\u1ec3u v\u00e0 c\u00e1c ch\u1ec9 ti\u00eau theo \u0111\u00fang quy \u0111\u1ecbnh c\u1ee7a Th\u00f4ng t\u01b0 200\/2014\/TT-BTC ho\u1eb7c Th\u00f4ng t\u01b0 133\/2016\/TT-BTC. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o v\u0103n b\u1ea3n h\u1ee3p nh\u1ea5t t\u1ea1i website c\u1ee7a B\u1ed9 T\u00e0i ch\u00ednh \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o tu\u00e2n th\u1ee7.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Nen_su_dung_ham_Excel_nao_la_quan_trong_nhat_khi_lap_BCTC\"><\/span>3. N\u00ean s\u1eed d\u1ee5ng h\u00e0m Excel n\u00e0o l\u00e0 quan tr\u1ecdng nh\u1ea5t khi l\u1eadp BCTC?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ba h\u00e0m quan tr\u1ecdng nh\u1ea5t l\u00e0: SUMIF(S) \u0111\u1ec3 t\u1ed5ng h\u1ee3p s\u1ed1 li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n (v\u00ed d\u1ee5: t\u1ed5ng ph\u00e1t sinh c\u1ee7a m\u1ed9t t\u00e0i kho\u1ea3n), VLOOKUP ho\u1eb7c INDEX-MATCH \u0111\u1ec3 l\u1ea5y s\u1ed1 d\u01b0 t\u1eeb s\u1ed5 chi ti\u1ebft l\u00ean b\u1ea3ng t\u1ed5ng h\u1ee3p, v\u00e0 PIVOT TABLE \u0111\u1ec3 t\u1ea1o c\u00e1c b\u00e1o c\u00e1o ph\u00e2n t\u00edch nhanh.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_Luan\"><\/span>K\u1ebft Lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>C\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u00e0i ch\u00ednh Excel<\/strong> l\u00e0 m\u1ed9t gi\u1ea3i ph\u00e1p ti\u1ebft ki\u1ec7m v\u00e0 linh ho\u1ea1t cho nhi\u1ec1u doanh nghi\u1ec7p, nh\u01b0ng \u0111\u00f2i h\u1ecfi s\u1ef1 c\u1ea9n th\u1eadn v\u00e0 t\u1ed1n nhi\u1ec1u th\u1eddi gian, \u0111\u1eb7c bi\u1ec7t trong kh\u00e2u thu th\u1eadp d\u1eef li\u1ec7u chi ph\u00ed. Khi quy m\u00f4 doanh nghi\u1ec7p t\u0103ng l\u00ean, vi\u1ec7c chuy\u1ec3n \u0111\u1ed5i sang c\u00e1c gi\u1ea3i ph\u00e1p t\u1ef1 \u0111\u1ed9ng h\u00f3a \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o l\u00e0 m\u1ed9t b\u01b0\u1edbc ti\u1ebfn t\u1ea5t y\u1ebfu \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a hi\u1ec7u su\u1ea5t v\u00e0 gi\u1ea3m thi\u1ec3u r\u1ee7i ro.<\/p>\n<p>Bizzi cung c\u1ea5p m\u1ed9t n\u1ec1n t\u1ea3ng qu\u1ea3n l\u00fd t\u00e0i ch\u00ednh to\u00e0n di\u1ec7n, t\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh t\u1eeb x\u1eed l\u00fd h\u00f3a \u0111\u01a1n \u0111\u1ea7u v\u00e0o, qu\u1ea3n l\u00fd chi ph\u00ed \u0111\u1ebfn thu h\u1ed3i c\u00f4ng n\u1ee3. H\u1ec7 th\u1ed1ng c\u1ee7a ch\u00fang t\u00f4i kh\u00f4ng thay th\u1ebf ho\u00e0n to\u00e0n Excel, m\u00e0 t\u00edch h\u1ee3p \u0111\u1ec3 tr\u1edf th\u00e0nh ngu\u1ed3n d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o ch\u00ednh x\u00e1c v\u00e0 \u0111\u00e1ng tin c\u1eady, gi\u1ea3i ph\u00f3ng k\u1ebf to\u00e1n kh\u1ecfi c\u00e1c t\u00e1c v\u1ee5 th\u1ee7 c\u00f4ng v\u00e0 sai s\u00f3t, gi\u00fap h\u1ecd t\u1eadp trung v\u00e0o ph\u00e2n t\u00edch v\u00e0 t\u01b0 v\u1ea5n chi\u1ebfn l\u01b0\u1ee3c.<\/p>\n<p><strong>\u0110\u1ecdc th\u00eam:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/bizzi.vn\/giai-phap-tai-chinh-toan-dien-cho-doanh-nghiep-trong-boi-canh-hien-nay\/\">Gi\u1ea3i ph\u00e1p t\u00e0i ch\u00ednh to\u00e0n di\u1ec7n cho doanh nghi\u1ec7p SMEs<\/a><\/li>\n<li><a href=\"https:\/\/bizzi.vn\/bien-phap-quan-tri-dong-tien-hieu-qua\/#3_5_bien_phap_quan_tri_dong_tien_hieu_qua_cho_doanh_nghiep_2025\">5 gi\u1ea3i ph\u00e1p trong qu\u1ea3n l\u00fd d\u00f2ng ti\u1ec1n doanh nghi\u1ec7p<\/a><\/li>\n<\/ul>\n<\/article>\n","protected":false},"excerpt":{"rendered":"<p>How to prepare Excel financial reports is a fundamental skill for every accountant, especially in businesses\u2026<\/p>","protected":false},"author":56,"featured_media":999978281,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[263],"tags":[],"class_list":["post-999978269","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc"],"acf":[],"_links":{"self":[{"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts\/999978269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/users\/56"}],"replies":[{"embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/comments?post=999978269"}],"version-history":[{"count":5,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts\/999978269\/revisions"}],"predecessor-version":[{"id":999980608,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/posts\/999978269\/revisions\/999980608"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/media\/999978281"}],"wp:attachment":[{"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/media?parent=999978269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/categories?post=999978269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bizzi.vn\/en\/wp-json\/wp\/v2\/tags?post=999978269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}