{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["振替伝票","科目コード表","使い方"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"振替伝票","index":0,"n_rows":16,"n_cols":11,"rows_kept":16,"merged":[[2,1,2,3],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[5,1,5,3],[7,4,7,5],[7,7,7,8],[7,9,7,10],[8,4,8,5],[8,7,8,8],[8,9,8,10],[9,4,9,5],[9,7,9,8],[9,9,9,10],[10,4,10,5],[10,7,10,8],[10,9,10,10],[11,4,11,5],[11,7,11,8],[11,9,11,10],[12,4,12,5],[12,7,12,8],[12,9,12,10],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,3,15,8],[15,9,15,10]]}
[]
[{"$nulls":7},"承認印","承認印","会計印","係印"]
[null,"振替伝票"]
[{"$nulls":3},"№"]
[]
[]
[]
[null,"金額","ｺｰﾄﾞ","借方科目","摘要",null,"ｺｰﾄﾞ","貸方科目",null,"金額"]
[{"$nulls":3},{"$f":"IF(C9=\"\",\"\",IF(ISNA(VLOOKUP(C9,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C9,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G9=\"\",\"\",IF(ISNA(VLOOKUP(G9,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G9,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C10=\"\",\"\",IF(ISNA(VLOOKUP(C10,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C10,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G10=\"\",\"\",IF(ISNA(VLOOKUP(G10,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G10,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C11=\"\",\"\",IF(ISNA(VLOOKUP(C11,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C11,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G11=\"\",\"\",IF(ISNA(VLOOKUP(G11,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G11,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C12=\"\",\"\",IF(ISNA(VLOOKUP(C12,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C12,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G12=\"\",\"\",IF(ISNA(VLOOKUP(G12,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G12,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C13=\"\",\"\",IF(ISNA(VLOOKUP(C13,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C13,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G13=\"\",\"\",IF(ISNA(VLOOKUP(G13,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G13,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C14=\"\",\"\",IF(ISNA(VLOOKUP(C14,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C14,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G14=\"\",\"\",IF(ISNA(VLOOKUP(G14,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G14,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C15=\"\",\"\",IF(ISNA(VLOOKUP(C15,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C15,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G15=\"\",\"\",IF(ISNA(VLOOKUP(G15,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G15,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[null,{"$f":"SUM(B9:B15)","v":0},null,"合　　　　　　　　　　計",{"$nulls":5},{"$f":"SUM(J9:K15)","v":0}]

{"sheet":"科目コード表","index":1,"n_rows":102,"n_cols":4,"rows_kept":102,"merged":[[1,1,1,2],[2,1,31,1],[32,1,51,1],[52,1,61,1],[62,1,71,1],[72,1,101,1]]}
[]
[null,"コード",null,"勘定科目"]
[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":16,"n_cols":11,"rows_kept":16,"merged":[[2,1,2,3],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[5,1,5,3],[7,4,7,5],[7,7,7,8],[7,9,7,10],[8,7,8,8],[8,9,8,10],[9,4,9,5],[9,7,9,8],[9,9,9,10],[10,4,10,5],[10,7,10,8],[10,9,10,10],[11,4,11,5],[11,7,11,8],[11,9,11,10],[12,4,12,5],[12,7,12,8],[12,9,12,10],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,3,15,8],[15,9,15,10]]}
[]
[{"$nulls":7},"承認印","承認印","会計印","係印"]
[null,"振替伝票"]
[{"$nulls":3},"№",1]
[]
[null,"2004-04-01"]
[]
[null,"金額","ｺｰﾄﾞ","借方科目","摘要",null,"ｺｰﾄﾞ","貸方科目",null,"金額"]
[null,{"v":300000,"d":"300,000"},{"v":103,"d":"103 "},{"$f":"IF(C9=\"\",\"\",IF(ISNA(VLOOKUP(C9,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C9,科目コード表!$C$3:$D$102,2,FALSE)))","v":"当座預金"},"○○商店 ２月分",null,104,{"$f":"IF(G9=\"\",\"\",IF(ISNA(VLOOKUP(G9,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G9,科目コード表!$C$3:$D$102,2,FALSE)))","v":"普通預金"},null,{"v":300630,"d":"300,630"}]
[null,630,{"v":507,"d":"507 "},{"$f":"IF(C10=\"\",\"\",IF(ISNA(VLOOKUP(C10,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C10,科目コード表!$C$3:$D$102,2,FALSE)))","v":"支払手数料"},"○○商店 振込手数料",null,null,{"$f":"IF(G10=\"\",\"\",IF(ISNA(VLOOKUP(G10,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G10,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C11=\"\",\"\",IF(ISNA(VLOOKUP(C11,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C11,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G11=\"\",\"\",IF(ISNA(VLOOKUP(G11,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G11,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C12=\"\",\"\",IF(ISNA(VLOOKUP(C12,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C12,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G12=\"\",\"\",IF(ISNA(VLOOKUP(G12,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G12,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C13=\"\",\"\",IF(ISNA(VLOOKUP(C13,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C13,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G13=\"\",\"\",IF(ISNA(VLOOKUP(G13,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G13,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C14=\"\",\"\",IF(ISNA(VLOOKUP(C14,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C14,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G14=\"\",\"\",IF(ISNA(VLOOKUP(G14,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G14,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[{"$nulls":3},{"$f":"IF(C15=\"\",\"\",IF(ISNA(VLOOKUP(C15,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(C15,科目コード表!$C$3:$D$102,2,FALSE)))","v":""},{"$nulls":3},{"$f":"IF(G15=\"\",\"\",IF(ISNA(VLOOKUP(G15,科目コード表!$C$3:$D$102,2,FALSE)),\"該当科目なし\",VLOOKUP(G15,科目コード表!$C$3:$D$102,2,FALSE)))","v":""}]
[null,{"$f":"SUM(B9:B15)","v":{"v":300630,"d":"300,630"}},null,"合　　　　　　　　　　計",{"$nulls":5},{"$f":"SUM(J9:K15)","v":{"v":300630,"d":"300,630"}}]