Tax Data for employees

komobu

New Member
Joined
Feb 7, 2011
Messages
29
Trying to write a sheet to track employee pay for about 10 employees. I can figure out the hours worked easily enough. What is the simplest way to figue the employee share of fed and state taxes? All of our employees will earn less than 100k per year, but may have different with holding numbers.

I am kind of hoping to have a value in a cell on the employees work sheet that I can write a formula off of. I need it for federal taxes and state taxes. Thanks for any help
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

komobu

New Member
Joined
Feb 7, 2011
Messages
29
Thanks James,
I do not have the tax tables in the file. I am hoping for an example on how to set it up.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,575
Messages
5,469,477
Members
406,656
Latest member
Kriscrawford76

This Week's Hot Topics

Top