|
Nebraska | Sounds like I did something similar. I have an employee info sheet, a 12 month summary sheet a couple of sheets for the tax tables and a pay stub sheet for each month. I have it set up so you enter the hrs in each months pay stub sheet and all the calculations are done and carried to the summary sheet.
I only have 2 employees. One is married one is single. Both paid monthly so that is all I set it up for.
I used the VLOOKUP formula to go the the tables and calculate the federal and state taxes.
Edited by glfarms 1/19/2020 19:18
| |
|