{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["設定・操作手引き","1","2","3","4","5","6","7","8","9","10","11","12","仕訳辞書","マスタ","WORK"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":45,"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":156,"n_cols":8,"rows_kept":156,"cut":false,"hidden":false,"merged":[]}
[null,"設定","V1.0",null,"操作手引き"]
[null,"自社名"]
[null,"預金科目名",null,null,"構造"]
[null,"消費税"]
[null,"金融機関名",null,null,null,"本ツールの構造は以下の通りです。"]
[null,"顧客ｺｰﾄﾞ"]
[null,"事業区分",null,null,null,"設定・操作手引き：本シートです。"]
[null,"決算月",null,null,null,"1～12：各月のデータを入れるシートです。会計期間単位に並びます。"]
[null,"決算年",null,null,null,"仕訳辞書：摘要単位に設定される仕訳作成データを保存するシートです。"]
[null,"前年度残",null,null,null,"マスタ：科目、消費税区分、取引先、金融機関のCSVレイアウトを設定するシートです。"]
[null,"対象ソフト",null,null,null,"WORK：各種処理をするためのシートです。操作の必要は一切ありません。"]
[null,"パスワード"]
[null,"CSV読込み",null,null,"設定について"]
[null,"＜CSVのレイアウト＞",null,null,null,"＜設定・操作手続き＞"]
[null,"データ開始の行"]
[null,"勘定日1",null,null,null,"使用の対象となる法人の情報と金融機関のCSVの構造を設定します。最初にこれを行って下さい。"]
[null,"勘定日2"]
[null,"勘定日3",null,null,null,"自社名：法人の名称（出納帳に印刷されます）"]
[null,"支払金額",null,null,null,"預金科目名：仕訳で使う預金側の科目名（仕訳作成に使われます）"]
[null,"預り金額",null,null,null,"消費税：税込み　又は　税抜き"]
[null,"摘要1",null,null,null,"金融機関名：対象となる金融機関の名称（プルダウンに無ければ手入力して下さい）"]
[null,"摘要2",null,null,null,"顧客コード：TKCに登録された顧客のコード"]
[null,null,null,null,null,"事業区分：売上の消費税で使用する事業区分"]
[null,null,null,null,null,"決算月：決算の月（ここを入力するとシートが並べ替えられます）"]
[null,null,null,null,null,"決算年：対象となる決算月がある西暦年"]
[null,null,null,null,null,"前年度残：対象金融機関の前年度決算時の残高"]
[null,null,null,null,null,"対象ソフト：ローカル処理系、クラウド系（前者では.slp、後者は.zipも出力します）"]
[null,null,null,null,null,"パスワード：下記の「支払いについて」をご覧ください。"]
[]
[null,null,null,null,null,"以下はCSVの構造です。"]
[null,null,null,null,null,"マスタに金融機関の定義があれば自動設定されます。無ければ設定して下さい。"]
[]
[null,null,null,null,null,"データ開始の行：取引データの最初の行の順番"]
[null,null,null,null,null,"勘定日1：年月日を表すデータの順番、または年を表すデータの順番（以下、行の中の順番）"]
[null,null,null,null,null,"勘定日2：上記が年の場合の月を表す順番（無ければ空白）"]
[null,null,null,null,null,"勘定日3：上記が年の場合の日を表す順番（無ければ空白）"]
[null,null,null,null,null,"支払金額：金融機関から引き出される金額の順番"]
[null,null,null,null,null,"預り金額：金融機関に預け入れられる金額の順番"]
[null,null,null,null,null,"摘要1：摘要が書かれている場所の順番"]
[null,null,null,null,null,"摘要2：摘要補助のようなデータがあればその順番（無ければ空白）"]
[]
[null,null,null,null,null,"＜マスタ＞"]
[]
[null,null,null,null,null,"科目は、選択する科目の個別名称を選択名に入れ、そのコード、補助コード、科目名も入力して下さい。"]
[null,null,null,null,null,"大半は個別名称と科目名は同じで良いのですが、金融機関が複数ある場合は補助コードを使います。"]
[null,null,null,null,null,"この場合は、金融機関名を個別名称にすれば良いです。"]
[]
[null,null,null,null,null,"取引先名は、公開された名称を取引先名に入れ、それを32バイト以下にした名称とコードも入れて下さい。"]
[]
[null,null,null,null,null,"金融機関は設定・操作手引きで手入力しても自動追加されません。"]
[]
[null,null,null,null,"操作"]
[]
[null,null,null,null,null,"日常の操作は以下の通りです。"]
[]
[null,null,null,null,null,"(1)左記の「ファイル選択」ボタンをクリックしてファイル読込みをします。"]
[null,null,null,null,null,"(2)読込まれたデータの編集をします。編集が必要なセルには色が付かれます。"]
[]
[null,null,null,null,null,null,"ピンク：データの入力が無い事を示します。（摘要、取引先は無くても大丈夫です）"]
[null,null,null,null,null,null,"黄色：対象が複数あります。（過去に別のデータが入力されています）"]
[]
[null,null,null,null,null,null,"色が無いセルについても確認して、必要に応じ上書き入力して下さい。"]
[null,null,null,null,null,null,"取引先や科目はプルダウンで選択できます。摘要も複数あればプルダウンが出ます。"]
[null,null,null,null,null,null,"取引先や摘要のプルダウンはそのデータで使用済みのものが上位にありその他も追加されています。"]
[]
[null,null,null,null,null,null,"仕訳の追加・削除は以下のようにします。"]
[]
[null,null,null,null,null,null,"追加：空白行で項目(選択)欄を選択しプルダウンから対象を選択します。"]
[null,null,null,null,null,null,null,"日付や金額を入力し、上部の「並べ替え」ボタンをクリックすれば日付順に並べ替えられます。"]
[null,null,null,null,null,null,"削除：対象の項目(選択)欄を選択しDelキーを押します。"]
[null,null,null,null,null,null,null,"これによりその行は空白になります。"]
[null,null,null,null,null,null,null,"その後、上部の「並べ替え」ボタンをクリックすれば空白行を下に移動して並べ替えられます。"]
[]
[null,null,null,null,null,"(3)仕訳データファイルの作成をします。"]
[]
[null,null,null,null,null,null,"画面上部の「ファイル出力」ボタンをクリックすればデスクトップに月が名称のファイルが出力されます。"]
[]
[null,null,null,null,null,"(4)仕訳データの読み込み（仕訳の入力）"]
[]
[null,null,null,null,null,null,"TKCの会計ソフトで「他社システム仕訳の読込」を選択し、上記のファイルを指定して下さい。"]
[]
[null,null,null,null,null,"以上で、仕訳入力まで終了です。"]
[]
[null,null,null,null,"仕訳辞書の編集"]
[]
[null,null,null,null,null,"仕訳辞書は最新3回分の仕訳情報が残されます。（B列～AA列）"]
[null,null,null,null,null,"仕訳のデータは左から右に新しい順に保存されます。"]
[null,null,null,null,null,"例えば、毎月は通信費になるものも月初だけは未払金になる場合など2件になります。"]
[null,null,null,null,null,"なお、間違った摘要等を入力し修正した場合も残りますのでこれは消去して下さい。"]
[]
[null,null,null,null,null,"ここでは、以下の特別な機能があります。"]
[]
[null,null,null,null,null,"（1）1行の仕訳では不足する場合は複数の仕訳を追加出来ます。"]
[null,null,null,null,null,null,"例えば、売掛金等を入金する際に手数料を当方負担にされ引かれる場合があります。"]
[null,null,null,null,null,null,"（10,000円売掛だが、手数料220円を引かれ99,780しか入って来ない）"]
[null,null,null,null,null,null,"この場合は、預金/売掛金 99,780 の仕訳に加えて、手数料/売掛金 220の仕訳が必要です。"]
[]
[null,null,null,null,null,null,"この対応方法は以下です。"]
[]
[null,null,null,null,null,null,"・必要な仕訳を個別な名前を付けて仕訳辞書に追加します。元になる仕訳の直下の必要はありません。"]
[null,null,null,null,null,null,"・元になる仕訳データの右側の「次行仕訳」欄(AC列)に、追加した仕訳の名前を追加します。"]
[null,null,null,null,null,null,"・複数の仕訳追加が必要な場合は、上記を続ければ良いです。"]
[]
[null,null,null,null,null,null,"場合により追加仕訳が不要な場合もある場合は、金額を入れなければ仕訳は作られません。"]
[]
[null,null,null,null,null,"（2）2行のデータがあるが、あるパターンでは1行の仕訳で済む状況に対応出来ます。"]
[]
[null,null,null,null,null,null,"例えば、買掛金の支払いをするのに特定の取引先だけは手数料を相手に持ってもらう事が"]
[null,null,null,null,null,null,"出来る場合があります。"]
[null,null,null,null,null,null,"（10,000円の支払いだが、99,780円を相手に振込み、220円は手数料として金融機関に払う）"]
[null,null,null,null,null,null,"この場合は、買掛金/預金 99,780 と 買掛金/預金 220 にすれば良いです。"]
[]
[null,null,null,null,null,null,"この方法は以下です。"]
[]
[null,null,null,null,null,null,"・1行目の支払いとなる仕訳データの右側の「次仕訳を同じ科目等にする」(AD列）に「〇」を入力します。"]
[]
[null,null,null,null,null,null,"上記により、次の行の仕訳名が登録されていても無視されます。"]
[]
[null,null,null,null,null,"必ず仕訳辞書の修正、追加を先に行い、数字の編集は最後にして下さい。"]
[null,null,null,null,null,"仕訳辞書を追加した後にデータの読み直しをするとそれらが生かされますが、数字は消え去れてしまいます。"]
[]
[null,null,null,null,"マスタの編集"]
[]
[null,null,null,null,null,"科目も取引先も通常の入力で追加する事は出来ます。"]
[null,null,null,null,null,"ただし、科目は途中に入れる必要があります。"]
[null,null,null,null,null,"この場合は、行の追加はしないで、追加したい行以下を全て下にコピーして追加して下さい。"]
[]
[null,null,null,null,"決算後の操作"]
[]
[null,null,null,null,null,"本ツールファイルをコピーします。（保存用なので名前に決算期などを追加するのが適当です）"]
[null,null,null,null,null,"決算年を変更します。"]
[null,null,null,null,null,"左側の「全月シートクリア」ボタンをタッチします。"]
[null,null,null,null,null,"以上により、これまでの仕訳辞書、取引先を残したまま新しい期間の入力が出来ます。"]
[]
[null,null,null,null,"注意事項"]
[]
[null,null,null,null,null,"以下については注意して下さい。"]
[]
[null,null,null,null,null,"・CSVファイルを別に開きながらの処理はエラーを発生させます。"]
[null,null,null,null,null,"・他のEXCELファイルを開きながらの操作も不可です。（操作時はこのツールだけを開いて下さい）"]
[null,null,null,null,null,"・出納帳の印刷をする際には空行を非表示にして下さい。削除は不可です。"]
[null,null,null,null,null,"・プルダウンを表示して候補が見付からなかった場合は、ESCキーを押してください。プルダウンが消えます。"]
[]
[null,null,null,null,"支払いについて"]
[]
[null,null,null,null,null,"このツールは二月分まで無料で操作できます。（操作性を確認して下さい）"]
[null,null,null,null,null,"試用が終了したら、料金を下記口座に振込み、下記連絡先に対応顧客のTKCコードを書き込み送って下さい。"]
[null,null,null,null,null,"（サブスクではないので、一度の支払いだけで良いです）"]
[null,null,null,null,null,"振込みを確認後にパスワードを返信しますので、これを左側のパスワードに入れて下さい。"]
[null,null,null,null,null,"以上で以下のように使えます。"]
[null,null,null,null,null,"・対象となる金融機関が複数ある場合は、その分をダウンロードし同じ顧客コードとパスワードを入れて下さい。"]
[null,null,null,null,null,"・何年分も制限なくこの支払いだけで使えます。"]
[]
[null,null,null,null,null,"振込先口座：三菱UFJ銀行 昭島支店 普通預金 0164586　バリダ株式会社"]
[null,null,null,null,null,"料金：5,500円（税込、手数料はご負担ください）"]
[null,null,null,null,null,"連絡先メールアドレス： info@valida-corp.com"]

{"sheet":"1","index":1,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年1月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":1},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"設定・操作手引き!C10","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"2","index":2,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年2月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":2},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"3","index":3,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年3月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":3},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"4","index":4,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年4月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":4},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"5","index":5,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年5月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":5},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"6","index":6,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年6月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":6},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"7","index":7,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年7月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":7},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"8","index":8,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年8月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":8},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"9","index":9,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年9月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":9},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"10","index":10,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年10月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":10},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"11","index":11,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年11月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":11},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"12","index":12,"n_rows":200,"n_cols":56,"rows_kept":200,"cut":false,"hidden":false,"merged":[[1,11,1,16],[2,4,2,6]]}
[null,"取引選択エリア",null,null,{"$f":"M1&\"年\"&N1&\"月\"&設定・操作手引き!C5","v":"-1年12月"},null,null,null,null,null,"≪仕訳表示エリア1≫",null,{"$f":"IF(N1<設定・操作手引き!C8,設定・操作手引き!C9,設定・操作手引き!C9-1)","v":-1},{"$f":"VALUE(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2))))","v":12},null,null,null,null,null,null,"≪インタフェースデータエリア1≫",null,null,null,null,null,null,null,null,null,null,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末列≫"]
[null,"項目（選択）",null,"日","摘要（編集可）","取引先（編集可）","預入金額","引出金額",{"$f":"I1+G2-H2","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D2=\"\",\"\",DATE($M$1,$N$1,$D2))","v":{"$error":"#VALUE!"}},"第　　一　　仕　　訳",null,null,null,null,null,null,null,null,{"$f":"設定・操作手引き!$C$6","v":0},999,{"$f":"(ROW()-3)*10","v":-10},{"$f":"TEXT(YEAR(K2),\"0000\")&TEXT(MONTH(K2),\"00\")&TEXT(DAY(K2),\"00\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(マスタ!$H$3:$I$500,MATCH(N2,マスタ!$H$3:$H$500,0),2)","v":0},{"$f":"IF(OR(AND(N2>=1,N2<=4),AND(N2>=11,N2<=31)),設定・操作手引き!$C$7,0)","v":0},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(L2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},{"$f":"INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),2)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3)=0,\"\",TEXT(INDEX(マスタ!$B$3:$D$200,MATCH(M2,科目名,0),3),\"00\"))","v":{"$error":"#N/A"}},null,0,{"$f":"O2","v":0},{"$f":"IF(設定・操作手引き!$C$4=\"税込み\",0,ROUND(AI2*AL2/(10000+AL2),0))*IF(COUNTIF(N2,\"*免*\"),0.8,1)","v":0},1,{"$f":"INDEX(マスタ!$H$3:$J$500,MATCH(N2,マスタ!$H$3:$H$500,0),3)","v":0},{"$f":"IF(ISERROR(MATCH(AN2,マスタ!$L$3:$L$500,0))=TRUE,0,INDEX(マスタ!$L$3:$N$500,MATCH(AN2,マスタ!$L$3:$L$500,0),3))","v":0},{"$f":"LEFTB(P2,32)","v":""},{"$f":"IF(AP2=0,0,IF(RIGHT(AP2,2)=\"00\",IF(AQ2=0,3,4),IF(AQ2=0,1,2)))","v":0},{"$f":"R2","v":0},{"$f":"S2","v":"00:00:00"},{"$f":"LEFTB(Q2,40)","v":""},null,0,0,null,0,0,0,0,0,0,null,101]
[null,null,null,null,"前月繰越金額",null,null,null,{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!I200\")","v":0},null,"","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入日(終了）",null,"関与先ｺｰﾄﾞ","ｼｽﾃﾑ区分","ﾚｺｰﾄﾞNO","取引年月日","伝票番号","証憑書番号","課税区分","事業区分","借科目ｺｰﾄﾞ","借補助ｺｰﾄﾞ","貸科目ｺｰﾄﾞ","貸補助ｺｰﾄﾞ","小切手番号","予備(0)","税込金額","消費税","税額入力区分","消費税率","取引先ｺｰﾄﾞ","取引先名","実際の仕入れ日入力ﾊﾟﾀｰﾝ","実際の仕入れ開始年月日","実際の仕入れ終了年月日","元帳摘要","予備（空欄）","資金大分類","資金小分類","部門ｺｰﾄﾞ","部門数","予備(0)","予備(0)","自動仕訳番号","予備(0)","予備(0)","空欄",101]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"合計",null,{"$f":"SUM(G4:G199)","v":0},{"$f":"SUM(H4:H199)","v":0},{"$f":"I3+G200-H200","v":0}]

