{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["変換後データ","仕訳データ","変換前データ","変換設定","使い方","詳細設定","詳細設定の使い方"],"not_rendered":{"images":3,"macros":1,"defined_names":3,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"変換後データ","index":0,"n_rows":1,"n_cols":7,"rows_kept":1}
["発生日","勘定科目","税区分","金額","備考","品目","メモタグ"]

{"sheet":"仕訳データ","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"変換前データ","index":2,"n_rows":32,"n_cols":5,"rows_kept":32}
[]
["↓見出し列＼見出し行→","社保窓口収入","国保窓口収入","後期高齢者窓口収入","自費"]
[1,20000,30000,50000,{"v":400000,"d":"¥400,000"}]
[2]
[3,20000,30000,50000,{"v":400000,"d":"¥400,000"}]
[4,20000,30000,50000,400000]
[5,20000,30000,50000,400000]
[6,20000,30000,50000,400000]
[7,20000,30000,50000,400000]
[8,20000,30000,50000,400000]
[9]
[10,20000,30000,50000,400000]
[11,20000,30000,50000,400000]
[12,20000,30000,50000,400000]
[13,20000,30000,50000,400000]
[14,20000,30000,50000,400000]
[15,20000,30000,50000,400000]
[16]
[17,20000,30000,50000,400000]
[18,20000,30000,50000,400000]
[19,20000,30000,50000,400000]
[20,20000,30000,50000,400000]
[21,20000,30000,50000,400000]
[22,20000,30000,50000,400000]
[23]
[24,20000,30000,50000,400000]
[25,20000,30000,50000,400000]
[26,20000,30000,50000,400000]
[27,20000,30000,50000,400000]
[28,20000,30000,50000,400000]
[29,20000,30000,50000,400000]
[30]

{"sheet":"変換設定","index":3,"n_rows":72,"n_cols":15,"rows_kept":72}
[{"$f":"詳細設定!A4","v":0},"■変換設定"]
[null,"項目","変換設定","値","値2\n（メモタグのみ）","値3\n（メモタグのみ）","値4\n（メモタグのみ）","年\n（日付表記\nの場合）","月\n（日付表記\nの場合）",{"$nulls":4},"選択肢","番号"]
[{"$f":"VLOOKUP(C3,$N$3:$O$10,2,FALSE)","v":8},"発生日（必須）","見出し列の値（日付表記）を用いる","2016-11-19",{"$nulls":3},"2016","12",{"$nulls":4},"見出し行の値を用いる",1]
[4,"支払期日","指定しない",{"$nulls":4},"2016","12",{"$nulls":4},"見出し列の値を用いる",2]
[4,"取引先","指定しない",{"$nulls":10},"一括で値を指定する",3]
[4,"備考","指定しない","備考",{"$nulls":9},"指定しない",4]
[{"$f":"VLOOKUP(C7,$N$3:$O$10,2,FALSE)","v":1},"品目","見出し行の値を用いる",{"$nulls":10},"見出し行の値（年月日表記）を用いる",5]
[4,"部門","指定しない",{"$nulls":10},"見出し列の値（年月日表記）を用いる",6]
[4,"メモタグ","指定しない",{"$nulls":10},"見出し行の値（日付表記）を用いる",7]
[null,"※値は一括指定の場合にのみ指定します",{"$nulls":11},"見出し列の値（日付表記）を用いる",8]
[null,"※シートの名称の変更、行・列の削除を避けてください"]
[null,"※日付または金額が空欄の場合、「変換前データ」シートの当該セルはデータの変換対象とはなりません。"]
[]
[null,"■【任意項目】 品目への勘定科目・税区分設定",{"$nulls":3},"■【任意項目】 見出し行・列に決済情報等が混在する場合の設定"]
[null,"見出し行・列の値で品目を設定する場合に、品目毎に勘定科目・税区分を指定できます。",{"$nulls":3},"品目等に加えて決済の情報等も混在する場合に、"]
[null,"（ここで設定せずインポートした場合でも、会計freeeの画面上で一括設定できます）",{"$nulls":3},"内容に応じた情報として取り込みます。"]
[]
[{"$f":"IF(C18=\"使用する\",1,0)","v":0},"勘定科目・税区分設定を","使用しない",null,null,"必要な場合のみ、詳細設定シートを表示して設定してください。"]
[]
[null,"一括指定する勘定科目","売上高"]
[null,"一括指定する税区分","非課売上"]
[]
[null,"品目","勘定科目","税区分",null,"■【任意項目】 無視する項目の設定"]
[null,"社保窓口収入","保険窓口収益","非課売上",null,"設定した項目については、データを作成しません。"]
[null,"国保窓口収入","保険窓口収益","非課売上"]
[null,"後期高齢者窓口収入","保険窓口収益","非課売上",null,"対象","項目名","Check"]
[null,"社保保険診療収入","保険請求収益","非課売上",{"$nulls":3},{"$f":"IF(G27=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G27)+COUNTIF(変換前データ!$A:$A,G27)>0,\"OK\",\"NG\"))","v":""}]
[null,"国保保険診療収入","保険請求収益","非課売上",{"$nulls":3},{"$f":"IF(G28=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G28)+COUNTIF(変換前データ!$A:$A,G28)>0,\"OK\",\"NG\"))","v":""}]
[null,"自由診療収入","自由診療収益","課税売上8%",{"$nulls":3},{"$f":"IF(G29=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G29)+COUNTIF(変換前データ!$A:$A,G29)>0,\"OK\",\"NG\"))","v":""}]
[null,"労災診療収入","自由診療収益","非課売上",{"$nulls":3},{"$f":"IF(G30=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G30)+COUNTIF(変換前データ!$A:$A,G30)>0,\"OK\",\"NG\"))","v":""}]
[null,"自賠責診療収入","自由診療収益","非課売上",{"$nulls":3},{"$f":"IF(G31=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G31)+COUNTIF(変換前データ!$A:$A,G31)>0,\"OK\",\"NG\"))","v":""}]
[null,"公害医療収入","自由診療収益","非課売上",{"$nulls":3},{"$f":"IF(G32=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G32)+COUNTIF(変換前データ!$A:$A,G32)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G33=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G33)+COUNTIF(変換前データ!$A:$A,G33)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G34=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G34)+COUNTIF(変換前データ!$A:$A,G34)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G35=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G35)+COUNTIF(変換前データ!$A:$A,G35)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G36=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G36)+COUNTIF(変換前データ!$A:$A,G36)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G37=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G37)+COUNTIF(変換前データ!$A:$A,G37)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G38=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G38)+COUNTIF(変換前データ!$A:$A,G38)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G39=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G39)+COUNTIF(変換前データ!$A:$A,G39)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G40=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G40)+COUNTIF(変換前データ!$A:$A,G40)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G41=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G41)+COUNTIF(変換前データ!$A:$A,G41)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G42=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G42)+COUNTIF(変換前データ!$A:$A,G42)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G43=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G43)+COUNTIF(変換前データ!$A:$A,G43)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G44=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G44)+COUNTIF(変換前データ!$A:$A,G44)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G45=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G45)+COUNTIF(変換前データ!$A:$A,G45)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G46=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G46)+COUNTIF(変換前データ!$A:$A,G46)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G47=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G47)+COUNTIF(変換前データ!$A:$A,G47)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G48=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G48)+COUNTIF(変換前データ!$A:$A,G48)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G49=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G49)+COUNTIF(変換前データ!$A:$A,G49)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G50=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G50)+COUNTIF(変換前データ!$A:$A,G50)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G51=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G51)+COUNTIF(変換前データ!$A:$A,G51)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G52=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G52)+COUNTIF(変換前データ!$A:$A,G52)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G53=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G53)+COUNTIF(変換前データ!$A:$A,G53)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G54=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G54)+COUNTIF(変換前データ!$A:$A,G54)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G55=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G55)+COUNTIF(変換前データ!$A:$A,G55)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G56=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G56)+COUNTIF(変換前データ!$A:$A,G56)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G57=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G57)+COUNTIF(変換前データ!$A:$A,G57)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G58=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G58)+COUNTIF(変換前データ!$A:$A,G58)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G59=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G59)+COUNTIF(変換前データ!$A:$A,G59)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G60=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G60)+COUNTIF(変換前データ!$A:$A,G60)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G61=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G61)+COUNTIF(変換前データ!$A:$A,G61)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G62=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G62)+COUNTIF(変換前データ!$A:$A,G62)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G63=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G63)+COUNTIF(変換前データ!$A:$A,G63)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G64=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G64)+COUNTIF(変換前データ!$A:$A,G64)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G65=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G65)+COUNTIF(変換前データ!$A:$A,G65)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G66=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G66)+COUNTIF(変換前データ!$A:$A,G66)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G67=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G67)+COUNTIF(変換前データ!$A:$A,G67)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G68=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G68)+COUNTIF(変換前データ!$A:$A,G68)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G69=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G69)+COUNTIF(変換前データ!$A:$A,G69)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G70=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G70)+COUNTIF(変換前データ!$A:$A,G70)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G71=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G71)+COUNTIF(変換前データ!$A:$A,G71)>0,\"OK\",\"NG\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G72=0,\"\",IF(COUNTIF(変換前データ!$2:$2,G72)+COUNTIF(変換前データ!$A:$A,G72)>0,\"OK\",\"NG\"))","v":""}]

{"sheet":"使い方","index":4,"n_rows":38,"n_cols":1,"rows_kept":38}
["このファイルを用いて、freeeのExcelインポート向けにデータ形式の変換を行うことができます。"]
["具体的には、①売上が種類別・日付別に記載されているデータ、②売上が種類別・部門別に記載されているデータ等、"]
["1行に複数の売上データが含まれるものが対象です。それらをインポート可能な1行毎のデータに変換します。"]
[]
["■シートの使い方"]
["1.見出し行・見出し列以外が数値（税込金額）で構成されたデータを用意します。"]
["※取り込みたいデータが存在するセルに関しては、必ず見出し列・見出し行に値を設定してください。　"]
["（見出し列・見出し行のいずれかが空欄の場合、正しく取り込まれません）"]
{"$rows_empty":12}
["2.当該データの内容に合わせ、「変換設定」シートで変換内容を設定します。"]
["※発生日以外の項目については、指定は必須ではありません。"]
["上記画像のような月次データについて、店舗名を部門に、事業部名を品目に入れたい場合は次の設定となります"]
{"$rows_empty":9}
["3.「変換前データ」シートにデータを貼り付けたのち、「データ変換」ボタンをクリックします"]
["4.「変換後データ」シートに整形されたデータが出力されます。そちらを用いてExcelインポートを行います。"]
[]
["■注意点"]
["※シートの名称変更、行や列の追加はしないでください。マクロが正しく動かなくなります。"]
["※本Excelファイルではマクロを使用しております。機能を有効にするため、コンテンツを有効化してください"]

{"sheet":"詳細設定","index":5,"n_rows":74,"n_cols":15,"rows_kept":74,"hidden":true}
[null,"※【注意】シートの名称の変更、行・列の削除を避けてください",{"$nulls":11},"決済内訳・収入","1"]
[null,"■ 見出し行・列に品目・部門・メモタグに加えて決済情報等が含まれる場合の設定",{"$nulls":11},"決済内訳・支出","2"]
[{"$nulls":13},"収入取引","3"]
[{"$f":"IF(C4=\"使用する\",1,0)","v":0},"追加情報の設定を","使用しない",{"$nulls":10},"支出取引","4"]
[{"$nulls":13},"振替・収入勘定","5"]
[null,"「仕訳」のデータ追加で作成されます。「決済内訳」の処理パターンを用いる場合、",{"$nulls":11},"振替・支出勘定","6"]
[null,"「変換後データ」シートに出力される「取引」の相手勘定はすべて仮口座とし、「仕訳データ」シートの仕訳でその分を振り替えます。"]
[]
[{"$f":"IF(C9=\"取引先\",1,IF(C9=\"品目\",2,IF(C9=\"部門\",3,IF(C9=\"メモタグ\",4,0))))","v":2},"対象とするタグ","品目"]
[null,"仮で用いる決済口座","現金"]
[]
[null,"項目名",{"$nulls":6},"作成される仕訳のプレビュー"]
[null,"（「変換前データ」シートの項目名と完全一致する必要があります）","処理パターン","勘定科目・決済口座","税区分","相手勘定\n（振替のみ）","相手勘定\n税区分\n（振替のみ）","備考","借方","貸方","Check","借税区分","貸税区分"]
[{"$f":"IFERROR(VLOOKUP($C14,$N$1:$O$6,2,FALSE)*1,\"\")","v":1},"カード売上","決済内訳・収入","カード売掛","対象外",null,null,"カード決済額",{"$f":"IF(OR($A14=1,$A14=4,$A14=6),$D14,IF(OR($A14=2,$A14=3),$C$10,IF($A14=\"\",\"\",$F14)))","v":"カード売掛"},{"$f":"IF(OR($A14=2,$A14=3,$A14=5),$D14,IF(OR($A14=1,$A14=4),$C$10,IF($A14=\"\",\"\",$F14)))","v":"現金"},{"$f":"IF($B14=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B14)+COUNTIF(変換前データ!$A:$A,$B14)>0,\"OK\",\"NG\"))","v":"NG"},{"$f":"IF(OR($A14=1,$A14=4,$A14=6),$E14,IF(OR($A14=2,$A14=3),\"対象外\",IF($A14=\"\",\"\",$G14)))","v":"対象外"},{"$f":"IF(OR($A14=2,$A14=3,$A14=5),$E14,IF(OR($A14=1,$A14=4),\"対象外\",IF($A14=\"\",\"\",$G14)))","v":"対象外"}]
[{"$f":"IFERROR(VLOOKUP($C15,$N$1:$O$6,2,FALSE)*1,\"\")","v":4},"未収金","支出取引","未収入金","対象外",null,null,"未収金の発生",{"$f":"IF(OR($A15=1,$A15=4,$A15=6),$D15,IF(OR($A15=2,$A15=3),$C$10,IF($A15=\"\",\"\",$F15)))","v":"未収入金"},{"$f":"IF(OR($A15=2,$A15=3,$A15=5),$D15,IF(OR($A15=1,$A15=4),$C$10,IF($A15=\"\",\"\",$F15)))","v":"現金"},{"$f":"IF($B15=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B15)+COUNTIF(変換前データ!$A:$A,$B15)>0,\"OK\",\"NG\"))","v":"NG"},{"$f":"IF(OR($A15=1,$A15=4,$A15=6),$E15,IF(OR($A15=2,$A15=3),\"対象外\",IF($A15=\"\",\"\",$G15)))","v":"対象外"},{"$f":"IF(OR($A15=2,$A15=3,$A15=5),$E15,IF(OR($A15=1,$A15=4),\"対象外\",IF($A15=\"\",\"\",$G15)))","v":"対象外"}]
[3,"未収金の回収","収入取引","未収入金","対象外",null,null,"未収金の回収",{"$f":"IF(OR($A16=1,$A16=4,$A16=6),$D16,IF(OR($A16=2,$A16=3),$C$10,IF($A16=\"\",\"\",$F16)))","v":"現金"},"未収入金",{"$f":"IF($B16=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B16)+COUNTIF(変換前データ!$A:$A,$B16)>0,\"OK\",\"NG\"))","v":"NG"},"対象外","対象外"]
[4,"値引き","支出取引","売上値引高","課税売返8%",null,null,"値引きの発生（売上値引）","売上値引高","現金",{"$f":"IF($B17=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B17)+COUNTIF(変換前データ!$A:$A,$B17)>0,\"OK\",\"NG\"))","v":"NG"},"課税売返8%","対象外"]
[4,"クーポン値引き","支出取引","販売促進費","課対仕入8%",null,null,"値引きの発生（販促費）","販売促進費","現金",{"$f":"IF($B18=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B18)+COUNTIF(変換前データ!$A:$A,$B18)>0,\"OK\",\"NG\"))","v":"NG"},"課対仕入8%","対象外"]
[3,"前受金","収入取引","前受金","対象外",null,null,"前受金の受領","現金","前受金",{"$f":"IF($B19=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B19)+COUNTIF(変換前データ!$A:$A,$B19)>0,\"OK\",\"NG\"))","v":"NG"},"対象外","対象外"]
[5,"前受金振替","振替・収入勘定","売上高","課税売上8%","前受金","対象外","前受分の売上計上","前受金","売上高",{"$f":"IF($B20=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B20)+COUNTIF(変換前データ!$A:$A,$B20)>0,\"OK\",\"NG\"))","v":"NG"},"対象外","課税売上8%"]
["",{"$nulls":7},"","",{"$f":"IF($B21=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B21)+COUNTIF(変換前データ!$A:$A,$B21)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B22=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B22)+COUNTIF(変換前データ!$A:$A,$B22)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B23=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B23)+COUNTIF(変換前データ!$A:$A,$B23)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B24=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B24)+COUNTIF(変換前データ!$A:$A,$B24)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B25=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B25)+COUNTIF(変換前データ!$A:$A,$B25)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B26=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B26)+COUNTIF(変換前データ!$A:$A,$B26)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B27=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B27)+COUNTIF(変換前データ!$A:$A,$B27)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B28=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B28)+COUNTIF(変換前データ!$A:$A,$B28)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B29=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B29)+COUNTIF(変換前データ!$A:$A,$B29)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B30=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B30)+COUNTIF(変換前データ!$A:$A,$B30)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B31=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B31)+COUNTIF(変換前データ!$A:$A,$B31)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B32=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B32)+COUNTIF(変換前データ!$A:$A,$B32)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B33=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B33)+COUNTIF(変換前データ!$A:$A,$B33)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B34=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B34)+COUNTIF(変換前データ!$A:$A,$B34)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B35=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B35)+COUNTIF(変換前データ!$A:$A,$B35)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B36=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B36)+COUNTIF(変換前データ!$A:$A,$B36)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B37=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B37)+COUNTIF(変換前データ!$A:$A,$B37)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B38=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B38)+COUNTIF(変換前データ!$A:$A,$B38)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B39=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B39)+COUNTIF(変換前データ!$A:$A,$B39)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B40=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B40)+COUNTIF(変換前データ!$A:$A,$B40)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B41=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B41)+COUNTIF(変換前データ!$A:$A,$B41)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B42=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B42)+COUNTIF(変換前データ!$A:$A,$B42)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B43=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B43)+COUNTIF(変換前データ!$A:$A,$B43)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B44=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B44)+COUNTIF(変換前データ!$A:$A,$B44)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B45=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B45)+COUNTIF(変換前データ!$A:$A,$B45)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B46=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B46)+COUNTIF(変換前データ!$A:$A,$B46)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B47=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B47)+COUNTIF(変換前データ!$A:$A,$B47)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B48=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B48)+COUNTIF(変換前データ!$A:$A,$B48)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B49=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B49)+COUNTIF(変換前データ!$A:$A,$B49)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B50=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B50)+COUNTIF(変換前データ!$A:$A,$B50)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B51=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B51)+COUNTIF(変換前データ!$A:$A,$B51)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B52=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B52)+COUNTIF(変換前データ!$A:$A,$B52)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B53=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B53)+COUNTIF(変換前データ!$A:$A,$B53)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B54=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B54)+COUNTIF(変換前データ!$A:$A,$B54)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B55=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B55)+COUNTIF(変換前データ!$A:$A,$B55)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B56=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B56)+COUNTIF(変換前データ!$A:$A,$B56)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B57=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B57)+COUNTIF(変換前データ!$A:$A,$B57)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B58=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B58)+COUNTIF(変換前データ!$A:$A,$B58)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B59=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B59)+COUNTIF(変換前データ!$A:$A,$B59)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B60=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B60)+COUNTIF(変換前データ!$A:$A,$B60)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B61=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B61)+COUNTIF(変換前データ!$A:$A,$B61)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B62=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B62)+COUNTIF(変換前データ!$A:$A,$B62)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B63=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B63)+COUNTIF(変換前データ!$A:$A,$B63)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B64=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B64)+COUNTIF(変換前データ!$A:$A,$B64)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B65=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B65)+COUNTIF(変換前データ!$A:$A,$B65)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B66=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B66)+COUNTIF(変換前データ!$A:$A,$B66)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B67=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B67)+COUNTIF(変換前データ!$A:$A,$B67)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B68=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B68)+COUNTIF(変換前データ!$A:$A,$B68)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B69=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B69)+COUNTIF(変換前データ!$A:$A,$B69)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B70=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B70)+COUNTIF(変換前データ!$A:$A,$B70)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B71=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B71)+COUNTIF(変換前データ!$A:$A,$B71)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B72=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B72)+COUNTIF(変換前データ!$A:$A,$B72)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B73=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B73)+COUNTIF(変換前データ!$A:$A,$B73)>0,\"OK\",\"NG\"))","v":""},"",""]
["",{"$nulls":7},"","",{"$f":"IF($B74=0,\"\",IF(COUNTIF(変換前データ!$2:$2,$B74)+COUNTIF(変換前データ!$A:$A,$B74)>0,\"OK\",\"NG\"))","v":""},"",""]

{"sheet":"詳細設定の使い方","index":6,"n_rows":33,"n_cols":3,"rows_kept":33,"hidden":true,"merged":[[27,0,28,0],[29,0,30,0],[31,0,32,0]]}
["■「詳細設定」を用いてできること"]
["見出し行・列に含まれる例外項目の処理が可能となります。"]
["・決済情報（現金/クレジットカード等）の反映（設定した勘定科目を一度経由しての振替となります）"]
["・収入/支出の処理（未収金の発生・その返金など）"]
[]
["「詳細設定」を用いる場合、インポートするデータが１種類増え、「仕訳」データが追加されます。"]
["※ エクセルインポートでは一番左のシートを読み込むので、順番を変更し上書き保存することで対象のシートを変更してください。"]
["「決済内訳」の処理パターンを用いた場合、"]
["下図の「①売上データ」について、すべて仮の決済口座で決済情報を付与しますが、"]
["「②決済等売上以外のデータ」の仕訳データにて振替を行い、クレジットカード決済分等を反映させます。"]
{"$rows_empty":13}
["　※ 仮の決済口座で決済情報を付与するため、取引への支払期日の付与はできません。"]
[]
["■「詳細設定」の処理パターン"]
["処理パターン",null,"説明"]
["決済","決済内訳・収入","設定された口座に、収入取引の決済情報を振り替えます。\n　例：\n顧客がクレジットカード払いで支払った売上分を反映する。"]
[null,"決済内訳・支出","設定された口座に、支出取引の決済情報を振り替えます。\n　例：\n仕入先へ支払いを行った銀行口座が混在しているので、その分を反映する。"]
["取引","収入取引","収入取引を作成します。\n　例：\n誤って受領した金額について、「預り金」の収入として処理する"]
[null,"支出取引","支出取引を作成します。\n　例：\n値引きした金額について、「売上値引高」の支出として処理する"]
["振替","振替・収入勘定","任意の貸方勘定科目について、指定した相手勘定との振替を作成します。\n　例：\n「前受金」で処理した手付金の受領額について、売上計上時に「売上高」へ振り替える"]
[null,"振替・支出勘定","任意の借方勘定科目について、指定した相手勘定との振替を作成します。\n　例：\n「前渡金」で処理した手付金の支払額について、仕入計上時に「仕入高」へ振り替える"]