{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["利用方法","表紙記入例","表紙入力シート","明細書記入例","明細書入力シート"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":72,"n_cols":3,"rows_kept":72,"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,null,"特記事項等ある場合は備考欄に記入して下さい。"]
[]
[null,null,"ページ削除ボタンを押すと、２ページ目の請求内訳書が削除されます。"]
[]
[null,"４．提出について"]
[]
[null,null,"当請求書の提出部数は１部です。"]
[]
[null,null,"弊社担当者が貴社専用請求書（納品書）にサインをしている場合、当請求書にて提出する場合"]
[null,null,"であっても、貴社専用請求書も添付のうえ提出して下さい。"]
[]
[null,null,"不明な点がございましたら、経理担当（樋口・中俣）まで連絡下さい。"]

{"sheet":"表紙記入例","index":1,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[26,10,26,12],[27,1,31,1],[18,1,18,2],[18,5,19,8],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[21,10,21,12],[17,1,17,2],[17,6,17,8],[17,10,17,12],[13,1,13,2],[13,5,13,6],[13,7,13,8],[13,10,13,11],[14,1,14,2],[14,5,14,6],[14,7,14,12],[15,1,15,2],[15,5,15,6],[15,7,15,8],[15,10,15,12],[16,1,16,2],[12,1,12,2],[7,5,7,6],[7,7,7,11],[8,1,8,2],[8,5,8,7],[8,8,8,12],[9,5,9,12],[10,1,10,2],[10,5,10,11],[11,1,11,2],[11,5,11,8],[11,9,11,12],[6,5,6,6],[1,5,1,6],[1,7,1,11],[2,1,2,3],[4,1,4,3],[5,5,5,6]]}
[]
[null,null,null,null,null,"請求年月日",null,"2023-10-31"]
[null,"請　求　書　（内税）"]
[]
[null,"株式会社　森 下 組　御中"]
[null,null,null,null,null,"請求部門",null,"① 土木","2 建築","3 機材","4 総務営業","⑤ 東京"]
[null,null,null,null,null,"業者コード"]
[null,null,null,null,null,"登録番号",null,"T0123456789123"]
[null,"請求金額",null,{"$f":"D26","v":17316},null,"　住所･社名･電話"]
[null,null,null,null,null,"新潟県湯沢町大字湯沢***-*"]
[null,"前月繰越額",null,null,null,"株式会社　○○○商店",null,null,null,null,null,null,"㊞"]
[null,"10％対象",null,{"$f":"IF(ISERROR(D17-D14-D16)=TRUE,\"\",D17-D14-D16)","v":10000},null,"代表取締役　○○○○",null,null,null,"012（345）6789"]
[null,"内消費税",null,{"$f":"IF(ISERROR(ROUND(D12*10/110,0))=TRUE,\"\",ROUND(D12*10/110,0))","v":909}]
[null,"8％対象",null,{"$f":"IF(SUMIF(明細書記入例!G:G,\"8%\",明細書記入例!F:F)+SUMIF(明細書記入例!G:G,\"軽8%\",明細書記入例!F:F)=0,\"\",SUMIF(明細書記入例!G:G,\"8%\",明細書記入例!F:F)+SUMIF(明細書記入例!G:G,\"軽8%\",明細書記入例!F:F))","v":5500},null,"取引銀行",null,"〇〇",null,"銀行","〇〇",null,"支店"]
[null,"内消費税",null,{"$f":"IF(ISERROR(ROUND(D14*8/108,0))=TRUE,\"\",ROUND(D14*8/108,0))","v":407},null,"口座名",null,"カ.〇〇〇シヨウテン"]
[null,"非・不課税",null,{"$f":"IF(SUMIF(明細書記入例!G:G,\"非・不課税\",明細書記入例!F:F)=0,\"\",SUMIF(明細書記入例!G:G,\"非・不課税\",明細書記入例!F:F))","v":900},null,"口座番号",null,"当座",null,"№","0123456"]
[null,"当月税込計",null,{"$f":"SUBTOTAL(9,明細書記入例!F:F)","v":16400}]
[null,"当月内税計",null,{"$f":"SUM(D13,D15)","v":1316},null,"備考",null,null,null,null,"支払方法"]
[null,"当月請求合計額",null,{"$f":"SUM(D17:D18)","v":17716},null,null,null,null,null,null,"現金",30,"％"]
[null,"当月値引額(10%)",null,{"$f":"IF(D25=\"\",\"\",D25-D22-D24)","v":244},null,null,null,null,null,null,"でんさい",70,"％"]
[null,"内消費税",null,{"$f":"IF(D20=\"\",\"\",ROUND(D20*10/110,0))","v":22}]
[null,"当月値引額(8%)",null,{"$f":"IF(D25=\"\",\"\",ROUND(D25*D14/D17,0))","v":134},null,"社長印","総務検印","総務検印",null,null,"請求書受付印"]
[null,"内消費税",null,{"$f":"IF(D22=\"\",\"\",ROUND(D22*8/108,0))","v":10}]
[null,"当月値引額(非･不)",null,{"$f":"IF(D25=\"\",\"\",ROUND(D25*D16/D17,0))","v":22}]
[null,"値引計",null,400]
[null,"差引今回請求額",null,{"$f":"IF(ISERROR(D11+D19-D25)=TRUE,IF(D11+D25=0,\"\",D11-D25),D11+D19-D25)","v":17316},null,"所属長印","経理担当","内容ﾁｪｯｸ","検　算"]
[null,null,null,"※端数調整して下さい",null,null,null,null,null,null,"未払分類"]
[null,"支払決済金額","上記請求金額"]
[null,null,"支払時値引額"]
[null,null,"相殺・保留額"]
[null,null,"差引支払決済額"]
[null,null,"留意事項"]

