{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["請求書","請求時仕訳","入金時仕訳"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,1,17],[3,11,3,12],[3,13,3,17],[4,11,4,12],[4,13,4,17],[5,1,5,7],[5,11,5,12],[5,13,5,17],[10,11,10,17],[11,11,11,17],[13,1,13,7],[14,1,15,7],[17,1,18,1],[17,2,17,7],[18,2,18,7],[6,1,6,7],[7,1,7,7],[7,10,7,17],[8,1,8,7],[8,10,8,17],[9,1,9,7],[9,11,9,17],[24,1,24,2],[24,3,24,7],[24,11,24,12],[24,16,24,17],[25,1,25,2],[25,3,25,7],[25,11,25,12],[25,16,25,17],[19,2,19,7],[22,1,22,2],[22,3,22,7],[22,11,22,12],[22,16,22,17],[23,1,23,2],[23,3,23,7],[23,11,23,12],[23,16,23,17],[26,1,26,2],[26,3,26,7],[26,11,26,12],[26,16,26,17],[27,1,27,2],[27,3,27,7],[27,11,27,12],[27,16,27,17],[26,14,26,15],[27,14,27,15],[28,1,28,2],[28,3,28,7],[28,11,28,12],[28,16,28,17],[29,1,29,2],[29,3,29,7],[29,11,29,12],[29,16,29,17],[28,14,28,15],[29,14,29,15],[30,1,30,2],[30,3,30,7],[30,11,30,12],[30,16,30,17],[31,1,31,2],[31,3,31,7],[31,11,31,12],[31,16,31,17],[30,14,30,15],[31,14,31,15],[32,1,32,2],[32,3,32,7],[32,11,32,12],[32,16,32,17],[33,1,33,2],[33,3,33,7],[33,11,33,12],[33,16,33,17],[32,14,32,15],[33,14,33,15],[34,1,34,2],[34,3,34,7],[34,11,34,12],[34,16,34,17],[35,1,35,2],[35,3,35,7],[35,11,35,12],[35,16,35,17],[34,14,34,15],[35,14,35,15],[36,1,36,2],[36,3,36,7],[36,11,36,12],[36,16,36,17],[37,1,37,2],[37,3,37,7],[37,11,37,12],[37,16,37,17],[36,14,36,15],[37,14,37,15],[43,1,43,17],[44,1,46,17],[40,1,40,2],[40,3,40,4],[40,5,40,6],[41,1,41,2],[41,3,41,4],[41,5,41,6],[39,1,39,2],[39,3,39,4],[39,5,39,6],[40,16,40,17],[39,16,39,17],[38,16,38,17],[38,14,38,15],[39,14,39,15],[40,14,40,15],[22,14,22,15],[23,14,23,15],[24,14,24,15],[25,14,25,15]]}
[]
[null,"請求書"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"発行日",null,"2025-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,"請求番号"]
[null,"〇〇〇〇株式会社",null,null,null,null,null,null,null,null,null,"登録番号"]
[null,1000000]
[null,"東京都千代田区0-1-2 〇〇ビル 3F",null,null,null,null,null,null,null,null,"●●●●株式会社"]
[null,null,null,null,null,null,null,null,null,null,1000000]
[null,"下記の通り、ご請求申し上げます。",null,null,null,null,null,null,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(Q41)","v":328000}]
[]
[]
[null,"振込先"]
[]
[null,"振込期日","2025-03-31"]
[null,"振込手数料は御社のご負担にてお願いいたします。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"仕訳出力用"]
[null,"日付",null,"内容",null,null,null,null,"税区分","数量","単位","単価（税抜）",null,"税率","金額（税抜）",null,"金額（税込）",null,null,"勘定科目","補助科目","部門"]
[null,"2025-02-28",null,"○○代金　2月分",null,null,null,null,null,1,"式",200000,null,{"$f":"_xlfn.IFS(D24=\"\", \"\", I24=\"\", 10%, I24=\"※\", 8%,I24=\"非\",0)","v":0.1},{"$f":"IF($L24=\"\", \"\", $J24*$L24)","v":200000},null,{"$f":"IF(O24=\"\",\"\",ROUNDDOWN(O24*(N24+1),0))","v":220000},null,null,"売上","○○","本社"]
[null,"2025-02-28",null,"××代金　2月分",null,null,null,null,"※",50,"個",2000,null,{"$f":"_xlfn.IFS(D25=\"\", \"\", I25=\"\", 10%, I25=\"※\", 8%,I25=\"非\",0)","v":0.08},{"$f":"IF($L25=\"\", \"\", $J25*$L25)","v":100000},null,{"$f":"IF(O25=\"\",\"\",ROUNDDOWN(O25*(N25+1),0))","v":108000},null,null,"売上","××","本社"]
[null,"2025-02-28",null,"▲▲立替金　2月分",null,null,null,null,"非",1,"式",10000,null,{"$f":"_xlfn.IFS(D26=\"\", \"\", I26=\"\", 10%, I26=\"※\", 8%,I26=\"非\",0)","v":0},10000,null,10000,null,null,"立替金",null,"本社"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D27=\"\", \"\", I27=\"\", 10%, I27=\"※\", 8%,I27=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D28=\"\", \"\", I28=\"\", 10%, I28=\"※\", 8%,I28=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D29=\"\", \"\", I29=\"\", 10%, I29=\"※\", 8%,I29=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D30=\"\", \"\", I30=\"\", 10%, I30=\"※\", 8%,I30=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D31=\"\", \"\", I31=\"\", 10%, I31=\"※\", 8%,I31=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D32=\"\", \"\", I32=\"\", 10%, I32=\"※\", 8%,I32=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D33=\"\", \"\", I33=\"\", 10%, I33=\"※\", 8%,I33=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D34=\"\", \"\", I34=\"\", 10%, I34=\"※\", 8%,I34=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D35=\"\", \"\", I35=\"\", 10%, I35=\"※\", 8%,I35=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D36=\"\", \"\", I36=\"\", 10%, I36=\"※\", 8%,I36=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D37=\"\", \"\", I37=\"\", 10%, I37=\"※\", 8%,I37=\"非\",0)","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(D38=\"\", \"\", I38=\"\", 10%, I38=\"※\", 8%,I38=\"非\",0)","v":""},"",null,""]
[null,"※は軽減税率対象、非は非課税対象です。",null,null,null,null,null,null,null,null,null,null,null,null,"小計",null,{"$f":"SUM(F41:G42)","v":300000}]
[null,"税率区分",null,"消費税",null,"金額（税抜）",null,null,null,null,null,null,null,null,"消費税",null,{"$f":"SUM(D41:E42)","v":28000}]
[null,"10%対象",null,{"$f":"ROUND(F41*10%,1)","v":20000},null,{"$f":"SUMIF(N24:N38, 10%, O24:P38)","v":200000},null,null,null,null,null,null,null,null,"合計",null,{"$f":"SUM(Q39:R40)","v":328000}]
[null,"8%対象",null,{"$f":"ROUND(F42*8%,1)","v":8000},null,{"$f":"SUMIF(N24:N38, 8%, O24:P38)","v":100000}]
[]
[null,"備考"]

{"sheet":"請求時仕訳","index":1,"n_rows":20,"n_cols":25,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["必",null,null,"必","必",null,null,"必","必",null,"必",null,null,"必","必",null,null,null,null,"必",null,null,null,null,"必"]
["識別フラグ","伝票No","決算","取引日付","借方勘定科目","借方補助科目","借方部門","借方税区分","借方金額","借方税金額","貸方勘定科目","貸方補助科目","貸方部門","貸方税区分","貸方金額","貸方税金額","摘要","番号　","期日","タイプ","生成元","仕訳メモ","付箋１","付箋２","調整"]
["仕訳の識別番号を半角数字で記述。\n\n仕訳日記帳：2000\n\n振替伝票(1行)：2111\n振替伝票(複数行)\n 1行目：2110\n間の行：2100   \n最終行：2101","任意","空白：通常の仕訳（区切り文字のカンマは必要）\n中決：中間決算仕訳\n本決：本決算仕訳","（例）2025年4月1日の場合、次のいずれかで記述。\n「20250401」「2025/04/01」「2025/4/1」「R07/04/01」「R07/4/1」","勘定科目を入力。\n弥生会計に登録されている文字列と異なる場合は、インポートの際にマッチング設定をする。","同左。","同左。","借方勘定科目がない場合でも必須。","税込金額を入力。","空欄でOK(自動計算されます)","勘定科目を入力。\n弥生会計に登録されている文字列と異なる場合は、インポートの際にマッチング設定をする。","同左。","同左。","借方勘定科目がない場合でも必須。","税込金額を入力。","空欄でOK(自動計算されます)","半角64桁まで。","空欄でOK。","（例）2025年4月1日の場合、次のいずれかで記述。\n「20250401」「2025/04/01」「2025/4/1」「R07/04/01」「R07/4/1」\n\n空欄でOK。","取引タイプを0～3の数字で記述。\n\n0：仕訳データ\n1：出金伝票データ\n2：入金伝票データ\n3：振替伝票データ","空欄でOK。","半角180桁まで。","0は付箋なし。\n1~5で設定された付箋を入力。","0は付箋なし。\n1~5で設定された付箋を入力。","基本「no」でOK。"]
[]
[{"$f":"IF(I6=\"\", \"\", IF(AND(I5=\"\", I7=\"\"), 2111, IF(AND(I5=\"\", I7<>\"\"), 2110, IF(AND(I5<>\"\", I7=\"\"), 2101, 2100))))","v":2110},null,null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",請求書!$N$4)","v":"2025-03-01"},{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"未収入金\")","v":"未収入金"},null,null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"対象外\")","v":"対象外"},{"$f":"IF(請求書!Q24=\"\",\"\",請求書!Q24)","v":220000},null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",請求書!T24)","v":"売上"},{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",IF(請求書!U24=\"\",\"\",請求書!U24))","v":"○○"},{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",IF(請求書!V24=\"\",\"\",請求書!V24))","v":"本社"},{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",請求書!N24)","v":0.1},{"$f":"I6","v":220000},null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",請求書!$B$6&\" \"&請求書!D24)","v":"〇〇〇〇株式会社 ○○代金　2月分"},null,null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"3\")","v":"3"},null,null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"0\")","v":"0"},{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"0\")","v":"0"},{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"no\")","v":"no"}]
[{"$f":"IF(I7=\"\", \"\", IF(AND(I6=\"\", I8=\"\"), 2111, IF(AND(I6=\"\", I8<>\"\"), 2110, IF(AND(I6<>\"\", I8=\"\"), 2101, 2100))))","v":2100},null,null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",請求書!$N$4)","v":"2025-03-01"},{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"未収入金\")","v":"未収入金"},null,null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"対象外\")","v":"対象外"},{"$f":"IF(請求書!Q25=\"\",\"\",請求書!Q25)","v":108000},null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",請求書!T25)","v":"売上"},{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",IF(請求書!U25=\"\",\"\",請求書!U25))","v":"××"},{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",IF(請求書!V25=\"\",\"\",請求書!V25))","v":"本社"},{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",請求書!N25)","v":0.08},{"$f":"I7","v":108000},null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",請求書!$B$6&\" \"&請求書!D25)","v":"〇〇〇〇株式会社 ××代金　2月分"},null,null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"3\")","v":"3"},null,null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"0\")","v":"0"},"0",{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"no\")","v":"no"}]
[2101,null,null,{"$f":"IF(OR($I8=0,$I8=\"\"),\"\",請求書!$N$4)","v":"2025-03-01"},"未収入金",null,null,"対象外",{"$f":"IF(請求書!Q26=\"\",\"\",請求書!Q26)","v":10000},null,{"$f":"IF(OR($I8=0,$I8=\"\"),\"\",請求書!T26)","v":"立替金"},{"$f":"IF(OR($I8=0,$I8=\"\"),\"\",IF(請求書!U26=\"\",\"\",請求書!U26))","v":""},{"$f":"IF(OR($I8=0,$I8=\"\"),\"\",IF(請求書!V26=\"\",\"\",請求書!V26))","v":"本社"},{"$f":"IF(OR($I8=0,$I8=\"\"),\"\",請求書!N26)","v":0},10000,null,{"$f":"IF(OR($I8=0,$I8=\"\"),\"\",請求書!$B$6&\" \"&請求書!D26)","v":"〇〇〇〇株式会社 ▲▲立替金　2月分"},null,null,"3",null,null,"0","0","no"]
["",null,null,{"$f":"IF(OR($I9=0,$I9=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q27=\"\",\"\",請求書!Q27)","v":""},null,{"$f":"IF(OR($I9=0,$I9=\"\"),\"\",請求書!T27)","v":""},{"$f":"IF(OR($I9=0,$I9=\"\"),\"\",IF(請求書!U27=\"\",\"\",請求書!U27))","v":""},{"$f":"IF(OR($I9=0,$I9=\"\"),\"\",IF(請求書!V27=\"\",\"\",請求書!V27))","v":""},{"$f":"IF(OR($I9=0,$I9=\"\"),\"\",請求書!N27)","v":""},"",null,{"$f":"IF(OR($I9=0,$I9=\"\"),\"\",請求書!$B$6&\" \"&請求書!D27)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I10=0,$I10=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q28=\"\",\"\",請求書!Q28)","v":""},null,{"$f":"IF(OR($I10=0,$I10=\"\"),\"\",請求書!T28)","v":""},{"$f":"IF(OR($I10=0,$I10=\"\"),\"\",IF(請求書!U28=\"\",\"\",請求書!U28))","v":""},{"$f":"IF(OR($I10=0,$I10=\"\"),\"\",IF(請求書!V28=\"\",\"\",請求書!V28))","v":""},{"$f":"IF(OR($I10=0,$I10=\"\"),\"\",請求書!N28)","v":""},"",null,{"$f":"IF(OR($I10=0,$I10=\"\"),\"\",請求書!$B$6&\" \"&請求書!D28)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I11=0,$I11=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q29=\"\",\"\",請求書!Q29)","v":""},null,{"$f":"IF(OR($I11=0,$I11=\"\"),\"\",請求書!T29)","v":""},{"$f":"IF(OR($I11=0,$I11=\"\"),\"\",IF(請求書!U29=\"\",\"\",請求書!U29))","v":""},{"$f":"IF(OR($I11=0,$I11=\"\"),\"\",IF(請求書!V29=\"\",\"\",請求書!V29))","v":""},{"$f":"IF(OR($I11=0,$I11=\"\"),\"\",請求書!N29)","v":""},"",null,{"$f":"IF(OR($I11=0,$I11=\"\"),\"\",請求書!$B$6&\" \"&請求書!D29)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I12=0,$I12=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q30=\"\",\"\",請求書!Q30)","v":""},null,{"$f":"IF(OR($I12=0,$I12=\"\"),\"\",請求書!T30)","v":""},{"$f":"IF(OR($I12=0,$I12=\"\"),\"\",IF(請求書!U30=\"\",\"\",請求書!U30))","v":""},{"$f":"IF(OR($I12=0,$I12=\"\"),\"\",IF(請求書!V30=\"\",\"\",請求書!V30))","v":""},{"$f":"IF(OR($I12=0,$I12=\"\"),\"\",請求書!N30)","v":""},"",null,{"$f":"IF(OR($I12=0,$I12=\"\"),\"\",請求書!$B$6&\" \"&請求書!D30)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I13=0,$I13=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q31=\"\",\"\",請求書!Q31)","v":""},null,{"$f":"IF(OR($I13=0,$I13=\"\"),\"\",請求書!T31)","v":""},{"$f":"IF(OR($I13=0,$I13=\"\"),\"\",IF(請求書!U31=\"\",\"\",請求書!U31))","v":""},{"$f":"IF(OR($I13=0,$I13=\"\"),\"\",IF(請求書!V31=\"\",\"\",請求書!V31))","v":""},{"$f":"IF(OR($I13=0,$I13=\"\"),\"\",請求書!N31)","v":""},"",null,{"$f":"IF(OR($I13=0,$I13=\"\"),\"\",請求書!$B$6&\" \"&請求書!D31)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I14=0,$I14=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q32=\"\",\"\",請求書!Q32)","v":""},null,{"$f":"IF(OR($I14=0,$I14=\"\"),\"\",請求書!T32)","v":""},{"$f":"IF(OR($I14=0,$I14=\"\"),\"\",IF(請求書!U32=\"\",\"\",請求書!U32))","v":""},{"$f":"IF(OR($I14=0,$I14=\"\"),\"\",IF(請求書!V32=\"\",\"\",請求書!V32))","v":""},{"$f":"IF(OR($I14=0,$I14=\"\"),\"\",請求書!N32)","v":""},"",null,{"$f":"IF(OR($I14=0,$I14=\"\"),\"\",請求書!$B$6&\" \"&請求書!D32)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I15=0,$I15=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q33=\"\",\"\",請求書!Q33)","v":""},null,{"$f":"IF(OR($I15=0,$I15=\"\"),\"\",請求書!T33)","v":""},{"$f":"IF(OR($I15=0,$I15=\"\"),\"\",IF(請求書!U33=\"\",\"\",請求書!U33))","v":""},{"$f":"IF(OR($I15=0,$I15=\"\"),\"\",IF(請求書!V33=\"\",\"\",請求書!V33))","v":""},{"$f":"IF(OR($I15=0,$I15=\"\"),\"\",請求書!N33)","v":""},"",null,{"$f":"IF(OR($I15=0,$I15=\"\"),\"\",請求書!$B$6&\" \"&請求書!D33)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I16=0,$I16=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q34=\"\",\"\",請求書!Q34)","v":""},null,{"$f":"IF(OR($I16=0,$I16=\"\"),\"\",請求書!T34)","v":""},{"$f":"IF(OR($I16=0,$I16=\"\"),\"\",IF(請求書!U34=\"\",\"\",請求書!U34))","v":""},{"$f":"IF(OR($I16=0,$I16=\"\"),\"\",IF(請求書!V34=\"\",\"\",請求書!V34))","v":""},{"$f":"IF(OR($I16=0,$I16=\"\"),\"\",請求書!N34)","v":""},"",null,{"$f":"IF(OR($I16=0,$I16=\"\"),\"\",請求書!$B$6&\" \"&請求書!D34)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I17=0,$I17=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q35=\"\",\"\",請求書!Q35)","v":""},null,{"$f":"IF(OR($I17=0,$I17=\"\"),\"\",請求書!T35)","v":""},{"$f":"IF(OR($I17=0,$I17=\"\"),\"\",IF(請求書!U35=\"\",\"\",請求書!U35))","v":""},{"$f":"IF(OR($I17=0,$I17=\"\"),\"\",IF(請求書!V35=\"\",\"\",請求書!V35))","v":""},{"$f":"IF(OR($I17=0,$I17=\"\"),\"\",請求書!N35)","v":""},"",null,{"$f":"IF(OR($I17=0,$I17=\"\"),\"\",請求書!$B$6&\" \"&請求書!D35)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I18=0,$I18=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q36=\"\",\"\",請求書!Q36)","v":""},null,{"$f":"IF(OR($I18=0,$I18=\"\"),\"\",請求書!T36)","v":""},{"$f":"IF(OR($I18=0,$I18=\"\"),\"\",IF(請求書!U36=\"\",\"\",請求書!U36))","v":""},{"$f":"IF(OR($I18=0,$I18=\"\"),\"\",IF(請求書!V36=\"\",\"\",請求書!V36))","v":""},{"$f":"IF(OR($I18=0,$I18=\"\"),\"\",請求書!N36)","v":""},"",null,{"$f":"IF(OR($I18=0,$I18=\"\"),\"\",請求書!$B$6&\" \"&請求書!D36)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I19=0,$I19=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q37=\"\",\"\",請求書!Q37)","v":""},null,{"$f":"IF(OR($I19=0,$I19=\"\"),\"\",請求書!T37)","v":""},{"$f":"IF(OR($I19=0,$I19=\"\"),\"\",IF(請求書!U37=\"\",\"\",請求書!U37))","v":""},{"$f":"IF(OR($I19=0,$I19=\"\"),\"\",IF(請求書!V37=\"\",\"\",請求書!V37))","v":""},{"$f":"IF(OR($I19=0,$I19=\"\"),\"\",請求書!N37)","v":""},"",null,{"$f":"IF(OR($I19=0,$I19=\"\"),\"\",請求書!$B$6&\" \"&請求書!D37)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I20=0,$I20=\"\"),\"\",請求書!$N$4)","v":""},"",null,null,"",{"$f":"IF(請求書!Q38=\"\",\"\",請求書!Q38)","v":""},null,{"$f":"IF(OR($I20=0,$I20=\"\"),\"\",請求書!T38)","v":""},{"$f":"IF(OR($I20=0,$I20=\"\"),\"\",IF(請求書!U38=\"\",\"\",請求書!U38))","v":""},{"$f":"IF(OR($I20=0,$I20=\"\"),\"\",IF(請求書!V38=\"\",\"\",請求書!V38))","v":""},{"$f":"IF(OR($I20=0,$I20=\"\"),\"\",請求書!N38)","v":""},"",null,{"$f":"IF(OR($I20=0,$I20=\"\"),\"\",請求書!$B$6&\" \"&請求書!D38)","v":""},null,null,"",null,null,"","",""]

