Spreadsheet: 680451d1591026294-autofilling-paychecks-from-payroll-example_2020
Sheet: QTR1Summary

Summary 2012 Quarter 1
Copy and Paste info from individual sheets
 |  | Wage | Overtime rate | Reg hours | OT Hours | Total Reg Wage | Total  OT Wage | Gross Pay | Federal With | SS.Withholding | Medicare Witholding |  | Other Ded | Total Ded | Net Pay | pay date | SS. | MED | FUTA | SUTA | Total Employer
1/1/2012-1/15/2012 | Employee 1 | 10 |  | 88.5 |  |  |  |  | 56 |  |  | 22.17 | 40 |  |  | 2012-01-16 00:00:00
 | Employee 2 | 11.25 |  | 83 |  |  |  |  | 45 |  |  | 18.48 | 0 |  |  | 2012-01-16 00:00:00
12 Employees | Employee 3 | 10.5 |  | 62 |  |  |  |  | 32 |  |  | 11.64 | 0 |  |  | 2012-01-16 00:00:00
 | Employee 4 | 16 |  | 110 |  |  |  |  | 188 |  |  | 75.96 | 0 |  |  | 2012-01-16 00:00:00
 | Employee 5 | 10.5 |  | 90 |  |  |  |  | 47 |  |  | 18.48 | 0 |  |  | 2012-01-16 00:00:00
 | Employee 6 | 9 |  | 62 |  |  |  |  | 15 |  |  | 9.67 | 0 |  |  | 2012-01-16 00:00:00
 | Employee 7 | 9 |  | 6 |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 2012-01-16 00:00:00
 | Employee 8 | 12 |  | 79.5 |  |  |  |  | 62 |  |  | 21.45 | 0 |  |  | 2012-01-16 00:00:00
 | Employee 9 | 10 |  | 71.5 |  |  |  |  | 0 |  |  | 5.64 | 0 |  |  | 2012-01-16 00:00:00
 | Employee 10 | 10.5 |  | 88 |  |  |  |  | 86 |  |  | 27.73 | 20 |  |  | 2012-01-16 00:00:00
 | Employee 11 | 15 |  | 89 |  |  |  |  | 38 |  |  | 25.78 | 0 |  |  | 2012-01-16 00:00:00
 | Employee 12 | 12 |  | 87 |  |  |  |  | 80 |  |  | 30.20 | 0 |  |  | 2012-01-16 00:00:00
1/16/2012-1/31/2012 | Employee 1 | 10 |  | 83.5 |  |  |  |  | 47 |  |  | 19.66 | 120 |  |  | 2012-02-01 00:00:00
 | Employee 2 | 11.25 |  | 73 |  |  |  |  | 35 |  |  | 14.55 |  |  |  | 2012-02-01 00:00:00
 | Employee 3 | 10.5 |  | 87.5 |  |  |  |  | 58 |  |  | 20.14 | 35 |  |  | 2012-02-01 00:00:00
 | Employee 4 | 16 |  | 100 |  |  |  |  | 164 |  |  | 65.40 |  |  |  | 2012-02-01 00:00:00
 | Employee 5 | 10.5 |  | 90 |  |  |  |  | 47 |  |  | 18.48 | 420 |  |  | 2012-01-16 00:00:00
 | Employee 6 | 12 |  | 72.5 |  |  |  |  | 54 |  |  | 18.83 | 280 |  |  | 2012-02-01 00:00:00
 | Employee 7 | 10 |  | 87 |  |  |  |  | 0 |  |  | 10.87 |  |  |  | 2012-02-01 00:00:00
 | Employee 8 | 10.5 |  | 67.75 |  |  |  |  | 53 |  |  | 17.22 | 20 |  |  | 2012-02-01 00:00:00
 | Employee 9 | 15 |  | 109 |  |  |  |  | 68 |  |  | 40.84 |  |  |  | 2012-02-01 00:00:00
 | Employee 10 | 12 |  | 90 |  |  |  |  | 86 |  |  | 32.21 |  |  |  | 2012-02-01 00:00:00
2/1/2012-2/15/2012 | Employee 1 | 10 |  | 66.25 |  |  |  |  | 27 |  |  | 13.27 | 50 |  |  | 2012-02-16 00:00:00
8 Employees | Employee 2 | 11.25 |  | 57.25 |  |  |  |  | 17 |  |  | 8.67 |  |  |  | 2012-02-16 00:00:00
 | Employee 3 | 10.5 |  | 55.5 |  |  |  |  | 26 |  |  | 9.02 | 45 |  |  | 2012-02-16 00:00:00
 | Employee 4 | 16 |  | 77 |  |  |  |  | 107 |  |  | 41.45 |  |  |  | 2012-02-16 00:00:00
 | Employee 5 | 10.5 |  | 52.5 |  |  |  |  | 7 |  |  | 6.05 | 221.08 |  |  | 2012-02-16 00:00:00
 | Employee 6 | 12 |  | 30.25 |  |  |  |  | 4 |  |  | 2.14 | 140 |  |  | 2012-02-16 00:00:00
 | Employee 7 | 10 |  | 55 |  |  |  |  | 0 |  |  | 10.89 |  |  |  | 2012-02-16 00:00:00
 | Employee 8 | 10.5 |  | 48.5 |  |  |  |  | 27 |  |  | 10.35 |  |  |  | 2012-02-16 00:00:00