{"sheet":"表紙入力シート","index":2,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,1,23,2],[7,7,7,11],[27,1,31,1],[5,5,5,6],[8,1,8,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[19,1,19,2],[20,1,20,2],[24,1,24,2],[25,1,25,2],[21,1,21,2],[22,1,22,2],[21,10,21,12],[26,10,26,12],[8,5,8,7],[8,8,8,12],[17,6,17,8],[13,10,13,11],[13,7,13,8],[15,7,15,8],[14,7,14,12],[15,10,15,12],[17,10,17,12],[13,5,13,6],[14,5,14,6],[15,5,15,6],[1,7,1,11],[11,9,11,12],[17,1,17,2],[18,1,18,2],[9,5,9,12],[10,5,10,11],[11,5,11,8],[1,5,1,6],[2,1,2,3],[4,1,4,3],[6,5,6,6],[7,5,7,6],[18,5,19,8]]}
[]
[null,null,null,null,null,"請求年月日"]
[null,"請　求　書　（内税）"]
[]
[null,"株式会社　森 下 組　御中"]
[null,null,null,null,null,"請求部門",null,"1 土木","2 建築","3 機材","4 総務営業","5 東京"]
[null,null,null,null,null,"業者コード"]
[null,null,null,null,null,"登録番号"]
[null,"請求金額",null,{"$f":"D26","v":0},null,"　住所･社名･電話"]
[]
[null,"前月繰越額",null,null,null,null,null,null,null,null,null,null,"㊞"]
[null,"10％対象",null,{"$f":"IF(ISERROR(D17-D14-D16)=TRUE,\"\",D17-D14-D16)","v":0},null,null,null,null,null,"　　　　　　（　　　　　）"]
[null,"内消費税",null,{"$f":"IF(ISERROR(ROUND(D12*10/110,0))=TRUE,\"\",ROUND(D12*10/110,0))","v":0}]
[null,"8％対象",null,{"$f":"IF(SUMIF(明細書入力シート!G:G,\"8%\",明細書入力シート!F:F)+SUMIF(明細書入力シート!G:G,\"軽8%\",明細書入力シート!F:F)=0,0,SUMIF(明細書入力シート!G:G,\"8%\",明細書入力シート!F:F)+SUMIF(明細書入力シート!G:G,\"軽8%\",明細書入力シート!F:F))","v":0},null,"取引銀行",null,null,null,"銀行",null,null,"支店"]
[null,"内消費税",null,{"$f":"IF(ISERROR(ROUND(D14*8/108,0))=TRUE,\"\",ROUND(D14*8/108,0))","v":0},null,"口座名"]
[null,"非・不課税",null,{"$f":"IF(SUMIF(明細書入力シート!G:G,\"非・不課税\",明細書入力シート!F:F)=0,0,SUMIF(明細書入力シート!G:G,\"非・不課税\",明細書入力シート!F:F))","v":0},null,"口座番号",null,null,null,"№"]
[null,"当月税込計",null,{"$f":"SUBTOTAL(9,明細書入力シート!F:F)","v":0}]
[null,"当月内税計",null,{"$f":"SUM(D13,D15)","v":0},null,"備考",null,null,null,null,"支払方法"]
[null,"当月請求合計額",null,{"$f":"D17","v":0},null,null,null,null,null,null,"現金",null,"％"]
[null,"当月値引額(10%)",null,{"$f":"IF(D25=\"\",\"\",D25-D22-D24)","v":""},null,null,null,null,null,null,"でんさい",null,"％"]
[null,"内消費税",null,{"$f":"IF(D25=\"\",\"\",ROUND(D20*10/110,0))","v":""}]
[null,"当月値引額(8%)",null,{"$f":"IF(D25=\"\",\"\",ROUND(D25*D14/D17,0))","v":""},null,"社長印","総務検印","総務検印",null,null,"請求書受付印"]
[null,"内消費税",null,{"$f":"IF(D22=\"\",\"\",ROUND(D22*8/108,0))","v":""}]
[null,"当月値引額(非･不)",null,{"$f":"IF(D25=\"\",\"\",ROUND(D25*D16/D17,0))","v":""}]
[null,"値引計"]
[null,"差引今回請求額",null,{"$f":"IF(ISERROR(D11+D19-D25)=TRUE,IF(D11+D25=0,\"\",D11-D25),D11+D19-D25)","v":0},null,"所属長印","経理担当","内容ﾁｪｯｸ","検　算"]
[null,null,null,{"$f":"IF(ISERROR(IF(D20+D22+D24=D25,\"\",\"※端数調整して下さい\"))=TRUE,\"\",IF(D20+D22+D24=D25,\"\",\"※端数調整して下さい\"))","v":""},null,null,null,null,null,null,"未払分類"]
[null,"支払決済金額","上記請求金額"]
[null,null,"支払時値引額"]
[null,null,"相殺・保留額"]
[null,null,"差引支払決済額"]
[null,null,"留意事項"]

