{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["勘定元帳","科目コード表","使い方"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"勘定元帳","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"merged":[[1,1,1,2],[2,4,2,6]]}
[]
[{"$nulls":3},"年",null,null,"№"]
[{"$nulls":4},"勘定元帳"]
[]
[null,"月","日","ｺｰﾄﾞ","摘要","借方","貸方","差引残高"]
[{"$nulls":4},{"$f":"IF(D6=\"\",\"\",IF(ISNA(VLOOKUP(D6,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D6,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,{"$f":"IF(AND(F6=0,G6=0),\"\",F6-G6)","v":""}]
[{"$nulls":4},{"$f":"IF(D7=\"\",\"\",IF(ISNA(VLOOKUP(D7,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D7,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,{"$f":"IF(AND(F7=0,G7=0),\"\",H6+F7-G7)","v":""}]
[{"$nulls":4},{"$f":"IF(D8=\"\",\"\",IF(ISNA(VLOOKUP(D8,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D8,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,{"$f":"IF(AND(F8=0,G8=0),\"\",H7+F8-G8)","v":""}]
[{"$nulls":4},{"$f":"IF(D9=\"\",\"\",IF(ISNA(VLOOKUP(D9,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D9,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D10=\"\",\"\",IF(ISNA(VLOOKUP(D10,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D10,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D11=\"\",\"\",IF(ISNA(VLOOKUP(D11,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D11,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D12=\"\",\"\",IF(ISNA(VLOOKUP(D12,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D12,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D13=\"\",\"\",IF(ISNA(VLOOKUP(D13,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D13,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D14=\"\",\"\",IF(ISNA(VLOOKUP(D14,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D14,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D15=\"\",\"\",IF(ISNA(VLOOKUP(D15,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D15,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D16=\"\",\"\",IF(ISNA(VLOOKUP(D16,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D16,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D17=\"\",\"\",IF(ISNA(VLOOKUP(D17,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D17,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D18=\"\",\"\",IF(ISNA(VLOOKUP(D18,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D18,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D19=\"\",\"\",IF(ISNA(VLOOKUP(D19,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D19,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D20=\"\",\"\",IF(ISNA(VLOOKUP(D20,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D20,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D21=\"\",\"\",IF(ISNA(VLOOKUP(D21,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D21,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D22=\"\",\"\",IF(ISNA(VLOOKUP(D22,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D22,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D23=\"\",\"\",IF(ISNA(VLOOKUP(D23,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D23,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D24=\"\",\"\",IF(ISNA(VLOOKUP(D24,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D24,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D25=\"\",\"\",IF(ISNA(VLOOKUP(D25,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D25,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D26=\"\",\"\",IF(ISNA(VLOOKUP(D26,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D26,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D27=\"\",\"\",IF(ISNA(VLOOKUP(D27,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D27,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D28=\"\",\"\",IF(ISNA(VLOOKUP(D28,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D28,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D29=\"\",\"\",IF(ISNA(VLOOKUP(D29,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D29,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D30=\"\",\"\",IF(ISNA(VLOOKUP(D30,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D30,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D31=\"\",\"\",IF(ISNA(VLOOKUP(D31,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D31,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D32=\"\",\"\",IF(ISNA(VLOOKUP(D32,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D32,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D33=\"\",\"\",IF(ISNA(VLOOKUP(D33,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D33,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D34=\"\",\"\",IF(ISNA(VLOOKUP(D34,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D34,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]
[{"$nulls":4},{"$f":"IF(D35=\"\",\"\",IF(ISNA(VLOOKUP(D35,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D35,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,""]

{"sheet":"科目コード表","index":1,"n_rows":107,"n_cols":4,"rows_kept":107,"merged":[[1,1,1,2],[2,1,6,1],[7,1,36,1],[37,1,56,1],[57,1,66,1],[67,1,76,1],[77,1,106,1]]}
[]
[null,"コード",null,"勘定科目"]
[null,"その他",{"v":1,"d":"001"},"前期繰越"]
[null,null,{"v":2,"d":"002"},"次期繰越"]
[null,null,{"v":3,"d":"003"},"前頁繰越"]
[null,null,{"v":4,"d":"004"},"次頁繰越"]
[null,null,999,"諸口"]
[null,"資産",101,"現金"]
[null,null,102,"小口現金"]
[null,null,103,"当座預金"]
[null,null,104,"普通預金"]
[null,null,105,"通知預金"]
[null,null,106,"定期預金"]
[null,null,107,"売掛金"]
[null,null,108,"未収金"]
[null,null,109,"棚卸商品"]
[null,null,110,"消耗品"]
[null,null,111,"仮払金"]
[null,null,112,"短期貸付金"]
[null,null,113,"長期貸付金"]
[null,null,114,"立替金"]
[null,null,115,"前払費用"]
[null,null,116,"未収収益"]
[null,null,117,"建物"]
[null,null,118,"建物付属設備"]
[null,null,119,"車両運搬具"]
[null,null,120,"機械"]
[null,null,121,"工具・器具"]
[null,null,122,"土地"]
[null,null,123,"什器・備品"]
[null,null,124,"減価償却累計額"]
[null,null,125,"建設仮勘定"]
[null,null,126,"営業権"]
[null,null,127]
[null,null,128]
[null,null,129]
[null,null,130]
[null,"負債",201,"買掛金"]
[null,null,202,"未払金"]
[null,null,203,"預り金"]
[null,null,204,"未払税金"]
[null,null,205,"未払法人税等"]
[null,null,206,"未払費用"]
[null,null,207,"未払利息"]
[null,null,208,"未払配当金"]
[null,null,209,"前受収益"]
[null,null,210,"短期借入金"]
[null,null,211,"長期借入金"]
[null,null,212,"前受金"]
[null,null,213,"仮受金"]
[null,null,214,"賞与引当金"]
[null,null,215,"退職給与引当金"]
[null,null,216]
[null,null,217]
[null,null,218]
[null,null,219]
[null,null,220]
[null,"資本",301,"引出金"]
[null,null,302,"資本金"]
[null,null,303,"資本準備金"]
[null,null,304,"利益準備金"]
[null,null,305]
[null,null,306]
[null,null,307]
[null,null,308]
[null,null,309]
[null,null,310]
[null,"収益",401,"売上"]
[null,null,402,"受取利息"]
[null,null,403,"受取配当金"]
[null,null,404,"有価証券売却益"]
[null,null,405,"固定資産売却益"]
[null,null,406,"雑収入"]
[null,null,407]
[null,null,408]
[null,null,409]
[null,null,410]
[null,"費用",501,"仕入"]
[null,null,502,"貸倒損失"]
[null,null,503,"減価償却費"]
[null,null,504,"給料"]
[null,null,505,"保険料"]
[null,null,506,"地代家賃"]
[null,null,507,"支払手数料"]
[null,null,508,"消耗品費"]
[null,null,509,"修繕費"]
[null,null,510,"租税公課"]
[null,null,511,"棚卸減耗費"]
[null,null,512,"退職金"]
[null,null,513,"通信費"]
[null,null,514,"保管料"]
[null,null,515,"旅費交通費"]
[null,null,516,"売上割引"]
[null,null,517,"支払利息"]
[null,null,518,"支払割引料"]
[null,null,519,"営業権償却"]
[null,null,520,"有価証券売却損"]
[null,null,521,"固定資産売却損"]
[null,null,522,"雑費"]
[null,null,523,"役員報酬"]
[null,null,524,"賞与"]
[null,null,525,"水道光熱費"]
[null,null,526,"福利厚生費"]
[null,null,527]
[null,null,528]
[null,null,529]
[null,null,530]

{"sheet":"使い方","index":2,"n_rows":35,"n_cols":8,"rows_kept":35,"merged":[[1,1,1,2],[2,4,2,6]]}
[]
[null,"令和 2",null,"年",null,null,"№",1]
[{"$nulls":4},"勘定元帳"]
[]
[null,"月","日","ｺｰﾄﾞ","摘要","借方","貸方","差引残高"]
[null,6,1,{"v":3,"d":"003"},{"$f":"IF(D6=\"\",\"\",IF(ISNA(VLOOKUP(D6,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D6,科目コード表!$C$3:$D$107,2,FALSE)))","v":"前頁繰越"},{"v":1234567,"d":"1,234,567"},{"v":1123456,"d":"1,123,456"},{"$f":"IF(AND(F6=0,G6=0),0,F6-G6)","v":{"v":111111,"d":"111,111"}}]
[{"$nulls":3},406,{"$f":"IF(D7=\"\",\"\",IF(ISNA(VLOOKUP(D7,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D7,科目コード表!$C$3:$D$107,2,FALSE)))","v":"雑収入"},{"v":12000,"d":"12,000"},null,{"$f":"IF(AND(F7=0,G7=0),0,H6+F7-G7)","v":{"v":123111,"d":"123,111"}}]
[null,null,10,513,{"$f":"IF(D8=\"\",\"\",IF(ISNA(VLOOKUP(D8,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D8,科目コード表!$C$3:$D$107,2,FALSE)))","v":"通信費"},null,{"v":20000,"d":"20,000"},{"$f":"IF(AND(F8=0,G8=0),0,H7+F8-G8)","v":{"v":103111,"d":"103,111"}}]
[{"$nulls":4},{"$f":"IF(D9=\"\",\"\",IF(ISNA(VLOOKUP(D9,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D9,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D10=\"\",\"\",IF(ISNA(VLOOKUP(D10,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D10,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D11=\"\",\"\",IF(ISNA(VLOOKUP(D11,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D11,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D12=\"\",\"\",IF(ISNA(VLOOKUP(D12,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D12,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D13=\"\",\"\",IF(ISNA(VLOOKUP(D13,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D13,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D14=\"\",\"\",IF(ISNA(VLOOKUP(D14,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D14,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D15=\"\",\"\",IF(ISNA(VLOOKUP(D15,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D15,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D16=\"\",\"\",IF(ISNA(VLOOKUP(D16,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D16,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D17=\"\",\"\",IF(ISNA(VLOOKUP(D17,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D17,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D18=\"\",\"\",IF(ISNA(VLOOKUP(D18,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D18,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D19=\"\",\"\",IF(ISNA(VLOOKUP(D19,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D19,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D20=\"\",\"\",IF(ISNA(VLOOKUP(D20,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D20,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D21=\"\",\"\",IF(ISNA(VLOOKUP(D21,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D21,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D22=\"\",\"\",IF(ISNA(VLOOKUP(D22,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D22,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D23=\"\",\"\",IF(ISNA(VLOOKUP(D23,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D23,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D24=\"\",\"\",IF(ISNA(VLOOKUP(D24,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D24,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D25=\"\",\"\",IF(ISNA(VLOOKUP(D25,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D25,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D26=\"\",\"\",IF(ISNA(VLOOKUP(D26,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D26,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D27=\"\",\"\",IF(ISNA(VLOOKUP(D27,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D27,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D28=\"\",\"\",IF(ISNA(VLOOKUP(D28,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D28,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D29=\"\",\"\",IF(ISNA(VLOOKUP(D29,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D29,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D30=\"\",\"\",IF(ISNA(VLOOKUP(D30,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D30,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D31=\"\",\"\",IF(ISNA(VLOOKUP(D31,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D31,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D32=\"\",\"\",IF(ISNA(VLOOKUP(D32,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D32,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D33=\"\",\"\",IF(ISNA(VLOOKUP(D33,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D33,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,{"$f":"IF(AND(F33=0,G33=0),0,H32+F33-G33)","v":0}]
[{"$nulls":4},{"$f":"IF(D34=\"\",\"\",IF(ISNA(VLOOKUP(D34,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D34,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]
[{"$nulls":4},{"$f":"IF(D35=\"\",\"\",IF(ISNA(VLOOKUP(D35,科目コード表!$C$3:$D$107,2,FALSE)),\"該当科目なし\",VLOOKUP(D35,科目コード表!$C$3:$D$107,2,FALSE)))","v":""},null,null,0]