{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ＴＯＰ","取込勘定科目","データ貼付","データ基礎","弥生インポート形式仕訳日記帳","摘要→勘定科目テーブル","勘定科目テーブル"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,3,12],[7,4,7,13],[9,4,9,13],[11,4,11,13],[13,4,13,13]]}
[]
[]
[]
[]
[]
[null,null,null,null,"弥生会計に取り込む出納帳の「勘定科目」と「補助科目」を選択します"]
[]
[null,null,null,null,"変換する出納帳の「日付」、「摘要」、「出金金額」、「入金金額」を、現金出納帳のデータなどから貼り付けます。"]
[]
[null,null,null,null,"貼付けた通帳のデータから、弥生インポート形式の仕訳日記帳を生成します"]
[]
[null,null,null,null,"摘要に含まれる文字に対応する勘定科目と補助科目を登録しておくテーブルです"]
[]
[null,null,null,null,"弥生会計の勘定科目と対応する税区分を管理するマスターテーブルです"]
[]
[]
[null,"※使用上の注意"]
[null,"　　弥生会計にインポートする前に、絶対バックアップをとってからインポートするようお願いします。"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"提供：小林敬幸税理士事務所"]

{"sheet":"取込勘定科目","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,6,9,7],[7,4,7,5],[8,4,8,5]]}
[]
[]
[]
[]
[]
[]
[]
["１、取り込む出納帳の「勘定科目」を選択してください",null,null,null,"※取込対象となる弥生会計上の勘定科目の登録"]
[null,"現金",null,null,"（弥生会計に登録されている通りに入力してください）"]
[null,null,null,null,"勘定科目","補助科目"]
["２，取り込む出納帳の「補助科目」を選択してください",null,null,null,"現金"," "]
[null," ",null,null,"小口現金"]
[null,null,null,null,"長期借入金"]
[]
[]
[]
[]
[null,{"$f":"IF(B12=\"\",\"\",B12)","v":" "}]

{"sheet":"データ貼付","index":2,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"日付","摘要","出金金額","入金金額","摘要に対応する\n勘定科目","摘要に対応する\n補助科目",null,"借方勘定科目","借方補助科目","借方税区分","貸方勘定科目","貸方補助科目","貸方税区分","金額","摘要","日付"]
[null,"2015-05-07","接着剤　今津文具店",1080,null,null,null,null,{"$f":"IF(D9=\"\",取込勘定科目!$B$9,IF(D9=0,取込勘定科目!$B$9,データ貼付!F9))","v":0},{"$f":"IF(D9=\"\",取込勘定科目!$B$18,IF(D9=0,取込勘定科目!$B$18,IF(G9=0,\"\",G9)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I9,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I9,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E9=\"\",取込勘定科目!$B$9,IF(E9=0,取込勘定科目!$B$9,データ貼付!F9))","v":"現金"},{"$f":"IF(E9=\"\",取込勘定科目!$B$18,IF(E9=0,取込勘定科目!$B$18,IF(G9=0,\"\",G9)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L9,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L9,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},{"$f":"IF(D9=\"\",E9,IF(D9=0,E9,D9))","v":1080},{"$f":"C9","v":"接着剤　今津文具店"},{"$f":"TEXT(B9,\"yyyy/mm/dd\")","v":"2015/05/07"}]
[null,"2015-05-07","図録　多胡書店",5400,null,null,null,null,{"$f":"IF(D10=\"\",取込勘定科目!$B$9,IF(D10=0,取込勘定科目!$B$9,データ貼付!F10))","v":0},{"$f":"IF(D10=\"\",取込勘定科目!$B$18,IF(D10=0,取込勘定科目!$B$18,IF(G10=0,\"\",G10)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I10,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I10,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E10=\"\",取込勘定科目!$B$9,IF(E10=0,取込勘定科目!$B$9,データ貼付!F10))","v":"現金"},{"$f":"IF(E10=\"\",取込勘定科目!$B$18,IF(E10=0,取込勘定科目!$B$18,IF(G10=0,\"\",G10)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L10,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L10,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},{"$f":"IF(D10=\"\",E10,IF(D10=0,E10,D10))","v":5400},{"$f":"C10","v":"図録　多胡書店"},"2015/05/07"]
[null,"2015-05-08","打ち合わせ　松尾酒店",10500,null,null,null,null,{"$f":"IF(D11=\"\",取込勘定科目!$B$9,IF(D11=0,取込勘定科目!$B$9,データ貼付!F11))","v":0},{"$f":"IF(D11=\"\",取込勘定科目!$B$18,IF(D11=0,取込勘定科目!$B$18,IF(G11=0,\"\",G11)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I11,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I11,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E11=\"\",取込勘定科目!$B$9,IF(E11=0,取込勘定科目!$B$9,データ貼付!F11))","v":"現金"},{"$f":"IF(E11=\"\",取込勘定科目!$B$18,IF(E11=0,取込勘定科目!$B$18,IF(G11=0,\"\",G11)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L11,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L11,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},10500,"打ち合わせ　松尾酒店","2015/05/08"]
[null,"2015-05-08","事務所花　大崎生花店",1580,null,null,null,null,{"$f":"IF(D12=\"\",取込勘定科目!$B$9,IF(D12=0,取込勘定科目!$B$9,データ貼付!F12))","v":0},{"$f":"IF(D12=\"\",取込勘定科目!$B$18,IF(D12=0,取込勘定科目!$B$18,IF(G12=0,\"\",G12)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I12,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I12,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E12=\"\",取込勘定科目!$B$9,IF(E12=0,取込勘定科目!$B$9,データ貼付!F12))","v":"現金"},{"$f":"IF(E12=\"\",取込勘定科目!$B$18,IF(E12=0,取込勘定科目!$B$18,IF(G12=0,\"\",G12)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L12,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L12,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},1580,"事務所花　大崎生花店","2015/05/08"]
[null,"2015-05-09","コピー代",30,null,null,null,null,{"$f":"IF(D13=\"\",取込勘定科目!$B$9,IF(D13=0,取込勘定科目!$B$9,データ貼付!F13))","v":0},{"$f":"IF(D13=\"\",取込勘定科目!$B$18,IF(D13=0,取込勘定科目!$B$18,IF(G13=0,\"\",G13)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I13,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I13,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E13=\"\",取込勘定科目!$B$9,IF(E13=0,取込勘定科目!$B$9,データ貼付!F13))","v":"現金"},{"$f":"IF(E13=\"\",取込勘定科目!$B$18,IF(E13=0,取込勘定科目!$B$18,IF(G13=0,\"\",G13)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L13,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L13,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},30,"コピー代","2015/05/09"]
[null,"2015-05-10","御影－大阪　京急電車",540,null,null,null,null,{"$f":"IF(D14=\"\",取込勘定科目!$B$9,IF(D14=0,取込勘定科目!$B$9,データ貼付!F14))","v":0},{"$f":"IF(D14=\"\",取込勘定科目!$B$18,IF(D14=0,取込勘定科目!$B$18,IF(G14=0,\"\",G14)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I14,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I14,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E14=\"\",取込勘定科目!$B$9,IF(E14=0,取込勘定科目!$B$9,データ貼付!F14))","v":"現金"},{"$f":"IF(E14=\"\",取込勘定科目!$B$18,IF(E14=0,取込勘定科目!$B$18,IF(G14=0,\"\",G14)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L14,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L14,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},540,"御影－大阪　京急電車","2015/05/10"]
[null,"2015-05-11","タクシー　竹村交通",760,null,null,null,null,{"$f":"IF(D15=\"\",取込勘定科目!$B$9,IF(D15=0,取込勘定科目!$B$9,データ貼付!F15))","v":0},{"$f":"IF(D15=\"\",取込勘定科目!$B$18,IF(D15=0,取込勘定科目!$B$18,IF(G15=0,\"\",G15)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I15,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I15,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E15=\"\",取込勘定科目!$B$9,IF(E15=0,取込勘定科目!$B$9,データ貼付!F15))","v":"現金"},{"$f":"IF(E15=\"\",取込勘定科目!$B$18,IF(E15=0,取込勘定科目!$B$18,IF(G15=0,\"\",G15)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L15,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L15,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},760,"タクシー　竹村交通","2015/05/11"]
[null,"2015-05-12","JR",2500,null,null,null,null,{"$f":"IF(D16=\"\",取込勘定科目!$B$9,IF(D16=0,取込勘定科目!$B$9,データ貼付!F16))","v":0},{"$f":"IF(D16=\"\",取込勘定科目!$B$18,IF(D16=0,取込勘定科目!$B$18,IF(G16=0,\"\",G16)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I16,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I16,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E16=\"\",取込勘定科目!$B$9,IF(E16=0,取込勘定科目!$B$9,データ貼付!F16))","v":"現金"},{"$f":"IF(E16=\"\",取込勘定科目!$B$18,IF(E16=0,取込勘定科目!$B$18,IF(G16=0,\"\",G16)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L16,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L16,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},2500,"JR","2015/05/12"]
[null,"2015-05-13","接待飲食　京都の家族",5400,null,null,null,null,{"$f":"IF(D17=\"\",取込勘定科目!$B$9,IF(D17=0,取込勘定科目!$B$9,データ貼付!F17))","v":0},{"$f":"IF(D17=\"\",取込勘定科目!$B$18,IF(D17=0,取込勘定科目!$B$18,IF(G17=0,\"\",G17)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I17,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I17,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E17=\"\",取込勘定科目!$B$9,IF(E17=0,取込勘定科目!$B$9,データ貼付!F17))","v":"現金"},{"$f":"IF(E17=\"\",取込勘定科目!$B$18,IF(E17=0,取込勘定科目!$B$18,IF(G17=0,\"\",G17)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L17,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L17,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},5400,"接待飲食　京都の家族","2015/05/13"]
[null,"2015-05-14","接待飲食　スナックYourMitsuko",25000,null,null,null,null,{"$f":"IF(D18=\"\",取込勘定科目!$B$9,IF(D18=0,取込勘定科目!$B$9,データ貼付!F18))","v":0},{"$f":"IF(D18=\"\",取込勘定科目!$B$18,IF(D18=0,取込勘定科目!$B$18,IF(G18=0,\"\",G18)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I18,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I18,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E18=\"\",取込勘定科目!$B$9,IF(E18=0,取込勘定科目!$B$9,データ貼付!F18))","v":"現金"},{"$f":"IF(E18=\"\",取込勘定科目!$B$18,IF(E18=0,取込勘定科目!$B$18,IF(G18=0,\"\",G18)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L18,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L18,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},25000,"接待飲食　スナックYourMitsuko","2015/05/14"]
[null,"2015-05-15","バス　",240,null,null,null,null,{"$f":"IF(D19=\"\",取込勘定科目!$B$9,IF(D19=0,取込勘定科目!$B$9,データ貼付!F19))","v":0},{"$f":"IF(D19=\"\",取込勘定科目!$B$18,IF(D19=0,取込勘定科目!$B$18,IF(G19=0,\"\",G19)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I19,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I19,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E19=\"\",取込勘定科目!$B$9,IF(E19=0,取込勘定科目!$B$9,データ貼付!F19))","v":"現金"},{"$f":"IF(E19=\"\",取込勘定科目!$B$18,IF(E19=0,取込勘定科目!$B$18,IF(G19=0,\"\",G19)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L19,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L19,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},240,"バス　","2015/05/15"]
[null,"2015-05-16","打ち合わせ　中川珈琲店",1080,null,null,null,null,{"$f":"IF(D20=\"\",取込勘定科目!$B$9,IF(D20=0,取込勘定科目!$B$9,データ貼付!F20))","v":0},{"$f":"IF(D20=\"\",取込勘定科目!$B$18,IF(D20=0,取込勘定科目!$B$18,IF(G20=0,\"\",G20)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I20,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I20,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E20=\"\",取込勘定科目!$B$9,IF(E20=0,取込勘定科目!$B$9,データ貼付!F20))","v":"現金"},{"$f":"IF(E20=\"\",取込勘定科目!$B$18,IF(E20=0,取込勘定科目!$B$18,IF(G20=0,\"\",G20)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L20,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L20,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},1080,"打ち合わせ　中川珈琲店","2015/05/16"]
[null,"2015-05-17","弥生文具　領収書１０冊",4200,null,null,null,null,{"$f":"IF(D21=\"\",取込勘定科目!$B$9,IF(D21=0,取込勘定科目!$B$9,データ貼付!F21))","v":0},{"$f":"IF(D21=\"\",取込勘定科目!$B$18,IF(D21=0,取込勘定科目!$B$18,IF(G21=0,\"\",G21)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I21,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I21,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E21=\"\",取込勘定科目!$B$9,IF(E21=0,取込勘定科目!$B$9,データ貼付!F21))","v":"現金"},{"$f":"IF(E21=\"\",取込勘定科目!$B$18,IF(E21=0,取込勘定科目!$B$18,IF(G21=0,\"\",G21)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L21,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L21,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},4200,"弥生文具　領収書１０冊","2015/05/17"]
[null,"2015-05-18","収入印紙  城西郵便局",20000,null,null,null,null,{"$f":"IF(D22=\"\",取込勘定科目!$B$9,IF(D22=0,取込勘定科目!$B$9,データ貼付!F22))","v":0},{"$f":"IF(D22=\"\",取込勘定科目!$B$18,IF(D22=0,取込勘定科目!$B$18,IF(G22=0,\"\",G22)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I22,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I22,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E22=\"\",取込勘定科目!$B$9,IF(E22=0,取込勘定科目!$B$9,データ貼付!F22))","v":"現金"},{"$f":"IF(E22=\"\",取込勘定科目!$B$18,IF(E22=0,取込勘定科目!$B$18,IF(G22=0,\"\",G22)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L22,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L22,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},20000,"収入印紙  城西郵便局","2015/05/18"]
[null,"2015-05-19","残業夜食代  そば処砂場　（弥生幸子）",3200,null,null,null,null,{"$f":"IF(D23=\"\",取込勘定科目!$B$9,IF(D23=0,取込勘定科目!$B$9,データ貼付!F23))","v":0},{"$f":"IF(D23=\"\",取込勘定科目!$B$18,IF(D23=0,取込勘定科目!$B$18,IF(G23=0,\"\",G23)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I23,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I23,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E23=\"\",取込勘定科目!$B$9,IF(E23=0,取込勘定科目!$B$9,データ貼付!F23))","v":"現金"},{"$f":"IF(E23=\"\",取込勘定科目!$B$18,IF(E23=0,取込勘定科目!$B$18,IF(G23=0,\"\",G23)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L23,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L23,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},3200,"残業夜食代  そば処砂場　（弥生幸子）","2015/05/19"]
[null,"2015-05-20","駐車場　早川",400,null,null,null,null,{"$f":"IF(D24=\"\",取込勘定科目!$B$9,IF(D24=0,取込勘定科目!$B$9,データ貼付!F24))","v":0},{"$f":"IF(D24=\"\",取込勘定科目!$B$18,IF(D24=0,取込勘定科目!$B$18,IF(G24=0,\"\",G24)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I24,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I24,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E24=\"\",取込勘定科目!$B$9,IF(E24=0,取込勘定科目!$B$9,データ貼付!F24))","v":"現金"},{"$f":"IF(E24=\"\",取込勘定科目!$B$18,IF(E24=0,取込勘定科目!$B$18,IF(G24=0,\"\",G24)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L24,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L24,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},400,"駐車場　早川","2015/05/20"]
[null,"2015-05-21","通勤定期代   城西バス",52500,null,null,null,null,{"$f":"IF(D25=\"\",取込勘定科目!$B$9,IF(D25=0,取込勘定科目!$B$9,データ貼付!F25))","v":0},{"$f":"IF(D25=\"\",取込勘定科目!$B$18,IF(D25=0,取込勘定科目!$B$18,IF(G25=0,\"\",G25)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I25,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I25,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E25=\"\",取込勘定科目!$B$9,IF(E25=0,取込勘定科目!$B$9,データ貼付!F25))","v":"現金"},{"$f":"IF(E25=\"\",取込勘定科目!$B$18,IF(E25=0,取込勘定科目!$B$18,IF(G25=0,\"\",G25)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L25,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L25,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},52500,"通勤定期代   城西バス","2015/05/21"]
[null,"2015-05-22","パーキング  市営駐車場（弥生幸子）",200,null,null,null,null,{"$f":"IF(D26=\"\",取込勘定科目!$B$9,IF(D26=0,取込勘定科目!$B$9,データ貼付!F26))","v":0},{"$f":"IF(D26=\"\",取込勘定科目!$B$18,IF(D26=0,取込勘定科目!$B$18,IF(G26=0,\"\",G26)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I26,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I26,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E26=\"\",取込勘定科目!$B$9,IF(E26=0,取込勘定科目!$B$9,データ貼付!F26))","v":"現金"},{"$f":"IF(E26=\"\",取込勘定科目!$B$18,IF(E26=0,取込勘定科目!$B$18,IF(G26=0,\"\",G26)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L26,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L26,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},200,"パーキング  市営駐車場（弥生幸子）","2015/05/22"]
[null,"2015-05-23","お茶菓子  セブンマート城西店（清水）",1000,null,null,null,null,{"$f":"IF(D27=\"\",取込勘定科目!$B$9,IF(D27=0,取込勘定科目!$B$9,データ貼付!F27))","v":0},{"$f":"IF(D27=\"\",取込勘定科目!$B$18,IF(D27=0,取込勘定科目!$B$18,IF(G27=0,\"\",G27)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I27,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I27,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E27=\"\",取込勘定科目!$B$9,IF(E27=0,取込勘定科目!$B$9,データ貼付!F27))","v":"現金"},{"$f":"IF(E27=\"\",取込勘定科目!$B$18,IF(E27=0,取込勘定科目!$B$18,IF(G27=0,\"\",G27)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L27,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L27,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},1000,"お茶菓子  セブンマート城西店（清水）","2015/05/23"]
[null,"2015-05-24","電車代　地下鉄（佐藤）",300,null,null,null,null,{"$f":"IF(D28=\"\",取込勘定科目!$B$9,IF(D28=0,取込勘定科目!$B$9,データ貼付!F28))","v":0},{"$f":"IF(D28=\"\",取込勘定科目!$B$18,IF(D28=0,取込勘定科目!$B$18,IF(G28=0,\"\",G28)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I28,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I28,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E28=\"\",取込勘定科目!$B$9,IF(E28=0,取込勘定科目!$B$9,データ貼付!F28))","v":"現金"},{"$f":"IF(E28=\"\",取込勘定科目!$B$18,IF(E28=0,取込勘定科目!$B$18,IF(G28=0,\"\",G28)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L28,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L28,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},300,"電車代　地下鉄（佐藤）","2015/05/24"]
[null,"2015-05-25","お茶等、コンビニストア",540,null,null,null,null,{"$f":"IF(D29=\"\",取込勘定科目!$B$9,IF(D29=0,取込勘定科目!$B$9,データ貼付!F29))","v":0},{"$f":"IF(D29=\"\",取込勘定科目!$B$18,IF(D29=0,取込勘定科目!$B$18,IF(G29=0,\"\",G29)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I29,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I29,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E29=\"\",取込勘定科目!$B$9,IF(E29=0,取込勘定科目!$B$9,データ貼付!F29))","v":"現金"},{"$f":"IF(E29=\"\",取込勘定科目!$B$18,IF(E29=0,取込勘定科目!$B$18,IF(G29=0,\"\",G29)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L29,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L29,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},540,"お茶等、コンビニストア","2015/05/25"]
[null,"2015-05-26","接待  割烹 よしの（弥生幸子）：景徳鎮",28000,null,null,null,null,{"$f":"IF(D30=\"\",取込勘定科目!$B$9,IF(D30=0,取込勘定科目!$B$9,データ貼付!F30))","v":0},{"$f":"IF(D30=\"\",取込勘定科目!$B$18,IF(D30=0,取込勘定科目!$B$18,IF(G30=0,\"\",G30)))","v":""},{"$f":"IF(ISERROR(VLOOKUP(I30,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(I30,勘定科目テーブル!$B:$C,2,FALSE))","v":""},{"$f":"IF(E30=\"\",取込勘定科目!$B$9,IF(E30=0,取込勘定科目!$B$9,データ貼付!F30))","v":"現金"},{"$f":"IF(E30=\"\",取込勘定科目!$B$18,IF(E30=0,取込勘定科目!$B$18,IF(G30=0,\"\",G30)))","v":" "},{"$f":"IF(ISERROR(VLOOKUP(L30,勘定科目テーブル!$B:$C,2,FALSE)),\"\",VLOOKUP(L30,勘定科目テーブル!$B:$C,2,FALSE))","v":"対象外"},28000,"接待  割烹 よしの（弥生幸子）：景徳鎮","2015/05/26"]

{"sheet":"データ基礎","index":3,"n_rows":22,"n_cols":25,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[2000,null,null,"2015/05/07","消耗品費","",null,"課対仕入込8%",1080,null,"現金"," ",null,"対象外",1080,null,"接着剤　今津文具店",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/07","新聞図書費","",null,"課対仕入込8%",5400,null,"現金"," ",null,"対象外",5400,null,"図録　多胡書店",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/08","会議費","",null,"課対仕入込8%",10500,null,"現金"," ",null,"対象外",10500,null,"打ち合わせ　松尾酒店",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/08","水道光熱費","",null,"課対仕入込8%",1580,null,"現金"," ",null,"対象外",1580,null,"事務所花　大崎生花店",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/09","新聞図書費","",null,"課対仕入込8%",30,null,"現金"," ",null,"対象外",30,null,"コピー代",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/10","旅費交通費","",null,"課対仕入込8%",540,null,"現金"," ",null,"対象外",540,null,"御影－大阪　京急電車",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/11","旅費交通費","",null,"課対仕入込8%",760,null,"現金"," ",null,"対象外",760,null,"タクシー　竹村交通",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/12","旅費交通費","",null,"課対仕入込8%",2500,null,"現金"," ",null,"対象外",2500,null,"JR",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/13","交際費","",null,"課対仕入込8%",5400,null,"現金"," ",null,"対象外",5400,null,"接待飲食　京都の家族",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/14","交際費","",null,"課対仕入込8%",25000,null,"現金"," ",null,"対象外",25000,null,"接待飲食　スナックYourMitsuko",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/15","旅費交通費","",null,"課対仕入込8%",240,null,"現金"," ",null,"対象外",240,null,"バス　",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/16","会議費","",null,"課対仕入込8%",1080,null,"現金"," ",null,"対象外",1080,null,"打ち合わせ　中川珈琲店",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/17","消耗品費","",null,"課対仕入込8%",4200,null,"現金"," ",null,"対象外",4200,null,"弥生文具　領収書１０冊",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/18","租税公課","",null,"対象外",20000,null,"現金"," ",null,"対象外",20000,null,"収入印紙  城西郵便局",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/19","福利厚生費","",null,"課対仕入込8%",3200,null,"現金"," ",null,"対象外",3200,null,"残業夜食代  そば処砂場　（弥生幸子）",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/20","旅費交通費","",null,"課対仕入込8%",400,null,"現金"," ",null,"対象外",400,null,"駐車場　早川",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/21","旅費交通費","",null,"課対仕入込8%",52500,null,"現金"," ",null,"対象外",52500,null,"通勤定期代   城西バス",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/22","旅費交通費","",null,"課対仕入込8%",200,null,"現金"," ",null,"対象外",200,null,"パーキング  市営駐車場（弥生幸子）",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/23","福利厚生費","",null,"課対仕入込8%",1000,null,"現金"," ",null,"対象外",1000,null,"お茶菓子  セブンマート城西店（清水）",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/24","旅費交通費","",null,"課対仕入込8%",300,null,"現金"," ",null,"対象外",300,null,"電車代　地下鉄（佐藤）",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/25","福利厚生費","",null,"課対仕入込8%",540,null,"現金"," ",null,"対象外",540,null,"お茶等、コンビニストア",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/26","交際費","",null,"課対仕入込8%",28000,null,"現金"," ",null,"対象外",28000,null,"接待  割烹 よしの（弥生幸子）：景徳鎮",null,null,0,null,null,null,null,"no"]

{"sheet":"弥生インポート形式仕訳日記帳","index":4,"n_rows":22,"n_cols":25,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[2000,null,null,"2015/05/07","消耗品費","",null,"課対仕入込8%",1080,null,"現金"," ",null,"対象外",1080,null,"接着剤　今津文具店",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/07","新聞図書費","",null,"課対仕入込8%",5400,null,"現金"," ",null,"対象外",5400,null,"図録　多胡書店",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/08","会議費","",null,"課対仕入込8%",10500,null,"現金"," ",null,"対象外",10500,null,"打ち合わせ　松尾酒店",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/08","水道光熱費","",null,"課対仕入込8%",1580,null,"現金"," ",null,"対象外",1580,null,"事務所花　大崎生花店",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/09","新聞図書費","",null,"課対仕入込8%",30,null,"現金"," ",null,"対象外",30,null,"コピー代",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/10","旅費交通費","",null,"課対仕入込8%",540,null,"現金"," ",null,"対象外",540,null,"御影－大阪　京急電車",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/11","旅費交通費","",null,"課対仕入込8%",760,null,"現金"," ",null,"対象外",760,null,"タクシー　竹村交通",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/12","旅費交通費","",null,"課対仕入込8%",2500,null,"現金"," ",null,"対象外",2500,null,"JR",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/13","交際費","",null,"課対仕入込8%",5400,null,"現金"," ",null,"対象外",5400,null,"接待飲食　京都の家族",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/14","交際費","",null,"課対仕入込8%",25000,null,"現金"," ",null,"対象外",25000,null,"接待飲食　スナックYourMitsuko",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/15","旅費交通費","",null,"課対仕入込8%",240,null,"現金"," ",null,"対象外",240,null,"バス　",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/16","会議費","",null,"課対仕入込8%",1080,null,"現金"," ",null,"対象外",1080,null,"打ち合わせ　中川珈琲店",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/17","消耗品費","",null,"課対仕入込8%",4200,null,"現金"," ",null,"対象外",4200,null,"弥生文具　領収書１０冊",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/18","租税公課","",null,"対象外",20000,null,"現金"," ",null,"対象外",20000,null,"収入印紙  城西郵便局",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/19","福利厚生費","",null,"課対仕入込8%",3200,null,"現金"," ",null,"対象外",3200,null,"残業夜食代  そば処砂場　（弥生幸子）",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/20","旅費交通費","",null,"課対仕入込8%",400,null,"現金"," ",null,"対象外",400,null,"駐車場　早川",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/21","旅費交通費","",null,"課対仕入込8%",52500,null,"現金"," ",null,"対象外",52500,null,"通勤定期代   城西バス",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/22","旅費交通費","",null,"課対仕入込8%",200,null,"現金"," ",null,"対象外",200,null,"パーキング  市営駐車場（弥生幸子）",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/23","福利厚生費","",null,"課対仕入込8%",1000,null,"現金"," ",null,"対象外",1000,null,"お茶菓子  セブンマート城西店（清水）",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/24","旅費交通費","",null,"課対仕入込8%",300,null,"現金"," ",null,"対象外",300,null,"電車代　地下鉄（佐藤）",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/25","福利厚生費","",null,"課対仕入込8%",540,null,"現金"," ",null,"対象外",540,null,"お茶等、コンビニストア",null,null,0,null,null,null,null,"no"]
[2000,null,null,"2015/05/26","交際費","",null,"課対仕入込8%",28000,null,"現金"," ",null,"対象外",28000,null,"接待  割烹 よしの（弥生幸子）：景徳鎮",null,null,0,null,null,null,null,"no"]

{"sheet":"摘要→勘定科目テーブル","index":5,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"摘要に含まれる文字","勘定科目","補助科目"]
[null,"売上","売上高"]
[null,"打ち合わせ","会議費"]
[null,"接待","交際費"]
[null,"歳暮","交際費"]
[null,"中元","交際費"]
[null,"土産","交際費"]
[null,"ゴルフ","交際費"]
[null,"香典","交際費"]
[null,"文具","消耗品費"]
[null,"書店","新聞図書費"]
[null,"新聞","新聞図書費"]
[null,"水道","水道光熱費"]
[null,"電気","水道光熱費"]
[null,"ガス","水道光熱費"]
[null,"収入印紙","租税公課"]
[null,"切手","通信費"]
[null,"NTT","通信費"]
[null,"NHK","通信費"]
[null,"携帯電話","通信費"]
[null,"お茶","福利厚生費"]
[null,"菓子","福利厚生費"]
[null,"夜食","福利厚生費"]
[null,"残業食事","福利厚生費"]
[null,"電車","旅費交通費"]
[null,"タクシー","旅費交通費"]
[null,"JR","旅費交通費"]
[null,"バス","旅費交通費"]
[null,"通勤","旅費交通費"]
[null,"駐車","旅費交通費"]

{"sheet":"勘定科目テーブル","index":6,"n_rows":150,"n_cols":7,"rows_kept":150,"cut":false,"hidden":false,"merged":[[96,5,100,5],[101,5,105,5],[41,5,45,5],[46,5,50,5],[51,5,55,5],[56,5,60,5],[61,5,65,5],[66,5,70,5],[71,5,75,5],[76,5,80,5],[81,5,85,5],[86,5,90,5],[10,5,14,5],[15,5,19,5],[20,5,24,5],[25,5,29,5],[91,5,95,5]]}
[]
[]
[]
[]
[]
[]
[]
[null,"勘定科目","税区分",null,null,"※消費税税区分一覧"]
[null,"現金","対象外",null,null,"取引の種類","税区分名"]
[null,"当座預金","対象外",null,null,"消費税と無関係な取引（不課税取引）","対象外"]
[null,"普通預金","対象外",null,null,"課税売上※","課税売上"]
[null,"定期預金","対象外",null,null,null,"課税売上10%"]
[null,"定期積金","対象外",null,null,null,"課税売上8%（軽）"]
[null,"郵便貯金","対象外",null,null,null,"課税売上8%"]
[null,"受取手形","対象外",null,null,null,"課税売上5%"]
[null,"売掛金","対象外",null,null,"課税売上にかかわる対価の返還※","課税売返"]
[null,"有価証券","対象外",null,null,null,"課税売返10%"]
[null,"前渡金","対象外",null,null,null,"課税売返8%（軽）"]
[null,"立替金","対象外",null,null,null,"課税売返8%"]
[null,"前払費用","対象外",null,null,null,"課税売返5%"]
[null,"未収収益","対象外",null,null,"課税売上にかかわる対価の貸倒※","課税売倒"]
[null,"短期貸付金","対象外",null,null,null,"課税売倒10%"]
[null,"未収入金","対象外",null,null,null,"課税売倒8%（軽）"]
[null,"仮払金","対象外",null,null,null,"課税売倒8%"]
[null,"預け金","対象外",null,null,null,"課税売倒5%"]
[null,"建物","課対仕入10%",null,null,"課税売上にかかわる貸倒分の回収※","課税売回"]
[null,"附属設備","課対仕入10%",null,null,null,"課税売回10%"]
[null,"構築物","課対仕入10%",null,null,null,"課税売回8%（軽）"]
[null,"機械装置","課対仕入10%",null,null,null,"課税売回8%"]
[null,"車両運搬具","課対仕入10%",null,null,null,"課税売回5%"]
[null,"工具器具備品","課対仕入10%",null,null,"輸出免税売上","輸出売上"]
[null,"土地","対象外",null,null,"輸出免税売上にかかわる対価の返還","輸出売返"]
[null,"建設仮勘定","対象外",null,null,"輸出免税売上にかかわる貸倒","輸出売倒"]
[null,"ソフトウェア","課対仕入10%",null,null,"非課税売上","非課売上"]
[null,"投資有価証券","対象外",null,null,"非課税売上にかかわる対価の返還","非課売返"]
[null,"出資金","対象外",null,null,"非課税売上にかかわる貸倒","非課売倒"]
[null,"敷金","対象外",null,null,"非課税資産の輸出等","非資輸出"]
[null,"差入保証金","対象外",null,null,"非課税資産の輸出等にかかわる対価の返還","非資輸返"]
[null,"長期貸付金","対象外",null,null,"非課税資産の輸出等にかかわる貸倒","非資輸倒"]
[null,"長期前払費用","対象外",null,null,"消費税と無関係な売上（不課税取引）","対外売上"]
[null,"預託金","対象外",null,null,"有価証券の譲渡","有価譲渡"]
[null,"支払手形","対象外",null,null,"課税仕入※","課対仕入"]
[null,"買掛金","対象外",null,null,null,"課対仕入10%"]
[null,"短期借入金","対象外",null,null,null,"課対仕入8%（軽）"]
[null,"未払金","対象外",null,null,null,"課対仕入8%"]
[null,"未払費用","対象外",null,null,null,"課対仕入5%"]
[null,"未払法人税等","対象外",null,null,"課税仕入にかかわる対価の返還※","課対仕返"]
[null,"未払消費税等","対象外",null,null,null,"課対仕返10%"]
[null,"前受金","対象外",null,null,null,"課対仕返8%（軽）"]
[null,"預り金","対象外",null,null,null,"課対仕返8%"]
[null,"前受収益","対象外",null,null,null,"課対仕返5%"]
[null,"仮受金","対象外",null,null,"非課税売上に対応する課税仕入※","非対仕入"]
[null,"預り保証金","対象外",null,null,null,"非対仕入10%"]
[null,"長期借入金","対象外",null,null,null,"非対仕入8%（軽）"]
[null,"長期未払金","対象外",null,null,null,"非対仕入8%"]
[null,"売上高","課税売上10%",null,null,null,"非対仕入5%"]
[null,"仕入高","課対仕入10%",null,null,"非課税売上に対応する課税仕入の対価の返還※","非対仕返"]
[null,"役員報酬","対象外",null,null,null,"非対仕返10%"]
[null,"役員賞与","対象外",null,null,null,"非対仕返8%（軽）"]
[null,"給料手当","対象外",null,null,null,"非対仕返8%"]
[null,"雑給","対象外",null,null,null,"非対仕返5%"]
[null,"賞与","対象外",null,null,"課税・非課税売上に共通対応する課税仕入※","共対仕入"]
[null,"退職金","対象外",null,null,null,"共対仕入10%"]
[null,"法定福利費","対象外",null,null,null,"共対仕入8%（軽）"]
[null,"福利厚生費","課対仕入10%",null,null,null,"共対仕入8%"]
[null,"採用教育費","課対仕入10%",null,null,null,"共対仕入5%"]
[null,"外注費","課対仕入10%",null,null,"課税・非課税売上に共通対応する課税仕入の対価の返還※","共対仕返"]
[null,"荷造運賃","課対仕入10%",null,null,null,"共対仕返10%"]
[null,"広告宣伝費","課対仕入10%",null,null,null,"共対仕返8%（軽）"]
[null,"交際費","課対仕入10%",null,null,null,"共対仕返8%"]
[null,"会議費","課対仕入10%",null,null,null,"共対仕返5%"]
[null,"旅費交通費","課対仕入10%",null,null,"課税売上に対応する課税貨物※","課対輸本"]
[null,"通信費","課対仕入10%",null,null,null,"課対輸本7.8%"]
[null,"販売手数料","課対仕入10%",null,null,null,"課対輸本6.24%（軽）"]
[null,"販売促進費","課対仕入10%",null,null,null,"課対輸本6.3%"]
[null,"消耗品費","課対仕入10%",null,null,null,"課対輸本4%"]
[null,"事務用品費","課対仕入10%",null,null,"非課税売上に対応する課税貨物※","非対輸本"]
[null,"修繕費","課対仕入10%",null,null,null,"非対輸本7.8%"]
[null,"水道光熱費","課対仕入10%",null,null,null,"非対輸本6.24%（軽）"]
[null,"新聞図書費","課対仕入10%",null,null,null,"非対輸本6.3%"]
[null,"諸会費","対象外",null,null,null,"非対輸本4%"]
[null,"支払手数料","課対仕入10%",null,null,"課税・非課税に共通対応する課税貨物※","共対輸本"]
[null,"車両費","課対仕入10%",null,null,null,"共対輸本7.8%"]
[null,"地代家賃","課対仕入10%",null,null,null,"共対輸本6.24%（軽）"]
[null,"賃借料","課対仕入10%",null,null,null,"共対輸本6.3%"]
[null,"リース料","課対仕入10%",null,null,null,"共対輸本4%"]
[null,"保険料","対象外",null,null,"課税貨物の消費税※","課対輸税"]
[null,"租税公課","対象外",null,null,null,"課対輸税7.8%"]
[null,"支払報酬料","課対仕入10%",null,null,null,"課対輸税6.24%（軽）"]
[null,"寄付金","対象外",null,null,null,"課対輸税6.3%"]
[null,"研究開発費","課対仕入10%",null,null,null,"課対輸税4%"]
[null,"雑費","課対仕入10%",null,null,"非課税貨物の消費税※","非対輸税"]
[null,"受取利息","非課売上",null,null,null,"非対輸税7.8%"]
[null,"受取配当金","対象外",null,null,null,"非対輸税6.24%（軽）"]
[null,"雑収入","課対仕入10%",null,null,null,"非対輸税6.3%"]
[null,"支払利息","対象外",null,null,null,"非対輸税4%"]
[null,"割引料","対象外",null,null,"課税・非課税に共通対応する課税貨物の消費税※","共対輸税"]
[null,"手形売却損","対象外",null,null,null,"共対輸税7.8%"]
[null,"貸倒損失(外)","課税売倒10%",null,null,null,"共対輸税6.24%（軽）"]
[null,"売上割引","課税売返10%",null,null,null,"共対輸税6.3%"]
[null,"雑損失","課対仕入10%",null,null,null,"共対輸税4%"]
[null,"法人税、住民税及び事業税","対象外",null,null,"地方消費税貨物割※","地消貨割"]
[null,"法人税等","対象外",null,null,null,"地消貨割2.2%"]
[null,"[製]材料仕入高","課対仕入10%",null,null,null,"地消貨割1.76%（軽）"]
[null,"[製]役員報酬","対象外",null,null,null,"地消貨割1.7%"]
[null,"[製]給料手当","対象外",null,null,null,"地消貨割1%"]
[null,"[製]雑給","対象外",null,null,"非課税仕入","非課仕入"]
[null,"[製]賞与","対象外",null,null,"消費税と無関係な仕入（不課税取引）","対外仕入"]
[null,"[製]退職金","対象外",null,null,"税区分が不明な取引","不明"]
[null,"[製]法定福利費","対象外"]
[null,"[製]福利厚生費","課対仕入10%"]
[null,"[製]外注加工費","課対仕入10%"]
[null,"[製]動力費","課対仕入10%"]
[null,"[製]荷造運賃","課対仕入10%"]
[null,"[製]会議費","課対仕入10%"]
[null,"[製]旅費交通費","課対仕入10%"]
[null,"[製]通信費","課対仕入10%"]
[null,"[製]消耗品費","課対仕入10%"]
[null,"[製]事務用品費","課対仕入10%"]
[null,"[製]消耗工具費","課対仕入10%"]
[null,"[製]車両費","課対仕入10%"]
[null,"[製]修繕費","課対仕入10%"]
[null,"[製]水道光熱費","課対仕入10%"]
[null,"[製]新聞図書費","課対仕入10%"]
[null,"[製]諸会費","対象外"]
[null,"[製]地代家賃","課対仕入10%"]
[null,"[製]賃借料","課対仕入10%"]
[null,"[製]租税公課","対象外"]
[null,"[製]保険料","対象外"]
[null,"[製]支払報酬料","課対仕入10%"]
[null,"[製]寄付金","対象外"]
[null,"[製]研究開発費","課対仕入10%"]
[null,"[製]保管料","課対仕入10%"]
[null,"[製]特許使用料","課対仕入10%"]
[null,"[製]雑費","課対仕入10%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"未確定勘定","対象外"]