Annual Payroll Report
ANNUAL PAYROLL REPORT
Prepared by: The Payroll Department of [Your Company Name]
I. Employee Information
|
Employee ID |
Name |
Job Title |
Department |
|---|---|---|---|
|
001 |
John Smith |
Software Engineer |
IT |
|
002 |
Jane Doe |
Marketing Manager |
Marketing |
|
003 |
Alice Johnson |
Sales Associate |
Sales |
|
004 |
Bob Brown |
HR Specialist |
Human Resources |
|
005 |
Carol Davis |
Financial Analyst |
Finance |
|
006 |
David Wilson |
Project Manager |
Operations |
|
007 |
Emma Thomas |
Content Strategist |
Marketing |
|
008 |
Frank White |
Data Scientist |
IT |
|
009 |
Grace Hall |
Customer Support Lead |
Customer Service |
|
010 |
Henry Allen |
Logistics Coordinator |
Supply Chain |
II. Total Earnings
|
Employee ID |
Name |
Gross Pay ($) |
|---|---|---|
|
001 |
John Smith |
120,000 |
|
002 |
Jane Doe |
90,000 |
|
003 |
Alice Johnson |
70,000 |
|
004 |
Bob Brown |
80,000 |
|
005 |
Carol Davis |
100,000 |
|
006 |
David Wilson |
110,000 |
|
007 |
Emma Thomas |
85,000 |
|
008 |
Frank White |
130,000 |
|
009 |
Grace Hall |
75,000 |
|
010 |
Henry Allen |
65,000 |
III. Taxes Withheld
|
Employee ID |
Name |
Federal Tax ($) |
State Tax ($) |
Local Tax ($) |
Total Taxes Withheld ($) |
|---|---|---|---|---|---|
|
001 |
John Smith |
24,000 |
6,000 |
2,400 |
32,400 |
|
002 |
Jane Doe |
18,000 |
4,500 |
1,800 |
24,300 |
|
003 |
Alice Johnson |
14,000 |
3,500 |
1,400 |
18,900 |
|
004 |
Bob Brown |
16,000 |
4,000 |
1,600 |
21,600 |
|
005 |
Carol Davis |
20,000 |
5,000 |
2,000 |
27,000 |
|
006 |
David Wilson |
22,000 |
5,500 |
2,200 |
29,700 |
|
007 |
Emma Thomas |
17,000 |
4,250 |
1,700 |
22,950 |
|
008 |
Frank White |
26,000 |
6,500 |
2,600 |
35,100 |
|
009 |
Grace Hall |
15,000 |
3,750 |
1,500 |
20,250 |
|
010 |
Henry Allen |
13,000 |
3,250 |
1,300 |
17,550 |
IV. Benefits Contributions
|
Employee ID |
Name |
Health Insurance ($) |
Retirement Plan ($) |
Other Benefits ($) |
|---|---|---|---|---|
|
001 |
John Smith |
5,000 |
7,000 |
3,000 |
|
002 |
Jane Doe |
4,500 |
6,500 |
2,500 |
|
003 |
Alice Johnson |
4,000 |
6,000 |
2,000 |
|
004 |
Bob Brown |
4,200 |
6,200 |
2,200 |
|
005 |
Carol Davis |
5,500 |
7,500 |
3,500 |
|
006 |
David Wilson |
5,700 |
7,700 |
3,700 |
|
007 |
Emma Thomas |
4,300 |
6,300 |
2,300 |
|
008 |
Frank White |
5,800 |
7,800 |
3,800 |
|
009 |
Grace Hall |
4,500 |
6,500 |
2,500 |
|
010 |
Henry Allen |
4,000 |
6,000 |
2,000 |
V. Other Deductions
|
Employee ID |
Name |
Garnishments ($) |
Union Dues ($) |
Other Deductions ($) |
|---|---|---|---|---|
|
001 |
John Smith |
500 |
300 |
200 |
|
002 |
Jane Doe |
400 |
250 |
150 |
|
003 |
Alice Johnson |
300 |
200 |
100 |
|
004 |
Bob Brown |
350 |
225 |
125 |
|
005 |
Carol Davis |
450 |
275 |
175 |
|
006 |
David Wilson |
550 |
325 |
225 |
|
007 |
Emma Thomas |
375 |
200 |
150 |
|
008 |
Frank White |
600 |
350 |
250 |
|
009 |
Grace Hall |
400 |
225 |
175 |
|
010 |
Henry Allen |
300 |
175 |
125 |
VI. Payroll Summary
A. Total Payroll Costs
|
Gross Pay ($) |
Total Taxes Withheld ($) |
Total Benefits ($) |
Total Other Deductions ($) |
Total Payroll Costs ($) |
|---|---|---|---|---|
|
925,000 |
250,800 |
145,000 |
8,525 |
1,329,325 |
B. Gross Pay
Total gross pay for all employees: $925,000
C. Net Pay
Total net pay for all employees: $670,675
(Gross Pay - Total Taxes Withheld - Total Other Deductions)
VII. Compliance Information
|
Employee ID |
Name |
W-2 Form Filed |
1099 Form Filed |
Other Compliance Documents |
|---|---|---|---|---|
|
001 |
John Smith |
Yes |
No |
Yes |
|
002 |
Jane Doe |
Yes |
No |
Yes |
|
003 |
Alice Johnson |
Yes |
No |
Yes |
|
004 |
Bob Brown |
Yes |
No |
Yes |
|
005 |
Carol Davis |
Yes |
No |
Yes |
|
006 |
David Wilson |
Yes |
No |
Yes |
|
007 |
Emma Thomas |
Yes |
No |
Yes |
|
008 |
Frank White |
Yes |
No |
Yes |
|
009 |
Grace Hall |
Yes |
No |
Yes |
|
010 |
Henry Allen |
Yes |
No |
Yes |
This report has been meticulously prepared by the Payroll Department of [Your Company Name] to ensure accuracy and compliance with all regulatory requirements. For any queries or further information, please contact [Your Name] at [Your Email].
