※ 概観プレビューです。実際のレイアウトはダウンロードしたファイルでご確認ください。
改訂履歴
| Ver | 日付 | 改定内容 |
| 1 | 2026-01-22 | 新規作成 |
| 1.1 | 2026-01-28 | 数式誤り、表記ゆれ、台帳項目の追加 |
| 1.2 | 2026-03-06 | 第6回用に修正、表記ゆれ、書式の修正 |
宣誓書
| 1人当たり給与支給総額の確認書 | |||||||||||||
| 第6回公募受付用 | |||||||||||||
| 株式会社サンプル金属加工 | |||||||||||||
| 応募申請時点における対象となる従業員及び1人当たり給与支給額について | |||||||||||||
| 記載した内容に間違いがないことを証明します。 | |||||||||||||
| 対象となる従業員及び算定対象となる給与の考え方については以下になります。 | |||||||||||||
| 詳細は公募要領・申請の手引きをご確認ください。 | |||||||||||||
| ■対象となる従業員 | |||||||||||||
| 基準年度及びその算出対象となる各事業年度において、全月分の給与等の支給を受けた従業員とします。 | |||||||||||||
| 中途採用や退職等で全月分の給与等の支給を受けていない従業員については、 | |||||||||||||
| 全月分の給与等の支給を受けていない事業年度に限り、算出の対象から除く必要があります | |||||||||||||
| ■算定対象となる給与 | |||||||||||||
| 給料、賃金、賞与、各種手当(残業手当、休日出勤手当、職務手当、地域手当、家族(扶養)手当、住宅手当)等、 | |||||||||||||
| 給与所得として課税対象となる経費を指します。福利厚生費、法定福利費や退職金は除きます。 | |||||||||||||
| 当該事業年度において、産前・産後休業、育児休業、介護休業など事業者の福利厚生等により | |||||||||||||
| 時短勤務を行っている従業員は、算定対象から除くことができます。 | |||||||||||||
| ※直近決算の期間によって使用するシートが異なります。記入例をご確認の上、該当するシートにご記載ください。 | |||||||||||||
| 両シートに記載していただく必要はございません。 | |||||||||||||
| 賃金台帳における給与支給総額の算定対象となる科目 | |||||||||||||
直近決算 1年(12か月)
| ■基準年度(直近の決算期)が1年(12か月)の事業者 | ||||||||
| ※直近の決算期が1年(12か月)の事業者のみご使用ください。 | ||||||||
| 2024-04-01 | 2025-03-31 | 全月分の給与等の支給を受けた 従業員の給与支給総額 | 全月分の給与等の支給を受けた 従業員数 | 従業員1人当たり給与支給総額 | ||||
| {"formula":"IFERROR(SUMIFS($F$11:$F$3010,$J$11:$J$3010,FALSE,$I$11:$I$3010,TRUE),\"\")"} | {"formula":"COUNTIF($I$11:$I$3010,TRUE)-COUNTIFS($J$11:$J$3010,TRUE,$I$11:$I$3010,TRUE)"} | - | ||||||
| NO | 従業員番号等 | 対象従業員名 | 全月分の給与支給の 対象外 | 福利厚生等による時短勤務 | 給与支給額 | 入力チェック | ||
| 1 | E001 | 田中 一郎 | 4200000 | {"formula":"IF(AND(C11<>\"\",F11<>\"\"),TRUE,FALSE)"} | ||||
| {"formula":"IF(C12=\"\",\"\",A11+1)"} | E002 | 佐藤 花子 | 3900000 | {"formula":"IF(AND(C12<>\"\",F12<>\"\"),TRUE,FALSE)","ref":"I12:I75","shareType":"shared"} | ||||
| {"formula":"IF(C13=\"\",\"\",A12+1)","ref":"A13:A76","shareType":"shared"} | E003 | 鈴木 二郎 | 3200000 | {"sharedFormula":"I12"} | ||||
| {"sharedFormula":"A13"} | E004 | 高橋 三郎 | 2800000 | {"sharedFormula":"I12"} | ||||
| {"sharedFormula":"A13"} | E005 | 渡辺 四郎 | 4500000 | {"sharedFormula":"I12"} | ||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"sharedFormula":"I12"} | |||||||
| {"sharedFormula":"A13"} | {"formula":"IF(AND(C76<>\"\",F76<>\"\"),TRUE,FALSE)","ref":"I76:I139","shareType":"shared"} | |||||||
| {"formula":"IF(C77=\"\",\"\",A76+1)","ref":"A77:A140","shareType":"shared"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"sharedFormula":"I76"} | |||||||
| {"sharedFormula":"A77"} | {"formula":"IF(AND(C140<>\"\",F140<>\"\"),TRUE,FALSE)","ref":"I140:I203","shareType":"shared"} | |||||||
| {"formula":"IF(C141=\"\",\"\",A140+1)","ref":"A141:A204","shareType":"shared"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} | |||||||
| {"sharedFormula":"A141"} | {"sharedFormula":"I140"} |
【記入例】宣誓書
| 1人当たり給与支給総額の確認書 | |||||||||||||
| 第6回公募受付用 | |||||||||||||
| 事業者名 | |||||||||||||
| 応募申請時点における対象となる従業員及び1人当たり給与支給額について | |||||||||||||
| 記載した内容に間違いがないことを証明します。 | |||||||||||||
| 対象となる従業員及び算定対象となる給与の考え方については以下になります。 | |||||||||||||
| 詳細は公募要領・申請の手引きをご確認ください。 | |||||||||||||
| ■対象となる従業員 | |||||||||||||
| 基準年度及びその算出対象となる各事業年度において、全月分の給与等の支給を受けた従業員とします。 | |||||||||||||
| 中途採用や退職等で全月分の給与等の支給を受けていない従業員については、 | |||||||||||||
| 全月分の給与等の支給を受けていない事業年度に限り、算出の対象から除く必要があります | |||||||||||||
| ■算定対象となる給与 | |||||||||||||
| 給料、賃金、賞与、各種手当(残業手当、休日出勤手当、職務手当、地域手当、家族(扶養)手当、住宅手当)等、 | |||||||||||||
| 給与所得として課税対象となる経費を指します。福利厚生費、法定福利費や退職金は除きます。 | |||||||||||||
| 当該事業年度において、産前・産後休業、育児休業、介護休業など事業者の福利厚生等により | |||||||||||||
| 時短勤務を行っている従業員は、算定対象から除くことができます。 | |||||||||||||
| ※直近決算の期間によって使用するシートが異なります。記入例をご確認の上、該当するシートにご記載ください。 | |||||||||||||
| 両シートに記載していただく必要はございません。 | |||||||||||||
| 賃金台帳における給与支給総額の算定対象となる科目 | |||||||||||||
【記入例】直近決算 1年(12か月)
| ■基準年度(直近の決算期)が1年(12か月)の事業者 | ||||||||
| ※直近の決算期が1年の事業者のみご使用ください。 | ||||||||
| 直近の決算期(自) | 直近の決算期(至) | 全月分の給与等の支給を受けた 従業員の給与支給総額 | 全月分の給与等の支給を受けた 従業員数 | 従業員1人当たり給与支給総額 | ||||
| 2024-04-01 | 2025-03-31 | 11500000 | 3 | 3833333.33 | ||||
| NO | 従業員番号等 | 対象従業員名 | 全月分の給与支給の 対象外 | 福利厚生等による時短勤務 | 給与支給額 | 対象外チェック | ||
| 1 | 11111 | a | 4000000 | {"formula":"IF(D19=\"☑\",TRUE,FALSE)"} | ||||
| 2 | 22222 | b | 5000000 | {"formula":"IF(D20=\"☑\",TRUE,FALSE)","ref":"I20:I83","shareType":"shared"} | ||||
| 3 | 33333 | C | ☑ | 4500000 | true | |||
| 4 | 44444 | d | ☑ | 2500000 | {"sharedFormula":"I20"} | |||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"sharedFormula":"I20"} | |||||||
| {"sharedFormula":"A21"} | {"formula":"IF(D84=\"☑\",TRUE,FALSE)","ref":"I84:I147","shareType":"shared"} | |||||||
| {"formula":"IF(C85=\"\",\"\",A84+1)","ref":"A85:A148","shareType":"shared"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"sharedFormula":"I84"} | |||||||
| {"sharedFormula":"A85"} | {"formula":"IF(D148=\"☑\",TRUE,FALSE)","ref":"I148:I211","shareType":"shared"} | |||||||
| {"formula":"IF(C149=\"\",\"\",A148+1)","ref":"A149:A212","shareType":"shared"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} | |||||||
| {"sharedFormula":"A149"} | {"sharedFormula":"I148"} |
※直近決算 1年(12か月)未満のみ使用※
| ■基準年度(直近の決算期)が1年(12か月)未満の事業者 | 直近の決算期(自) | 直近の決算期(至) | ||||||
| ※直近の決算期が1年に満たない事業者のみご使用ください。 | ||||||||
| 上記に該当しない事業者はこちらをクリックしてください。 | ||||||||
| 直近決算期における月数 | 直近決算期における 従業員の給与支給総額 | 12か月換算における 従業員の給与支給総額 | 全月分の給与等の支給を受けた 従業員数 | 12か月分換算 従業員1人当たり給与支給総額 | ||||
| {"formula":"IF(AND(E3=\"\",F3=\"\"),\"\",IFERROR(DATEDIF(E3,F3,\"M\")+1,\"\"))"} | {"formula":"IFERROR(SUMIFS($F$12:$F$3011,$J$12:$J$3011,FALSE,$I$12:$I$3011,TRUE),\"\")"} | {"formula":"IFERROR(C7/B7*12,0)"} | {"formula":"COUNTIF($I$12:$I$3011,TRUE)-COUNTIFS($J$12:$J$3011,TRUE,$I$12:$I$3011,TRUE)"} | - | ||||
| NO | 従業員番号等 | 対象従業員名 | 全月分の給与支給の 対象外 | 福利厚生等による時短勤務 | 給与支給額 | 入力チェック | ||
| 1 | {"formula":"IF(AND(C12<>\"\",F12<>\"\"),TRUE,FALSE)"} | |||||||
| {"formula":"IF(C13=\"\",\"\",A12+1)"} | {"formula":"IF(AND(C13<>\"\",F13<>\"\"),TRUE,FALSE)","ref":"I13:I76","shareType":"shared"} | |||||||
| {"formula":"IF(C14=\"\",\"\",A13+1)","ref":"A14:A77","shareType":"shared"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"sharedFormula":"I13"} | |||||||
| {"sharedFormula":"A14"} | {"formula":"IF(AND(C77<>\"\",F77<>\"\"),TRUE,FALSE)","ref":"I77:I140","shareType":"shared"} | |||||||
| {"formula":"IF(C78=\"\",\"\",A77+1)","ref":"A78:A141","shareType":"shared"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"sharedFormula":"I77"} | |||||||
| {"sharedFormula":"A78"} | {"formula":"IF(AND(C141<>\"\",F141<>\"\"),TRUE,FALSE)","ref":"I141:I204","shareType":"shared"} | |||||||
| {"formula":"IF(C142=\"\",\"\",A141+1)","ref":"A142:A205","shareType":"shared"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
| {"sharedFormula":"A142"} | {"sharedFormula":"I141"} | |||||||
【記入例】直近決算 1年(12か月)未満
| ■基準年度(直近の決算期)が1年(12か月)未満の事業者 | 直近の決算期(自) | 直近の決算期(至) | |||||
| ※直近の決算期が1年に満たない事業者のみご使用ください。 | 2025-04-01 | 2025-11-30 | |||||
| 上記に該当しない事業者はこちらをクリックしてください。 | |||||||
| 直近決算期における月数 | 直近決算期における 従業員の給与支給総額 | 全月分の給与等の支給を受けた 従業員の給与支給総額 | 全月分の給与等の支給を受けた 従業員数 | 12か月分換算 従業員1人当たり給与支給総額 | |||
| 8 | 11500000 | 17250000 | 3 | 5750000 | |||
| NO | 従業員番号等 | 対象従業員名 | 全月分の給与支給の 対象外 | 福利厚生等による時短勤務 | 給与支給額 | ||
| 1 | 11111 | a | 4000000 | ||||
| 2 | 22222 | b | 5000000 | ||||
| 3 | 33333 | C | ☑ | 4500000 | |||
| 4 | 44444 | d | ☑ | 2500000 | |||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"sharedFormula":"A22"} | |||||||
| {"formula":"IF(C86=\"\",\"\",A85+1)","ref":"A86:A149","shareType":"shared"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"sharedFormula":"A86"} | |||||||
| {"formula":"IF(C150=\"\",\"\",A149+1)","ref":"A150:A213","shareType":"shared"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} | |||||||
| {"sharedFormula":"A150"} |