Check for Retirement Gross and Deductions.xlsx

	A	B	C	D	E	F	G	H
1	Check Retirement Gross and Deductions
2	Fill-in
3	Calculation should be zero, or allow for pennies in rounding
4	Calculation, do not change
5
6	Payroll Report	Pay Item Summary	Pay Item Summary	~Wages with no Retirement~
7	Total Gross	400 SERS Gross Wages	450 STRS Gross Wages	Students	Board Members	Other	Difference
8	$ 472,017.23	101,851.05	366,608.97	2,545.20	750.00	262.01	0.00	<---Should be zero!
9
10
11		Pay Item Summary	Pay Item Summary
12		400 SERS	450 STRS
13	Applicable Gross*	101,851.05	370,087.75	*includes inflated amounts.
14	Multiply by 14%	14%	14%
15	Calculation	14,259.15	51,812.29
16	Ded Amt from Report	14,259.15	51,812.22
17	Difference	(0.00)	0.07	<-Difference should be zero(pennies rounding)
18
19
20		Pay Item Summary	Pay Item Summary
21		590/690 SERS	591/691 STRS
22	590	9,148.95	47,379.27	591
23	690	1,036.23	4,432.95	691
24	Total of deductions	10,185.18	51,812.22	<-Total of deductions
25	divided by 10% SERS	101,851.80	370,087.29	<-divided by 14% STRS
26	multiplied by 14%	14,259.25	51,812.22	<-multiplied by 14%
27
28	400 from above	14,259.15	51,812.22	450 from above
29	Difference should be zero	0.10	(0.00)	<-Difference should be zero(pennies rounding)
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