Spreadsheet: 60550d1261067078-payroll-taxes-example-docpay-05-09
Sheet: COMPENSATION

 |  |  |  |  | 0.113 | 0.17 |  |  | MCR | FICA | 0.113 | 0.17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ID Those |  | ID Those | ID Those |  |  |  | Adjusted
 |  | Net | 1.45% | 6.20% | Net | Net | Total | W-2 | Tax | Tax | MPPP | MPPP | MPPP $ | FICA $ | 11.3% PP | 17% PP | 17% Gross | 11.3% Gross | 1st MCR | 1st FICA | 1st Pension | 1st Pension | 1st W-2 | 2nd MCR | 2nd FICA | 2nd Pension | 2nd Pension | 2nd W-2 | 3rd MCR | 3rd FICA | 3rd Pension | 3rd Pension | 3rd W-2 | 4th MCR | 4th FICA | 4th Pension | 4th Pension | [NAME] | 5th MCR | 5th FICA | 5th Pension | 5th Pension | 5th W-2 | MCR | FICA | Pension | Pension | 6th W-2 | MCR | FICA | Pension | Pension | 7th W-2 | MCR | FICA | Pension | Pension | 8th W-2 | MCR | FICA | Pension | Pension | 9th W-2 | MCR | FICA | Pension | Pension | 10th W-2 | Maxed or | Amt to | Maxing | FICA Maxed | Amt to | MCR | Pension | Pension | 11th W-2 | MCR | Pension | Pension | 12th W-2 | MCR | Pension | Pension | 13th W-2 | MCR | Pension | Pension | 14th W-2 | MCR | Pension | Pension | 15th W-2 | MCR | Pension | Pension | 16th W-2 | MCR | Pension | Pension | 17th W-2 | MCR | Pension | Pension | 18th W-2 | MCR | Pension | Pension | 19th W-2 | MCR | Pension | Pension | 20th W-2 | MCR | Pension | Pension | 21st W-2
name | Pay # | Comp | MCR Tax | FICA Tax | Pension | Pension | W-2 | Check | Check | Check | Check | Check | Left to [NAME] | Left to [NAME] | Left to [NAME] | Left to [NAME] | Estimate | Estimate | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Maxing (   ) | MPPP | This PP | or Maxing | FICA | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess
SMITH | 107 | 32833.74855619267 | 401.9327589552353 | 0 | 0 | 4712.315104992414 | 27719.5 | -0.000692245019308757 | 8.955235273333528e-06 | -1718.609 |  | 4712.315000000001 | 18315.62281354027 | 0 | 0 | 18315.62281354027 | 5581.737254552753 | 0 | 395.1541638737787 | 1665.1251425415 | 0 | 5231.489772462156 | 25541.97947731523 | 370.3587024210709 | 1583.602727593544 | 0 | 4342.13651114359 | 26537.65061503446 | 384.7959339179997 | 1645.334338132136 | 0 | 4511.400604555858 | 26292.21767958668 | 381.2371563540068 | 1630.117496134374 | 0 | 4469.677005529736 | 26352.71689817455 | 382.114395023531 | 1633.868447686822 | 0 | 4479.961872689673 | 26337.80384079264 | 381.8981556914933 | 1632.943838129144 | 0 | 4477.426652934749 | 26341.47990943728 | 381.9514586868406 | 1633.171754385111 | 0 | 4478.051584604338 | 26340.57375851638 | 381.9383194984875 | 1633.115573028015 | 0 | 4477.897538947785 | 26340.79712471838 | 381.9415583084165 | 1633.129421732539 | 0 | 4477.935511202125 | 26340.74206494959 | 381.940759941769 | 1633.126008026874 | 0 | 4477.92615104143 | 26340.7556371826 | 0 | 4477.92615104143 | 0 | -1633.126008026874 | 0 | 381.9409567391477 | 0 | 4477.92615104143 | 27973.88144841209 | 405.6212810019753 | 0 | 4755.559846230055 | 27672.56742896064 | 401.2522277199292 | 0 | 4704.336462923308 | 27728.15986554943 | 402.0583180504668 | 0 | 4713.787177143404 | 27717.9030609988 | 401.9095943844825 | 0 | 4712.043520369796 | 27719.79544143839 | 401.9370339008566 | 0 | 4712.365225044526 | 27719.44629724728 | 401.9319713100856 | 0 | 4712.305870532038 | 27719.51071435054 | 401.9329053580829 | 0 | 4712.316821439593 | 27719.49882939499 | 401.9327330262274 | 0 | 4712.314800997148 | 27719.50102216929 | 401.9327648214547 | 0 | 4712.315173768779 | 27719.50061760243 | 401.9327589552353 | 0 | 4712.315104992414 | 27719.50069224502
 |  |  | 1.45% on [NAME] | 6.2% on [NAME] | 11.3% on first $9k of W2 | 17% on [NAME]
 |  |  | no maximum | maximum $6621.6 | maximum $1017 | maximum $41137