Payroll..xlsx

	B	C	D	E	F	G	H
1
2	- Payroll Dashboard
3	- Payroll Dashboard
4	Pay Period: TealWave Solutions Inc. 2026 \| Currency: 0.05
5
6	TOTAL EMPLOYEES		TOTAL GROSS PAYROLL		TOTAL NET PAYROLL		TOTAL DEDUCTIONS
7
8	24		$158,833		$122,253		$36,580
9
10	Active on payroll		Before deductions		Paid out to staff		Tax + retirement + insurance
11
12	AVERAGE NET PAY		AVERAGE GROSS PAY		HIGHEST NET PAY		PENDING PAYMENTS
13
14	$5,094		$6,618		$7,719		3
15
16
17	Department Summary					Deduction Breakdown
18	Department	Headcount	Gross Pay	Net Pay		Category	Amount
19	Engineering	8	$40,247	$30,820		Federal Tax	$19,060
20	Sales	5	$42,716	$33,145		State Tax	$6,353
21	Marketing	2	$13,907	$10,686		Retirement 401k	$7,942
22	Finance	4	$28,152	$21,640		Health Insurance	$3,225
23	Human Resources	2	$18,146	$14,035
24	Operations	0	$0	$0
25	Customer Support	3	$15,665	$11,926
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44	Top 5 Net Pay Earners
45	Rank	Employee Name	Department	Net Pay
46	1	Emily Hill	Finance	$7,719
47	2	Brian Young	Sales	$7,475
48	3	Joseph Rodriguez	Human Resources	$7,268
49	4	Betty Thompson	Sales	$6,921
50	5	Karen Robinson	Sales	$6,806
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