{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["基本","領収書1","領収書２","支払調書","記載例"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":1,"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":21,"n_cols":61,"rows_kept":21,"cut":false,"hidden":false,"merged":[[10,11,16,14],[9,19,9,22],[3,22,3,23],[1,1,3,1],[5,1,6,1],[4,1,4,2],[7,2,7,3],[1,3,1,7],[5,3,5,4],[8,11,8,12],[6,3,6,7],[2,3,2,7],[8,2,8,3]]}
[null,"領収書・支払調書作成",null,null,"Ver.2.1",null,null,null,null,null,null,null,null,null,null,null,"算出例"]
[null,"支払者","氏名",null,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":"Q3","v":0},"×",0.1021,"）＝",{"$f":"ROUNDUP(Q3-(Q3*U3),0)","v":0}]
[null,null,"電話番号",null,null,null,null,null,null,null,null,"法人番号",null,{"$f":"LEN(M4)","v":0},null,null,"↑支払額（銀行からおろす額）",null,null,null,null,null,"↑講師に渡す額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N4<13,0,MID($M4,$N4-12,1))","v":0},{"$f":"IF($N4<12,0,MID($M4,$N4-11,1))","v":0},{"$f":"IF($N4<11,0,MID($M4,$N4-10,1))","v":0},{"$f":"IF($N4<10,0,MID($M4,$N4-9,1))","v":0},{"$f":"IF($N4<9,0,MID($M4,$N4-8,1))","v":0},{"$f":"IF($N4<8,0,MID($M4,$N4-7,1))","v":0},{"$f":"IF($N4<7,0,MID($M4,$N4-6,1))","v":0},{"$f":"IF($N4<6,0,MID($M4,$N4-5,1))","v":0},{"$f":"IF($N4<5,0,MID($M4,$N4-4,1))","v":0},{"$f":"IF($N4<4,0,MID($M4,$N4-3,1))","v":0},{"$f":"IF($N4<3,0,MID($M4,$N4-2,1))","v":0},{"$f":"IF($N4<2,0,MID($M4,$N4-1,1))","v":0},{"$f":"IF($N4<1,0,MID($M4,$N4,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUNDDOWN(Q3*U3,0)","v":0},"←税額"]
[null,null,"住所",null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(G6)","v":0},null,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":"IF($N7<13,0,MID($G6,$N7-12,1))","v":0},{"$f":"IF($N7<12,0,MID($G6,$N7-11,1))","v":0},{"$f":"IF($N7<11,0,MID($G6,$N7-10,1))","v":0},{"$f":"IF($N7<10,0,MID($G6,$N7-9,1))","v":0},{"$f":"IF($N7<9,0,MID($G6,$N7-8,1))","v":0},{"$f":"IF($N7<8,0,MID($G6,$N7-7,1))","v":0},{"$f":"IF($N7<7,0,MID($G6,$N7-6,1))","v":0},{"$f":"IF($N7<6,0,MID($G6,$N7-5,1))","v":0},{"$f":"IF($N7<5,0,MID($G6,$N7-4,1))","v":0},{"$f":"IF($N7<4,0,MID($G6,$N7-3,1))","v":0},{"$f":"IF($N7<3,0,MID($G6,$N7-2,1))","v":0},{"$f":"IF($N7<2,0,MID($G6,$N7-1,1))","v":0},{"$f":"IF($N7<1,0,MID($G6,$N7,1))","v":0}]
[null,"区 分","細 目",null,"支払額","源泉徴収額","手取り額","領収日",null,null,null,"発行する領収書"]
[null,"講師料","指導者料",null,{"$f":"SUM(E10:E21)","v":0},{"$f":"SUM(F10:F21)","v":0},{"$f":"SUM(G10:G21)","v":0},null,{"$f":"LEN(E9)","v":1},1,1,"９月分報酬",null,null,null,null,null,"÷（",100,"－",10.210000000000001,"）％＝",{"$f":"ROUNDDOWN(Q9/(1-0.1021),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I9<7,0,MID($E9,$I9-6,1))","v":0},{"$f":"IF($I9<6,0,MID($E9,$I9-5,1))","v":0},{"$f":"IF($I9<5,0,MID($E9,$I9-4,1))","v":0},{"$f":"IF($I9<4,0,MID($E9,$I9-3,1))","v":0},{"$f":"IF($I9<3,0,MID($E9,$I9-2,1))","v":0},{"$f":"IF($I9<2,0,MID($E9,$I9-1,1))","v":0},{"$f":"IF($I9<1,0,MID($E9,$I9,1))","v":"0"},null,null,{"$f":"IF($J9<7,0,MID($F9,$J9-6,1))","v":0},{"$f":"IF($J9<6,0,MID($F9,$J9-5,1))","v":0},{"$f":"IF($J9<5,0,MID($F9,$J9-4,1))","v":0},{"$f":"IF($J9<4,0,MID($F9,$J9-3,1))","v":0},{"$f":"IF($J9<3,0,MID($F9,$J9-2,1))","v":0},{"$f":"IF($J9<2,0,MID($F9,$J9-1,1))","v":0},{"$f":"IF($J9<1,0,MID($F9,$J9,1))","v":"0"}]
[1,"講師料","指導者料","１2月分報酬",{"$f":"INT(G10/0.8979)","v":0},{"$f":"E10-G10","v":0},null,null,1,1,0,null,null,null,null,null,"↑講師に渡す額",null,null,"支払額（銀行からおろす額）↑",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,"0",null,null,0,0,0,0,0,0,"0"]
[2,"講師料","指導者料","１月分報酬",{"$f":"INT(G11/0.8979)","v":0},{"$f":"E11-G11","v":0},null,null,2,1,0,"４枚ある支払調書のうち、左上の個人番号が記載されたものが税務署提出用です",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,"0","",null,null,0,0,0,0,0,0,"0"]
[3,"講師料","指導者料","２月分報酬",0,0,null,null,3,1,0,null,null,null,null,null,null,null,null,null,{"$f":"W9-Q9","v":0},"←税額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"0","","",null,null,0,0,0,0,0,0,"0"]
[4,"講師料","指導者料","３月分報酬",0,0,null,null,4]
[5,"講師料","指導者料","４月分報酬",0,0,null,null,5]
[6,"講師料","指導者料","５月分報酬",0,0,null,null,6]
[7,"講師料","指導者料","６月分報酬",0,0,null,null,7]
[8,"講師料","指導者料","７月分報酬",0,0,null,null,8]
[9,"講師料","指導者料","８月分報酬",0,0,null,null,9]
[10,"講師料","指導者料","９月分報酬",0,0,null,null,10]
[11,"講師料","指導者料","１０月分報酬",0,0,null,null,11,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",null,null,0,0,0,0,0,0,"0"]
[12,"講師料","指導者料","１１月分報酬",0,0,null,null,12,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",null,null,0,0,0,0,0,0,"0"]

{"sheet":"領収書1","index":1,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,11,2],[9,3,9,8],[7,2,7,7],[1,0,1,8],[10,7,10,8],[4,4,4,5],[2,7,2,8],[3,1,3,6],[9,1,9,2],[3,7,3,8],[8,2,8,5],[8,6,8,8],[11,3,11,5]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"基本!L9","v":"９月分報酬"},{"$f":"VLOOKUP(L1,基本!D10:K21,6,FALSE)","v":10},{"$f":"M1+9","v":19},"E","F","H","D"]
["領　 収　 証"]
[null,null,null,null,null,null,null,{"$f":"INDIRECT(\"基本!\"&$Q$1&$N1)","v":"00:00:00"}]
[null,{"$f":"基本!D2&\"　様\"","v":"　様"}]
[null,null,null,"￥",{"$f":"INDIRECT(\"基本!\"&$O$1&$N1)","v":0},null,"―"]
[]
[null,null,{"$f":"\"　但し、\"&INDIRECT(\"基本!\"&$R$1&$N1)&\"講師謝礼金として\"","v":"　但し、９月分報酬講師謝礼金として"}]
[null,null,{"$f":"\"(上記の金額に源泉徴収税　\"&INDIRECT(\"基本!\"&$P$1&$N1)&\"円を含む）\"","v":"(上記の金額に源泉徴収税　0円を含む）"}]
[]
[null,"住所",null,{"$f":"基本!D7","v":0}]
[]
[null,"氏名",null,{"$f":"基本!D6","v":0},null,null,"印"]

{"sheet":"領収書２","index":2,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,2,7,7],[11,1,11,2],[8,2,8,5],[8,6,8,8],[9,1,9,2],[10,7,10,8],[9,3,9,8],[11,3,11,5],[1,0,1,8],[2,7,2,8],[3,1,3,6],[3,7,3,8],[4,4,4,5]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"基本!L9","v":"９月分報酬"},{"$f":"VLOOKUP(L1,基本!D10:K21,6,FALSE)","v":10},{"$f":"M1+9","v":19},"E","F","H","D","G"]
["領　 収　 証"]
[null,null,null,null,null,null,null,{"$f":"INDIRECT(\"基本!\"&$Q$1&$N1)","v":"00:00:00"}]
[null,{"$f":"基本!D2&\"　様\"","v":"　様"}]
[null,null,null,"￥",{"$f":"INDIRECT(\"基本!\"&$S$1&$N1)","v":0},null,"―"]
[]
[null,null,{"$f":"\"　但し、\"&INDIRECT(\"基本!\"&$R$1&$N1)&\"講師謝礼金として\"","v":"　但し、９月分報酬講師謝礼金として"}]
[null,null,{"$f":"\"(上記の金額は源泉徴収税　\"&INDIRECT(\"基本!\"&$P$1&$N1)&\"円を控除後）\"","v":"(上記の金額は源泉徴収税　0円を控除後）"}]
[]
[null,"住所",null,{"$f":"基本!D7","v":0}]
[]
[null,"氏名",null,{"$f":"基本!D6","v":0},null,null,"印"]

