クエリ |
このシートには計算用データが含まれています。削除しないでください。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
共通 |
エクセル簿記バージョンを整数変換 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=VALUE(LEFT(はじめに!B3,1)) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
はじめに |
種別 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
gene |
agri |
real |
asset |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=IF(はじめに!B5=クエリ!B7,"一般用",IF(はじめに!B5=クエリ!C7,"農業用",IF(はじめに!B5=クエリ!D7,"不動産用",IF(はじめに!B5=クエリ!E7,"減価償却専用")))) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
期首月 |
日 |
から表示 |
期末月 |
日 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=IF(B14="","〜",IF(B14<C14,"〜 "&C14&"年","〜")) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
期首年 |
期末年 |
期末年のずれ有無 |
期首年月日 |
期末年月日 |
期末年度 |
全角変換 |
今日 |
今年-期首年 |
現在位置 |
現在月 |
終了月数 |
期末年-今年 |
残存月数 |
推定期末月 |
推定期末日 |
推定期首月 |
推定期首日 |
西暦換算 |
期間日数 |
|
|
=IF(はじめに!H5="","",はじめに!H5) |
=IF(B14="","",IF(はじめに!I5>=はじめに!L5,はじめに!H5+1,はじめに!H5)) |
=IF(B14="",0,IF(B14-C14>=0,0,1)) |
=IF(B14="",0,DATE(1988+はじめに!H5,はじめに!I5,はじめに!J5)) |
=IF(B14="",0,DATE(1988+D14+はじめに!$H$5,はじめに!L5,はじめに!M5)) |
=IF(B14="",0,YEAR($F$14)-1988) |
=JIS(はじめに!$H$5) |
=TODAY() |
=YEAR(I14)-YEAR(E14) |
=IF(AND(E14<=I14,I14<=F14),1,IF(I14<E14,-1,2)) |
=IF(K14=1,1,0) |
=IF(K14=1,(MONTH(I14)-MONTH(E14))+12*(J14),IF(K14=-1,0,MONTH(F14)-MONTH(E14)+1+12*D14)) |
=IF(B14="",0,YEAR(F14)-YEAR(I14)) |
=IF(B14="",0,IF(K14=1,(MONTH(F14)-MONTH(I14))+12*N14,IF(I14<E14,MONTH(F14)-MONTH(E14)+1+12*D14,0))) |
=はじめに!L5 |
=はじめに!M5 |
=IF(B14="",0,MONTH(F14+1)) |
=IF(B14="",0,DAY(F14+1)) |
=はじめに!$H$5+1988 |
=IF(B14="",0,F14-E14+1) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
端数処理 |
|
端数補正 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
切り上げ |
|
=IF(はじめに!P6=クエリ!B17,0.499999,IF(はじめに!P6=クエリ!B19,-0.5,0)) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
四捨五入 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
切り捨て |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
リンク更新のサイン |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=IF(ISERR(VALUE(LEFT(INFO("release"),3))),"ファイルを開く際のリンク更新は、必ず 「いいえ(N)」 を選択すること。",IF(INFO("system")="mac","ファイルを開く際は、必ず「更新しない」を選択すること",IF(OR(ISTEXT(VALUE(LEFT(INFO("release"),3))),VALUE(LEFT(INFO("release"),3))<10,VALUE(LEFT(INFO("release"),3))>100),"ファイルを開く際のリンク更新は、必ず 「いいえ(N)」 を選択すること。",""))) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
あいさつ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=IF(HOUR(NOW())<3,"こんばんは。(-_-)zzZ",IF(HOUR(NOW())<10,"おはよう。(^o^)/",IF(HOUR(NOW())<18,"こんにちは。(^_^)",IF(HOUR(NOW())<23,"こんばんは。(+_+)","こんばんは。(-_-)zzZ")))) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ボタン表示 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
@ |
C |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A |
=IF(はじめに!B5=クエリ!E7,"","B") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
グラフ表示 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=IF(はじめに!H5="",REPT(" ・ ",12),REPT(" ■ ",クエリ!$M$14)&REPT(" ◆ ",クエリ!$L$14)&REPT(" □ ",クエリ!$O$14)) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
一般用、農業用、不動産用 |
|
|
|
|
|
|
|
|
|
減価償却専用 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
使い方 |
|
|
|
|
|
|
|
|
|
使い方 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
・会計年の記入 |
|
シート上段にある緑色のセルに会計年を入力します。 |
|
|
|
|
|
|
|
・会計年の記入 |
|
シート上段にある緑色のセルに会計年を入力します。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
・・ シート確認 |
|
〔はじめに〕 ・・・ このシート |
|
|
|
|
|
|
|
・・ シート確認 |
|
〔はじめに〕 ・・・ このシート |
|
|
|
|
|
|
|
|
|
|
|
〔仕訳帳〕、〔決算書@〜C〕 ・・・ 記帳するシート |
|
|
|
|
|
|
|
|
|
〔減価償却〕 ・・・ 記帳するシート |
|
|
|
|
|
|
|
|
|
|
|
〔 元 帳 〕、〔 台 帳 〕 ・・・ 自動作成されるシート |
|
|
|
|
|
|
|
|
|
〔 台 帳 〕 ・・・ 自動作成されるシート |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
・・・ 記 帳 |
|
〔仕訳帳〕、〔決算書@〜C〕のどちらから始めても構いません。 |
|
|
|
|
|
|
|
・・・ 記 帳 |
|
〔減価償却〕シートに記帳します。 |
|
|
|
|
|
|
|
|
|
|
|
シートの緑色セル部分が入力するセルです。 |
|
|
|
|
|
|
|
|
|
シートの緑色セル部分が入力するセルです。 |
|
|
|
|
|
|
|
|
|
|
|
セルを右移動に設定しましょう。〔仕訳帳〕入力が楽になります。 |
|
|
|
|
|
|
|
|
|
セルを右移動に設定しましょう。入力が楽になります。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
エクセル簿記(減価償却専用)は、減価償却費の計算と固定資産台帳を作成します。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
一連の簿記記帳には、エクセル簿記(一般用)、(農業用)、(不動産用) を併用ください。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
⇒エクセル簿記のダウンロード |
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
・・・・ 決 算 |
|
自動集計されています。決算振替手続や元帳締切は必要ありません。 |
|
|
|
|
|
|
|
・・・・ 作 成 |
|
自動で再計算し、帳簿を作成しています。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
・・・・・印 刷 |
|
範囲設定済み。そのまま印刷してください。 |
|
|
|
|
|
|
|
・・・・・印 刷 |
|
必要に応じて表示行を調整し、印刷します。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
※ご利用の前に、 |
|
<使用上の注意> |
|
をお読みください(最下段にあります)。 |
|
|
|
|
|
※ご利用の前に、 |
|
<使用上の注意> |
|
をお読みください(最下段にあります)。 |
|
|
|
|
|
|
|
※操作方法の最新情報は、 |
|
|
はてな? |
のサイトで紹介しています。 |
|
|
|
|
|
※操作方法の最新情報は、 |
|
|
はてな? |
のサイトで紹介しています。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
機 能 |
|
|
|
|
|
|
|
|
|
機 能 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
〔はじめに〕:操作に関する情報サイトのリンク、メール 等 |
|
|
|
|
|
|
|
|
|
〔はじめに〕: 操作に関する情報サイトのリンク、メール 等 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
〔仕訳帳〕: 摘要文例の表示、日付順・oの並べ替え、行削除、仕訳検索 等 |
|
|
|
|
|
|
|
|
|
〔減価償却〕: 償却費計算、償却資産の科目別集計、残存割合の変更 等 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
〔決算書〕: 科目の追加、集計・決算、償却資産の科目別集計、残存割合の変更 等 |
|
|
|
|
|
|
|
|
|
〔 台 帳 〕: 償却資産別の台帳作成 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
〔 元 帳 〕: 勘定科目別の元帳作成、行移動ボタン、エラーメッセージ 等 |
|
|
|
|
|
|
|
|
|
共 通 : シート移動ボタン、印刷範囲の設定、〔台帳様式〕シートの付属 等 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
〔 台 帳 〕: 償却資産別の台帳作成 |
|
|
|
|
|
|
|
|
|
応 用 : 年度更新、会計期間の変更、端数処理選択 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
共 通 : シート移動ボタン、印刷範囲の設定、〔精算表〕の作成 等 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
応 用 : 年度更新、会計期間変更、科目やコード修正、端数処理選択、月次決算、 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
科目別・月別・摘要別集計、資本金勘定の設定、外貨対応 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
※ご利用の前に、 |
|
<使用上の注意> |
|
をお読みください(最下段にあります)。 |
|
|
|
|
|
=F98 |
|
<使用上の注意> |
|
=J98 |
|
|
|
|
|
|
|
※応用機能の利用や独自加工を施すには、マニュアルが必要です。 |
|
|
|
|
|
|
|
|
|
=F99 |
|
|
|
|
|
|
|
|
|
|
|
※各種機能の操作方法や最新情報は、 |
|
|
|
はてな? |
のサイトで紹介しています。 |
|
|
|
|
=F100 |
|
|
|
はてな? |
=K100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<使用上の注意> |
|
|
|
|
|
|
|
|
|
<使用上の注意> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
・エクセル簿記は、複式簿記による会計ソフトです。 |
|
|
|
|
|
|
|
|
|
・エクセル簿記(減価償却専用)は、償却資産のための計算ソフトです。 |
|
|
|
|
|
|
|
|
|
|
|
=IF(はじめに!$B$5="gene","・個人事業者(一般)を対象に作成しています。",IF(はじめに!$B$5="agri","・個人事業者(農業)を対象に作成しています。","・個人事業者(不動産)を対象に作成しています。")) |
|
|
|
|
|
|
|
|
|
・全ての事業者を対象に作成しています。 |
|
|
|
|
|
|
|
|
|
|
|
=IF(はじめに!$N$2="記入例","・記入例は、仕訳行数100行、摘要文例25例です。","・仕訳行数の初期設定は2100行、摘要文例は100例です。") |
|
|
|
|
|
|
|
|
|
=F116 |
|
|
|
|
|
|
|
|
|
|
|
・平成19、20、23年の減価償却制度の改正に対応しています。 |
|
|
|
|
|
|
|
|
|
・特殊な減価償却の場合、〔台帳様式〕シートを併用ください。 |
|
|
|
|
|
|
|
|
|
|
|
・償却資産が多い場合、エクセル簿記(減価償却専用)を併用ください。 |
|
|
|
|
|
⇒(減価償却専用)のダウンロード |
|
|
|
・一連の簿記記帳には、エクセル簿記(一般用)等があります。 |
|
|
|
|
|
⇒(一般用)(農業用)(不動産用) |
|
|
|
|
|
・新年度の記帳や年度更新には、最新のエクセル簿記をご利用ください。 |
|
|
|
|
|
⇒最新版のダウンロード |
|
|
|
=F118 |
|
|
|
|
|
=L118 |
|
|
|
|
|
・パソコンの性能等により動作の遅くなる場合があります。 |
|
|
|
|
|
|
|
|
|
=F119 |
|
|
|
|
|
|
|
|
|
|
|
・複式簿記を理解したうえで記帳することをお薦めします。 |
|
|
|
|
|
|
|
|
|
・償却資産が多い場合のご利用をお薦めします(78件まで登録可能)。 |
|
|
|
|
|
|
|
|
|
|
|
・Microsoft Excel, Excel for Mac, OpenOffice Calc 対応です。 |
|
|
|
|
|
|
|
|
|
=F121 |
|
|
|
|
|
|
|
|
|
|
|
・別添のreadmeファイルも併せてお読みください。 |
|
|
|
|
|
|
|
|
|
=F122 |
|
|
|
|
|
|
|
|
|
|
|
・ご意見や、お問い合わせは、以下宛にお願いいたします。 |
|
|
|
|
|
|
|
|
|
=F123 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Eメール excelb@ab.auone-net.jp |
|
|
|
|
|
|
|
|
|
Eメール excelb@ab.auone-net.jp |
|
|
|
|
|
|
|
|
|
|
|
URL http://management.main.jp/ |
|
|
|
|
|
|
|
|
|
URL http://management.main.jp/ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
勘定科目一覧(一般用) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
コード |
勘定科目 |
分類 |
|
文字列 |
借方/貸方 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA8 |
=LEFT(決算書@!B12,FIND("金額",決算書@!B12)-1) |
収益 |
=B133 |
=TEXT($E133,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA9 |
=CLEAN(決算書@!C16) |
売上原価 |
=B134 |
=TEXT($E134,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA10 |
=CLEAN(決算書@!C17) |
売上原価 |
=B135 |
=TEXT($E135,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA11 |
- |
- |
=B136 |
=TEXT($E136,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA12 |
=CLEAN(決算書@!C19) |
-売上原価 |
=B137 |
=TEXT($E137,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA13 |
- |
- |
=B138 |
=TEXT($E138,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA14 |
- |
- |
=B139 |
=TEXT($E139,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA15 |
=決算書@!C25 |
費用 |
=B140 |
=TEXT($E140,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA16 |
=決算書@!C26 |
費用 |
=B141 |
=TEXT($E141,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA17 |
=決算書@!C27 |
費用 |
=B142 |
=TEXT($E142,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA18 |
=決算書@!C29 |
費用 |
=B143 |
=TEXT($E143,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA19 |
=決算書@!C31 |
費用 |
=B144 |
=TEXT($E144,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA20 |
=決算書@!C32 |
費用 |
=B145 |
=TEXT($E145,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA21 |
=決算書@!C33 |
費用 |
=B146 |
=TEXT($E146,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA22 |
=決算書@!C34 |
費用 |
=B147 |
=TEXT($E147,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA23 |
=決算書@!C36 |
費用 |
=B148 |
=TEXT($E148,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA24 |
=決算書@!H12 |
費用 |
=B149 |
=TEXT($E149,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA25 |
=決算書@!H14 |
費用 |
=B150 |
=TEXT($E150,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA26 |
=決算書@!H16 |
費用 |
=B151 |
=TEXT($E151,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA27 |
=決算書@!H17 |
費用 |
=B152 |
=TEXT($E152,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA28 |
=決算書@!H18 |
費用 |
=B153 |
=TEXT($E153,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA29 |
=決算書@!H19 |
費用 |
=B154 |
=TEXT($E154,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA30 |
=決算書@!H20 |
費用 |
=B155 |
=TEXT($E155,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA31 |
=決算書@!H21 |
費用 |
=B156 |
=TEXT($E156,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA32 |
=IF(決算書@!H23="","",決算書@!H23) |
費用 |
=B157 |
=TEXT($E157,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA33 |
=IF(決算書@!H25="","",決算書@!H25) |
費用 |
=B158 |
=TEXT($E158,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA34 |
=IF(決算書@!H26="","",決算書@!H26) |
費用 |
=B159 |
=TEXT($E159,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA35 |
=IF(決算書@!H27="","",決算書@!H27) |
費用 |
=B160 |
=TEXT($E160,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA36 |
=IF(決算書@!H29="","",決算書@!H29) |
費用 |
=B161 |
=TEXT($E161,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA37 |
=IF(決算書@!H31="","",決算書@!H31) |
費用 |
=B162 |
=TEXT($E162,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA38 |
=決算書@!H32 |
費用 |
=B163 |
=TEXT($E163,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA39 |
- |
- |
=B164 |
=TEXT($E164,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA40 |
- |
- |
=B165 |
=TEXT($E165,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA41 |
=決算書@!Q12&"戻入" |
収益 |
=B166 |
=TEXT($E166,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA42 |
=IF(決算書@!Q14="","",決算書@!Q14) |
収益 |
=B167 |
=TEXT($E167,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA43 |
=IF(決算書@!Q16="","",決算書@!Q16) |
収益 |
=B168 |
=TEXT($E168,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA44 |
- |
- |
=B169 |
=TEXT($E169,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA45 |
=決算書@!Q18 |
費用 |
=B170 |
=TEXT($E170,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA46 |
=決算書@!Q19&"繰入" |
費用 |
=B171 |
=TEXT($E171,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA47 |
=IF(決算書@!Q20="","",決算書@!Q20) |
費用 |
=B172 |
=TEXT($E172,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AA48 |
=IF(決算書@!Q21="","",決算書@!Q21) |
費用 |
=B173 |
=TEXT($E173,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B174 |
=TEXT($E174,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B175 |
=TEXT($E175,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B176 |
=TEXT($E176,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B177 |
=TEXT($E177,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B178 |
=TEXT($E178,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B179 |
=TEXT($E179,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B180 |
=TEXT($E180,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B181 |
=TEXT($E181,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B182 |
=TEXT($E182,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH8 |
=C!B6 |
資産 |
=B183 |
=TEXT($E183,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH9 |
=C!B7 |
資産 |
=B184 |
=TEXT($E184,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH10 |
=C!B8 |
資産 |
=B185 |
=TEXT($E185,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH11 |
=C!B9 |
資産 |
=B186 |
=TEXT($E186,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH12 |
=C!B10 |
資産 |
=B187 |
=TEXT($E187,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH13 |
=C!B11 |
資産 |
=B188 |
=TEXT($E188,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH14 |
=C!B12 |
資産 |
=B189 |
=TEXT($E189,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH15 |
=C!B13 |
資産 |
=B190 |
=TEXT($E190,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH16 |
=C!B14 |
資産 |
=B191 |
=TEXT($E191,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH17 |
=C!B15 |
資産 |
=B192 |
=TEXT($E192,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH18 |
=C!B16 |
資産 |
=B193 |
=TEXT($E193,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH19 |
=C!B17 |
資産 |
=B194 |
=TEXT($E194,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH20 |
=C!B18 |
資産 |
=B195 |
=TEXT($E195,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH21 |
=C!B19 |
資産 |
=B196 |
=TEXT($E196,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH22 |
=C!B20 |
資産 |
=B197 |
=TEXT($E197,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH23 |
=C!B21 |
資産 |
=B198 |
=TEXT($E198,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH24 |
=IF(C!B22="","",C!B22) |
資産 |
=B199 |
=TEXT($E199,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH25 |
=IF(C!B23="","",C!B23) |
資産 |
=B200 |
=TEXT($E200,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH26 |
=IF(C!B24="","",C!B24) |
資産 |
=B201 |
=TEXT($E201,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH27 |
=IF(C!B25="","",C!B25) |
資産 |
=B202 |
=TEXT($E202,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH28 |
=IF(C!B26="","",C!B26) |
資産 |
=B203 |
=TEXT($E203,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH29 |
=IF(C!B27="","",C!B27) |
資産 |
=B204 |
=TEXT($E204,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH30 |
=IF(C!B28="","",C!B28) |
資産 |
=B205 |
=TEXT($E205,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH31 |
=C!B29 |
-資本 |
=B206 |
=TEXT($E206,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B207 |
=TEXT($E207,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B208 |
=TEXT($E208,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B209 |
=TEXT($E209,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH35 |
=C!E6 |
負債 |
=B210 |
=TEXT($E210,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH36 |
=C!E7 |
負債 |
=B211 |
=TEXT($E211,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH37 |
=C!E8 |
負債 |
=B212 |
=TEXT($E212,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH38 |
=C!E9 |
負債 |
=B213 |
=TEXT($E213,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH39 |
=C!E10 |
負債 |
=B214 |
=TEXT($E214,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH40 |
=C!E11 |
負債 |
=B215 |
=TEXT($E215,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH41 |
=IF(C!E12="","",C!E12) |
負債 |
=B216 |
=TEXT($E216,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH42 |
=IF(C!E13="","",C!E13) |
負債 |
=B217 |
=TEXT($E217,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH43 |
=IF(C!E14="","",C!E14) |
負債 |
=B218 |
=TEXT($E218,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH44 |
=IF(C!E15="","",C!E15) |
負債 |
=B219 |
=TEXT($E219,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH45 |
=IF(C!E16="","",C!E16) |
負債 |
=B220 |
=TEXT($E220,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH46 |
=IF(C!E17="","",C!E17) |
負債 |
=B221 |
=TEXT($E221,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH47 |
=IF(C!E18="","",C!E18) |
負債 |
=B222 |
=TEXT($E222,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH48 |
=C!E19 |
評価勘定 |
=B223 |
=TEXT($E223,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH49 |
=IF(C!E20="","",C!E20) |
負債等 |
=B224 |
=TEXT($E224,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH50 |
=IF(C!E21="","",C!E21) |
負債等 |
=B225 |
=TEXT($E225,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH51 |
=IF(C!E22="","",C!E22) |
負債等 |
=B226 |
=TEXT($E226,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH52 |
=IF(C!E23="","",C!E23) |
負債等 |
=B227 |
=TEXT($E227,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH53 |
=IF(C!E24="","",C!E24) |
負債等 |
=B228 |
=TEXT($E228,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH54 |
=IF(C!E25="","",C!E25) |
負債等 |
=B229 |
=TEXT($E229,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH55 |
=IF(C!E26="","",C!E26) |
負債等 |
=B230 |
=TEXT($E230,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH56 |
=C!E27 |
資本 |
=B231 |
=TEXT($E231,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AH57 |
=C!E28 |
資本 |
=B232 |
=TEXT($E232,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B233 |
=TEXT($E233,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B234 |
=TEXT($E234,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL8 |
=C!J5 |
原材料費 |
=B235 |
=TEXT($E235,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL9 |
=C!J6 |
原材料費 |
=B236 |
=TEXT($E236,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL10 |
- |
- |
=B237 |
=TEXT($E237,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL11 |
=C!J8 |
-原材料費 |
=B238 |
=TEXT($E238,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL12 |
- |
- |
=B239 |
=TEXT($E239,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL13 |
=IF(C!I10="","",C!I10&"(製造原価)") |
労務費 |
=B240 |
=TEXT($E240,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL14 |
=IF(C!J11="","",C!J11&"(製造原価)") |
製造経費 |
=B241 |
=TEXT($E241,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL15 |
=IF(C!J12="","",C!J12&"(製造原価)") |
製造経費 |
=B242 |
=TEXT($E242,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL16 |
=IF(C!J13="","",C!J13&"(製造原価)") |
製造経費 |
=B243 |
=TEXT($E243,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL17 |
=IF(C!J14="","",C!J14&"(製造原価)") |
製造経費 |
=B244 |
=TEXT($E244,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL18 |
=IF(C!J15="","",C!J15&"(製造原価)") |
製造経費 |
=B245 |
=TEXT($E245,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL19 |
=IF(C!J16="","",C!J16&"(製造原価)") |
製造経費 |
=B246 |
=TEXT($E246,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL20 |
=IF(C!J17="","",C!J17&"(製造原価)") |
製造経費 |
=B247 |
=TEXT($E247,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL21 |
=IF(C!J18="","",C!J18&"(製造原価)") |
製造経費 |
=B248 |
=TEXT($E248,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL22 |
=IF(C!J19="","",C!J19&"(製造原価)") |
製造経費 |
=B249 |
=TEXT($E249,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL23 |
=IF(C!J20="","",C!J20&"(製造原価)") |
製造経費 |
=B250 |
=TEXT($E250,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL24 |
=IF(C!J21="","",C!J21&"(製造原価)") |
製造経費 |
=B251 |
=TEXT($E251,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL25 |
=IF(C!J22="","",C!J22&"(製造原価)") |
製造経費 |
=B252 |
=TEXT($E252,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL26 |
=IF(C!J23="","",C!J23&"(製造原価)") |
製造経費 |
=B253 |
=TEXT($E253,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL27 |
=IF(C!J24="","",C!J24&"(製造原価)") |
製造経費 |
=B254 |
=TEXT($E254,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL28 |
- |
- |
=B255 |
=TEXT($E255,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL29 |
- |
- |
=B256 |
=TEXT($E256,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL30 |
=C!I27 |
製造原価 |
=B257 |
=TEXT($E257,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL31 |
- |
- |
=B258 |
=TEXT($E258,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!AL32 |
=C!I29 |
-製造原価 |
=B259 |
=TEXT($E259,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
[▼]ボタンで科目を一つ選択 |
- |
0 |
=TEXT($E260,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
勘定科目一覧(農業用) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
コード |
勘定科目 |
分類 |
|
文字列 |
借方/貸方 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA8 |
=LEFT(決算書@!C13,FIND("金額",決算書@!C13)-1) |
収益 |
=B264 |
=TEXT($E264,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA9 |
=CLEAN(決算書@!C15) |
収益 |
=B265 |
=TEXT($E265,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA10 |
=決算書@!C17 |
収益 |
=B266 |
=TEXT($E266,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA11 |
- |
- |
=B267 |
=TEXT($E267,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA12 |
=決算書@!C19 |
-収益 |
=B268 |
=TEXT($E268,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA13 |
=決算書@!C20 |
収益 |
=B269 |
=TEXT($E269,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA14 |
- |
- |
=B270 |
=TEXT($E270,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA15 |
=決算書@!C25 |
費用 |
=B271 |
=TEXT($E271,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA16 |
=決算書@!C26 |
費用 |
=B272 |
=TEXT($E272,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA17 |
=決算書@!C27 |
費用 |
=B273 |
=TEXT($E273,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA18 |
=決算書@!C28 |
費用 |
=B274 |
=TEXT($E274,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA19 |
=決算書@!C29 |
費用 |
=B275 |
=TEXT($E275,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA20 |
=決算書@!C30 |
費用 |
=B276 |
=TEXT($E276,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA21 |
=決算書@!C32 |
費用 |
=B277 |
=TEXT($E277,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA22 |
=決算書@!C34 |
費用 |
=B278 |
=TEXT($E278,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA23 |
=決算書@!C35 |
費用 |
=B279 |
=TEXT($E279,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA24 |
=決算書@!C37 |
費用 |
=B280 |
=TEXT($E280,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA25 |
=決算書@!I13 |
費用 |
=B281 |
=TEXT($E281,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA26 |
=決算書@!I15 |
費用 |
=B282 |
=TEXT($E282,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA27 |
=決算書@!I17 |
費用 |
=B283 |
=TEXT($E283,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA28 |
=決算書@!I18 |
費用 |
=B284 |
=TEXT($E284,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA29 |
=決算書@!I19 |
費用 |
=B285 |
=TEXT($E285,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA30 |
=決算書@!I20 |
費用 |
=B286 |
=TEXT($E286,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA31 |
=決算書@!I21 |
費用 |
=B287 |
=TEXT($E287,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA32 |
=決算書@!I23 |
費用 |
=B288 |
=TEXT($E288,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA33 |
=IF(決算書@!I25="","",決算書@!I25) |
費用 |
=B289 |
=TEXT($E289,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA34 |
=IF(決算書@!I26="","",決算書@!I26) |
費用 |
=B290 |
=TEXT($E290,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA35 |
=IF(決算書@!I27="","",決算書@!I27) |
費用 |
=B291 |
=TEXT($E291,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA36 |
=IF(決算書@!I28="","",決算書@!I28) |
費用 |
=B292 |
=TEXT($E292,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA37 |
=決算書@!I29 |
費用 |
=B293 |
=TEXT($E293,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA38 |
- |
- |
=B294 |
=TEXT($E294,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA39 |
=決算書@!I32 |
費用 |
=B295 |
=TEXT($E295,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA40 |
=決算書@!I34 |
-費用 |
=B296 |
=TEXT($E296,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA41 |
=CLEAN(決算書@!H35) |
-費用 |
=B297 |
=TEXT($E297,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA42 |
- |
- |
=B298 |
=TEXT($E298,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA43 |
- |
- |
=B299 |
=TEXT($E299,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA44 |
=決算書@!S17&"戻入" |
収益 |
=B300 |
=TEXT($E300,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA45 |
=IF(決算書@!S18="","",決算書@!S18) |
収益 |
=B301 |
=TEXT($E301,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA46 |
=IF(決算書@!S19="","",決算書@!S19) |
収益 |
=B302 |
=TEXT($E302,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA47 |
- |
- |
=B303 |
=TEXT($E303,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA48 |
=決算書@!S21 |
費用 |
=B304 |
=TEXT($E304,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA49 |
=決算書@!S23&"繰入" |
費用 |
=B305 |
=TEXT($E305,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA50 |
=IF(決算書@!S25="","",決算書@!S25) |
費用 |
=B306 |
=TEXT($E306,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CA51 |
=IF(決算書@!S26="","",決算書@!S26) |
費用 |
=B307 |
=TEXT($E307,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B308 |
=TEXT($E308,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B309 |
=TEXT($E309,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B310 |
=TEXT($E310,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B311 |
=TEXT($E311,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B312 |
=TEXT($E312,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B313 |
=TEXT($E313,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH8 |
=C!H6 |
資産 |
=B314 |
=TEXT($E314,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH9 |
=C!H7 |
資産 |
=B315 |
=TEXT($E315,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH10 |
=C!H8 |
資産 |
=B316 |
=TEXT($E316,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH11 |
=C!H9 |
資産 |
=B317 |
=TEXT($E317,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH12 |
=C!H10 |
資産 |
=B318 |
=TEXT($E318,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH13 |
=C!H11 |
資産 |
=B319 |
=TEXT($E319,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH14 |
=C!H12 |
資産 |
=B320 |
=TEXT($E320,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH15 |
=C!H13 |
資産 |
=B321 |
=TEXT($E321,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH16 |
=C!H14 |
資産 |
=B322 |
=TEXT($E322,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH17 |
=CLEAN(C!H15) |
資産 |
=B323 |
=TEXT($E323,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH18 |
=C!H16 |
資産 |
=B324 |
=TEXT($E324,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH19 |
=C!H17 |
資産 |
=B325 |
=TEXT($E325,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH20 |
=C!H18 |
資産 |
=B326 |
=TEXT($E326,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH21 |
=C!H19 |
資産 |
=B327 |
=TEXT($E327,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH22 |
=C!H20 |
資産 |
=B328 |
=TEXT($E328,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH23 |
=C!H21 |
資産 |
=B329 |
=TEXT($E329,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH24 |
=C!H22 |
資産 |
=B330 |
=TEXT($E330,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH25 |
=CLEAN(C!H23) |
資産 |
=B331 |
=TEXT($E331,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH26 |
=IF(C!H24="","",C!H24) |
資産 |
=B332 |
=TEXT($E332,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH27 |
=IF(C!H25="","",C!H25) |
資産 |
=B333 |
=TEXT($E333,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH28 |
=IF(C!H26="","",C!H26) |
資産 |
=B334 |
=TEXT($E334,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH29 |
=IF(C!H27="","",C!H27) |
資産 |
=B335 |
=TEXT($E335,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH30 |
=IF(C!H28="","",C!H28) |
資産 |
=B336 |
=TEXT($E336,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH31 |
=C!H29 |
-資本 |
=B337 |
=TEXT($E337,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH32 |
- |
- |
=B338 |
=TEXT($E338,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH33 |
- |
- |
=B339 |
=TEXT($E339,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH34 |
- |
- |
=B340 |
=TEXT($E340,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH35 |
=IF(C!K6="","",C!K6) |
負債 |
=B341 |
=TEXT($E341,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH36 |
=IF(C!K7="","",C!K7) |
負債 |
=B342 |
=TEXT($E342,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH37 |
=IF(C!K8="","",C!K8) |
負債 |
=B343 |
=TEXT($E343,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH38 |
=IF(C!K9="","",C!K9) |
負債 |
=B344 |
=TEXT($E344,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH39 |
=IF(C!K10="","",C!K10) |
負債 |
=B345 |
=TEXT($E345,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH40 |
=IF(C!K11="","",C!K11) |
負債 |
=B346 |
=TEXT($E346,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH41 |
=IF(C!K12="","",C!K12) |
負債 |
=B347 |
=TEXT($E347,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH42 |
=IF(C!K13="","",C!K13) |
負債 |
=B348 |
=TEXT($E348,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH43 |
=IF(C!K14="","",C!K14) |
負債 |
=B349 |
=TEXT($E349,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH44 |
=IF(C!K15="","",C!K15) |
負債 |
=B350 |
=TEXT($E350,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH45 |
=IF(C!K16="","",C!K16) |
負債 |
=B351 |
=TEXT($E351,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH46 |
=IF(C!K17="","",C!K17) |
負債 |
=B352 |
=TEXT($E352,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH47 |
=IF(C!K18="","",C!K18) |
負債 |
=B353 |
=TEXT($E353,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH48 |
=IF(C!K19="","",C!K19) |
評価勘定 |
=B354 |
=TEXT($E354,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH49 |
=IF(C!K20="","",C!K20) |
負債等 |
=B355 |
=TEXT($E355,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH50 |
=IF(C!K21="","",C!K21) |
負債等 |
=B356 |
=TEXT($E356,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH51 |
=IF(C!K22="","",C!K22) |
負債等 |
=B357 |
=TEXT($E357,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH52 |
=IF(C!K23="","",C!K23) |
負債等 |
=B358 |
=TEXT($E358,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH53 |
=IF(C!K24="","",C!K24) |
負債等 |
=B359 |
=TEXT($E359,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH54 |
=IF(C!K25="","",C!K25) |
負債等 |
=B360 |
=TEXT($E360,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH55 |
=IF(C!K26="","",C!K26) |
負債等 |
=B361 |
=TEXT($E361,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH56 |
=IF(C!K27="","",C!K27) |
資本 |
=B362 |
=TEXT($E362,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!CH57 |
=IF(C!K28="","",C!K28) |
資本 |
=B363 |
=TEXT($E363,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
[▼]ボタンで科目を一つ選択 |
- |
0 |
=TEXT($E364,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B365 |
=TEXT($E365,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
勘定科目一覧(不動産用) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
コード |
勘定科目 |
分類 |
|
文字列 |
借方/貸方 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA8 |
=IF(決算書@!C13="","",決算書@!C13) |
収益 |
=B369 |
=TEXT($E369,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA9 |
=IF(決算書@!C14="","",CLEAN(決算書@!C14)) |
収益 |
=B370 |
=TEXT($E370,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA10 |
=IF(決算書@!C15="","",CLEAN(決算書@!C15)) |
収益 |
=B371 |
=TEXT($E371,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA11 |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA12 |
=IF(決算書@!C17="","",CLEAN(決算書@!C17)) |
費用 |
=B373 |
=TEXT($E373,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA13 |
=IF(決算書@!C18="","",CLEAN(決算書@!C18)) |
費用 |
=B374 |
=TEXT($E374,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA14 |
=IF(決算書@!C19="","",CLEAN(決算書@!C19)) |
費用 |
=B375 |
=TEXT($E375,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA15 |
=IF(決算書@!C20="","",CLEAN(決算書@!C20)) |
費用 |
=B376 |
=TEXT($E376,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA16 |
=IF(決算書@!C21="","",CLEAN(決算書@!C21)) |
費用 |
=B377 |
=TEXT($E377,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA17 |
=IF(決算書@!C22="","",CLEAN(決算書@!C22)) |
費用 |
=B378 |
=TEXT($E378,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA18 |
=IF(決算書@!C23="","",CLEAN(決算書@!C23)) |
費用 |
=B379 |
=TEXT($E379,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA19 |
=IF(決算書@!C24="","",CLEAN(決算書@!C24)) |
費用 |
=B380 |
=TEXT($E380,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA20 |
=IF(決算書@!I13="","",CLEAN(決算書@!I13)) |
費用 |
=B381 |
=TEXT($E381,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA21 |
=IF(決算書@!I14="","",CLEAN(決算書@!I14)) |
費用 |
=B382 |
=TEXT($E382,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA22 |
=IF(決算書@!I15="","",CLEAN(決算書@!I15)) |
費用 |
=B383 |
=TEXT($E383,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA23 |
=IF(決算書@!I16="","",CLEAN(決算書@!I16)) |
費用 |
=B384 |
=TEXT($E384,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA24 |
=IF(決算書@!I17="","",CLEAN(決算書@!I17)) |
費用 |
=B385 |
=TEXT($E385,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA25 |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA26 |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DA27 |
=IF(決算書@!H20="","",CLEAN(決算書@!H20)) |
費用 |
=B388 |
=TEXT($E388,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH8 |
=IF(C!B6="","",CLEAN(C!B6)) |
資産 |
=B419 |
=TEXT($E419,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH9 |
=IF(C!B7="","",CLEAN(C!B7)) |
資産 |
=B420 |
=TEXT($E420,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH10 |
=IF(C!B8="","",CLEAN(C!B8)) |
資産 |
=B421 |
=TEXT($E421,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH11 |
=IF(C!B9="","",CLEAN(C!B9)) |
資産 |
=B422 |
=TEXT($E422,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH12 |
=IF(C!B10="","",CLEAN(C!B10)) |
資産 |
=B423 |
=TEXT($E423,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH13 |
=IF(C!B11="","",CLEAN(C!B11)) |
資産 |
=B424 |
=TEXT($E424,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH14 |
=IF(C!B12="","",CLEAN(C!B12)) |
資産 |
=B425 |
=TEXT($E425,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH15 |
=IF(C!B13="","",CLEAN(C!B13)) |
資産 |
=B426 |
=TEXT($E426,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH16 |
=IF(C!B14="","",CLEAN(C!B14)) |
資産 |
=B427 |
=TEXT($E427,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH17 |
=IF(C!B15="","",CLEAN(C!B15)) |
資産 |
=B428 |
=TEXT($E428,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH18 |
=IF(C!B16="","",CLEAN(C!B16)) |
資産 |
=B429 |
=TEXT($E429,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH19 |
=IF(C!B17="","",CLEAN(C!B17)) |
資産 |
=B430 |
=TEXT($E430,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH20 |
=IF(C!B18="","",CLEAN(C!B18)) |
資産 |
=B431 |
=TEXT($E431,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH21 |
=IF(C!B19="","",CLEAN(C!B19)) |
資産 |
=B432 |
=TEXT($E432,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH22 |
=IF(C!B20="","",CLEAN(C!B20)) |
資産 |
=B433 |
=TEXT($E433,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH23 |
=IF(C!B21="","",CLEAN(C!B21)) |
資産 |
=B434 |
=TEXT($E434,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH24 |
=IF(C!B22="","",CLEAN(C!B22)) |
資産 |
=B435 |
=TEXT($E435,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH25 |
=IF(C!B23="","",CLEAN(C!B23)) |
資産 |
=B436 |
=TEXT($E436,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH26 |
=IF(C!B24="","",CLEAN(C!B24)) |
資産 |
=B437 |
=TEXT($E437,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH27 |
=IF(C!B25="","",CLEAN(C!B25)) |
資産 |
=B438 |
=TEXT($E438,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH28 |
=IF(C!B26="","",CLEAN(C!B26)) |
資産 |
=B439 |
=TEXT($E439,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH29 |
=IF(C!B27="","",CLEAN(C!B27)) |
資産 |
=B440 |
=TEXT($E440,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH30 |
=IF(C!B28="","",CLEAN(C!B28)) |
資産 |
=B441 |
=TEXT($E441,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH31 |
=IF(C!B29="","",CLEAN(C!B29)) |
-資本 |
=B442 |
=TEXT($E442,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH32 |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH33 |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH34 |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH35 |
=CLEAN(C!E6) |
負債 |
=B446 |
=TEXT($E446,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH36 |
=CLEAN(C!E7) |
負債 |
=B447 |
=TEXT($E447,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH37 |
=CLEAN(C!E8) |
負債 |
=B448 |
=TEXT($E448,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH38 |
=CLEAN(C!E9) |
負債 |
=B449 |
=TEXT($E449,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH39 |
=CLEAN(C!E10) |
負債 |
=B450 |
=TEXT($E450,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH40 |
=CLEAN(C!E11) |
負債 |
=B451 |
=TEXT($E451,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH41 |
=CLEAN(C!E12) |
負債 |
=B452 |
=TEXT($E452,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH42 |
=CLEAN(C!E13) |
負債 |
=B453 |
=TEXT($E453,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH43 |
=CLEAN(C!E14) |
負債 |
=B454 |
=TEXT($E454,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH44 |
=CLEAN(C!E15) |
負債 |
=B455 |
=TEXT($E455,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH45 |
=CLEAN(C!E16) |
負債 |
=B456 |
=TEXT($E456,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH46 |
=CLEAN(C!E17) |
負債 |
=B457 |
=TEXT($E457,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH47 |
=CLEAN(C!E18) |
負債 |
=B458 |
=TEXT($E458,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH48 |
=CLEAN(C!E19) |
評価勘定 |
=B459 |
=TEXT($E459,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH49 |
=CLEAN(C!E20) |
負債等 |
=B460 |
=TEXT($E460,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH50 |
=CLEAN(C!E21) |
負債等 |
=B461 |
=TEXT($E461,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH51 |
=CLEAN(C!E22) |
負債等 |
=B462 |
=TEXT($E462,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH52 |
=CLEAN(C!E23) |
負債等 |
=B463 |
=TEXT($E463,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH53 |
=CLEAN(C!E24) |
負債等 |
=B464 |
=TEXT($E464,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH54 |
=CLEAN(C!E25) |
負債等 |
=B465 |
=TEXT($E465,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH55 |
=CLEAN(C!E26) |
負債等 |
=B466 |
=TEXT($E466,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH56 |
=CLEAN(C!E27) |
資本 |
=B467 |
=TEXT($E467,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=はじめに!DH57 |
=CLEAN(C!E28) |
資本 |
=B468 |
=TEXT($E468,"000") |
-1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
[▼]ボタンで科目を一つ選択 |
- |
0 |
=TEXT($E469,"000") |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
- |
- |
=B470 |
=TEXT($E470,"000") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
B、台帳 |
減価償却資産の償却率等表 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 旧定額法、定額法の償却率表 |
|
2 旧定率法、定率法の償却率等表 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
平成19年3月31日以前取得 |
平成19年4月1日以後取得 |
平成19年3月31日以前取得 |
平成19 年4月1日から平成24年3月31日までに取得 |
|
|
平成24年4月1日以後取得 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
耐用年数 |
旧定額法償却率 |
定額法償却率 |
旧定率法償却率 |
250%定率法償却率 |
250%定率法改定償却率 |
250%定率法保証率 |
200%定率法償却率 |
200%定率法償却率 |
200%定率法保証率 |
|
|
|
|
|
|
|
|
|
|
|
|
2 |
0.5 |
0.5 |
0.684 |
1 |
0 |
0 |
1 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
3 |
0.333 |
0.334 |
0.536 |
0.833 |
1 |
0.02789 |
0.667 |
1 |
0.11089 |
|
|
|
|
|
|
|
|
|
|
|
|
4 |
0.25 |
0.25 |
0.438 |
0.625 |
1 |
0.05274 |
0.5 |
1 |
0.12499 |
|
|
|
|
|
|
|
|
|
|
|
|
5 |
0.2 |
0.2 |
0.369 |
0.5 |
1 |
0.06249 |
0.4 |
0.5 |
0.108 |
|
|
|
|
|
|
|
|
|
|
|
|
6 |
0.166 |
0.167 |
0.319 |
0.417 |
0.5 |
0.05776 |
0.333 |
0.334 |
0.09911 |
|
|
|
|
|
|
|
|
|
|
|
|
7 |
0.142 |
0.143 |
0.28 |
0.357 |
0.5 |
0.05496 |
0.286 |
0.334 |
0.0868 |
|
|
|
|
|
|
|
|
|
|
|
|
8 |
0.125 |
0.125 |
0.25 |
0.313 |
0.334 |
0.05111 |
0.25 |
0.334 |
0.07909 |
|
|
|
|
|
|
|
|
|
|
|
|
9 |
0.111 |
0.112 |
0.226 |
0.278 |
0.334 |
0.04731 |
0.222 |
0.25 |
0.07126 |
|
|
|
|
|
|
|
|
|
|
|
|
10 |
0.1 |
0.1 |
0.206 |
0.25 |
0.334 |
0.04448 |
0.2 |
0.25 |
0.06552 |
|
|
|
|
|
|
|
|
|
|
|
|
11 |
0.09 |
0.091 |
0.189 |
0.227 |
0.25 |
0.04123 |
0.182 |
0.2 |
0.05992 |
|
|
|
|
|
|
|
|
|
|
|
|
12 |
0.083 |
0.084 |
0.175 |
0.208 |
0.25 |
0.0387 |
0.167 |
0.2 |
0.05566 |
|
|
|
|
|
|
|
|
|
|
|
|
13 |
0.076 |
0.077 |
0.162 |
0.192 |
0.2 |
0.03633 |
0.154 |
0.167 |
0.0518 |
|
|
|
|
|
|
|
|
|
|
|
|
14 |
0.071 |
0.072 |
0.152 |
0.179 |
0.2 |
0.03389 |
0.143 |
0.167 |
0.04854 |
|
|
|
|
|
|
|
|
|
|
|
|
15 |
0.066 |
0.067 |
0.142 |
0.167 |
0.2 |
0.03217 |
0.133 |
0.143 |
0.04565 |
|
|
|
|
|
|
|
|
|
|
|
|
16 |
0.062 |
0.063 |
0.134 |
0.156 |
0.167 |
0.03063 |
0.125 |
0.143 |
0.04294 |
|
|
|
|
|
|
|
|
|
|
|
|
17 |
0.058 |
0.059 |
0.127 |
0.147 |
0.167 |
0.02905 |
0.118 |
0.125 |
0.04038 |
|
|
|
|
|
|
|
|
|
|
|
|
18 |
0.055 |
0.056 |
0.12 |
0.139 |
0.143 |
0.02757 |
0.111 |
0.112 |
0.03884 |
|
|
|
|
|
|
|
|
|
|
|
|
19 |
0.052 |
0.053 |
0.114 |
0.132 |
0.143 |
0.02616 |
0.105 |
0.112 |
0.03693 |
|
|
|
|
|
|
|
|
|
|
|
|
20 |
0.05 |
0.05 |
0.109 |
0.125 |
0.143 |
0.02517 |
0.1 |
0.112 |
0.03486 |
|
|
|
|
|
|
|
|
|
|
|
|
21 |
0.048 |
0.048 |
0.104 |
0.119 |
0.125 |
0.02408 |
0.095 |
0.1 |
0.03335 |
|
|
|
|
|
|
|
|
|
|
|
|
22 |
0.046 |
0.046 |
0.099 |
0.114 |
0.125 |
0.02296 |
0.091 |
0.1 |
0.03182 |
|
|
|
|
|
|
|
|
|
|
|
|
23 |
0.044 |
0.044 |
0.095 |
0.109 |
0.112 |
0.02226 |
0.087 |
0.091 |
0.03052 |
|
|
|
|
|
|
|
|
|
|
|
|
24 |
0.042 |
0.042 |
0.092 |
0.104 |
0.112 |
0.02157 |
0.083 |
0.084 |
0.02969 |
|
|
|
|
|
|
|
|
|
|
|
|
25 |
0.04 |
0.04 |
0.088 |
0.1 |
0.112 |
0.02058 |
0.08 |
0.084 |
0.02841 |
|
|
|
|
|
|
|
|
|
|
|
|
26 |
0.039 |
0.039 |
0.085 |
0.096 |
0.1 |
0.01989 |
0.077 |
0.084 |
0.02716 |
|
|
|
|
|
|
|
|
|
|
|
|
27 |
0.037 |
0.038 |
0.082 |
0.093 |
0.1 |
0.01902 |
0.074 |
0.077 |
0.02624 |
|
|
|
|
|
|
|
|
|
|
|
|
28 |
0.036 |
0.036 |
0.079 |
0.089 |
0.091 |
0.01866 |
0.071 |
0.072 |
0.02568 |
|
|
|
|
|
|
|
|
|
|
|
|
29 |
0.035 |
0.035 |
0.076 |
0.086 |
0.091 |
0.01803 |
0.069 |
0.072 |
0.02463 |
|
|
|
|
|
|
|
|
|
|
|
|
30 |
0.034 |
0.034 |
0.074 |
0.083 |
0.084 |
0.01766 |
0.067 |
0.072 |
0.02366 |
|
|
|
|
|
|
|
|
|
|
|
|
31 |
0.033 |
0.033 |
0.072 |
0.081 |
0.084 |
0.01688 |
0.065 |
0.067 |
0.02286 |
|
|
|
|
|
|
|
|
|
|
|
|
32 |
0.032 |
0.032 |
0.069 |
0.078 |
0.084 |
0.01655 |
0.063 |
0.067 |
0.02216 |
|
|
|
|
|
|
|
|
|
|
|
|
33 |
0.031 |
0.031 |
0.067 |
0.076 |
0.077 |
0.01585 |
0.061 |
0.063 |
0.02161 |
|
|
|
|
|
|
|
|
|
|
|
|
34 |
0.03 |
0.03 |
0.066 |
0.074 |
0.077 |
0.01532 |
0.059 |
0.063 |
0.02097 |
|
|
|
|
|
|
|
|
|
|
|
|
35 |
0.029 |
0.029 |
0.064 |
0.071 |
0.072 |
0.01532 |
0.057 |
0.059 |
0.02051 |
|
|
|
|
|
|
|
|
|
|
|
|
36 |
0.028 |
0.028 |
0.062 |
0.069 |
0.072 |
0.01494 |
0.056 |
0.059 |
0.01974 |
|
|
|
|
|
|
|
|
|
|
|
|
37 |
0.027 |
0.028 |
0.06 |
0.068 |
0.072 |
0.01425 |
0.054 |
0.056 |
0.0195 |
|
|
|
|
|
|
|
|
|
|
|
|
38 |
0.027 |
0.027 |
0.059 |
0.066 |
0.067 |
0.01393 |
0.053 |
0.056 |
0.01882 |
|
|
|
|
|
|
|
|
|
|
|
|
39 |
0.026 |
0.026 |
0.057 |
0.064 |
0.067 |
0.0137 |
0.051 |
0.053 |
0.0186 |
|
|
|
|
|
|
|
|
|
|
|
|
40 |
0.025 |
0.025 |
0.056 |
0.063 |
0.067 |
0.01317 |
0.05 |
0.053 |
0.01791 |
|
|
|
|
|
|
|
|
|
|
|
|
41 |
0.025 |
0.025 |
0.055 |
0.061 |
0.063 |
0.01306 |
0.049 |
0.05 |
0.01741 |
|
|
|
|
|
|
|
|
|
|
|
|
42 |
0.024 |
0.024 |
0.053 |
0.06 |
0.063 |
0.01261 |
0.048 |
0.05 |
0.01694 |
|
|
|
|
|
|
|
|
|
|
|
|
43 |
0.024 |
0.024 |
0.052 |
0.058 |
0.059 |
0.01248 |
0.047 |
0.048 |
0.01664 |
|
|
|
|
|
|
|
|
|
|
|
|
44 |
0.023 |
0.023 |
0.051 |
0.057 |
0.059 |
0.0121 |
0.045 |
0.046 |
0.01664 |
|
|
|
|
|
|
|
|
|
|
|
|
45 |
0.023 |
0.023 |
0.05 |
0.056 |
0.059 |
0.01175 |
0.044 |
0.046 |
0.01634 |
|
|
|
|
|
|
|
|
|
|
|
|
46 |
0.022 |
0.022 |
0.049 |
0.054 |
0.056 |
0.01175 |
0.043 |
0.044 |
0.01601 |
|
|
|
|
|
|
|
|
|
|
|
|
47 |
0.022 |
0.022 |
0.048 |
0.053 |
0.056 |
0.01153 |
0.043 |
0.044 |
0.01532 |
|
|
|
|
|
|
|
|
|
|
|
|
48 |
0.021 |
0.021 |
0.047 |
0.052 |
0.053 |
0.01126 |
0.042 |
0.044 |
0.01499 |
|
|
|
|
|
|
|
|
|
|
|
|
49 |
0.021 |
0.021 |
0.046 |
0.051 |
0.053 |
0.01102 |
0.041 |
0.042 |
0.01475 |
|
|
|
|
|
|
|
|
|
|
|
|
50 |
0.02 |
0.02 |
0.045 |
0.05 |
0.053 |
0.01072 |
0.04 |
0.042 |
0.0144 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
償却_旧法 |
償却_新法 |
指定なし |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
旧定額 |
定額 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
旧定率 |
定率 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19年度税制改正における減価償却制度の見直し |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
39173 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
20年度税制改正における耐用年数の見直し |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
39539 |
=B534+364 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
23年12月の税制改正における償却率の見直し |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
41000 |
41274 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
B、精算表 |
Excelバージョン |
旧バージョン用メッセージ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=IF(ISERR(VALUE(LEFT(INFO("release"),3))),10,VALUE(LEFT(INFO("release"),3))) |
=IF(B540<10,"Excel2000以前の場合、[▼] ボタンは、シート保護を解除してお使いください。","") |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
精算表 |
科目コード |
|
勘定科目 |
|
科目コード |
|
勘定科目 |
|
科目コード |
|
勘定科目 |
|
|
|
|
|
|
|
|
|
|
|
=クエリ!$B668 |
|
=IF(精算表!$B543="-","",クエリ!$C668) |
|
=クエリ!$B799 |
|
=IF(精算表!$B543="-","",クエリ!$C799) |
|
=クエリ!$B904 |
|
=IF(精算表!$B543="-","",クエリ!$C904) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
元帳@ |
仕訳帳入力ミス用メッセージ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
=IF(仕訳帳!E1<>"",仕訳帳!E1,IF(AND(仕訳帳!E3="",精算表!H142=精算表!I142),"","〔仕訳帳〕シートに科目コードの入力ミスがあります!")) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Copyright Toshiei Niitsuma 2007-2014. All Rights Reserved |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|