Allocate the FIT, SSN, MED, NYS and NYC amounts (based on the total) per pay period on ?Sheet 3? of the attached for each employee.

For instance, the FIT for Matt BL for the period was $193.92. That total is 7% of the wages (the wages will always be the denominator). Each pay period needs to have 7% withholding. You will do the same allocation for each category and the sums need to equal the highlighted number in column J. the payroll details are on the pdf file so you can see the source data and tie the wages back to the individual. The amounts summed for each category will be the same but the data will change within the sheet.

Matt Bl 1-May 8-May 12-Jun 19-Jun 8-Apr 10-Apr 17-Apr 24-Apr 15-May 22-May 29-May mike brooks 8-Apr 10-Apr 8-May 15-May 22-May 29-May 12-Jun 19-Jun 265.34 259.02 239.55 191.78 174.58 219.22 262.19 287.32 239.54 215.80 284.18 2,638.52 FIT 17.63 17.63 17.63 17.63 17.63 17.63 17.63 17.63 17.63 17.63 17.63 193.92 SSN 17.96 17.96 17.96 17.96 17.96 17.96 17.96 17.96 17.96 17.96 17.96 197.53 MED 4.20 4.20 4.20 4.20 4.20 4.20 4.20 4.20 4.20 4.20 4.20 46.19 NYS 5.19 5.19 5.19 5.19 5.19 5.19 5.19 5.19 5.19 5.19 5.19 57.13 NYC 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 46.11 3,179.40 6.60 481.14 454.34 481.14 481.14 481.14 481.14 481.14 481.14 3,822.32 77.95 77.95 77.95 77.95 77.95 77.95 77.95 77.95 545.68 44.99 44.99 44.99 44.99 44.99 44.99 44.99 44.99 314.96 10.52 10.52 10.52 10.52 10.52 10.52 10.52 10.52 73.66 27.61 27.61 27.61 27.61 27.61 27.61 27.61 27.61 193.26 17.90 17.90 17.90 17.90 17.90 17.90 17.90 17.90 125.32 5,075.20 4.80 SSN 23.80 23.80 23.80 23.80 23.80 23.80 23.80 23.80 23.80 23.80 23.80 261.81 MED 5.57 5.57 5.57 5.57 5.57 5.57 5.57 5.57 5.57 5.57 5.57 61.23 NYS 9.75 9.75 9.75 9.75 9.75 9.75 9.75 9.75 9.75 9.75 9.75 107.23 NYC 304.75 410.22 239.52 304.74 360.21 347.70 274.16 345.20 413.73 284.90 157.98 3,443.11 FIT 31.16 31.16 31.16 31.16 31.16 31.16 31.16 31.16 31.16 31.16 31.16 342.72 0.00 4,216.10 6.60 332.03 332.03 FIT 35.84 35.84 SSN 25.99 25.99 MED 6.08 6.08 NYS 11.10 11.10 NYC 7.61 7.61 418.65 0.60 jasper 1-May 8-May 12-Jun 19-Jun 8-Apr 10-Apr 17-Apr 24-Apr 15-May 22-May 29-May david ch 8-Apr annalee dit 17-Apr 8-May 12-Jun 19-Jun 24-Apr 15-May 22-May 29-May 185.27 185.26 208.20 244.65 71.64 199.03 71.65 199.03 1,364.73 FIT 8.91 8.91 8.91 8.91 8.91 8.91 8.91 8.91 71.28 SSN 12.37 12.37 12.37 12.37 12.37 12.37 12.37 12.37 98.95 MED 2.89 2.89 2.89 2.89 2.89 2.89 2.89 2.89 23.14 NYS 2.39 2.39 2.39 2.39 2.39 2.39 2.39 2.39 19.08 NYC 1.81 1.81 1.81 1.81 1.81 1.81 1.81 1.81 14.44 1,591.62 4.38 175.33 356.28 360.69 363.40 284.77 1,540.47 FIT 31.99 31.99 31.99 31.99 31.99 159.96 SSN 24.01 24.01 24.01 24.01 24.01 120.03 MED 5.61 5.61 5.61 5.61 5.61 28.07 NYS 10.00 10.00 10.00 10.00 10.00 49.98 NYC 6.90 6.90 6.90 6.90 6.90 34.49 1,933.00 3.00 318.82 318.82 318.82 318.82 318.82 318.82 318.82 318.82 318.82 318.82 3,188.20 FIT 32.96 32.96 32.96 32.96 32.96 32.96 32.96 32.96 32.96 32.96 329.60 SSN 24.80 24.80 24.80 24.80 24.80 24.80 24.80 24.80 24.80 24.80 248.00 MED 5.80 5.80 5.80 5.80 5.80 5.80 5.80 5.80 5.80 5.80 58.00 NYS 10.09 10.09 10.09 10.09 10.09 10.09 10.09 10.09 10.09 10.09 100.90 NYC 6.93 6.93 6.93 6.93 6.93 6.93 6.93 6.93 6.93 6.93 69.30 3,994.00 6.00 329.94 319.78 282.67 307.51 356.36 356.36 311.62 348.23 FIT 31.64 31.64 31.64 31.64 31.64 31.64 31.64 31.64 SSN 29.03 29.03 29.03 29.03 29.03 29.03 29.03 29.03 MED 6.79 6.79 6.79 6.79 6.79 6.79 6.79 6.79 NYS 12.86 12.86 12.86 12.86 12.86 12.86 12.86 12.86 NYC 8.72 8.72 8.72 8.72 8.72 8.72 8.72 8.72 stefan 8-Apr 10-Apr 17-Apr 24-Apr 15-May megan 8-May 12-Jun 19-Jun 8-Apr 10-Apr 17-Apr 24-Apr 15-May 22-May 29-May todd 8-Apr 10-Apr 17-Apr 24-Apr 8-May 15-May 22-May 29-May 12-Jun 19-Jun anderson 8-Apr steve kong 1-May 8-May 12-Jun 19-Jun 8-Apr 10-Apr 17-Apr 24-Apr 15-May 22-May 29-May frank lopez 8-Apr 10-Apr 17-Apr 24-Apr 8-May 15-May 22-May 29-May 12-Jun 19-Jun 336.03 371.61 3,320.11 31.64 31.64 316.42 29.03 29.03 290.25 6.79 6.79 67.88 12.86 12.86 128.62 8.72 8.72 87.22 4,210.50 471.00 145.83 145.83 FIT 13.18 13.18 SSN 10.92 10.92 MED 2.56 2.56 NYS 1.39 1.39 NYC 1.52 1.52 175.40 0.60 275.37 333.05 345.27 297.33 233.36 221.37 238.45 248.56 211.07 253.30 272.21 2,929.34 FIT 22.33 22.33 22.33 22.33 22.33 22.33 22.33 22.33 22.33 22.33 22.33 245.65 SSN 20.19 20.19 20.19 20.19 20.19 20.19 20.19 20.19 20.19 20.19 20.19 222.08 MED 4.72 4.72 4.72 4.72 4.72 4.72 4.72 4.72 4.72 4.72 4.72 51.94 NYS 6.81 6.81 6.81 6.81 6.81 6.81 6.81 6.81 6.81 6.81 6.81 74.87 NYC 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 51.52 3,575.40 6.60 FIT SSN MED NYS NYC 552.50 564.00 462.00 444.00 462.00 480.00 520.00 676.00 864.50 774.00 5,799.00 0.00 0.00 0.00 0.00 0.00 273.62 274.31 298.02 365.08 291.04 FIT 29.12 29.12 29.12 29.12 29.12 SSN 23.08 23.08 23.08 23.08 23.08 MED 5.40 5.40 5.40 5.40 5.40 NYS 9.18 9.18 9.18 9.18 9.18 NYC 6.26 6.26 6.26 6.26 6.26 ed n 1-May 8-May 12-Jun 19-Jun 8-Apr 1099 recepient 5,799.00 10-Apr 17-Apr 24-Apr 15-May 22-May 29-May 231.09 266.64 270.64 339.68 212.78 462.38 3,285.28 29.12 29.12 29.12 29.12 29.12 29.12 320.28 23.08 23.08 23.08 23.08 23.08 23.08 253.91 5.40 5.40 5.40 5.40 5.40 5.40 59.38 9.18 9.18 9.18 9.18 9.18 9.18 100.98 6.26 6.26 6.26 6.26 6.26 6.26 68.82 4,088.65 6.60 389.48 444.27 314.18 387.11 422.00 435.52 257.52 2,650.08 FIT 46.22 46.22 46.22 46.22 46.22 46.22 46.22 323.52 SSN 30.28 30.28 30.28 30.28 30.28 30.28 30.28 211.96 MED 7.08 7.08 7.08 7.08 7.08 7.08 7.08 49.57 NYS 15.38 15.38 15.38 15.38 15.38 15.38 15.38 107.63 NYC 10.26 10.26 10.26 10.26 10.26 10.26 10.26 71.79 3,414.55 4.20 jessica 8-Apr 10-Apr 8-May 22-May 17-Apr 24-Apr 29-May 3,186.00 5,080.00 4,222.70 419.25 1,596.00 1,936.00 4,000.00 4,681.50 176.00 3,582.00 5,799.00 4,095.25 3,418.75 1.00 MATT BLA1 X MIKE BROO X JASPER X DAVID C X AD X STEF FREE X MEG H X TODD HAN X AND HO X STEVE K X FL X EN X JW X 2 X X X 3 X X X X X X X X X X X X X X X X X Matt Bl 1-May 8-May 12-Jun 19-Jun 8-Apr 10-Apr 17-Apr 24-Apr 15-May 22-May 29-May mike brooks 8-Apr 10-Apr 8-May 15-May 22-May 29-May 12-Jun 19-Jun 265.34 259.02 239.55 191.78 174.58 219.22 262.19 287.32 239.54 215.80 284.18 2,638.52 FIT 17.63 17.63 17.63 17.63 17.63 17.63 17.63 17.63 17.63 17.63 17.63 193.92 SSN 17.96 17.96 17.96 17.96 17.96 17.96 17.96 17.96 17.96 17.96 17.96 197.53 MED 4.20 4.20 4.20 4.20 4.20 4.20 4.20 4.20 4.20 4.20 4.20 46.19 NYS 5.19 5.19 5.19 5.19 5.19 5.19 5.19 5.19 5.19 5.19 5.19 57.13 NYC 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 46.11 3,179.40 6.60 481.14 454.34 481.14 481.14 481.14 481.14 481.14 481.14 3,822.32 77.95 77.95 77.95 77.95 77.95 77.95 77.95 77.95 545.68 44.99 44.99 44.99 44.99 44.99 44.99 44.99 44.99 314.96 10.52 10.52 10.52 10.52 10.52 10.52 10.52 10.52 73.66 27.61 27.61 27.61 27.61 27.61 27.61 27.61 27.61 193.26 17.90 17.90 17.90 17.90 17.90 17.90 17.90 17.90 125.32 5,075.20 4.80 SSN 23.80 23.80 23.80 23.80 23.80 23.80 23.80 23.80 23.80 23.80 23.80 261.81 MED 5.57 5.57 5.57 5.57 5.57 5.57 5.57 5.57 5.57 5.57 5.57 61.23 NYS 9.75 9.75 9.75 9.75 9.75 9.75 9.75 9.75 9.75 9.75 9.75 107.23 NYC 304.75 410.22 239.52 304.74 360.21 347.70 274.16 345.20 413.73 284.90 157.98 3,443.11 FIT 31.16 31.16 31.16 31.16 31.16 31.16 31.16 31.16 31.16 31.16 31.16 342.72 0.00 4,216.10 6.60 332.03 332.03 FIT 35.84 35.84 SSN 25.99 25.99 MED 6.08 6.08 NYS 11.10 11.10 NYC 7.61 7.61 418.65 0.60 FIT SSN MED NYS NYC jasper 1-May 8-May 12-Jun 19-Jun 8-Apr 10-Apr 17-Apr 24-Apr 15-May 22-May 29-May david ch 8-Apr annalee dit 17-Apr 8-May 12-Jun 19-Jun 24-Apr 15-May 22-May 29-May 185.27 185.26 208.20 244.65 71.64 199.03 71.65 199.03 1,364.73 8.91 8.91 8.91 8.91 8.91 8.91 8.91 8.91 71.28 12.37 12.37 12.37 12.37 12.37 12.37 12.37 12.37 98.95 2.89 2.89 2.89 2.89 2.89 2.89 2.89 2.89 23.14 2.39 2.39 2.39 2.39 2.39 2.39 2.39 2.39 19.08 1.81 1.81 1.81 1.81 1.81 1.81 1.81 1.81 14.44 1,591.62 4.38 175.33 356.28 360.69 363.40 284.77 1,540.47 FIT 31.99 31.99 31.99 31.99 31.99 159.96 SSN 24.01 24.01 24.01 24.01 24.01 120.03 MED 5.61 5.61 5.61 5.61 5.61 28.07 NYS 10.00 10.00 10.00 10.00 10.00 49.98 NYC 6.90 6.90 6.90 6.90 6.90 34.49 1,933.00 3.00 318.82 318.82 318.82 318.82 318.82 318.82 318.82 318.82 318.82 318.82 3,188.20 FIT 32.96 32.96 32.96 32.96 32.96 32.96 32.96 32.96 32.96 32.96 329.60 SSN 24.80 24.80 24.80 24.80 24.80 24.80 24.80 24.80 24.80 24.80 248.00 MED 5.80 5.80 5.80 5.80 5.80 5.80 5.80 5.80 5.80 5.80 58.00 NYS 10.09 10.09 10.09 10.09 10.09 10.09 10.09 10.09 10.09 10.09 100.90 NYC 6.93 6.93 6.93 6.93 6.93 6.93 6.93 6.93 6.93 6.93 69.30 3,994.00 6.00 329.94 319.78 282.67 307.51 356.36 356.36 311.62 348.23 336.03 371.61 3,320.11 FIT 31.64 31.64 31.64 31.64 31.64 31.64 31.64 31.64 31.64 31.64 316.42 SSN 29.03 29.03 29.03 29.03 29.03 29.03 29.03 29.03 29.03 29.03 290.25 MED 6.79 6.79 6.79 6.79 6.79 6.79 6.79 6.79 6.79 6.79 67.88 NYS 12.86 12.86 12.86 12.86 12.86 12.86 12.86 12.86 12.86 12.86 128.62 NYC 8.72 8.72 8.72 8.72 8.72 8.72 8.72 8.72 8.72 8.72 87.22 4,210.50 471.00 FIT SSN MED NYS NYC stefan 8-Apr 10-Apr 17-Apr 24-Apr 15-May megan 8-May 12-Jun 19-Jun 8-Apr 10-Apr 17-Apr 24-Apr 15-May 22-May 29-May todd 8-Apr 10-Apr 17-Apr 24-Apr 8-May 15-May 22-May 29-May 12-Jun 19-Jun anderson 8-Apr steve kong 1-May 8-May 12-Jun 19-Jun 8-Apr 10-Apr 17-Apr 24-Apr 15-May 22-May 29-May frank lopez 8-Apr 10-Apr 17-Apr 24-Apr 8-May 15-May 22-May 29-May 12-Jun 19-Jun 145.83 145.83 13.18 13.18 10.92 10.92 2.56 2.56 1.39 1.39 1.52 1.52 175.40 0.60 275.37 333.05 345.27 297.33 233.36 221.37 238.45 248.56 211.07 253.30 272.21 2,929.34 FIT 22.33 22.33 22.33 22.33 22.33 22.33 22.33 22.33 22.33 22.33 22.33 245.65 SSN 20.19 20.19 20.19 20.19 20.19 20.19 20.19 20.19 20.19 20.19 20.19 222.08 MED 4.72 4.72 4.72 4.72 4.72 4.72 4.72 4.72 4.72 4.72 4.72 51.94 NYS 6.81 6.81 6.81 6.81 6.81 6.81 6.81 6.81 6.81 6.81 6.81 74.87 NYC 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 51.52 3,575.40 6.60 FIT SSN MED NYS NYC 552.50 564.00 462.00 444.00 462.00 480.00 520.00 676.00 864.50 774.00 5,799.00 0.00 0.00 0.00 0.00 0.00 5,799.00 273.62 274.31 298.02 365.08 291.04 231.09 266.64 270.64 339.68 212.78 462.38 3,285.28 FIT 29.12 29.12 29.12 29.12 29.12 29.12 29.12 29.12 29.12 29.12 29.12 320.28 SSN 23.08 23.08 23.08 23.08 23.08 23.08 23.08 23.08 23.08 23.08 23.08 253.91 MED 5.40 5.40 5.40 5.40 5.40 5.40 5.40 5.40 5.40 5.40 5.40 59.38 NYS 9.18 9.18 9.18 9.18 9.18 9.18 9.18 9.18 9.18 9.18 9.18 100.98 NYC 6.26 6.26 6.26 6.26 6.26 6.26 6.26 6.26 6.26 6.26 6.26 68.82 4,088.65 ed n 1-May 8-May 12-Jun 19-Jun 8-Apr 10-Apr 17-Apr 24-Apr 15-May 22-May 29-May 1099 recepient 6.60 jessica 8-Apr 10-Apr 8-May 22-May 17-Apr 24-Apr 29-May 389.48 444.27 314.18 387.11 422.00 435.52 257.52 2,650.08 FIT 46.22 46.22 46.22 46.22 46.22 46.22 46.22 323.52 SSN 30.28 30.28 30.28 30.28 30.28 30.28 30.28 211.96 MED 7.08 7.08 7.08 7.08 7.08 7.08 7.08 49.57 NYS 15.38 15.38 15.38 15.38 15.38 15.38 15.38 107.63 NYC 10.26 10.26 10.26 10.26 10.26 10.26 10.26 71.79 3,414.55 4.20 3,186.00 5,080.00 4,222.70 419.25 1,596.00 1,936.00 4,000.00 4,681.50 176.00 3,582.00 5,799.00 4,095.25 3,418.75