{"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":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,3,12],[7,4,7,13],[9,4,9,13],[5,4,5,13]]}
[]
[]
[]
[]
[]
[null,null,null,null,"会計王の仕訳日記帳から、弥生インポート形式の仕訳日記帳を生成します。\n（※会計王の仕訳日記帳は、出力形式は「可変長」、「区切り文字（カンマ）」、「項目の引用符（''）」、「出力項目（全項目）」で出力します）"]
[]
[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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"データ基礎","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"弥生インポート形式仕訳日記帳","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"勘定科目テーブル","index":4,"n_rows":303,"n_cols":5,"rows_kept":303,"cut":false,"hidden":false,"merged":[[10,1,10,2],[10,3,11,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"会計王",null,null,"弥生会計"]
[null,"勘定科目コード","勘定科目",null,"勘定科目"]
[null,100,"現      金","→","現金"]
[null,102,"小口  現金","→","小口現金"]
[null,104,"当座  預金","→","当座預金"]
[null,106,"普通  預金","→","普通預金"]
[null,108,"通知  預金","→","通知預金"]
[null,110,"定期  預金","→","定期預金"]
[null,112,"定期  積金","→","定期積金"]
[null,114,"別段  預金","→","別段預金"]
[null,115,"その他預金","→","その他の預金"]
[null,130,"受取  手形","→","受取手形"]
[null,132,"不渡  手形","→","不渡手形"]
[null,134,"売  掛  金","→","売掛金"]
[null,135,"未収賃貸料","→","未収賃貸料"]
[null,136,"貸倒引当金","→","貸倒引当金(売)"]
[null,140,"有価  証券","→","有価証券"]
[null,150,"商      品","→","商品"]
[null,152,"製      品","→","製品"]
[null,154,"半  製  品","→","半製品"]
[null,156,"仕  掛  品","→","仕掛品"]
[null,158,"原  材  料","→","原材料"]
[null,160,"貯  蔵  品","→","貯蔵品"]
[null,162,"副産物  等","→","副産物作業くず"]
[null,164,"棚卸  資産","→"]
[null,170,"前  渡  金","→","前渡金"]
[null,172,"前払  費用","→","前払費用"]
[null,173,"前  払  金","→","前払金"]
[null,174,"未収  収益","→","未収収益"]
[null,176,"立  替  金","→","立替金"]
[null,178,"仮  払  金","→","仮払金"]
[null,179,"仮払  税金","→","仮払消費税"]
[null,180,"短期貸付金","→","短期貸付金"]
[null,182,"未収入金","→","未収入金"]
[null,184,"差入保証金","→"]
[null,190,"繰延税資産","→","繰延税金資産(流)"]
[null,194,"貸倒引当金","→","貸倒引当金(他)"]
[null,195,"仮払消費税","→","仮払消費税"]
[null,200,"建      物","→","建物"]
[null,202,"建物附属設","→","附属設備"]
[null,204,"構  築  物","→","構築物"]
[null,206,"機械  装置","→","機械装置"]
[null,208,"車両運搬具","→","車両運搬具"]
[null,209,"船      舶","→","船舶"]
[null,212,"工具・備品","→","工具器具備品"]
[null,220,"減価累計額","→","減価償却累計額"]
[null,222,"土      地","→","土地"]
[null,224,"建設仮勘定","→","建設仮勘定"]
[null,230,"電話加入権","→","電話加入権"]
[null,232,"工業所有権","→","工業所有権"]
[null,234,"借  地  権","→","借地権"]
[null,250,"投資有価証","→","投資有価証券"]
[null,252,"子会社株式","→"]
[null,254,"出  資  金","→","出資金"]
[null,256,"敷      金","→","敷金"]
[null,258,"長期貸付金","→","長期貸付金"]
[null,266,"長期前払費","→","長期前払費用"]
[null,268,"長期固定預","→","長期固定性預金"]
[null,280,"貸倒引当金","→","貸倒引当金(投)"]
[null,281,"繰延税資産","→","繰延税金資産(固)"]
[null,290,"創立開業費","→"]
[null,291,"施設負担金","→","公共施設負担金"]
[null,292,"繰延  資産","→"]
[null,299,"事業主  貸","→","事業主貸"]
[null,300,"買  掛  金","→","買掛金"]
[null,302,"支払  手形","→","支払手形"]
[null,306,"未  払  金","→","未払金"]
[null,308,"未払  費用","→","未払費用"]
[null,310,"前  受  金","→","前受金"]
[null,320,"短期借入金","→","短期借入金"]
[null,322,"預  り  金","→","預り金"]
[null,324,"従業員預金","→"]
[null,326,"預り保証金","→","預り保証金"]
[null,328,"前受  収益","→","前受収益"]
[null,330,"仮  受  金","→","仮受金"]
[null,336,"割引  手形","→","割引手形"]
[null,338,"裏書  手形","→","裏書手形"]
[null,340,"賞与引当金","→"]
[null,350,"未払法人税","→","未払法人税等"]
[null,352,"未払事業税","→","未払事業税等"]
[null,354,"未払消費税","→","未払消費税等"]
[null,355,"納税充当金","→"]
[null,357,"貸倒引当金","→"]
[null,358,"繰延税負債","→","繰延税金負債(流)"]
[null,360,"仮受消費税","→","仮受消費税"]
[null,370,"長期借入金","→","長期借入金"]
[null,374,"長期未払金","→","長期未払金"]
[null,380,"退職引当金","→","退職給付引当金"]
[null,385,"繰延税負債","→","繰延税金負債(固)"]
[null,390,"事業主  借","→","事業主借"]
[null,400,"資  本  金","→","資本金"]
[null,401,"元  入  金","→","元入金"]
[null,402,"新株申込金","→","新株式申込証拠金"]
[null,410,"資本準備金","→","資本準備金"]
[null,415,"他資本剰余","→"]
[null,420,"利益準備金","→","利益準備金"]
[null,430,"任意積立金","→"]
[null,440,"別途積立金","→","別途積立金"]
[null,442,"圧縮積立金","→"]
[null,450,"自己  株式","→","自己株式"]
[null,452,"自己株申金","→","自己株式申込証拠金"]
[null,460,"他有評価差","→","その他有価証券評価差額金"]
[null,462,"繰ﾍｯｼﾞ損益","→","繰延ヘッジ損益"]
[null,464,"土地再評差","→","土地再評価差額金"]
[null,470,"新株予約権","→","新株予約権"]
[null,490,"繰越利益金","→"]
[null,500,"売  上  高","→","売上高"]
[null,501,"売 上 高１","→","売上高"]
[null,502,"売 上 高２","→","売上高"]
[null,503,"売 上 高３","→","売上高"]
[null,504,"家事  消費","→","家事消費等"]
[null,510,"賃  貸  料","→","賃貸料"]
[null,512,"礼金権利金","→","礼金･権利金"]
[null,514,"名義書換料","→","名義書換料"]
[null,520,"売上値引高","→","売上値引高"]
[null,526,"売上値引戻","→"]
[null,540,"売上割戻高","→","売上割戻し高"]
[null,550,"売上戻り高","→","売上戻り高"]
[null,600,"期首商棚卸","→","期首商品棚卸高"]
[null,601,"首商製棚卸","→"]
[null,602,"期首製棚卸","→","期首製品棚卸高"]
[null,610,"仕  入  高","→","仕入高"]
[null,611,"仕 入 高１","→","仕入高"]
[null,612,"仕 入 高２","→","仕入高"]
[null,613,"仕 入 高３","→","仕入高"]
[null,622,"他勘定振替","→","他勘定振替高(商)"]
[null,624,"仕入値引高","→","仕入値引高"]
[null,625,"仕入値引戻","→"]
[null,630,"仕入割戻高","→","仕入割戻し高"]
[null,634,"仕入戻し高","→","仕入戻し高"]
[null,640,"期末商棚卸","→","期末商品棚卸高"]
[null,641,"末商製棚卸","→"]
[null,646,"期末製棚卸","→","期末製品棚卸高"]
[null,700,"給料  手当","→","給料手当"]
[null,701,"給料  賃金","→"]
[null,702,"役員  報酬","→","役員報酬"]
[null,704,"外注費","→","外注費"]
[null,706,"賞      与","→","賞与"]
[null,707,"役員  賞与","→","役員賞与"]
[null,710,"退  職  金","→","退職金"]
[null,712,"退職金掛金","→","退職金掛金"]
[null,716,"法定福利費","→","法定福利費"]
[null,718,"福利厚生費","→","福利厚生費"]
[null,720,"外  注  費","→","外注費"]
[null,722,"通  信  費","→","通信費"]
[null,723,"新聞図書費","→","新聞図書費"]
[null,724,"荷造  運賃","→","荷造運賃"]
[null,726,"水道光熱費","→","水道光熱費"]
[null,728,"旅費交通費","→","旅費交通費"]
[null,730,"出張費","→","出張費"]
[null,732,"販売促進費","→","販売促進費"]
[null,734,"接待交際費","→","交際費"]
[null,736,"会  議  費","→","会議費"]
[null,738,"事務消耗品","→","事務用品費"]
[null,740,"備品消耗品","→","消耗品費"]
[null,741,"消耗品  費","→","消耗品費"]
[null,742,"新聞図書費","→","新聞図書費"]
[null,744,"修  繕  費","→","修繕費"]
[null,746,"地代  家賃","→","地代家賃"]
[null,750,"車両燃料費","→"]
[null,752,"保  険  料","→","保険料"]
[null,754,"損害保険料","→","損害保険料"]
[null,756,"租税  公課","→","租税公課"]
[null,758,"諸  会  費","→","諸会費"]
[null,760,"リース  料","→","リース料"]
[null,762,"支払手数料","→","支払手数料"]
[null,764,"寄  付  金","→","寄付金"]
[null,776,"減価償却費","→","減価償却費"]
[null,780,"貸倒引当繰","→","貸倒繰入額(販)"]
[null,782,"貸倒  損失","→","貸倒損失(販)"]
[null,790,"雑      費","→","雑費"]
[null,800,"期首材棚卸","→","[製]期首材料棚卸高"]
[null,801,"期首材棚卸","→","[製]期首材料棚卸高"]
[null,802,"期首材棚卸","→","[製]期首材料棚卸高"]
[null,810,"材料仕入高","→","[製]材料仕入高"]
[null,811,"材料仕入１","→","[製]材料仕入高"]
[null,812,"材料仕入２","→","[製]材料仕入高"]
[null,820,"材料値引高","→"]
[null,822,"材料割戻高","→"]
[null,823,"材料値引戻","→"]
[null,828,"材料戻り高","→"]
[null,830,"期末材棚卸","→","[製]期末材料棚卸高"]
[null,831,"期末材棚卸","→","[製]期末材料棚卸高"]
[null,832,"期末材棚卸","→","[製]期末材料棚卸高"]
[null,840,"給料  手当","→","[製]給料手当"]
[null,842,"賃      金","→"]
[null,844,"雑      給","→","[製]雑給"]
[null,846,"賞      与","→","[製]賞与"]
[null,850,"退職金掛金","→","[製]退職金掛金"]
[null,852,"退  職  金","→","[製]退職金"]
[null,854,"法定福利費","→","[製]法定福利費"]
[null,856,"福利厚生費","→","[製]福利厚生費"]
[null,860,"外注加工費","→","[製]外注加工費"]
[null,861,"外注加工費","→","[製]外注加工費"]
[null,862,"外注加工費","→","[製]外注加工費"]
[null,867,"動力光熱費","→","[製]動力費"]
[null,868,"電  力  費","→","[製]電力費"]
[null,869,"水道光熱費","→","[製]水道光熱費"]
[null,870,"荷造  運賃","→","[製]荷造運賃"]
[null,872,"修  繕  費","→","[製]修繕費"]
[null,874,"賃  借  料","→","[製]賃借料"]
[null,876,"地代  家賃","→","[製]地代家賃"]
[null,878,"保  険  料","→","[製]保険料"]
[null,880,"租税  公課","→","[製]租税公課"]
[null,882,"減価償却費","→","[製]減価償却費"]
[null,884,"通  信  費","→","[製]通信費"]
[null,886,"消耗品  費","→","[製]消耗品費"]
[null,888,"旅費交通費","→","[製]旅費交通費"]
[null,890,"車両燃料費","→"]
[null,891,"保  管  料","→","[製]保管料"]
[null,892,"特許権使料","→","[製]特許使用料"]
[null,893,"棚卸減耗損","→","[製]棚卸減耗損"]
[null,894,"雑      費","→","[製]雑費"]
[null,898,"首仕掛棚卸","→","[製]期首仕掛品"]
[null,899,"末仕掛棚卸","→","[製]期末仕掛品"]
[null,900,"受取  利息","→","受取利息"]
[null,902,"受取配当金","→","受取配当金"]
[null,904,"仕入  割引","→","仕入割引"]
[null,906,"有証売却益","→","有価証券売却益"]
[null,908,"受取  家賃","→"]
[null,910,"雑  収  入","→","雑収入"]
[null,920,"支払  利息","→","支払利息"]
[null,922,"支払割引料","→","割引料"]
[null,923,"利子割引料","→"]
[null,924,"売上  割引","→","売上割引"]
[null,926,"有証売却損","→","有価証券売却損"]
[null,928,"繰延資償却","→","繰延資産償却(外)"]
[null,950,"固資産売益","→","固定資産売却益"]
[null,952,"投有価売益","→","投資有価証券売却益"]
[null,954,"貸倒引当戻","→","貸倒引当金戻入"]
[null,956,"前期修正益","→","前期損益修正益"]
[null,960,"固資産売損","→","固定資産売却損"]
[null,962,"固資産除損","→","固定資産除却損"]
[null,964,"投有価売損","→","投資有価証券売却損"]
[null,966,"前期修正損","→","前期損益修正損"]
[null,967,"専従者給与","→","専従者給与"]
[null,968,"貸倒引当繰","→","貸倒引当金繰入"]
[null,970,"雑  損  失","→","雑損失"]
[null,980,"法人住民税","→","法人税･住民税及び事業税"]
[null,981,"法人税調整","→","法人税等調整額"]
[null,982,"前繰越利益","→","繰越利益"]
[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,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,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,"→"]
[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,null,"→"]
[null,null,null,"→"]
[null,null,null,"→"]
[null,null,null,"→"]
[null,null,null,"→"]
[null,null,null,"→"]

{"sheet":"課税区分テーブル","index":5,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,2,11,2],[10,6,11,6],[10,10,11,10],[10,14,11,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"会計王",null,"弥生会計",null,"会計王",null,"弥生会計",null,"会計王",null,"弥生会計",null,"会計王",null,"弥生会計"]
[null,"課税区分",null,"課税区分",null,"税率",null,"税率",null,"事業区分",null,"事業区分",null,"税込・税抜",null,"税込・税抜"]
[null,0,"→","対象外",null,0.1,"→","10%",null,1,"→","一",null,"税込","→","込"]
[null,11,"→","課税売上",null,"8%軽","→","軽減8%",null,2,"→","二",null,"内税","→","内"]
[null,13,"→","非課売上",null,0.05,"→","5%",null,3,"→","三",null,"外税","→","外"]
[null,14,"→","輸出売上",null,0.08,"→","8%",null,4,"→","四",null,"別途入力","→","別"]
[null,15,"→","課税売返",null,null,"→",null,null,5,"→","五"]
[null,16,"→","非課売返",null,null,"→",null,null,6,"→","六"]
[null,17,"→","輸出売上",null,null,"→"]
[null,19,null,"非資輸出",null,null,"→"]
[null,21,"→","課対仕入",null,null,"→"]
[null,22,"→","非対仕入",null,null,"→"]
[null,23,"→","共対仕入",null,null,"→"]
[null,24,"→","非課仕入",null,null,"→"]
[null,25,"→","課対仕返",null,0,"→"]
[null,26,"→","非対仕返",null,null,"→"]
[null,27,"→","共対仕返"]
[null,30,"→","有価譲渡"]
[null,41,"→","課税売倒"]
[null,42,"→","非課売倒"]
[null,43,"→","輸出売倒"]
[null,99,"→","不明"]
[null,51,"→","課対輸本"]
[null,52,"→","非対輸本"]
[null,53,"→","共対輸本"]
[null,61,"→","課対輸税"]
[null,62,"→","非対輸税"]
[null,63,"→","共対輸税"]
[null,64,"→","地消貨割"]
[null,null,"→"]
[null,null,"→"]
[null,null,"→"]
[null,null,"→"]
[null,null,"→"]
[null,null,"→"]
[null,null,"→"]

{"sheet":"作業シート","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}