PayRoll Calculator in Excel

Description

Pay Roll calculator in excel for small companies

Reviews
Shared by: Nantha Kumar S
Categories
Tags
Stats
views:
465
rating:
not rated
reviews:
0
posted:
5/21/2009
language:
English
pages:
0
Prepared By PURNA P Employee Information Federal Allowance (From W-4) 1 Federal Income Tax (Percentage based on Social Security Total Taxes Federal Tax Medicare Tax Withheld Allowance) (Percentage) (Percentage) (Percentage) 28.00% 6.30% 1.45% 38.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Insurance Deduction (Dollars) $20.00 Total Regular Deductions Other Regular (Excluding Deduction taxes, in (Dollars) dollars) $40.00 $60.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Employee ID Name 1 Jay Adams 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Hourly Wage $10.00 Tax Status State Tax (Percentage) 4 2.30% Payroll Calculator Period Ending: 4/25/2003 Regular Hours Worked 50 Vacation Hours Overtime Hours Overtime Rate Gross Pay $560.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Taxes and Deductions $273.08 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Other Deduction Net Pay $20.00 $266.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Employee ID Employee Name 1 Jay Adams 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Sick Hours 5 1 [Company Name] Period: 4/25/2003 Employee Name Jay Adams Federal Allowance (From W-4) Overtime Rate Federal Income Tax State Tax Other Regular Deduction Employee ID 1 Tax Status Hourly Rate Social Security Tax Medicare Tax Insurance Deduction Total Taxes and Regular Deductions 1 $10.00 $35.28 $8.12 $20.00 $273.08 4 $0.00 $156.80 $12.88 $40.00 Hours Worked Sick Hours Vacation Hours Overtime Hours Gross Pay Total Taxes and Deductions Net Pay 50 1 5 0 $560.00 $293.08 $266.92 Other Deduction $20.00 [Company Name] Period: 4/25/2003 Employee Name Federal Allowance (From W-4) Overtime Rate Federal Income Tax State Tax Other Regular Deduction 0 Employee ID 2 Tax Status Hourly Rate Social Security Tax Medicare Tax Insurance Deduction Total Taxes and Regular Deductions 0 $0.00 $0.00 $0.00 $0.00 $0.00 0 $0.00 $0.00 $0.00 $0.00 Hours Worked Sick Hours Vacation Hours Overtime Hours Gross Pay Total Taxes and Deductions Net Pay 0 0 0 0 $0.00 $0.00 $0.00 Other Deduction $0.00 [Company Name] Period: 4/25/2003 Employee Name Federal Allowance (From W-4) Overtime Rate Federal Income Tax State Tax Other Regular Deduction 0 Employee ID 3 Tax Status Hourly Rate Social Security Tax Medicare Tax Insurance Deduction Total Taxes and Regular Deductions 0 $0.00 $0.00 $0.00 $0.00 $0.00 0 $0.00 $0.00 $0.00 $0.00 Hours Worked Sick Hours Vacation Hours Overtime Hours Gross Pay Total Taxes and Deductions Net Pay 0 0 0 0 $0.00 $0.00 $0.00 Other Deduction $0.00 [Company Name] Period: 4/25/2003 Employee Name Federal Allowance (From W-4) Overtime Rate Federal Income Tax State Tax Other Regular Deduction 0 Employee ID 4 Tax Status Hourly Rate Social Security Tax Medicare Tax Insurance Deduction Total Taxes and Regular Deductions 0 $0.00 $0.00 $0.00 $0.00 $0.00 0 $0.00 $0.00 $0.00 $0.00 Hours Worked Sick Hours Vacation Hours Overtime Hours Gross Pay Total Taxes and Deductions Net Pay 0 0 0 0 $0.00 $0.00 $0.00 Other Deduction $0.00

Related docs
Payroll Calculator
Views: 374  |  Downloads: 52
Payroll Calculator
Views: 581  |  Downloads: 79
Payroll Tax Calculator
Views: 4156  |  Downloads: 296
Payroll Calculator Taxes
Views: 101  |  Downloads: 3
Payroll Calculator Taxes
Views: 899  |  Downloads: 95
payroll calculator
Views: 761  |  Downloads: 133
Payroll Template
Views: 71  |  Downloads: 7
annuities calculator
Views: 154  |  Downloads: 3
payroll services
Views: 69  |  Downloads: 9
employee payroll
Views: 236  |  Downloads: 32
How To Use the Tax Calculator Excel Workbook
Views: 44  |  Downloads: 1
premium docs