R-Work
Batman007
Rosin_Preservation_LLCPayrollbymonth.xlsxPayroll
| Jan 21 | Feb 21 | Mar 21 | Apr 21 | May 21 | Jun 21 | TOTAL | ||||||||||
| Employee Wages, Taxes and Adjustments | ||||||||||||||||
| Gross Pay | ||||||||||||||||
| Salary | 20,167.89 | 26,268.78 | 39,403.17 | 25,834.89 | 28,444.94 | 27,619.57 | 167,739.24 | |||||||||
| Salary Holiday | 2,165.34 | 0.00 | 0.00 | 0.00 | 0.00 | 1,486.52 | 3,651.86 | |||||||||
| Salary Vacation | 1,522.86 | 0.00 | 0.00 | 433.89 | 420.00 | 105.00 | 2,481.75 | |||||||||
| Hourly | 1,582.43 | 2,130.08 | 3,123.68 | 2,192.11 | 2,619.45 | 3,838.43 | 15,486.18 | |||||||||
| Hourly Holiday | 180.00 | 0.00 | 0.00 | 0.00 | 0.00 | 90.00 | 270.00 | |||||||||
| Hourly Overtime | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 48.00 | 48.00 | |||||||||
| Hourly Vacation | 90.00 | 0.00 | 90.00 | 0.00 | 0.00 | 0.00 | 180.00 | |||||||||
| Bonus | 0.00 | 1,000.00 | 0.00 | 0.00 | 0.00 | 21,000.00 | 22,000.00 | |||||||||
| Monthly Stipend | 364.57 | 368.58 | 368.58 | 368.58 | 368.58 | 368.58 | 2,207.47 | |||||||||
| Total Gross Pay | 26,073.09 | 29,767.44 | 42,985.43 | 28,829.47 | 31,852.97 | 54,556.10 | 214,064.50 | |||||||||
| Deductions from Gross Pay | ||||||||||||||||
| Health Insurance (pre-tax) | -1,428.72 | -1,428.72 | -1,428.72 | -1,428.72 | -1,428.72 | -1,428.72 | -8,572.32 | |||||||||
| Health Insurance (Taxable) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||
| HSA Employee (Pretax) | -125.00 | -50.00 | -50.00 | -50.00 | -50.00 | -50.00 | -375.00 | |||||||||
| S-Corp Health Adjustment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||
| Simple IRA Emp. | -2,012.46 | -2,122.63 | -3,093.94 | -2,166.72 | -2,166.72 | -2,616.72 | -14,179.19 | |||||||||
| Total Deductions from Gross Pay | -3,566.18 | -3,601.35 | -4,572.66 | -3,645.44 | -3,645.44 | -4,095.44 | -23,126.51 | |||||||||
| Adjusted Gross Pay | 22,506.91 | 26,166.09 | 38,412.77 | 25,184.03 | 28,207.53 | 50,460.66 | 190,937.99 | |||||||||
| Taxes Withheld | ||||||||||||||||
| Federal Withholding | -1,789.00 | -2,308.00 | -3,231.00 | -2,079.00 | -2,271.00 | -6,792.00 | -18,470.00 | |||||||||
| Medicare Employee | -355.53 | -410.19 | -601.84 | -396.59 | -440.42 | -769.63 | -2,974.20 | |||||||||
| Social Security Employee | -1,520.21 | -1,753.90 | -2,573.40 | -1,695.76 | -1,883.20 | -3,290.80 | -12,717.27 | |||||||||
| MO - Withholding | -772.00 | -968.00 | -1,408.00 | -908.00 | -988.00 | -2,151.00 | -7,195.00 | |||||||||
| Kansas City Earnings Tax | -225.08 | -261.67 | -384.15 | -251.85 | -282.08 | -504.61 | -1,909.44 | |||||||||
| Medicare Employee Addl Tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||
| Total Taxes Withheld | -4,661.82 | -5,701.76 | -8,198.39 | -5,331.20 | -5,864.70 | -13,508.04 | -43,265.91 | |||||||||
| Deductions from Net Pay | ||||||||||||||||
| Disability Insurance (Taxable) | -364.58 | -368.60 | -368.60 | -368.60 | -368.60 | -368.60 | -2,207.58 | |||||||||
| Total Deductions from Net Pay | -364.58 | -368.60 | -368.60 | -368.60 | -368.60 | -368.60 | -2,207.58 | |||||||||
| Net Pay | 17,480.51 | 20,095.73 | 29,845.78 | 19,484.23 | 21,974.23 | 36,584.02 | 145,464.50 | |||||||||
| Employer Taxes and Contributions | ||||||||||||||||
| Federal Unemployment | 147.11 | 86.79 | 18.10 | 0.96 | 18.44 | 29.13 | 300.53 | |||||||||
| Medicare Company | 355.53 | 410.19 | 601.84 | 396.59 | 440.42 | 769.63 | 2,974.20 | |||||||||
| Social Security Company | 1,520.21 | 1,753.90 | 2,573.40 | 1,695.76 | 1,883.20 | 3,290.80 | 12,717.27 | |||||||||
| MO - Unemployment Company | 215.76 | 218.58 | 112.99 | 19.29 | 42.63 | 42.73 | 651.98 | |||||||||
| Health Insurance (Company Paid) | 1,426.66 | 1,426.66 | 1,426.66 | 1,426.66 | 1,426.66 | 1,426.66 | 8,559.96 | |||||||||
| HSA Company (Nontaxable) | 800.00 | 800.00 | 800.00 | 800.00 | 800.00 | 800.00 | 4,800.00 | |||||||||
| S-Corp Medical Insurance | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||||||||
| Simple IRA Co. Match | 575.70 | 755.02 | 1,042.23 | 799.11 | 799.11 | 1,339.11 | 5,310.28 | |||||||||
| Total Employer Taxes and Contributions | 5,040.97 | 5,451.14 | 6,575.22 | 5,138.37 | 5,410.46 | 7,698.06 | 35,314.22 | |||||||||
&"Arial,Bold"&8 3:45 PM &"Arial,Bold"&8 07/19/21 &"Arial,Bold"&12 Rosin Preservation, LLC &"Arial,Bold"&14 Payroll Summary &"Arial,Bold"&10 January through June 2021
&"Arial,Bold"&8 Page &P of &N