{"sheet":"支払調書","index":3,"n_rows":37,"n_cols":67,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,49,34,53],[33,54,34,54],[33,55,34,55],[33,56,34,56],[33,57,34,57],[33,58,34,58],[33,59,34,59],[33,60,34,60],[14,60,15,60],[14,61,15,61],[14,62,15,62],[14,63,15,63],[14,64,15,64],[14,65,15,65],[14,66,15,66],[15,41,15,48],[22,41,22,48],[22,49,22,53],[17,54,17,66],[3,49,3,53],[14,41,14,48],[14,49,15,53],[14,54,15,54],[14,55,15,55],[14,56,15,56],[14,57,15,57],[14,58,15,58],[14,59,15,59],[36,1,36,6],[36,7,36,19],[36,20,36,32],[36,35,36,40],[36,41,36,53],[36,54,36,66],[33,31,34,31],[33,32,34,32],[32,1,34,3],[32,4,32,6],[32,7,32,32],[32,35,34,37],[32,38,32,40],[32,41,32,66],[33,4,34,6],[33,7,33,14],[33,23,34,23],[33,24,34,24],[33,25,34,25],[33,26,34,26],[33,15,34,19],[33,20,34,20],[33,21,34,21],[33,22,34,22],[33,61,34,61],[33,62,34,62],[33,63,34,63],[29,1,29,6],[29,7,29,14],[29,35,29,40],[29,41,29,48],[31,1,31,32],[31,35,31,66],[33,38,34,40],[33,27,34,27],[33,28,34,28],[33,29,34,29],[33,30,34,30],[34,7,34,14],[30,1,30,6],[30,7,30,14],[30,35,30,40],[33,64,34,64],[33,65,34,65],[33,66,34,66],[34,41,34,48],[30,41,30,48],[33,41,33,48],[28,1,28,6],[28,7,28,14],[28,35,28,40],[28,41,28,48],[9,7,9,14],[10,7,10,14],[11,7,11,14],[17,1,17,6],[17,7,17,19],[17,20,17,32],[14,15,15,19],[12,1,12,32],[14,20,15,20],[14,21,15,21],[14,22,15,22],[14,23,15,23],[13,1,15,3],[14,4,15,6],[14,7,14,14],[15,7,15,14],[14,32,15,32],[14,24,15,24],[14,25,15,25],[14,26,15,26],[1,35,1,66],[2,35,3,37],[2,38,2,40],[2,41,2,66],[3,38,3,40],[14,31,15,31],[14,28,15,28],[14,29,15,29],[4,58,4,66],[1,1,1,32],[2,1,3,3],[2,4,2,6],[3,4,3,6],[2,7,2,32],[3,7,3,14],[3,15,3,19],[4,7,4,14],[3,41,3,48],[4,49,4,57],[6,35,6,40],[6,41,6,48],[13,7,13,32],[11,1,11,6],[10,1,10,6],[4,1,4,6],[9,41,9,48],[10,35,10,40],[10,41,10,48],[9,1,9,6],[7,35,7,40],[7,41,7,48],[8,35,8,40],[4,15,4,23],[4,24,4,32],[7,1,7,6],[6,1,6,6],[6,7,6,14],[7,7,7,14],[4,35,4,40],[8,41,8,48],[4,41,4,48],[8,7,8,14],[14,30,15,30],[14,27,15,27],[13,4,13,6],[22,38,22,40],[23,49,23,57],[23,58,23,66],[20,1,20,32],[20,35,20,66],[8,1,8,6],[21,1,22,3],[21,4,21,6],[21,7,21,32],[21,35,22,37],[21,38,21,40],[21,41,21,66],[22,4,22,6],[11,35,11,40],[11,41,11,48],[12,35,12,66],[13,35,15,37],[13,38,13,40],[13,41,13,66],[14,38,15,40],[9,35,9,40],[27,1,27,6],[27,7,27,14],[27,35,27,40],[27,41,27,48],[26,1,26,6],[26,7,26,14],[26,35,26,40],[26,41,26,48],[17,35,17,40],[17,41,17,53],[25,1,25,6],[25,7,25,14],[23,1,23,6],[23,7,23,14],[23,15,23,23],[23,24,23,32],[25,35,25,40],[25,41,25,48],[23,35,23,40],[23,41,23,48],[22,7,22,14],[22,15,22,19]]}
[]
[null,{"$f":"\"令和 \"&基本!L2&\" 年分　報酬、料金、契約金及び賞金の支払調書\"","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,{"$f":"\"令和 \"&基本!L2&\" 年分　報酬、料金、契約金及び賞金の支払調書\"","v":"令和  年分　報酬、料金、契約金及び賞金の支払調書"}]
[null,"支払を\n受ける者",null,null,"住所（居所）\n又は所在地",null,null,{"$f":"基本!D7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支払を\n受ける者",null,null,"住所（居所）\n又は所在地",null,null,{"$f":"基本!D7","v":0}]
[null,null,null,null,"氏名又は\n名    称",null,null,{"$f":"基本!D6","v":0},null,null,null,null,null,null,null,"個人番号又は\n法 人 番 号",null,null,null,null,{"$f":"基本!$AN$7","v":0},{"$f":"基本!$AO$7","v":0},{"$f":"基本!$AP$7","v":0},{"$f":"基本!$AQ$7","v":0},{"$f":"基本!$AR$7","v":0},{"$f":"基本!$AS$7","v":0},{"$f":"基本!$AT$7","v":0},{"$f":"基本!$AU$7","v":0},{"$f":"基本!$AV$7","v":0},{"$f":"基本!$AW$7","v":0},{"$f":"基本!$AX$7","v":0},{"$f":"基本!$AY$7","v":0},{"$f":"基本!$AZ$7","v":0},null,null,null,null,null,"氏名又は\n名    称",null,null,{"$f":"基本!D6","v":0},null,null,null,null,null,null,null,"個人番号又は\n法 人 番 号"]
[null,"区　　分",null,null,null,null,null,"細　　　　目",null,null,null,null,null,null,null,"支　払　金　額",null,null,null,null,null,null,null,null,"源泉徴収税額",null,null,null,null,null,null,null,null,null,null,"区　　分",null,null,null,null,null,"細　　　　目",null,null,null,null,null,null,null,"支　払　金　額",null,null,null,null,null,null,null,null,"源泉徴収税額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"内",null,null,null,null,"千",null,null,"円","内",null,null,null,null,"千",null,null,"円",null,null,null,null,null,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":"IF(基本!$B9=\"\",\"\",基本!$B9)","v":"講師料"},null,null,null,null,null,{"$f":"IF(基本!$C9=\"\",\"\",基本!$C9)","v":"指導者料"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(基本!$AU9=0,\"\",基本!$AU9)","v":""},{"$f":"基本!$AV9","v":0},{"$f":"基本!$AW9","v":0},{"$f":"基本!$AX9","v":0},{"$f":"基本!$AY9","v":0},{"$f":"IF(基本!$E9=0,\"\",基本!$AZ9)","v":""},null,null,null,{"$f":"基本!$BD9","v":0},{"$f":"基本!$BE9","v":0},{"$f":"基本!$BF9","v":0},{"$f":"基本!$BG9","v":0},{"$f":"基本!$BH9","v":0},{"$f":"IF(基本!$E9=0,\"\",基本!$BI9)","v":""},null,null,{"$f":"IF(基本!$B9=\"\",\"\",基本!$B9)","v":"講師料"},null,null,null,null,null,{"$f":"IF(基本!$C9=\"\",\"\",基本!$C9)","v":"指導者料"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(基本!$AU9=0,\"\",基本!$AU9)","v":""},{"$f":"基本!$AV9","v":0},{"$f":"基本!$AW9","v":0},{"$f":"基本!$AX9","v":0},{"$f":"基本!$AY9","v":0},{"$f":"IF(基本!$E9=0,\"\",基本!$AZ9)","v":""},null,null,null,{"$f":"基本!$BD9","v":0},{"$f":"基本!$BE9","v":0},{"$f":"基本!$BF9","v":0},{"$f":"基本!$BG9","v":0},{"$f":"基本!$BH9","v":0},{"$f":"IF(基本!$E9=0,\"\",基本!$BI9)","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,"住所（居所）\n又は所在地",null,null,{"$f":"基本!D3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支払者",null,null,"住所（居所）\n又は所在地",null,null,{"$f":"基本!D3","v":0}]
[null,null,null,null,"氏名又は\n名    称",null,null,{"$f":"基本!D2","v":0},null,null,null,null,null,null,null,"個人番号又は\n法 人 番 号",null,null,null,null,{"$f":"基本!$AN$4","v":0},{"$f":"基本!$AO$4","v":0},{"$f":"基本!$AP$4","v":0},{"$f":"基本!$AQ$4","v":0},{"$f":"基本!$AR$4","v":0},{"$f":"基本!$AS$4","v":0},{"$f":"基本!$AT$4","v":0},{"$f":"基本!$AU$4","v":0},{"$f":"基本!$AV$4","v":0},{"$f":"基本!$AW$4","v":0},{"$f":"基本!$AX$4","v":0},{"$f":"基本!$AY$4","v":0},{"$f":"基本!$AZ$4","v":0},null,null,null,null,null,"氏名又は\n名    称",null,null,{"$f":"基本!D2","v":0},null,null,null,null,null,null,null,"個人番号又は\n法 人 番 号",null,null,null,null,{"$f":"基本!$AN$4","v":0},{"$f":"基本!$AO$4","v":0},{"$f":"基本!$AP$4","v":0},{"$f":"基本!$AQ$4","v":0},{"$f":"基本!$AR$4","v":0},{"$f":"基本!$AS$4","v":0},{"$f":"基本!$AT$4","v":0},{"$f":"基本!$AU$4","v":0},{"$f":"基本!$AV$4","v":0},{"$f":"基本!$AW$4","v":0},{"$f":"基本!$AX$4","v":0},{"$f":"基本!$AY$4","v":0},{"$f":"基本!$AZ$4","v":0}]
[null,null,null,null,null,null,null,{"$f":"\"(電話) \"&基本!D4","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,{"$f":"\"(電話) \"&基本!D4","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,{"$f":"B2","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,{"$f":"AJ2","v":"令和  年分　報酬、料金、契約金及び賞金の支払調書"}]
[null,"支払を\n受ける者",null,null,"住所（居所）\n又は所在地",null,null,{"$f":"H3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支払を\n受ける者",null,null,"住所（居所）\n又は所在地",null,null,{"$f":"AP3","v":0}]
[null,null,null,null,"氏名又は\n名    称",null,null,{"$f":"H4","v":0},null,null,null,null,null,null,null,"個人番号又は\n法 人 番 号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"氏名又は\n名    称",null,null,{"$f":"AP4","v":0},null,null,null,null,null,null,null,"個人番号又は\n法 人 番 号",null,null,null,null,{"$f":"BC4","v":0},{"$f":"BD4","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"区　　分",null,null,null,null,null,"細　　　　目",null,null,null,null,null,null,null,"支　払　金　額",null,null,null,null,null,null,null,null,"源泉徴収税額",null,null,null,null,null,null,null,null,null,null,"区　　分",null,null,null,null,null,"細　　　　目",null,null,null,null,null,null,null,"支　払　金　額",null,null,null,null,null,null,null,null,"源泉徴収税額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"内",null,null,null,null,"千",null,null,"円","内",null,null,null,null,"千",null,null,"円",null,null,null,null,null,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":"B7","v":"講師料"},null,null,null,null,null,{"$f":"H7","v":"指導者料"},null,null,null,null,null,null,null,null,null,null,{"$f":"S7","v":""},{"$f":"T7","v":0},0,0,0,"",0,0,0,0,0,0,0,0,"",null,null,{"$f":"AJ7","v":"講師料"},null,null,null,null,null,{"$f":"AP7","v":"指導者料"},null,null,null,null,null,null,null,null,null,null,{"$f":"BA7","v":""},{"$f":"BB7","v":0},0,0,0,"",0,0,0,0,0,0,0,0,""]
[]
[]
[]
[]
[]
[null,"（摘要）　",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（摘要）　"]
[null,"支払者",null,null,"住所（居所）\n又は所在地",null,null,{"$f":"H14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支払者",null,null,"住所（居所）\n又は所在地",null,null,{"$f":"H14","v":0}]
[null,null,null,null,"氏名又は\n名    称",null,null,{"$f":"H15","v":0},null,null,null,null,null,null,null,"個人番号又は\n法 人 番 号",null,null,null,null,{"$f":"U15","v":0},{"$f":"V15","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,"氏名又は\n名    称",null,null,{"$f":"H15","v":0},null,null,null,null,null,null,null,"個人番号又は\n法 人 番 号",null,null,null,null,{"$f":"U15","v":0},{"$f":"BD15","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H16","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,{"$f":"H16","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,"　②"]

{"sheet":"記載例","index":4,"n_rows":21,"n_cols":61,"rows_kept":21,"cut":false,"hidden":false,"merged":[[9,19,9,22],[10,11,16,14],[3,22,3,23],[4,1,4,2],[7,2,7,3],[8,2,8,3],[8,11,8,12],[5,1,6,1],[5,3,5,4],[6,3,6,7],[1,1,3,1],[1,3,1,7],[2,3,2,7]]}
[null,"領収書・支払調書作成",null,null,"Ver.1.0",null,null,null,null,null,null,null,null,null,null,null,"算出例"]
[null,"支払者","氏名","〇〇中学校▲▲クラブ",null,null,null,null,null,null,null,8,"年度"]
[null,null,"住所","浜松市□□区〇〇町１－２",null,null,null,null,null,null,null,null,null,null,null,null,13364,"－（",{"$f":"Q3","v":13364},"×",0.1021,"）＝",{"$f":"ROUNDUP(Q3-(Q3*U3),0)","v":12000}]
[null,null,"電話番号","０９０－１２３－４５６７",null,null,null,null,null,null,null,"法人番号",null,{"$f":"LEN(M4)","v":0},null,null,"↑支払額（銀行からおろす額）",null,null,null,null,null,"↑講師に渡す額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N4<13,0,MID($M4,$N4-12,1))","v":0},{"$f":"IF($N4<12,0,MID($M4,$N4-11,1))","v":0},{"$f":"IF($N4<11,0,MID($M4,$N4-10,1))","v":0},{"$f":"IF($N4<10,0,MID($M4,$N4-9,1))","v":0},{"$f":"IF($N4<9,0,MID($M4,$N4-8,1))","v":0},{"$f":"IF($N4<8,0,MID($M4,$N4-7,1))","v":0},{"$f":"IF($N4<7,0,MID($M4,$N4-6,1))","v":0},{"$f":"IF($N4<6,0,MID($M4,$N4-5,1))","v":0},{"$f":"IF($N4<5,0,MID($M4,$N4-4,1))","v":0},{"$f":"IF($N4<4,0,MID($M4,$N4-3,1))","v":0},{"$f":"IF($N4<3,0,MID($M4,$N4-2,1))","v":0},{"$f":"IF($N4<2,0,MID($M4,$N4-1,1))","v":0},{"$f":"IF($N4<1,0,MID($M4,$N4,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[null,"支払を受ける者","氏名","あいうえお",null,"個人番号",123456789123,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(Q3*U3,0)","v":1364},"←税額"]
[null,null,"住所","浜松市中央区１－２－３",null,null,null,null,null,null,null,null,null,{"$f":"LEN(G6)","v":12},null,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":"IF($N7<13,0,MID($G6,$N7-12,1))","v":0},{"$f":"IF($N7<12,0,MID($G6,$N7-11,1))","v":"1"},{"$f":"IF($N7<11,0,MID($G6,$N7-10,1))","v":"2"},{"$f":"IF($N7<10,0,MID($G6,$N7-9,1))","v":"3"},{"$f":"IF($N7<9,0,MID($G6,$N7-8,1))","v":"4"},{"$f":"IF($N7<8,0,MID($G6,$N7-7,1))","v":"5"},{"$f":"IF($N7<7,0,MID($G6,$N7-6,1))","v":"6"},{"$f":"IF($N7<6,0,MID($G6,$N7-5,1))","v":"7"},{"$f":"IF($N7<5,0,MID($G6,$N7-4,1))","v":"8"},{"$f":"IF($N7<4,0,MID($G6,$N7-3,1))","v":"9"},{"$f":"IF($N7<3,0,MID($G6,$N7-2,1))","v":"1"},{"$f":"IF($N7<2,0,MID($G6,$N7-1,1))","v":"2"},{"$f":"IF($N7<1,0,MID($G6,$N7,1))","v":"3"}]
[null,"区 分","細 目",null,"支払額","源泉徴収額","手取り額","領収日",null,null,null,"発行する領収書"]
[null,"講師料","指導者料",null,{"$f":"INT(G9/0.8979)","v":160374},{"$f":"E9-G9","v":16374},{"$f":"SUM(G10:G21)","v":144000},null,{"$f":"LEN(E9)","v":6},5,6,"９月分報酬",null,null,null,null,12000,"÷（",100,"－",10.210000000000001,"）％＝",{"$f":"ROUNDDOWN(Q9/(1-0.1021),0)","v":13364},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I9<7,0,MID($E9,$I9-6,1))","v":0},{"$f":"IF($I9<6,0,MID($E9,$I9-5,1))","v":"1"},{"$f":"IF($I9<5,0,MID($E9,$I9-4,1))","v":"6"},{"$f":"IF($I9<4,0,MID($E9,$I9-3,1))","v":"0"},{"$f":"IF($I9<3,0,MID($E9,$I9-2,1))","v":"3"},{"$f":"IF($I9<2,0,MID($E9,$I9-1,1))","v":"7"},{"$f":"IF($I9<1,0,MID($E9,$I9,1))","v":"4"},null,null,{"$f":"IF($J9<7,0,MID($F9,$J9-6,1))","v":0},{"$f":"IF($J9<6,0,MID($F9,$J9-5,1))","v":0},{"$f":"IF($J9<5,0,MID($F9,$J9-4,1))","v":"1"},{"$f":"IF($J9<4,0,MID($F9,$J9-3,1))","v":"6"},{"$f":"IF($J9<3,0,MID($F9,$J9-2,1))","v":"3"},{"$f":"IF($J9<2,0,MID($F9,$J9-1,1))","v":"7"},{"$f":"IF($J9<1,0,MID($F9,$J9,1))","v":"4"}]
[1,"講師料","指導者料","１2月分報酬",13364,1364,12000,"2026-01-20",1,4,5,null,null,null,null,null,"↑講師に渡す額",null,null,"支払額（銀行からおろす額）↑",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,"1",null,null,0,0,0,"1","3","6","4"]
[2,"講師料","指導者料","１月分報酬",13364,1364,12000,"2026-02-20",2,4,5,"４枚ある支払調書のうち、左上の個人番号が記載されたものが税務署提出用です",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,"1","3",null,null,0,0,0,"1","3","6","4"]
[3,"講師料","指導者料","２月分報酬",13364,1364,12000,"2026-03-20",3,4,5,null,null,null,null,null,null,null,null,null,{"$f":"W9-Q9","v":1364},"←税額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"1","3","3",null,null,0,0,0,"1","3","6","4"]
[4,"講師料","指導者料","３月分報酬",13364,1364,12000,"2026-04-20",4]
[5,"講師料","指導者料","４月分報酬",13364,1364,12000,"2026-05-20",5]
[6,"講師料","指導者料","５月分報酬",13364,1364,12000,"2026-06-20",6]
[7,"講師料","指導者料","６月分報酬",13364,1364,12000,"2026-07-20",7]
[8,"講師料","指導者料","７月分報酬",13364,1364,12000,"2026-08-20",8]
[9,"講師料","指導者料","８月分報酬",13364,1364,12000,"2026-09-20",9]
[10,"講師料","指導者料","９月分報酬",13364,1364,12000,"2026-10-20",10]
[11,"講師料","指導者料","１０月分報酬",13364,1364,12000,"2026-11-20",11,4,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4","","","","","","",null,null,0,0,0,"1","3","6","4"]
[12,"講師料","指導者料","１１月分報酬",13364,1364,12000,"2026-12-20",12,4,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",null,null,0,0,0,"1","3","6","4"]