| |
Payroll Spreadsheet | |   | Name | Hourly Wage | Tax Status | Federal Allowance (From W-4) | State Tax (Percentage) | Federal Income Tax (Percentage based on Federal Allowance) | Social Security Tax (Percentage) | Medicare Tax (Percentage) | Total Taxes Withheld (Percentage) | Insurance Deduction (Dollars) | Other Regular Deduction (Dollars) | Total Regular Deductions (Excluding taxes, in dollars) | |   | john jones | 11.75 |   | 0 |   | .09 | 6.5 | 1.45 | 7.6 |   |   | 96.77 | |   |   |   |   |   |   |   |   |   |   |   |   |   | | 3 |   |   | 420 |   |   |   |   |   | 0.00_ |   |   | $0.00 | | 4 |   |   |   |   |   |   |   |   | 0.00_ |   |   | $0.00 | |   |   |   |   |   |   |   |   |   | 0.00_ |   |   | $0.00 | | |