{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["横長","社員マスタ","伝票風","月額表"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":49,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"横長","index":0,"n_rows":48,"n_cols":50,"rows_kept":48,"cut":false,"hidden":false,"merged":[[28,25,28,28],[28,29,28,32],[28,33,28,36],[28,37,28,40],[28,41,28,44],[28,45,28,48],[28,49,28,52],[0,10,0,12],[4,9,4,12],[21,41,21,44],[19,9,19,12],[20,9,20,12],[15,49,15,52],[16,49,16,52],[0,28,0,29],[0,31,0,32],[2,45,2,48],[13,39,13,41],[13,47,13,52],[26,10,26,12],[26,14,26,15],[26,24,26,26],[26,28,26,29],[26,31,26,32],[22,41,22,44],[22,45,22,48],[22,49,22,52],[7,0,7,4],[7,5,7,8],[7,9,7,12],[8,9,8,12],[24,0,24,8],[24,9,24,12],[17,17,17,20],[18,37,18,40],[17,49,17,52],[18,5,18,8],[18,9,18,12],[18,13,18,16],[18,17,18,20],[18,21,18,24],[18,41,18,44],[17,41,17,44],[17,45,17,48],[18,49,18,52],[19,5,19,8],[20,5,20,8],[17,21,17,24],[2,37,2,40],[20,0,20,4],[21,1,23,3],[22,13,22,16],[22,17,22,20],[22,21,22,24],[22,25,22,28],[22,29,22,32],[22,33,22,36],[22,37,22,40],[23,5,23,8],[2,13,2,16],[3,13,3,16],[3,9,3,12],[2,1,3,3],[4,1,6,3],[8,1,10,3],[2,5,2,8],[3,5,3,8],[2,9,2,12],[17,1,19,3],[17,5,17,8],[17,9,17,12],[17,13,17,16],[0,14,0,15],[4,5,4,8],[6,5,6,8],[5,5,5,8],[8,49,8,52],[9,49,9,52],[8,41,8,44],[9,41,9,44],[8,33,8,36],[9,33,9,36],[4,49,4,52],[4,41,4,44],[8,17,8,20],[9,17,9,20],[8,25,8,28],[9,25,9,28],[5,17,5,20],[5,25,5,28],[4,37,4,40],[4,17,4,20],[4,25,4,28],[0,24,0,26],[0,39,0,41],[0,47,0,52],[37,0,37,8],[37,9,37,12],[8,45,8,48],[9,45,9,48],[11,0,11,8],[10,9,10,12],[11,9,11,12],[8,37,8,40],[9,37,9,40],[8,21,8,24],[9,21,9,24],[8,13,8,16],[9,13,9,16],[8,29,8,32],[9,29,9,32],[9,9,9,12],[10,5,10,8],[35,17,35,20],[35,21,35,24],[35,25,35,28],[35,29,35,32],[35,33,35,36],[35,37,35,40],[35,41,35,44],[35,45,35,48],[35,49,35,52],[34,17,34,20],[34,21,34,24],[34,25,34,28],[34,29,34,32],[34,33,34,36],[34,37,34,40],[34,41,34,44],[34,45,34,48],[34,49,34,52],[34,1,36,3],[34,5,34,8],[34,9,34,12],[34,13,34,16],[35,5,35,8],[35,9,35,12],[35,13,35,16],[36,5,36,8],[36,9,36,12],[31,41,31,44],[31,45,31,48],[31,49,31,52],[31,17,31,20],[31,21,31,24],[31,25,31,28],[31,29,31,32],[31,33,31,36],[31,37,31,40],[31,5,31,8],[31,9,31,12],[31,13,31,16],[32,5,32,8],[32,9,32,12],[33,5,33,8],[33,9,33,12],[30,1,32,3],[33,0,33,4],[30,41,30,44],[30,45,30,48],[30,49,30,52],[29,5,29,8],[29,9,29,12],[29,13,29,16],[29,17,29,20],[29,21,29,24],[29,25,29,28],[29,29,29,32],[29,33,29,36],[29,37,29,40],[29,41,29,44],[30,5,30,8],[30,9,30,12],[30,13,30,16],[30,17,30,20],[30,21,30,24],[30,25,30,28],[30,29,30,32],[30,33,30,36],[30,37,30,40],[28,1,29,3],[28,5,28,8],[28,9,28,12],[28,13,28,16],[21,49,21,52],[23,9,23,12],[22,5,22,8],[22,9,22,12],[21,17,21,20],[21,21,21,24],[21,5,21,8],[21,9,21,12],[21,13,21,16],[21,25,21,28],[21,29,21,32],[21,33,21,36],[21,37,21,40],[21,45,21,48],[29,45,29,48],[29,49,29,52],[28,17,28,20],[28,21,28,24],[26,39,26,41],[26,47,26,52],[17,25,17,28],[17,29,17,32],[15,41,15,44],[16,41,16,44],[15,45,15,48],[18,45,18,48],[17,33,17,36],[17,37,17,40],[16,45,16,48],[18,25,18,28],[18,29,18,32],[18,33,18,36],[16,9,16,12],[16,13,16,16],[16,17,16,20],[16,21,16,24],[16,25,16,28],[16,29,16,32],[15,21,15,24],[15,25,15,28],[15,29,15,32],[2,41,2,44],[3,41,3,44],[4,45,4,48],[3,37,3,40],[15,1,16,3],[15,5,15,8],[15,9,15,12],[15,13,15,16],[15,17,15,20],[5,41,5,44],[16,5,16,8],[15,33,15,36],[15,37,15,40],[16,33,16,36],[16,37,16,40],[13,10,13,12],[13,14,13,15],[13,24,13,26],[13,28,13,29],[13,31,13,32],[6,9,6,12],[5,9,5,12],[8,5,8,8],[9,5,9,8],[2,29,2,32],[3,29,3,32],[3,17,3,20],[2,25,2,28],[3,25,3,28],[2,21,2,24],[3,21,3,24],[5,49,5,52],[4,13,4,16],[4,21,4,24],[4,29,4,32],[5,13,5,16],[5,21,5,24],[5,29,5,32],[5,33,5,36],[5,37,5,40],[5,45,5,48],[2,17,2,20],[2,33,2,36],[3,33,3,36],[4,33,4,36],[2,49,2,52],[3,45,3,48],[3,49,3,52]]}
["給与支給明細書",null,null,null,null,null,null,null,null,null,null,null,null,"年",null,null,"月分",null,null,null,"支給年月日",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",null,null,"コード",null,null,"A011",null,null,null,null,null,"氏名",null,{"$f":"LOOKUP(code1,社員マスタ,氏名)","v":"東京　花子"}]
[]
[null,"勤怠",null,null,null,"出勤日数",null,null,null,null,null,null,null,"欠勤日数",null,null,null,null,null,null,null,"有給休暇",null,null,null,null,null,null,null,"代休日数"]
[null,null,null,null,null,"残業時間",null,null,null,2,null,null,null,"早出残業",null,null,null,null,null,null,null,"早朝深夜"]
[null,"支給額",null,null,null,"基本給",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,基本給)","v":200001},null,null,null,"残業手当",null,null,null,{"$f":"J5/(8*21)*1.25*J4","v":2976.2053571428573},null,null,null,"通勤手当",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,通勤手当)","v":12010},null,null,null,"住宅手当",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,通勤手当)","v":12010},null,null,null,"家族手当",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,家族手当)","v":5010},null,null,null,"通勤費",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,通勤手当)","v":12010}]
[]
[null,null,null,null,null,"計",null,null,null,{"$f":"IF(J5+R5+Z5+AH5+AP5+AX5+J6+R6+Z6+AH6+AP6+AX6>0,J5+R5+Z5+AH5+AP5+AX5+J6+R6+Z6+AH6+AP6+AX6,\"\")","v":244017.20535714287}]
["課税対象額",null,null,null,null,"計",null,null,null,{"$f":"J7-AX5-J9-R9-Z9-AH9","v":204257.11933035715}]
[null,"控除額",null,null,null,"健康保険",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,健康保険)","v":7010},null,null,null,"介護保険",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,介護保険)","v":2510},null,null,null,"厚生年金",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,厚生年金)","v":17010},null,null,null,"雇用保険",null,null,null,{"$f":"J7*(5/1000)","v":1220.0860267857145}]
[null,null,null,null,null,"所得税",null,null,null,{"$f":"GenSenTax(課税対象額,LOOKUP(code1,社員マスタ,扶養人数))","v":4190},null,null,null,"住民税",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,住民税)","v":4010}]
[null,null,null,null,null,"計",null,null,null,{"$f":"J9+R9+Z9+AH9+J10+R10","v":35950.086026785713}]
["差引支給額",null,null,null,null,null,null,null,null,{"$f":"N(J7)-AX5-J9-R9-Z9-AH9","v":204257.11933035715}]
[]
["給与支給明細書",null,null,null,null,null,null,null,null,null,null,null,null,"年",null,null,"月分",null,null,null,"支給年月日",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",null,null,"コード",null,null,"A006",null,null,null,null,null,"氏名",null,{"$f":"LOOKUP(code2,社員マスタ,氏名)","v":"埼玉　４男"}]
[]
[null,"勤怠",null,null,null,"出勤日数",null,null,null,null,null,null,null,"欠勤日数",null,null,null,null,null,null,null,"有給休暇",null,null,null,null,null,null,null,"代休日数"]
[null,null,null,null,null,"残業時間",null,null,null,2,null,null,null,"早出残業",null,null,null,null,null,null,null,"早朝深夜"]
[null,"支給額",null,null,null,"基本給",null,null,null,{"$f":"LOOKUP(code2,社員マスタ,基本給)","v":960},null,null,null,"残業手当",null,null,null,{"$f":"J18/(8*21)*1.25*J17","v":14.285714285714286},null,null,null,"通勤手当",null,null,null,{"$f":"LOOKUP(code2,社員マスタ,通勤手当)","v":12005},null,null,null,"住宅手当",null,null,null,{"$f":"LOOKUP(code2,社員マスタ,住宅手当)","v":10005},null,null,null,"家族手当",null,null,null,{"$f":"LOOKUP(code2,社員マスタ,家族手当)","v":5005},null,null,null,"通勤費",null,null,null,{"$f":"LOOKUP(code2,社員マスタ,通勤手当)","v":12005}]
[]
[null,null,null,null,null,"計",null,null,null,{"$f":"IF(J18+R18+Z18+AH18+AP18+AX18+J19+R19+Z19+AH19+AP19+AX19>0,J18+R18+Z18+AH18+AP18+AX18+J19+R19+Z19+AH19+AP19+AX19,\"\")","v":39994.28571428571}]
["課税対象額",null,null,null,null,"計",null,null,null,{"$f":"J20-AX18-J22-R22-Z22-AH22","v":1274.3142857142816}]
[null,"控除額",null,null,null,"健康保険",null,null,null,{"$f":"LOOKUP(code2,社員マスタ,健康保険)","v":7005},null,null,null,"介護保険",null,null,null,{"$f":"LOOKUP(code2,社員マスタ,介護保険)","v":2505},null,null,null,"厚生年金",null,null,null,{"$f":"LOOKUP(code2,社員マスタ,厚生年金)","v":17005},null,null,null,"雇用保険",null,null,null,{"$f":"J20*(5/1000)","v":199.97142857142856}]
[null,null,null,null,null,"所得税",null,null,null,{"$f":"GenSenTax(課税対象額2,LOOKUP(code2,社員マスタ,扶養人数))","v":0},null,null,null,"住民税",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,住民税)","v":4010}]
[null,null,null,null,null,"計",null,null,null,{"$f":"J22+R22+Z22+AH22+J23+R23","v":30724.971428571429}]
["差引支給額",null,null,null,null,null,null,null,null,{"$f":"IF(N(J20)-N(J24)=0,\"\",N(J20)-N(J24))","v":9269.3142857142811}]
[]
["給与支給明細書",null,null,null,null,null,null,null,null,null,null,null,null,"年",null,null,"月分",null,null,null,"支給年月日",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",null,null,"コード",null,null,"A020",null,null,null,null,null,"氏名",null,{"$f":"LOOKUP(code3,社員マスタ,氏名)","v":"大坂　花子"}]
[]
[null,"勤怠",null,null,null,"出勤日数",null,null,null,null,null,null,null,"欠勤日数",null,null,null,null,null,null,null,"有給休暇",null,null,null,null,null,null,null,"代休日数"]
[null,null,null,null,null,"残業時間",null,null,null,2,null,null,null,"早出残業",null,null,null,null,null,null,null,"早朝深夜"]
[null,"支給額",null,null,null,"基本給",null,null,null,{"$f":"LOOKUP(code3,社員マスタ,基本給)","v":124300},null,null,null,"残業手当",null,null,null,{"$f":"J31/(8*21)*1.25*J30","v":1849.702380952381},null,null,null,"通勤手当",null,null,null,{"$f":"LOOKUP(code3,社員マスタ,通勤手当)","v":12019},null,null,null,"住宅手当",null,null,null,{"$f":"LOOKUP(code3,社員マスタ,住宅手当)","v":10019},null,null,null,"家族手当",null,null,null,{"$f":"LOOKUP(code3,社員マスタ,家族手当)","v":5019},null,null,null,"通勤費",null,null,null,{"$f":"LOOKUP(code3,社員マスタ,通勤手当)","v":12019}]
[]
[null,null,null,null,null,"計",null,null,null,{"$f":"IF(J31+R31+Z31+AH31+AP31+AX31+J32+R32+Z32+AH32+AP32+AX32>0,J31+R31+Z31+AH31+AP31+AX31+J32+R32+Z32+AH32+AP32+AX32,\"\")","v":165225.70238095237}]
["課税対象額",null,null,null,null,"計",null,null,null,{"$f":"J33-AX31-J35-R35-Z35-AH35","v":125823.5738690476}]
[null,"控除額",null,null,null,"健康保険",null,null,null,{"$f":"LOOKUP(code3,社員マスタ,健康保険)","v":7019},null,null,null,"介護保険",null,null,null,{"$f":"LOOKUP(code3,社員マスタ,介護保険)","v":2519},null,null,null,"厚生年金",null,null,null,{"$f":"LOOKUP(code3,社員マスタ,厚生年金)","v":17019},null,null,null,"雇用保険",null,null,null,{"$f":"J33*(5/1000)","v":826.12851190476181}]
[null,null,null,null,null,"所得税",null,null,null,{"$f":"GenSenTax(課税対象額3,LOOKUP(code3,社員マスタ,扶養人数))","v":1800},null,null,null,"住民税",null,null,null,{"$f":"LOOKUP(code3,社員マスタ,住民税)","v":4019}]
[null,null,null,null,null,"計",null,null,null,{"$f":"J35+R35+Z35+AH35+J36+R36","v":33202.128511904761}]
["差引支給額",null,null,null,null,null,null,null,null,{"$f":"IF(N(J33)-N(J37)=0,\"\",N(J33)-N(J37))","v":132023.5738690476}]
[]
[]
[null,"項目説明"]
[null,null,null,"：社員マスタの値をコードから索引して該当値が表示されます"]
[null,null,null,"：は手入力を行う"]
[null,null,null,"：自動計算されます"]
[null,"残業手当：基本給から日給を算出してから計算しています"]
[null,null,null,null,"日給単価が決まっているときは、計算値では固定値に書き換えてください"]
[null,null,null,null,"早出残業、早朝深夜には対応していません。自社の計算方法を入力してください。"]
[null,null,null,null,"シート保護はしていません、修正して使用する時はコピーして利用。"]

{"sheet":"社員マスタ","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["個人コード","氏名","基本給","残業手当","通勤手当","住宅手当","家族手当","健康保険","介護保険","厚生年金","住民税","扶養人数"]
["A001","埼玉　太郎",200000,null,12000,10000,5000,7000,2500,17000,4000,0]
["A002","埼玉　花子",200000,null,12001,10001,5001,7001,2501,17001,4001,0]
["A003","埼玉　次郎",200000,null,12002,10002,5002,7002,2502,17002,4002,0]
["A004","埼玉　２男",200000,null,12003,10003,5003,7003,2503,17003,4003,0]
["A005","埼玉　３男",200000,null,12004,10004,5004,7004,2504,17004,4004,2]
["A006","埼玉　４男",960,null,12005,10005,5005,7005,2505,17005,4005,1]
["A007","埼玉　５男",200000,null,12006,10006,5006,7006,2506,17006,4006,0]
["A008","埼玉　６男",200000,11,12007,10007,5007,7007,2507,17007,4007,0]
["A009","埼玉　７男",200000,null,12008,10008,5008,7008,2508,17008,4008,0]
["A010","東京　太郎",250000,null,12009,10009,5009,7009,2509,17009,4009,0]
["A011","東京　花子",200001,null,12010,10010,5010,7010,2510,17010,4010,1]
["A012","東京　次郎",200000,null,12011,10011,5011,7011,2511,17011,4011,0]
["A013","東京　２男",200000,null,12012,10012,5012,7012,2512,17012,4012,0]
["A014","東京　３男",200000,null,12013,10013,5013,7013,2513,17013,4013,0]
["A015","東京　４男",200000,null,12014,10014,5014,7014,2514,17014,4014,0]
["A016","東京　５男",200000,null,12015,10015,5015,7015,2515,17015,4015,0]
["A017","東京　６男",200000,null,12016,10016,5016,7016,2516,17016,4016,0]
["A018","東京　７男",200000,null,12017,10017,5017,7017,2517,17017,4017,0]
["A019","大坂　太郎",240000,null,12018,10018,5018,7018,2518,17018,4018,0]
["A020","大坂　花子",124300,null,12019,10019,5019,7019,2519,17019,4019,0]
["A021","大坂　次郎",200000,null,12020,10020,5020,7020,2520,17020,4020,0]
["A022","大坂　２男",200000,null,12021,10021,5021,7021,2521,17021,4021,0]
["A023","大坂　３男",200000,null,12022,10022,5022,7022,2522,17022,4022,0]
["A024","大坂　４男",200000,null,12023,10023,5023,7023,2523,17023,4023,0]
["A025","大坂　５男",200000,null,12024,10024,5024,7024,2524,17024,4024,0]
["A026","大坂　６男",200000,null,12025,10025,5025,7025,2525,17025,4025,0]
["A027","大坂　７男",200000,null,12026,10026,5026,7026,2526,17026,4026,0]

{"sheet":"伝票風","index":2,"n_rows":44,"n_cols":48,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,13,4,14],[4,16,4,17],[6,17,6,18],[6,19,6,20],[7,17,7,18],[7,19,7,20],[6,13,6,16],[7,13,7,16],[29,13,29,16],[29,17,29,20],[28,13,28,16],[28,17,28,20],[23,13,23,16],[23,17,23,20],[18,13,18,16],[18,17,18,20],[8,17,8,18],[8,19,8,20],[15,17,15,20],[16,13,16,16],[16,17,16,20],[17,13,17,16],[17,17,17,20],[11,17,11,20],[30,13,30,16],[30,17,30,20],[26,13,26,16],[26,17,26,20],[27,13,27,16],[27,17,27,20],[25,13,25,16],[25,17,25,20],[19,13,19,16],[19,17,19,20],[21,13,21,16],[21,17,21,20],[22,13,22,16],[22,17,22,20],[24,13,24,16],[24,17,24,20],[12,17,12,20],[9,17,9,18],[9,19,9,20],[13,13,13,16],[13,17,13,20],[14,13,14,16],[14,17,14,20],[8,13,8,16],[9,13,9,16],[11,13,11,16],[29,1,29,4],[30,1,30,4],[30,5,30,8],[18,1,18,4],[25,1,25,4],[26,1,26,4],[28,1,28,4],[26,5,26,8],[29,5,29,8],[28,5,28,8],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,5,25,8],[11,5,11,8],[12,5,12,8],[8,7,8,8],[9,7,9,8],[14,1,14,4],[6,7,6,8],[7,7,7,8],[15,13,15,16],[17,1,17,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[15,1,15,4],[12,13,12,16],[4,1,4,2],[4,4,4,5],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[27,1,27,4],[27,5,27,8],[19,5,19,8],[21,5,21,8],[22,5,22,8],[23,5,23,8],[24,5,24,8],[13,5,13,8],[14,5,14,8],[15,5,15,8],[16,5,16,8],[17,5,17,8],[18,5,18,8],[16,1,16,4],[19,1,19,4]]}
[null,null,null,"常勤者用",null,null,null,null,null,null,null,null,null,null,null,"パート用"]
[]
[]
[null,"給与支給明細書",null,null,null,null,null,null,null,null,null,null,null,"給与支給明細書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"氏名",null,{"$f":"LOOKUP(code1,社員マスタ!A3:A29,社員マスタ!B3:B29)","v":"東京　花子"}]
[null,null,null,"年",null,null,"月分",null,null,null,null,null,null,null,null,"年",null,null,"月分"]
[null,"a005",null,{"$f":"LOOKUP(ncd,社員マスタ!A2:A28,社員マスタ!B2:B28)&\" 様\"","v":"埼玉　３男 様"},null,null,null,null,null,null,null,null,null,"a006",null,{"$f":"LOOKUP(_ncd2,[0]!code_all,[0]!name_a)&\" 様\"","v":"埼玉　４男 様"}]
[null,"出勤日数",null,null,null,20,null,"日",null,null,null,null,null,"出勤日数",null,null,null,15,null,"日"]
[null,"欠勤日数",null,null,null,1,null,"日",null,null,null,null,null,"欠勤日数",null,null,null,0,null,"日"]
[null,"労働時間",null,null,null,null,null,"時間",null,null,null,null,null,"労働時間",null,null,null,100,null,"時間"]
[null,"時間外労働時間",null,null,null,4,null,"時間",null,null,null,null,null,"時間外労働時間",null,null,null,5,null,"時間"]
[]
[null,"基本給",null,null,null,{"$f":"LOOKUP(ycode1,社員マスタ,基本給)","v":200000},null,null,null,null,null,null,null,"基本給",null,null,null,{"$f":"LOOKUP(ycode2,社員マスタ,基本給)*de_day1","v":14400}]
[null,"残業手当",null,null,null,{"$f":"ROUND(F12/(8*21)*1.25*F10,0)","v":5952},null,null,null,null,null,null,null,"残業手当",null,null,null,{"$f":"ROUND(R12/(8*21)*1.25*R10,0)","v":536}]
[null,"通勤手当",null,null,null,{"$f":"LOOKUP(ycode1,社員マスタ,通勤手当)","v":12004},null,null,null,null,null,null,null,"通勤手当",null,null,null,{"$f":"LOOKUP(ycode2,社員マスタ,通勤手当)","v":12005}]
[null,"住宅手当",null,null,null,{"$f":"LOOKUP(ycode1,社員マスタ,住宅手当)","v":10004},null,null,null,null,null,null,null,"住宅手当",null,null,null,{"$f":"LOOKUP(ycode2,社員マスタ,住宅手当)","v":10005}]
[null,"家族手当",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,家族手当)","v":5010},null,null,null,null,null,null,null,"家族手当",null,null,null,{"$f":"LOOKUP(code2,社員マスタ,家族手当)","v":5005}]
[]
[]
[]
[null,"支給額計",null,null,null,{"$f":"SUM(F12:I19)","v":232970},null,null,null,null,null,null,null,"支給額計",null,null,null,{"$f":"SUM(R12:U19)","v":41951}]
[]
[null,"健康保険",null,null,null,{"$f":"LOOKUP(ycode1,社員マスタ,健康保険)","v":7004},null,null,null,null,null,null,null,"健康保険",null,null,null,{"$f":"LOOKUP(ycode2,社員マスタ,健康保険)","v":7005}]
[null,"厚生年金",null,null,null,{"$f":"LOOKUP(code1,社員マスタ,厚生年金)","v":17010},null,null,null,null,null,null,null,"厚生年金",null,null,null,{"$f":"LOOKUP(code2,社員マスタ,厚生年金)","v":17005}]
[null,"介護保険",null,null,null,{"$f":"LOOKUP(ycode1,社員マスタ,介護保険)","v":2504},null,null,null,null,null,null,null,"介護保険",null,null,null,{"$f":"LOOKUP(ycode2,社員マスタ,介護保険)","v":2505}]
[null,"雇用保険",null,null,null,{"$f":"ROUND(支給額計*(3/1000),0)","v":699},null,null,null,null,null,null,null,"雇用保険",null,null,null,{"$f":"ROUND(支給額計*(3/1000),0)","v":699}]
[null,"所得税",null,null,null,{"$f":"GenSenTax(課税対象額,LOOKUP(ycode1,社員マスタ,扶養人数))","v":2580},null,null,null,null,null,null,null,"所得税",null,null,null,{"$f":"GenSenTax(課税対象額,LOOKUP(ycode2,社員マスタ,扶養人数))","v":4190}]
[null,"控除額計",null,null,null,{"$f":"SUM(F22:I26)","v":29797},null,null,null,null,null,null,null,"控除額計",null,null,null,{"$f":"SUM(R22:U26)","v":31404}]
[]
[]
[null,"課税対象額",null,null,null,{"$f":"支給額計-F22-F23-F24-F25","v":205753},null,null,null,null,null,null,null,"課税対象額",null,null,null,{"$f":"支給額計-R22-R23-R24-R25","v":205756}]
[null,"差引支給額",null,null,null,{"$f":"支給額計-F27","v":203173},null,null,null,null,null,null,null,"差引支給額",null,null,null,{"$f":"支給額計1-R27","v":10547}]
[]
[]
[]
[]
[]
[null,"項目説明"]
[null,null,null,"：社員マスタの値をコードから索引して該当値が表示されます"]
[null,null,null,"：は手入力を行う"]
[null,null,null,"：自動計算されます"]
[null,"残業手当：基本給から日給を算出してから計算しています"]
[null,null,null,null,"日給単価が決まっているときは、計算値では固定値に書き換えてください"]
[null,null,null,null,"早出残業、早朝深夜には対応していません。自社の計算方法を入力してください。"]
[null,null,null,null,"シート保護はしていません、修正して使用する時はコピーして利用。"]

{"sheet":"月額表","index":3,"n_rows":413,"n_cols":12,"rows_kept":413,"cut":false,"hidden":false,"merged":[[410,1,410,11],[411,1,411,11],[412,1,412,11],[405,1,405,11],[406,1,406,11],[407,1,407,11],[408,1,408,11],[409,1,409,11],[400,1,400,11],[401,1,401,11],[402,1,402,11],[403,1,403,11],[404,1,404,11],[395,1,395,11],[396,1,396,11],[397,1,397,11],[398,1,398,11],[399,1,399,11],[390,1,390,11],[391,1,391,11],[392,1,392,11],[393,1,393,11],[394,1,394,11],[363,11,373,11],[374,11,386,11],[387,1,387,11],[388,1,388,11],[389,1,389,11],[0,1,0,11],[1,1,1,11],[290,11,299,11],[300,11,317,11],[320,11,362,11]]}
[null,"給与所得の源泉徴収税額表（令和８年分） 参考です　所得税は計算式によるものです"]
[null,"月　額　表（平成24年３月31日財務省告示第115号別表第一（令和７年４月30日財務省告示第122号改正））"]
[null,"   その月の社会保",null,"甲",null,null,null,null,null,null,null,"　"]
[null,"   険料等控除後の",null,"扶        養        親        族        等        の        数",null,null,null,null,null,null,null,"乙"]
[null,"   給与等の金額",null,"0  人","1  人","2  人","3  人","4  人","5  人","6  人","7  人"]
[null,"以  上","未  満","税                                            額",null,null,null,null,null,null,null,"税  額"]
[null,"円","円","円","円","円","円","円","円","円","円","円"]
[null,105000,"円未満",0,0,0,0,0,0,0,0,"その月の社会保険料等控除後の給与等の金額の3.063％に相当する金額"]
[]
[1,105000,107000,170,0,0,0,0,0,0,0,3800]
[2,107000,109000,280,0,0,0,0,0,0,0,3800]
[3,109000,111000,380,0,0,0,0,0,0,0,3900]
[4,111000,113000,480,0,0,0,0,0,0,0,4000]
[5,113000,115000,580,0,0,0,0,0,0,0,4100]
[]
[6,115000,117000,680,0,0,0,0,0,0,0,4100]
[7,117000,119000,790,0,0,0,0,0,0,0,4200]
[8,119000,121000,890,0,0,0,0,0,0,0,4300]
[9,121000,123000,990,0,0,0,0,0,0,0,4300]
[10,123000,125000,1090,0,0,0,0,0,0,0,4400]
[]
[11,125000,127000,1190,0,0,0,0,0,0,0,4700]
[12,127000,129000,1300,0,0,0,0,0,0,0,5000]
[13,129000,131000,1400,0,0,0,0,0,0,0,5300]
[14,131000,133000,1500,0,0,0,0,0,0,0,5500]
[15,133000,135000,1600,0,0,0,0,0,0,0,5800]
[]
[16,135000,137000,1710,0,0,0,0,0,0,0,6100]
[17,137000,139000,1810,190,0,0,0,0,0,0,6400]
[18,139000,141000,1910,300,0,0,0,0,0,0,6700]
[19,141000,143000,2010,400,0,0,0,0,0,0,7000]
[20,143000,145000,2110,500,0,0,0,0,0,0,7400]
[]
[21,145000,147000,2220,600,0,0,0,0,0,0,7700]
[22,147000,149000,2320,700,0,0,0,0,0,0,8000]
[23,149000,151000,2420,810,0,0,0,0,0,0,8300]
[24,151000,153000,2520,910,0,0,0,0,0,0,8600]
[25,153000,155000,2620,1010,0,0,0,0,0,0,8900]
[]
[26,155000,157000,2730,1110,0,0,0,0,0,0,9200]
[27,157000,159000,2830,1210,0,0,0,0,0,0,9500]
[28,159000,161000,2910,1300,0,0,0,0,0,0,9800]
[29,161000,163000,2980,1370,0,0,0,0,0,0,10100]
[30,163000,165000,3050,1440,0,0,0,0,0,0,10400]
[]
[31,165000,167000,3120,1510,0,0,0,0,0,0,10700]
[32,167000,169000,3200,1580,0,0,0,0,0,0,11000]
[33,169000,171000,3270,1650,0,0,0,0,0,0,11300]
[34,171000,173000,3340,1730,100,0,0,0,0,0,11500]
[35,173000,175000,3410,1800,170,0,0,0,0,0,11800]
[]
[36,175000,177000,3480,1870,250,0,0,0,0,0,12100]
[37,177000,179000,3550,1940,320,0,0,0,0,0,12500]
[38,179000,181000,3620,2010,390,0,0,0,0,0,12800]
[39,181000,183000,3700,2080,460,0,0,0,0,0,13300]
[40,183000,185000,3770,2150,530,0,0,0,0,0,14000]
[]
[41,185000,187000,3840,2230,600,0,0,0,0,0,14700]
[42,187000,189000,3910,2300,670,0,0,0,0,0,15400]
[43,189000,191000,3980,2370,750,0,0,0,0,0,16100]
[44,191000,193000,4050,2440,820,0,0,0,0,0,16800]
[45,193000,195000,4120,2510,890,0,0,0,0,0,17600]
[]
[46,195000,197000,4200,2580,960,0,0,0,0,0,18300]
[47,197000,199000,4270,2650,1030,0,0,0,0,0,19000]
[48,199000,201000,4340,2730,1100,0,0,0,0,0,19700]
[49,201000,203000,4410,2800,1170,0,0,0,0,0,20400]
[50,203000,205000,4480,2870,1250,0,0,0,0,0,21000]
[]
[51,205000,207000,4550,2940,1320,0,0,0,0,0,21700]
[52,207000,209000,4630,3010,1390,0,0,0,0,0,22500]
[53,209000,211000,4700,3080,1460,0,0,0,0,0,23000]
[54,211000,213000,4770,3150,1530,0,0,0,0,0,23600]
[55,213000,215000,4840,3230,1600,0,0,0,0,0,24100]
[]
[56,215000,217000,4910,3300,1670,0,0,0,0,0,24700]
[57,217000,219000,4980,3370,1750,130,0,0,0,0,25300]
[58,219000,221000,5050,3440,1820,200,0,0,0,0,25800]
[59,221000,224000,5150,3520,1910,300,0,0,0,0,26400]
[60,224000,227000,5250,3630,2020,400,0,0,0,0,27500]
[]
[61,227000,230000,5360,3740,2120,510,0,0,0,0,28500]
[62,230000,233000,5460,3850,2240,610,0,0,0,0,29500]
[63,233000,236000,5570,3950,2340,720,0,0,0,0,30500]
[64,236000,239000,5680,4060,2450,830,0,0,0,0,31500]
[65,239000,242000,5790,4170,2550,940,0,0,0,0,32600]
[]
[66,242000,245000,5890,4280,2660,1040,0,0,0,0,33600]
[67,245000,248000,6000,4380,2770,1150,0,0,0,0,34600]
[68,248000,251000,6110,4490,2880,1260,0,0,0,0,35500]
[69,251000,254000,6220,4590,2980,1370,0,0,0,0,36600]
[70,254000,257000,6320,4710,3090,1470,0,0,0,0,37600]
[]
[71,257000,260000,6430,4810,3200,1580,0,0,0,0,38600]
[72,260000,263000,6530,4920,3310,1680,0,0,0,0,39600]
[73,263000,266000,6650,5020,3410,1800,170,0,0,0,40600]
[74,266000,269000,6750,5140,3520,1900,290,0,0,0,41700]
[75,269000,272000,6860,5240,3620,2010,390,0,0,0,42700]
[]
[76,272000,275000,6960,5350,3740,2110,500,0,0,0,43700]
[77,275000,278000,7080,5450,3840,2230,600,0,0,0,44700]
[78,278000,281000,7180,5560,3950,2330,710,0,0,0,45600]
[79,281000,284000,7290,5670,4050,2440,820,0,0,0,46700]
[80,284000,287000,7390,5780,4170,2540,930,0,0,0,47800]
[]
[81,287000,290000,7500,5880,4270,2650,1030,0,0,0,48900]
[82,290000,293000,7610,5990,4380,2760,1140,0,0,0,50000]
[83,293000,296000,7720,6100,4480,2870,1250,0,0,0,51300]
[84,296000,299000,7820,6210,4590,2970,1360,0,0,0,52400]
[85,299000,302000,7930,6320,4700,3080,1470,0,0,0,53600]
[]
[86,302000,305000,8060,6440,4820,3210,1590,0,0,0,54500]
[87,305000,308000,8180,6570,4940,3330,1720,0,0,0,55200]
[88,308000,311000,8300,6690,5060,3450,1840,210,0,0,56100]
[89,311000,314000,8550,6810,5190,3570,1960,340,0,0,56900]
[90,314000,317000,8790,6930,5310,3700,2080,460,0,0,57700]
[]
[91,317000,320000,9040,7060,5430,3820,2210,580,0,0,58500]
[92,320000,323000,9280,7180,5550,3940,2330,700,0,0,59500]
[93,323000,326000,9530,7300,5680,4060,2450,830,0,0,60500]
[94,326000,329000,9770,7420,5800,4190,2570,950,0,0,61600]
[95,329000,332000,10020,7550,5920,4310,2700,1070,0,0,62600]
[]
[96,332000,335000,10260,7670,6040,4430,2820,1190,0,0,63700]
[97,335000,338000,10510,7790,6170,4550,2940,1320,0,0,64700]
[98,338000,341000,10750,7910,6290,4680,3060,1440,0,0,65800]
[99,341000,344000,11000,8040,6410,4800,3190,1560,0,0,66800]
[100,344000,347000,11240,8160,6530,4920,3310,1680,0,0,67800]
[]
[101,347000,350000,11490,8280,6660,5040,3430,1810,190,0,68800]
[102,350000,353000,11730,8500,6780,5170,3550,1930,320,0,69800]
[103,353000,356000,11980,8750,6900,5290,3680,2050,440,0,70900]
[104,356000,359000,12220,9000,7020,5410,3800,2170,560,0,71900]
[105,359000,362000,12470,9240,7150,5530,3920,2300,680,0,72900]
[]
[106,362000,365000,12710,9490,7270,5660,4040,2420,810,0,73900]
[107,365000,368000,12960,9730,7390,5780,4170,2540,930,0,74900]
[108,368000,371000,13200,9980,7510,5900,4290,2660,1050,0,76000]
[109,371000,374000,13450,10220,7640,6020,4410,2790,1170,0,76900]
[110,374000,377000,13690,10470,7760,6150,4530,2910,1300,0,77800]
[]
[111,377000,380000,13940,10710,7880,6270,4660,3030,1420,0,78700]
[112,380000,383000,14180,10960,8000,6390,4780,3150,1540,0,79600]
[113,383000,386000,14430,11200,8130,6510,4900,3280,1660,0,80600]
[114,386000,389000,14670,11450,8250,6640,5020,3400,1790,170,82000]
[115,389000,392000,14920,11690,8450,6760,5150,3520,1910,300,83600]
[]
[116,392000,395000,15160,11940,8700,6880,5270,3640,2030,420,85400]
[117,395000,398000,15410,12180,8940,7000,5390,3770,2150,540,87100]
[118,398000,401000,15650,12430,9190,7130,5510,3890,2280,660,88700]
[119,401000,404000,15900,12670,9430,7250,5640,4010,2400,790,90500]
[120,404000,407000,16140,12920,9680,7370,5760,4140,2520,910,92200]
[]
[121,407000,410000,16390,13160,9920,7490,5880,4260,2640,1030,93800]
[122,410000,413000,16630,13410,10170,7620,6000,4380,2770,1150,95600]
[123,413000,416000,16880,13650,10410,7740,6130,4500,2890,1280,97300]
[124,416000,419000,17120,13900,10660,7860,6250,4630,3010,1400,98900]
[125,419000,422000,17370,14140,10900,7980,6370,4750,3130,1520,100700]
[]
[126,422000,425000,17610,14390,11150,8110,6490,4870,3260,1640,102400]
[127,425000,428000,17860,14630,11390,8230,6620,4990,3380,1770,104000]
[128,428000,431000,18100,14880,11640,8400,6740,5120,3500,1890,105800]
[129,431000,434000,18350,15120,11880,8650,6860,5240,3620,2010,107500]
[130,434000,437000,18590,15370,12130,8890,6980,5360,3750,2130,109100]
[]
[131,437000,440000,18840,15610,12370,9140,7110,5480,3870,2260,110900]
[132,440000,443000,19080,15860,12620,9380,7230,5610,3990,2380,112600]
[133,443000,446000,19330,16100,12860,9630,7350,5730,4110,2500,114200]
[134,446000,449000,19570,16350,13110,9870,7470,5850,4240,2620,116000]
[135,449000,452000,19860,16590,13350,10120,7600,5970,4360,2750,117600]
[]
[136,452000,455000,20350,16840,13600,10360,7720,6100,4480,2870,119400]
[137,455000,458000,20840,17080,13840,10610,7840,6220,4600,2990,121100]
[138,458000,461000,21330,17330,14090,10850,7960,6340,4730,3110,122700]
[139,461000,464000,21820,17570,14330,11100,8090,6460,4850,3240,124500]
[140,464000,467000,22310,17820,14580,11340,8210,6590,4970,3360,126200]
[]
[141,467000,470000,22800,18060,14820,11590,8360,6710,5090,3480,127800]
[142,470000,473000,23290,18310,15070,11830,8610,6830,5220,3600,129600]
[143,473000,476000,23780,18550,15320,12080,8850,6950,5340,3730,131200]
[144,476000,479000,24270,18800,15560,12320,9100,7080,5460,3850,132800]
[145,479000,482000,24760,19040,15810,12570,9340,7200,5580,3970,134500]
[]
[146,482000,485000,25250,19290,16050,12810,9590,7320,5710,4090,136100]
[147,485000,488000,25740,19530,16300,13060,9830,7440,5830,4220,137600]
[148,488000,491000,26230,19780,16540,13300,10080,7570,5950,4340,139300]
[149,491000,494000,26720,20260,16790,13550,10320,7690,6070,4460,140900]
[150,494000,497000,27210,20750,17030,13790,10570,7810,6200,4580,142500]
[]
[151,497000,500000,27700,21240,17280,14040,10810,7930,6320,4710,144100]
[152,500000,503000,28190,21730,17520,14280,11060,8060,6440,4830,145700]
[153,503000,506000,28680,22220,17770,14530,11300,8180,6570,4950,147300]
[154,506000,509000,29170,22710,18010,14770,11550,8310,6690,5070,149000]
[155,509000,512000,29660,23200,18260,15020,11790,8560,6810,5200,150500]
[]
[156,512000,515000,30150,23690,18500,15260,12040,8800,6930,5320,152100]
[157,515000,518000,30640,24180,18750,15510,12280,9050,7060,5440,153800]
[158,518000,521000,31130,24670,18990,15750,12530,9290,7180,5560,155400]
[159,521000,524000,31620,25160,19240,16000,12770,9540,7300,5690,156900]
[160,524000,527000,32110,25650,19480,16240,13020,9780,7420,5810,158600]
[]
[161,527000,530000,32600,26140,19730,16490,13260,10030,7550,5930,160200]
[162,530000,533000,33090,26630,20160,16730,13510,10270,7670,6050,161600]
[163,533000,536000,33580,27120,20650,16980,13750,10520,7790,6180,163200]
[164,536000,539000,34070,27610,21140,17220,14000,10760,7910,6300,164600]
[165,539000,542000,34560,28100,21630,17470,14240,11010,8040,6420,166000]
[]
[166,542000,545000,35050,28590,22130,17710,14490,11250,8160,6540,167500]
[167,545000,548000,35540,29080,22620,17960,14730,11500,8280,6670,169000]
[168,548000,551000,36030,29570,23110,18200,14980,11740,8500,6790,170500]
[169,551000,554000,36570,30110,23650,18480,15240,12020,8780,6920,171900]
[170,554000,557000,37120,30660,24200,18760,15520,12290,9060,7060,173400]
[]
[171,557000,560000,37670,31210,24750,19030,15790,12570,9330,7200,174900]
[172,560000,563000,38230,31760,25300,19310,16070,12840,9610,7330,176300]
[173,563000,566000,38780,32310,25850,19580,16350,13120,9880,7470,177900]
[174,566000,569000,39330,32870,26400,19930,16620,13400,10160,7610,179300]
[175,569000,572000,39880,33420,26950,20480,16900,13670,10430,7750,180700]
[]
[176,572000,575000,40430,33970,27510,21030,17170,13950,10710,7880,182200]
[177,575000,578000,40980,34520,28060,21580,17450,14220,10990,8030,183700]
[178,578000,581000,41530,35070,28610,22140,17720,14500,11260,8160,185200]
[179,581000,584000,42090,35620,29160,22690,18000,14770,11540,8300,186600]
[180,584000,587000,42640,36170,29710,23240,18280,15050,11810,8580,188100]
[]
[181,587000,590000,43190,36730,30260,23790,18550,15330,12090,8850,189600]
[182,590000,593000,43740,37280,30810,24340,18830,15600,12360,9130,191000]
[183,593000,596000,44290,37830,31370,24890,19100,15880,12640,9400,192600]
[184,596000,599000,44840,38380,31920,25440,19380,16150,12920,9680,194000]
[185,599000,602000,45390,38930,32470,25990,19650,16430,13190,9950,195400]
[]
[186,602000,605000,45950,39480,33020,26550,20080,16700,13470,10230,197000]
[187,605000,608000,46500,40030,33570,27100,20630,16980,13740,10510,198400]
[188,608000,611000,47050,40580,34120,27650,21190,17250,14020,10780,199900]
[189,611000,614000,47600,41140,34670,28200,21740,17530,14290,11060,201300]
[190,614000,617000,48150,41690,35220,28750,22290,17810,14570,11330,202800]
[]
[191,617000,620000,48700,42240,35780,29300,22840,18080,14850,11610,204300]
[192,620000,623000,49250,42790,36330,29850,23390,18360,15120,11880,205700]
[193,623000,626000,49800,43340,36880,30410,23940,18630,15400,12160,207300]
[194,626000,629000,50360,43890,37430,30960,24490,18910,15670,12440,208700]
[195,629000,632000,50910,44440,37980,31510,25050,19180,15950,12710,210100]
[]
[196,632000,635000,51460,45000,38530,32060,25600,19460,16220,12990,211700]
[197,635000,638000,52010,45550,39080,32610,26150,19740,16500,13260,213100]
[198,638000,641000,52560,46100,39640,33160,26700,20240,16780,13540,214600]
[199,641000,644000,53110,46650,40190,33710,27250,20790,17050,13810,215900]
[200,644000,647000,53660,47200,40740,34260,27800,21340,17330,14090,217000]
[]
[201,647000,650000,54220,47750,41290,34820,28350,21890,17600,14370,218000]
[202,650000,653000,54770,48300,41840,35370,28900,22440,17880,14640,219000]
[203,653000,656000,55320,48850,42390,35920,29460,22990,18150,14920,220000]
[204,656000,659000,55870,49410,42940,36470,30010,23540,18430,15190,221000]
[205,659000,662000,56420,49960,43490,37020,30560,24100,18700,15470,222100]
[]
[206,662000,665000,56970,50510,44050,37570,31110,24650,18980,15740,223100]
[207,665000,668000,57520,51060,44600,38120,31660,25200,19260,16020,224100]
[208,668000,671000,58070,51610,45150,38680,32210,25750,19530,16300,225000]
[209,671000,674000,58630,52160,45700,39230,32760,26300,19830,16570,226000]
[210,674000,677000,59180,52710,46250,39780,33320,26850,20380,16850,227100]
[]
[211,677000,680000,59730,53270,46800,40330,33870,27400,20930,17120,228100]
[212,680000,683000,60280,53820,47350,40880,34420,27950,21480,17400,229100]
[213,683000,686000,60830,54370,47910,41430,34970,28510,22030,17670,230100]
[214,686000,689000,61380,54920,48460,41980,35520,29060,22580,17950,231500]
[215,689000,692000,61930,55470,49010,42530,36070,29610,23140,18220,233000]
[]
[216,692000,695000,62490,56020,49560,43090,36620,30160,23690,18500,234500]
[217,695000,698000,63040,56570,50110,43640,37170,30710,24240,18780,236100]
[218,698000,701000,63590,57120,50660,44190,37730,31260,24790,19050,237600]
[219,701000,704000,64140,57680,51210,44740,38280,31810,25340,19330,239100]
[220,704000,707000,64690,58230,51760,45290,38830,32370,25890,19600,240800]
[]
[221,707000,710000,65250,58780,52320,45850,39380,32920,26450,19980,242300]
[222,710000,713000,65860,59390,52930,46470,39990,33530,27070,20590,243800]
[223,713000,716000,66480,60000,53540,47080,40610,34140,27680,21210,245300]
[224,716000,719000,67090,60620,54150,47690,41220,34750,28290,21820,246900]
[225,719000,722000,67700,61230,54770,48300,41830,35370,28900,22430,248400]
[]
[226,722000,725000,68320,61840,55380,48920,42440,35980,29520,23040,250000]
[227,725000,728000,68930,62450,55990,49530,43060,36590,30130,23660,251600]
[228,728000,731000,69540,63070,56600,50140,43670,37210,30740,24270,253100]
[229,731000,734000,70150,63680,57220,50750,44280,37820,31350,24880,254600]
[230,734000,737000,70770,64290,57830,51370,44890,38430,31970,25490,256200]
[]
[231,737000,740000,71380,64900,58440,51980,45510,39040,32580,26110,257700]
[]
[]
[null,"740,000円",null,71680,65210,58750,52290,45810,39350,32890,26410,259200]
[]
[null,null,null,null,null,null,null,null,null,null,null,"259,200円に、その月の社会保険料等控除後の給与等の金額のうち740,000円を超える金額の40.84％に相当する金額を加算した金額"]
[]
[null," 740,000円を超え"]
[null,null,null," 740,000円の場合の税額に、その月の社会保険料等控除後の給与等の金額のうち"]
[]
[null," 790,000円に満た"]
[null,null,null," 740,000円を超える金額の20.42％に相当する金額を加算した金額"]
[null," ない金額"]
[]
[]
[null," ",null,null,null,null,null,null,null,null,null,"259,200円に、その月の社会保険料等控除後の給与等の金額のうち740,000円を超える金額の40.84％に相当する金額を加算した金額"]
[null,"790,000円",null,81890,75420,68960,62500,56020,49560,43100,36620]
[]
[null," 790,000円を超え"]
[null,null,null," 790,000円の場合の税額に、その月の社会保険料等控除後の給与等の金額のうち"]
[null," 960,000円に満た"]
[null,null,null," 790,000円を超える金額の23.483％に相当する金額を加算した金額"]
[null," ない金額"]
[]
[null," ",null,"円","円","円","円","円","円","円","円"]
[null,"960,000円",null,121820,115340,108880,102420,95940,89480,83020,76540]
[]
[null," 960,000円を超え"]
[null,null,null," 960,000円の場合の税額に、その月の社会保険料等控除後の給与等の金額のうち"]
[null," 1,710,000円に満た"]
[null,null,null," 960,000円を超える金額の33.693％に相当する金額を加算した金額"]
[null," ない金額"]
[]
[null," ",null,"円","円","円","円","円","円","円","円","円"]
[null,"1,710,000円",null,374520,368040,361580,355120,348640,342180,335720,329240,655400]
[null,null,null,null,null,null,null,null,null,null,null,"655,400円に、その月の社会保険料等控除後の給与等の金額のうち1,710,000円を超える金額の45.945％に相当する金額を加算した金額"]
[null," 1,710,000円を超え"]
[null,null,null," 1,710,000円の場合の税額に、その月の社会保険料等控除後の給与等の金額のうち"]
[null," 2,130,000円に満た"]
[null,null,null," 1,710,000円を超える金額の40.84％に相当する金額を加算した金額"]
[null," ない金額"]
[]
[null," ",null,"円","円","円","円","円","円","円","円"]
[null,"2,130,000円",null,549440,542970,536500,530040,523570,517110,510640,504170]
[]
[null," 2,130,000円を超え"]
[null,null,null," 2,130,000円の場合の税額に、その月の社会保険料等控除後の給与等の金額のうち"]
[null," 2,170,000円に満た"]
[null,null,null," 2,130,000円を超える金額の40.84％に相当する金額を加算した金額"]
[null," ない金額"]
[]
[null," ",null,"円","円","円","円","円","円","円","円"]
[null,"2,170,000円",null,571220,564750,558280,551820,545350,538880,532420,525950]
[]
[null," 2,170,000円を超え"]
[null,null,null," 2,170,000円の場合の税額に、その月の社会保険料等控除後の給与等の金額のうち"]
[null," 2,210,000円に満た"]
[null,null,null," 2,170,000円を超える金額の40.84％に相当する金額を加算した金額"]
[null," ない金額"]
[]
[null," ",null,"円","円","円","円","円","円","円","円"]
[null,"2,210,000円",null,593000,586520,580060,573600,567120,560660,554200,547730]
[]
[null," 2,210,000円を超え"]
[null,null,null," 2,210,000円の場合の税額に、その月の社会保険料等控除後の給与等の金額のうち"]
[null," 2,250,000円に満た"]
[null,null,null," 2,210,000円を超える金額の40.84％に相当する金額を加算した金額"]
[null," ない金額"]
[]
[null," ",null,"円","円","円","円","円","円","円","円"]
[null,"2,250,000円",null,614770,608300,601840,595380,588900,582440,575980,569500]
[]
[null," 2,250,000円を超え"]
[null,null,null," 2,250,000円の場合の税額に、その月の社会保険料等控除後の給与等の金額のうち"]
[null," 3,500,000円に満た"]
[null,null,null," 2,250,000円を超える金額の40.84％に相当する金額を加算した金額"]
[null," ない金額"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"655,400円に、その月の社会保険料等控除後の給与等の金額のうち1,710,000円を超える金額の45.945％に相当する金額を加算した金額"]
[null,"3,500,000円",null,1125270,1118800,1112340,1105880,1099400,1092940,1086480,1080000]
[]
[]
[]
[null," 3,500,000円を超え",null," 3,500,000円の場合の税額に、その月の社会保険料等控除後の給与等の金額のうち"]
[]
[null," る金額",null," 3,500,000円を超える金額の45.945％に相当する金額を加算した金額"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"従たる給与についての扶養控除等申告書が提出されている場合には、当該申告書に記載された扶養親族等の数に応じ、扶養親族等１人ごとに1,610円を、上の各欄によって求めた税額から控除した金額"]
[]
[]
[null,"　扶養親族等の数が７人を超える場合には、扶養親族等の数が７人の場合の税額から、その７人を超える"]
[]
[]
[]
[null,"　１人ごとに1,610円を控除した金額"]
[]
[]
[]
[]
[]
[null,"(注)  この表における用語の意味は、次のとおりです。"]
[null,"　１　「扶養親族等」とは、源泉控除対象配偶者及び源泉控除対象親族をいいます。"]
[null,"　２　「社会保険料等」とは、所得税法第74条第２項に規定する社会保険料及び同法第75条第２項に規定する小規模企業共済等掛金をいいます。"]
[null,"(備考）  税額の求め方は、次のとおりです。"]
[null,"　１　「給与所得者の扶養控除等申告書」（以下この表において「扶養控除等申告書」といいます。）の提出があった人"]
[null,"　　⑴  まず、その人のその月の給与等の金額から、その給与等の金額から控除される社会保険料等の金額を控除した金額を求めます。"]
[null,"    ⑵  次に、扶養控除等申告書により申告された扶養親族等（その申告書に記載がされていないものとされる源泉控除対象配偶者及び源泉控除対象親族を除"]
[null,"　　　きます。また、扶養親族等が非居住者である親族（以下この表において「国外居住親族」といいます。）である場合には、親族に該当する旨を証する書"]
[null,"　　　類（その国外居住親族である扶養親族等が年齢30歳以上70歳未満の控除対象扶養親族であり、かつ、留学により国内に住所及び居所を有しなくなった人"]
[null,"　　　である場合には、親族に該当する旨を証する書類及び留学により国内に住所及び居所を有しなくなった人に該当する旨を証する書類。２において同じで"]
[null,"　　　す。）がその申告書に添付され、又はその申告書の提出の際に提示された扶養親族等に限ります。）の数が７人以下である場合には、⑴により求めた金"]
[null,"      額に応じて「その月の社会保険料等控除後の給与等の金額」欄の該当する行を求め、その行と扶養親族等の数に応じた甲欄の該当欄との交わるところに"]
[null,"　　　記載されている金額を求めます。これが求める税額です。"]
[null,"    ⑶　扶養控除等申告書により申告された扶養親族等の数が７人を超える場合には、⑴により求めた金額に応じて、扶養親族等の数が７人であるものとして"]
[null,"      て⑵により求めた税額から、扶養親族等の数が７人を超える１人ごとに1,610円を控除した金額を求めます。これが求める税額です。"]
[null,"    ⑷　⑵及び⑶の場合において、扶養控除等申告書にその人が障害者（特別障害者を含みます。以下この表において同じです。）、寡婦、ひとり親又は勤労"]
[null,"      学生に該当する旨の記載があるときは、扶養親族等の数にこれらの一に該当するごとに１人を加算した数を、扶養控除等申告書にその人の同一生計配偶"]
[null,"      者又は扶養親族のうちに障害者又は同居特別障害者（障害者又は同居特別障害者が国外居住親族である場合には、親族に該当する旨を証する書類がその"]
[null,"　　　申告書に添付され、又はその申告書の提出の際に提示された障害者又は同居特別障害者に限ります。）に該当する人がいる旨の記載があるときは、扶養"]
[null,"　　　親族等の数にこれらの一に該当するごとに１人を加算した数を、それぞれ(2)及び(3)の扶養親族等の数とします。"]
[null,"　２  扶養控除等申告書の提出がない人（「従たる給与についての扶養控除等申告書」の提出があった人を含みます。）"]
[null,"　　　その人のその月の給与等の金額から、その給与等の金額から控除される社会保険料等の金額を控除し、その控除後の金額に応じた「その月の社会保険料"]
[null,"　　等控除後の給与等の金額」欄の該当する行と乙欄との交わるところに記載されている金額（「従たる給与についての扶養控除等申告書」の提出があった場"]
[null,"　　合には、その申告書により申告された扶養親族等（その申告書に記載がされていないものとされる源泉控除対象配偶者及び源泉控除対象親族を除きます。"]
[null,"　　また、扶養親族等が国外居住親族である場合には、親族に該当する旨を証する書類がその申告書に添付され、又はその申告書の提出の際に提示された扶養"]
[null,"　　親族等に限ります。）の数に応じ、扶養親族等１人ごとに1,610円を控除した金額）を求めます。これが求める税額です。"]