Spreadsheet: 680989d1591288966-autofilling-paychecks-from-payroll-example_2020
Sheet: Cook, Carl

Name |  |  | example |  |  |  |  |  |  |  | SocSec Total (split) |  |  | 0.124
Address |  |  | address |  |  |  |  |  |  |  | Medicare Total (split) |  |  | 0.029
Rate of pay |  |  | 48.0528846154 |  |  |  |  |  |  |  | WA SUI 2020 Limit |  |  | 52700
SS |  |  | xxxx |  |  | [NAME] |  |  |  |  | WA SUI 2020 Rate |  |  | 0.0121
Status |  |  | Single/1 |  |  | 1 |  |  |  |  | WA EAF 2020 Rate |  |  | 0.0003
Extra Ded/Allowances |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * | * | * | * |  |  |  |  |  |  |  | Form 940 31Jan2020 https://www.irs.gov/employmentefile
Week |  | From | To | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Wage | Otrate | Hours | OT | [NAME] | OT Pay | Gross |  | Fed Tax | SocSec | Medicare | WA SUI | WA EAF | Other Deduct | Total Ded | Net Pay | Pay Date | Check | Total Soc Sec | Total Medicare | Total FUTA | Total St Withh | Total Empl Taxes
19 |  | 2020-05-04 00:00:00 | 2020-05-10 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0 |  |  |  | 5003
20 |  | 2020-05-11 00:00:00 | 2020-05-17 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
21 |  | 2020-05-18 00:00:00 | 2020-05-24 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
22 |  | 2020-05-25 00:00:00 | 2020-05-31 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
23 |  | 2020-06-01 00:00:00 | 2020-06-07 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
24 |  | 2020-06-08 00:00:00 | 2020-06-14 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
25 |  | 2020-06-15 00:00:00 | 2020-06-21 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
26 |  | 2020-06-22 00:00:00 | 2020-06-28 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
27 |  | 2020-06-29 00:00:00 | 2020-07-05 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
28 |  | 2020-07-06 00:00:00 | 2020-07-12 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
29 |  | 2020-07-13 00:00:00 | 2020-07-19 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
30 |  | 2020-07-20 00:00:00 | 2020-07-26 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290 |  |  |  |  | 0
31 |  | 2020-07-27 00:00:00 | 2020-08-02 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
32 |  | 2020-08-03 00:00:00 | 2020-08-09 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
33 |  | 2020-08-10 00:00:00 | 2020-08-16 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
34 |  | 2020-08-17 00:00:00 | 2020-08-23 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
35 |  | 2020-08-24 00:00:00 | 2020-08-30 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
36 |  | 2020-08-31 00:00:00 | 2020-09-06 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
37 |  | 2020-09-07 00:00:00 | 2020-09-13 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
38 |  | 2020-09-14 00:00:00 | 2020-09-20 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
39 |  | 2020-09-21 00:00:00 | 2020-09-27 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
40 |  | 2020-09-28 00:00:00 | 2020-10-04 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
41 |  | 2020-10-05 00:00:00 | 2020-10-11 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
42 |  | 2020-10-12 00:00:00 | 2020-10-18 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
43 |  | 2020-10-19 00:00:00 | 2020-10-25 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
44 |  | 2020-10-26 00:00:00 | 2020-11-01 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
45 |  | 2020-11-02 00:00:00 | 2020-11-08 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
46 |  | 2020-11-09 00:00:00 | 2020-11-15 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
47 |  | 2020-11-16 00:00:00 | 2020-11-22 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
48 |  | 2020-11-23 00:00:00 | 2020-11-29 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
49 |  | 2020-11-30 00:00:00 | 2020-12-06 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
50 |  | 2020-12-07 00:00:00 | 2020-12-13 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
51 |  | 2020-12-14 00:00:00 | 2020-12-20 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
52 |  | 2020-12-21 00:00:00 | 2020-12-27 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
53 |  | 2020-12-28 00:00:00 | 2021-01-03 00:00:00 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 290
Totals
Week | 20 | : |  |  |  | A12:ah46
 |  | company
 |  | address
 |  | city
Pay to the
order of
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dollars
 |  |  |  |  |  |  |  |  | cacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacacaca
 |  | Week Ending
 |  | CsomethingC |  | AelseA |  |  |  |  | C
Employee |  |  | W/E |  | S.S |  |  | Status
Earnings and Hours |  |  | Current |  |  |  |  |  | Year to Date
Hourly Wage
Hours this week
Gross Pay |  |  |  |  |  |  |  | HERE>>
Withholding |  |  | Current |  |  |  |  |  | Year to Date
Federal Withholding
Social Security
Medicare Employee
WA State- Withholding
Other Deductions
Total Withholding
Net Pay