{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["作成シート","設定シート"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"作成シート","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["【楽楽債権管理】 仕訳変換ツール"]
[]
["【操作手順】"]
[]
["１．「楽楽債権管理」から消込情報データを出力する"]
[null,"「楽楽債権管理」にアクセス＞「消込情報」画面よりCSV出力し、\n右のボタンからデータを選択します。"]
[]
["２．「楽楽債権管理」から仕訳データを出力する"]
[null,"「楽楽債権管理」にアクセス＞「仕訳」画面よりCSV出力し、\n右のボタンからデータを選択します。"]
[null,"　　　　仕訳データの1行目を読み込む",null,null,false]
[]
["3．変換を実行する"]
[null,"右のボタンをクリックすると、変換後の仕訳データが出力されます。"]

{"sheet":"設定シート","index":1,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[2,9,3,9],[0,0,0,9],[2,3,2,6],[2,7,2,8],[2,0,3,0],[2,1,3,1],[2,2,3,2],[3,7,3,8]]}
["仕訳出力フォーマット設定"]
["変換後の出力フォーマットと出力条件を指定してください。"]
["対象項目","取込データ区分","取込列","出力内容の設定",null,null,null,null,null,"データ型"]
[null,null,null,"出力列","変更後ヘッダー名","任意の文字列","日付書式","出力条件"]
["伝票区切（勘定奉行）","仕訳データ"]
["伝票番号","仕訳データ"]
["仕訳日","仕訳データ",null,null,null,null,"yyyy/mm/dd"]
["借方：勘定科目コード","仕訳データ"]
["借方：勘定科目名","仕訳データ"]
["借方：補助科目コード","仕訳データ"]
["借方：補助科目名","仕訳データ"]
["借方：金額","仕訳データ",null,null,null,null,null,null,null,"数値"]
["貸方：勘定科目コード","仕訳データ"]
["貸方：勘定科目名","仕訳データ"]
["貸方：補助科目コード","仕訳データ"]
["貸方：補助科目名","仕訳データ"]
["貸方：金額","仕訳データ",null,null,null,null,null,null,null,"数値"]
["摘要","仕訳データ"]
["顧客コード","仕訳データ"]
["任意項目1（顧客データ）","仕訳データ"]
["任意項目2（顧客データ）","仕訳データ"]
["任意項目3（顧客データ）","仕訳データ"]
["消込日時","消込情報データ",1,null,null,null,"yyyy/mm/dd"]
["顧客コード","消込情報データ",2]
["顧客名","消込情報データ",3]
["請求ID","消込情報データ",4]
["帳票種別","消込情報データ",5]
["帳票No","消込情報データ",6]
["売上計上日","消込情報データ",7,null,null,null,"yyyy/mm/dd"]
["支払期日","消込情報データ",8,null,null,null,"yyyy/mm/dd"]
["発行日","消込情報データ",9,null,null,null,"yyyy/mm/dd"]
["請求金額","消込情報データ",10,null,null,null,null,null,null,"数値"]
["請求消込額","消込情報データ",11,null,null,null,null,null,null,"数値"]
["入金ID","消込情報データ",12]
["振込依頼人名","消込情報データ",13]
["振込元銀行名","消込情報データ",14]
["振込元支店名","消込情報データ",15]
["入金先銀行名","消込情報データ",16]
["入金先支店名","消込情報データ",17]
["預金種目","消込情報データ",18]
["入金先口座番号","消込情報データ",19]
["入金先口座名義","消込情報データ",20]
["入金日","消込情報データ",21,null,null,null,"yyyy/mm/dd"]
["入金額","消込情報データ",22,null,null,null,null,null,null,"数値"]
["消込額（入金残高）","消込情報データ",23,null,null,null,null,null,null,"数値"]
["消込額（前受金）","消込情報データ",24,null,null,null,null,null,null,"数値"]
["調整金","消込情報データ",25,null,null,null,null,null,null,"数値"]
["調整金メモ","消込情報データ",26]
["消込メモ","消込情報データ",27]
["任意項目1（請求データ）","消込情報データ",28]
["任意項目2（請求データ）","消込情報データ",29]
["任意項目3（請求データ）","消込情報データ",30]
["任意項目1（顧客データ）","消込情報データ",31]
["任意項目2（顧客データ）","消込情報データ",32]
["任意項目3（顧客データ）","消込情報データ",33]
["消込方法","消込情報データ",34]
["消込実行スタッフ","消込情報データ",35]
["CSV出力","消込情報データ",36]
["前回CSV出力日時","消込情報データ",37,null,null,null,"yyyy/mm/dd HH:MM"]
["前回CSV出力スタッフ","消込情報データ",38]
["識別フラグ（弥生会計）\n※仕訳データ「伝票番号」の取込が必須です","-"]