{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ブランク伝票","マクロ実行後（銀行手数料）","銀行手数料"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":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,"読込みません。全伝票の終わり"]
[]
["＊注意","金額増・金額減がともにゼロの場合、読み込みません"]

{"sheet":"マクロ実行後（銀行手数料）","index":1,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[11,"010150-0000","711070-3900","333710-1000",158147,null,"(株)みずほ銀行奈良支店長","2020-11-18",1,10]
[11,"010150-0000","711070-3900","333710-1000",660110,null,"(株)三菱UFJ銀行奈良支店長","2020-11-18",1,10]
[11,"010150-0000","711070-3900","333710-1000",453508,null,"(株)みずほ三井住友銀行奈良支店長","2020-11-18",1,10]
[11,"010150-0000","711070-3900","333710-1000",370623,null,"(株)りそな銀行新奈良営業部営業第三部長","2020-11-18",1,10]
[0,"金額合計",null,null,{"$f":"SUM(E3:E6)","v":1642388}]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[21,"010150-0000","711070-3900","333710-1000",143770,143770,"(株)みずほ銀行奈良支店長","2020-11-18",99]
[21,null,"158030-1000","333710-1000",14377,14377,"消費税：(株)みずほ銀行奈良支店長","2020-11-18",99]
[21,"010150-0000","711070-3900","333710-1000",600100,600100,"(株)三菱UFJ銀行奈良支店長","2020-11-18",99]
[21,null,"158030-1000","333710-1000",60010,60010,"消費税：(株)三菱UFJ銀行奈良支店長","2020-11-18",99]
[21,"010150-0000","711070-3900","333710-1000",412280,412280,"(株)みずほ三井住友銀行奈良支店長","2020-11-18",99]
[21,null,"158030-1000","333710-1000",41228,41228,"消費税：(株)みずほ三井住友銀行奈良支店長","2020-11-18",99]
[21,"010150-0000","711070-3900","333710-1000",336930,336930,"(株)りそな銀行新奈良営業部営業第三部長","2020-11-18",99]
[21,null,"158030-1000","333710-1000",33693,33693,"消費税：(株)りそな銀行新奈良営業部営業第三部長","2020-11-18",99]
[0,"金額合計",null,null,1642388,{"$f":"SUM(F10:F17)","v":1642388}]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"銀行手数料","index":2,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["読込FLG","見出し１","見出し２","見出し３","見出し４","見出し５","見出し６"]
[5,"予算科目CD","010150-0000","水道事業費用","営業費用","業務費","手数料"]
[5,"借方CD","711070-3900","水道事業費用","営業費用","総係費","手数料"]
[5,"貸方CD","333710-1000","流動負債","未払費用","未払費用","未払費用"]
[5,"仮受消費税","336010-1000"]
[5,"仮払消費税","158030-1000"]
[5,"消費税CD",1]
[5,"消費税率",10]
[5,"摘要","口座振替手数料　令和2年度上半期（令和2年3月～令和2年8月振替分）526,285件*10円　単価契約"]
[5,"発行日","2021-01-26"]
[0]
[0,"銀行手数料","負担行為額","税抜額","消費税額","債権者CD","債権者名称","金融機関","口座番号","口座名義人"]
[11,1,158147,143770,14377,"0100000918","(株)みずほ銀行奈良支店長"]
[11,2,660110,600100,60010,"0100000908","(株)三菱UFJ銀行奈良支店長"]
[11,3,453508,412280,41228,"0100000910","(株)みずほ三井住友銀行奈良支店長"]
[11,4,370623,336930,33693,"0100015806","(株)りそな銀行新奈良営業部営業第三部長"]
[11]
[11]
[11]
[11]
[0,"金額合計",{"$f":"SUM(C13:C20)","v":1642388},{"$f":"SUM(D13:D20)","v":1493080},{"$f":"SUM(E13:E20)","v":149308}]
[19,"予算伝票終わり"]
[999,"全伝票終わり"]