{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["HD","HOME","Setup","DM","KE HOACH","THUC TE","BCTK","BC_30DAY","tam","BCTHU","BCCHI","BCNO","BAO CAO","DL93"],"not_rendered":{"charts":3,"images":8,"macros":1,"external_links":0,"defined_names":106,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HD","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["PHẦN MỀM THU CHI CÁ NHÂN WPRO"]
[]
[]
[null,null,"ENABLE MACRO TRƯỚC KHI DÙNG"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"LƯU Ý: Nếu bạn không thấy nút nào chứa chữ Enable, bạn hãy làm theo hướng dẫn ở hình dưới"]

{"sheet":"HOME","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"PHẦN MỀM QUẢN LÝ CHI TIÊU CÁ NHÂN, GIA ĐÌNH WPRO (ALL NEW)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"KHÁCH HÀNG:",null,"WPRO.VN - 0869 770 968"]

{"sheet":"Setup","index":2,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Bạn có muốn khôi phục dữ liệu từ bản cũ không?",null,null,null,null,null,"URL"]
["Khôi phục dữ liệu thành công.",null,null,null,null,null,"Tccn.pro.vn"]
["Có lỗi, liên hệ: webkynang.vn@gmail.com; hotline: 038 997 8430 để được hỗ trợ"]

{"sheet":"DM","index":3,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"DANH MỤC"]
[null,null,null,null,"Lưu ý tại báo cáo nợ/ vay: Số âm là còn phải thu, Số dương là còn phải trả."]
[null,"DANH MỤC TÀI KHOẢN","SỐ DƯ ĐẦU",null,"NGƯỜI VAY/ NỢ","SỐ DƯ ĐẦU",null,"DANH MỤC NGUỒN THU",null,"DANH MỤC NGUỒN CHI"]
[null,"TM",10000000,null,"HA",2000000,null,"Tiền lương",null,"Thức ăn"]
[null,"VCB",5000000,null,"VU",-50000000,null,"Làm thêm",null,"Tiền học cho con"]
[null,"Quỹ Tự do tài chính",20000000,null,null,null,null,"Thưởng cuối năm",null,"Xe oto"]
[null,"Quỹ sức khỏe",150000000,null,null,null,null,null,null,"Điện nước, internet"]
[null,"Quỹ đầu tư",200000000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tổng",{"$f":"SUM(C4:C23)","v":385000000},null,"Tổng",{"$f":"SUM(F4:F23)","v":-48000000},null,{"$f":"SUM(H4:H23)","v":0},null,{"$f":"SUM(J4:J23)","v":0}]

{"sheet":"KE HOACH","index":4,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,"KẾ HOẠCH THU CHI",null,null,"Năm: ",2021]
[]
[null,"NGUỒN THU",1,2,3,4,5,6,7,8,9,10,11,12,"CẢ NĂM"]
[null,{"$f":"DM!H4","v":"Tiền lương"},null,null,null,null,null,null,null,null,null,null,null,10000000,{"$f":"SUM(C4:N4)","v":10000000}]
[null,{"$f":"DM!H5","v":"Làm thêm"},null,null,null,null,null,null,null,null,null,null,null,1000000,{"$f":"SUM(C5:N5)","v":1000000}]
[null,{"$f":"DM!H6","v":"Thưởng cuối năm"},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!H23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Tổng",{"$f":"SUM(C4:C23)","v":0},{"$f":"SUM(D4:D23)","v":0},0,0,0,0,0,0,0,0,0,11000000,11000000]
[]
[null,"CHI TIÊU",1,2,3,4,5,6,7,8,9,10,11,12,"CẢ NĂM"]
[null,{"$f":"DM!J4","v":"Thức ăn"},null,null,null,null,null,null,null,null,null,null,null,2000000,{"$f":"SUM(C27:N27)","v":2000000}]
[null,{"$f":"DM!J5","v":"Tiền học cho con"},null,null,null,null,null,null,null,null,null,null,null,3000000,{"$f":"SUM(C28:N28)","v":3000000}]
[null,{"$f":"DM!J6","v":"Xe oto"},null,null,null,null,null,null,null,null,null,null,null,500000,500000]
[null,{"$f":"DM!J7","v":"Điện nước, internet"},null,null,null,null,null,null,null,null,null,null,null,500000,500000]
[null,{"$f":"DM!J8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"DM!J23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Tổng",{"$f":"SUM(C27:C46)","v":0},0,0,0,0,0,0,0,0,0,0,6000000,6000000]

{"sheet":"THUC TE","index":5,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"THỰC TẾ THU CHI HÀNG NGÀY",null,null,null,null,null,"ZALO hỗ trợ: 0869 770 968"]
[]
[null,"NGÀY","NỘI DUNG THU/ CHI","TÀI KHOẢN","SỐ TIỀN THU","NGUỒN THU","SỐ TIỀN CHI","NGUỒN CHI","NGƯỜI VAY/ NỢ","TỰ ĐỔI TÊN","TỰ ĐỔI TÊN","TỰ ĐỔI TÊN","TỰ ĐỔI TÊN","TỰ ĐỔI TÊN","GHI CHÚ"]
[null,"2021-12-02","Lương tháng 11","VCB",11000000,"Tiền lương"]
[null,"2021-12-02","Tiền bán hàng online","TM",1500000,"Làm thêm"]
[null,"2021-12-02","Trả nợ","VCB",null,null,1000000,null,"HA"]
[null,"2021-12-02","Thức ăn","VCB",null,null,100000,"Thức ăn"]
[null,"2021-12-03","Thức ăn","VCB",null,null,100000,"Thức ăn"]
[null,"2021-12-04","Thức ăn","VCB",null,null,100000,"Thức ăn"]
[null,"2021-12-05","Thức ăn","VCB",null,null,100000,"Thức ăn"]
[null,"2021-12-06","Thức ăn","VCB",null,null,100000,"Thức ăn"]
[null,"2021-12-07","Thức ăn","VCB",null,null,100000,"Thức ăn"]
[null,"2021-12-08","Thức ăn","VCB",null,null,100000,"Thức ăn"]
[null,"2021-12-09","Điện nước tháng 11","TM",null,null,500000,"Điện nước, internet"]
[null,"2021-12-09","Thu hồi nợ từ Vũ","VCB",45000000,null,null,null,"VU"]

{"sheet":"BCTK","index":6,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"BÁO CÁO TÀI KHOẢN",null,null,null,"Chọn tháng:",12,"Chọn năm:",2022]
[]
[]
[]
[null,null,"TÀI KHOẢN","SỐ DƯ ĐẦU","THU","CHI","SỐ DƯ CUỐI"]
[null,null,{"$f":"DM!B4","v":"TM"},11000000,0,0,{"$f":"+D6+E6-F6","v":11000000}]
[null,null,{"$f":"DM!B5","v":"VCB"},59300000,0,0,{"$f":"+D7+E7-F7","v":59300000}]
[null,null,{"$f":"DM!B6","v":"Quỹ Tự do tài chính"},20000000,0,0,20000000]
[null,null,{"$f":"DM!B7","v":"Quỹ sức khỏe"},150000000,0,0,150000000]
[null,null,{"$f":"DM!B8","v":"Quỹ đầu tư"},200000000,0,0,200000000]
[null,null,{"$f":"DM!B9","v":0},0,0,0,0]
[null,null,{"$f":"DM!B10","v":0},0,0,0,0]
[null,null,{"$f":"DM!B11","v":0},0,0,0,0]
[null,null,{"$f":"DM!B12","v":0},0,0,0,0]
[null,null,{"$f":"DM!B13","v":0},0,0,0,0]
[null,null,{"$f":"DM!B14","v":0},0,0,0,0]
[null,null,{"$f":"DM!B15","v":0},0,0,0,0]
[null,null,{"$f":"DM!B16","v":0},0,0,0,0]
[null,null,{"$f":"DM!B17","v":0},0,0,0,0]
[null,null,{"$f":"DM!B18","v":0},0,0,0,0]
[null,null,{"$f":"DM!B19","v":0},0,0,0,0]
[null,null,{"$f":"DM!B20","v":0},0,0,0,0]
[null,null,{"$f":"DM!B21","v":0},0,0,0,0]
[null,null,{"$f":"DM!B22","v":0},0,0,0,0]
[null,null,{"$f":"DM!B23","v":0},0,0,0,0]
[null,null,"Tổng",{"$f":"SUM(D6:D25)","v":440300000},{"$f":"SUM(E6:E25)","v":0},0,440300000]

{"sheet":"BC_30DAY","index":7,"n_rows":24,"n_cols":33,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"BÁO CÁO THU CHI 30 NGÀY GẦN NHẤT",null,null,null,null,null,null,null,"CHI",null,"Ngày:","2021-12-09",null,"Chọn ĐVT:","VND",{"$f":"IF(P1=\"vnd\",1,IF(P1=\"K vnd\",1000,1000000))","v":1}]
[]
[null,{"$f":"\"NGUỒN \" &J1","v":"NGUỒN CHI"},{"$f":"M1","v":"2021-12-09"},{"$f":"+C3-1","v":"2021-12-08"},{"$f":"+D3-1","v":"2021-12-07"},"2021-12-06","2021-12-05","2021-12-04","2021-12-03","2021-12-02","2021-12-01","2021-11-30","2021-11-29","2021-11-28","2021-11-27","2021-11-26",{"$f":"+P3-1","v":"2021-11-25"},"2021-11-24","2021-11-23","2021-11-22","2021-11-21","2021-11-20","2021-11-19","2021-11-18","2021-11-17","2021-11-16","2021-11-15","2021-11-14","2021-11-13","2021-11-12","2021-11-11","2021-11-10",{"$f":"+AF3-1","v":"2021-11-09"}]
[null,"Thức ăn",0,100000,100000,100000,100000,100000,100000,100000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Tiền học cho con",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Xe oto",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Điện nước, internet",500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Tổng",{"$f":"SUM(C4:C23)","v":500000},{"$f":"SUM(D4:D23)","v":100000},100000,100000,100000,100000,100000,100000,0,0,0,0,0,0,{"$f":"SUM(Q4:Q23)","v":0},{"$f":"SUM(R4:R23)","v":0},{"$f":"SUM(S4:S23)","v":0},{"$f":"SUM(T4:T23)","v":0},{"$f":"SUM(U4:U23)","v":0},{"$f":"SUM(V4:V23)","v":0},{"$f":"SUM(W4:W23)","v":0},{"$f":"SUM(X4:X23)","v":0},{"$f":"SUM(Y4:Y23)","v":0},{"$f":"SUM(Z4:Z23)","v":0},{"$f":"SUM(AA4:AA23)","v":0},{"$f":"SUM(AB4:AB23)","v":0},{"$f":"SUM(AC4:AC23)","v":0},{"$f":"SUM(AD4:AD23)","v":0},{"$f":"SUM(AE4:AE23)","v":0},{"$f":"SUM(AF4:AF23)","v":0},0]

{"sheet":"tam","index":8,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"THỰC TẾ","KẾ HOẠCH"]
[null,null,"THU NHẬP",{"$f":"BCTHU!$D$26","v":12500000},{"$f":"BCTHU!$E$26","v":11000000}]
[null,null,"CHI TIÊU",{"$f":"BCCHI!D26","v":1200000},{"$f":"BCCHI!E26","v":6000000}]

{"sheet":"BCTHU","index":9,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"BÁO CÁO NGUỒN THU",null,null,null,"Chọn tháng:",12,"Chọn năm:",2021]
[]
[]
[]
[null,null,"NGUỒN THU","THỰC TẾ","KẾ HOẠCH","CHÊNH LỆCH"]
[null,null,{"$f":"DM!H4","v":"Tiền lương"},11000000,10000000,{"$f":"+D6-E6","v":1000000}]
[null,null,{"$f":"DM!H5","v":"Làm thêm"},1500000,1000000,{"$f":"+D7-E7","v":500000}]
[null,null,{"$f":"DM!H6","v":"Thưởng cuối năm"},0,0,0]
[null,null,{"$f":"DM!H7","v":0},0,0,0]
[null,null,{"$f":"DM!H8","v":0},0,0,0]
[null,null,{"$f":"DM!H9","v":0},0,0]
[null,null,{"$f":"DM!H10","v":0},0,0]
[null,null,{"$f":"DM!H11","v":0},0,0]
[null,null,{"$f":"DM!H12","v":0},0,0]
[null,null,{"$f":"DM!H13","v":0},0,0]
[null,null,{"$f":"DM!H14","v":0},0,0]
[null,null,{"$f":"DM!H15","v":0},0,0]
[null,null,{"$f":"DM!H16","v":0},0,0]
[null,null,{"$f":"DM!H17","v":0},0,0]
[null,null,{"$f":"DM!H18","v":0},0,0]
[null,null,{"$f":"DM!H19","v":0},0,0]
[null,null,{"$f":"DM!H20","v":0},0,0]
[null,null,{"$f":"DM!H21","v":0},0,0]
[null,null,{"$f":"DM!H22","v":0},0,0]
[null,null,{"$f":"DM!H23","v":0},0,0,0]
[null,null,"Tổng",{"$f":"SUM(D6:D25)","v":12500000},11000000,1500000]

{"sheet":"BCCHI","index":10,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"BÁO CÁO NGUỒN CHI",null,null,null,"Chọn tháng:",12,"Chọn năm:",2021]
[]
[]
[]
[null,null,"NGUỒN CHI","THỰC TẾ","KẾ HOẠCH","CHÊNH LỆCH"]
[null,null,{"$f":"DM!J4","v":"Thức ăn"},700000,2000000,{"$f":"+D6-E6","v":-1300000}]
[null,null,{"$f":"DM!J5","v":"Tiền học cho con"},0,3000000,-3000000]
[null,null,{"$f":"DM!J6","v":"Xe oto"},0,500000,-500000]
[null,null,{"$f":"DM!J7","v":"Điện nước, internet"},500000,500000,0]
[null,null,{"$f":"DM!J8","v":0},0,0,0]
[null,null,{"$f":"DM!J9","v":0},0,0]
[null,null,{"$f":"DM!J10","v":0},0,0]
[null,null,{"$f":"DM!J11","v":0},0,0]
[null,null,{"$f":"DM!J12","v":0},0,0]
[null,null,{"$f":"DM!J13","v":0},0,0]
[null,null,{"$f":"DM!J14","v":0},0,0]
[null,null,{"$f":"DM!J15","v":0},0,0]
[null,null,{"$f":"DM!J16","v":0},0,0]
[null,null,{"$f":"DM!J17","v":0},0,0]
[null,null,{"$f":"DM!J18","v":0},0,0]
[null,null,{"$f":"DM!J19","v":0},0,0]
[null,null,{"$f":"DM!J20","v":0},0,0]
[null,null,{"$f":"DM!J21","v":0},0,0]
[null,null,{"$f":"DM!J22","v":0},0,0]
[null,null,{"$f":"DM!J23","v":0},0,0]
[null,null,"Tổng",{"$f":"SUM(D6:D25)","v":1200000},6000000,-4800000]

{"sheet":"BCNO","index":11,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"BÁO CÁO NỢ, VAY",null,null,null,"Chọn tháng:",12,"Chọn năm:",2021]
[]
[]
[]
[null,null,"NGƯỜI VAY/ NỢ","SỐ DƯ ĐẦU","THU","CHI","SỐ DƯ CUỐI"]
[null,null,{"$f":"DM!E4","v":"HA"},2000000,0,1000000,{"$f":"+D6+E6-F6","v":1000000}]
[null,null,{"$f":"DM!E5","v":"VU"},-50000000,45000000,0,{"$f":"+D7+E7-F7","v":-5000000}]
[null,null,{"$f":"DM!E6","v":0},0,0,0,0]
[null,null,{"$f":"DM!E7","v":0},0,0,0,0]
[null,null,{"$f":"DM!E8","v":0},0,0,0,0]
[null,null,{"$f":"DM!E9","v":0},0,0,0]
[null,null,{"$f":"DM!E10","v":0},0,0,0]
[null,null,{"$f":"DM!E11","v":0},0,0,0]
[null,null,{"$f":"DM!E12","v":0},0,0,0]
[null,null,{"$f":"DM!E13","v":0},0,0,0]
[null,null,{"$f":"DM!E14","v":0},0,0,0]
[null,null,{"$f":"DM!E15","v":0},0,0,0]
[null,null,{"$f":"DM!E16","v":0},0,0,0]
[null,null,{"$f":"DM!E17","v":0},0,0,0]
[null,null,{"$f":"DM!E18","v":0},0,0,0]
[null,null,{"$f":"DM!E19","v":0},0,0,0]
[null,null,{"$f":"DM!E20","v":0},0,0,0]
[null,null,{"$f":"DM!E21","v":0},0,0,0]
[null,null,{"$f":"DM!E22","v":0},0,0,0]
[null,null,{"$f":"DM!E23","v":0},0,0,0]
[null,null,"Tổng",{"$f":"SUM(D6:D25)","v":-48000000},{"$f":"SUM(E6:E25)","v":45000000},1000000,-4000000]

{"sheet":"BAO CAO","index":12,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
[null,"BÁO CÁO QUẢN TRỊ THU CHI",null,null,null,"Chọn tháng:",6,"Chọn năm:",2021]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TÀI KHOẢN","SỐ DƯ ĐẦU","THU","CHI","SỐ DƯ CUỐI",null,"NGUỒN THU","THỰC TẾ","KẾ HOẠCH","CHÊNH LỆCH"]
[null,{"$f":"DM!B4","v":"TM"},0,0,0,{"$f":"+C17+D17-E17","v":0},null,{"$f":"DM!H4","v":"Tiền lương"},0,0,{"$f":"+I17-J17","v":0}]
[null,{"$f":"DM!B5","v":"VCB"},0,0,0,{"$f":"+C18+D18-E18","v":0},null,{"$f":"DM!H5","v":"Làm thêm"},0,0,{"$f":"+I18-J18","v":0}]
[null,{"$f":"DM!B6","v":"Quỹ Tự do tài chính"},0,0,0,0,null,{"$f":"DM!H6","v":"Thưởng cuối năm"},0,0,0]
[null,{"$f":"DM!B7","v":"Quỹ sức khỏe"},0,0,0,0,null,{"$f":"DM!H7","v":0},0,0,0]
[null,{"$f":"DM!B8","v":"Quỹ đầu tư"},0,0,0,{"$f":"+C21+D21-E21","v":0},null,{"$f":"DM!H8","v":0},0,0,0]
[null,{"$f":"DM!B9","v":0},0,0,0,null,null,{"$f":"DM!H9","v":0},0,0]
[null,{"$f":"DM!B10","v":0},0,0,0,null,null,{"$f":"DM!H10","v":0},0,0]
[null,{"$f":"DM!B11","v":0},0,0,0,null,null,{"$f":"DM!H11","v":0},0,0]
[null,{"$f":"DM!B12","v":0},0,0,0,null,null,{"$f":"DM!H12","v":0},0,0]
[null,{"$f":"DM!B13","v":0},0,0,0,null,null,{"$f":"DM!H13","v":0},0,0]
[null,{"$f":"DM!B14","v":0},0,0,0,null,null,{"$f":"DM!H14","v":0},0,0]
[null,{"$f":"DM!B15","v":0},0,0,0,null,null,{"$f":"DM!H15","v":0},0,0]
[null,{"$f":"DM!B16","v":0},0,0,0,null,null,{"$f":"DM!H16","v":0},0,0]
[null,{"$f":"DM!B17","v":0},0,0,0,null,null,{"$f":"DM!H17","v":0},0,0]
[null,{"$f":"DM!B18","v":0},0,0,0,null,null,{"$f":"DM!H18","v":0},0,0]
[null,{"$f":"DM!B19","v":0},0,0,0,null,null,{"$f":"DM!H19","v":0},0,0]
[null,{"$f":"DM!B20","v":0},0,0,0,null,null,{"$f":"DM!H20","v":0},0,0]
[null,{"$f":"DM!B21","v":0},0,0,0,null,null,{"$f":"DM!H21","v":0},0,0]
[null,{"$f":"DM!B22","v":0},0,0,0,null,null,{"$f":"DM!H22","v":0},0,0]
[null,{"$f":"DM!B23","v":0},0,0,0,0,null,{"$f":"DM!H23","v":0},0,0,0]
[null,"Tổng",{"$f":"SUM(C17:C36)","v":0},{"$f":"SUM(D17:D36)","v":0},0,0,null,"Tổng",{"$f":"SUM(I17:I36)","v":0},{"$f":"SUM(J17:J36)","v":0},{"$f":"SUM(K17:K36)","v":0}]
[]
[null,"Lưu ý tại báo cáo nợ/ vay: Số âm là còn phải thu, Số dương là con phải trả."]
[null,"NGƯỜI VAY/ NỢ","SỐ DƯ ĐẦU","THU","CHI","SỐ DƯ CUỐI",null,"CHI TIÊU","THỰC TẾ","KẾ HOẠCH","CHÊNH LỆCH"]
[null,{"$f":"DM!E4","v":"HA"},0,0,0,{"$f":"+C41+D41-E41","v":0},null,{"$f":"DM!J4","v":"Thức ăn"},0,0,{"$f":"+I41-J41","v":0}]
[null,{"$f":"DM!E5","v":"VU"},0,0,0,{"$f":"+C42+D42-E42","v":0},null,{"$f":"DM!J5","v":"Tiền học cho con"},0,0,0]
[null,{"$f":"DM!E6","v":0},0,0,0,0,null,{"$f":"DM!J6","v":"Xe oto"},0,0,0]
[null,{"$f":"DM!E7","v":0},0,0,0,0,null,{"$f":"DM!J7","v":"Điện nước, internet"},0,0,0]
[null,{"$f":"DM!E8","v":0},0,0,0,0,null,{"$f":"DM!J8","v":0},0,0,0]
[null,{"$f":"DM!E9","v":0},0,0,0,null,null,{"$f":"DM!J9","v":0},0,0]
[null,{"$f":"DM!E10","v":0},0,0,0,null,null,{"$f":"DM!J10","v":0},0,0]
[null,{"$f":"DM!E11","v":0},0,0,0,null,null,{"$f":"DM!J11","v":0},0,0]
[null,{"$f":"DM!E12","v":0},0,0,0,null,null,{"$f":"DM!J12","v":0},0,0]
[null,{"$f":"DM!E13","v":0},0,0,0,null,null,{"$f":"DM!J13","v":0},0,0]
[null,{"$f":"DM!E14","v":0},0,0,0,null,null,{"$f":"DM!J14","v":0},0,0]
[null,{"$f":"DM!E15","v":0},0,0,0,null,null,{"$f":"DM!J15","v":0},0,0]
[null,{"$f":"DM!E16","v":0},0,0,0,null,null,{"$f":"DM!J16","v":0},0,0]
[null,{"$f":"DM!E17","v":0},0,0,0,null,null,{"$f":"DM!J17","v":0},0,0]
[null,{"$f":"DM!E18","v":0},0,0,0,null,null,{"$f":"DM!J18","v":0},0,0]
[null,{"$f":"DM!E19","v":0},0,0,0,null,null,{"$f":"DM!J19","v":0},0,0]
[null,{"$f":"DM!E20","v":0},0,0,0,null,null,{"$f":"DM!J20","v":0},0,0]
[null,{"$f":"DM!E21","v":0},0,0,0,null,null,{"$f":"DM!J21","v":0},0,0]
[null,{"$f":"DM!E22","v":0},0,0,0,null,null,{"$f":"DM!J22","v":0},0,0]
[null,{"$f":"DM!E23","v":0},0,0,0,null,null,{"$f":"DM!J23","v":0},0,0]
[null,"Tổng",{"$f":"SUM(C41:C60)","v":0},{"$f":"SUM(D41:D60)","v":0},0,0,null,"Tổng",{"$f":"SUM(I41:I60)","v":0},{"$f":"SUM(J41:J60)","v":0},{"$f":"SUM(K41:K60)","v":0}]

{"sheet":"DL93","index":13,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[1,null,null,null,null,null,null,"Tên KH","WPRO.VN - 0869 770 968"]