{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["現金出納帳","取引先テーブル","勘定科目消費税区分テーブル","データ基礎","絞込みデータ","弥生インポート形式仕訳日記帳"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"現金出納帳","index":0,"n_rows":110,"n_cols":35,"rows_kept":110,"cut":false,"hidden":false,"merged":[[7,9,8,9],[2,7,2,8],[7,0,8,0],[7,1,8,1],[7,7,8,7],[7,8,8,8],[7,4,7,6],[7,2,8,2],[7,3,8,3]]}
[null,null,null,null,null,null,null,null,null,null,"１、期首日を入力してください"]
[null,null,null,null,null,null,null,null,null,null,"期首日を入力","2020-04-01",null,{"$f":"YEAR(L2)","v":2020},{"$f":"MONTH(L2)","v":4},{"$f":"DAY(L2)","v":1},{"$f":"TODAY()","v":"2022-06-30"},{"$f":"MONTH(Q2)","v":6},{"$f":"DAY(Q2)","v":30},null,{"$f":"L2","v":"2020-04-01"},{"$f":"MONTH(U2)","v":4},{"$f":"YEAR(U2)","v":2020},null,null,"年","月","日",null,"日付","日付"]
[null,null,null,null,null,null,null,null,null,null,"期末日",{"$f":"EDATE(L2,12)-1","v":"2021-03-31"},null,{"$f":"YEAR(L3)","v":2021},{"$f":"MONTH(L3)","v":3},{"$f":"DAY(L3)","v":31},null,null,null,null,{"$f":"EDATE(U2,1)","v":"2020-05-01"},{"$f":"MONTH(U3)","v":5},{"$f":"YEAR(U3)","v":2020},null,"開始",2016,4,1,{"$f":"DATE(Z3,AA3,AB3)","v":"2016-04-01"},{"$f":"\">=\"&AC3","v":">=42461"},{"$f":"\"<=\"&AC4","v":"<=42825"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EDATE(U3,1)","v":"2020-06-01"},6,2020,null,"終了",2017,3,31,{"$f":"DATE(Z4,AA4,AB4)","v":"2017-03-31"}]
[null,null,null,null,null,null,null,null,null,null,"２、弥生会計の対象科目名を入力してください",null,null,null,null,null,null,null,null,null,"2020-07-01",7,2020]
[null,null,null,null,null,null,null,null,"提供：小林敬幸税理士事務所",null,"対象科目","現金",null,null,null,null,null,null,null,null,"2020-08-01",8,2020]
[null,null,null,null,null,null,null,null,null,null,"対象補助科目",null,null,{"$f":"IF(L7=\"\",\"\",L7)","v":""},null,null,null,null,null,null,"2020-09-01",9,2020]
["月","日","取引先","取引内容","勘定科目",null,null,"入金額","出金額","差引残高",null,null,null,null,null,null,null,null,null,null,"2020-10-01",10,2020]
[null,null,null,null,null,"科目名","補助科目",null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-01",11,2020]
[{"$f":"O2","v":4},{"$f":"P2","v":1},null,null,null,"前期繰越",null,null,null,62841,null,null,null,null,null,null,null,null,null,null,"2020-12-01",12,2020,null,null,null,"借方勘定科目","借方補助科目","借方税区分","貸方勘定科目","貸方補助科目","貸方税区分","金額","摘要","日付"]
[4,1,"今野デザイン","ホームページ管理",{"$f":"C11&D11","v":"今野デザインホームページ管理"},"広告宣伝費",null,null,10500,{"$f":"IF(A11=\"\",\"\",J10+H11-I11)","v":52341},null,null,null,{"$f":"VLOOKUP(A11,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N11,A11,B11)","v":"2020-04-01"},null,null,null,null,null,"2021-01-01",1,2021,null,{"$f":"IF(F11=\"\",\"未確定勘定\",F11)","v":"広告宣伝費"},{"$f":"IF(G11=\"\",\"\",G11)","v":""},{"$f":"IF(I11=\"\",$L$6,IF(I11=0,$L$6,Y11))","v":"広告宣伝費"},{"$f":"IF(I11=\"\",$N$7,IF(I11=0,$N$7,Z11))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AA11,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA11,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},{"$f":"IF(I11=\"\",Y11,IF(I11=0,Y11,$L$6))","v":"現金"},{"$f":"IF(I11=\"\",Z11,IF(I11=0,Z11,$N$7))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AD11,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD11,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},{"$f":"IF(H11=\"\",I11,IF(H11=0,I11,H11))","v":10500},{"$f":"C11&\" \"&D11","v":"今野デザイン ホームページ管理"},{"$f":"TEXT(O11,\"yyyy/mm/dd\")","v":"2020/04/01"}]
[4,23,"坂本飯店","接待飲食",{"$f":"C12&D12","v":"坂本飯店接待飲食"},"交際費",null,null,5000,{"$f":"IF(A12=\"\",\"\",J11+H12-I12)","v":47341},null,null,null,{"$f":"VLOOKUP(A12,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N12,A12,B12)","v":"2020-04-23"},null,null,null,null,null,"2021-02-01",2,2021,null,{"$f":"IF(F12=\"\",\"未確定勘定\",F12)","v":"交際費"},{"$f":"IF(G12=\"\",\"\",G12)","v":""},{"$f":"IF(I12=\"\",$L$6,IF(I12=0,$L$6,Y12))","v":"交際費"},{"$f":"IF(I12=\"\",$N$7,IF(I12=0,$N$7,Z12))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AA12,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA12,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},{"$f":"IF(I12=\"\",Y12,IF(I12=0,Y12,$L$6))","v":"現金"},{"$f":"IF(I12=\"\",Z12,IF(I12=0,Z12,$N$7))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AD12,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD12,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},{"$f":"IF(H12=\"\",I12,IF(H12=0,I12,H12))","v":5000},{"$f":"C12&\" \"&D12","v":"坂本飯店 接待飲食"},{"$f":"TEXT(O12,\"yyyy/mm/dd\")","v":"2020/04/23"}]
[4,30,"JR",null,{"$f":"C13&D13","v":"JR"},"旅費交通費",null,null,3000,{"$f":"IF(A13=\"\",\"\",J12+H13-I13)","v":44341},null,null,null,{"$f":"VLOOKUP(A13,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N13,A13,B13)","v":"2020-04-30"},null,null,null,null,null,{"$f":"EDATE(U12,1)","v":"2021-03-01"},3,2021,null,"旅費交通費","","旅費交通費","",{"$f":"IF(ISERROR(VLOOKUP(AA13,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA13,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD13,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD13,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},3000,"JR ","2020/04/30"]
[5,1,"坂本飯店","接待飲食",{"$f":"C14&D14","v":"坂本飯店接待飲食"},"交際費",null,null,10800,{"$f":"IF(A14=\"\",\"\",J13+H14-I14)","v":33541},null,null,null,{"$f":"VLOOKUP(A14,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N14,A14,B14)","v":"2020-05-01"},null,null,null,null,null,null,null,null,null,"交際費","","交際費","",{"$f":"IF(ISERROR(VLOOKUP(AA14,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA14,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD14,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD14,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},10800,"坂本飯店 接待飲食","2020/05/01"]
[5,11,"坂本飯店","接待飲食",{"$f":"C15&D15","v":"坂本飯店接待飲食"},"交際費",null,null,24000,{"$f":"IF(A15=\"\",\"\",J14+H15-I15)","v":9541},null,null,null,{"$f":"VLOOKUP(A15,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N15,A15,B15)","v":"2020-05-11"},null,null,null,null,null,null,null,null,null,"交際費","","交際費","",{"$f":"IF(ISERROR(VLOOKUP(AA15,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA15,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD15,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD15,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},24000,"坂本飯店 接待飲食","2020/05/11"]
[5,20,"東灘信用金庫","預金より入金",{"$f":"C16&D16","v":"東灘信用金庫預金より入金"},"普通預金","東灘信金／御影",124566,null,{"$f":"IF(A16=\"\",\"\",J15+H16-I16)","v":134107},null,null,null,{"$f":"VLOOKUP(A16,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N16,A16,B16)","v":"2020-05-20"},null,null,null,null,null,null,null,null,null,"普通預金","東灘信金／御影","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA16,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA16,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"普通預金","東灘信金／御影",{"$f":"IF(ISERROR(VLOOKUP(AD16,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD16,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},124566,"東灘信用金庫 預金より入金","2020/05/20"]
[6,10,"クロネコ運輸",null,{"$f":"C17&D17","v":"クロネコ運輸"},"荷造運賃",null,null,1020,{"$f":"IF(A17=\"\",\"\",J16+H17-I17)","v":133087},null,null,null,{"$f":"VLOOKUP(A17,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N17,A17,B17)","v":"2020-06-10"},null,null,null,null,null,null,null,null,null,"荷造運賃","","荷造運賃","",{"$f":"IF(ISERROR(VLOOKUP(AA17,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA17,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD17,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD17,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},1020,"クロネコ運輸 ","2020/06/10"]
[6,20,"東灘信用金庫","預金より入金",{"$f":"C18&D18","v":"東灘信用金庫預金より入金"},"普通預金",null,80000,null,{"$f":"IF(A18=\"\",\"\",J17+H18-I18)","v":213087},null,null,null,{"$f":"VLOOKUP(A18,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N18,A18,B18)","v":"2020-06-20"},null,null,null,null,null,null,null,null,null,"普通預金","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA18,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA18,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"普通預金","",{"$f":"IF(ISERROR(VLOOKUP(AD18,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD18,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},80000,"東灘信用金庫 預金より入金","2020/06/20"]
[7,1,"武田商店",null,{"$f":"C19&D19","v":"武田商店"},"買掛金","武田商店",null,30000,{"$f":"IF(A19=\"\",\"\",J18+H19-I19)","v":183087},null,null,null,{"$f":"VLOOKUP(A19,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N19,A19,B19)","v":"2020-07-01"},null,null,null,null,null,null,null,null,null,"買掛金","武田商店","買掛金","武田商店",{"$f":"IF(ISERROR(VLOOKUP(AA19,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA19,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD19,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD19,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},30000,"武田商店 ","2020/07/01"]
[7,25,"御影タクシー",null,{"$f":"C20&D20","v":"御影タクシー"},"旅費交通費",null,null,1080,{"$f":"IF(A20=\"\",\"\",J19+H20-I20)","v":182007},null,null,null,{"$f":"VLOOKUP(A20,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N20,A20,B20)","v":"2020-07-25"},null,null,null,null,null,null,null,null,null,"旅費交通費","","旅費交通費","",{"$f":"IF(ISERROR(VLOOKUP(AA20,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA20,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD20,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD20,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},1080,"御影タクシー ","2020/07/25"]
[8,1,"JR",null,{"$f":"C21&D21","v":"JR"},"旅費交通費",null,null,5000,{"$f":"IF(A21=\"\",\"\",J20+H21-I21)","v":177007},null,null,null,{"$f":"VLOOKUP(A21,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N21,A21,B21)","v":"2020-08-01"},null,null,null,null,null,null,null,null,null,"旅費交通費","","旅費交通費","",{"$f":"IF(ISERROR(VLOOKUP(AA21,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA21,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD21,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD21,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},5000,"JR ","2020/08/01"]
[8,23,"クロネコ運輸",null,{"$f":"C22&D22","v":"クロネコ運輸"},"荷造運賃",null,null,540,{"$f":"IF(A22=\"\",\"\",J21+H22-I22)","v":176467},null,null,null,{"$f":"VLOOKUP(A22,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N22,A22,B22)","v":"2020-08-23"},null,null,null,null,null,null,null,null,null,"荷造運賃","","荷造運賃","",{"$f":"IF(ISERROR(VLOOKUP(AA22,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA22,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD22,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD22,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},540,"クロネコ運輸 ","2020/08/23"]
[9,20,"今野デザイン","ホームページ管理",{"$f":"C23&D23","v":"今野デザインホームページ管理"},"広告宣伝費",null,null,30000,{"$f":"IF(A23=\"\",\"\",J22+H23-I23)","v":146467},null,null,null,{"$f":"VLOOKUP(A23,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N23,A23,B23)","v":"2020-09-20"},null,null,null,null,null,null,null,null,null,"広告宣伝費","","広告宣伝費","",{"$f":"IF(ISERROR(VLOOKUP(AA23,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA23,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD23,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD23,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},30000,"今野デザイン ホームページ管理","2020/09/20"]
[9,21,"坂本飯店","接待飲食",{"$f":"C24&D24","v":"坂本飯店接待飲食"},"交際費",null,null,4000,{"$f":"IF(A24=\"\",\"\",J23+H24-I24)","v":142467},null,null,null,{"$f":"VLOOKUP(A24,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N24,A24,B24)","v":"2020-09-21"},null,null,null,null,null,null,null,null,null,"交際費","","交際費","",{"$f":"IF(ISERROR(VLOOKUP(AA24,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA24,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD24,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD24,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},4000,"坂本飯店 接待飲食","2020/09/21"]
[10,20,"東灘信用金庫","預金より入金",{"$f":"C25&D25","v":"東灘信用金庫預金より入金"},"普通預金","東灘信金／御影",24560,null,{"$f":"IF(A25=\"\",\"\",J24+H25-I25)","v":167027},null,null,null,{"$f":"VLOOKUP(A25,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N25,A25,B25)","v":"2020-10-20"},null,null,null,null,null,null,null,null,null,"普通預金","東灘信金／御影","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA25,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA25,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"普通預金","東灘信金／御影",{"$f":"IF(ISERROR(VLOOKUP(AD25,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD25,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},24560,"東灘信用金庫 預金より入金","2020/10/20"]
[11,11,"クロネコ運輸",null,{"$f":"C26&D26","v":"クロネコ運輸"},"荷造運賃",null,null,940,{"$f":"IF(A26=\"\",\"\",J25+H26-I26)","v":166087},null,null,null,{"$f":"VLOOKUP(A26,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N26,A26,B26)","v":"2020-11-11"},null,null,null,null,null,null,null,null,null,"荷造運賃","","荷造運賃","",{"$f":"IF(ISERROR(VLOOKUP(AA26,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA26,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD26,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD26,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},940,"クロネコ運輸 ","2020/11/11"]
[11,12,"坂本飯店","接待飲食",{"$f":"C27&D27","v":"坂本飯店接待飲食"},"交際費",null,null,5400,{"$f":"IF(A27=\"\",\"\",J26+H27-I27)","v":160687},null,null,null,{"$f":"VLOOKUP(A27,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N27,A27,B27)","v":"2020-11-12"},null,null,null,null,null,null,null,null,null,"交際費","","交際費","",{"$f":"IF(ISERROR(VLOOKUP(AA27,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA27,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD27,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD27,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},5400,"坂本飯店 接待飲食","2020/11/12"]
[11,12,"一木運送",null,{"$f":"C28&D28","v":"一木運送"},"荷造運賃",null,null,5400,{"$f":"IF(A28=\"\",\"\",J27+H28-I28)","v":155287},null,null,null,{"$f":"VLOOKUP(A28,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N28,A28,B28)","v":"2020-11-12"},null,null,null,null,null,null,null,null,null,"荷造運賃","","荷造運賃","",{"$f":"IF(ISERROR(VLOOKUP(AA28,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA28,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD28,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD28,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},5400,"一木運送 ","2020/11/12"]
[12,11,"今津文具店","事務用品",{"$f":"C29&D29","v":"今津文具店事務用品"},"事務用品費",null,null,500,{"$f":"IF(A29=\"\",\"\",J28+H29-I29)","v":154787},null,null,null,{"$f":"VLOOKUP(A29,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N29,A29,B29)","v":"2020-12-11"},null,null,null,null,null,null,null,null,null,"事務用品費","","事務用品費","",{"$f":"IF(ISERROR(VLOOKUP(AA29,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA29,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD29,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD29,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},500,"今津文具店 事務用品","2020/12/11"]
[12,28,"JR",null,{"$f":"C30&D30","v":"JR"},"旅費交通費",null,null,525,{"$f":"IF(A30=\"\",\"\",J29+H30-I30)","v":154262},null,null,null,{"$f":"VLOOKUP(A30,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N30,A30,B30)","v":"2020-12-28"},null,null,null,null,null,null,null,null,null,"旅費交通費","","旅費交通費","",{"$f":"IF(ISERROR(VLOOKUP(AA30,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA30,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD30,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD30,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},525,"JR ","2020/12/28"]
[12,31,"一木運送",null,{"$f":"C31&D31","v":"一木運送"},"荷造運賃",null,null,5400,{"$f":"IF(A31=\"\",\"\",J30+H31-I31)","v":148862},null,null,null,{"$f":"VLOOKUP(A31,$V$2:$W$13,2,FALSE)","v":2020},{"$f":"DATE(N31,A31,B31)","v":"2020-12-31"},null,null,null,null,null,null,null,null,null,"荷造運賃","","荷造運賃","",{"$f":"IF(ISERROR(VLOOKUP(AA31,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA31,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"課対仕入10%"},"現金","",{"$f":"IF(ISERROR(VLOOKUP(AD31,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD31,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},5400,"一木運送 ","2020/12/31"]
[null,null,null,null,{"$f":"C32&D32","v":""},null,null,null,null,{"$f":"IF(A32=\"\",\"\",J31+H32-I32)","v":""},null,null,null,{"$f":"VLOOKUP(A32,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N32,A32,B32)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA32,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA32,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD32,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD32,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C33&D33","v":""},null,null,null,null,{"$f":"IF(A33=\"\",\"\",J32+H33-I33)","v":""},null,null,null,{"$f":"VLOOKUP(A33,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N33,A33,B33)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA33,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA33,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD33,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD33,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C34&D34","v":""},null,null,null,null,{"$f":"IF(A34=\"\",\"\",J33+H34-I34)","v":""},null,null,null,{"$f":"VLOOKUP(A34,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N34,A34,B34)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA34,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA34,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD34,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD34,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C35&D35","v":""},null,null,null,null,{"$f":"IF(A35=\"\",\"\",J34+H35-I35)","v":""},null,null,null,{"$f":"VLOOKUP(A35,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N35,A35,B35)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA35,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA35,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD35,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD35,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C36&D36","v":""},null,null,null,null,{"$f":"IF(A36=\"\",\"\",J35+H36-I36)","v":""},null,null,null,{"$f":"VLOOKUP(A36,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N36,A36,B36)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA36,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA36,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD36,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD36,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C37&D37","v":""},null,null,null,null,{"$f":"IF(A37=\"\",\"\",J36+H37-I37)","v":""},null,null,null,{"$f":"VLOOKUP(A37,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N37,A37,B37)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA37,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA37,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD37,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD37,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C38&D38","v":""},null,null,null,null,{"$f":"IF(A38=\"\",\"\",J37+H38-I38)","v":""},null,null,null,{"$f":"VLOOKUP(A38,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N38,A38,B38)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA38,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA38,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD38,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD38,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C39&D39","v":""},null,null,null,null,{"$f":"IF(A39=\"\",\"\",J38+H39-I39)","v":""},null,null,null,{"$f":"VLOOKUP(A39,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N39,A39,B39)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA39,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA39,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD39,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD39,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C40&D40","v":""},null,null,null,null,{"$f":"IF(A40=\"\",\"\",J39+H40-I40)","v":""},null,null,null,{"$f":"VLOOKUP(A40,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N40,A40,B40)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA40,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA40,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD40,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD40,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C41&D41","v":""},null,null,null,null,{"$f":"IF(A41=\"\",\"\",J40+H41-I41)","v":""},null,null,null,{"$f":"VLOOKUP(A41,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N41,A41,B41)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA41,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA41,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD41,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD41,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C42&D42","v":""},null,null,null,null,{"$f":"IF(A42=\"\",\"\",J41+H42-I42)","v":""},null,null,null,{"$f":"VLOOKUP(A42,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N42,A42,B42)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA42,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA42,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD42,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD42,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C43&D43","v":""},null,null,null,null,{"$f":"IF(A43=\"\",\"\",J42+H43-I43)","v":""},null,null,null,{"$f":"VLOOKUP(A43,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N43,A43,B43)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA43,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA43,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD43,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD43,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C44&D44","v":""},null,null,null,null,{"$f":"IF(A44=\"\",\"\",J43+H44-I44)","v":""},null,null,null,{"$f":"VLOOKUP(A44,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N44,A44,B44)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA44,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA44,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD44,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD44,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C45&D45","v":""},null,null,null,null,{"$f":"IF(A45=\"\",\"\",J44+H45-I45)","v":""},null,null,null,{"$f":"VLOOKUP(A45,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N45,A45,B45)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA45,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA45,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD45,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD45,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C46&D46","v":""},null,null,null,null,{"$f":"IF(A46=\"\",\"\",J45+H46-I46)","v":""},null,null,null,{"$f":"VLOOKUP(A46,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N46,A46,B46)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA46,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA46,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD46,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD46,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C47&D47","v":""},null,null,null,null,{"$f":"IF(A47=\"\",\"\",J46+H47-I47)","v":""},null,null,null,{"$f":"VLOOKUP(A47,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N47,A47,B47)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA47,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA47,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD47,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD47,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C48&D48","v":""},null,null,null,null,{"$f":"IF(A48=\"\",\"\",J47+H48-I48)","v":""},null,null,null,{"$f":"VLOOKUP(A48,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N48,A48,B48)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA48,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA48,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD48,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD48,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C49&D49","v":""},null,null,null,null,{"$f":"IF(A49=\"\",\"\",J48+H49-I49)","v":""},null,null,null,{"$f":"VLOOKUP(A49,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N49,A49,B49)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA49,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA49,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD49,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD49,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C50&D50","v":""},null,null,null,null,{"$f":"IF(A50=\"\",\"\",J49+H50-I50)","v":""},null,null,null,{"$f":"VLOOKUP(A50,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N50,A50,B50)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA50,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA50,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD50,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD50,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C51&D51","v":""},null,null,null,null,{"$f":"IF(A51=\"\",\"\",J50+H51-I51)","v":""},null,null,null,{"$f":"VLOOKUP(A51,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N51,A51,B51)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA51,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA51,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD51,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD51,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C52&D52","v":""},null,null,null,null,{"$f":"IF(A52=\"\",\"\",J51+H52-I52)","v":""},null,null,null,{"$f":"VLOOKUP(A52,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N52,A52,B52)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA52,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA52,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD52,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD52,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C53&D53","v":""},null,null,null,null,{"$f":"IF(A53=\"\",\"\",J52+H53-I53)","v":""},null,null,null,{"$f":"VLOOKUP(A53,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N53,A53,B53)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA53,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA53,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD53,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD53,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C54&D54","v":""},null,null,null,null,{"$f":"IF(A54=\"\",\"\",J53+H54-I54)","v":""},null,null,null,{"$f":"VLOOKUP(A54,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N54,A54,B54)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA54,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA54,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD54,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD54,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C55&D55","v":""},null,null,null,null,{"$f":"IF(A55=\"\",\"\",J54+H55-I55)","v":""},null,null,null,{"$f":"VLOOKUP(A55,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N55,A55,B55)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA55,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA55,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD55,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD55,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C56&D56","v":""},null,null,null,null,{"$f":"IF(A56=\"\",\"\",J55+H56-I56)","v":""},null,null,null,{"$f":"VLOOKUP(A56,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N56,A56,B56)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA56,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA56,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD56,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD56,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C57&D57","v":""},null,null,null,null,{"$f":"IF(A57=\"\",\"\",J56+H57-I57)","v":""},null,null,null,{"$f":"VLOOKUP(A57,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N57,A57,B57)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA57,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA57,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD57,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD57,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C58&D58","v":""},null,null,null,null,{"$f":"IF(A58=\"\",\"\",J57+H58-I58)","v":""},null,null,null,{"$f":"VLOOKUP(A58,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N58,A58,B58)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA58,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA58,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD58,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD58,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C59&D59","v":""},null,null,null,null,{"$f":"IF(A59=\"\",\"\",J58+H59-I59)","v":""},null,null,null,{"$f":"VLOOKUP(A59,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N59,A59,B59)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA59,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA59,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD59,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD59,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C60&D60","v":""},null,null,null,null,{"$f":"IF(A60=\"\",\"\",J59+H60-I60)","v":""},null,null,null,{"$f":"VLOOKUP(A60,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N60,A60,B60)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA60,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA60,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD60,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD60,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C61&D61","v":""},null,null,null,null,{"$f":"IF(A61=\"\",\"\",J60+H61-I61)","v":""},null,null,null,{"$f":"VLOOKUP(A61,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N61,A61,B61)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA61,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA61,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD61,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD61,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C62&D62","v":""},null,null,null,null,{"$f":"IF(A62=\"\",\"\",J61+H62-I62)","v":""},null,null,null,{"$f":"VLOOKUP(A62,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N62,A62,B62)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA62,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA62,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD62,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD62,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C63&D63","v":""},null,null,null,null,{"$f":"IF(A63=\"\",\"\",J62+H63-I63)","v":""},null,null,null,{"$f":"VLOOKUP(A63,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N63,A63,B63)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA63,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA63,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD63,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD63,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C64&D64","v":""},null,null,null,null,{"$f":"IF(A64=\"\",\"\",J63+H64-I64)","v":""},null,null,null,{"$f":"VLOOKUP(A64,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N64,A64,B64)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA64,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA64,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD64,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD64,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C65&D65","v":""},null,null,null,null,{"$f":"IF(A65=\"\",\"\",J64+H65-I65)","v":""},null,null,null,{"$f":"VLOOKUP(A65,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N65,A65,B65)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA65,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA65,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD65,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD65,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C66&D66","v":""},null,null,null,null,{"$f":"IF(A66=\"\",\"\",J65+H66-I66)","v":""},null,null,null,{"$f":"VLOOKUP(A66,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N66,A66,B66)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA66,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA66,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD66,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD66,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C67&D67","v":""},null,null,null,null,{"$f":"IF(A67=\"\",\"\",J66+H67-I67)","v":""},null,null,null,{"$f":"VLOOKUP(A67,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N67,A67,B67)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA67,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA67,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD67,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD67,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C68&D68","v":""},null,null,null,null,{"$f":"IF(A68=\"\",\"\",J67+H68-I68)","v":""},null,null,null,{"$f":"VLOOKUP(A68,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N68,A68,B68)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA68,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA68,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD68,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD68,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C69&D69","v":""},null,null,null,null,{"$f":"IF(A69=\"\",\"\",J68+H69-I69)","v":""},null,null,null,{"$f":"VLOOKUP(A69,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N69,A69,B69)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA69,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA69,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD69,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD69,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C70&D70","v":""},null,null,null,null,{"$f":"IF(A70=\"\",\"\",J69+H70-I70)","v":""},null,null,null,{"$f":"VLOOKUP(A70,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N70,A70,B70)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA70,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA70,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD70,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD70,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C71&D71","v":""},null,null,null,null,{"$f":"IF(A71=\"\",\"\",J70+H71-I71)","v":""},null,null,null,{"$f":"VLOOKUP(A71,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N71,A71,B71)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA71,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA71,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD71,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD71,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C72&D72","v":""},null,null,null,null,{"$f":"IF(A72=\"\",\"\",J71+H72-I72)","v":""},null,null,null,{"$f":"VLOOKUP(A72,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N72,A72,B72)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA72,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA72,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD72,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD72,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C73&D73","v":""},null,null,null,null,{"$f":"IF(A73=\"\",\"\",J72+H73-I73)","v":""},null,null,null,{"$f":"VLOOKUP(A73,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N73,A73,B73)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA73,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA73,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD73,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD73,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C74&D74","v":""},null,null,null,null,{"$f":"IF(A74=\"\",\"\",J73+H74-I74)","v":""},null,null,null,{"$f":"VLOOKUP(A74,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N74,A74,B74)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA74,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA74,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD74,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD74,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C75&D75","v":""},null,null,null,null,{"$f":"IF(A75=\"\",\"\",J74+H75-I75)","v":""},null,null,null,{"$f":"VLOOKUP(A75,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N75,A75,B75)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA75,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA75,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD75,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD75,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C76&D76","v":""},null,null,null,null,{"$f":"IF(A76=\"\",\"\",J75+H76-I76)","v":""},null,null,null,{"$f":"VLOOKUP(A76,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N76,A76,B76)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(F76=\"\",\"未確定勘定\",F76)","v":"未確定勘定"},{"$f":"IF(G76=\"\",\"\",G76)","v":""},{"$f":"IF(I76=\"\",$L$6,IF(I76=0,$L$6,Y76))","v":"現金"},{"$f":"IF(I76=\"\",$N$7,IF(I76=0,$N$7,Z76))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AA76,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA76,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},{"$f":"IF(I76=\"\",Y76,IF(I76=0,Y76,$L$6))","v":"未確定勘定"},{"$f":"IF(I76=\"\",Z76,IF(I76=0,Z76,$N$7))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AD76,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD76,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},{"$f":"IF(H76=\"\",I76,IF(H76=0,I76,H76))","v":0},{"$f":"C76&\" \"&D76","v":" "},{"$f":"TEXT(O76,\"yyyy/mm/dd\")","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"C77&D77","v":""},null,null,null,null,{"$f":"IF(A77=\"\",\"\",J76+H77-I77)","v":""},null,null,null,{"$f":"VLOOKUP(A77,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N77,A77,B77)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA77,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA77,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD77,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD77,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C78&D78","v":""},null,null,null,null,{"$f":"IF(A78=\"\",\"\",J77+H78-I78)","v":""},null,null,null,{"$f":"VLOOKUP(A78,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N78,A78,B78)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA78,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA78,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD78,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD78,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C79&D79","v":""},null,null,null,null,{"$f":"IF(A79=\"\",\"\",J78+H79-I79)","v":""},null,null,null,{"$f":"VLOOKUP(A79,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N79,A79,B79)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA79,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA79,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD79,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD79,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C80&D80","v":""},null,null,null,null,{"$f":"IF(A80=\"\",\"\",J79+H80-I80)","v":""},null,null,null,{"$f":"VLOOKUP(A80,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N80,A80,B80)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA80,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA80,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD80,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD80,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C81&D81","v":""},null,null,null,null,{"$f":"IF(A81=\"\",\"\",J80+H81-I81)","v":""},null,null,null,{"$f":"VLOOKUP(A81,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N81,A81,B81)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA81,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA81,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD81,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD81,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C82&D82","v":""},null,null,null,null,{"$f":"IF(A82=\"\",\"\",J81+H82-I82)","v":""},null,null,null,{"$f":"VLOOKUP(A82,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N82,A82,B82)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA82,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA82,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD82,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD82,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C83&D83","v":""},null,null,null,null,{"$f":"IF(A83=\"\",\"\",J82+H83-I83)","v":""},null,null,null,{"$f":"VLOOKUP(A83,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N83,A83,B83)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA83,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA83,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD83,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD83,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C84&D84","v":""},null,null,null,null,{"$f":"IF(A84=\"\",\"\",J83+H84-I84)","v":""},null,null,null,{"$f":"VLOOKUP(A84,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N84,A84,B84)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA84,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA84,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD84,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD84,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C85&D85","v":""},null,null,null,null,{"$f":"IF(A85=\"\",\"\",J84+H85-I85)","v":""},null,null,null,{"$f":"VLOOKUP(A85,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N85,A85,B85)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA85,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA85,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD85,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD85,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C86&D86","v":""},null,null,null,null,{"$f":"IF(A86=\"\",\"\",J85+H86-I86)","v":""},null,null,null,{"$f":"VLOOKUP(A86,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N86,A86,B86)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA86,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA86,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD86,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD86,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C87&D87","v":""},null,null,null,null,{"$f":"IF(A87=\"\",\"\",J86+H87-I87)","v":""},null,null,null,{"$f":"VLOOKUP(A87,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N87,A87,B87)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA87,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA87,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD87,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD87,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C88&D88","v":""},null,null,null,null,{"$f":"IF(A88=\"\",\"\",J87+H88-I88)","v":""},null,null,null,{"$f":"VLOOKUP(A88,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N88,A88,B88)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA88,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA88,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD88,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD88,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C89&D89","v":""},null,null,null,null,{"$f":"IF(A89=\"\",\"\",J88+H89-I89)","v":""},null,null,null,{"$f":"VLOOKUP(A89,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N89,A89,B89)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA89,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA89,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD89,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD89,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C90&D90","v":""},null,null,null,null,{"$f":"IF(A90=\"\",\"\",J89+H90-I90)","v":""},null,null,null,{"$f":"VLOOKUP(A90,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N90,A90,B90)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA90,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA90,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD90,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD90,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C91&D91","v":""},null,null,null,null,{"$f":"IF(A91=\"\",\"\",J90+H91-I91)","v":""},null,null,null,{"$f":"VLOOKUP(A91,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N91,A91,B91)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA91,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA91,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD91,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD91,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C92&D92","v":""},null,null,null,null,{"$f":"IF(A92=\"\",\"\",J91+H92-I92)","v":""},null,null,null,{"$f":"VLOOKUP(A92,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N92,A92,B92)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA92,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA92,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD92,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD92,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C93&D93","v":""},null,null,null,null,{"$f":"IF(A93=\"\",\"\",J92+H93-I93)","v":""},null,null,null,{"$f":"VLOOKUP(A93,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N93,A93,B93)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA93,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA93,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD93,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD93,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C94&D94","v":""},null,null,null,null,{"$f":"IF(A94=\"\",\"\",J93+H94-I94)","v":""},null,null,null,{"$f":"VLOOKUP(A94,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N94,A94,B94)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA94,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA94,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD94,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD94,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C95&D95","v":""},null,null,null,null,{"$f":"IF(A95=\"\",\"\",J94+H95-I95)","v":""},null,null,null,{"$f":"VLOOKUP(A95,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N95,A95,B95)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA95,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA95,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD95,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD95,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C96&D96","v":""},null,null,null,null,{"$f":"IF(A96=\"\",\"\",J95+H96-I96)","v":""},null,null,null,{"$f":"VLOOKUP(A96,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N96,A96,B96)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA96,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA96,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD96,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD96,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C97&D97","v":""},null,null,null,null,{"$f":"IF(A97=\"\",\"\",J96+H97-I97)","v":""},null,null,null,{"$f":"VLOOKUP(A97,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N97,A97,B97)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA97,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA97,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD97,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD97,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C98&D98","v":""},null,null,null,null,{"$f":"IF(A98=\"\",\"\",J97+H98-I98)","v":""},null,null,null,{"$f":"VLOOKUP(A98,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N98,A98,B98)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA98,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA98,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD98,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD98,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C99&D99","v":""},null,null,null,null,{"$f":"IF(A99=\"\",\"\",J98+H99-I99)","v":""},null,null,null,{"$f":"VLOOKUP(A99,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N99,A99,B99)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA99,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA99,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD99,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD99,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C100&D100","v":""},null,null,null,null,{"$f":"IF(A100=\"\",\"\",J99+H100-I100)","v":""},null,null,null,{"$f":"VLOOKUP(A100,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N100,A100,B100)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA100,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA100,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD100,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD100,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C101&D101","v":""},null,null,null,null,{"$f":"IF(A101=\"\",\"\",J100+H101-I101)","v":""},null,null,null,{"$f":"VLOOKUP(A101,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N101,A101,B101)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA101,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA101,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD101,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD101,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C102&D102","v":""},null,null,null,null,{"$f":"IF(A102=\"\",\"\",J101+H102-I102)","v":""},null,null,null,{"$f":"VLOOKUP(A102,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N102,A102,B102)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA102,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA102,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD102,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD102,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C103&D103","v":""},null,null,null,null,{"$f":"IF(A103=\"\",\"\",J102+H103-I103)","v":""},null,null,null,{"$f":"VLOOKUP(A103,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N103,A103,B103)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA103,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA103,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD103,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD103,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C104&D104","v":""},null,null,null,null,{"$f":"IF(A104=\"\",\"\",J103+H104-I104)","v":""},null,null,null,{"$f":"VLOOKUP(A104,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N104,A104,B104)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA104,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA104,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD104,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD104,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C105&D105","v":""},null,null,null,null,{"$f":"IF(A105=\"\",\"\",J104+H105-I105)","v":""},null,null,null,{"$f":"VLOOKUP(A105,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N105,A105,B105)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA105,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA105,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD105,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD105,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C106&D106","v":""},null,null,null,null,{"$f":"IF(A106=\"\",\"\",J105+H106-I106)","v":""},null,null,null,{"$f":"VLOOKUP(A106,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N106,A106,B106)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA106,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA106,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD106,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD106,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C107&D107","v":""},null,null,null,null,{"$f":"IF(A107=\"\",\"\",J106+H107-I107)","v":""},null,null,null,{"$f":"VLOOKUP(A107,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N107,A107,B107)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA107,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA107,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD107,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD107,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C108&D108","v":""},null,null,null,null,{"$f":"IF(A108=\"\",\"\",J107+H108-I108)","v":""},null,null,null,{"$f":"VLOOKUP(A108,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N108,A108,B108)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA108,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA108,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD108,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD108,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C109&D109","v":""},null,null,null,null,{"$f":"IF(A109=\"\",\"\",J108+H109-I109)","v":""},null,null,null,{"$f":"VLOOKUP(A109,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N109,A109,B109)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA109,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA109,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD109,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD109,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]
[null,null,null,null,{"$f":"C110&D110","v":""},null,null,null,null,{"$f":"IF(A110=\"\",\"\",J109+H110-I110)","v":""},null,null,null,{"$f":"VLOOKUP(A110,$V$2:$W$13,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATE(N110,A110,B110)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,"未確定勘定","","現金","",{"$f":"IF(ISERROR(VLOOKUP(AA110,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AA110,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},"未確定勘定","",{"$f":"IF(ISERROR(VLOOKUP(AD110,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE)),\"\",VLOOKUP(AD110,勘定科目消費税区分テーブル!$B$9:$C$150,2,FALSE))","v":"対象外"},0," ",{"$error":"#N/A"}]

{"sheet":"取引先テーブル","index":1,"n_rows":150,"n_cols":6,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"取引先名","取引内容",null,"勘定科目","補助科目"]
[null,"JR",null,{"$f":"B9&C9","v":"JR"},"旅費交通費"]
[null,"一木運送",null,"一木運送","荷造運賃"]
[null,"今津文具店","事務用品","今津文具店事務用品","事務用品費"]
[null,"クロネコ運輸",null,"クロネコ運輸","荷造運賃"]
[null,"今野デザイン","ホームページ管理","今野デザインホームページ管理","広告宣伝費"]
[null,"坂本飯店","接待飲食","坂本飯店接待飲食","交際費"]
[null,"セブンマート",null,"セブンマート","消耗品費"]
[null,"武田商店",null,"武田商店","買掛金","武田商店"]
[null,"東灘信用金庫","預金より入金","東灘信用金庫預金より入金","普通預金","東灘信金／御影"]
[null,"郵便局",null,"郵便局","通信費"]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"B41&C41","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"B73&C73","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"B105&C105","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"B137&C137","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]

{"sheet":"勘定科目消費税区分テーブル","index":2,"n_rows":150,"n_cols":7,"rows_kept":150,"cut":false,"hidden":false,"merged":[[91,5,95,5],[96,5,100,5],[101,5,105,5],[41,5,45,5],[46,5,50,5],[51,5,55,5],[56,5,60,5],[61,5,65,5],[71,5,75,5],[76,5,80,5],[81,5,85,5],[86,5,90,5],[10,5,14,5],[15,5,19,5],[20,5,24,5],[25,5,29,5],[66,5,70,5]]}
[]
[]
[]
[]
[]
[]
[]
[null,"勘定科目","税区分",null,null,"※消費税税区分一覧"]
[null,"現金","対象外",null,null,"取引の種類","税区分名"]
[null,"当座預金","対象外",null,null,"消費税と無関係な取引（不課税取引）","対象外"]
[null,"普通預金","対象外",null,null,"課税売上※","課税売上"]
[null,"定期預金","対象外",null,null,null,"課税売上10%"]
[null,"定期積金","対象外",null,null,null,"課税売上8%（軽）"]
[null,"郵便貯金","対象外",null,null,null,"課税売上8%"]
[null,"受取手形","対象外",null,null,null,"課税売上5%"]
[null,"売掛金","対象外",null,null,"課税売上にかかわる対価の返還※","課税売返"]
[null,"有価証券","対象外",null,null,null,"課税売返10%"]
[null,"前渡金","対象外",null,null,null,"課税売返8%（軽）"]
[null,"立替金","対象外",null,null,null,"課税売返8%"]
[null,"前払費用","対象外",null,null,null,"課税売返5%"]
[null,"未収収益","対象外",null,null,"課税売上にかかわる対価の貸倒※","課税売倒"]
[null,"短期貸付金","対象外",null,null,null,"課税売倒10%"]
[null,"未収入金","対象外",null,null,null,"課税売倒8%（軽）"]
[null,"仮払金","対象外",null,null,null,"課税売倒8%"]
[null,"預け金","対象外",null,null,null,"課税売倒5%"]
[null,"建物","課対仕入10%",null,null,"課税売上にかかわる貸倒分の回収※","課税売回"]
[null,"附属設備","課対仕入10%",null,null,null,"課税売回10%"]
[null,"構築物","課対仕入10%",null,null,null,"課税売回8%（軽）"]
[null,"機械装置","課対仕入10%",null,null,null,"課税売回8%"]
[null,"車両運搬具","課対仕入10%",null,null,null,"課税売回5%"]
[null,"工具器具備品","課対仕入10%",null,null,"輸出免税売上","輸出売上"]
[null,"土地","対象外",null,null,"輸出免税売上にかかわる対価の返還","輸出売返"]
[null,"建設仮勘定","対象外",null,null,"輸出免税売上にかかわる貸倒","輸出売倒"]
[null,"ソフトウェア","課対仕入10%",null,null,"非課税売上","非課売上"]
[null,"投資有価証券","対象外",null,null,"非課税売上にかかわる対価の返還","非課売返"]
[null,"出資金","対象外",null,null,"非課税売上にかかわる貸倒","非課売倒"]
[null,"敷金","対象外",null,null,"非課税資産の輸出等","非資輸出"]
[null,"差入保証金","対象外",null,null,"非課税資産の輸出等にかかわる対価の返還","非資輸返"]
[null,"長期貸付金","対象外",null,null,"非課税資産の輸出等にかかわる貸倒","非資輸倒"]
[null,"長期前払費用","対象外",null,null,"消費税と無関係な売上（不課税取引）","対外売上"]
[null,"預託金","対象外",null,null,"有価証券の譲渡","有価譲渡"]
[null,"支払手形","対象外",null,null,"課税仕入※","課対仕入"]
[null,"買掛金","対象外",null,null,null,"課対仕入10%"]
[null,"短期借入金","対象外",null,null,null,"課対仕入8%（軽）"]
[null,"未払金","対象外",null,null,null,"課対仕入8%"]
[null,"未払費用","対象外",null,null,null,"課対仕入5%"]
[null,"未払法人税等","対象外",null,null,"課税仕入にかかわる対価の返還※","課対仕返"]
[null,"未払消費税等","対象外",null,null,null,"課対仕返10%"]
[null,"前受金","対象外",null,null,null,"課対仕返8%（軽）"]
[null,"預り金","対象外",null,null,null,"課対仕返8%"]
[null,"前受収益","対象外",null,null,null,"課対仕返5%"]
[null,"仮受金","対象外",null,null,"非課税売上に対応する課税仕入※","非対仕入"]
[null,"預り保証金","対象外",null,null,null,"非対仕入10%"]
[null,"長期借入金","対象外",null,null,null,"非対仕入8%（軽）"]
[null,"長期未払金","対象外",null,null,null,"非対仕入8%"]
[null,"売上高","課税売上10%",null,null,null,"非対仕入5%"]
[null,"仕入高","課対仕入10%",null,null,"非課税売上に対応する課税仕入の対価の返還※","非対仕返"]
[null,"役員報酬","対象外",null,null,null,"非対仕返10%"]
[null,"役員賞与","対象外",null,null,null,"非対仕返8%（軽）"]
[null,"給料手当","対象外",null,null,null,"非対仕返8%"]
[null,"雑給","対象外",null,null,null,"非対仕返5%"]
[null,"賞与","対象外",null,null,"課税・非課税売上に共通対応する課税仕入※","共対仕入"]
[null,"退職金","対象外",null,null,null,"共対仕入10%"]
[null,"法定福利費","対象外",null,null,null,"共対仕入8%（軽）"]
[null,"福利厚生費","課対仕入10%",null,null,null,"共対仕入8%"]
[null,"採用教育費","課対仕入10%",null,null,null,"共対仕入5%"]
[null,"外注費","課対仕入10%",null,null,"課税・非課税売上に共通対応する課税仕入の対価の返還※","共対仕返"]
[null,"荷造運賃","課対仕入10%",null,null,null,"共対仕返10%"]
[null,"広告宣伝費","課対仕入10%",null,null,null,"共対仕返8%（軽）"]
[null,"交際費","課対仕入10%",null,null,null,"共対仕返8%"]
[null,"会議費","課対仕入10%",null,null,null,"共対仕返5%"]
[null,"旅費交通費","課対仕入10%",null,null,"課税売上に対応する課税貨物※","課対輸本"]
[null,"通信費","課対仕入10%",null,null,null,"課対輸本7.8%"]
[null,"販売手数料","課対仕入10%",null,null,null,"課対輸本6.24%（軽）"]
[null,"販売促進費","課対仕入10%",null,null,null,"課対輸本6.3%"]
[null,"消耗品費","課対仕入10%",null,null,null,"課対輸本4%"]
[null,"事務用品費","課対仕入10%",null,null,"非課税売上に対応する課税貨物※","非対輸本"]
[null,"修繕費","課対仕入10%",null,null,null,"非対輸本7.8%"]
[null,"水道光熱費","課対仕入10%",null,null,null,"非対輸本6.24%（軽）"]
[null,"新聞図書費","課対仕入10%",null,null,null,"非対輸本6.3%"]
[null,"諸会費","対象外",null,null,null,"非対輸本4%"]
[null,"支払手数料","課対仕入10%",null,null,"課税・非課税に共通対応する課税貨物※","共対輸本"]
[null,"車両費","課対仕入10%",null,null,null,"共対輸本7.8%"]
[null,"地代家賃","課対仕入10%",null,null,null,"共対輸本6.24%（軽）"]
[null,"賃借料","課対仕入10%",null,null,null,"共対輸本6.3%"]
[null,"リース料","課対仕入10%",null,null,null,"共対輸本4%"]
[null,"保険料","対象外",null,null,"課税貨物の消費税※","課対輸税"]
[null,"租税公課","対象外",null,null,null,"課対輸税7.8%"]
[null,"支払報酬料","課対仕入10%",null,null,null,"課対輸税6.24%（軽）"]
[null,"寄付金","対象外",null,null,null,"課対輸税6.3%"]
[null,"研究開発費","課対仕入10%",null,null,null,"課対輸税4%"]
[null,"雑費","課対仕入10%",null,null,"非課税貨物の消費税※","非対輸税"]
[null,"受取利息","非課売上",null,null,null,"非対輸税7.8%"]
[null,"受取配当金","対象外",null,null,null,"非対輸税6.24%（軽）"]
[null,"雑収入","対象外",null,null,null,"非対輸税6.3%"]
[null,"支払利息","対象外",null,null,null,"非対輸税4%"]
[null,"割引料","対象外",null,null,"課税・非課税に共通対応する課税貨物の消費税※","共対輸税"]
[null,"手形売却損","対象外",null,null,null,"共対輸税7.8%"]
[null,"貸倒損失(外)","課税売倒10%",null,null,null,"共対輸税6.24%（軽）"]
[null,"売上割引","課税売返10%",null,null,null,"共対輸税6.3%"]
[null,"雑損失","課対仕入10%",null,null,null,"共対輸税4%"]
[null,"法人税、住民税及び事業税","対象外",null,null,"地方消費税貨物割※","地消貨割"]
[null,"法人税等","対象外",null,null,null,"地消貨割2.2%"]
[null,"[製]材料仕入高","課対仕入10%",null,null,null,"地消貨割1.76%（軽）"]
[null,"[製]役員報酬","対象外",null,null,null,"地消貨割1.7%"]
[null,"[製]給料手当","対象外",null,null,null,"地消貨割1%"]
[null,"[製]雑給","対象外",null,null,"非課税仕入","非課仕入"]
[null,"[製]賞与","対象外",null,null,"消費税と無関係な仕入（不課税取引）","対外仕入"]
[null,"[製]退職金","対象外",null,null,"税区分が不明な取引","不明"]
[null,"[製]法定福利費","対象外"]
[null,"[製]福利厚生費","課対仕入10%"]
[null,"[製]外注加工費","課対仕入10%"]
[null,"[製]動力費","課対仕入10%"]
[null,"[製]荷造運賃","課対仕入10%"]
[null,"[製]会議費","課対仕入10%"]
[null,"[製]旅費交通費","課対仕入10%"]
[null,"[製]通信費","課対仕入10%"]
[null,"[製]消耗品費","課対仕入10%"]
[null,"[製]事務用品費","課対仕入10%"]
[null,"[製]消耗工具費","課対仕入10%"]
[null,"[製]車両費","課対仕入10%"]
[null,"[製]修繕費","課対仕入10%"]
[null,"[製]水道光熱費","課対仕入10%"]
[null,"[製]新聞図書費","課対仕入10%"]
[null,"[製]諸会費","対象外"]
[null,"[製]地代家賃","課対仕入10%"]
[null,"[製]賃借料","課対仕入10%"]
[null,"[製]租税公課","対象外"]
[null,"[製]保険料","対象外"]
[null,"[製]支払報酬料","課対仕入10%"]
[null,"[製]寄付金","対象外"]
[null,"[製]研究開発費","課対仕入10%"]
[null,"[製]保管料","課対仕入10%"]
[null,"[製]特許使用料","課対仕入10%"]
[null,"[製]雑費","課対仕入10%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"未確定勘定","対象外"]

{"sheet":"データ基礎","index":3,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[1,2,3,"1900-01-04",5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,"日付"]
[2000,null,null,"2016/04/01","広告宣伝費","",null,"課対仕入込8%",10500,null,"現金","",null,"対象外",10500,null,"今野デザイン ホームページ管理",null,null,0,null,null,null,null,"no",{"$f":"DATEVALUE(D2)","v":42461}]
[2000,null,null,"2016/04/23","交際費","",null,"課対仕入込8%",5000,null,"現金","",null,"対象外",5000,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no",{"$f":"DATEVALUE(D3)","v":42483}]
[2000,null,null,"2016/04/30","旅費交通費","",null,"課対仕入込8%",3000,null,"現金","",null,"対象外",3000,null,"JR ",null,null,0,null,null,null,null,"no",42490]
[2000,null,null,"2016/05/01","交際費","",null,"課対仕入込8%",10800,null,"現金","",null,"対象外",10800,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no",42491]
[2000,null,null,"2016/05/11","交際費","",null,"課対仕入込8%",24000,null,"現金","",null,"対象外",24000,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no",42501]
[2000,null,null,"2016/05/20","現金","",null,"対象外",124566,null,"普通預金","東灘信金／御影",null,"対象外",124566,null,"東灘信用金庫 預金より入金",null,null,0,null,null,null,null,"no",42510]
[2000,null,null,"2016/06/10","荷造運賃","",null,"課対仕入込8%",1020,null,"現金","",null,"対象外",1020,null,"クロネコ運輸 ",null,null,0,null,null,null,null,"no",42531]
[2000,null,null,"2016/06/20","現金","",null,"対象外",80000,null,"普通預金","",null,"対象外",80000,null,"東灘信用金庫 預金より入金",null,null,0,null,null,null,null,"no",42541]
[2000,null,null,"2016/07/01","買掛金","武田商店",null,"対象外",30000,null,"現金","",null,"対象外",30000,null,"武田商店 ",null,null,0,null,null,null,null,"no",42552]
[2000,null,null,"2016/07/25","旅費交通費","",null,"課対仕入込8%",1080,null,"現金","",null,"対象外",1080,null,"御影タクシー ",null,null,0,null,null,null,null,"no",42576]
[2000,null,null,"2016/08/01","旅費交通費","",null,"課対仕入込8%",5000,null,"現金","",null,"対象外",5000,null,"JR ",null,null,0,null,null,null,null,"no",42583]
[2000,null,null,"2016/08/23","荷造運賃","",null,"課対仕入込8%",540,null,"現金","",null,"対象外",540,null,"クロネコ運輸 ",null,null,0,null,null,null,null,"no",42605]
[2000,null,null,"2016/09/20","広告宣伝費","",null,"課対仕入込8%",30000,null,"現金","",null,"対象外",30000,null,"今野デザイン ホームページ管理",null,null,0,null,null,null,null,"no",42633]
[2000,null,null,"2016/09/21","交際費","",null,"課対仕入込8%",4000,null,"現金","",null,"対象外",4000,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no",42634]
[2000,null,null,"2016/10/20","現金","",null,"対象外",24560,null,"普通預金","東灘信金／御影",null,"対象外",24560,null,"東灘信用金庫 預金より入金",null,null,0,null,null,null,null,"no",42663]
[2000,null,null,"2016/11/11","荷造運賃","",null,"課対仕入込8%",940,null,"現金","",null,"対象外",940,null,"クロネコ運輸 ",null,null,0,null,null,null,null,"no",42685]
[2000,null,null,"2016/11/12","交際費","",null,"課対仕入込8%",5400,null,"現金","",null,"対象外",5400,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no",42686]
[2000,null,null,"2016/11/12","荷造運賃","",null,"課対仕入込8%",5400,null,"現金","",null,"対象外",5400,null,"一木運送 ",null,null,0,null,null,null,null,"no",42686]
[2000,null,null,"2016/12/11","事務用品費","",null,"課対仕入込8%",500,null,"現金","",null,"対象外",500,null,"今津文具店 事務用品",null,null,0,null,null,null,null,"no",42715]
[2000,null,null,"2016/12/28","旅費交通費","",null,"課対仕入込8%",525,null,"現金","",null,"対象外",525,null,"JR ",null,null,0,null,null,null,null,"no",42732]
[2000,null,null,"2016/12/31","荷造運賃","",null,"課対仕入込8%",5400,null,"現金","",null,"対象外",5400,null,"一木運送 ",null,null,0,null,null,null,null,"no",42735]

{"sheet":"絞込みデータ","index":4,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[1,2,3,"1900-01-04",5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,"日付"]
[2000,null,null,"2016/04/01","広告宣伝費","",null,"課対仕入込8%",10500,null,"現金","",null,"対象外",10500,null,"今野デザイン ホームページ管理",null,null,0,null,null,null,null,"no",42461]
[2000,null,null,"2016/04/23","交際費","",null,"課対仕入込8%",5000,null,"現金","",null,"対象外",5000,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no",42483]
[2000,null,null,"2016/04/30","旅費交通費","",null,"課対仕入込8%",3000,null,"現金","",null,"対象外",3000,null,"JR ",null,null,0,null,null,null,null,"no",42490]
[2000,null,null,"2016/05/01","交際費","",null,"課対仕入込8%",10800,null,"現金","",null,"対象外",10800,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no",42491]
[2000,null,null,"2016/05/11","交際費","",null,"課対仕入込8%",24000,null,"現金","",null,"対象外",24000,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no",42501]
[2000,null,null,"2016/05/20","現金","",null,"対象外",124566,null,"普通預金","東灘信金／御影",null,"対象外",124566,null,"東灘信用金庫 預金より入金",null,null,0,null,null,null,null,"no",42510]
[2000,null,null,"2016/06/10","荷造運賃","",null,"課対仕入込8%",1020,null,"現金","",null,"対象外",1020,null,"クロネコ運輸 ",null,null,0,null,null,null,null,"no",42531]
[2000,null,null,"2016/06/20","現金","",null,"対象外",80000,null,"普通預金","",null,"対象外",80000,null,"東灘信用金庫 預金より入金",null,null,0,null,null,null,null,"no",42541]
[2000,null,null,"2016/07/01","買掛金","武田商店",null,"対象外",30000,null,"現金","",null,"対象外",30000,null,"武田商店 ",null,null,0,null,null,null,null,"no",42552]
[2000,null,null,"2016/07/25","旅費交通費","",null,"課対仕入込8%",1080,null,"現金","",null,"対象外",1080,null,"御影タクシー ",null,null,0,null,null,null,null,"no",42576]
[2000,null,null,"2016/08/01","旅費交通費","",null,"課対仕入込8%",5000,null,"現金","",null,"対象外",5000,null,"JR ",null,null,0,null,null,null,null,"no",42583]
[2000,null,null,"2016/08/23","荷造運賃","",null,"課対仕入込8%",540,null,"現金","",null,"対象外",540,null,"クロネコ運輸 ",null,null,0,null,null,null,null,"no",42605]
[2000,null,null,"2016/09/20","広告宣伝費","",null,"課対仕入込8%",30000,null,"現金","",null,"対象外",30000,null,"今野デザイン ホームページ管理",null,null,0,null,null,null,null,"no",42633]
[2000,null,null,"2016/09/21","交際費","",null,"課対仕入込8%",4000,null,"現金","",null,"対象外",4000,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no",42634]
[2000,null,null,"2016/10/20","現金","",null,"対象外",24560,null,"普通預金","東灘信金／御影",null,"対象外",24560,null,"東灘信用金庫 預金より入金",null,null,0,null,null,null,null,"no",42663]
[2000,null,null,"2016/11/11","荷造運賃","",null,"課対仕入込8%",940,null,"現金","",null,"対象外",940,null,"クロネコ運輸 ",null,null,0,null,null,null,null,"no",42685]
[2000,null,null,"2016/11/12","交際費","",null,"課対仕入込8%",5400,null,"現金","",null,"対象外",5400,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no",42686]
[2000,null,null,"2016/11/12","荷造運賃","",null,"課対仕入込8%",5400,null,"現金","",null,"対象外",5400,null,"一木運送 ",null,null,0,null,null,null,null,"no",42686]
[2000,null,null,"2016/12/11","事務用品費","",null,"課対仕入込8%",500,null,"現金","",null,"対象外",500,null,"今津文具店 事務用品",null,null,0,null,null,null,null,"no",42715]
[2000,null,null,"2016/12/28","旅費交通費","",null,"課対仕入込8%",525,null,"現金","",null,"対象外",525,null,"JR ",null,null,0,null,null,null,null,"no",42732]
[2000,null,null,"2016/12/31","荷造運賃","",null,"課対仕入込8%",5400,null,"現金","",null,"対象外",5400,null,"一木運送 ",null,null,0,null,null,null,null,"no",42735]

{"sheet":"弥生インポート形式仕訳日記帳","index":5,"n_rows":21,"n_cols":25,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[2000,null,null,"2016/04/01","広告宣伝費","",null,"課対仕入込8%",10500,null,"現金","",null,"対象外",10500,null,"今野デザイン ホームページ管理",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/04/23","交際費","",null,"課対仕入込8%",5000,null,"現金","",null,"対象外",5000,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/04/30","旅費交通費","",null,"課対仕入込8%",3000,null,"現金","",null,"対象外",3000,null,"JR ",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/05/01","交際費","",null,"課対仕入込8%",10800,null,"現金","",null,"対象外",10800,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/05/11","交際費","",null,"課対仕入込8%",24000,null,"現金","",null,"対象外",24000,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/05/20","現金","",null,"対象外",124566,null,"普通預金","東灘信金／御影",null,"対象外",124566,null,"東灘信用金庫 預金より入金",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/06/10","荷造運賃","",null,"課対仕入込8%",1020,null,"現金","",null,"対象外",1020,null,"クロネコ運輸 ",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/06/20","現金","",null,"対象外",80000,null,"普通預金","",null,"対象外",80000,null,"東灘信用金庫 預金より入金",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/07/01","買掛金","武田商店",null,"対象外",30000,null,"現金","",null,"対象外",30000,null,"武田商店 ",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/07/25","旅費交通費","",null,"課対仕入込8%",1080,null,"現金","",null,"対象外",1080,null,"御影タクシー ",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/08/01","旅費交通費","",null,"課対仕入込8%",5000,null,"現金","",null,"対象外",5000,null,"JR ",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/08/23","荷造運賃","",null,"課対仕入込8%",540,null,"現金","",null,"対象外",540,null,"クロネコ運輸 ",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/09/20","広告宣伝費","",null,"課対仕入込8%",30000,null,"現金","",null,"対象外",30000,null,"今野デザイン ホームページ管理",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/09/21","交際費","",null,"課対仕入込8%",4000,null,"現金","",null,"対象外",4000,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/10/20","現金","",null,"対象外",24560,null,"普通預金","東灘信金／御影",null,"対象外",24560,null,"東灘信用金庫 預金より入金",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/11/11","荷造運賃","",null,"課対仕入込8%",940,null,"現金","",null,"対象外",940,null,"クロネコ運輸 ",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/11/12","交際費","",null,"課対仕入込8%",5400,null,"現金","",null,"対象外",5400,null,"坂本飯店 接待飲食",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/11/12","荷造運賃","",null,"課対仕入込8%",5400,null,"現金","",null,"対象外",5400,null,"一木運送 ",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/12/11","事務用品費","",null,"課対仕入込8%",500,null,"現金","",null,"対象外",500,null,"今津文具店 事務用品",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/12/28","旅費交通費","",null,"課対仕入込8%",525,null,"現金","",null,"対象外",525,null,"JR ",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2016/12/31","荷造運賃","",null,"課対仕入込8%",5400,null,"現金","",null,"対象外",5400,null,"一木運送 ",null,null,0,null,null,null,null,"no"]