{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["伝票作成","上水調定入力","銀行手数料","上水入金"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["ID","読込FLG","予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日"]
[1,10,"予算伝票始まり"]
[2,11,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日"]
[3,0,"都市部"]
[4,1,"110101-0100","152010-1000","611010-1000",549393689.090909,null,{"$f":"\"定例調定：\"&$C$4&\"：隔月分\"","v":"定例調定：都市部：隔月分"},"2020-11-18"]
[5,1,"110101-0100","152010-1000","611010-1000",55523149.999999993,null,{"$f":"\"定例調定：\"&$C$4&\"：毎月分\"","v":"定例調定：都市部：毎月分"},"2020-11-18"]
[6,1,"110101-0100","152010-1000","611010-1000",null,null,"臨時・仮設前受金精算","2020-11-18"]
[7,1,"110101-0100","152010-1000","611010-1000",null,null,{"$f":"\"調定増：現年度：\"&$C$4","v":"調定増：現年度：都市部"},"2020-11-18"]
[8,1,"110503-0100","152010-1000","613020-1000",null,null,{"$f":"\"調定増：過年度：\"&$C$4","v":"調定増：過年度：都市部"},"2020-11-18"]
[9,1,"110101-0100","611010-1000","152010-1000",null,null,{"$f":"\"調定減：現年度：\"&$C$4","v":"調定減：現年度：都市部"},"2020-11-18"]
[10,1,"210507-0100","713040-1000","152010-1000",null,null,{"$f":"\"調定減：過年度：\"&$C$4","v":"調定減：過年度：都市部"},"2020-11-18"]
[11,0,"都祁"]
[12,1,"110101-0300","152010-1000","611010-2000",null,null,{"$f":"\"定例調定：\"&$C$12&\"：隔月分\"","v":"定例調定：都祁：隔月分"},"2020-11-18"]
[13,1,"110101-0300","152010-1000","611010-2000",null,null,{"$f":"\"定例調定：\"&$C$12&\"：毎月分\"","v":"定例調定：都祁：毎月分"},"2020-11-18"]
[14,1,"110101-0300","152010-1000","611010-2000",null,null,"臨時・仮設前受金精算","2020-11-18"]
[15,1,"110101-0300","152010-1000","611010-2000",null,null,{"$f":"\"調定増：現年度：\"&$C$12","v":"調定増：現年度：都祁"},"2020-11-18"]
[16,1,"110503-0100","152010-1000","613020-1000",null,null,{"$f":"\"調定増：過年度：\"&$C$12","v":"調定増：過年度：都祁"},"2020-11-18"]
[17,1,"110101-0300","611010-2000","152010-1000",null,null,{"$f":"\"調定減：現年度：\"&$C$12","v":"調定減：現年度：都祁"},"2020-11-18"]
[18,1,"210507-0100","713040-1000","152010-1000",null,null,{"$f":"\"調定減：過年度：\"&$C$12","v":"調定減：過年度：都祁"},"2020-11-18"]
[19,0,"月ヶ瀬"]
[20,1,"110101-0500","152010-1000","611010-3000",null,null,{"$f":"\"定例調定：\"&$C$20&\"：隔月分\"","v":"定例調定：月ヶ瀬：隔月分"},"2020-11-18"]
[21,1,"110101-0500","152010-1000","611010-3000",null,null,{"$f":"\"定例調定：\"&$C$20&\"：毎月分\"","v":"定例調定：月ヶ瀬：毎月分"},"2020-11-18"]
[22,1,"110101-0500","152010-1000","611010-3000",null,null,"臨時・仮設前受金精算","2020-11-18"]
[23,1,"110101-0500","152010-1000","611010-3000",null,null,{"$f":"\"調定増：現年度：\"&$C$20","v":"調定増：現年度：月ヶ瀬"},"2020-11-18"]
[24,1,"110503-0100","152010-1000","613020-1000",null,null,{"$f":"\"調定増：過年度：\"&$C$20","v":"調定増：過年度：月ヶ瀬"},"2020-11-18"]
[25,1,"110101-0500","611010-3000","152010-1000",null,null,{"$f":"\"調定減：現年度：\"&$C$20","v":"調定減：現年度：月ヶ瀬"},"2020-11-18"]
[26,1,"210507-0100","713040-1000","152010-1000",null,null,{"$f":"\"調定減：過年度：\"&$C$20","v":"調定減：過年度：月ヶ瀬"},"2020-11-18"]
[27,0,"金額合計"]
[28,19,"予算伝票終わり",null,null,null,null,""]
[29,20,"簿記伝票始まり",null,null,null,null,""]
[30,22,"簿記科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[31,0,"都市部"]
[32,2,{"$f":"C5","v":"110101-0100"},"152010-1000","611010-1000",null,null,{"$f":"H5","v":"定例調定：都市部：隔月分"},"2020-11-18"]
[null,null,null,"152010-1000","336010-1000"]
[33,2,{"$f":"C6","v":"110101-0100"},{"$f":"D6","v":"152010-1000"},{"$f":"E6","v":"611010-1000"},null,null,{"$f":"H6","v":"定例調定：都市部：毎月分"},"2020-11-18"]
[null,null,null,"152010-1000","336010-1000"]
[34,2,"110101-0100","152010-1000","611010-1000",null,null,"臨時・仮設前受金精算","2020-11-18"]
[null,null,null,"152010-1000","336010-1000"]
[35,2,{"$f":"C8","v":"110101-0100"},"152010-1000","611010-1000",null,null,{"$f":"H8","v":"調定増：現年度：都市部"},"2020-11-18"]
[null,null,null,"152010-1000","336010-1000"]
[36,2,{"$f":"C9","v":"110503-0100"},"152010-1000","613020-1000",null,null,{"$f":"H9","v":"調定増：過年度：都市部"},"2020-11-18"]
[null,null,null,"152010-1000","336010-1000"]
[37,2,{"$f":"C10","v":"110101-0100"},"611010-1000","152010-1000",null,null,{"$f":"H10","v":"調定減：現年度：都市部"},"2020-11-18"]
[null,null,null,"336010-1000","152010-1000"]
[38,2,{"$f":"C11","v":"210507-0100"},"713040-1000","152010-1000",null,null,{"$f":"H11","v":"調定減：過年度：都市部"},"2020-11-18"]
[null,null,null,"158030-1000","152010-1000"]
[39,0,"都祁"]
[]
[40,2,{"$f":"C13","v":"110101-0300"},"152010-1000","611010-2000",null,null,{"$f":"H13","v":"定例調定：都祁：隔月分"},"2020-11-18"]
[]
[41,2,{"$f":"C14","v":"110101-0300"},{"$f":"D14","v":"152010-1000"},{"$f":"E14","v":"611010-2000"},null,null,{"$f":"H14","v":"定例調定：都祁：毎月分"},"2020-11-18"]
[]
[42,2,"110101-0300","152010-1000","611010-2000",null,null,"臨時・仮設前受金精算","2020-11-18"]
[]
[43,2,{"$f":"C16","v":"110101-0300"},"152010-1000","611010-2000",null,null,{"$f":"H16","v":"調定増：現年度：都祁"},"2020-11-18"]
[]
[44,2,{"$f":"C17","v":"110503-0100"},"152010-1000","613020-1000",null,null,{"$f":"H17","v":"調定増：過年度：都祁"},"2020-11-18"]
[]
[45,2,{"$f":"C18","v":"110101-0300"},"611010-2000","152010-1000",null,null,{"$f":"H18","v":"調定減：現年度：都祁"},"2020-11-18"]
[]
[46,2,{"$f":"C19","v":"210507-0100"},"713040-1000","152010-1000",null,null,{"$f":"H19","v":"調定減：過年度：都祁"},"2020-11-18"]
[]
[47,0,"月ヶ瀬"]
[]
[48,2,{"$f":"C21","v":"110101-0500"},"152010-1000","611010-3000",null,null,{"$f":"H21","v":"定例調定：月ヶ瀬：隔月分"},"2020-11-18"]
[]
[49,2,{"$f":"C22","v":"110101-0500"},{"$f":"D22","v":"152010-1000"},{"$f":"E22","v":"611010-3000"},null,null,{"$f":"H22","v":"定例調定：月ヶ瀬：毎月分"},"2020-11-18"]
[]
[50,2,"110101-0100","152010-1000","611010-1000",null,null,"臨時・仮設前受金精算","2020-11-18"]
[]
[51,2,{"$f":"C24","v":"110101-0500"},"152010-1000","611010-3000",null,null,{"$f":"H24","v":"調定増：現年度：月ヶ瀬"},"2020-11-18"]
[]
[52,2,{"$f":"C25","v":"110503-0100"},"152010-1000","613020-1000",null,null,{"$f":"H25","v":"調定増：過年度：月ヶ瀬"},"2020-11-18"]
[]
[53,2,{"$f":"C26","v":"110101-0500"},"611010-3000","152010-1000",null,null,{"$f":"H26","v":"調定減：現年度：月ヶ瀬"},"2020-11-18"]
[]
[54,2,{"$f":"C27","v":"210507-0100"},"713040-1000","152010-1000",null,null,{"$f":"H27","v":"調定減：過年度：月ヶ瀬"},"2020-11-18"]
[]
[55,0,"金額合計"]
[56,29,"簿記伝票終わり"]
[999,999,"全伝票終わり"]

{"sheet":"上水調定入力","index":1,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["ID","読込FLG","予算科目CD","借方科目CD","貸方科目CD"]
[null,"都市部","110101-0100","152010-1000","611010-1000"]
[null,"都祁","110101-0300","152010-1000","611010-2000"]
[null,"月ヶ瀬","110101-0500","152010-1000","611010-3000"]
[null,"仮受消費税","336010-1000"]
[null,"仮払消費税","158030-1000"]
[null,"過年度修正益","613020-1000"]
[null,"過年度修正損","713040-1000"]
[]
[null,"発行日","2020-01-01"]
["ID","読込FLG","予算科目CD","借方科目CD","貸方科目CD","税込み金額","税抜き金額","消費税額","摘要"]
[1,0,"都市部"]
[2,1,"給水収益","給水未収金","給水収益",604333058,{"$f":"F13/1.1","v":549393689.090909},{"$f":"F13-G13","v":54939368.909090996},{"$f":"\"定例調定：\"&$C$12&\"：隔月分\"","v":"定例調定：都市部：隔月分"}]
[3,1,"給水収益","給水未収金","給水収益",61075465,{"$f":"F14/1.1","v":55523149.999999993},{"$f":"F14-G14","v":5552315.0000000075},{"$f":"\"定例調定：\"&$C$12&\"：毎月分\"","v":"定例調定：都市部：毎月分"}]
[4,1,"給水収益","給水未収金","給水収益",788150,716500,71650,"臨時・仮設前受金精算"]
[5,1,"給水収益","給水未収金","給水収益",15861,14419.090909090908,1441.9090909090919,{"$f":"\"調定増：現年度：\"&$C$12","v":"調定増：現年度：都市部"}]
[6,1,"過年度修正益","給水未収金","過年度修正益",null,0,0,{"$f":"\"調定増：過年度：\"&$C$12","v":"調定増：過年度：都市部"}]
[7,1,"給水収益","給水収益","給水未収金",31360,28509.090909090908,2850.9090909090919,{"$f":"\"調定減：現年度：\"&$C$12","v":"調定減：現年度：都市部"}]
[8,1,"過年度修正損","過年度修正損","給水未収金",null,0,0,{"$f":"\"調定減：過年度：\"&$C$12","v":"調定減：過年度：都市部"}]
[9,0,"都祁"]
[10,1,"給水収益","給水未収金","給水収益",11228857,{"$f":"F21/1.1","v":10208051.818181816},{"$f":"F21-G21","v":1020805.1818181835},{"$f":"\"定例調定：\"&$C$20&\"：隔月分\"","v":"定例調定：都祁：隔月分"}]
[11,1,"給水収益","給水未収金","給水収益",null,{"$f":"F22/1.1","v":0},{"$f":"F22-G22","v":0},{"$f":"\"定例調定：\"&$C$20&\"：毎月分\"","v":"定例調定：都祁：毎月分"}]
[12,1,"給水収益","給水未収金","給水収益",null,0,0,"臨時・仮設前受金精算"]
[13,1,"給水収益","給水未収金","給水収益",null,0,0,{"$f":"\"調定増：現年度：\"&$C$20","v":"調定増：現年度：都祁"}]
[14,1,"過年度修正益","給水未収金","過年度修正益",null,0,0,{"$f":"\"調定増：過年度：\"&$C$20","v":"調定増：過年度：都祁"}]
[15,1,"給水収益","給水収益","給水未収金",null,0,0,{"$f":"\"調定減：現年度：\"&$C$20","v":"調定減：現年度：都祁"}]
[16,1,"過年度修正損","過年度修正損","給水未収金",null,0,0,{"$f":"\"調定減：過年度：\"&$C$20","v":"調定減：過年度：都祁"}]
[17,0,"月ヶ瀬"]
[18,1,"給水収益","給水未収金","給水収益",null,{"$f":"F29/1.1","v":0},{"$f":"F29-G29","v":0},{"$f":"\"定例調定：\"&$C$28&\"：隔月分\"","v":"定例調定：月ヶ瀬：隔月分"}]
[19,1,"給水収益","給水未収金","給水収益",null,{"$f":"F30/1.1","v":0},{"$f":"F30-G30","v":0},{"$f":"\"定例調定：\"&$C$28&\"：毎月分\"","v":"定例調定：月ヶ瀬：毎月分"}]
[20,1,"給水収益","給水未収金","給水収益",null,0,0,"臨時・仮設前受金精算"]
[21,1,"給水収益","給水未収金","給水収益",null,0,0,{"$f":"\"調定増：現年度：\"&$C$28","v":"調定増：現年度：月ヶ瀬"}]
[22,1,"過年度修正益","給水未収金","過年度修正益",null,0,0,{"$f":"\"調定増：過年度：\"&$C$28","v":"調定増：過年度：月ヶ瀬"}]
[23,1,"給水収益","給水収益","給水未収金",null,0,0,{"$f":"\"調定減：現年度：\"&$C$28","v":"調定減：現年度：月ヶ瀬"}]
[24,1,"過年度修正損","過年度修正損","給水未収金",null,0,0,{"$f":"\"調定減：過年度：\"&$C$28","v":"調定減：過年度：月ヶ瀬"}]
[25,0,"金額合計"]

{"sheet":"銀行手数料","index":2,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["ID","読込FLG","見出し１","見出し２","見出し３","見出し４","見出し５","見出し６"]
[1,9,"予算科目CD","010150-0000","水道事業費用","営業費用","業務費","手数料"]
[2,9,"摘要","口座振替手数料　令和2年度上半期（令和2年3月～令和2年8月振替分）526,285件*10円　単価契約"]
[3,0]
[4,10,"予算伝票始まり"]
[5,11,"負担行為番号","負担行為額","消費税CD","消費税率","税抜額","消費税額","債権者CD","債権者名称","債権者郵便番号","債権者住所"]
[6,1,4617,158147,1,10,143770,14377,"0100000918","(株)みずほ銀行奈良支店長","630-8228","奈良市上三条町１３－１"]
[7,1,4618,660110,1,10,600100,60010,"0100000908","(株)三菱UFJ銀行奈良支店長","630-8225","奈良市西御門町２７－１"]
[8,1,4619,453508,1,10,412280,41228,"0100000910","(株)みずほ三井住友銀行奈良支店長","630-8224","奈良市角振町３５"]
[9,1,4620,370623,1,10,336930,33693,"0100015806","(株)りそな銀行新奈良営業部営業第三部長","630-8122","奈良市三条本町１－２"]
[10,0]
[11,0]
[12,0]
[13,0]
[14,0]
[15,0]
[16,0]
[17,0]
[18,0]
[19,0]
[20,0]
[21,0]
[22,0]
[23,0]
[24,0]
[25,0]
[26,0]
[27,0]
[28,0]
[29,0]
[30,0,"金額合計",{"$f":"SUM(D7:D30)","v":1642388},null,null,{"$f":"SUM(G7:G30)","v":1493080},{"$f":"SUM(H7:H30)","v":149308}]
[31,19,"予算伝票終わり",null,null,null,null,null,null,null,""]
[999,999,"全伝票終わり"]

{"sheet":"上水入金","index":3,"n_rows":160,"n_cols":9,"rows_kept":160,"cut":false,"hidden":false,"merged":[]}
["ID","読込FLG","予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日"]
[1,20,"簿記伝票始まり",null,null,null,null,""]
[3,21,"簿記科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[2,22,"口座"]
[4,0,"都市部"]
[5,2,"110101-0100","151010-1000","152010-1000",94380298,null,{"$f":"\"水道料金：\"&$C$5","v":"水道料金：都市部"},"2020-11-18"]
[6,2,null,"151010-1000","335530-1000",67182693,null,{"$f":"\"公共下水料金：\"&$C$5","v":"公共下水料金：都市部"},"2020-11-18"]
[7,2,null,"151010-1000","335530-5000",543801,null,{"$f":"\"農業集落排水：\"&$C$5","v":"農業集落排水：都市部"},"2020-11-18"]
[8,0,"都祁"]
[9,2,"110101-0300","151010-1000","152010-1000",1322218,null,{"$f":"\"水道料金：\"&$C$9","v":"水道料金：都祁"},"2020-11-18"]
[10,0,"月ヶ瀬"]
[11,2,"110101-0500","151010-1000","152010-1000",134014,null,{"$f":"\"水道料金：\"&$C$11","v":"水道料金：月ヶ瀬"},"2020-11-18"]
[12,2,null,"151010-1000","335530-3000",41321,null,{"$f":"\"公共下水料金：\"&$C$11","v":"公共下水料金：月ヶ瀬"},"2020-11-18"]
[13,2,null,"151010-1000","335530-7000",77252,null,{"$f":"\"農業集落排水：\"&$C$11","v":"農業集落排水：月ヶ瀬"},"2020-11-18"]
[14,0,"都市部（下水のみ）"]
[15,2,null,"151010-1000","335530-2000",0,null,{"$f":"\"公共下水料金：\"&$C$15","v":"公共下水料金：都市部（下水のみ）"},"2020-11-18"]
[16,2,null,"151010-1000","335530-6000",0,null,{"$f":"\"農業集落排水：\"&$C$15","v":"農業集落排水：都市部（下水のみ）"},"2020-11-18"]
[17,0,"月ヶ瀬（下水のみ）"]
[18,2,null,"151010-1000","335530-4000",41321,null,{"$f":"\"公共下水料金：\"&$C$18","v":"公共下水料金：月ヶ瀬（下水のみ）"},"2020-11-18"]
[19,2,null,"151010-1000","335530-8000",77252,null,{"$f":"\"農業集落排水：\"&$C$18","v":"農業集落排水：月ヶ瀬（下水のみ）"},"2020-11-18"]
[20]
[21,0,"水道料金過誤納"]
[22,2,"都市部","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C23&\")\"","v":"水道料金過誤納(都市部)"},"2020-11-18"]
[23,2,"都祁","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C24&\")\"","v":"水道料金過誤納(都祁)"},"2020-11-18"]
[24,2,"月ヶ瀬","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C25&\")\"","v":"水道料金過誤納(月ヶ瀬)"},"2020-11-18"]
[25,0]
[26,0,"下水料金過誤納"]
[27,2,"都市部（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$C$27&C28","v":"下水料金過誤納都市部（下水のみ）"},"2020-11-18"]
[28,2,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$C$27&C29","v":"下水料金過誤納月ヶ瀬（下水のみ）"},"2020-11-18"]
[29,0]
[30,2,"証明・給水再開手数料","151010-1000","152010-6000",null,null,"証明・給水再開手数料","2020-11-18"]
[31,2,"臨時メータ精算","334010-1000","152010-1000",null,null,"臨時メータ精算","2020-11-18"]
[32,2,"仮設メータ精算","334010-2000","152010-1000",null,null,"仮設メータ精算","2020-11-18"]
[33,0]
[34,22,"郵政納付"]
[36,0,"都市部"]
[37,2,"110101-0100","151010-1000","152010-1000",94380298,null,{"$f":"\"水道料金：\"&$C$5","v":"水道料金：都市部"},"2020-11-18"]
[38,2,null,"151010-1000","335530-1000",67182693,null,{"$f":"\"公共下水料金：\"&$C$5","v":"公共下水料金：都市部"},"2020-11-18"]
[39,2,null,"151010-1000","335530-5000",543801,null,{"$f":"\"農業集落排水：\"&$C$5","v":"農業集落排水：都市部"},"2020-11-18"]
[40,0,"都祁"]
[41,2,"110101-0300","151010-1000","152010-1000",1322218,null,{"$f":"\"水道料金：\"&$C$9","v":"水道料金：都祁"},"2020-11-18"]
[42,0,"月ヶ瀬"]
[43,2,"110101-0500","151010-1000","152010-1000",134014,null,{"$f":"\"水道料金：\"&$C$11","v":"水道料金：月ヶ瀬"},"2020-11-18"]
[44,2,null,"151010-1000","335530-3000",41321,null,{"$f":"\"公共下水料金：\"&$C$11","v":"公共下水料金：月ヶ瀬"},"2020-11-18"]
[45,2,null,"151010-1000","335530-7000",77252,null,{"$f":"\"農業集落排水：\"&$C$11","v":"農業集落排水：月ヶ瀬"},"2020-11-18"]
[46,0,"都市部（下水のみ）"]
[47,2,null,"151010-1000","335530-2000",0,null,{"$f":"\"公共下水料金：\"&$C$15","v":"公共下水料金：都市部（下水のみ）"},"2020-11-18"]
[48,2,null,"151010-1000","335530-6000",0,null,{"$f":"\"農業集落排水：\"&$C$15","v":"農業集落排水：都市部（下水のみ）"},"2020-11-18"]
[49,0,"月ヶ瀬（下水のみ）"]
[50,2,null,"151010-1000","335530-4000",41321,null,{"$f":"\"公共下水料金：\"&$C$18","v":"公共下水料金：月ヶ瀬（下水のみ）"},"2020-11-18"]
[51,2,null,"151010-1000","335530-8000",77252,null,{"$f":"\"農業集落排水：\"&$C$18","v":"農業集落排水：月ヶ瀬（下水のみ）"},"2020-11-18"]
[52]
[53,0,"水道料金過誤納"]
[54,2,"都市部","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C54&\")\"","v":"水道料金過誤納(都市部)"},"2020-11-18"]
[55,2,"都祁","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C55&\")\"","v":"水道料金過誤納(都祁)"},"2020-11-18"]
[56,2,"月ヶ瀬","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C56&\")\"","v":"水道料金過誤納(月ヶ瀬)"},"2020-11-18"]
[57,0]
[58,0,"下水料金過誤納"]
[59,2,"都市部（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$C$27&C59","v":"下水料金過誤納都市部（下水のみ）"},"2020-11-18"]
[60,2,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$C$27&C60","v":"下水料金過誤納月ヶ瀬（下水のみ）"},"2020-11-18"]
[61,0]
[62,2,"証明・給水再開手数料","151010-1000","152010-6000",null,null,"証明・給水再開手数料","2020-11-18"]
[63,2,"臨時メータ精算","334010-1000","152010-1000",null,null,"臨時メータ精算","2020-11-18"]
[64,2,"仮設メータ精算","334010-2000","152010-1000",null,null,"仮設メータ精算","2020-11-18"]
[65,0]
[66,22,"銀行納付"]
[68,0,"都市部"]
[69,2,"110101-0100","151010-1000","152010-1000",94380298,null,{"$f":"\"水道料金：\"&$C$5","v":"水道料金：都市部"},"2020-11-18"]
[70,2,null,"151010-1000","335530-1000",67182693,null,{"$f":"\"公共下水料金：\"&$C$5","v":"公共下水料金：都市部"},"2020-11-18"]
[71,2,null,"151010-1000","335530-5000",543801,null,{"$f":"\"農業集落排水：\"&$C$5","v":"農業集落排水：都市部"},"2020-11-18"]
[72,0,"都祁"]
[73,2,"110101-0300","151010-1000","152010-1000",1322218,null,{"$f":"\"水道料金：\"&$C$9","v":"水道料金：都祁"},"2020-11-18"]
[74,0,"月ヶ瀬"]
[75,2,"110101-0500","151010-1000","152010-1000",134014,null,{"$f":"\"水道料金：\"&$C$11","v":"水道料金：月ヶ瀬"},"2020-11-18"]
[76,2,null,"151010-1000","335530-3000",41321,null,{"$f":"\"公共下水料金：\"&$C$11","v":"公共下水料金：月ヶ瀬"},"2020-11-18"]
[77,2,null,"151010-1000","335530-7000",77252,null,{"$f":"\"農業集落排水：\"&$C$11","v":"農業集落排水：月ヶ瀬"},"2020-11-18"]
[78,0,"都市部（下水のみ）"]
[79,2,null,"151010-1000","335530-2000",0,null,{"$f":"\"公共下水料金：\"&$C$15","v":"公共下水料金：都市部（下水のみ）"},"2020-11-18"]
[80,2,null,"151010-1000","335530-6000",0,null,{"$f":"\"農業集落排水：\"&$C$15","v":"農業集落排水：都市部（下水のみ）"},"2020-11-18"]
[81,0,"月ヶ瀬（下水のみ）"]
[82,2,null,"151010-1000","335530-4000",41321,null,{"$f":"\"公共下水料金：\"&$C$18","v":"公共下水料金：月ヶ瀬（下水のみ）"},"2020-11-18"]
[83,2,null,"151010-1000","335530-8000",77252,null,{"$f":"\"農業集落排水：\"&$C$18","v":"農業集落排水：月ヶ瀬（下水のみ）"},"2020-11-18"]
[84]
[85,0,"水道料金過誤納"]
[86,2,"都市部","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C85&\")\"","v":"水道料金過誤納(都市部)"},"2020-11-18"]
[87,2,"都祁","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C86&\")\"","v":"水道料金過誤納(都祁)"},"2020-11-18"]
[88,2,"月ヶ瀬","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C87&\")\"","v":"水道料金過誤納(月ヶ瀬)"},"2020-11-18"]
[89,0]
[90,0,"下水料金過誤納"]
[91,2,"都市部（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$C$27&C90","v":"下水料金過誤納都市部（下水のみ）"},"2020-11-18"]
[92,2,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$C$27&C91","v":"下水料金過誤納月ヶ瀬（下水のみ）"},"2020-11-18"]
[93,0]
[94,2,"証明・給水再開手数料","151010-1000","152010-6000",null,null,"証明・給水再開手数料","2020-11-18"]
[95,2,"臨時メータ精算","334010-1000","152010-1000",null,null,"臨時メータ精算","2020-11-18"]
[96,2,"仮設メータ精算","334010-2000","152010-1000",null,null,"仮設メータ精算","2020-11-18"]
[97,0]
[98,22,"コンビニ"]
[100,0,"都市部"]
[101,2,"110101-0100","151010-1000","152010-1000",94380298,null,{"$f":"\"水道料金：\"&$C$5","v":"水道料金：都市部"},"2020-11-18"]
[102,2,null,"151010-1000","335530-1000",67182693,null,{"$f":"\"公共下水料金：\"&$C$5","v":"公共下水料金：都市部"},"2020-11-18"]
[103,2,null,"151010-1000","335530-5000",543801,null,{"$f":"\"農業集落排水：\"&$C$5","v":"農業集落排水：都市部"},"2020-11-18"]
[104,0,"都祁"]
[105,2,"110101-0300","151010-1000","152010-1000",1322218,null,{"$f":"\"水道料金：\"&$C$9","v":"水道料金：都祁"},"2020-11-18"]
[106,0,"月ヶ瀬"]
[107,2,"110101-0500","151010-1000","152010-1000",134014,null,{"$f":"\"水道料金：\"&$C$11","v":"水道料金：月ヶ瀬"},"2020-11-18"]
[108,2,null,"151010-1000","335530-3000",41321,null,{"$f":"\"公共下水料金：\"&$C$11","v":"公共下水料金：月ヶ瀬"},"2020-11-18"]
[109,2,null,"151010-1000","335530-7000",77252,null,{"$f":"\"農業集落排水：\"&$C$11","v":"農業集落排水：月ヶ瀬"},"2020-11-18"]
[110,0,"都市部（下水のみ）"]
[111,2,null,"151010-1000","335530-2000",0,null,{"$f":"\"公共下水料金：\"&$C$15","v":"公共下水料金：都市部（下水のみ）"},"2020-11-18"]
[112,2,null,"151010-1000","335530-6000",0,null,{"$f":"\"農業集落排水：\"&$C$15","v":"農業集落排水：都市部（下水のみ）"},"2020-11-18"]
[113,0,"月ヶ瀬（下水のみ）"]
[114,2,null,"151010-1000","335530-4000",41321,null,{"$f":"\"公共下水料金：\"&$C$18","v":"公共下水料金：月ヶ瀬（下水のみ）"},"2020-11-18"]
[115,2,null,"151010-1000","335530-8000",77252,null,{"$f":"\"農業集落排水：\"&$C$18","v":"農業集落排水：月ヶ瀬（下水のみ）"},"2020-11-18"]
[116]
[117,0,"水道料金過誤納"]
[118,2,"都市部","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C116&\")\"","v":"水道料金過誤納(都市部)"},"2020-11-18"]
[119,2,"都祁","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C117&\")\"","v":"水道料金過誤納(都祁)"},"2020-11-18"]
[120,2,"月ヶ瀬","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C118&\")\"","v":"水道料金過誤納(月ヶ瀬)"},"2020-11-18"]
[121,0]
[122,0,"下水料金過誤納"]
[123,2,"都市部（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$C$27&C121","v":"下水料金過誤納都市部（下水のみ）"},"2020-11-18"]
[124,2,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$C$27&C122","v":"下水料金過誤納月ヶ瀬（下水のみ）"},"2020-11-18"]
[125,0]
[126,2,"証明・給水再開手数料","151010-1000","152010-6000",null,null,"証明・給水再開手数料","2020-11-18"]
[127,2,"臨時メータ精算","334010-1000","152010-1000",null,null,"臨時メータ精算","2020-11-18"]
[128,2,"仮設メータ精算","334010-2000","152010-1000",null,null,"仮設メータ精算","2020-11-18"]
[129,0]
[130,22,"窓口"]
[132,0,"都市部"]
[133,2,"110101-0100","151010-1000","152010-1000",94380298,null,{"$f":"\"水道料金：\"&$C$5","v":"水道料金：都市部"},"2020-11-18"]
[134,2,null,"151010-1000","335530-1000",67182693,null,{"$f":"\"公共下水料金：\"&$C$5","v":"公共下水料金：都市部"},"2020-11-18"]
[135,2,null,"151010-1000","335530-5000",543801,null,{"$f":"\"農業集落排水：\"&$C$5","v":"農業集落排水：都市部"},"2020-11-18"]
[136,0,"都祁"]
[137,2,"110101-0300","151010-1000","152010-1000",1322218,null,{"$f":"\"水道料金：\"&$C$9","v":"水道料金：都祁"},"2020-11-18"]
[138,0,"月ヶ瀬"]
[139,2,"110101-0500","151010-1000","152010-1000",134014,null,{"$f":"\"水道料金：\"&$C$11","v":"水道料金：月ヶ瀬"},"2020-11-18"]
[140,2,null,"151010-1000","335530-3000",41321,null,{"$f":"\"公共下水料金：\"&$C$11","v":"公共下水料金：月ヶ瀬"},"2020-11-18"]
[141,2,null,"151010-1000","335530-7000",77252,null,{"$f":"\"農業集落排水：\"&$C$11","v":"農業集落排水：月ヶ瀬"},"2020-11-18"]
[142,0,"都市部（下水のみ）"]
[143,2,null,"151010-1000","335530-2000",0,null,{"$f":"\"公共下水料金：\"&$C$15","v":"公共下水料金：都市部（下水のみ）"},"2020-11-18"]
[144,2,null,"151010-1000","335530-6000",0,null,{"$f":"\"農業集落排水：\"&$C$15","v":"農業集落排水：都市部（下水のみ）"},"2020-11-18"]
[145,0,"月ヶ瀬（下水のみ）"]
[146,2,null,"151010-1000","335530-4000",41321,null,{"$f":"\"公共下水料金：\"&$C$18","v":"公共下水料金：月ヶ瀬（下水のみ）"},"2020-11-18"]
[147,2,null,"151010-1000","335530-8000",77252,null,{"$f":"\"農業集落排水：\"&$C$18","v":"農業集落排水：月ヶ瀬（下水のみ）"},"2020-11-18"]
[148]
[149,0,"水道料金過誤納"]
[150,2,"都市部","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C147&\")\"","v":"水道料金過誤納(都市部)"},"2020-11-18"]
[151,2,"都祁","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C148&\")\"","v":"水道料金過誤納(都祁)"},"2020-11-18"]
[152,2,"月ヶ瀬","151010-1000","335550-1000",null,null,{"$f":"$C$22&\"(\"&C149&\")\"","v":"水道料金過誤納(月ヶ瀬)"},"2020-11-18"]
[153,0]
[154,0,"下水料金過誤納"]
[155,2,"都市部（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$C$27&C152","v":"下水料金過誤納都市部（下水のみ）"},"2020-11-18"]
[156,2,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$C$27&C153","v":"下水料金過誤納月ヶ瀬（下水のみ）"},"2020-11-18"]
[157,0]
[158,2,"証明・給水再開手数料","151010-1000","152010-6000",null,null,"証明・給水再開手数料","2020-11-18"]
[159,2,"臨時メータ精算","334010-1000","152010-1000",null,null,"臨時メータ精算","2020-11-18"]
[160,2,"仮設メータ精算","334010-2000","152010-1000",null,null,"仮設メータ精算","2020-11-18"]
[161,0]
[162,29,"簿記伝票終わり"]
[999,999,"全伝票終わり"]