Free HR Payroll Report Template
HR Payroll Report
Prepared by: The Payroll Department of [Your Company Name]
I. Employee Information
|
Employee Name |
Employee ID |
Department |
Job Title |
|---|---|---|---|
|
John Smith |
12345 |
HR |
HR Manager |
|
Jane Doe |
67890 |
Finance |
Accountant |
|
Mark Johnson |
54321 |
IT |
Software Engineer |
|
Emily Brown |
98765 |
Sales |
Sales Manager |
|
Michael Clark |
24680 |
Operations |
Operations Lead |
|
Sarah White |
13579 |
Marketing |
Marketing Analyst |
|
David Lee |
86420 |
Customer Service |
Customer Support Specialist |
|
Jennifer Taylor |
97531 |
Research |
Research Scientist |
II. Pay Period
|
Pay Period Start Date |
Pay Period End Date |
|---|---|
|
July 1, 2050 |
July 31, 2050 |
III. Gross Earnings
|
Employee Name |
Regular Pay |
Overtime Pay |
Bonuses |
Commissions |
Total Gross Earnings |
|---|---|---|---|---|---|
|
John Smith |
$5,000 |
$500 |
$1,000 |
$300 |
$6,800 |
|
Jane Doe |
$4,500 |
$200 |
$800 |
$300 |
$5,800 |
|
Mark Johnson |
$4,200 |
$400 |
$700 |
$200 |
$5,500 |
|
Emily Brown |
$4,800 |
$300 |
$900 |
$250 |
$6,250 |
|
Michael Clark |
$4,000 |
$100 |
$500 |
$150 |
$4,750 |
|
Sarah White |
$3,500 |
$0 |
$600 |
$100 |
$4,200 |
|
David Lee |
$3,800 |
$300 |
$400 |
$50 |
$4,550 |
|
Jennifer Taylor |
$4,600 |
$200 |
$1,200 |
$350 |
$6,350 |
IV. Deduction Summary
A. Taxes Withheld
|
Employee Name |
Federal Taxes |
State Taxes |
Social Security |
Medicare |
Total Taxes |
|---|---|---|---|---|---|
|
John Smith |
$1,200 |
$500 |
$300 |
$150 |
$2,150 |
|
Jane Doe |
$1,000 |
$400 |
$250 |
$120 |
$1,770 |
|
Mark Johnson |
$900 |
$350 |
$200 |
$100 |
$1,550 |
|
Emily Brown |
$1,100 |
$450 |
$280 |
$130 |
$1,960 |
|
Michael Clark |
$950 |
$380 |
$220 |
$110 |
$1,660 |
|
Sarah White |
$800 |
$320 |
$180 |
$90 |
$1,390 |
|
David Lee |
$850 |
$340 |
$190 |
$95 |
$1,475 |
|
Jennifer Taylor |
$1,300 |
$550 |
$350 |
$160 |
$2,360 |
B. Benefits Contributions
|
Employee Name |
Health Insurance |
Retirement Plan |
Other Benefits |
Total Benefits Contributions |
|---|---|---|---|---|
|
John Smith |
$200 |
$400 |
$50 |
$650 |
|
Jane Doe |
$180 |
$350 |
$60 |
$590 |
|
Mark Johnson |
$220 |
$380 |
$55 |
$655 |
|
Emily Brown |
$190 |
$370 |
$70 |
$630 |
|
Michael Clark |
$210 |
$390 |
$45 |
$645 |
|
Sarah White |
$175 |
$320 |
$40 |
$535 |
|
David Lee |
$185 |
$330 |
$50 |
$565 |
|
Jennifer Taylor |
$240 |
$420 |
$65 |
$725 |
C. Other Deductions
|
Employee Name |
Loan Repayment |
Union Dues |
Other Deductions |
Total Other Deductions |
|---|---|---|---|---|
|
John Smith |
$100 |
$50 |
$20 |
$170 |
|
Jane Doe |
$80 |
$40 |
$15 |
$135 |
|
Mark Johnson |
$90 |
$45 |
$18 |
$153 |
|
Emily Brown |
$95 |
$48 |
$22 |
$165 |
|
Michael Clark |
$85 |
$42 |
$20 |
$147 |
|
Sarah White |
$75 |
$35 |
$18 |
$128 |
|
David Lee |
$70 |
$30 |
$15 |
$115 |
|
Jennifer Taylor |
$110 |
$60 |
$25 |
$195 |
V. Net Pay
|
Employee Name |
Total Gross Earnings |
Total Deductions |
Net Pay |
|---|---|---|---|
|
John Smith |
$6,800 |
$2,970 |
$3,830 |
|
Jane Doe |
$5,800 |
$2,400 |
$3,400 |
|
Mark Johnson |
$5,500 |
$2,223 |
$3,277 |
|
Emily Brown |
$6,250 |
$2,157 |
$4,093 |
|
Michael Clark |
$4,750 |
$2,367 |
$2,383 |
|
Sarah White |
$4,200 |
$2,053 |
$2,147 |
|
David Lee |
$4,550 |
$1,755 |
$2,795 |
|
Jennifer Taylor |
$6,350 |
$2,750 |
$3,600 |
VI. Employer Contributions
A. Health Insurance Contributions
|
Employee Name |
Employer Contribution |
|---|---|
|
John Smith |
$150 |
|
Jane Doe |
$140 |
|
Mark Johnson |
$160 |
|
Emily Brown |
$145 |
|
Michael Clark |
$155 |
|
Sarah White |
$130 |
|
David Lee |
$135 |
|
Jennifer Taylor |
$180 |
B. Retirement Plan Contributions
|
Employee Name |
Employer Contribution |
|---|---|
|
John Smith |
$300 |
|
Jane Doe |
$275 |
|
Mark Johnson |
$380 |
|
Emily Brown |
$370 |
|
Michael Clark |
$395 |
|
Sarah White |
$320 |
|
David Lee |
$330 |
|
Jennifer Taylor |
$420 |
C. Other Contributions
|
Employee Name |
Type of Contribution |
Employer Contribution |
|---|---|---|
|
John Smith |
Education Assistance |
$50 |
|
Jane Doe |
Wellness Program |
$30 |
|
Mark Johnson |
Parking Allowance |
$25 |
|
Emily Brown |
Transit Benefits |
$40 |
|
Michael Clark |
Mobile Phone Allowance |
$35 |
|
Sarah White |
Gym Membership |
$20 |
|
David Lee |
Meal Subsidy |
$15 |
|
Jennifer Taylor |
Professional Development |
$50 |
VII. Tax Information
|
Employee Name |
Federal Taxes |
State Taxes |
Social Security |
Medicare |
Total Taxes Withheld |
|---|---|---|---|---|---|
|
John Smith |
$1,200 |
$500 |
$300 |
$150 |
$2,150 |
|
Jane Doe |
$1,000 |
$400 |
$250 |
$120 |
$1,770 |
|
Mark Johnson |
$900 |
$350 |
$200 |
$100 |
$1,550 |
|
Emily Brown |
$1,100 |
$450 |
$280 |
$130 |
$1,960 |
|
Michael Clark |
$950 |
$380 |
$220 |
$110 |
$1,660 |
|
Sarah White |
$800 |
$320 |
$180 |
$90 |
$1,390 |
|
David Lee |
$850 |
$340 |
$190 |
$95 |
$1,475 |
|
Jennifer Taylor |
$1,300 |
$550 |
$350 |
$160 |
$2,360 |
VIII. Leave Balances
|
Employee Name |
Paid Time Off (Hours) |
Sick Leave (Hours) |
Vacation (Days) |
|---|---|---|---|
|
John Smith |
80 |
40 |
15 |
|
Jane Doe |
72 |
36 |
12 |
|
Mark Johnson |
88 |
44 |
18 |
|
Emily Brown |
96 |
48 |
20 |
|
Michael Clark |
64 |
32 |
10 |
|
Sarah White |
80 |
40 |
15 |
|
David Lee |
56 |
28 |
8 |
|
Jennifer Taylor |
104 |
52 |
22 |
