{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["設定","1","2","3","4","5","6","7","8","9","10","11","12","科目一覧"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"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":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"小口現金出納帳　印刷ツール"]
[null,null,"V3.0"]
[null,"事業所名"]
[null,"事業種別","保育事業"]
[null,"契約ID"]
[null,"決算月",3]
[null,"対象年",2023]
[null,"前年度残"]
[null,"起動時読込み","する"]
[null,"画像格納フォルダー","D:\\Petty\\印刷ツール\\ABC保育園\\image"]
[null,"画像一時フォルダー","D:\\Petty\\印刷ツール\\ABC保育園\\tmp"]
[]
[null,"＜初期設定＞"]
[null,"・経理職員用アプリの「設定」-「契約について」でメール送信ボタンをタッチしてIDを本パソコンに送信します。\n"]
[null,"・メールで受信したデータをコピーし、上記の事業所名、事業種別、契約ID欄に貼り付けます。"]
[]
[null,"上記の後に再集計ボタンをクリックするか、保存終了して再起動すれば印刷可能状態になります。"]
[null,"起動時読込みを「しない」にすると以前に読み込まれたデータがそのまま使われます。"]
[null,"画像格納フォルダーは対象年の写真を全て保存してあるフォルダーです。（書込み不可でも良いです）"]
[null,"画像一時フォルダーは写真表示用に一時的に使用するフォルダーです。（書き込み可能でなければなりません）"]
[null,"日付セルの背面が赤色の行は画像が未確認の状況を表しています。本ツールでも表示して確認できます。"]

{"sheet":"1","index":1,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和5年1月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和5年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,"前月残",{"$f":"設定!C8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"2","index":2,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和5年2月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和5年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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"3","index":3,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和5年3月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和5年3月 小口現金出納帳"}]
["日付","入力日付","精算日付","科目設定日付","勘定科目","課税区分","購入者","取引先","摘要","金額","添付写真","科目設定者",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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"4","index":4,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和4年4月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和4年4月 小口現金出納帳"}]
["日付","入力日付","精算日付","科目設定日付","勘定科目","課税区分","購入者","取引先","摘要","金額","添付写真","科目設定者",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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"5","index":5,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和4年5月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和4年5月 小口現金出納帳"}]
["日付","入力日付","精算日付","科目設定日付","勘定科目","課税区分","購入者","取引先","摘要","金額","添付写真","科目設定者",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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"6","index":6,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和4年6月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和4年6月 小口現金出納帳"}]
["日付","入力日付","精算日付","科目設定日付","勘定科目","課税区分","購入者","取引先","摘要","金額","添付写真","科目設定者",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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"7","index":7,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和4年7月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和4年7月 小口現金出納帳"}]
["日付","入力日付","精算日付","科目設定日付","勘定科目","課税区分","購入者","取引先","摘要","金額","添付写真","科目設定者",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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"8","index":8,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和4年8月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和4年8月 小口現金出納帳"}]
["日付","入力日付","精算日付","科目設定日付","勘定科目","課税区分","購入者","取引先","摘要","金額","添付写真","科目設定者",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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"9","index":9,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和4年9月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和4年9月 小口現金出納帳"}]
["日付","入力日付","精算日付","科目設定日付","勘定科目","課税区分","購入者","取引先","摘要","金額","添付写真","科目設定者",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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"10","index":10,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和4年10月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和4年10月 小口現金出納帳"}]
["日付","入力日付","精算日付","科目設定日付","勘定科目","課税区分","購入者","取引先","摘要","金額","添付写真","科目設定者",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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"11","index":11,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和4年11月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和4年11月 小口現金出納帳"}]
["日付","入力日付","精算日付","科目設定日付","勘定科目","課税区分","購入者","取引先","摘要","金額","添付写真","科目設定者",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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"12","index":12,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15]]}
[{"$f":"TEXT(IF(INT(RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))) > 設定!C6,DATE(設定!C7-1,1,1),DATE(設定!C7,1,1)),\"ggge\")&\"年\"&RIGHT(CELL(\"filename\",B2),LEN(CELL(\"filename\",B2))-FIND(\"]\",CELL(\"filename\",B2)))&\"月 \"&設定!C3&\"小口現金出納帳\"","v":"令和4年12月 小口現金出納帳"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"令和4年12月 小口現金出納帳"}]
["日付","入力日付","精算日付","科目設定日付","勘定科目","課税区分","購入者","取引先","摘要","金額","添付写真","科目設定者",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,"前月残",{"$f":"INDIRECT(\"'\"&getSheetName(_xlfn.SHEET()-1)&\"'!O7:P7\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月入金額",{"$f":"SUM(U4:U500)-SUM(W4:W500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"当月支払額",{"$f":"SUM(J3:J500)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次月繰越",{"$f":"O4+O5-O6","v":0}]
[]
[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,"勘定科目","消費税","金額"]

{"sheet":"科目一覧","index":13,"n_rows":18,"n_cols":75,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["介護保険事業="]
["人件費:","役員報酬","役員退職慰労金","役員退職慰労引当金繰入","職員給料","職員賞与","非常勤職員給与","派遣職員費","退職給付費用","法定福利費",":事業費:","給食費","介護用品費","医薬品費","診療・療養等材料費","保健衛生費","医療費","被服費","教養娯楽費","日用品費",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,"雑費(事業)",":事務費:","福利厚生費","職員被服費","旅費交通費","研修研究費","事務消耗品費","印刷製本費","修繕費","通信運搬費","会議費","広報費","業務委託費","手数料","土地・建物賃借料","租税公課","保守料","渉外費","諸会費","雑費(事務)",":流動資産:","貯蔵品","医薬品","診療・療養費等材料","給食用材料","商品・製品","仕掛品","原材料","立替金","前払金","前払費用","その他の流動資産",":流動負債:","事業未払金","その他の未払金","役員等短期借入金","未払費用","未返還金","預り金","職員預り金","前受金","前受収益","その他の流動負債"]
["一般="]
["人件費:","役員報酬","給料手当","賞与","退職給与","法定福利費","厚生費",":販売費:","販売員給与","旅費交通費","広告宣伝費","容器包装費","荷造運賃","会議費","その他販売費","外注費",":一般管理費:","リース料","地代家賃","修繕費","事務消耗品費","通信費","水道光熱費","租税公課","寄付金","接待交際費","保険料","備品消耗品費","管理諸費","図書研修費","車両費","販売手数料","雑費",":製造原価:","材料仕入高","賃金","賞与","雑給","法定福利費(製造)","厚生費(製造)","退職金(製造)","外注加工費(製造)","水道光熱費(製造)","運賃(製造)","リース料(製造)","修繕費(製造)","租税公課(製造)","賃借料(製造)","保険料(製造)","消耗品費(製造)","旅費交通費(製造)","通信費(製造)","消耗工具費(製造)","雑費(製造)",":流動資産:","前渡金","前払費用","立替金",":流動負債:","買掛金","未払金","未払費用","前受金","預り金","その他の流動負債"]
["General="]
["Labor cost:","Directors’ compensations","Salaries","Bonuses","Employee retirement allowance","Legal welfare expenses","Welfare expenses",":Selling costs:","Salesperson salary","Traveling & transportation expenses","Advertising expenses","Packing expenses","Packing fare","Conference expenses","Promotional expense","Subcontract expenses",":General administrative expense:","Lease expenses","Rent expenses","Repair expenses","Office supplies expense","Communication expenses","Heat, light, and water expenses","Taxes and dues","Donation","Entertainment expenses","Insurance expenses","Supplies expenses","Administrative expenses","Library and training expense","Vehicle expenses","Sales commission","Miscellaneous expenses",":Manufacturing cost:","Material purchased","Wages expense","Bonuses(Manufacturing)","Miscellaneous wages","Legal welfare expenses(Manufacturing)","Welfare expenses(Manufacturing)","Employee retirement allowance(Manufacturing)","Expenses arising from outside manufactures","Heat, light, and water expenses(Manufacturing)","fare(Manufacturing)","Lease expenses(Manufacturing)","Repair expenses(Manufacturing)","Taxes and dues(Manufacturing)","Rent(Manufacturing)","Insurance expenses(Manufacturing)","Supplies expenses(Manufacturing)","Traveling & transportation expenses(Manufacturing)","Communication expenses(Manufacturing)","Consumable tool expenses(Manufacturing)","Miscellaneous expenses(Manufacturing)",":Current assets:","Advance payment","Prepaid expenses","Advance money",":Current liabilities:","Trade accounts payable","Accounts payable","Accrued expenses","Advance received","Withholding","Liabilities- other"]