{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["限度額設定型貿易保険（船積後）損失等発生通知書","別紙","記入要領"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":4,"defined_names":12,"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":47,"n_cols":30,"rows_kept":47,"cut":false,"hidden":false,"merged":[[33,0,33,29],[18,24,18,29],[18,6,18,17],[21,10,21,19],[21,20,21,29],[24,0,24,29],[25,1,25,5],[25,6,25,29],[22,1,22,9],[22,10,22,19],[22,20,22,29],[19,19,19,23],[21,1,21,9],[20,1,20,5],[20,6,20,9],[20,10,20,19],[34,0,34,29],[36,0,36,29],[40,0,40,29],[39,0,39,29],[38,0,38,29],[37,0,37,29],[46,20,46,22],[46,24,46,25],[46,27,46,28],[41,0,41,29],[35,0,35,29],[43,0,44,0],[43,1,43,4],[43,5,43,15],[43,16,43,19],[43,20,43,29],[44,1,44,4],[44,5,44,15],[44,16,44,19],[44,20,44,29],[2,0,2,29],[29,1,29,5],[26,1,26,5],[27,1,27,5],[30,1,30,9],[29,6,29,29],[26,6,26,29],[28,22,28,29],[27,6,27,29],[14,6,14,29],[18,19,18,23],[9,19,9,29],[10,17,10,29],[11,17,11,22],[17,19,17,23],[17,24,17,29],[11,23,11,29],[4,20,4,22],[4,24,4,25],[4,27,4,28],[9,17,9,18],[7,29,8,29],[8,21,8,28],[7,21,7,28],[18,1,18,5],[28,1,28,9],[19,1,19,5],[14,1,14,5],[31,6,31,29],[17,1,17,5],[17,6,17,17],[16,0,16,29],[20,20,20,29],[19,6,19,17],[19,24,19,29],[31,1,31,5],[28,17,28,21]]}
["別紙様式第８－２"]
[]
["限度額設定型貿易保険（船積後）損失等発生通知書"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"提出日",null,null,null,null,null,"年",null,null,"月",null,null,"日"]
["株式会社日本貿易保険　御中"]
[null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"被保険者名",null,null,null,null,null,null,null,null,null,null,null,"印"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者氏名"]
[null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,"住所"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"保険利用者コード"]
[]
[]
[1,"保険証券番号"]
[]
["輸出契約等の情報及び損失発生額　（「別紙」を作成する場合は記入不要）"]
[{"$f":"A15+1","v":2},"輸出契約等番号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A18+1","v":3},"輸出契約等締結日"]
[{"$f":"S18+1","v":4},"事故発生日（決済期限）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A19+1","v":5},"船積日"]
[{"$f":"S19+1","v":6},"支払人",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A20+1","v":7},"支払国"]
[{"$f":"S20+1","v":8},"契約通貨",null,null,null,null,null,null,null,null,"契約元本",null,null,null,null,null,null,null,null,null,"契約金利"]
[{"$f":"A21+1","v":9},"輸出契約等に基づく代金等の額"]
[{"$f":"A22+1","v":10},"損失発生額（建値）"]
[]
["案件概要等"]
[{"$f":"A23+1","v":11},"案件概要"]
[{"$f":"A26+1","v":12},"品名（貨物名）"]
[{"$f":"A27+1","v":13},"決済条件（方法）"]
[{"$f":"A28+1","v":14},"保証金等、担保の受領の有無",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A29+1","v":15},"保証金等の金額"]
[{"$f":"Q29+1","v":16},"保証金等の内容"]
[{"$f":"A30+1","v":17},"クレームの有無"]
[{"$f":"A31+1","v":18},"クレームの内容"]
[]
["損失等発生に至った経緯等"]
["(事故発生に至った経緯)"]
[]
["(本通知提出までに実施されたこと)"]
[]
["(今後の見込みや対応予定)"]
[]
["（本通知書の提出が損失等が発生してから45日を超えた場合は、通知書の提出が遅滞した理由を記入してください。）"]
[]
[]
["連絡先","担当部署名",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"担当者名"]
[null,"E-mail アドレス",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"電話番号"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NEXI記入欄",null,null,null,"受理日：",null,null,null,null,null,"年","　",null,"月",null,null,"日"]

{"sheet":"別紙","index":1,"n_rows":60,"n_cols":26,"rows_kept":60,"cut":false,"hidden":false,"merged":[[55,1,55,2],[55,3,55,4],[12,14,12,25],[13,15,13,16],[13,18,13,19],[13,20,13,21],[13,22,13,23],[13,24,13,25],[10,14,10,15],[1,1,1,12],[5,14,5,15],[6,14,6,15],[7,2,7,3],[8,2,8,3]]}
[null,null,"別紙"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"証　券　番　号",null,{"$f":"E8","v":0},null,null,null,null,null,null,null,"　被保険者シッパーコード",{"$f":"K7","v":0}]
[null,null,null,null,null,null,null,null,null,"　被保険者シッパーコード",null,null,null,null,"保険契約締結日",null,{"$f":"E9","v":"00:00:00"}]
[null,null,"証　券　番　号",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(tsuuchiRange=\"\",\"\",tsuuchiRange)","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,"事故\n通番","輸出契約等番号","輸出契約等の相手方\nのバイヤーコード","支払国の国コード","輸出契約等締結日","船積（予定）日","事故発生日\n（決済期限）","通貨コード","輸出契約等に基づく\n代金等の額　　　①","輸出契約等締結日\nTTBレート　　②","保険価額\n(①×②)③",{"$f":"IF($E$9=\"\",\"保険金額\n（③×90%)\",IF($E$9>=DATE(2007,4,1),\"保険金額\n（③×90%）\",\"保険金額\n（③×95%）\"))","v":"保険金額\n（③×90%)"},null,"事故通番","元本","金利","決済日レート","契約元本\n(対外債権ﾍﾞｰｽ)","契約金利\n(対外債権ﾍﾞｰｽ)","契約元本\n(対外債権ﾍﾞｰｽ)","契約金利\n(対外債権ﾍﾞｰｽ)","契約元本\n(対外債権ﾍﾞｰｽ)","契約金利\n(対外債権ﾍﾞｰｽ)","契約元本\n(対外債権ﾍﾞｰｽ)","契約金利\n(対外債権ﾍﾞｰｽ)"]
[null,1,null,null,null,null,null,null,null,null,null,{"$f":"J16*K16","v":0},{"$f":"L16*0.9","v":0},null,1]
[null,{"$f":"B16+1","v":2},null,null,null,null,null,null,null,null,null,{"$f":"J17*K17","v":0},{"$f":"L17*0.9","v":0},null,2]
[null,3,null,null,null,null,null,null,null,null,null,0,0,null,3]
[null,4,null,null,null,null,null,null,null,null,null,0,0,null,4]
[null,5,null,null,null,null,null,null,null,null,null,0,0,null,5]
[null,6,null,null,null,null,null,null,null,null,null,0,0,null,6]
[null,7,null,null,null,null,null,null,null,null,null,0,0,null,7]
[null,8,null,null,null,null,null,null,null,null,null,0,0,null,8]
[null,9,null,null,null,null,null,null,null,null,null,0,0,null,9]
[null,10,null,null,null,null,null,null,null,null,null,0,0,null,10]
[null,11,null,null,null,null,null,null,null,null,null,0,0,null,11]
[null,12,null,null,null,null,null,null,null,null,null,0,0,null,12]
[null,13,null,null,null,null,null,null,null,null,null,0,0,null,13]
[null,14,null,null,null,null,null,null,null,null,null,0,0,null,14]
[null,15,null,null,null,null,null,null,null,null,null,0,0,null,15]
[null,16,null,null,null,null,null,null,null,null,null,0,0,null,16]
[null,17,null,null,null,null,null,null,null,null,null,0,0,null,17]
[null,18,null,null,null,null,null,null,null,null,null,0,0,null,18]
[null,19,null,null,null,null,null,null,null,null,null,0,0,null,19]
[null,20,null,null,null,null,null,null,null,null,null,0,0,null,20]
[null,null,null,null,null,null,null,null,null,null,"計",{"$f":"SUM(L16:L35)","v":0},{"$f":"SUM(M16:M35)","v":0},null,null,null,"計",null,{"$f":"SUM(S16:S35)","v":0},0,0,0,0,0,0,0]
[]
[null,"３．輸出契約等内容変更通知"]
[null,"整理\n番号","通知済輸出契約等番号","変更輸出契約等番号","輸出契約等の相手方\nのバイヤーコード","支払国の国コード","輸出契約等締結日","契約変更日","通貨コード","輸出契約等の変更額\n①","輸出契約等変更日\nTTBレート　　②","保険価額\n(①×②)③",{"$f":"IF($E$9=\"\",\"保険金額\n（③×90%)\",IF($E$9>=DATE(2007,4,1),\"保険金額\n（③×90%）\",\"保険金額\n（③×95%）\"))","v":"保険金額\n（③×90%)"}]
[null,1,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(J40*K40,0)","v":0},{"$f":"IF($E$9=\"\",ROUNDDOWN(L40*0.9,0),IF($E$9>=DATE(2007,4,1),ROUNDDOWN(L40*0.9,0),ROUNDDOWN(L40*0.95,0)))","v":0}]
[null,{"$f":"B40+1","v":2},null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(J41*K41,0)","v":0},{"$f":"IF($E$9=\"\",ROUNDDOWN(L41*0.9,0),IF($E$9>=DATE(2007,4,1),ROUNDDOWN(L41*0.9,0),ROUNDDOWN(L41*0.95,0)))","v":0}]
[null,{"$f":"B41+1","v":3},null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(J42*K42,0)","v":0},{"$f":"IF($E$9=\"\",ROUNDDOWN(L42*0.9,0),IF($E$9>=DATE(2007,4,1),ROUNDDOWN(L42*0.9,0),ROUNDDOWN(L42*0.95,0)))","v":0}]
[null,{"$f":"B42+1","v":4},null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(J43*K43,0)","v":0},{"$f":"IF($E$9=\"\",ROUNDDOWN(L43*0.9,0),IF($E$9>=DATE(2007,4,1),ROUNDDOWN(L43*0.9,0),ROUNDDOWN(L43*0.95,0)))","v":0}]
[null,{"$f":"B43+1","v":5},null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(J44*K44,0)","v":0},{"$f":"IF($E$9=\"\",ROUNDDOWN(L44*0.9,0),IF($E$9>=DATE(2007,4,1),ROUNDDOWN(L44*0.9,0),ROUNDDOWN(L44*0.95,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"計",{"$f":"SUM(L40:L44)","v":0},{"$f":"SUM(M40:M44)","v":0}]
[null,"４．通知額（保険金額）累計"]
[null,null,"１月通知額",null,"７月通知額",null,null,null,null,null,"当月合計",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,"通知額累計",{"$f":"SUM(F47:F52)+SUM(D47:D52)","v":0},"……Ｂ",null,null,"E-mail："]
[null,null,null,null,null,null,null,null,null,"その他通信欄"]
[null,"５．引受保険金額上限額残"]
[null,"Ａ－Ｂ＝",null,{"$f":"E12-F53","v":0}]
[]
[null,"（注）　１．本通知書「別紙様式第４－１」に通知すべき輸出契約等の内容が記載しきれない場合は、「別紙様式第４－２」をご使用下さい。"]
[null,"　　　  ２．本通知書の他に「別紙様式第４－２」もご使用の場合は、本通知書との合計額を ４．通知額（保険金額）累計 にご記入下さい。"]
[null,"  　　  ３．輸出契約等ごとの保険金支払いの上限は、当該保険金額となるため、額、レートは正確にご記入下さい。"]

{"sheet":"記入要領","index":2,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[35,1,35,12],[25,2,25,12],[27,2,27,12],[29,2,29,12],[31,2,31,12],[33,1,33,12],[23,2,23,12],[10,2,10,12],[0,0,0,12],[2,2,2,12],[4,2,4,12],[6,2,6,12],[8,2,8,12],[12,2,12,12],[14,2,14,12],[16,2,16,12],[18,2,18,12],[20,0,21,0],[20,1,21,1],[20,2,20,12],[21,2,21,12]]}
["記入要領",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　"]
[]
["①","提出日","日本貿易保険へ提出する日を西暦で記入してください。"]
[]
[{"$f":"CHAR(CODE(A3)+1)","v":"②"},"被保険者名\n代表者氏名\n住所","必要に応じて行を加減し記入してください。\n「被保険者名」は本通知を提出する法人名を、「代表者氏名」は「被保険者」を代表する方（代表取締役社長等）の氏名を記入し、代表者印（丸印）を押印してください。\n貿易保険に係る手続きの代理人登録をしている場合は、該当者の役職及び氏名を記載し、登録済みの代理人印を押印してください。"]
[]
[{"$f":"CHAR(CODE('[4]記入要領（別紙様式第8-1 ）'!A5)+1)","v":"③"},"１．保険証券番号","保険証券の確認し、記入してください。"]
[]
[{"$f":"CHAR(CODE(A7)+1)","v":"④"},"２．輸出契約等番号\n３．輸出契約等締結日","実際の輸出契約等をご確認の上、ご記入ください。\n輸出契約等締結日は、限度額設定型貿易保険運用規程第９条（輸出契約等の締結日）を確認し、記入してください。"]
[]
[{"$f":"CHAR(CODE(A9)+1)","v":"⑤"},"４．事故発生日（決済期限）","対象となる輸出契約等で今回の未決済分に対応する決済期限を西暦で記入してください。\nなお、損失等発生通知書は保険証券番号の決済期限ごとに提出してください。"]
[]
[{"$f":"CHAR(CODE(A11)+1)","v":"⑥"},"５．船積日","船積書類を確認し、記入してください。"]
[]
[{"$f":"CHAR(CODE(A13)+1)","v":"⑦"},"６．支払人\n７．支払国","輸出等契約書及び保険証券を確認し記入してください。"]
[]
[{"$f":"CHAR(CODE(A15)+1)","v":"⑧"},"８．契約通貨","保険証券に記載された通貨を記入してください。"]
[]
[{"$f":"CHAR(CODE(A17)+1)","v":"⑨"},"９．輸出契約等に基づく\n代金等の額","輸出等契約書を確認し、契約元本と契約金利（※）に分けて記入してください。\n※契約金利は、輸出契約等で定めるユーザンス等に設定される金利または利息をいいます。"]
[]
[{"$f":"CHAR(CODE(A19)+1)","v":"⑩"},"１０．損失発生額（建値）","通知書を提出する時点での未決済額を、契約元本と契約金利（遅滞金利を除く）に分けて記入してください。\n【今回の決済期限までに決済されるべき金額】－【決済期限前及び決済期限到来後入金された金額】＝「１０．損失発生額（建値）」\n\n輸出契約等の変更により、「今回の決済期限までに決済されるべき金額」が変更となった場合は、変更後の元本及び金利から、決済期限前及び決済期限到来後入金された金額を差し引いてください。"]
[null,null,"金額の記入において、通貨が円建ての場合には、小数点以下は記入しないでください。\n円以外の通貨建ての場合には、小数点以下２桁（３桁以下は切り捨て）まで記入してください。"]
[]
[{"$f":"CHAR(CODE(A21)+1)","v":"⑪"},"１１．案件概要","取引開始の経緯や商流等できるだけ詳細に記入してください。"]
[]
[{"$f":"CHAR(CODE(A24)+1)","v":"⑫"},"１２．品名（貨物名）\n１３．決済条件（方法）","保険申込書、輸出等契約書、インボイス等を確認し記入してください。"]
[]
[{"$f":"CHAR(CODE(A26)+1)","v":"⑬"},"１４．保証金等、\n担保の受領の有無","輸出契約等の相手方や第三者から保証金、預かり金、担保等について、保証金等を預かっている場合には「有」を、該当が無い場合には「無」を選択してください。\nまた、「有」の場合は「１５．保証金等の金額」及び「１６．保証金等の内容」を記入してください。"]
[]
[{"$f":"CHAR(CODE(A28)+1)","v":"⑭"},"１７．クレームの有無","輸出契約等の相手方からクレームがある場合には「有」を、無い場合には「無」を選択してください。\nまた、「有」の場合は「１８．クレームの内容」を記入してください。"]
[]
[{"$f":"CHAR(CODE(A30)+1)","v":"⑮"},"損失等発生に至った経緯等","できるだけ詳細に記入してください。"]