{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["★★★振込データ入力用★★★","集計","振込先データ","リスト","仕訳CSV"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":2,"pivot_tables":1},"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":16,"n_cols":27,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,6,7,6],[3,5,6,5],[1,5,2,5]]}
[]
[null,null,null,null,null,"振込日",null,2]
[]
[null,null,null,null,null,"2025-02-28"]
[]
[]
[]
[]
[]
[null,"№","支払元","振込元口座","項目","摘要","金額","データ№","口座名義","銀行","銀行コード","支店","支店コード","種類","口座番号","入力日","入力者","振込先固定","金額固定","仕訳","勘定科目","補助科目","計上日","経過勘定科目","経過勘定補助科目","使用月","弥生摘要"]
[null,"№","支払元","振込元口座","項目","摘要","金額","データ№","口座名義","銀行","銀行コード","支店","支店コード","種類","口座番号","入力日","入力者","振込先固定","金額固定","仕訳","勘定科目","補助科目","計上日","経過勘定科目","経過勘定補助科目","使用月","弥生摘要"]
[null,1,"01sample_本社SMBC",{"$f":"IFERROR(_xlfn.XLOOKUP(振込データ入力用[[#This Row],[支払元]],口座リスト[支払元],口座リスト[口座番号]),\"\")","v":"1234567"},"○○電力","電気代",100000,0,"ｶ)ｻﾝﾌﾟﾙ","サンプル銀行",0,"サンプル支店",0,1,1234567,"2025-02-01","田中","○","×","○","水道光熱費","電気代","2025-01-31","未払金","月末振込","1月",{"$f":"振込データ入力用[[#This Row],[項目]]&\" \"&振込データ入力用[[#This Row],[摘要]]&\" \"&IF(振込データ入力用[[#This Row],[使用月]]=\"\",\"\",振込データ入力用[[#This Row],[使用月]]&\"分\")","v":"○○電力 電気代 1月分"}]
[null,2,"02sample_支店1みずほ",{"$f":"IFERROR(_xlfn.XLOOKUP(振込データ入力用[[#This Row],[支払元]],口座リスト[支払元],口座リスト[口座番号]),\"\")","v":"9876543"},"○○不動産㈱","事務所家賃",500000,0,"ｶ)ｻﾝﾌﾟﾙ","サンプル銀行",0,"サンプル支店",0,1,1234567,"2025-02-01","田中","○","○","○","地代家賃","事務所家賃","2025-03-31","前払費用","月末振込","3月",{"$f":"振込データ入力用[[#This Row],[項目]]&\" \"&振込データ入力用[[#This Row],[摘要]]&\" \"&IF(振込データ入力用[[#This Row],[使用月]]=\"\",\"\",振込データ入力用[[#This Row],[使用月]]&\"分\")","v":"○○不動産㈱ 事務所家賃 3月分"}]
[null,3,"01sample_本社SMBC",{"$f":"IFERROR(_xlfn.XLOOKUP(振込データ入力用[[#This Row],[支払元]],口座リスト[支払元],口座リスト[口座番号]),\"\")","v":"1234567"},"○○商店","事務用品一式",50000,0,"ｶ)ｻﾝﾌﾟﾙ","サンプル銀行",0,"サンプル支店",0,1,1234567,"2025-02-25","田中","×","×","○","消耗品費","事務用品",null,null,null,null,{"$f":"振込データ入力用[[#This Row],[項目]]&\" \"&振込データ入力用[[#This Row],[摘要]]&\" \"&IF(振込データ入力用[[#This Row],[使用月]]=\"\",\"\",振込データ入力用[[#This Row],[使用月]]&\"分\")","v":"○○商店 事務用品一式 "}]
[null,4,"01sample_本社SMBC",{"$f":"IFERROR(_xlfn.XLOOKUP(振込データ入力用[[#This Row],[支払元]],口座リスト[支払元],口座リスト[口座番号]),\"\")","v":"1234567"},"○○ﾈｯﾄﾜｰｸ㈱","Wi-Fi使用料",20000,1,"ｶ)ﾃｽﾄ","test銀行",0,"test支店",0,1,9876543,"2025-02-25","齋藤","×","×","○","通信費","Wi-Fi","2025-01-31","未払金","月末振込","1月",{"$f":"振込データ入力用[[#This Row],[項目]]&\" \"&振込データ入力用[[#This Row],[摘要]]&\" \"&IF(振込データ入力用[[#This Row],[使用月]]=\"\",\"\",振込データ入力用[[#This Row],[使用月]]&\"分\")","v":"○○ﾈｯﾄﾜｰｸ㈱ Wi-Fi使用料 1月分"}]
[null,5,"01sample_本社SMBC",{"$f":"IFERROR(_xlfn.XLOOKUP(振込データ入力用[[#This Row],[支払元]],口座リスト[支払元],口座リスト[口座番号]),\"\")","v":"1234567"},"○○広告代理店","広告宣伝費",100000,0,"ｶ)ｻﾝﾌﾟﾙ","サンプル銀行",0,"サンプル支店",0,1,1234567,"2025-02-28","田中","×","×","○","広告宣伝費","看板使用料","2025-01-31","未払金","月末振込","1月",{"$f":"振込データ入力用[[#This Row],[項目]]&\" \"&振込データ入力用[[#This Row],[摘要]]&\" \"&IF(振込データ入力用[[#This Row],[使用月]]=\"\",\"\",振込データ入力用[[#This Row],[使用月]]&\"分\")","v":"○○広告代理店 広告宣伝費 1月分"}]

{"sheet":"集計","index":1,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,3,1,4]]}
[null,"金額","(すべて)"]
[null,null,null,{"$f":"★★★振込データ入力用★★★!$F$4","v":"2025-02-28"}]
[null,"支払元","項目","№","摘要","口座名義","銀行","支店","種類","口座番号","合計 / 金額"]
[null,"01sample_本社SMBC","○○電力",1,"電気代","ｶ)ｻﾝﾌﾟﾙ","サンプル銀行","サンプル支店",1,1234567,100000]
[null,null,"○○電力 集計",null,null,null,null,null,null,null,100000]
[]
[null,null,"○○不動産㈱",2,"事務所家賃","ｶ)ｻﾝﾌﾟﾙ","サンプル銀行","サンプル支店",1,1234567,500000]
[null,null,"○○不動産㈱ 集計",null,null,null,null,null,null,null,500000]
[]
[null,null,"○○ﾈｯﾄﾜｰｸ㈱",4,"Wi-Fi使用料","ｶ)ﾃｽﾄ","test銀行","test支店",1,9876543,20000]
[null,null,"○○ﾈｯﾄﾜｰｸ㈱ 集計",null,null,null,null,null,null,null,20000]
[]
[null,"01sample_本社SMBC 合計",null,null,null,null,null,null,null,null,620000]
[]
[null,"02sample_支店1みずほ","○○商店",3,"事務用品一式","ｶ)ｻﾝﾌﾟﾙ","サンプル銀行","サンプル支店",1,1234567,50000]
[null,null,"○○商店 集計",null,null,null,null,null,null,null,50000]
[]
[null,"02sample_支店1みずほ 合計",null,null,null,null,null,null,null,null,50000]
[]
[null,"総計",null,null,null,null,null,null,null,null,670000]

