payroll-calculator_for-business.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AF
1	Employee Register
2																															© 2013 - 2026 Spreadsheet123 LTD
3	Information contained in this employee register is highly confidential											Filing Status (W-4 before 2020)			Filing Status (W-4 from 2020 or later)						Pre-Tax Adjustments				Post-Tax Adjustments		Post-Tax Deductions				Payroll Calculator
4	ID	Employee's Name	M/F	Hire Date	Occupation	Annual Salary ($)	Regular Hourly Rate ($)	Overtime Hourly Rate ($)	Exempt from Overtime	Pay Frequency	W-4 Form	Filing Status	Federal Allowance	Additional Amount to Withhold (With every paycheck) ($)	Filing Status	Step 2	Step 3		Step 4		Tax Deferral Plan (401k) (%)	Health Insurance Premiums ($)	Other Withholdings ($)	Exempt from FICA	State Tax (%)	Local Tax (%)	Insurance ($)	Other Deductions ($)	Address	Social Security #
5	ID	Employee's Name	M/F	Hire Date	Occupation	Annual Salary ($)	Regular Hourly Rate ($)	Overtime Hourly Rate ($)	Exempt from Overtime	Pay Frequency	W-4 Form	Filing Status	Federal Allowance	Additional Amount to Withhold (With every paycheck) ($)	Filing Status	Box in (c)	Dependents Under Age 17	Other Dependents	(b) Deductions ($)	(c) Extra withholding ($)	Tax Deferral Plan (401k) (%)	Health Insurance Premiums ($)	Other Withholdings ($)	Exempt from FICA	State Tax (%)	Local Tax (%)	Insurance ($)	Other Deductions ($)	Address	Social Security #

6	1	Adam Jones	M	15-Feb-13	Senior Accountant	42,000.00	20.19	30.29	Yes	Monthly	W-4 (2020 or later)	Exempt	2	50	Single	Not Checked			100	50	4.00%	-	-	Not Exempt	4.63%	0.00%	45.00	-	111 Street, Town/City, ST, 00000	*--6789
7	2	Nichola Brown	F	28-Sep-11	CR Manager	54,481.00	26.19	39.29	Yes	Monthly	W-4 (2020 or later)	Married	4		Single	Not Checked					3.00%	-	-	Not Exempt	4.63%	0.00%	42.00	-	111 Street, Town/City, ST, 00000	*--4321
8	3	Benny Erwin	M	11-May-11	Applications PM	48,785.00	23.45	35.18	No	Monthly	W-4 (before 2020)	Married	4								4.50%	-	-	Not Exempt	4.63%	0.00%	14.00	30.00	111 Street, Town/City, ST, 00000	*--0000
9
10
11																															Disclaimer:
12																															This template is provided as-is for informational, illustrative, or/and educational purposes only and under no circumstances should be construed as financial, legal, or tax advice. The results provided by this calculator are only estimates and may not apply to your specific situation. Spreadsheet123 LTD strongly recommends seeking the advice of qualified professionals regarding financial or legal decisions. Spreadsheet123 LTD reserves the right to make changes to this software without notification.
13
14
15
16
17
18
19
20
21
22
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	When adding more rows, insert new rows above this one
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