{"text_format":"1","workbook":"xlsx","n_sheets":1,"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":7,"n_cols":25,"rows_kept":7,"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。"]
[2000,null,null,"2025-03-31","支払手数料","振込手数料","本社","課対仕入込10%",1650,null,"普通預金","みずほ銀行","本社","対象外",1650,null,"みずほ銀行　振込手数料　本社負担分",null,null,0,null,null,0,0,"no"]
[2110,null,null,"2025-03-31","地代家賃","事務所家賃","本社","課対仕入込10%",200000,null,"普通預金","みずほ銀行","本社","対象外",200000,null,"○○不動産　事務所家賃　3月分",null,null,3,null,null,0,0,"no"]
[2101,null,null,"2025-03-31","水道光熱費","電気代","本社","課対仕入込10%",5000,null,"普通預金","みずほ銀行","本社","対象外",5000,null,"○○電気　事務所電気代　3月分",null,null,3,null,null,0,0,"no"]