Brütten nette-Netten Brüte Ücret hesaplama_ELÇİNCE_2024.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	T	U
1			14%	1%						0.759%			15.50%	2%
3		Brüt	SSK İşçi	İşsizlik İşçi	Kümülatif Vergi Matrahı	Aylık Gelir Vergisi	Asgari ücret Kümülatif vergi matrahı	Vergi istisnası	İstisna sonrası Aylık Gelir Vergisi	Damga Vergisi	Net	Toplam Ele Geçen	SSK İşveren	İşsizlik İşveren	Toplam Maliyet		Net Ücret
4	1/31/2024	38,183.6	5,345.7	381.8	32,456.1	4,868.4	17,002.1	2,550.3	2,318.1	138.0	30,000.0	30,000.0	5,918.5	763.7	44,865.8	15.0%	30,000	28200.93436	38400
5	2/29/2024	38,183.6	5,345.7	381.8	64,912.2	4,868.4	34,004.3	2,550.3	2,318.1	138.0	30,000.0	30,000.0	5,918.5	763.7	44,865.8	15.0%	30,000	26600.93436	38400
6	3/31/2024	38,183.6	5,345.7	381.8	97,368.3	4,868.4	51,006.4	2,550.3	2,318.1	138.0	30,000.0	30,000.0	5,918.5	763.7	44,865.8	15.0%	30,000	24619.12936	38400
7	4/30/2024	39,657.8	5,552.1	396.6	131,077.4	6,110.2	68,008.5	2,550.3	3,559.9	149.2	30,000.0	30,000.0	6,147.0	793.2	46,597.9	18.1%	30,000	24306.99936	38400
8	5/31/2024	40,597.0	5,683.6	406.0	165,584.9	6,901.5	85,010.6	2,550.3	4,351.2	156.3	30,000.0	30,000.0	6,292.5	811.9	47,701.5	20.0%	30,000	24306.99936	38400
9	6/30/2024	40,597.0	5,683.6	406.0	200,092.4	6,901.5	102,012.8	2,550.3	4,351.2	156.3	30,000.0	30,000.0	6,292.5	811.9	47,701.5	20.0%	30,000	24306.99936	38400
10	7/31/2024	40,387.0	5,654.2	403.9	234,421.3	7,175.3	119,014.9	3,001.1	4,174.2	154.7	30,000.0	30,000.0	6,260.0	807.7	47,454.7	20.9%	30,000	31622.84838	49920
11	8/31/2024	43,151.1	6,041.2	431.5	271,099.7	9,903.2	136,017.0	3,400.4	6,502.8	175.7	30,000.0	30,000.0	6,688.4	863.0	50,702.6	27.0%	30,000	29296.53426	49920
12	9/30/2024	43,151.1	6,041.2	431.5	307,778.2	9,903.2	153,019.1	3,400.4	6,502.8	175.7	30,000.0	30,000.0	6,688.4	863.0	50,702.6	27.0%	30,000	28486.60132	49920
13	10/31/2024	43,151.1	6,041.2	431.5	344,456.7	9,903.2	170,021.3	3,400.4	6,502.8	175.7	30,000.0	30,000.0	6,688.4	863.0	50,702.6	27.0%	30,000	28486.60132	49920
14	11/30/2024	43,151.1	6,041.2	431.5	381,135.1	9,903.2	187,023.4	3,400.4	6,502.8	175.7	30,000.0	30,000.0	6,688.4	863.0	50,702.6	27.0%	30,000	28486.60132	49920
15	12/31/2024	43,151.1	6,041.2	431.5	417,813.6	9,903.2	204,025.5	3,400.4	6,502.8	175.7	30,000.0	30,000.0	6,688.4	863.0	50,702.6	27.0%	30,000	28486.60132	49920
16		491,545.37	68,816.35	4,915.45	417,813.56	91,209.66		35,305.10	55,904.56	1,909.00	360,000.00	360,000.00	76,189.53	9,830.91	577,565.81		360,000.00
17																	0.00
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106