{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Rxx年度決算書","収支詳細","項目管理"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"comments":1,"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":"Rxx年度決算書","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,36,0,38],[0,34,0,35],[19,1,19,2],[17,1,17,2],[3,1,3,2],[19,6,19,9],[3,6,3,9]]}
[null,null,"令和xx年  町内会会計収支決算書"]
[null,null,"令和xx年１月１日 ～令和xx年１２月３１日"]
[null,"収入の部（単位：円）"]
[null,"項目",null,"本年度予算","決算額","予算比","備考"]
[null,1,"会費",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C5,収支詳細!G$5:[0]!G_last)","v":200000},{"$f":"E5-D5","v":200000},"①",{"$f":"項目管理!A4","v":"町内会費"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H5,収支詳細!G$5:[0]!G_last)","v":200000}]
[null,2,"新年会会費",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C6,収支詳細!G$5:[0]!G_last)","v":0},0,"①",{"$f":"項目管理!B4","v":"新年会会費"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H6,収支詳細!G$5:[0]!G_last)","v":0}]
[null,3,"使用料",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C7,収支詳細!G$5:[0]!G_last)","v":0},0,"①",{"$f":"項目管理!C4","v":"施設使用料"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H7,収支詳細!G$5:[0]!G_last)","v":0}]
[null,4,"補助金および交付金",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C8,収支詳細!G$5:[0]!G_last)","v":0},0,"①",{"$f":"項目管理!D4","v":"市集落推進費"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H8,収支詳細!G$5:[0]!G_last)","v":0}]
[null,null,null,null,null,null,"②",{"$f":"項目管理!D5","v":"自治振興会(前期/後期)"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H9,収支詳細!G$5:[0]!G_last)","v":0}]
[null,null,null,null,null,null,"③",{"$f":"項目管理!D6","v":"防犯協会(年末夜警助成金)"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H10,収支詳細!G$5:[0]!G_last)","v":0}]
[null,null,null,null,null,null,"④",{"$f":"項目管理!D7","v":"赤い羽根共同募金協力金"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H11,収支詳細!G$5:[0]!G_last)","v":0}]
[null,null,null,null,null,null,"⑤",{"$f":"項目管理!D8","v":0},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H12,収支詳細!G$5:[0]!G_last)","v":0}]
[null,5,"委託金",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C13,収支詳細!G$5:[0]!G_last)","v":0},0,"①",{"$f":"項目管理!E4","v":"里山再生整備委託"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H13,収支詳細!G$5:[0]!G_last)","v":0}]
[null,6,"寄付金",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C14,収支詳細!G$5:[0]!G_last)","v":0},0,"①",{"$f":"項目管理!F4","v":"新年会・村祭"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H14,収支詳細!G$5:[0]!G_last)","v":0}]
[null,7,"繰越金",null,null,0,"①",{"$f":"項目管理!G4","v":"前年度会計繰越金 (普通預金残高)"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H15,収支詳細!G$5:[0]!G_last)","v":293225}]
[null,8,"繰入金",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C16,収支詳細!G$5:[0]!G_last)","v":0},0,"①",{"$f":"項目管理!H4","v":"定期預金より普通預金通帳へ"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H16,収支詳細!G$5:[0]!G_last)","v":0}]
[null,9,"雑収入",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C17,収支詳細!G$5:[0]!G_last)","v":0},0,"①",{"$f":"項目管理!I4","v":"預金利息、御滝権現様社賽銭、出資配当金等"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H17,収支詳細!G$5:[0]!G_last)","v":0}]
[null,"合計",null,{"$f":"SUM(D5:D17)","v":0},{"$f":"SUM(E5:E17)","v":200000},200000]
[null,"支出の部（単位：円）"]
[null,"項目",null,"本年度予算","決算額","予算比","備考"]
[null,1,"会議費",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C21,収支詳細!G$5:[0]!F_last)","v":0},{"$f":"E21-D21","v":0},"①",{"$f":"項目管理!J4","v":"役員会及び監査等の会議費"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H21,収支詳細!F$5:[0]!F_last)","v":0}]
[null,2,"事務費",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C22,収支詳細!G$5:[0]!F_last)","v":0},{"$f":"E22-D22","v":0},"①",{"$f":"項目管理!K4","v":"役員交通費等"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H22,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"②",{"$f":"項目管理!K5","v":"印刷代、消耗品等"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H23,収支詳細!F$5:[0]!F_last)","v":0}]
[null,3,"事業費",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C24,収支詳細!G$5:[0]!F_last)","v":150000},{"$f":"E24-D24","v":150000},"①",{"$f":"項目管理!L4","v":"新年会"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H24,収支詳細!F$5:[0]!F_last)","v":150000}]
[null,null,null,null,null,null,"②",{"$f":"項目管理!L5","v":"江ざらい"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H25,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"③",{"$f":"項目管理!L6","v":"道路愛護"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H26,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"④",{"$f":"項目管理!L7","v":"里山再生"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H27,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑤",{"$f":"項目管理!L8","v":"地域体育大会"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H28,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑥",{"$f":"項目管理!L9","v":"歳末警戒"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H29,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑦",{"$f":"項目管理!L10","v":0},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H30,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑧",{"$f":"項目管理!L11","v":0},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H31,収支詳細!F$5:[0]!F_last)","v":0}]
[null,4,"施設管理費",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C32,収支詳細!G$5:[0]!F_last)","v":0},{"$f":"E32-D32","v":0},"①",{"$f":"項目管理!M4","v":"電気使用料"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H32,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"②",{"$f":"項目管理!M5","v":"ＬＰガス代"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H33,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"③",{"$f":"項目管理!M6","v":"上水道使用使用料"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H34,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"④",{"$f":"項目管理!M7","v":"下水道使用使用料"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H35,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑤",{"$f":"項目管理!M8","v":"建物共済"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H36,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑥",{"$f":"項目管理!M9","v":"責任賠償保険"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H37,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑦",{"$f":"項目管理!M10","v":"灯油代"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H38,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑧",{"$f":"項目管理!M11","v":0},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H39,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑨",{"$f":"項目管理!M12","v":0},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H40,収支詳細!F$5:[0]!F_last)","v":0}]
[null,5,"負担金及び補助金",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C41,収支詳細!G$5:[0]!F_last)","v":0},{"$f":"E41-D41","v":0},"①",{"$f":"項目管理!N4","v":"小学校後援会"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H41,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"②",{"$f":"項目管理!N5","v":"中学校後援会"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H42,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"③",{"$f":"項目管理!N6","v":"自治振興会負担金"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H43,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"④",{"$f":"項目管理!N7","v":"地区体育協会負担金"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H44,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑤",{"$f":"項目管理!N8","v":"青少年育成"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H45,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑥",{"$f":"項目管理!N9","v":"老人クラブ助成金"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H46,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,null,null,null,null,"⑦",{"$f":"項目管理!N10","v":0},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H47,収支詳細!F$5:[0]!F_last)","v":0}]
[null,6,"諸費",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C48,収支詳細!F$5:[0]!F_last)","v":0},{"$f":"E48-D48","v":0},"①",{"$f":"項目管理!O4","v":"慶弔費等"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H48,収支詳細!F$5:[0]!F_last)","v":0}]
[null,7,"予備費",null,{"$f":"SUMIF(収支詳細!C$5:C_last,Rxx年度決算書!C49,収支詳細!G$5:[0]!F_last)","v":0},{"$f":"E49-D49","v":0},"①",{"$f":"項目管理!P4","v":"予備費"},null,{"$f":"SUMIF(収支詳細!D$5:D_last,Rxx年度決算書!H49,収支詳細!F$5:[0]!F_last)","v":0}]
[null,null,"合計",{"$f":"SUM(D21:D49)","v":0},{"$f":"SUM(E21:E49)","v":150000},{"$f":"E50-D50","v":150000}]

{"sheet":"収支詳細","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,11,3,11],[2,10,3,10],[2,8,3,8],[2,9,3,9]]}
[null,null,"令和xx年度　収支明細"]
[]
["項","年月日","費目","内容","明細","支出金額","収入金額","振替","出金口座","普通預金","手持金","備考"]
[]
[1,"2016-01-01","繰越金","前年度会計繰越金 (普通預金残高)","普通預金初年度残高",null,293225,null,"普通預金",{"$f":"IF(I5=J$3,J4-F5+G5,J4-H5)","v":293225},{"$f":"IF(I5=K$3,K4-F5+G5+H5,K4)","v":0}]
[{"$f":"A5+1","v":2},"2016-04-01","会費","町内会費",null,null,200000,null,"手持金",{"$f":"IF(I6=J$3,J5-F6+G6,J5-H6)","v":293225},{"$f":"IF(I6=K$3,K5-F6+G6+H6,K5)","v":200000}]
[{"$f":"A6+1","v":3},"2016-04-04","事業費","新年会",null,150000,null,null,"手持金",{"$f":"IF(I7=J$3,J6-F7+G7,J6-H7)","v":293225},{"$f":"IF(I7=K$3,K6-F7+G7+H7,K6)","v":50000}]
[{"$f":"A7+1","v":4},null,null,null,null,null,null,null,null,{"$f":"IF(I8=J$3,J7-F8+G8,J7-H8)","v":293225},{"$f":"IF(I8=K$3,K7-F8+G8+H8,K7)","v":50000}]
[null,null,"合計",null,null,{"$f":"SUM(F5:F8)","v":150000},{"$f":"SUM(G5:G8)","v":493225},{"$f":"SUM(H5:H8)","v":0},null,{"$f":"J8","v":293225},{"$f":"K8","v":50000}]
[null,null,null,null,"SubTotal",{"$f":"SUBTOTAL(9, F5:F8)","v":150000},{"$f":"SUBTOTAL(9, G5:G8)","v":493225}]

{"sheet":"項目管理","index":2,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,8],[1,9,1,15]]}
[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,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,"灯油代"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["手持金","普通預金","定期預金"]