2/16/2012-2/28/2012 | Employee 1 | 10 |  | 82.5 |  |  |  |  | 47 |  |  | 19.15 | 340.2 |  |  | 2012-03-01 00:00:00
 | Employee 2 | 11.25 |  | 90 |  |  |  |  | 53 |  |  | 21.09 |  |  |  | 2012-03-01 00:00:00
 | Employee 3 | 10.5 |  | 56 |  |  |  |  | 26 |  |  | 9.02 |  |  |  | 2012-03-01 00:00:00
 | Employee 4 | 16 |  | 56 |  |  |  |  | 56 |  |  | 22.67 |  |  |  | 2012-03-01 00:00:00
 | Employee 5 | 10.5 |  | 51 |  |  |  |  | 5 |  |  | 5.4 | 0 |  |  | 2012-03-01 00:00:00
 | Employee 6 | 9 |  | 37.5 |  |  |  |  | 25 |  |  | 7.11 |  |  |  | 2012-03-01 00:00:00
 | Employee 7 | 12 |  | 21 |  |  |  |  | 0 |  |  | 0 |  |  |  | 2012-03-01 00:00:00
 | Employee 8 | 10 |  | 44.5 |  |  |  |  | 0 |  |  | 0 |  |  |  | 2012-03-01 00:00:00
3/1/2012-3/15/2012 | Employee 1 | 10 |  | 99.25 |  |  |  |  | 71 |  |  | 27.69 |  |  |  | 2012-03-16 00:00:00
7 Employees | Employee 2 | 11.25 |  | 99.25 |  |  |  |  | 63 |  |  | 25.4 |  |  |  | 2012-03-16 00:00:00
 | Employee 3 | 10.5 |  | 75.5 |  |  |  |  | 46 |  |  | 85 |  |  |  | 2012-03-16 00:00:00
 | Employee 4 | 16 |  | 80 |  |  |  |  | 116 |  |  | 44.55 |  |  |  | 2012-03-16 00:00:00
 | Employee 5 | 10.5 |  | 99.25 |  |  |  |  |  |  |  |  | 421 |  |  | 2012-03-16 00:00:00
 | Employee 6 | 9 |  | 105 |  |  |  |  | 112 |  |  | 32.29 |  |  |  | 2012-03-16 00:00:00
 | Employee 7 | 12 |  | 34 |  |  |  |  | 8 |  |  | 3.14 |  |  |  | 2012-03-16 00:00:00
3/16/2012-3/31/2012 | Employee 1 | 10 |  | 116.5 |  |  |  |  | 98 |  |  | 37.11 |  |  |  | 2012-04-01 00:00:00
 | Employee 2 | 11.25 |  | 116.5 |  |  |  |  | 89 |  |  | 35.44 |  |  |  | 2012-04-01 00:00:00
 | Employee 3 | 10.5 |  | 107.5 |  |  |  |  | 85 |  |  | 28.96 |  |  |  | 2012-04-01 00:00:00
 | Employee 4 | 16 |  | 80 |  |  |  |  | 116 |  |  | 44.55 |  |  |  | 2012-04-01 00:00:00 |  |  | 14.38
 | Employee 5 | 10.5 |  | 107.5 |  |  |  |  | 65 |  |  | 25.4 | 421 |  |  | 2012-04-01 00:00:00
 | Employee 6 | 9 |  | 93.5 |  |  |  |  | 97 |  |  | 27.27 |  |  |  | 2012-04-01 00:00:00
Employee | SS Number | Total Wages 1st quarter |  |  |  |  | SUMMARY BY MONTH -Federal Taxes
Employee 1 | 000-00-0000 | 5365 |  |  |  | Wages | Federal Withholding | SS employee | Medicare Employee | SS Employer | Medicare Employer
Employee 2 | 000-00-0000 | 5838.75 |  |  | January
Employee 3 | 000-00-0000 | 4662 |  |  | February
Employee 4 | 000-00-0000 | 8048 |  |  | March
Employee 5 | 000-00-0000 | 5147.63 |  |  | Totals=
Employee 6 | 000-00-0000 | 558 |  |  |  |  | Total SS |  |  | Total Medicare
Employee 7 | 000-00-0000 | 54
Employee 8 | 000-00-0000 | 2847
Employee 9 | 000-00-0000 | 2580
Employee 10 | 000-00-0000 | 2144.63 |  |  |  | Payroll Construction |  | FED ID
Employee 11 | 000-00-0000 | 2970 |  |  |  | 0000 Payroll Ave |  | 0
Employee 12 | 000-00-0000 | 2124 |  |  |  | Nowhere, US
Employee 13 | 000-00-0000 | 2124 |  |  |  | 0 |  | State ID
 |  |  |  |  |  |  |  | US            00000000
 | Total Wages