{"sheet":"振込先データ","index":2,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"№","銀行コード","銀行","支店コード","支店","ダミー","種類","口座番号","口座名義"]
[null,"№","銀行コード","銀行","支店コード","支店","ダミー","種類","口座番号","口座名義"]
[null,0,0,"サンプル銀行",0,"サンプル支店",null,1,1234567,"ｶ)ｻﾝﾌﾟﾙ"]
[null,1,0,"test銀行",0,"test支店",null,1,9876543,"ｶ)ﾃｽﾄ"]
[null,2,1111,"ｻﾝﾌﾟﾙ中央銀行",111,"ｻﾝﾌﾟﾙ中央支店",null,1,1111111,"ｶ)ｻﾝﾌﾟﾙｼﾖｳﾃﾝ"]

{"sheet":"リスト","index":3,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"支払元となる口座の情報を入力して下さい。"]
[null,{"$f":"HYPERLINK(\"https://zengin.ajtw.net/\",\"金融機関コード検索リンク(Webページが開きます)\")","v":"金融機関コード検索リンク(Webページが開きます)"}]
[null,"番号","支払元","部門名","銀行名","銀行コード","支店名","支店コード","口座種別","口座番号","委託者コード","口座名義",null,"入力者",null,"○×",null,"使用月"]
[null,"01sample",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":"01sample_本社SMBC"},"本社SMBC","三井住友銀行",9,"葛西支店",823,1,"1234567","0000000000","ｶ) ｹｲﾘｻﾝｷﾞﾖｳﾎﾝｼﾔ",null,"田中",null,"○",null,"1月"]
[null,"02sample",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":"02sample_支店1みずほ"},"支店1みずほ","みずほ銀行",1,"千葉支店",280,1,"9876543","0000000000","ｶ) ｹｲﾘｻﾝｷﾞﾖｳｼﾃﾝｲﾁ",null,"齋藤",null,"×",null,"2月"]
[null,"03",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""},null,null,null,null,null,null,null,null,null,null,"山田",null,null,null,"3月"]
[null,"04",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"口座種別",null,"4月"]
[null,"05",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"1:普通預金",null,"5月"]
[null,"06",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"2:当座預金",null,"6月"]
[null,"07",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7月"]
[null,"08",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"経過勘定",null,"8月"]
[null,"09",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"未払金",null,"9月"]
[null,"10",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"未払費用",null,"10月"]
[null,"11",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"前払金",null,"11月"]
[null,"12",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"前払費用",null,"12月"]
[null,"13",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"14",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"15",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"16",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"17",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"18",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"19",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"20",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"21",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"22",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"23",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"24",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"25",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"26",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"27",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"28",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"29",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"30",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"31",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]
[null,"32",{"$f":"IF(口座リスト[[#This Row],[口座番号]]=\"\",\"\",口座リスト[[#This Row],[番号]] & \"_\" &口座リスト[[#This Row],[部門名]])","v":""}]

{"sheet":"仕訳CSV","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}