{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["請求書(一般用）","記入注意事項","請求書(一般用）記載例"],"not_rendered":{"charts":0,"images":1,"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":83,"n_cols":24,"rows_kept":83,"cut":false,"hidden":false,"merged":[[76,17,76,22],[81,1,81,11],[81,12,81,13],[80,1,80,11],[80,12,80,13],[81,17,81,22],[74,17,74,22],[70,17,70,22],[9,18,11,22],[64,1,67,22],[71,17,71,22],[70,12,70,13],[12,18,14,22],[41,6,43,7],[41,1,43,5],[32,15,37,22],[39,5,39,8],[69,17,69,22],[73,17,73,22],[1,1,3,22],[6,22,7,22],[6,16,7,16],[6,17,7,18],[12,17,14,17],[6,23,7,23],[82,1,82,11],[82,12,82,13],[82,17,82,22],[19,1,20,2],[80,17,80,22],[9,1,12,12],[9,13,12,14],[19,3,20,8],[6,19,7,19],[75,17,75,22],[26,15,31,22],[15,2,16,13],[6,20,7,20],[6,21,7,21],[72,17,72,22],[19,9,20,10],[19,11,20,14],[74,12,74,13],[75,1,75,11],[75,12,75,13],[23,1,27,4],[23,5,27,13],[73,1,73,11],[28,5,32,13],[41,9,43,13],[41,8,43,8],[28,1,37,1],[33,2,37,4],[28,2,32,4],[33,5,37,13],[39,1,39,4],[73,12,73,13],[69,12,69,13],[76,12,76,13],[70,1,70,11],[71,12,71,13],[72,1,72,11],[72,12,72,13],[74,1,74,11],[76,1,76,11],[69,1,69,11],[71,1,71,11],[79,17,79,22],[77,17,77,22],[78,17,78,22],[79,1,79,11],[79,12,79,13],[77,1,77,11],[77,12,77,13],[78,1,78,11],[78,12,78,13]]}
[]
[null,"請　　求　　書（一般用）"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"請求年月日",null,null,"年",null,"月",null,"日"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"工事所 御中"]
[]
[]
[null,null,null,null,null,null,null,null,null,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(AND(F29=\"\",F34=\"\"),\"\",SUM(F29:N38))","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,{"$f":"IF(F29=\"\",\"\",IF(F40=\"\",\"消費税率を選択してください\",IF(OR(F40=\"8%(軽)\",F40=\"免税8％(軽)\"),ROUNDDOWN(F29*8%,0),IF(F40=\"0%\",ROUNDDOWN(F29*0%,0),IF(OR(F40=\"10%\",F40=\"免税10％\"),ROUNDDOWN(F29*10%,0))))))","v":""}]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,{"$f":"IF(AND(O71=\"\",P71=\"\"),\"\",ROUNDDOWN(O71*P71,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(O72=\"\",P72=\"\"),\"\",ROUNDDOWN(O72*P72,0))","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,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,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":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["記入注意事項"]
[]
["　　　　 １．本用紙は材料の納品等、出来高査定を伴わない請求に使用して下さい。"]
[]
["　　　　 ２．黄色のセルに入力して下さい。"]
[]
["　　　　 ３．水色のセルは自動計算されますが、必要に応じて上書き修正できます。"]
[]
["　　　　 ４．※欄は当社使用欄ですので、記入しないで下さい。"]
[]
["　　　　 ５．請求書の提出期限は当社指定締切日後３日以内です。"]
[]
["　　　　 ６．注文書･注文請書を取り交している場合は,当該注文番号を記入して下さい。"]
[]
["　　　　 ７．取引先コードは必ず記入して下さい。"]
[]
["　　　　 ８．取引先コードのない業者は、弊社職員の指示に従って下さい。"]
[]
["　　　　 ９．請求内訳書は内容が確認できれば任意の書式でもかまいせん。"]
[]
["　　　　１０．白黒印刷設定をしていますので、そのまま印刷して提出して下さい。"]
[]
["　　　　１１．弊社には請求書・請求内訳書とも２部ずつ提出して下さい。"]
[]
["　　　　１２．インボイス登録事業者は必ず登録番号を記載して下さい。"]

{"sheet":"請求書(一般用）記載例","index":2,"n_rows":83,"n_cols":24,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,1,3,22],[6,16,7,16],[6,17,7,18],[6,19,7,19],[6,20,7,20],[6,21,7,21],[6,22,7,22],[6,23,7,23],[9,1,12,12],[9,13,12,14],[9,18,11,22],[12,17,14,17],[12,18,14,22],[15,2,16,13],[19,1,20,2],[19,3,20,8],[19,9,20,10],[19,11,20,14],[41,9,43,13],[26,15,31,22],[28,1,37,1],[28,2,32,4],[28,5,32,13],[32,15,37,22],[33,2,37,4],[33,5,37,13],[23,1,27,4],[23,5,27,13],[39,1,39,4],[39,5,39,8],[41,1,43,5],[41,6,43,7],[41,8,43,8],[64,1,67,22],[69,1,69,11],[69,12,69,13],[69,17,69,22],[70,1,70,11],[70,12,70,13],[70,17,70,22],[71,1,71,11],[71,12,71,13],[71,17,71,22],[72,1,72,11],[72,12,72,13],[72,17,72,22],[73,1,73,11],[73,12,73,13],[73,17,73,22],[74,1,74,11],[74,12,74,13],[74,17,74,22],[75,1,75,11],[75,12,75,13],[75,17,75,22],[76,1,76,11],[76,12,76,13],[76,17,76,22],[77,1,77,11],[77,12,77,13],[77,17,77,22],[78,1,78,11],[78,12,78,13],[78,17,78,22],[79,1,79,11],[79,12,79,13],[79,17,79,22],[80,1,80,11],[80,12,80,13],[80,17,80,22],[81,1,81,11],[81,12,81,13],[81,17,81,22],[82,1,82,11],[82,12,82,13],[82,17,82,22]]}
[]
[null,"請　　求　　書（一般用）"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"請求年月日",2023,null,"年",8,"月",20,"日"]
[]
[]
[null,"S．Kマンション",null,null,null,null,null,null,null,null,null,null,null,"工事所 御中",null,null,null,null,30123456]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ｔ","1234567891234"]
[]
[]
[null,null,"下記の通り請求いたします。"]
[]
[]
[]
[null,8,null,"月分請求内訳書",null,null,null,null,null,1,null,"枚 (本用紙を含む)"]
[]
[]
[]
[null,"請 求 金 額",null,null,null,{"$f":"IF(AND(F29=\"\",F34=\"\"),\"\",SUM(F29:N38))","v":41800}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※工事所"]
[]
[null,"内　訳","税抜金額",null,null,38000]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※支社店"]
[null,null,"消費税額等",null,null,{"$f":"IF(F29=\"\",\"\",IF(F40=\"\",\"消費税率を選択してください\",IF(OR(F40=\"8%\",F40=\"免税8％\",F40=\"8%(軽)\",F40=\"免税8％(軽)\"),ROUNDDOWN(F29*8%,0),IF(F40=\"0%\",ROUNDDOWN(F29*0%,0),IF(OR(F40=\"10%\",F40=\"免税10％\"),ROUNDDOWN(F29*10%,0))))))","v":3800}]
[]
[]
[]
[]
[]
[null,"消費税率",null,null,null,"10%"]
[]
[null,"注文番号",null,null,null,null,"30",null,"－","0012345"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"請　　求　　内　　訳　　書"]
[]
[]
[]
[]
[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,100,{"$f":"IF(AND(O71=\"\",P71=\"\"),\"\",ROUNDDOWN(O71*P71,0))","v":100}]
[null,"フラットファイル",null,null,null,null,null,null,null,null,null,null,"個",null,2,200,{"$f":"IF(AND(O72=\"\",P72=\"\"),\"\",ROUNDDOWN(O72*P72,0))","v":400}]
[null,"シャープペンシル",null,null,null,null,null,null,null,null,null,null,"個",null,3,300,900]
[null,"ボールペン",null,null,null,null,null,null,null,null,null,null,"個",null,4,400,1600]
[null,"セロテープ",null,null,null,null,null,null,null,null,null,null,"個",null,5,500,2500]
[null,"セロテープ",null,null,null,null,null,null,null,null,null,null,"個",null,6,600,3600]
[null,"ブルーシート",null,null,null,null,null,null,null,null,null,null,"個",null,7,700,4900]
[null,"ステープラー",null,null,null,null,null,null,null,null,null,null,"個",null,8,800,6400]
[null,"消しゴム",null,null,null,null,null,null,null,null,null,null,"個",null,9,900,8100]
[null,"輪ゴム",null,null,null,null,null,null,null,null,null,null,"個",null,10,1000,10000]
[null,"値引き",null,null,null,null,null,null,null,null,null,null,"式",null,1,-500,-500]
[null,"計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,38000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(O83=\"\",P83=\"\"),\"\",ROUNDDOWN(O83*P83,0))","v":""}]