Weekly Payroll Report
WEEKLY PAYROLL REPORT
Prepared by: [Your Name], HR
I. Employee Information
|
Employee Name |
Employee ID |
Department |
|---|---|---|
|
John Doe |
12345 |
Sales |
|
Jane Smith |
67890 |
Marketing |
|
Michael Johnson |
54321 |
Finance |
|
Emily Brown |
98765 |
HR |
|
Robert Davis |
45678 |
IT |
II. Hours Worked
|
Employee Name |
Regular Hours |
Overtime Hours |
|---|---|---|
|
John Doe |
40 |
5 |
|
Jane Smith |
37 |
3 |
|
Michael Johnson |
42 |
7 |
|
Emily Brown |
39 |
6 |
|
Robert Davis |
41 |
4 |
III. Gross Earnings
|
Employee Name |
Regular Earnings |
Overtime Earnings |
Total Gross Earnings |
|---|---|---|---|
|
John Doe |
$800 |
$125 |
$925 |
|
Jane Smith |
$925 |
$75 |
$1000 |
|
Michael Johnson |
$875 |
$175 |
$1050 |
|
Emily Brown |
$810 |
$130 |
$940 |
|
Robert Davis |
$850 |
$100 |
$950 |
IV. Deduction Summary
A. Taxes
|
Employee Name |
Federal Tax |
State Tax |
FICA |
Total Deductions |
|---|---|---|---|---|
|
John Doe |
$120 |
$60 |
$60 |
$240 |
|
Jane Smith |
$140 |
$70 |
$70 |
$280 |
|
Michael Johnson |
$150 |
$75 |
$75 |
$300 |
|
Emily Brown |
$130 |
$65 |
$65 |
$260 |
|
Robert Davis |
$125 |
$62.50 |
$62.50 |
$250 |
B. Benefits
|
Employee Name |
Health Insurance |
Retirement Contribution |
Other Benefits |
Total Benefits Deduction |
|---|---|---|---|---|
|
John Doe |
$100 |
$80 |
$20 |
$200 |
|
Jane Smith |
$110 |
$85 |
$25 |
$220 |
|
Michael Johnson |
$120 |
$90 |
$30 |
$240 |
|
Emily Brown |
$105 |
$75 |
$15 |
$195 |
|
Robert Davis |
$115 |
$70 |
$18 |
$203 |
C. Other Deductions
|
Employee Name |
Loan Repayment |
Union Dues |
Other Deductions |
Total Other Deductions |
|---|---|---|---|---|
|
John Doe |
$50 |
$10 |
$5 |
$65 |
|
Jane Smith |
$60 |
$12 |
$6 |
$78 |
|
Michael Johnson |
$70 |
$14 |
$7 |
$91 |
|
Emily Brown |
$55 |
$11 |
$5 |
$71 |
|
Robert Davis |
$58 |
$11.50 |
$6 |
$75.50 |
V. Net Pay
|
Employee Name |
Total Gross Earnings |
Total Deductions |
Net Pay |
|---|---|---|---|
|
John Doe |
$925 |
$505 |
$420 |
|
Jane Smith |
$1000 |
$580 |
$420 |
|
Michael Johnson |
$1050 |
$631 |
$419 |
|
Emily Brown |
$940 |
$526 |
$414 |
|
Robert Davis |
$950 |
$325.50 |
$624.50 |
VI. Leave Balances
|
Employee Name |
Vacation Hours |
Sick Hours |
Personal Hours |
|---|---|---|---|
|
John Doe |
40 |
32 |
16 |
|
Jane Smith |
35 |
28 |
14 |
|
Michael Johnson |
45 |
36 |
18 |
|
Emily Brown |
38 |
30 |
15 |
|
Robert Davis |
42 |
34 |
17 |
VII. Reimbursement
|
Employee Name |
Travel Expenses |
Training Fees |
Other Reimbursements |
|---|---|---|---|
|
John Doe |
$200 |
$100 |
$50 |
|
Jane Smith |
$180 |
$90 |
$45 |
|
Michael Johnson |
$220 |
$110 |
$55 |
|
Emily Brown |
$190 |
$95 |
$48 |
|
Robert Davis |
$210 |
$105 |
$52.50 |
This Weekly Payroll Report provides comprehensive details on employee hours, earnings, deductions, net pay, leave balances, and reimbursements for the week ending [Date]. Prepared by the HR team, this report ensures transparency and accuracy in payroll management.
