{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["基本情報","請求書内訳","依頼書","請求書","マクロを有効化してください"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["日本建設株式会社　取引代金受領に関する依頼書・請求書　基本情報"]
[]
[null,null,{"$f":"IF(AND($D$6<>14,$D$5=1),\"登録番号の文字数が不正です。\",\"\")","v":"登録番号の文字数が不正です。"},null,null,"（入力例等）"]
[null,"取引先コード（新規依頼書は入力不要）",null,null,null,123456,"6桁(不明な場合省略可)"]
[null,"事業者区分",null,1,null,"どちらか選択"]
[null,"適格請求書発行事業者登録番号",null,{"$f":"LEN($C$6)","v":0},null,"T1234567890123","課税事業者のみ入力(T＋13桁の数字）"]
[null,"会社名（フリガナ）",null,null,null,"サンプルケンセツ（カ"]
[null,"会社名",null,null,null,"さんぷる建設株式会社"]
[null,"代表者名（フリガナ）",null,null,null,"ニッケンタロウ"]
[null,"代表者名",null,null,null,"代表取締役　日建太郎"]
[null,"郵便番号",null,null,null,"100-0000"]
[null,"住所１",null,null,null,"東京都千代田区八番町99番地"]
[null,"住所２（ビル名等）",null,null,null,"□□□□ビル"]
[null,"電話番号",null,null,null,"03-0000-0000"]
[null,"FAX番号",null,null,null,"03-0000-0000"]
[null,"振込銀行名（フリガナ）",null,null,null,"ミツイスミトモ"]
[null,"振込銀行名",null,null,null,"三井住友銀行"]
[null,"銀行支店名（フリガナ）",null,null,null,"トウキヨウ"]
[null,"銀行支店名",null,null,null,"東京支店"]
[null,"預金種別",null,null,null,"当座"]
[null,"口座番号",null,null,null,"1234567"]
[null,"口座名義（フリガナ）",null,null,null,"サンプルケンセツ（カ"]
[null,"口座名義",null,null,null,"さんぷる建設株式会社"]
[]
[null,"【依頼書内容】","※依頼書提出時のみ入力"]
[null,"依頼書提出日",null,null,null,"0000/00/00","西暦で入力"]
[null,"提出区分",null,1,null,"どちらか選択"]
[null,"変更内容",null,false]
[null,"※変更依頼書の場合のみ入力",null,false]
[null,null,null,false]
[null,null,null,false]
[null,null,null,false]
[null,null,null,false]
[null,null,null,false]
[null,null,null,false]
[null,null,null,null,null,"「その他」にチェック入力した場合には太枠内に内容を入力"]

{"sheet":"請求書内訳","index":1,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":true,"merged":[[3,1,3,3],[4,1,4,3]]}
["日本建設株式会社　請求書内訳"]
[null,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%",0.1]
["工事名称",null,null,null,null,null,"※出来高に対しての〇分金及び消費税（税率）の選択は項目を",null,null,null,null,null,null,"8%",0.08]
["契約番号",null,null,null,null,null,"左クリックをすると矢印が出ますので矢印で選択をして下さい。",null,null,null,null,null,null,"8%軽減",0.08]
[null,"※契約番号は注文書右上に記載の注文番号を入力してください。",null,null,null,null,null,null,null,null,null,null,null,"非課税",0]
["工事名（品名又は内容）","契約金額（税抜）","出来高％","金額（税抜）",null,null,"合計又は総出来高金額",null,null,{"$f":"SUM($D$8:$D$12)","v":0},null,null,null,"不課税",0]
[null,null,{"$f":"IFERROR(ROUNDDOWN($D8/$B8*100,0),\"\")","v":""},null,null,null,"上記に対して",10,"分金",{"$f":"$J$7*$H$8/10","v":0},null,null,null,"免税",0]
[null,null,{"$f":"IFERROR(ROUNDDOWN($D9/$B9*100,0),\"\")","v":""},null,null,null,"前回迄の領収金額"]
[null,null,"",null,null,"①","請求金額 （第",null,"回）",{"$f":"$J$8-$J$9","v":0}]
[null,null,"",null,null,"②","消費税　　（税率","10%","）",{"$f":"ROUNDDOWN($J$10*VLOOKUP($H$11,$N$2:$O$8,2,FALSE),0)","v":0}]
[null,null,"",null,null,null,"請求金額（①＋②　税込）",null,null,{"$f":"$J$10+$J$11","v":0}]
["※契約金額（税抜）・金額（税抜）を入力すると出来高％が自動計算されます。"]
[]
["（協力会社注意事項）"]
["１．基本情報及び請求書内訳シートを必ず入力して下さい。"]
["２．外注費の内金請求は総出来高金額の９分金を千円単位で請求して下さい。"]
["　　又材料費、労務費は１０分金にて請求して下さい。"]
["３．請求書は押印済み１部を提出して下さい。",null,null," "]
["４．記載内容を訂正されたものは受理できません。"]
["５．消費税は請求の毎、請求して下さい。"]
["６．請求書は消費税率毎に発行してください。"]
["７．請求書シートのグレー着色欄は当社記入欄です。"]
["８．不明点は各作業所及び本社調達部（03-3265-3214）へお問い合わせ下さい。"]

{"sheet":"依頼書","index":2,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":true,"merged":[[8,2,8,3],[24,2,24,3],[24,4,24,5],[28,2,28,5],[29,2,29,5],[27,2,27,5],[26,2,26,5],[25,2,25,3],[25,4,25,5]]}
[null,null,null,"取引代金受領に関する",{"$f":"_xlfn.IFS(基本情報!$D$27=1,\"新規\",基本情報!$D$27=2,\"変更\",基本情報!$D$27=0,\"\")","v":"新規"},"依頼書"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(基本情報!$C$26=\"\",\"年　　　月　　　日\",基本情報!$C$26)","v":"年　　　月　　　日"}]
[]
["日本建設株式会社　御中"]
[]
[null,"事業者区分",{"$f":"_xlfn.IFS(基本情報!$D$5=1,\"課税事業者\",基本情報!$D$5=2,\"免税事業者\",基本情報!$D$5=0,\"\")","v":"課税事業者"}]
[]
[null,"登録番号",{"$f":"IF(基本情報!$D$5<>1,\"\",基本情報!$C$6&\"\")","v":""}]
[]
[null,"ﾌﾘｶﾞﾅ",{"$f":"基本情報!$C$7&\"\"","v":""}]
[null,"商号",{"$f":"基本情報!$C$8&\"\"","v":""}]
[]
[null,"ﾌﾘｶﾞﾅ",{"$f":"基本情報!$C$9&\"\"","v":""}]
[null,"代表者名",{"$f":"基本情報!$C$10&\"\"","v":""},null,null,null,null,"(印鑑)"]
[]
[null,"住所",{"$f":"IF(基本情報!$C$11=\"\",\"\",\"〒\"&基本情報!$C$11)","v":""}]
[null,null,{"$f":"基本情報!$C$12&\"\"","v":""}]
[null,null,{"$f":"基本情報!$C$13&\"\"","v":""}]
[]
[null,"電話番号",{"$f":"基本情報!$C$14&\"\"","v":""}]
[]
[null,"FAX番号",{"$f":"基本情報!$C$15&\"\"","v":""}]
[]
[null,"ﾌﾘｶﾞﾅ",{"$f":"基本情報!$C$16&\"\"","v":""},null,{"$f":"基本情報!$C$18&\"\"","v":""}]
[null,"振込銀行名",{"$f":"基本情報!$C$17&\"\"","v":""},null,{"$f":"基本情報!$C$19&\"\"","v":""}]
[null,"口座種別",{"$f":"基本情報!$C$20&\"\"","v":""}]
[null,"口座番号",{"$f":"基本情報!$C$21&\"\"","v":""}]
[null,"ﾌﾘｶﾞﾅ",{"$f":"基本情報!$C$22&\"\"","v":""}]
[null,"口座名義",{"$f":"基本情報!$C$23&\"\"","v":""}]
[]
[null,"【変更内容】※変更依頼書のみ",null,"住所","代表者","電話番号"]
[null,null,null,"代表者印","FAX番号"]
[null,null,null,"振込口座","事業者区分"]
[null,null,null,"その他",{"$f":"IF(基本情報!$C$36=\"\",\"\",\"(\"&基本情報!$C$36&\")\")","v":""}]
[]
["１．貴社より当社への支払代金は、上記指定の銀行預金口座へお振込下さい。"]
["　　お振込をもって当該代金を受領したものと認め、別に領収書の発行は致しません。"]
["２．上記指定銀行の支払停止その他の理由で問題が生じましても、一切ご迷惑をおかけ致しません。"]
["３．後日、記載事項に変更が生じた場合は、遅滞なく通知の上あらためて依頼書を提出致します。"]
[null,null,null,null,null,null,null,"(２０２４年６月改正）"]
[]
[null,null,null,null,null,null,null,{"$f":"基本情報!$C$4&\"\"","v":""}]

{"sheet":"請求書","index":3,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":true,"merged":[[13,1,14,1],[29,1,29,3],[30,1,30,3],[8,6,8,7],[10,6,10,7],[11,6,11,7],[16,2,16,4],[17,2,17,4],[9,6,9,7],[13,2,14,4],[10,1,11,2],[10,4,11,4],[31,1,31,3],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[31,4,31,5],[26,1,26,3],[27,1,27,3],[28,1,28,3],[0,0,0,3],[7,2,7,4],[8,2,8,4],[10,3,11,3],[9,1,9,2],[1,0,1,3]]}
["請　　求　　書",null,null,null,null,null,null,"No."]
[{"$f":"IF($G$37=\"8%軽減）\",\"（軽減税率対象）\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(請求書内訳!$B$3=\"\",\"\",請求書内訳!$B$3)","v":""}]
["日本建設株式会社　御中"]
[]
[null,"下記の通り請求致します"]
[null,null,null,null,null,null,"取引先コード",{"$f":"基本情報!$C$4&\"\"","v":""}]
[]
[null,"工事名称",{"$f":"請求書内訳!$B$4&\"\"","v":""},null,null,null,{"$f":"IF(基本情報!$C$11=\"\",\"\",\"〒\"&基本情報!$C$11)","v":""}]
[null,"契約番号",{"$f":"請求書内訳!$B$5&\"\"","v":""},null,null,null,{"$f":"基本情報!$C$12&\"\"","v":""}]
[null,"略称名・略称コード",null,"工事コード","要素コード",null,{"$f":"基本情報!$C$13&\"\"","v":""}]
[null,null,null,null,null,null,{"$f":"基本情報!$C$8&\"\"","v":""}]
[null,null,null,null,null,null,{"$f":"基本情報!$C$10&\"\"","v":""}]
[]
[null,"請求金額\n（①＋②　税込）",{"$f":"請求書内訳!$J$12","v":0},null,null,null,"電話番号",{"$f":"基本情報!$C$14&\"\"","v":""}]
[null,null,null,null,null,null,{"$f":"IF(基本情報!$D$5<>1,\"\",\"登録番号\")","v":"登録番号"},{"$f":"IF(基本情報!$D$5<>1,\"\",基本情報!$C$6)","v":0}]
[]
[null,"振込銀行",{"$f":"基本情報!$C$17&\"　\"&基本情報!$C$19","v":"　"}]
[null,"口座名",{"$f":"基本情報!C23&\"\"","v":""}]
[null,"口座番号",{"$f":"基本情報!$C$20&\"\"","v":""},{"$f":"基本情報!$C$21&\"\"","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"工事名（品名又は内容）",null,null,"契約金額（税抜）",null,"出来高％","金額（税抜）"]
[null,{"$f":"IF(請求書内訳!$A8=\"\",\"\",請求書内訳!$A8)","v":""},null,null,{"$f":"IF(請求書内訳!$B8=\"\",\"\",請求書内訳!$B8)","v":""},null,{"$f":"IF(請求書内訳!$C8=\"\",\"\",請求書内訳!$C8)","v":""},{"$f":"IF(請求書内訳!$D8=\"\",\"\",請求書内訳!$D8)","v":""}]
[null,{"$f":"IF(請求書内訳!$A9=\"\",\"\",請求書内訳!$A9)","v":""},null,null,{"$f":"IF(請求書内訳!$B9=\"\",\"\",請求書内訳!$B9)","v":""},null,{"$f":"IF(請求書内訳!$C9=\"\",\"\",請求書内訳!$C9)","v":""},{"$f":"IF(請求書内訳!$D9=\"\",\"\",請求書内訳!$D9)","v":""}]
[null,{"$f":"IF(請求書内訳!$A10=\"\",\"\",請求書内訳!$A10)","v":""},null,null,{"$f":"IF(請求書内訳!$B10=\"\",\"\",請求書内訳!$B10)","v":""},null,{"$f":"IF(請求書内訳!$C10=\"\",\"\",請求書内訳!$C10)","v":""},{"$f":"IF(請求書内訳!$D10=\"\",\"\",請求書内訳!$D10)","v":""}]
[null,{"$f":"IF(請求書内訳!$A11=\"\",\"\",請求書内訳!$A11)","v":""},null,null,{"$f":"IF(請求書内訳!$B11=\"\",\"\",請求書内訳!$B11)","v":""},null,{"$f":"IF(請求書内訳!$C11=\"\",\"\",請求書内訳!$C11)","v":""},{"$f":"IF(請求書内訳!$D11=\"\",\"\",請求書内訳!$D11)","v":""}]
[null,{"$f":"IF(請求書内訳!$A12=\"\",\"\",請求書内訳!$A12)","v":""},null,null,{"$f":"IF(請求書内訳!$B12=\"\",\"\",請求書内訳!$B12)","v":""},null,{"$f":"IF(請求書内訳!$C12=\"\",\"\",請求書内訳!$C12)","v":""},{"$f":"IF(請求書内訳!$D12=\"\",\"\",請求書内訳!$D12)","v":""}]
[null,"（備考）",null,null,"合計又は総出来高金額",null,null,{"$f":"請求書内訳!$J$7","v":0}]
[null,null,null,null,"上記に対して",null,{"$f":"請求書内訳!$H$8","v":10},{"$f":"請求書内訳!$J$8","v":0}]
[null,null,null,null,"前回迄の領収金額",null,null,{"$f":"請求書内訳!$J$9","v":0}]
[null,null,null,null,"①請求金額　　（第",null,{"$f":"請求書内訳!$H$10","v":0},{"$f":"請求書内訳!$J$10","v":0}]
[null,null,null,null,"②消費税　　（税率",null,{"$f":"請求書内訳!$H$11&\"）\"","v":"10%）"},{"$f":"請求書内訳!$J$11","v":0}]
[null,null,null,null,null,null,"完納内金別","　　完　納　　・　　内　金　　"]

{"sheet":"マクロを有効化してください","index":4,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"本ドキュメントはマクロを有効にしないと起動することはできません。"]
[null,"マクロを有効に変更してください。"]
[]
[null,"設定方法：上部のセキュリティ警告「マクロが無効にされました。」の右の「コンテンツの有効化」をクリックしてください。"]