Weekly Payroll Report Template
Download
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.
Templates
Report
Templates
