{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["入力資産減耗","入力減価償却累計額","入力長期前受金戻入","入力収益化累計額","ブランク伝票"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[0,"都市部"]
[11,"210118-0100","711085-1000","111025-5000",17781606,null,"固定資産除却令和２年度構築物(配水設備)","2020-12-19",99]
[11,"210118-0100","711085-1000","111025-6000",16256222,null,"固定資産除却令和２年度構築物(配水管設備)","2020-12-19",99]
[11,"210118-0100","711085-1000","111025-7000",631834,null,"固定資産除却令和２年度構築物(諸設備)","2020-12-19",99]
[11,"210118-0100","711085-1000","111035-1000",2221161,null,"固定資産除却令和２年度機械及び装置(電気設備)","2020-12-19",99]
[11,"210118-0100","711085-1000","111035-2000",1537069,null,"固定資産除却令和２年度機械及び装置(ポンプ設備)","2020-12-19",99]
[11,"210118-0100","711085-1000","111035-4000",977665,null,"固定資産除却令和２年度機械及び装置(量水器)","2020-12-19",99]
[11,"210118-0100","711085-1000","111035-6000",1748500,null,"固定資産除却令和２年度構築物(計装設備)","2020-12-19",99]
[11,"210118-0100","711085-1000","111035-7000",1944716,null,"固定資産除却令和２年度機械及び装置(その他機械装置)","2020-12-19",99]
[11,"210118-0100","711085-1000","111045-1000",320900,null,"固定資産除却令和２年度車両運搬具","2020-12-19",99]
[11,"210118-0100","711085-1000","111055-1000",905109,null,"固定資産除却令和２年度器具備品","2020-12-19",99]
[0,"都祁"]
[11,"210118-0500","711085-3000","111035-4000",4433,null,"固定資産除却令和２年度機械及び装置(量水器)","2020-12-19",99]
[11,"210118-0500","711085-3000","111035-6000",126815,null,"固定資産除却令和２年度機械及び装置(計装設備)","2020-12-19",99]
[11,"210118-0500","711085-3000","111035-7000",74145,null,"固定資産除却令和２年度機械及び装置(その他機械装置)","2020-12-19",99]
[0,"月ヶ瀬"]
[11,"210118-0900","711085-5000","111025-6000",178847,null,"固定資産除却令和２年度構築物(配水管設備)","2020-12-19",99]
[11,"210118-0900","711085-5000","111035-2000",3176,null,"固定資産除却令和２年度機械及び装置(ポンプ設備)","2020-12-19",99]
[11,"210118-0900","711085-5000","111035-4000",236105,null,"固定資産除却令和２年度機械及び装置(量水器)","2020-12-19",99]
[0,"金額合計"]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[0,"都市部"]
[21,"210118-0100","711085-1000","111025-5000",17781606,17781606,"固定資産除却令和２年度構築物(配水設備)","2020-12-19",99]
[21,"210118-0100","711085-1000","111025-6000",16256222,16256222,"固定資産除却令和２年度構築物(配水管設備)","2020-12-19",99]
[21,"210118-0100","711085-1000","111025-7000",631834,631834,"固定資産除却令和２年度構築物(諸設備)","2020-12-19",99]
[21,"210118-0100","711085-1000","111035-1000",2221161,2221161,"固定資産除却令和２年度機械及び装置(電気設備)","2020-12-19",99]
[21,"210118-0100","711085-1000","111035-2000",1537069,1537069,"固定資産除却令和２年度機械及び装置(ポンプ設備)","2020-12-19",99]
[21,"210118-0100","711085-1000","111035-4000",977665,977665,"固定資産除却令和２年度機械及び装置(量水器)","2020-12-19",99]
[21,"210118-0100","711085-1000","111035-6000",1748500,1748500,"固定資産除却令和２年度構築物(計装設備)","2020-12-19",99]
[21,"210118-0100","711085-1000","111035-7000",1944716,1944716,"固定資産除却令和２年度機械及び装置(その他機械装置)","2020-12-19",99]
[21,"210118-0100","711085-1000","111045-1000",320900,320900,"固定資産除却令和２年度車両運搬具","2020-12-19",99]
[21,"210118-0100","711085-1000","111055-1000",905109,905109,"固定資産除却令和２年度器具備品","2020-12-19",99]
[0,"都祁"]
[21,"210118-0500","711085-3000","111035-4000",4433,4433,"固定資産除却令和２年度機械及び装置(量水器)","2020-12-19",99]
[21,"210118-0500","711085-3000","111035-6000",126815,126815,"固定資産除却令和２年度機械及び装置(計装設備)","2020-12-19",99]
[21,"210118-0500","711085-3000","111035-7000",74145,74145,"固定資産除却令和２年度機械及び装置(その他機械装置)","2020-12-19",99]
[0,"月ヶ瀬"]
[21,"210118-0900","711085-5000","111025-6000",178847,178847,"固定資産除却令和２年度構築物(配水管設備)","2020-12-19",99]
[21,"210118-0900","711085-5000","111035-2000",3176,3176,"固定資産除却令和２年度機械及び装置(ポンプ設備)","2020-12-19",99]
[21,"210118-0900","711085-5000","111035-4000",236105,236105,"固定資産除却令和２年度機械及び装置(量水器)","2020-12-19",99]
[0,"金額合計"]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"入力減価償却累計額","index":1,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[0,"都市部"]
[21,null,"111030-5500","111025-5000",52689150,52689150,"固定資産除却令和２年度構築物(配水設備)",null,99]
[21,null,"111030-6000","111025-6000",27502698,27502698,"固定資産除却令和２年度構築物(配水管設備)",null,99]
[21,null,"111030-7000","111025-7000",8035004,8035004,"固定資産除却令和２年度構築物(諸設備)",null,99]
[21,null,"111040-1000","111035-1000",21774422,21774422,"固定資産除却令和２年度機械及び装置(電気設備)",null,99]
[21,null,"111040-2000","111035-2000",29204245,29204245,"固定資産除却令和２年度機械及び装置(ポンプ設備)",null,99]
[21,null,"111040-4000","111035-4000",977665,977665,"固定資産除却令和２年度機械及び装置(量水器)",null,99]
[21,null,"111040-6000","111035-6000",33221500,33221500,"固定資産除却令和２年度機械及び装置(計装設備)",null,99]
[21,null,"111040-7000","111035-7000",33939561,33939561,"固定資産除却令和２年度機械及び装置(その他機械装置)",null,99]
[21,null,"111050-1000","111045-1000",6097100,6097100,"固定資産除却令和２年度車両運搬具",null,99]
[21,null,"111060-1000","111055-1000",9084506,9084506,"固定資産除却令和２年度器具備品",null,99]
[0,"都祁"]
[21,null,"111040-6000","111035-6000",1666534,1666534,"固定資産除却令和２年度機械及び装置(計装設備)",null,99]
[21,null,"111040-7000","111035-7000",961192,961192,"固定資産除却令和２年度機械及び装置(その他機械装置)",null,99]
[0,"月ヶ瀬"]
[21,null,"111030-6000","111025-6000",2838895,2838895,"固定資産除却令和２年度構築物(配水管設備)",null,99]
[21,null,"111040-2000","111035-2000",429921,429921,"固定資産除却令和２年度機械及び装置(ポンプ設備)",null,99]
[21,null,"111040-7000","111035-7000",2332355,2332355,"固定資産除却令和２年度機械及び装置(その他機械装置)",null,99]
[0,"金額合計"]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"入力長期前受金戻入","index":2,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[0,"都市部"]
[11,"110309-0100","361060-1000","612050-1000",1465681,null,"有形固定資産令和２年度除却に伴う分担金長期前受金戻入","2020-12-19",99]
[11,"110309-0100","361050-1000","612050-1000",1843759,null,"有形固定資産令和２年度除却に伴う開発負担金長期前受金戻入","2020-12-19",99]
[11,"110309-0100","361020-1000","612050-1000",1024433,null,"有形固定資産令和２年度除却に伴う補助金長期前受金戻入","2020-12-19",99]
[11,"110309-0100","361030-1000","612050-1000",1711668,null,"有形固定資産令和２年度除却に伴う負担金長期前受金戻入","2020-12-19",99]
[11,"110309-0100","361010-1000","612050-1000",5747599,null,"有形固定資産令和２年度除却に伴う受贈財産長期前受金戻入","2020-12-19",99]
[11,"110309-0100","361070-1000","612050-1000",2608528,null,"有形固定資産令和２年度除却に伴う受託負担金長期前受金戻入","2020-12-19",99]
[0,"都祁"]
[11,"110309-0500","361020-1000","612050-3000",128615,null,"有形固定資産令和２年度除却に伴う補助金長期前受金戻入","2020-12-19",99]
[11,"110309-0500","361030-1000","612050-3000",9690,null,"有形固定資産令和２年度除却に伴う負担金長期前受金戻入","2020-12-19",99]
[11,"110309-0500","361060-1000","612050-3000",733,null,"有形固定資産令和２年度除却に伴う分担金長期前受金戻入","2020-12-19",99]
[0,"月ヶ瀬"]
[11,"110309-0900","361020-1000","612050-5000",222603,null,"有形固定資産令和２年度除却に伴う補助金長期前受金戻入","2020-12-19",99]
[11,"110309-0900","361030-1000","612050-5000",65725,null,"有形固定資産令和２年度除却に伴う負担金長期前受金戻入","2020-12-19",99]
[11,"110309-0900","361060-1000","612050-5000",1424,null,"有形固定資産令和２年度除却に伴う分担金長期前受金戻入","2020-12-19",99]
[0,"金額合計"]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[0,"都市部"]
[21,"110309-0100","361060-1000","612050-1000",1465681,1465681,"有形固定資産令和２年度除却に伴う分担金長期前受金戻入","2020-12-19",99]
[21,"110309-0100","361050-1000","612050-1000",1843759,1843759,"有形固定資産令和２年度除却に伴う開発負担金長期前受金戻入","2020-12-19",99]
[21,"110309-0100","361020-1000","612050-1000",1024433,1024433,"有形固定資産令和２年度除却に伴う補助金長期前受金戻入","2020-12-19",99]
[21,"110309-0100","361030-1000","612050-1000",1711668,1711668,"有形固定資産令和２年度除却に伴う負担金長期前受金戻入","2020-12-19",99]
[21,"110309-0100","361010-1000","612050-1000",5747599,5747599,"有形固定資産令和２年度除却に伴う受贈財産長期前受金戻入","2020-12-19",99]
[21,"110309-0100","361070-1000","612050-1000",2608528,2608528,"有形固定資産令和２年度除却に伴う受託負担金長期前受金戻入","2020-12-19",99]
[0,"都祁"]
[21,"110309-0500","361020-1000","612050-3000",128615,128615,"有形固定資産令和２年度除却に伴う補助金長期前受金戻入","2020-12-19",99]
[21,"110309-0500","361030-1000","612050-3000",9690,9690,"有形固定資産令和２年度除却に伴う負担金長期前受金戻入","2020-12-19",99]
[21,"110309-0500","361060-1000","612050-3000",733,733,"有形固定資産令和２年度除却に伴う分担金長期前受金戻入","2020-12-19",99]
[0,"月ヶ瀬"]
[21,"110309-0900","361020-1000","612050-5000",222603,222603,"有形固定資産令和２年度除却に伴う補助金長期前受金戻入","2020-12-19",99]
[21,"110309-0900","361030-1000","612050-5000",65725,65725,"有形固定資産令和２年度除却に伴う負担金長期前受金戻入","2020-12-19",99]
[21,"110309-0900","361060-1000","612050-5000",1424,1424,"有形固定資産令和２年度除却に伴う分担金長期前受金戻入","2020-12-19",99]
[0,"金額合計"]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"入力収益化累計額","index":3,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[0,"都市部"]
[21,null,"361060-1000","361065-1000",13115996,13115996,"有形固定資産除却に伴う分担金長期前受収益化累計額の振替",null,99]
[21,null,"361050-1000","361055-1000",7988929,7988929,"有形固定資産除却に伴う開発負担金長期前受収益化累計額の振替",null,99]
[21,null,"361020-1000","361025-1000",4905372,4905372,"有形固定資産除却に伴う補助金長期前受収益化累計額の振替",null,99]
[21,null,"361030-1000","361035-1000",5152805,5152805,"有形固定資産除却に伴う負担金長期前受収益化累計額の振替",null,99]
[21,null,"361020-1000","361025-1000",4905372,4905372,"有形固定資産除却に伴う補助金長期前受収益化累計額の振替",null,99]
[21,null,"361010-1000","361015-1000",9320681,9320681,"有形固定資産除却に伴う受贈財産長期前受収益化累計額の振替",null,99]
[21,null,"361070-1000","361075-1000",2442328,2442328,"有形固定資産除却に伴う受託負担金長期前受収益化累計額の振替",null,99]
[0,"都祁"]
[21,null,"361020-1000","361025-1000",2443656,2443656,"有形固定資産除却に伴う補助金長期前受収益化累計額の振替",null,99]
[21,null,"361030-1000","361035-1000",184070,184070,"有形固定資産除却に伴う負担金長期前受収益化累計額の振替",null,99]
[0,"月ヶ瀬"]
[21,null,"361020-1000","361025-1000",4352470,4352470,"有形固定資産除却に伴う補助金長期前受収益化累計額の振替",null,99]
[21,null,"361030-1000","361035-1000",1248701,1248701,"有形固定資産除却に伴う負担金長期前受収益化累計額の振替",null,99]
[0,"金額合計"]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"ブランク伝票","index":4,"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,"読込みません。全伝票の終わり"]
[]
["＊注意","金額増・金額減がともにゼロの場合、読み込みません"]