{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["伝票上水調定","伝票下水調定","伝票上水入金","入力様式・調定","入力様式・上水入金下水調定","ブランク伝票"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[0,"都市部"]
[11,"110101-0100","152010-1000","611010-1000",549393689.090909,null,"定例調定：都市部：隔月分","2020-11-18",1,10]
[11,"110101-0100","152010-1000","611010-1000",55523149.999999993,null,"定例調定：都市部：毎月分","2020-11-18",1,10]
[11,"110101-0100","152010-1000","611010-1000",14419.090909090908,null,"調定増：現年度：都市部","2020-11-18",1,10]
[11,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度：都市部","2020-11-18",1,10]
[11,"110101-0100","611010-1000","152010-1000",null,28509.090909090908,"調定減：現年度：都市部","2020-11-18",1,10]
[11,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度：都市部","2020-11-18",1,10]
[0,"都祁"]
[11,"110101-0300","152010-1000","611010-2000",10208051.818181816,null,"定例調定：都祁：隔月分","2020-11-18",1,10]
[11,"110101-0300","152010-1000","611010-2000",0,null,"定例調定：都祁：毎月分","2020-11-18",1,10]
[11,"110101-0300","152010-1000","611010-2000",0,null,"調定増：現年度：都祁","2020-11-18",1,10]
[11,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度：都祁","2020-11-18",1,10]
[11,"110101-0300","611010-2000","152010-1000",null,0,"調定減：現年度：都祁","2020-11-18",1,10]
[11,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度：都祁","2020-11-18",1,10]
[0,"月ヶ瀬"]
[11,"110101-0500","152010-1000","611010-3000",0,null,"定例調定：月ヶ瀬：隔月分","2020-11-18",1,10]
[11,"110101-0500","152010-1000","611010-3000",0,null,"定例調定：月ヶ瀬：毎月分","2020-11-18",1,10]
[11,"110101-0500","152010-1000","611010-3000",0,null,"調定増：現年度：月ヶ瀬","2020-11-18",1,10]
[11,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度：月ヶ瀬","2020-11-18",1,10]
[11,"110101-0500","611010-3000","152010-1000",null,0,"調定減：現年度：月ヶ瀬","2020-11-18",1,10]
[11,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度：月ヶ瀬","2020-11-18",1,10]
[0,"金額合計"]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[0,"都市部"]
[21,{"$f":"B4","v":"110101-0100"},{"$f":"C4","v":"152010-1000"},{"$f":"D4","v":"611010-1000"},549393689.090909,549393689.090909,"定例調定：都市部：隔月分","2020-11-18",99]
[21,null,"152010-1000","336010-1000",54939368.909090996,54939368.909090996,null,"2020-11-18",99]
[21,{"$f":"B5","v":"110101-0100"},{"$f":"C5","v":"152010-1000"},{"$f":"D5","v":"611010-1000"},55523149.999999993,55523149.999999993,"定例調定：都市部：毎月分","2020-11-18",99]
[21,null,"152010-1000","336010-1000",5552315.0000000075,5552315.0000000075,null,"2020-11-18",99]
[21,{"$f":"B6","v":"110101-0100"},{"$f":"C6","v":"152010-1000"},{"$f":"D6","v":"611010-1000"},14419.090909090908,14419.090909090908,"調定増：現年度：都市部","2020-11-18",99]
[21,null,"152010-1000","336010-1000",1441.9090909090919,1441.9090909090919,null,"2020-11-18",99]
[21,{"$f":"B7","v":"110503-0100"},{"$f":"C7","v":"152010-1000"},{"$f":"D7","v":"613020-1000"},0,0,"調定増：過年度：都市部","2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B8","v":"110101-0100"},{"$f":"C8","v":"611010-1000"},{"$f":"D8","v":"152010-1000"},28509.090909090908,28509.090909090908,"調定減：現年度：都市部","2020-11-18",99]
[21,null,"336010-1000","152010-1000",2850.9090909090919,2850.9090909090919,null,"2020-11-18",99]
[21,{"$f":"B9","v":"210507-0100"},{"$f":"C9","v":"713040-1000"},{"$f":"D9","v":"152010-1000"},0,0,"調定減：過年度：都市部","2020-11-18",99]
[21,null,"158030-1000","152010-1000",0,0,null,"2020-11-18",99]
[0,"都祁"]
[21,{"$f":"B11","v":"110101-0300"},{"$f":"C11","v":"152010-1000"},{"$f":"D11","v":"611010-2000"},10208051.818181816,10208051.818181816,"定例調定：都祁：隔月分","2020-11-18",99]
[21,null,"152010-1000","336010-1000",1020805.1818181835,1020805.1818181835,null,"2020-11-18",99]
[21,{"$f":"B12","v":"110101-0300"},{"$f":"C12","v":"152010-1000"},{"$f":"D12","v":"611010-2000"},0,0,"定例調定：都祁：毎月分","2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B13","v":"110101-0300"},{"$f":"C13","v":"152010-1000"},{"$f":"D13","v":"611010-2000"},0,0,"調定増：現年度：都祁","2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B14","v":"110503-0100"},{"$f":"C14","v":"152010-1000"},{"$f":"D14","v":"613020-1000"},0,0,"調定増：過年度：都祁","2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B15","v":"110101-0300"},{"$f":"C15","v":"611010-2000"},{"$f":"D15","v":"152010-1000"},0,0,"調定減：現年度：都祁","2020-11-18",99]
[21,null,"336010-1000","152010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B16","v":"210507-0100"},{"$f":"C16","v":"713040-1000"},{"$f":"D16","v":"152010-1000"},0,0,"調定減：過年度：都祁","2020-11-18",99]
[21,null,"158030-1000","152010-1000",0,0,null,"2020-11-18",99]
[0,"月ヶ瀬"]
[21,{"$f":"B18","v":"110101-0500"},{"$f":"C18","v":"152010-1000"},{"$f":"D18","v":"611010-3000"},0,0,"定例調定：月ヶ瀬：隔月分","2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B19","v":"110101-0500"},"152010-1000",{"$f":"D19","v":"611010-3000"},0,0,"定例調定：月ヶ瀬：毎月分","2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B20","v":"110101-0500"},"152010-1000","611010-3000",0,0,"調定増：現年度：月ヶ瀬","2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B21","v":"110503-0100"},"152010-1000","613020-1000",0,0,"調定増：過年度：月ヶ瀬","2020-11-18",99]
[21,null,"152010-1000","336010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B22","v":"110101-0500"},"611010-3000","152010-1000",0,0,"調定減：現年度：月ヶ瀬","2020-11-18",99]
[21,null,"336010-1000","152010-1000",0,0,null,"2020-11-18",99]
[21,{"$f":"B23","v":"210507-0100"},"713040-1000","152010-1000",0,0,"調定減：過年度：月ヶ瀬","2020-11-18",99]
[21,null,"158030-1000","152010-1000",0,0,null,"2020-11-18",99]
[0,"金額合計"]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"伝票下水調定","index":1,"n_rows":89,"n_cols":11,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[0,"公共下水料金：都市部（上下水道区域）"]
[11,"110101-0100","152010-1000","611010-1000",549393689.090909,null,"定例調定：隔月分","2020-11-18",1,10]
[11,"110101-0100","152010-1000","611010-1000",55523149.999999993,null,"定例調定：毎月分","2020-11-18",1,10]
[11,"110101-0100","152010-1000","611010-1000",14419.090909090908,null,"調定増：現年度","2020-11-18",1,10]
[11,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度","2020-11-18",1,10]
[11,"110101-0100","611010-1000","152010-1000",null,28509.090909090908,"調定減：現年度","2020-11-18",1,10]
[11,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度","2020-11-18",1,10]
[0,"公共下水料金：都市部（下水のみ区域）"]
[11,"110101-0100","152010-1000","611010-1000",549393689.090909,null,"定例調定：隔月分","2020-11-18",1,10]
[11,"110101-0100","152010-1000","611010-1000",55523149.999999993,null,"定例調定：毎月分","2020-11-18",1,10]
[11,"110101-0100","152010-1000","611010-1000",14419.090909090908,null,"調定増：現年度","2020-11-18",1,10]
[11,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度","2020-11-18",1,10]
[11,"110101-0100","611010-1000","152010-1000",null,28509.090909090908,"調定減：現年度","2020-11-18",1,10]
[11,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度","2020-11-18",1,10]
[]
[0,"農業集落排水：月ヶ瀬（上下水道区域）"]
[11,"110101-0300","152010-1000","611010-2000",0,null,"定例調定：隔月分","2020-11-18",1,10]
[11,"110101-0300","152010-1000","611010-2000",0,null,"定例調定：毎月分","2020-11-18",1,10]
[11,"110101-0300","152010-1000","611010-2000",0,null,"調定増：現年度","2020-11-18",1,10]
[11,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度","2020-11-18",1,10]
[11,"110101-0300","611010-3000","152010-1000",null,0,"調定減：現年度","2020-11-18",1,10]
[11,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度","2020-11-18",1,10]
[0,"農業集落排水：月ヶ瀬（下水のみ区域）"]
[11,"110101-0300","152010-1000","611010-2000",0,null,"定例調定：月ヶ瀬：隔月分","2020-11-18",1,10]
[11,"110101-0300","152010-1000","611010-2000",0,null,"定例調定：月ヶ瀬：毎月分","2020-11-18",1,10]
[11,"110101-0300","152010-1000","611010-2000",0,null,"調定増：現年度：月ヶ瀬","2020-11-18",1,10]
[11,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度：月ヶ瀬","2020-11-18",1,10]
[11,"110101-0300","611010-3000","152010-1000",null,0,"調定減：現年度：月ヶ瀬","2020-11-18",1,10]
[11,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度：月ヶ瀬","2020-11-18",1,10]
[0,"金額合計"]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[0,"公共下水料金：都市部（上下水道区域）"]
[21,"110101-0100","152010-1000","611010-1000",549393689.090909,null,"定例調定：隔月分","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0100","152010-1000","611010-1000",55523149.999999993,null,"定例調定：毎月分","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0100","152010-1000","611010-1000",14419.090909090908,null,"調定増：現年度","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0100","611010-1000","152010-1000",null,28509.090909090908,"調定減：現年度","2020-11-18",1,10]
[21,null,"336010-1000","152010-1000"]
[21,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度","2020-11-18",1,10]
[21,null,"158030-1000","152010-1000"]
[0,"公共下水料金：都市部（下水のみ区域）"]
[21,"110101-0100","152010-1000","611010-1000",549393689.090909,null,"定例調定：隔月分","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0100","152010-1000","611010-1000",55523149.999999993,null,"定例調定：毎月分","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0100","152010-1000","611010-1000",14419.090909090908,null,"調定増：現年度","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0100","611010-1000","152010-1000",null,28509.090909090908,"調定減：現年度","2020-11-18",1,10]
[21,null,"336010-1000","152010-1000"]
[21,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度","2020-11-18",1,10]
[21,null,"158030-1000","152010-1000"]
[0,"農業集落排水：月ヶ瀬（上下水道区域）"]
[21,"110101-0500","152010-1000","611010-2000",0,null,"定例調定：隔月分","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0500","152010-1000","611010-3000",0,null,"定例調定：毎月分","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0500","152010-1000","611010-3000",0,null,"調定増：現年度","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0500","611010-3000","152010-1000",null,0,"調定減：現年度","2020-11-18",1,10]
[21,null,"336010-1000","152010-1000"]
[21,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度","2020-11-18",1,10]
[21,null,"158030-1000","152010-1000"]
[0,"農業集落排水：月ヶ瀬（下水のみ区域）"]
[21,"110101-0500","152010-1000","611010-3000",0,null,"定例調定：月ヶ瀬：隔月分","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0500","152010-1000","611010-2000",0,null,"定例調定：月ヶ瀬：毎月分","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0500","152010-1000","611010-2000",0,null,"調定増：現年度：月ヶ瀬","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110503-0100","152010-1000","613020-1000",0,null,"調定増：過年度：月ヶ瀬","2020-11-18",1,10]
[21,null,"152010-1000","336010-1000"]
[21,"110101-0500","611010-3000","152010-1000",null,0,"調定減：現年度：月ヶ瀬","2020-11-18",1,10]
[21,null,"336010-1000","152010-1000"]
[21,"210507-0100","713040-1000","152010-1000",0,null,"調定減：過年度：月ヶ瀬","2020-11-18",1,10]
[21,null,"158030-1000","152010-1000"]
[0,"金額合計"]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"伝票上水入金","index":2,"n_rows":140,"n_cols":9,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
["読込FLG"]
[20,"簿記伝票始まり",null,null,null,null,""]
[21,"簿記科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[0,"口座"]
[0,"都市部"]
[21,"110101-0100","151010-1000","152010-1000",94380298,null,{"$f":"\"水道料金：\"&$B$5","v":"水道料金：都市部"},"2020-11-18",99]
[21,null,"151010-1000","335530-1000",67182693,null,{"$f":"\"公共下水料金：\"&$B$5","v":"公共下水料金：都市部"},"2020-11-18",99]
[21,null,"151010-1000","335530-5000",543801,null,{"$f":"\"農業集落排水：\"&$B$5","v":"農業集落排水：都市部"},"2020-11-18",99]
[0,"都祁",null,null,null,null,null,null,99]
[21,"110101-0300","151010-1000","152010-1000",1322218,null,{"$f":"\"水道料金：\"&$B$9","v":"水道料金：都祁"},"2020-11-18",99]
[0,"月ヶ瀬",null,null,null,null,null,null,99]
[21,"110101-0500","151010-1000","152010-1000",134014,null,{"$f":"\"水道料金：\"&$B$11","v":"水道料金：月ヶ瀬"},"2020-11-18",99]
[21,null,"151010-1000","335530-3000",41321,null,{"$f":"\"公共下水料金：\"&$B$11","v":"公共下水料金：月ヶ瀬"},"2020-11-18",99]
[21,null,"151010-1000","335530-7000",77252,null,{"$f":"\"農業集落排水：\"&$B$11","v":"農業集落排水：月ヶ瀬"},"2020-11-18",99]
[0,"都市部（下水のみ）",null,null,null,null,null,null,99]
[21,null,"151010-1000","335530-2000",0,null,{"$f":"\"公共下水料金：\"&$B$15","v":"公共下水料金：都市部（下水のみ）"},"2020-11-18",99]
[21,null,"151010-1000","335530-6000",0,null,{"$f":"\"農業集落排水：\"&$B$15","v":"農業集落排水：都市部（下水のみ）"},"2020-11-18",99]
[0,"月ヶ瀬（下水のみ）",null,null,null,null,null,null,99]
[21,null,"151010-1000","335530-4000",41321,null,{"$f":"\"公共下水料金：\"&$B$18","v":"公共下水料金：月ヶ瀬（下水のみ）"},"2020-11-18",99]
[21,null,"151010-1000","335530-8000",77252,null,{"$f":"\"農業集落排水：\"&$B$18","v":"農業集落排水：月ヶ瀬（下水のみ）"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"水道料金過誤納",null,null,null,null,null,null,99]
[21,"都市部","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B23&\")\"","v":"水道料金過誤納(都市部)"},"2020-11-18",99]
[21,"都祁","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B24&\")\"","v":"水道料金過誤納(都祁)"},"2020-11-18",99]
[21,"月ヶ瀬","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B25&\")\"","v":"水道料金過誤納(月ヶ瀬)"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"下水料金過誤納",null,null,null,null,null,null,99]
[21,"都市部（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$B$27&B28","v":"下水料金過誤納都市部（下水のみ）"},"2020-11-18",99]
[21,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$B$27&B29","v":"下水料金過誤納月ヶ瀬（下水のみ）"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"郵政納付",null,null,null,null,null,null,99]
[0,"都市部",null,null,null,null,null,null,99]
[21,"110101-0100","151010-1000","152010-1000",94380298,null,{"$f":"\"水道料金：\"&$B$5","v":"水道料金：都市部"},"2020-11-18",99]
[21,null,"151010-1000","335530-1000",67182693,null,{"$f":"\"公共下水料金：\"&$B$5","v":"公共下水料金：都市部"},"2020-11-18",99]
[21,null,"151010-1000","335530-5000",543801,null,{"$f":"\"農業集落排水：\"&$B$5","v":"農業集落排水：都市部"},"2020-11-18",99]
[0,"都祁",null,null,null,null,null,null,99]
[21,"110101-0300","151010-1000","152010-1000",1322218,null,{"$f":"\"水道料金：\"&$B$9","v":"水道料金：都祁"},"2020-11-18",99]
[0,"月ヶ瀬",null,null,null,null,null,null,99]
[21,"110101-0500","151010-1000","152010-1000",134014,null,{"$f":"\"水道料金：\"&$B$11","v":"水道料金：月ヶ瀬"},"2020-11-18",99]
[21,null,"151010-1000","335530-3000",41321,null,{"$f":"\"公共下水料金：\"&$B$11","v":"公共下水料金：月ヶ瀬"},"2020-11-18",99]
[21,null,"151010-1000","335530-7000",77252,null,{"$f":"\"農業集落排水：\"&$B$11","v":"農業集落排水：月ヶ瀬"},"2020-11-18",99]
[0,"都市部（下水のみ）",null,null,null,null,null,null,99]
[21,null,"151010-1000","335530-2000",0,null,{"$f":"\"公共下水料金：\"&$B$15","v":"公共下水料金：都市部（下水のみ）"},"2020-11-18",99]
[21,null,"151010-1000","335530-6000",0,null,{"$f":"\"農業集落排水：\"&$B$15","v":"農業集落排水：都市部（下水のみ）"},"2020-11-18",99]
[0,"月ヶ瀬（下水のみ）",null,null,null,null,null,null,99]
[21,null,"151010-1000","335530-4000",41321,null,{"$f":"\"公共下水料金：\"&$B$18","v":"公共下水料金：月ヶ瀬（下水のみ）"},"2020-11-18",99]
[21,null,"151010-1000","335530-8000",77252,null,{"$f":"\"農業集落排水：\"&$B$18","v":"農業集落排水：月ヶ瀬（下水のみ）"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"水道料金過誤納",null,null,null,null,null,null,99]
[21,"都市部","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B50&\")\"","v":"水道料金過誤納(都市部)"},"2020-11-18",99]
[21,"都祁","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B51&\")\"","v":"水道料金過誤納(都祁)"},"2020-11-18",99]
[21,"月ヶ瀬","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B52&\")\"","v":"水道料金過誤納(月ヶ瀬)"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"下水料金過誤納",null,null,null,null,null,null,99]
[21,"都市部（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$B$27&B55","v":"下水料金過誤納都市部（下水のみ）"},"2020-11-18",99]
[21,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$B$27&B56","v":"下水料金過誤納月ヶ瀬（下水のみ）"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"銀行納付",null,null,null,null,null,null,99]
[0,"都市部",null,null,null,null,null,null,99]
[21,"110101-0100","151010-1000","152010-1000",94380298,null,{"$f":"\"水道料金：\"&$B$5","v":"水道料金：都市部"},"2020-11-18",99]
[21,null,"151010-1000","335530-1000",67182693,null,{"$f":"\"公共下水料金：\"&$B$5","v":"公共下水料金：都市部"},"2020-11-18",99]
[21,null,"151010-1000","335530-5000",543801,null,{"$f":"\"農業集落排水：\"&$B$5","v":"農業集落排水：都市部"},"2020-11-18",99]
[0,"都祁",null,null,null,null,null,null,99]
[21,"110101-0300","151010-1000","152010-1000",1322218,null,{"$f":"\"水道料金：\"&$B$9","v":"水道料金：都祁"},"2020-11-18",99]
[0,"月ヶ瀬",null,null,null,null,null,null,99]
[21,"110101-0500","151010-1000","152010-1000",134014,null,{"$f":"\"水道料金：\"&$B$11","v":"水道料金：月ヶ瀬"},"2020-11-18",99]
[21,null,"151010-1000","335530-3000",41321,null,{"$f":"\"公共下水料金：\"&$B$11","v":"公共下水料金：月ヶ瀬"},"2020-11-18",99]
[21,null,"151010-1000","335530-7000",77252,null,{"$f":"\"農業集落排水：\"&$B$11","v":"農業集落排水：月ヶ瀬"},"2020-11-18",99]
[0,"都市部（下水のみ）",null,null,null,null,null,null,99]
[21,null,"151010-1000","335530-2000",0,null,{"$f":"\"公共下水料金：\"&$B$15","v":"公共下水料金：都市部（下水のみ）"},"2020-11-18",99]
[21,null,"151010-1000","335530-6000",0,null,{"$f":"\"農業集落排水：\"&$B$15","v":"農業集落排水：都市部（下水のみ）"},"2020-11-18",99]
[0,"月ヶ瀬（下水のみ）",null,null,null,null,null,null,99]
[21,null,"151010-1000","335530-4000",41321,null,{"$f":"\"公共下水料金：\"&$B$18","v":"公共下水料金：月ヶ瀬（下水のみ）"},"2020-11-18",99]
[21,null,"151010-1000","335530-8000",77252,null,{"$f":"\"農業集落排水：\"&$B$18","v":"農業集落排水：月ヶ瀬（下水のみ）"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"水道料金過誤納",null,null,null,null,null,null,99]
[21,"都市部","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B77&\")\"","v":"水道料金過誤納(都市部)"},"2020-11-18",99]
[21,"都祁","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B78&\")\"","v":"水道料金過誤納(都祁)"},"2020-11-18",99]
[21,"月ヶ瀬","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B79&\")\"","v":"水道料金過誤納(月ヶ瀬)"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"下水料金過誤納",null,null,null,null,null,null,99]
[21,"都市部（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$B$27&B82","v":"下水料金過誤納都市部（下水のみ）"},"2020-11-18",99]
[21,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$B$27&B83","v":"下水料金過誤納月ヶ瀬（下水のみ）"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[21,"コンビニ",null,null,null,null,null,null,99]
[0,"都市部",null,null,null,null,null,null,99]
[21,"110101-0100","151010-1000","152010-1000",94380298,null,{"$f":"\"水道料金：\"&$B$5","v":"水道料金：都市部"},"2020-11-18",99]
[21,null,"151010-1000","335530-1000",67182693,null,{"$f":"\"公共下水料金：\"&$B$5","v":"公共下水料金：都市部"},"2020-11-18",99]
[21,null,"151010-1000","335530-5000",543801,null,{"$f":"\"農業集落排水：\"&$B$5","v":"農業集落排水：都市部"},"2020-11-18",99]
[0,"都祁",null,null,null,null,null,null,99]
[21,"110101-0300","151010-1000","152010-1000",1322218,null,{"$f":"\"水道料金：\"&$B$9","v":"水道料金：都祁"},"2020-11-18",99]
[0,"月ヶ瀬",null,null,null,null,null,null,99]
[21,"110101-0500","151010-1000","152010-1000",134014,null,{"$f":"\"水道料金：\"&$B$11","v":"水道料金：月ヶ瀬"},"2020-11-18",99]
[21,null,"151010-1000","335530-3000",41321,null,{"$f":"\"公共下水料金：\"&$B$11","v":"公共下水料金：月ヶ瀬"},"2020-11-18",99]
[21,null,"151010-1000","335530-7000",77252,null,{"$f":"\"農業集落排水：\"&$B$11","v":"農業集落排水：月ヶ瀬"},"2020-11-18",99]
[0,"都市部（下水のみ）",null,null,null,null,null,null,99]
[21,null,"151010-1000","335530-2000",0,null,{"$f":"\"公共下水料金：\"&$B$15","v":"公共下水料金：都市部（下水のみ）"},"2020-11-18",99]
[21,null,"151010-1000","335530-6000",0,null,{"$f":"\"農業集落排水：\"&$B$15","v":"農業集落排水：都市部（下水のみ）"},"2020-11-18",99]
[0,"月ヶ瀬（下水のみ）",null,null,null,null,null,null,99]
[21,null,"151010-1000","335530-4000",41321,null,{"$f":"\"公共下水料金：\"&$B$18","v":"公共下水料金：月ヶ瀬（下水のみ）"},"2020-11-18",99]
[21,null,"151010-1000","335530-8000",77252,null,{"$f":"\"農業集落排水：\"&$B$18","v":"農業集落排水：月ヶ瀬（下水のみ）"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"水道料金過誤納",null,null,null,null,null,null,99]
[21,"都市部","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B104&\")\"","v":"水道料金過誤納(都市部)"},"2020-11-18",99]
[21,"都祁","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B105&\")\"","v":"水道料金過誤納(都祁)"},"2020-11-18",99]
[21,"月ヶ瀬","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B106&\")\"","v":"水道料金過誤納(月ヶ瀬)"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"下水料金過誤納",null,null,null,null,null,null,99]
[21,"都市部（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$B$27&B109","v":"下水料金過誤納都市部（下水のみ）"},"2020-11-18",99]
[21,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$B$27&B110","v":"下水料金過誤納月ヶ瀬（下水のみ）"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[21,"窓口",null,null,null,null,null,null,99]
[0,"都市部",null,null,null,null,null,null,99]
[21,"110101-0100","151010-1000","152010-1000",94380298,null,{"$f":"\"水道料金：\"&$B$5","v":"水道料金：都市部"},"2020-11-18",99]
[21,null,"151010-1000","335530-1000",67182693,null,{"$f":"\"公共下水料金：\"&$B$5","v":"公共下水料金：都市部"},"2020-11-18",99]
[21,null,"151010-1000","335530-5000",543801,null,{"$f":"\"農業集落排水：\"&$B$5","v":"農業集落排水：都市部"},"2020-11-18",99]
[0,"都祁",null,null,null,null,null,null,99]
[21,"110101-0300","151010-1000","152010-1000",1322218,null,{"$f":"\"水道料金：\"&$B$9","v":"水道料金：都祁"},"2020-11-18",99]
[0,"月ヶ瀬",null,null,null,null,null,null,99]
[21,"110101-0500","151010-1000","152010-1000",134014,null,{"$f":"\"水道料金：\"&$B$11","v":"水道料金：月ヶ瀬"},"2020-11-18",99]
[21,null,"151010-1000","335530-3000",41321,null,{"$f":"\"公共下水料金：\"&$B$11","v":"公共下水料金：月ヶ瀬"},"2020-11-18",99]
[21,null,"151010-1000","335530-7000",77252,null,{"$f":"\"農業集落排水：\"&$B$11","v":"農業集落排水：月ヶ瀬"},"2020-11-18",99]
[0,"都市部（下水のみ）",null,null,null,null,null,null,99]
[21,null,"151010-1000","335530-2000",0,null,{"$f":"\"公共下水料金：\"&$B$15","v":"公共下水料金：都市部（下水のみ）"},"2020-11-18",99]
[21,null,"151010-1000","335530-6000",0,null,{"$f":"\"農業集落排水：\"&$B$15","v":"農業集落排水：都市部（下水のみ）"},"2020-11-18",99]
[0,"月ヶ瀬（下水のみ）",null,null,null,null,null,null,99]
[21,null,"151010-1000","335530-4000",41321,null,{"$f":"\"公共下水料金：\"&$B$18","v":"公共下水料金：月ヶ瀬（下水のみ）"},"2020-11-18",99]
[21,null,"151010-1000","335530-8000",77252,null,{"$f":"\"農業集落排水：\"&$B$18","v":"農業集落排水：月ヶ瀬（下水のみ）"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"水道料金過誤納",null,null,null,null,null,null,99]
[21,"都市部","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B131&\")\"","v":"水道料金過誤納(都市部)"},"2020-11-18",99]
[21,"都祁","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B132&\")\"","v":"水道料金過誤納(都祁)"},"2020-11-18",99]
[21,"月ヶ瀬","151010-1000","335550-1000",null,null,{"$f":"$B$22&\"(\"&B133&\")\"","v":"水道料金過誤納(月ヶ瀬)"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[0,"下水料金過誤納",null,null,null,null,null,null,99]
[21,"都市部（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$B$27&B136","v":"下水料金過誤納都市部（下水のみ）"},"2020-11-18",99]
[21,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,{"$f":"$B$27&B137","v":"下水料金過誤納月ヶ瀬（下水のみ）"},"2020-11-18",99]
[0,null,null,null,null,null,null,null,99]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"入力様式・調定","index":3,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["項目","発行日"]
["発行日","2020-01-01"]
[null,"予算科目CD","借方科目CD","貸方科目CD","消費税CD","消費税率"]
["都市部","110101-0100","152010-1000","611010-1000",1,10]
["都祁","110101-0300","152010-1000","611010-2000",1,10]
["月ヶ瀬","110101-0500","152010-1000","611010-3000",1,10]
[null,"簿記科目CD"]
["仮受消費税","336010-1000"]
["仮払消費税","158030-1000"]
["過年度修正益","613020-1000"]
["過年度修正損","713040-1000"]
["予算科目CD","借方科目CD","貸方科目CD","税込み金額","税抜き金額","消費税額","摘要"]
["都市部"]
["給水収益","給水未収金","給水収益",604333058,{"$f":"D14/1.1","v":549393689.090909},{"$f":"D14-E14","v":54939368.909090996},{"$f":"\"定例調定：\"&$A$13&\"：隔月分\"","v":"定例調定：都市部：隔月分"}]
["給水収益","給水未収金","給水収益",61075465,{"$f":"D15/1.1","v":55523149.999999993},{"$f":"D15-E15","v":5552315.0000000075},{"$f":"\"定例調定：\"&$A$13&\"：毎月分\"","v":"定例調定：都市部：毎月分"}]
["給水収益","給水未収金","給水収益",15861,14419.090909090908,1441.9090909090919,{"$f":"\"調定増：現年度：\"&$A$13","v":"調定増：現年度：都市部"}]
["過年度修正益","給水未収金","過年度修正益",null,0,0,{"$f":"\"調定増：過年度：\"&$A$13","v":"調定増：過年度：都市部"}]
["給水収益","給水収益","給水未収金",31360,28509.090909090908,2850.9090909090919,{"$f":"\"調定減：現年度：\"&$A$13","v":"調定減：現年度：都市部"}]
["過年度修正損","過年度修正損","給水未収金",null,0,0,{"$f":"\"調定減：過年度：\"&$A$13","v":"調定減：過年度：都市部"}]
["都祁"]
["給水収益","給水未収金","給水収益",11228857,{"$f":"D21/1.1","v":10208051.818181816},{"$f":"D21-E21","v":1020805.1818181835},{"$f":"\"定例調定：\"&$A$20&\"：隔月分\"","v":"定例調定：都祁：隔月分"}]
["給水収益","給水未収金","給水収益",null,{"$f":"D22/1.1","v":0},{"$f":"D22-E22","v":0},{"$f":"\"定例調定：\"&$A$20&\"：毎月分\"","v":"定例調定：都祁：毎月分"}]
["給水収益","給水未収金","給水収益",null,0,0,{"$f":"\"調定増：現年度：\"&$A$20","v":"調定増：現年度：都祁"}]
["過年度修正益","給水未収金","過年度修正益",null,0,0,{"$f":"\"調定増：過年度：\"&$A$20","v":"調定増：過年度：都祁"}]
["給水収益","給水収益","給水未収金",null,0,0,{"$f":"\"調定減：現年度：\"&$A$20","v":"調定減：現年度：都祁"}]
["過年度修正損","過年度修正損","給水未収金",null,0,0,{"$f":"\"調定減：過年度：\"&$A$20","v":"調定減：過年度：都祁"}]
["月ヶ瀬"]
["給水収益","給水未収金","給水収益",null,{"$f":"D28/1.1","v":0},{"$f":"D28-E28","v":0},{"$f":"\"定例調定：\"&$A$27&\"：隔月分\"","v":"定例調定：月ヶ瀬：隔月分"}]
["給水収益","給水未収金","給水収益",null,{"$f":"D29/1.1","v":0},{"$f":"D29-E29","v":0},{"$f":"\"定例調定：\"&$A$27&\"：毎月分\"","v":"定例調定：月ヶ瀬：毎月分"}]
["給水収益","給水未収金","給水収益",null,0,0,{"$f":"\"調定増：現年度：\"&$A$27","v":"調定増：現年度：月ヶ瀬"}]
["過年度修正益","給水未収金","過年度修正益",null,0,0,{"$f":"\"調定増：過年度：\"&$A$27","v":"調定増：過年度：月ヶ瀬"}]
["給水収益","給水収益","給水未収金",null,0,0,{"$f":"\"調定減：現年度：\"&$A$27","v":"調定減：現年度：月ヶ瀬"}]
["過年度修正損","過年度修正損","給水未収金",null,0,0,{"$f":"\"調定減：過年度：\"&$A$27","v":"調定減：過年度：月ヶ瀬"}]
["金額合計"]

{"sheet":"入力様式・上水入金下水調定","index":4,"n_rows":140,"n_cols":8,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
["読込FLG"]
[20,"簿記伝票始まり",null,null,null,null,""]
[21,"簿記科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[22,"口座"]
[0,"都市部"]
[2,"110101-0100","151010-1000","152010-1000",94380298,null,"水道料金：都市部","2020-11-18"]
[2,null,"151010-1000","335530-1000",67182693,null,"公共下水料金：都市部","2020-11-18"]
[2,null,"151010-1000","335530-5000",543801,null,"農業集落排水：都市部","2020-11-18"]
[0,"都祁"]
[2,"110101-0300","151010-1000","152010-1000",1322218,null,"水道料金：都祁","2020-11-18"]
[0,"月ヶ瀬"]
[2,"110101-0500","151010-1000","152010-1000",134014,null,"水道料金：月ヶ瀬","2020-11-18"]
[2,null,"151010-1000","335530-3000",41321,null,"公共下水料金：月ヶ瀬","2020-11-18"]
[2,null,"151010-1000","335530-7000",77252,null,"農業集落排水：月ヶ瀬","2020-11-18"]
[0,"都市部（下水のみ）"]
[2,null,"151010-1000","335530-2000",0,null,"公共下水料金：都市部（下水のみ）","2020-11-18"]
[2,null,"151010-1000","335530-6000",0,null,"農業集落排水：都市部（下水のみ）","2020-11-18"]
[0,"月ヶ瀬（下水のみ）"]
[2,null,"151010-1000","335530-4000",41321,null,"公共下水料金：月ヶ瀬（下水のみ）","2020-11-18"]
[2,null,"151010-1000","335530-8000",77252,null,"農業集落排水：月ヶ瀬（下水のみ）","2020-11-18"]
[]
[0,"水道料金過誤納"]
[2,"都市部","151010-1000","335550-1000",null,null,"水道料金過誤納(都市部)","2020-11-18"]
[2,"都祁","151010-1000","335550-1000",null,null,"水道料金過誤納(都祁)","2020-11-18"]
[2,"月ヶ瀬","151010-1000","335550-1000",null,null,"水道料金過誤納(月ヶ瀬)","2020-11-18"]
[0]
[0,"下水料金過誤納"]
[2,"都市部（下水のみ）","151010-1000","335530-1000",null,null,"下水料金過誤納都市部（下水のみ）","2020-11-18"]
[2,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,"下水料金過誤納月ヶ瀬（下水のみ）","2020-11-18"]
[0]
[22,"郵政納付"]
[0,"都市部"]
[2,"110101-0100","151010-1000","152010-1000",94380298,null,"水道料金：都市部","2020-11-18"]
[2,null,"151010-1000","335530-1000",67182693,null,"公共下水料金：都市部","2020-11-18"]
[2,null,"151010-1000","335530-5000",543801,null,"農業集落排水：都市部","2020-11-18"]
[0,"都祁"]
[2,"110101-0300","151010-1000","152010-1000",1322218,null,"水道料金：都祁","2020-11-18"]
[0,"月ヶ瀬"]
[2,"110101-0500","151010-1000","152010-1000",134014,null,"水道料金：月ヶ瀬","2020-11-18"]
[2,null,"151010-1000","335530-3000",41321,null,"公共下水料金：月ヶ瀬","2020-11-18"]
[2,null,"151010-1000","335530-7000",77252,null,"農業集落排水：月ヶ瀬","2020-11-18"]
[0,"都市部（下水のみ）"]
[2,null,"151010-1000","335530-2000",0,null,"公共下水料金：都市部（下水のみ）","2020-11-18"]
[2,null,"151010-1000","335530-6000",0,null,"農業集落排水：都市部（下水のみ）","2020-11-18"]
[0,"月ヶ瀬（下水のみ）"]
[2,null,"151010-1000","335530-4000",41321,null,"公共下水料金：月ヶ瀬（下水のみ）","2020-11-18"]
[2,null,"151010-1000","335530-8000",77252,null,"農業集落排水：月ヶ瀬（下水のみ）","2020-11-18"]
[]
[0,"水道料金過誤納"]
[2,"都市部","151010-1000","335550-1000",null,null,"水道料金過誤納(都市部)","2020-11-18"]
[2,"都祁","151010-1000","335550-1000",null,null,"水道料金過誤納(都祁)","2020-11-18"]
[2,"月ヶ瀬","151010-1000","335550-1000",null,null,"水道料金過誤納(月ヶ瀬)","2020-11-18"]
[0]
[0,"下水料金過誤納"]
[2,"都市部（下水のみ）","151010-1000","335530-1000",null,null,"下水料金過誤納都市部（下水のみ）","2020-11-18"]
[2,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,"下水料金過誤納月ヶ瀬（下水のみ）","2020-11-18"]
[0]
[22,"銀行納付"]
[0,"都市部"]
[2,"110101-0100","151010-1000","152010-1000",94380298,null,"水道料金：都市部","2020-11-18"]
[2,null,"151010-1000","335530-1000",67182693,null,"公共下水料金：都市部","2020-11-18"]
[2,null,"151010-1000","335530-5000",543801,null,"農業集落排水：都市部","2020-11-18"]
[0,"都祁"]
[2,"110101-0300","151010-1000","152010-1000",1322218,null,"水道料金：都祁","2020-11-18"]
[0,"月ヶ瀬"]
[2,"110101-0500","151010-1000","152010-1000",134014,null,"水道料金：月ヶ瀬","2020-11-18"]
[2,null,"151010-1000","335530-3000",41321,null,"公共下水料金：月ヶ瀬","2020-11-18"]
[2,null,"151010-1000","335530-7000",77252,null,"農業集落排水：月ヶ瀬","2020-11-18"]
[0,"都市部（下水のみ）"]
[2,null,"151010-1000","335530-2000",0,null,"公共下水料金：都市部（下水のみ）","2020-11-18"]
[2,null,"151010-1000","335530-6000",0,null,"農業集落排水：都市部（下水のみ）","2020-11-18"]
[0,"月ヶ瀬（下水のみ）"]
[2,null,"151010-1000","335530-4000",41321,null,"公共下水料金：月ヶ瀬（下水のみ）","2020-11-18"]
[2,null,"151010-1000","335530-8000",77252,null,"農業集落排水：月ヶ瀬（下水のみ）","2020-11-18"]
[]
[0,"水道料金過誤納"]
[2,"都市部","151010-1000","335550-1000",null,null,"水道料金過誤納(都市部)","2020-11-18"]
[2,"都祁","151010-1000","335550-1000",null,null,"水道料金過誤納(都祁)","2020-11-18"]
[2,"月ヶ瀬","151010-1000","335550-1000",null,null,"水道料金過誤納(月ヶ瀬)","2020-11-18"]
[0]
[0,"下水料金過誤納"]
[2,"都市部（下水のみ）","151010-1000","335530-1000",null,null,"下水料金過誤納都市部（下水のみ）","2020-11-18"]
[2,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,"下水料金過誤納月ヶ瀬（下水のみ）","2020-11-18"]
[0]
[22,"コンビニ"]
[0,"都市部"]
[2,"110101-0100","151010-1000","152010-1000",94380298,null,"水道料金：都市部","2020-11-18"]
[2,null,"151010-1000","335530-1000",67182693,null,"公共下水料金：都市部","2020-11-18"]
[2,null,"151010-1000","335530-5000",543801,null,"農業集落排水：都市部","2020-11-18"]
[0,"都祁"]
[2,"110101-0300","151010-1000","152010-1000",1322218,null,"水道料金：都祁","2020-11-18"]
[0,"月ヶ瀬"]
[2,"110101-0500","151010-1000","152010-1000",134014,null,"水道料金：月ヶ瀬","2020-11-18"]
[2,null,"151010-1000","335530-3000",41321,null,"公共下水料金：月ヶ瀬","2020-11-18"]
[2,null,"151010-1000","335530-7000",77252,null,"農業集落排水：月ヶ瀬","2020-11-18"]
[0,"都市部（下水のみ）"]
[2,null,"151010-1000","335530-2000",0,null,"公共下水料金：都市部（下水のみ）","2020-11-18"]
[2,null,"151010-1000","335530-6000",0,null,"農業集落排水：都市部（下水のみ）","2020-11-18"]
[0,"月ヶ瀬（下水のみ）"]
[2,null,"151010-1000","335530-4000",41321,null,"公共下水料金：月ヶ瀬（下水のみ）","2020-11-18"]
[2,null,"151010-1000","335530-8000",77252,null,"農業集落排水：月ヶ瀬（下水のみ）","2020-11-18"]
[]
[0,"水道料金過誤納"]
[2,"都市部","151010-1000","335550-1000",null,null,"水道料金過誤納(都市部)","2020-11-18"]
[2,"都祁","151010-1000","335550-1000",null,null,"水道料金過誤納(都祁)","2020-11-18"]
[2,"月ヶ瀬","151010-1000","335550-1000",null,null,"水道料金過誤納(月ヶ瀬)","2020-11-18"]
[0]
[0,"下水料金過誤納"]
[2,"都市部（下水のみ）","151010-1000","335530-1000",null,null,"下水料金過誤納都市部（下水のみ）","2020-11-18"]
[2,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,"下水料金過誤納月ヶ瀬（下水のみ）","2020-11-18"]
[0]
[22,"窓口"]
[0,"都市部"]
[2,"110101-0100","151010-1000","152010-1000",94380298,null,"水道料金：都市部","2020-11-18"]
[2,null,"151010-1000","335530-1000",67182693,null,"公共下水料金：都市部","2020-11-18"]
[2,null,"151010-1000","335530-5000",543801,null,"農業集落排水：都市部","2020-11-18"]
[0,"都祁"]
[2,"110101-0300","151010-1000","152010-1000",1322218,null,"水道料金：都祁","2020-11-18"]
[0,"月ヶ瀬"]
[2,"110101-0500","151010-1000","152010-1000",134014,null,"水道料金：月ヶ瀬","2020-11-18"]
[2,null,"151010-1000","335530-3000",41321,null,"公共下水料金：月ヶ瀬","2020-11-18"]
[2,null,"151010-1000","335530-7000",77252,null,"農業集落排水：月ヶ瀬","2020-11-18"]
[0,"都市部（下水のみ）"]
[2,null,"151010-1000","335530-2000",0,null,"公共下水料金：都市部（下水のみ）","2020-11-18"]
[2,null,"151010-1000","335530-6000",0,null,"農業集落排水：都市部（下水のみ）","2020-11-18"]
[0,"月ヶ瀬（下水のみ）"]
[2,null,"151010-1000","335530-4000",41321,null,"公共下水料金：月ヶ瀬（下水のみ）","2020-11-18"]
[2,null,"151010-1000","335530-8000",77252,null,"農業集落排水：月ヶ瀬（下水のみ）","2020-11-18"]
[]
[0,"水道料金過誤納"]
[2,"都市部","151010-1000","335550-1000",null,null,"水道料金過誤納(都市部)","2020-11-18"]
[2,"都祁","151010-1000","335550-1000",null,null,"水道料金過誤納(都祁)","2020-11-18"]
[2,"月ヶ瀬","151010-1000","335550-1000",null,null,"水道料金過誤納(月ヶ瀬)","2020-11-18"]
[0]
[0,"下水料金過誤納"]
[2,"都市部（下水のみ）","151010-1000","335530-1000",null,null,"下水料金過誤納都市部（下水のみ）","2020-11-18"]
[2,"月ヶ瀬（下水のみ）","151010-1000","335530-1000",null,null,"下水料金過誤納月ヶ瀬（下水のみ）","2020-11-18"]
[0]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"ブランク伝票","index":5,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[11]
[11]
[0]
[11]
[0]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日","消費税CD","消費税率","消費税額"]
[21]
[21]
[0]
[21]
[0]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]
[]
["読込FLG","読込FLGの値に応じて行単位で読込みます"]
[10,"読込みません。予算伝票の読込の始まり"]
[0,"読込みません。合計、見出しなど関連情報を記載します。"]
[11,"予算伝票データ"]
[19,"読込みません。予算伝票の終わり"]
[20,"読込みません。簿記伝票の読込の始まり"]
[21,"簿記伝票データ"]
[29,"読込みません。簿記伝票の終わり"]
[999,"読込みません。全伝票の終わり"]
[]
["＊注意","金額増・金額減がともにゼロの場合、読み込みません"]