{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["利用方法","記入例","入力シート"],"not_rendered":{"charts":0,"images":2,"macros":0,"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":59,"n_cols":3,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,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,"下さい。"]
[]
[null,null,"工事コードがわかる場合は、工事コード欄を入力してください。（不明の場合は入力不要）"]
[]
[null,null,"提出用（現場控・経理）には出力後、必ず捺印して提出して下さい。"]
[]
[null,null,"契約書（注文書）を取り交わしている場合は、注文書金額の契約金額欄と２枚目の支払条件欄"]
[null,null,"を記入して下さい。"]
[]
[null,null,"増減の契約書（注文書）を取り交わした場合は、注文書金額の変更増減額欄を記入して下さい。"]
[]
[null,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":1,"n_rows":112,"n_cols":9,"rows_kept":112,"cut":false,"hidden":false,"merged":[[107,2,108,2],[110,2,111,2],[110,3,111,3],[110,5,111,5],[110,6,111,6],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[93,1,93,3],[94,2,94,3],[94,7,96,8],[95,2,95,3],[96,2,96,3],[97,1,104,1],[97,2,97,3],[97,5,97,6],[97,7,97,8],[98,2,98,3],[88,5,88,6],[88,7,88,8],[90,1,91,3],[90,4,91,6],[90,7,90,8],[91,7,91,8],[84,2,84,3],[84,7,84,8],[85,6,85,8],[86,5,86,8],[87,2,87,3],[87,5,87,7],[81,1,81,3],[81,4,81,5],[82,1,82,3],[82,4,82,5],[82,7,82,8],[83,4,83,5],[69,2,70,2],[72,2,73,2],[72,3,73,3],[76,1,76,4],[78,1,78,4],[80,1,80,3],[80,4,80,5],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[55,1,55,3],[56,2,56,3],[56,7,58,8],[57,2,57,3],[58,2,58,3],[59,1,66,1],[59,2,59,3],[59,5,59,6],[59,7,59,8],[60,2,60,3],[50,5,50,6],[50,7,50,8],[52,1,53,3],[52,4,53,6],[52,7,52,8],[53,7,53,8],[46,2,46,3],[46,7,46,8],[47,6,47,8],[48,5,48,8],[49,2,49,3],[49,5,49,7],[45,4,45,5],[29,2,29,3],[31,1,34,8],[38,1,38,4],[40,1,40,4],[42,1,42,3],[42,4,42,5],[22,1,29,1],[22,2,22,3],[22,5,22,6],[22,7,22,8],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[18,1,18,3],[19,2,19,3],[19,7,21,8],[20,2,20,3],[21,2,21,3],[43,1,43,3],[43,4,43,5],[44,1,44,3],[44,4,44,5],[44,7,44,8],[13,5,13,6],[13,7,13,8],[7,1,7,3],[7,4,7,5],[7,7,7,8],[8,4,8,5],[9,2,9,3],[9,7,9,8],[15,1,16,3],[15,4,16,6],[15,7,15,8],[16,7,16,8],[1,1,1,4],[3,1,3,4],[5,1,5,3],[5,4,5,5],[6,1,6,3],[6,4,6,5],[10,6,10,8],[11,5,11,8],[12,2,12,3],[12,5,12,7]]}
[null,null,null,null,null,null,null,null,"(業者控)"]
[null,"請　　求　　書"]
[]
[null,"関 越 舗 道 株式会社　御中"]
[null,null,null,null,null,null,"（振込指定口座)"]
[null,"当月工事金額",null,null,{"$f":"G24+G26+G28-I24-I26-I28","v":218000},null,"金融機関名","〇〇","銀行"]
[null,"同消費税額",null,null,{"$f":"IF(I29=0,G25+G27,G25+G27-I25-I27)","v":22000},null,"支店名","〇〇","支店"]
[null,"同請求額",null,null,{"$f":"SUM(E6:F7)","v":240000},null,"口座名義","カ．〇〇ケンセツ"]
[null,null,null,null,"(下段⑦差引請求額と一致します）",null,"口座番号","当座","0123456"]
[null,null,"上記金額請求いたします。",null,null,null,"適格請求書№","T0123456789012"]
[null,null,null,null,null,"住所･氏名"]
[null,null,"請求日",null,null,"新潟県南魚沼郡湯沢町大字湯沢***-*"]
[null,null,"2023-10-31",null,null,"株式会社　○○建設",null,null,"㊞　"]
[null,null,null,null,null,"代表取締役　○○○○",null,"012（345）6789"]
[]
[null,"工　事　名",null,null,"○○○○○○○○工事",null,null,"工事コード"]
[null,null,null,null,null,null,null,"1230001"]
[]
[null,"注文書金額",null,null,"契約金額","変更増減額","最終契約額","備考"]
[null,"A","工事金額",null,500000,200000,{"$f":"IF(F20=\"\",IF(E20=\"\",\"\",E20),IF(E20=\"\",\"\",E20+F20))","v":700000},"○/○ ＊人工×15,000-\n材工共一式"]
[null,"B","消費税額",null,{"$f":"IF(E20=\"\",\"\",ROUND(E20*10%,0))","v":50000},{"$f":"IF(F20=\"\",\"\",ROUND(F20*10%,0))","v":20000},{"$f":"IF(F21=\"\",IF(E21=\"\",\"\",E21),IF(E21=\"\",\"\",E21+F21))","v":70000}]
[null,"C","合計金額（Ａ＋Ｂ）",null,{"$f":"IF(E20=0,\"\",E20+E21)","v":550000},{"$f":"IF(F20=\"\",\"\",F20+F21)","v":220000},{"$f":"IF(G21=\"\",G20,IF(G20=\"\",\"\",G20+G21))","v":770000}]
[null,"請 求 内 容","①前回迄出来高額(税込)",null,110000,"当月出来高",null,"仕　送　り"]
[null,null,"②今回出来高額(税込)",null,{"$f":"G29","v":275000},"10％対象",250000,"10％対象",30000]
[null,null,"③出来高累計(①＋②)",null,{"$f":"SUM(E23:E24)","v":385000},"同消費税",{"$f":"ROUND(G24*10%,0)","v":25000},"同消費税",{"$f":"ROUND(I24*10%,0)","v":3000}]
[null,null,"④既入金済額",null,{"$f":"E23","v":110000},"8％対象",null,"8％対象"]
[null,null,"⑤今回請求額(③－④)",null,{"$f":"E25-E26","v":275000},"同消費税",{"$f":"ROUND(G26*8%,0)","v":0},"同消費税",{"$f":"ROUND(I26*8%,0)","v":0}]
[null,null,"⑥仕送(相殺)金額(税込)",null,{"$f":"I29","v":35000},"非・不課税",null,"非・不課税",2000]
[null,null,"⑦差引請求額(⑤－⑥)",null,{"$f":"E27-E28","v":240000},"出来高計",{"$f":"SUM(G24:G28)","v":275000},"仕送り計",{"$f":"SUM(I24:I28)","v":35000}]
[null,null,"⑧未請求残高(Ｃ－③)",null,{"$f":"IF(I19=\"仮払い\",\"\",IF(G22=\"\",0,G22-E25))","v":385000}]
[]
[null,"1.この請求書は契約書(注文書発行済)の工事費等を請求するときに使用して下さい。\n　（但し、契約外の場合は、請求計算の根拠となる、労賃・材料・物品納品書等を添付して下さい。）\n２．請求書の提出期限は毎月末日締切、翌月５日迄必着を原則とします。\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,{"$f":"G61+G63+G65-I61-I63-I65","v":218000},null,"金融機関名",{"$f":"IF($H$6=\"\",\"\",$H$6)","v":"〇〇"},{"$f":"IF($I$6=\"\",\"\",$I$6)","v":"銀行"}]
[null,"同消費税額",null,null,{"$f":"IF(I66=0,G62+G64,G62+G64-I62-I64)","v":22000},null,"支店名",{"$f":"IF($H$7=\"\",\"\",$H$7)","v":"〇〇"},"支店"]
[null,"同請求額",null,null,{"$f":"SUM(E43:F44)","v":240000},null,"口座名義",{"$f":"IF($H$8=\"\",\"\",$H$8)","v":"カ．〇〇ケンセツ"},{"$f":"IF(I8=\"\",\"\",I8)","v":""}]
[null,null,null,null,"(下段⑦差引請求額と一致します）",null,"口座番号",{"$f":"IF($H$9=\"\",\"\",$H$9)","v":"当座"},{"$f":"IF(I9=\"\",\"\",I9)","v":"0123456"}]
[null,null,"上記金額請求いたします。",null,null,null,"適格請求書№",{"$f":"IF($H$10=\"\",\"\",$H$10)","v":"T0123456789012"}]
[null,null,null,null,null,"住所･氏名",{"$f":"IF($G$11=\"\",\"\",$G$11)","v":""}]
[null,null,"請求日",null,null,{"$f":"IF($F$12=\"\",\"\",$F$12)","v":"新潟県南魚沼郡湯沢町大字湯沢***-*"}]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":"2023-10-31"},null,null,{"$f":"IF($F$13=\"\",\"\",$F$13)","v":"株式会社　○○建設"},null,null,"㊞　"]
[null,null,null,null,null,{"$f":"IF($F$14=\"\",\"\",$F$14)","v":"代表取締役　○○○○"},null,{"$f":"IF($H$14=\"\",\"\",$H$14)","v":"012（345）6789"}]
[]
[null,"工　事　名",null,null,{"$f":"IF($E$16=\"\",\"\",$E$16)","v":"○○○○○○○○工事"},null,null,"工事コード"]
[null,null,null,null,null,null,null,{"$f":"IF($H$17=\"\",\"\",$H$17)","v":"1230001"}]
[]
[null,"注文書金額",null,null,"契約金額","変更増減額","最終契約額","備考",{"$f":"IF($I$19=\"\",\"\",$I$19)","v":""}]
[null,"A","工事金額",null,{"$f":"IF($E$20=\"\",\"\",$E$20)","v":500000},{"$f":"IF($F$20=\"\",\"\",$F$20)","v":200000},{"$f":"IF(F57=\"\",IF(E57=\"\",\"\",E57),IF(E57=\"\",\"\",E57+F57))","v":700000},{"$f":"IF($H$20=\"\",\"\",$H$20)","v":"○/○ ＊人工×15,000-\n材工共一式"}]
[null,"B","消費税額",null,{"$f":"IF($E$21=\"\",\"\",$E$21)","v":50000},{"$f":"IF($F$21=\"\",\"\",$F$21)","v":20000},{"$f":"IF(F58=\"\",IF(E58=\"\",\"\",E58),IF(E58=\"\",\"\",E58+F58))","v":70000}]
[null,"C","合計金額（Ａ＋Ｂ）",null,{"$f":"IF(ISERROR(E57+E58=TRUE),\"\",IF(E57+E58=0,\"\",E57+E58))","v":550000},{"$f":"IF(ISERROR(F57+F58=TRUE),\"\",IF(F57+F58=0,\"\",F57+F58))","v":220000},{"$f":"IF(G58=\"\",G57,IF(G57=\"\",\"\",G57+G58))","v":770000}]
[null,"請 求 内 容","①前回迄出来高額(税込)",null,{"$f":"$E$23","v":110000},"当月出来高",null,"仕　送　り"]
[null,null,"②今回出来高額(税込)",null,{"$f":"G66","v":275000},"10％対象",{"$f":"$G$24","v":250000},"10％対象",{"$f":"$I$24","v":30000}]
[null,null,"③出来高累計(①＋②)",null,{"$f":"SUM(E60:E61)","v":385000},"同消費税",{"$f":"$G$25","v":25000},"同消費税",{"$f":"$I$25","v":3000}]
[null,null,"④既入金済額",null,{"$f":"E60","v":110000},"8％対象",{"$f":"$G$26","v":0},"8％対象",{"$f":"$I$26","v":0}]
[null,null,"⑤今回請求額(③－④)",null,{"$f":"E62-E63","v":275000},"同消費税",{"$f":"$G$27","v":0},"同消費税",{"$f":"$I$27","v":0}]
[null,null,"⑥仕送(相殺)金額(税込)",null,{"$f":"I66","v":35000},"非・不課税",{"$f":"$G$28","v":0},"非・不課税",{"$f":"$I$28","v":2000}]
[null,null,"⑦差引請求額(⑤－⑥)",null,{"$f":"E64-E65","v":240000},"出来高計",{"$f":"SUM(G61:G65)","v":275000},"仕送り計",{"$f":"SUM(I61:I65)","v":35000}]
[null,null,"⑧未請求残高(Ｃ－③)",null,{"$f":"IF(I56=\"仮払い\",\"\",IF(G59=\"\",0,G59-E62))","v":385000}]
[]
[null,null,"現　金","手　形",null,null,"工事コード",{"$f":"IF($H$54=\"\",\"\",$H$54)","v":"1230001"}]
[null,null,40,60,null,null,"業者コード"]
[null,null,null,60,null,null,"外　注　費","労務外注費"]
[null,null,"科目コード","工種コード"]
[]
[null,null,null,null,null,null,null,null,{"$f":"$I$36","v":"【令和　　　年　　　月分】"}]
[]
[null,null,null,null,null,null,null,null,"(経　 理)"]
[null,"請　　求　　書"]
[]
[null,"関 越 舗 道 株式会社　御中"]
[null,null,null,null,null,null,"（振込指定口座)"]
[null,"当月工事金額",null,null,{"$f":"G99+G101+G103-I99-I101-I103","v":218000},null,"金融機関名",{"$f":"IF($H$6=\"\",\"\",$H$6)","v":"〇〇"},{"$f":"IF($I$6=\"\",\"\",$I$6)","v":"銀行"}]
[null,"同消費税額",null,null,{"$f":"IF(I104=0,G100+G102,G100+G102-I100-I102)","v":22000},null,"支店名",{"$f":"IF($H$7=\"\",\"\",$H$7)","v":"〇〇"},"支店"]
[null,"同請求額",null,null,{"$f":"SUM(E81:F82)","v":240000},null,"口座名義",{"$f":"IF($H$8=\"\",\"\",$H$8)","v":"カ．〇〇ケンセツ"},{"$f":"IF(I46=\"\",\"\",I46)","v":"0123456"}]
[null,null,null,null,"(下段⑦差引請求額と一致します）",null,"口座番号",{"$f":"IF($H$9=\"\",\"\",$H$9)","v":"当座"},{"$f":"IF(I9=\"\",\"\",I9)","v":"0123456"}]
[null,null,"上記金額請求いたします。",null,null,null,"適格請求書№",{"$f":"IF($H$10=\"\",\"\",$H$10)","v":"T0123456789012"}]
[null,null,null,null,null,"住所･氏名",{"$f":"IF($G$11=\"\",\"\",$G$11)","v":""}]
[null,null,"請求日",null,null,{"$f":"IF($F$12=\"\",\"\",$F$12)","v":"新潟県南魚沼郡湯沢町大字湯沢***-*"}]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":"2023-10-31"},null,null,{"$f":"IF($F$13=\"\",\"\",$F$13)","v":"株式会社　○○建設"},null,null,"㊞　"]
[null,null,null,null,null,{"$f":"IF($F$14=\"\",\"\",$F$14)","v":"代表取締役　○○○○"},null,{"$f":"IF($H$14=\"\",\"\",$H$14)","v":"012（345）6789"}]
[]
[null,"工　事　名",null,null,{"$f":"IF($E$16=\"\",\"\",$E$16)","v":"○○○○○○○○工事"},null,null,"工事コード"]
[null,null,null,null,null,null,null,{"$f":"IF($H$17=\"\",\"\",$H$17)","v":"1230001"}]
[]
[null,"注文書金額",null,null,"契約金額","変更増減額","最終契約額","備考",{"$f":"IF($I$19=\"\",\"\",$I$19)","v":""}]
[null,"A","工事金額",null,{"$f":"IF($E$20=\"\",\"\",$E$20)","v":500000},{"$f":"IF($F$20=\"\",\"\",$F$20)","v":200000},{"$f":"IF(F95=\"\",IF(E95=\"\",\"\",E95),IF(E95=\"\",\"\",E95+F95))","v":700000},{"$f":"IF($H$20=\"\",\"\",$H$20)","v":"○/○ ＊人工×15,000-\n材工共一式"}]
[null,"B","消費税額",null,{"$f":"IF($E$21=\"\",\"\",$E$21)","v":50000},{"$f":"IF($F$21=\"\",\"\",$F$21)","v":20000},{"$f":"IF(F96=\"\",IF(E96=\"\",\"\",E96),IF(E96=\"\",\"\",E96+F96))","v":70000}]
[null,"C","合計金額（Ａ＋Ｂ）",null,{"$f":"IF(ISERROR(E95+E96=TRUE),\"\",IF(E95+E96=0,\"\",E95+E96))","v":550000},{"$f":"IF(ISERROR(F95+F96=TRUE),\"\",IF(F95+F96=0,\"\",F95+F96))","v":220000},{"$f":"IF(G96=\"\",G95,IF(G95=\"\",\"\",G95+G96))","v":770000}]
[null,"請 求 内 容","①前回迄出来高額(税込)",null,{"$f":"$E$23","v":110000},"当月出来高",null,"仕　送　り"]
[null,null,"②今回出来高額(税込)",null,{"$f":"G104","v":275000},"10％対象",{"$f":"$G$24","v":250000},"10％対象",{"$f":"$I$24","v":30000}]
[null,null,"③出来高累計(①＋②)",null,{"$f":"SUM(E98:E99)","v":385000},"同消費税",{"$f":"$G$25","v":25000},"同消費税",{"$f":"$I$25","v":3000}]
[null,null,"④既入金済額",null,{"$f":"E98","v":110000},"8％対象",{"$f":"$G$26","v":0},"8％対象",{"$f":"$I$26","v":0}]
[null,null,"⑤今回請求額(③－④)",null,{"$f":"E100-E101","v":275000},"同消費税",{"$f":"$G$27","v":0},"同消費税",{"$f":"$I$27","v":0}]
[null,null,"⑥仕送(相殺)金額(税込)",null,{"$f":"I104","v":35000},"非・不課税",{"$f":"$G$28","v":0},"非・不課税",{"$f":"$I$28","v":2000}]
[null,null,"⑦差引請求額(⑤－⑥)",null,{"$f":"E102-E103","v":240000},"出来高計",{"$f":"SUM(G99:G103)","v":275000},"仕送り計",{"$f":"SUM(I99:I103)","v":35000}]
[null,null,"⑧未請求残高(Ｃ－③)",null,{"$f":"IF(I94=\"仮払い\",\"\",IF(G97=\"\",0,G97-E100))","v":385000}]
[]
[null,null,"現　金","手　形",null,null,"工事コード",{"$f":"IF($H$92=\"\",\"\",$H$92)","v":"1230001"}]
[null,null,{"$f":"IF(C70=\"\",\"\",C70)","v":40},{"$f":"IF(D70=\"\",\"\",D70)","v":60},null,null,"業者コード",{"$f":"IF(H70=\"\",\"\",H70)","v":""}]
[null,null,null,{"$f":"IF(D71=\"\",\"\",D71)","v":60},null,null,"外　注　費","労務外注費"]
[null,null,"科目コード","工種コード"]
[null,null,{"$f":"IF(C73=\"\",\"\",C73)","v":""},{"$f":"IF(D73=\"\",\"\",D73)","v":""},null,"前回迄",{"$f":"IF(E98=\"\",\"\",E98)","v":110000}]
[null,null,null,null,null,null,null,null,{"$f":"$I$36","v":"【令和　　　年　　　月分】"}]

