{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["作成シート","レイアウト定義"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,11],[5,0,5,4],[8,0,8,4],[11,0,11,4]]}
["【楽楽債権管理】入金予定表　作成ツール"]
[]
["【操作手順】"]
[]
["1. 請求データを読み込む"]
["　　「楽楽債権管理」にアクセス＞「請求」画面よりCSV出力を行い、\n　　「請求データ選択」ボタンから出力されたデータを選択します。"]
[]
["2. 消込情報データを読み込む"]
["　　「楽楽債権管理」にアクセス＞「消込情報」画面よりCSV出力を行い、\n　　「消込データ選択」ボタンから出力されたデータを選択します。"]
[]
["3. 入金予定表を作成する"]
["　　以下に作成したい入金予定表の対象期間（入金予定日の期間）を入力します。\n　　「作成する」ボタンをクリックすると、入金予定表が作成されます。"]
[null,"■対象期間（入金予定日）"]
[null,"2026-01-01","～","2026-01-31"]
[]
[]
["【初期設定】"]
["１．請求データの出力フォーマットを変更している場合は、背景緑色の「列番号(CSV)」を修正してください。"]
[null,"■入金予定表（得意先別）"]
[null,"項目名","列番号（Excel）","参照元データ","列番号（CSV）"]
[null,"顧客コード","B","請求","C"]
[null,"顧客名","C","請求","D"]
[null,"帳票No","D","請求","L"]
[null,"ステータス","E","請求","B"]
[null,"売上計上日","F","請求","E"]
[null,"入金予定日","G","請求","F"]
[null,"入金予定額","H","請求","G"]
[null,"入金額","I","消込情報","W"]
[null,"調整金","J","消込情報","Y"]
[null,"差額","K","-","-"]
[null,"入金日","L","消込情報","U"]
[null,"入金先銀行名","M","消込情報","P"]
[null,"入金先支店名","N","消込情報","Q"]
[null,"入金先口座番号","O","消込情報","S"]
[null,"請求ID（請求）","-","請求","A"]
[null,"請求ID（消込情報）","-","消込情報","D"]

{"sheet":"レイアウト定義","index":1,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"入金予定表"]
[null,"対象月：25年12月（入金予定日：2025/12/1～12/31）",null,null,null,null,null,null,null,"入金予定額合計：",{"$f":"SUM(H:H)","v":0},"円","入金額合計：",{"$f":"SUM(I:I)","v":0},"円"]
[null,"顧客コード","顧客名","帳票No","ステータス","売上計上日","入金予定日","入金予定額","入金額","調整金","差額","入金日","入金先銀行名","入金先支店名","入金先口座"]