{"sheet":"入金時仕訳","index":2,"n_rows":20,"n_cols":25,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["必",null,null,"必","必",null,null,"必","必",null,"必",null,null,"必","必",null,null,null,null,"必",null,null,null,null,"必"]
["識別フラグ","伝票No","決算","取引日付","借方勘定科目","借方補助科目","借方部門","借方税区分","借方金額","借方税金額","貸方勘定科目","貸方補助科目","貸方部門","貸方税区分","貸方金額","貸方税金額","摘要","番号　","期日","タイプ","生成元","仕訳メモ","付箋１","付箋２","調整"]
["仕訳の識別番号を半角数字で記述。\n\n仕訳日記帳：2000\n\n振替伝票(1行)：2111\n振替伝票(複数行)\n 1行目：2110\n間の行：2100   \n最終行：2101","任意","空白：通常の仕訳（区切り文字のカンマは必要）\n中決：中間決算仕訳\n本決：本決算仕訳","（例）2025年4月1日の場合、次のいずれかで記述。\n「20250401」「2025/04/01」「2025/4/1」「R07/04/01」「R07/4/1」","勘定科目を入力。\n弥生会計に登録されている文字列と異なる場合は、インポートの際にマッチング設定をする。","同左。","同左。","借方勘定科目がない場合でも必須。","税込金額を入力。","空欄でOK(自動計算されます)","勘定科目を入力。\n弥生会計に登録されている文字列と異なる場合は、インポートの際にマッチング設定をする。","同左。","同左。","借方勘定科目がない場合でも必須。","税込金額を入力。","空欄でOK(自動計算されます)","半角64桁まで。","空欄でOK。","（例）2025年4月1日の場合、次のいずれかで記述。\n「20250401」「2025/04/01」「2025/4/1」「R07/04/01」「R07/4/1」\n\n空欄でOK。","取引タイプを0～3の数字で記述。\n\n0：仕訳データ\n1：出金伝票データ\n2：入金伝票データ\n3：振替伝票データ","空欄でOK。","半角180桁まで。","0は付箋なし。\n1~5で設定された付箋を入力。","0は付箋なし。\n1~5で設定された付箋を入力。","基本「no」でOK。"]
[]
[{"$f":"IF(I6=\"\", \"\", IF(AND(I5=\"\", I7=\"\"), 2111, IF(AND(I5=\"\", I7<>\"\"), 2110, IF(AND(I5<>\"\", I7=\"\"), 2101, 2100))))","v":2110},null,null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",請求書!$C$20)","v":"2025-03-31"},{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"普通預金\")","v":"普通預金"},null,null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"対象外\")","v":"対象外"},{"$f":"IF(請求書!Q24=\"\",\"\",請求書!Q24)","v":220000},null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"未収入金\")","v":"未収入金"},null,null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"対象外\")","v":"対象外"},{"$f":"I6","v":220000},null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",請求書!$B$6&\" \"&請求書!D24)","v":"〇〇〇〇株式会社 ○○代金　2月分"},null,null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"3\")","v":"3"},null,null,{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"0\")","v":"0"},{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"0\")","v":"0"},{"$f":"IF(OR($I6=0,$I6=\"\"),\"\",\"no\")","v":"no"}]
[{"$f":"IF(I7=\"\", \"\", IF(AND(I6=\"\", I8=\"\"), 2111, IF(AND(I6=\"\", I8<>\"\"), 2110, IF(AND(I6<>\"\", I8=\"\"), 2101, 2100))))","v":2100},null,null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",請求書!$C$20)","v":"2025-03-31"},{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"普通預金\")","v":"普通預金"},null,null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"対象外\")","v":"対象外"},{"$f":"IF(請求書!Q25=\"\",\"\",請求書!Q25)","v":108000},null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"未収入金\")","v":"未収入金"},null,null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"対象外\")","v":"対象外"},{"$f":"I7","v":108000},null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",請求書!$B$6&\" \"&請求書!D25)","v":"〇〇〇〇株式会社 ××代金　2月分"},null,null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"3\")","v":"3"},null,null,{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"0\")","v":"0"},"0",{"$f":"IF(OR($I7=0,$I7=\"\"),\"\",\"no\")","v":"no"}]
[2101,null,null,{"$f":"IF(OR($I8=0,$I8=\"\"),\"\",請求書!$C$20)","v":"2025-03-31"},"普通預金",null,null,"対象外",{"$f":"IF(請求書!Q26=\"\",\"\",請求書!Q26)","v":10000},null,"未収入金",null,null,"対象外",10000,null,{"$f":"IF(OR($I8=0,$I8=\"\"),\"\",請求書!$B$6&\" \"&請求書!D26)","v":"〇〇〇〇株式会社 ▲▲立替金　2月分"},null,null,"3",null,null,"0","0","no"]
["",null,null,{"$f":"IF(OR($I9=0,$I9=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q27=\"\",\"\",請求書!Q27)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I9=0,$I9=\"\"),\"\",請求書!$B$6&\" \"&請求書!D27)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I10=0,$I10=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q28=\"\",\"\",請求書!Q28)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I10=0,$I10=\"\"),\"\",請求書!$B$6&\" \"&請求書!D28)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I11=0,$I11=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q29=\"\",\"\",請求書!Q29)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I11=0,$I11=\"\"),\"\",請求書!$B$6&\" \"&請求書!D29)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I12=0,$I12=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q30=\"\",\"\",請求書!Q30)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I12=0,$I12=\"\"),\"\",請求書!$B$6&\" \"&請求書!D30)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I13=0,$I13=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q31=\"\",\"\",請求書!Q31)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I13=0,$I13=\"\"),\"\",請求書!$B$6&\" \"&請求書!D31)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I14=0,$I14=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q32=\"\",\"\",請求書!Q32)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I14=0,$I14=\"\"),\"\",請求書!$B$6&\" \"&請求書!D32)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I15=0,$I15=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q33=\"\",\"\",請求書!Q33)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I15=0,$I15=\"\"),\"\",請求書!$B$6&\" \"&請求書!D33)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I16=0,$I16=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q34=\"\",\"\",請求書!Q34)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I16=0,$I16=\"\"),\"\",請求書!$B$6&\" \"&請求書!D34)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I17=0,$I17=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q35=\"\",\"\",請求書!Q35)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I17=0,$I17=\"\"),\"\",請求書!$B$6&\" \"&請求書!D35)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I18=0,$I18=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q36=\"\",\"\",請求書!Q36)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I18=0,$I18=\"\"),\"\",請求書!$B$6&\" \"&請求書!D36)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I19=0,$I19=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q37=\"\",\"\",請求書!Q37)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I19=0,$I19=\"\"),\"\",請求書!$B$6&\" \"&請求書!D37)","v":""},null,null,"",null,null,"","",""]
["",null,null,{"$f":"IF(OR($I20=0,$I20=\"\"),\"\",請求書!$C$20)","v":""},"",null,null,"",{"$f":"IF(請求書!Q38=\"\",\"\",請求書!Q38)","v":""},null,"",null,null,"","",null,{"$f":"IF(OR($I20=0,$I20=\"\"),\"\",請求書!$B$6&\" \"&請求書!D38)","v":""},null,null,"",null,null,"","",""]