{"sheet":"明細書記入例","index":3,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,6,0,7],[1,6,1,7],[2,5,2,7],[3,4,4,7],[6,1,6,4],[34,2,36,3],[34,5,34,6],[34,7,36,7],[35,4,35,6],[36,4,36,6]]}
[null,null,null,null,null,"整理番号",1]
[null,null,null,null,null,"納入年月日","2023-10-10"]
["　請　求　内　訳　書　（内税）",null,null,null,"納入者名"]
[null,null,null,null,{"$f":"IF(表紙記入例!$F$11=\"\",\"\",表紙記入例!$F$11)","v":"株式会社　○○○商店"}]
["請求部門","① 土木"]
["工事コード","1230001"]
["工事件名","○○○○○工事"]
[]
["科目コード","工種コード","品名寸法","数量","単価","金額(税込)","税区分","備考"]
[null,null,"○○○○○○",1,10000,{"$f":"IF(ROUND(D10*E10,0)=0,\"\",ROUND(D10*E10,0))","v":10000}]
[null,null,"□□□□□□",5,500,{"$f":"IF(ROUND(D11*E11,0)=0,\"\",ROUND(D11*E11,0))","v":2500},0.08]
[null,null,"△△△△△△",2,1500,3000,"軽8%"]
[null,null,"◇◇◇◇◇◇",3,300,900,"非・不課税"]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[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(SUBTOTAL(9,F10:F32)=0,\"\",SUBTOTAL(9,F10:F32))","v":16400}]
[null,null,null,null,null,null,null,"弊社担当者"]
["納入方法","店頭渡･配達","[お願い]\n● 各部門単位にまとめ、それぞれに表紙を添付して下さい。\n● 毎月20日締切、25日各部門必着です。\n● 工事コード頭1･土木、2･建築､3･機材、5･東京支店です。",null,"備考"]
["配達場所","現場･倉庫･事務所"]

{"sheet":"明細書入力シート","index":4,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,6,1,7],[0,6,0,7],[6,1,6,4],[34,2,36,3],[2,5,2,7],[3,4,4,7],[34,5,34,6],[35,4,35,6],[36,4,36,6],[34,7,36,7]]}
[null,null,null,null,null,"整理番号"]
[null,null,null,null,null,"納入年月日"]
["　請　求　内　訳　書　（内税）",null,null,null,"納入者名"]
[]
["請求部門"]
["工事コード"]
["工事件名"]
[]
["科目コード","工種コード","品名寸法","数量","単価","金額(税込)","税区分","備考"]
[null,null,null,null,null,{"$f":"IF(ROUND(D10*E10,0)=0,\"\",ROUND(D10*E10,0))","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(ROUND(D14*E14,0)=0,\"\",ROUND(D14*E14,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,{"$f":"IF(SUBTOTAL(9,F10:F32)=0,\"\",SUBTOTAL(9,F10:F32))","v":""}]
[null,null,null,null,null,null,null,"弊社担当者"]
["納入方法","店頭渡･配達","[お願い]\n● 各部門単位にまとめ、それぞれに表紙を添付して下さい。\n● 毎月20日締切、25日各部門必着です。\n● 工事コード頭1･土木、2･建築､3･機材、5･東京支店です。",null,"備考"]
["配達場所","現場･倉庫･事務所"]