{"sheet":"仕訳辞書","index":13,"n_rows":2,"n_cols":30,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["仕訳名","借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入終了日",null,"借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入終了日",null,"借方科目","貸方科目","税","取引金額","取引先","摘要","実際の仕入日","実際の仕入終了日",null,"次行仕訳","次仕訳を同じ科目等にする"]

{"sheet":"マスタ","index":14,"n_rows":159,"n_cols":24,"rows_kept":159,"cut":false,"hidden":false,"merged":[]}
[]
[null,"選択名","コード","補助コード","科目名",null,"消費税区分","コード","課税区分","税率",null,"取引先名","取引先(32バイト)","コード",null,"金融機関名","データ開始の行","勘定日1","勘定日2","勘定日3","支払金額","預り金額","摘要1","摘要2"]
[null,"現金",1111,null,"現金",null,"課税売上",1,1,1000,null,null,null,null,null,"みずほ銀行",14,2,null,null,3,4,6]
[null,"当座預金",1112,null,"当座預金",null,"非課税収入",3,3,0,null,null,null,null,null,"三井住友銀行",2,11,17,18,20,19,22]
[null,"預金",1113,null,"普通預金",null,"仕入標準課税",5,5,1000,null,null,null,null,null,"三菱UFJ銀行",2,1,null,null,4,5,2,3]
[null,"定期預金",1114,null,"定期預金",null,"軽減税","K",5,800,null,null,null,null,null,"りそな銀行",2,3,null,null,5,6,13,14]
[null,"定期積金",1115,null,"定期積金",null,"免税仕入標準課税","免5",5,1000,null,null,null,null,null,"ゆうちょ銀行",9,1,null,null,4,3,5,6]
[null,"別段預金",1116,null,"別段預金",null,"免税軽減税","免K",5,800,null,null,null,null,null,"横浜銀行",2,3,null,null,5,6,13]
[null,"受取手形",1121,null,"受取手形",null,"仕入標準課税8%","5_8",5,800,null,null,null,null,null,"多摩信用金庫",2,2,null,null,4,5,3]
[null,"電子記録債権",1124,null,"電子記録債権",null,"非課税",8,8,0]
[null,"売掛金",1122,null,"売掛金",null,"不課税",0,0,0]
[null,"有価証券",1125,null,"有価証券",null,"軽減売上","1k",1,800]
[null,"その他の当座資産",1126,null,"その他の当座資産",null,"軽減売上返還","11k",11,800]
[null,"商品",1131,null,"商品",null,"課税売上返還",11,11,1000]
[null,"製品",1132,null,"製品",null,"課税売上貸倒",12,12,1000]
[null,"半製品",1133,null,"半製品",null,"輸出売上",2,2,0]
[null,"原材料",1134,null,"原材料",null,"輸出売上返還",21,21,0]
[null,"仕掛品（半成品）",1135,null,"仕掛品（半成品）",null,"非課税輸出売上",25,25,0]
[null,"貯蔵品",1136,null,"貯蔵品",null,"非課税輸出売上返還",26,26,0]
[null,"前渡金",1151,null,"前渡金",null,"非課税売上返還",31,31,0]
[null,"前払費用",1152,null,"前払費用",null,"有価証券譲渡",4,4,1000]
[null,"繰延税金資産",1165,null,"繰延税金資産",null,"仕入標準課税返還",51,51,1000]
[null,"短期貸付金",1153,null,"短期貸付金",null,"輸入標準課税",55,55,0]
[null,"未収入金",1154,null,"未収入金",null,"仕入非課税売上用",6,6,1000]
[null,"未収還付法人税等",1162,null,"未収還付法人税等",null,"仕入返還非課税売上用",61,61,1000]
[null,"立替金",1155,null,"立替金",null,"輸入非課税用",65,65,0]
[null,"仮払金",1156,null,"仮払金",null,"仕入共通",7,7,1000]
[null,"仮払消費税等",1164,null,"仮払消費税等",null,"仕入共通返還",71,71,1000]
[null,"仮払税金",1157,null,"仮払税金",null,"輸入共通",75,75,0]
[null,"不渡手形",1158,null,"不渡手形",null,"課税区分未定",9,9,1000]
[null,"不渡電子記録債権",1168,null,"不渡電子記録債権"]
[null,"その他の流動資産",1159,null,"その他の流動資産"]
[null,"貸倒引当金",1171,null,"貸倒引当金"]
[null,"建物",1211,null,"建物"]
[null,"建物付属設備",1218,null,"建物付属設備"]
[null,"構築物",1212,null,"構築物"]
[null,"機械及び装置",1213,null,"機械及び装置"]
[null,"船舶",1214,null,"船舶"]
[null,"車両運搬具",1215,null,"車両運搬具"]
[null,"工具、器具及び備品",1216,null,"工具、器具及び備品"]
[null,"土地",1221,null,"土地"]
[null,"リース資産",1223,null,"リース資産"]
[null,"建設仮勘定",1222,null,"建設仮勘定"]
[null,"その他の有形固定資産",1224,null,"その他の有形固定資産"]
[null,"減価償却累計額",1225,null,"減価償却累計額"]
[null,"のれん",1231,null,"のれん"]
[null,"借地権",1233,null,"借地権"]
[null,"ソフトウェア",1237,null,"ソフトウェア"]
[null,"電話加入権",1236,null,"電話加入権"]
[null,"投資有価証券",1252,null,"投資有価証券"]
[null,"出資金",1251,null,"出資金"]
[null,"保証金",1254,null,"保証金"]
[null,"敷金",1255,null,"敷金"]
[null,"長期貸付金",1256,null,"長期貸付金"]
[null,"繰延税金資産",1265,null,"繰延税金資産"]
[null,"貸倒引当金",1259,null,"貸倒引当金"]
[null,"創業費",1311,null,"創業費"]
[null,"資金諸口",9991,null,"資金諸口"]
[null,"資金外諸口",9992,null,"資金外諸口"]
[null,"支払手形",2111,null,"支払手形"]
[null,"電子記録債務",2144,null,"電子記録債務"]
[null,"買掛金",2112,null,"買掛金"]
[null,"短期借入金",2113,null,"短期借入金"]
[null,"１年以内返済長期借入金",2135,null,"１年以内返済長期借入金"]
[null,"未払金",2114,null,"未払金"]
[null,"未払費用",2115,null,"未払費用"]
[null,"未払法人税等",2125,null,"未払法人税等"]
[null,"未払消費税等",2136,null,"未払消費税等"]
[null,"繰延税金負債",2165,null,"繰延税金負債"]
[null,"前受金",2116,null,"前受金"]
[null,"預り金",2117,null,"預り金"]
[null,"前受金",2116,null,"前受金"]
[null,"前受収益",2118,null,"前受収益"]
[null,"仮受金",2119,null,"仮受金"]
[null,"仮受消費税等",2164,null,"仮受消費税等"]
[null,"割引手形",2122,null,"割引手形"]
[null,"割引電子記録債権",2132,null,"割引電子記録債権"]
[null,"賞与引当金",2126,null,"賞与引当金"]
[null,"その他の流動負債",2129,null,"その他の流動負債"]
[null,"社債",2216,null,"社債"]
[null,"長期借入金",2212,null,"長期借入金"]
[null,"長期未払金",2219,null,"長期未払金"]
[null,"繰延税金負債",2265,null,"繰延税金負債"]
[null,"退職給付引当金",2214,null,"退職給付引当金"]
[null,"その他の固定負債",2215,null,"その他の固定負債"]
[null,"資本金",3111,null,"資本金"]
[null,"資本準備金",3211,null,"資本準備金"]
[null,"資本金資本準備金減少差益",3341,null,"資本金資本準備金減少差益"]
[null,"自己株式処分差益",3342,null,"自己株式処分差益"]
[null,"利益準備金",3212,null,"利益準備金"]
[null,"別途積立金",3311,null,"別途積立金"]
[null,"積立金",3312,null,"積立金"]
[null,"自己株式",3511,null,"自己株式"]
[null,"その他有価証券評価差額金",3411,null,"その他有価証券評価差額金"]
[null,"繰延ヘッジ損益",3421,null,"繰延ヘッジ損益"]
[null,"新株予約権",3611,null,"新株予約権"]
[null,"売上高",4111,null,"売上高"]
[null,"売上高",4112,null,"売上高"]
[null,"売上高",4113,null,"売上高"]
[null,"売上高",4114,null,"売上高"]
[null,"売上値引戻り高",4115,null,"売上値引戻り高"]
[null,"期首棚卸高",5111,null,"期首棚卸高"]
[null,"材料仕入高",5211,null,"材料仕入高"]
[null,"外注費",5212,null,"外注費"]
[null,"現場消耗品費",5215,null,"現場消耗品費"]
[null,"仕入値引戻し高",5213,null,"仕入値引戻し高"]
[null,"他勘定振替高",5273,null,"他勘定振替高"]
[null,"期末棚卸高",5311,null,"期末棚卸高"]
[null,"販売員給与",6111,null,"販売員給与"]
[null,"旅費交通費",6112,null,"旅費交通費"]
[null,"広告宣伝費",6113,null,"広告宣伝費"]
[null,"容器包装費",6114,null,"容器包装費"]
[null,"発送配達費",6115,null,"発送配達費"]
[null,"会議費",6116,null,"会議費"]
[null,"その他の販売費",6117,null,"その他の販売費"]
[null,"役員報酬",6211,null,"役員報酬"]
[null,"給与手当",6212,null,"給与手当"]
[null,"従業員賞与",6213,null,"従業員賞与"]
[null,"法定福利費",6312,null,"法定福利費"]
[null,"厚生費",6226,null,"厚生費"]
[null,"減価償却費",6214,null,"減価償却費"]
[null,"リース料",6234,null,"リース料"]
[null,"地代家賃",6215,null,"地代家賃"]
[null,"修繕費",6216,null,"修繕費"]
[null,"事務用消耗品費",6217,null,"事務用消耗品費"]
[null,"通信費",6218,null,"通信費"]
[null,"水道光熱費",6219,null,"水道光熱費"]
[null,"租税公課",6221,null,"租税公課"]
[null,"寄付金",6222,null,"寄付金"]
[null,"接待交際費",6223,null,"接待交際費"]
[null,"保険料",6224,null,"保険料"]
[null,"備品消耗品費",6225,null,"備品消耗品費"]
[null,"管理諸費",6227,null,"管理諸費"]
[null,"図書研修費",6228,null,"図書研修費"]
[null,"貸倒償却",6314,null,"貸倒償却"]
[null,"雑費",6231,null,"雑費"]
[null,"受取利息",7111,null,"受取利息"]
[null,"受取配当金",7114,null,"受取配当金"]
[null,"雑収入",7118,null,"雑収入"]
[null,"支払利息",7511,null,"支払利息"]
[null,"手形売却損",7518,null,"手形売却損"]
[null,"貸倒償却",7514,null,"貸倒償却"]
[null,"繰延資産償却",7515,null,"繰延資産償却"]
[null,"雑損失",7519,null,"雑損失"]
[null,"固定資産売却益",8111,null,"固定資産売却益"]
[null,"前期損益修正益",8114,null,"前期損益修正益"]
[null,"固定資産売却損",8211,null,"固定資産売却損"]
[null,"前期損益修正損",8214,null,"前期損益修正損"]
[null,"法人税、住民税及び事業税",8311,null,"法人税、住民税及び事業税"]
[null,"過年度法人税等",8321,null,"過年度法人税等"]
[null,"法人税等調整額",8312,null,"法人税等調整額"]
[null,"繰越利益剰余金期首残高",9211,null,"繰越利益剰余金期首残高"]
[null,"過年度税効果調整額",9212,null,"過年度税効果調整額"]
[null,"積立金取崩額",9311,null,"積立金取崩額"]
[null,"利益準備金取崩額",9321,null,"利益準備金取崩額"]
[null,"自己株式処分差損・消却額",9322,null,"自己株式処分差損・消却額"]
[null,"利益剰余金配当額",9411,null,"利益剰余金配当額"]
[null,"利益準備金積立額",9511,null,"利益準備金積立額"]
[null,"積立金積立額",9521,null,"積立金積立額"]

{"sheet":"WORK","index":15,"n_rows":55,"n_cols":36,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[625,999,10,"20251101",null,null,0,0,2212,"A",1113,"B",null,0,100000,0,1,0,6,"田口勝利",0,0,0,"借入金返済　運転資金",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,20,"20251101",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,30,"20251102",null,null,0,0,1111,"",1113,"B",null,0,50000,0,1,0,0,"",0,0,0,"現金引出し",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,40,"20251102",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,50,"20251107",null,null,5,0,6216,"",1113,"B",null,0,9900,900,1,1000,112,"リックメンテナンス",0,0,0,"RIKCADメンテナンス",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,60,"20251107",null,null,5,0,6231,"",1113,"B",null,0,2200,200,1,1000,145,"横浜銀行",0,0,0,"インターネット基本料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,70,"20251107",null,null,5,0,6231,"",1113,"B",null,0,1100,100,1,1000,145,"横浜銀行",0,0,0,"インターネット基本料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,80,"20251107",null,null,0,0,2112,"",1113,"B",null,0,36300,0,1,0,138,"長倉工業",0,0,0,"左官工",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,90,"20251107",null,null,5,0,6231,"",1113,"B",null,0,550,50,1,1000,145,"横浜銀行",0,0,0,"振込手数料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,100,"20251107",null,null,0,0,2114,"01",1113,"B",null,0,2000000,0,1,0,6,"田口勝利",0,0,0,"預金支払　未払役員報酬",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,110,"20251107",null,null,5,0,6231,"",1113,"B",null,0,550,50,1,1000,145,"横浜銀行",0,0,0,"振込手数料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,120,"20251107",null,null,0,0,2114,"02",1113,"B",null,0,308595,0,1,0,0,"前月分",0,0,0,"預金支払　　未払給与",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,130,"20251107",null,null,5,0,6231,"",1113,"B",null,0,550,50,1,1000,145,"横浜銀行",0,0,0,"振込手数料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,140,"20251107",null,null,0,0,2114,"01",1113,"B",null,0,150000,0,1,0,6,"田口勝利",0,0,0,"預金支払　未払役員報酬",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,150,"20251107",null,null,5,0,6231,"",1113,"B",null,0,550,50,1,1000,145,"横浜銀行",0,0,0,"振込手数料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,160,"20251107",null,null,0,0,2114,"01",1113,"B",null,0,1500000,0,1,0,28,"田口由紀",0,0,0,"預金支払　未払役員報酬",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,170,"20251107",null,null,5,0,6231,"",1113,"B",null,0,550,50,1,1000,145,"横浜銀行",0,0,0,"振込手数料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,180,"20251107",null,null,0,0,1113,"A",1113,"B",null,0,1000000,0,1,0,2,"多摩信用金庫",0,0,0,"預金振替",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,190,"20251107",null,null,5,0,6231,"",1113,"B",null,0,550,50,1,1000,145,"横浜銀行",0,0,0,"振込手数料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,200,"20251110",null,null,0,0,2212,"A",1113,"B",null,0,50000,0,1,0,6,"田口勝利",0,0,0,"借入金返済　運転資金",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,210,"20251110",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,220,"20251114",null,null,0,0,2212,"A",1113,"B",null,0,100000,0,1,0,6,"田口勝利",0,0,0,"借入金返済　運転資金",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,230,"20251114",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,240,"20251118",null,null,0,0,1111,"",1113,"B",null,0,200000,0,1,0,0,"",0,0,0,"現金引出し",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,250,"20251118",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,260,"20251120",null,null,0,0,2212,"A",1113,"B",null,0,200000,0,1,0,6,"田口勝利",0,0,0,"借入金返済　運転資金",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,270,"20251120",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,280,"20251120",null,null,0,0,2212,"A",1113,"B",null,0,200000,0,1,0,6,"田口勝利",0,0,0,"借入金返済　運転資金",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,290,"20251120",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,300,"20251120",null,null,0,0,2212,"A",1113,"B",null,0,100000,0,1,0,6,"田口勝利",0,0,0,"借入金返済　運転資金",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,310,"20251120",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,320,"20251121",null,null,0,0,2212,"A",1113,"B",null,0,200000,0,1,0,6,"田口勝利",0,0,0,"借入金返済　運転資金",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,330,"20251121",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,340,"20251122",null,null,5,0,6227,"",1113,"B",null,0,45337,4122,1,1000,3,"山田諭子税理士事務所",0,0,0,"預金支払　　顧問料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,380,"20251126",null,null,8,0,6224,"",1113,"B",null,0,6080,0,1,0,146,"あいおいニッセイ",0,0,0,"預金支払　自動車保険",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,390,"20251126",null,null,0,0,2212,"A",1113,"B",null,0,50000,0,1,0,6,"田口勝利",0,0,0,"借入金返済　運転資金",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,400,"20251126",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,410,"20251128",null,null,0,0,2212,"A",1113,"B",null,0,50000,0,1,0,6,"田口勝利",0,0,0,"借入金返済　運転資金",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,420,"20251128",null,null,5,0,6231,"",1113,"B",null,0,220,20,1,1000,158,"コンビニなど",0,0,0,"振込料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,430,"20251130",null,null,1,5,1113,"B",4111,"",null,0,1650821,150075,1,1000,152,"住友不動産",0,0,0,"売上入金　当月分",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,450,"20251130",null,null,5,0,5215,"",1113,"B",null,0,22055,2005,1,1000,58,"東京レンタル株式会社",0,0,0,"重機リース料・回送料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,460,"20251130",null,null,5,0,6231,"",1113,"B",null,0,385,35,1,1000,145,"横浜銀行",0,0,0,"振込手数料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,470,"20251130",null,null,5,0,5212,"",1113,"B",null,0,70400,6400,1,1000,124,"ケイゾウポンプ",0,0,0,"圧送業務",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,480,"20251130",null,null,5,0,6231,"",1113,"B",null,0,550,50,1,1000,145,"横浜銀行",0,0,0,"振込手数料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,490,"20251130",null,null,5,0,5211,"",1113,"B",null,0,922204,83837,1,1000,82,"関東",0,0,0,"材料仕入高",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,500,"20251130",null,null,5,0,5211,"",1113,"B",null,0,550,50,1,1000,145,"横浜銀行",0,0,0,"振込手数料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,510,"20251130",null,null,5,0,5211,"",1113,"B",null,0,1038611,94419,1,1000,83,"小沢商店",0,0,0,"材料仕入高",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,520,"20251130",null,null,5,0,5212,"",1113,"B",null,0,164450,14950,1,1000,180,"フロアーテック(株)",0,0,0,"床コンクリート工事",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,530,"20251130",null,null,5,0,6231,"",1113,"B",null,0,550,50,1,1000,145,"横浜銀行",0,0,0,"振込手数料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,540,"20251130",null,null,5,0,6218,"",1113,"B",null,0,27410,2492,1,1000,197,"ＫＤＤＩ株式会社",0,0,0,"電話料金　月分",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,550,"20251130",null,null,0,0,6221,"",1113,"B",null,0,17600,0,1,0,0,"神奈川県自動車税管理事務所",0,0,0,"自動車税",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,560,"20251130",null,null,0,0,6221,"",1113,"B",null,0,45000,0,1,0,0,"神奈川県自動車税管理事務所",0,0,0,"自動車税",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,570,"20251130",null,null,0,0,2117,"B",1113,"B",null,0,5000,0,1,0,97,"横浜市役所",0,0,0,"住民税納付",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,580,"20251130",null,null,0,0,6312,"",1113,"B",null,0,1500,0,1,0,0,"年金事務所",0,0,0,"預金支払　社会保険料",null,0,0,null,0,0,0,0,0,0,null,101]
[625,999,590,"20251130",null,null,0,0,6312,"",1113,"B",null,0,700,0,1,0,0,"年金事務所",0,0,0,"預金支払　社会保険料",null,0,0,null,0,0,0,0,0,0,null,101]