{"sheet":"入力シート","index":2,"n_rows":112,"n_cols":9,"rows_kept":112,"cut":false,"hidden":false,"merged":[[59,1,66,1],[58,2,58,3],[59,2,59,3],[60,2,60,3],[72,2,73,2],[72,3,73,3],[69,2,70,2],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[59,5,59,6],[59,7,59,8],[56,7,58,8],[5,1,5,3],[6,1,6,3],[7,1,7,3],[9,2,9,3],[57,2,57,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[46,2,46,3],[49,2,49,3],[52,1,53,3],[55,1,55,3],[56,2,56,3],[43,1,43,3],[12,2,12,3],[15,1,16,3],[18,1,18,3],[19,2,19,3],[97,7,97,8],[97,5,97,6],[81,1,81,3],[81,4,81,5],[82,1,82,3],[82,4,82,5],[82,7,82,8],[93,1,93,3],[94,2,94,3],[95,2,95,3],[84,2,84,3],[87,2,87,3],[88,7,88,8],[90,1,91,3],[90,4,91,6],[90,7,90,8],[91,7,91,8],[85,6,85,8],[86,5,86,8],[87,5,87,7],[88,5,88,6],[94,7,96,8],[84,7,84,8],[83,4,83,5],[1,1,1,4],[76,1,76,4],[78,1,78,4],[80,1,80,3],[80,4,80,5],[3,1,3,4],[7,7,7,8],[15,7,15,8],[13,7,13,8],[15,4,16,6],[5,4,5,5],[6,4,6,5],[7,4,7,5],[16,7,16,8],[43,4,43,5],[42,1,42,3],[22,5,22,6],[9,7,9,8],[46,7,46,8],[22,7,22,8],[19,7,21,8],[44,4,44,5],[44,7,44,8],[50,7,50,8],[110,2,111,2],[110,3,111,3],[110,5,111,5],[110,6,111,6],[96,2,96,3],[97,1,104,1],[97,2,97,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[104,2,104,3],[107,2,108,2],[52,4,53,6],[52,7,52,8],[45,4,45,5],[8,4,8,5],[47,6,47,8],[49,5,49,7],[48,5,48,8],[50,5,50,6],[10,6,10,8],[11,5,11,8],[12,5,12,7],[13,5,13,6],[31,1,34,8],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[22,1,29,1],[53,7,53,8],[44,1,44,3],[38,1,38,4],[40,1,40,4],[42,4,42,5]]}
[null,null,null,null,null,null,null,null,"(業者控)"]
[null,"請　　求　　書"]
[]
[null,"関 越 舗 道 株式会社　御中"]
[null,null,null,null,null,null,"（振込指定口座)"]
[null,"当月工事金額",null,null,{"$f":"G24+G26+G28-I24-I26-I28","v":0},null,"金融機関名"]
[null,"同消費税額",null,null,{"$f":"IF(I29=0,G25+G27,G25+G27-I25-I27)","v":0},null,"支店名",null,"支店"]
[null,"同請求額",null,null,{"$f":"SUM(E6:F7)","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,null,null,"工事コード"]
[]
[]
[null,"注文書金額",null,null,"契約金額","変更増減額","最終契約額","備考"]
[null,"A","工事金額",null,null,null,{"$f":"IF(F20=\"\",IF(E20=\"\",\"\",E20),IF(E20=\"\",\"\",E20+F20))","v":""}]
[null,"B","消費税額",null,{"$f":"IF(E20=\"\",\"\",ROUND(E20*10%,0))","v":""},{"$f":"IF(F20=\"\",\"\",ROUND(F20*10%,0))","v":""},{"$f":"IF(F21=\"\",IF(E21=\"\",\"\",E21),IF(E21=\"\",\"\",E21+F21))","v":""}]
[null,"C","合計金額（Ａ＋Ｂ）",null,{"$f":"IF(E20=0,\"\",E20+E21)","v":""},{"$f":"IF(F20=\"\",\"\",F20+F21)","v":""},{"$f":"IF(G21=\"\",G20,IF(G20=\"\",\"\",G20+G21))","v":""}]
[null,"請 求 内 容","①前回迄出来高額(税込)",null,null,"当月出来高",null,"仕　送　り"]
[null,null,"②今回出来高額(税込)",null,{"$f":"G29","v":0},"10％対象",null,"10％対象"]
[null,null,"③出来高累計(①＋②)",null,{"$f":"SUM(E23:E24)","v":0},"同消費税",{"$f":"ROUND(G24*10%,0)","v":0},"同消費税",{"$f":"ROUND(I24*10%,0)","v":0}]
[null,null,"④既入金済額",null,{"$f":"E23","v":0},"8％対象",null,"8％対象"]
[null,null,"⑤今回請求額(③－④)",null,{"$f":"E25-E26","v":0},"同消費税",{"$f":"ROUND(G26*8%,0)","v":0},"同消費税",{"$f":"ROUND(I26*8%,0)","v":0}]
[null,null,"⑥仕送(相殺)金額(税込)",null,{"$f":"I29","v":0},"非・不課税",null,"非・不課税"]
[null,null,"⑦差引請求額(⑤－⑥)",null,{"$f":"E27-E28","v":0},"出来高計",{"$f":"SUM(G24:G28)","v":0},"仕送り計",{"$f":"SUM(I24:I28)","v":0}]
[null,null,"⑧未請求残高(Ｃ－③)",null,{"$f":"IF(I19=\"仮払い\",\"\",IF(G22=\"\",0,G22-E25))","v":0}]
[]
[null,"1.この請求書は契約書(注文書発行済)の工事費等を請求するときに使用して下さい。\n　（但し、契約外の場合は、請求計算の根拠となる、労賃・材料・物品納品書等を添付して下さい。）\n２．請求書の提出期限は毎月末日締切、翌月５日迄必着を原則とします。\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,{"$f":"G61+G63+G65-I61-I63-I65","v":0},null,"金融機関名",{"$f":"IF($H$6=\"\",\"\",$H$6)","v":""},{"$f":"IF($I$6=\"\",\"\",$I$6)","v":""}]
[null,"同消費税額",null,null,{"$f":"IF(I66=0,G62+G64,G62+G64-I62-I64)","v":0},null,"支店名",{"$f":"IF($H$7=\"\",\"\",$H$7)","v":""},"支店"]
[null,"同請求額",null,null,{"$f":"SUM(E43:F44)","v":0},null,"口座名義",{"$f":"IF($H$8=\"\",\"\",$H$8)","v":""},{"$f":"IF(I8=\"\",\"\",I8)","v":""}]
[null,null,null,null,"(下段⑦差引請求額と一致します）",null,"口座番号",{"$f":"IF($H$9=\"\",\"\",$H$9)","v":""},{"$f":"IF(I9=\"\",\"\",I9)","v":""}]
[null,null,"上記金額請求いたします。",null,null,null,"適格請求書№",{"$f":"IF($H$10=\"\",\"\",$H$10)","v":""}]
[null,null,null,null,null,"住所･氏名",{"$f":"IF($G$11=\"\",\"\",$G$11)","v":""}]
[null,null,"請求日",null,null,{"$f":"IF($F$12=\"\",\"\",$F$12)","v":""}]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":""},null,null,{"$f":"IF($F$13=\"\",\"\",$F$13)","v":""},null,null,"㊞　"]
[null,null,null,null,null,{"$f":"IF($F$14=\"\",\"\",$F$14)","v":""},null,{"$f":"IF($H$14=\"\",\"\",$H$14)","v":"（　　）"}]
[]
[null,"工　事　名",null,null,{"$f":"IF($E$16=\"\",\"\",$E$16)","v":""},null,null,"工事コード"]
[null,null,null,null,null,null,null,{"$f":"IF($H$17=\"\",\"\",$H$17)","v":""}]
[]
[null,"注文書金額",null,null,"契約金額","変更増減額","最終契約額","備考",{"$f":"IF($I$19=\"\",\"\",$I$19)","v":""}]
[null,"A","工事金額",null,{"$f":"IF($E$20=\"\",\"\",$E$20)","v":""},{"$f":"IF($F$20=\"\",\"\",$F$20)","v":""},{"$f":"IF(F57=\"\",IF(E57=\"\",\"\",E57),IF(E57=\"\",\"\",E57+F57))","v":""},{"$f":"IF($H$20=\"\",\"\",$H$20)","v":""}]
[null,"B","消費税額",null,{"$f":"IF($E$21=\"\",\"\",$E$21)","v":""},{"$f":"IF($F$21=\"\",\"\",$F$21)","v":""},{"$f":"IF(F58=\"\",IF(E58=\"\",\"\",E58),IF(E58=\"\",\"\",E58+F58))","v":""}]
[null,"C","合計金額（Ａ＋Ｂ）",null,{"$f":"IF(ISERROR(E57+E58=TRUE),\"\",IF(E57+E58=0,\"\",E57+E58))","v":""},{"$f":"IF(ISERROR(F57+F58=TRUE),\"\",IF(F57+F58=0,\"\",F57+F58))","v":""},{"$f":"IF(G58=\"\",G57,IF(G57=\"\",\"\",G57+G58))","v":""}]
[null,"請 求 内 容","①前回迄出来高額(税込)",null,{"$f":"$E$23","v":0},"当月出来高",null,"仕　送　り"]
[null,null,"②今回出来高額(税込)",null,{"$f":"G66","v":0},"10％対象",{"$f":"$G$24","v":0},"10％対象",{"$f":"$I$24","v":0}]
[null,null,"③出来高累計(①＋②)",null,{"$f":"SUM(E60:E61)","v":0},"同消費税",{"$f":"$G$25","v":0},"同消費税",{"$f":"$I$25","v":0}]
[null,null,"④既入金済額",null,{"$f":"E60","v":0},"8％対象",{"$f":"$G$26","v":0},"8％対象",{"$f":"$I$26","v":0}]
[null,null,"⑤今回請求額(③－④)",null,{"$f":"E62-E63","v":0},"同消費税",{"$f":"$G$27","v":0},"同消費税",{"$f":"$I$27","v":0}]
[null,null,"⑥仕送(相殺)金額(税込)",null,{"$f":"I66","v":0},"非・不課税",{"$f":"$G$28","v":0},"非・不課税",{"$f":"$I$28","v":0}]
[null,null,"⑦差引請求額(⑤－⑥)",null,{"$f":"E64-E65","v":0},"出来高計",{"$f":"SUM(G61:G65)","v":0},"仕送り計",{"$f":"SUM(I61:I65)","v":0}]
[null,null,"⑧未請求残高(Ｃ－③)",null,{"$f":"IF(I56=\"仮払い\",\"\",IF(G59=\"\",0,G59-E62))","v":0}]
[]
[null,null,"現　金","手　形",null,null,"工事コード",{"$f":"IF($H$54=\"\",\"\",$H$54)","v":""}]
[null,null,null,null,null,null,"業者コード"]
[null,null,null,null,null,null,"外　注　費","労務外注費"]
[null,null,"科目コード","工種コード"]
[]
[null,null,null,null,null,null,null,null,{"$f":"$I$36","v":"【令和　　　年　　　月分】"}]
[]
[null,null,null,null,null,null,null,null,"(経　 理)"]
[null,"請　　求　　書"]
[]
[null,"関 越 舗 道 株式会社　御中"]
[null,null,null,null,null,null,"（振込指定口座)"]
[null,"当月工事金額",null,null,{"$f":"G99+G101+G103-I99-I101-I103","v":0},null,"金融機関名",{"$f":"IF($H$6=\"\",\"\",$H$6)","v":""},{"$f":"IF($I$6=\"\",\"\",$I$6)","v":""}]
[null,"同消費税額",null,null,{"$f":"IF(I104=0,G100+G102,G100+G102-I100-I102)","v":0},null,"支店名",{"$f":"IF($H$7=\"\",\"\",$H$7)","v":""},"支店"]
[null,"同請求額",null,null,{"$f":"SUM(E81:F82)","v":0},null,"口座名義",{"$f":"IF($H$8=\"\",\"\",$H$8)","v":""},{"$f":"IF(I46=\"\",\"\",I46)","v":""}]
[null,null,null,null,"(下段⑦差引請求額と一致します）",null,"口座番号",{"$f":"IF($H$9=\"\",\"\",$H$9)","v":""},{"$f":"IF(I9=\"\",\"\",I9)","v":""}]
[null,null,"上記金額請求いたします。",null,null,null,"適格請求書№",{"$f":"IF($H$10=\"\",\"\",$H$10)","v":""}]
[null,null,null,null,null,"住所･氏名",{"$f":"IF($G$11=\"\",\"\",$G$11)","v":""}]
[null,null,"請求日",null,null,{"$f":"IF($F$12=\"\",\"\",$F$12)","v":""}]
[null,null,{"$f":"IF($C$13=\"\",\"\",$C$13)","v":""},null,null,{"$f":"IF($F$13=\"\",\"\",$F$13)","v":""},null,null,"㊞　"]
[null,null,null,null,null,{"$f":"IF($F$14=\"\",\"\",$F$14)","v":""},null,{"$f":"IF($H$14=\"\",\"\",$H$14)","v":"（　　）"}]
[]
[null,"工　事　名",null,null,{"$f":"IF($E$16=\"\",\"\",$E$16)","v":""},null,null,"工事コード"]
[null,null,null,null,null,null,null,{"$f":"IF($H$17=\"\",\"\",$H$17)","v":""}]
[]
[null,"注文書金額",null,null,"契約金額","変更増減額","最終契約額","備考",{"$f":"IF($I$19=\"\",\"\",$I$19)","v":""}]
[null,"A","工事金額",null,{"$f":"IF($E$20=\"\",\"\",$E$20)","v":""},{"$f":"IF($F$20=\"\",\"\",$F$20)","v":""},{"$f":"IF(F95=\"\",IF(E95=\"\",\"\",E95),IF(E95=\"\",\"\",E95+F95))","v":""},{"$f":"IF($H$20=\"\",\"\",$H$20)","v":""}]
[null,"B","消費税額",null,{"$f":"IF($E$21=\"\",\"\",$E$21)","v":""},{"$f":"IF($F$21=\"\",\"\",$F$21)","v":""},{"$f":"IF(F96=\"\",IF(E96=\"\",\"\",E96),IF(E96=\"\",\"\",E96+F96))","v":""}]
[null,"C","合計金額（Ａ＋Ｂ）",null,{"$f":"IF(ISERROR(E95+E96=TRUE),\"\",IF(E95+E96=0,\"\",E95+E96))","v":""},{"$f":"IF(ISERROR(F95+F96=TRUE),\"\",IF(F95+F96=0,\"\",F95+F96))","v":""},{"$f":"IF(G96=\"\",G95,IF(G95=\"\",\"\",G95+G96))","v":""}]
[null,"請 求 内 容","①前回迄出来高額(税込)",null,{"$f":"$E$23","v":0},"当月出来高",null,"仕　送　り"]
[null,null,"②今回出来高額(税込)",null,{"$f":"G104","v":0},"10％対象",{"$f":"$G$24","v":0},"10％対象",{"$f":"$I$24","v":0}]
[null,null,"③出来高累計(①＋②)",null,{"$f":"SUM(E98:E99)","v":0},"同消費税",{"$f":"$G$25","v":0},"同消費税",{"$f":"$I$25","v":0}]
[null,null,"④既入金済額",null,{"$f":"E98","v":0},"8％対象",{"$f":"$G$26","v":0},"8％対象",{"$f":"$I$26","v":0}]
[null,null,"⑤今回請求額(③－④)",null,{"$f":"E100-E101","v":0},"同消費税",{"$f":"$G$27","v":0},"同消費税",{"$f":"$I$27","v":0}]
[null,null,"⑥仕送(相殺)金額(税込)",null,{"$f":"I104","v":0},"非・不課税",{"$f":"$G$28","v":0},"非・不課税",{"$f":"$I$28","v":0}]
[null,null,"⑦差引請求額(⑤－⑥)",null,{"$f":"E102-E103","v":0},"出来高計",{"$f":"SUM(G99:G103)","v":0},"仕送り計",{"$f":"SUM(I99:I103)","v":0}]
[null,null,"⑧未請求残高(Ｃ－③)",null,{"$f":"IF(I94=\"仮払い\",\"\",IF(G97=\"\",0,G97-E100))","v":0}]
[]
[null,null,"現　金","手　形",null,null,"工事コード",{"$f":"IF($H$92=\"\",\"\",$H$92)","v":""}]
[null,null,{"$f":"IF(C70=\"\",\"\",C70)","v":""},{"$f":"IF(D70=\"\",\"\",D70)","v":""},null,null,"業者コード",{"$f":"IF(H70=\"\",\"\",H70)","v":""}]
[null,null,null,{"$f":"IF(D71=\"\",\"\",D71)","v":""},null,null,"外　注　費","労務外注費"]
[null,null,"科目コード","工種コード"]
[null,null,{"$f":"IF(C73=\"\",\"\",C73)","v":""},{"$f":"IF(D73=\"\",\"\",D73)","v":""},null,"前回迄",{"$f":"IF(E98=\"\",\"\",E98)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"$I$36","v":"【令和　　　年　　　月分】"}]