Tax Data for employees

[komobu]

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

 

[James006]

Hello,

Do you already have your Tables available in your file ...?

https://us.icalculator.info/terminology/us-tax-tables/2019.html

 

[komobu]

Thanks James,
I do not have the tax tables in the file. I am hoping for an example on how to set it up.

 

[James006]

If you are looking for inspiration ...

https://michaelkummer.com/archive/spreadsheet-estimate-income-tax/

Hope this will help

 

[komobu]

Thanks...I will look it over

 

[James006]

You are welcome