226 Payroll Accounting Chapter 7: Comprehensive Projects --Paper Based Vers One-Month Project NOTE! Templates needed to complete these exercises, including one containing year-to-date payroll data, are included in the Student Exercise Files download for this course. Ellipses Corp. is a small business that operates in Herndon, VA. The company is located at 20 Period Lane, Herndon, VA 20170. Its federal Employer Identification Number is 77-7777777, and its president, who signs all tax forms, is John Parker (telephone #571-555-0073). The cornpany does not wish to name a third-party designee on forms During 2019 four individuals are employed by Ellipses Corp. These employees are as follows: State W/H Allowances Marital Status Federal W/H Allowances Social Security # Married 2 Name Address 2 111-11-1111 Married 3 Hunter Cranston 85 Southern Road Herndon, VA 20170 4 777-77-7777 Allison Harrison 203A Pine Court Herndon, VA 20170 1 Single 1 444-44-4444 1929.410 1,421.34 11, 18:32 Herndon, VA 20170 6,510084 John Parker 212 Tradition Lane Married 2 2 333-33-3333 Pierre Sternberg 41 Seward Boulevard Herndon, VA 20170 Note that Pierre Sternberg was hired in November, and his first day of work was Monday, November 25. Additionally, due to an economic downturn, Allison Harrison was laid off in mid-December, with her last day of work on Friday, December 13. All employees of Ellipses Corp. work a regular 40-hour workweek (thus all hours worked over 40 in a given week are overtime hours), receive overtime pay at a rate of 1.5 times the regular wage rate, and are paid Weekly) on Friday for the current week (which runs from Saturday through Friday, although employees never work on weekends). The SUTA tax rate applicable to Ellipses Corp. is 3.1%, while the SUTA wage base in Virginia is ($8,000. Earnings and voluntary deduction information for each of the four employees is as follows: Regular Wage Rate Annual Salary Weekly 401(k) Deduction Weekly Charitable Contribution Name S5 6% of gross pay N/A $15/hour Hunter Cranston $5 N/A 5% of gross pay $23/hour Allison Harrison N/A $20 $203,000.20 N/A John Parker N/A 1% of gross pay $112,000.20 N/A Pierre Sternberg The first 11 months of the year have passed, and all payroll-related activity has been properly accounted for as of 11/30/2019. Payroll data for each of the four employees for the first three quarters of the year, as well as for the months of October and November, is as follows: Hunter Cranston Gross Earnings Federal Income Tax State Social Income Tax Security Tax Medicare Tax 401(k) Deduction Charitable Cont. Period $7,800 $221 $366,60 $483.60 $113.10 $468 $65 1st quarter $7,800 $221 $366.60 5483.60 $113.10 $65 $468 2nd quarter $7,800 $221 $366.60 $483.60 $113.10 $468 $65 3rd quarter $2,400 $68 $112.80 $148.80 $34.80 $144 $20 October $3,000 $85 $141 S186 $43.50 $180 $25 November Allison Harrison Gross Earnings Federal Income Tax State Social Income Tax Security Tax Medicare 401(k) Tax Deduction Charitable Cont. Period $65 $598 $416 $11,960 $568.10 $741.52 $173.42 1st quarter $65 $ 173.42 $598 $11.960 $416 $568.10 $741.52 2nd quarter $598 $65 $ 173.42 $416 $568.10 $741.52 $11,960 3rd quarter $184 $20 $53.36 $174.80 $228.16 October $3,680 $128 $230 $25 $66.70 $160 $285.20 $4,600 $218.50 November John Parker Charitable Cont. 401(k) Deduction Gross Earnings State Income Tax Federal Income Tax Social Medicare Security Tax Tax Period $0 $260 $735.93 $3,146.52 $2,537.47 $10,929.36 $50,750.05 1st quarter SO $260 $735.93 $3,146.52 $2,537.47 $50,750.05 $10,929.36 $260 2nd quarter SO $735.93 $1,946.76 $10.929.36 $2,537.47 $50,750.05 3rd quarter $80 $0 $226.44 $780.76 SO $3,362.88 October $100 $0 $15,615.40 $19,519,25 $283.05 $975.95 SO $4,203.60 November Payroll ACCO 401(k) Deduction charitable Medicare Tax Cont Pierre Sternberg Social Security Tax SO SO State Income Tax Gross Earnings 50 Federal Income Tax Period 50 SO SO SO SO SO 50 $0 1st quarter SO $0 so SO 2nd quarter SO 50 50 SO SO SO SO 50 $0 3rd quarter SO $21.54 So SO $31.23 October SO SO $133,54 $106.62 5224.36 November $2,153.85 Note that all tax payments and filings are made on the due date. Based on the data provided here, you will complete the following: 1. Establish an employee earnings record for each of the company's four employees. Complete the top portion of each record. 2. Establish and complete the payroll register for each weekly pay period during December. When calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using method only when necessary, Note that as of December 7, Hunter Cranston requests that his federal withholding allowances increase from two to three (Ellipses Corp. makes this change) . Additionally, for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the the applicable state's withholding tables. Payroll checks are remitted to the employees in the same orders (Cranston, Harrison, Parker, Sternberg) each pay period and are written from a bank account that is used solely for these payments. The first payroll check written in December is check #762. Note that all charitable contributions are deemed to be made on the final day of each pay period. The following information will be required for the completion of these records for the two employees who are compensated via an hourly wage: Weekly Hours Worked Weekly Start Date Hunter Cranston Allison Harrison 40 37 November 30 41 December 7 38 43.5 0 December 14 December 21 40 0 WARNING! The above dates are weekly start dates. Refer to a calendar to determine the weekly end dates and associated pay dates. Keep in mind that tax liability and payment amounts are determined based on the weekly pay dates. 3. Complete the employee earnings records for December for each of the four employees. Divide the voluntary deductions from the payroll register appropriately across the associated columns within the employee earnings records. If directed to do so by your instructor, record the necessary journal entries for each pay period. Three Month Project 229 14. Complete Form 941 for the 4th quarter. Note that based on the lookback period, the company is a monthly depositor. Assume that all necessary deposits were made on a timely basis and that the employer made also filed by Ellipses Corp., you will not complete these. If directed to do so by your instructor, record the deposits equal to the total amount owed for the quarter. Although Virginia quarterly state payroll forms are necessary journal entries associated with Form 941 (including those required for any tax payments made). NOTE! Recall from the Form 941 Rounding Considerations section that quarter- and year-end tax figures should not be calculated based on the total taxable earnings for the respective quarter or year Instead, to avoid rounding discrepancies, tax figures within Part 2 of Form 941 should be determined for each employee by adding the individual taxes across each pay period. 5. Complete Form 940 for Ellipses Corp. Note that FUTA payments are made only when required (i.e., if the employer is permitted to postpone the payment of these taxes, it will do so until a point in time when payment must be remitted). If directed to do so by your instructor, record the necessary journal entry associated with Form 940. wages Kalculate total SUTA tax owed by the employer . Although Ellipses Corp. will file state forms in which this figure is reported, you are required to calculate only the total amount owed for the year. Complete Copy A of Form W-2 for each of the four employees. State wages were the same as federal subject to federal withholding tax for each of the four employees , and the state identification number for Ellipses Corp. is the same as its federal Employer Identification Number. 8. Complete Form W-3 for Ellipses Corp. Note that the company files the paper version of the form and sele None apply" in the Kind of Employer section. B2 4 x fx Employee Earnings Record c D E F G H L M N o P R S T U V w X B 2 4 Name Employee Earnings Record Hunter Cranston Marital Status Married 6 Address 2 (until Dec 6; as of Dec 7 this increases to 3) 85 Southern Road Herndon, VA 20170 Fed. Withholding Allow. State Withholding Allow. 2 111-11-1111 10 SSU 11 12 Earnings Deductions egular Pay Rate Regular Wages ertime Pay Rate wertime Wages deral Withholding Tax Vithholding Tax Gross Pay Social Security Tax Medicare Tax 0 0 o 0 13 14 1st Quarter 15 2nd Quarter 16 3rd Quarter 17 October 18 November 19 W/E Dec. 6 20 W/E Dec. 13 21 W/E Dec. 20 22 W/E Dec. 27 23 520 520 520 200 160 40 38 40 40 0 $15 $15 $15 $15 $15 $15 $15 $15 $15 $7,800 $7 800 $7800 $2,400 $3,000 $600 $750 $600 $600 $22.50 $22.50 $22.50 $22.50 $22.50 $22.50 $22.50 $22.50 $22.50 $ 483.60 $ 113.10 $ 468.00 $ 65.00 $ $ 483.60 $ 113.10 $ 468.00 S 65.00 $ $ 483.60 $ 113.10 $ 468.00 $ 65.00 $ $ 148.80$ 34.80$ 144.00 $ 20.00 $ $ 186.00 $ 43.50 $ 180.00 $ 25.00 $ $ 7.800.00 $ 221.00 $ 366.60 $ 7,800.00 $ 221.00 $366.60 $ 7,800.00 $ 221.00 $ 366.60 $ 2,400.00 $ 68,00 $ 112.80 $ 3.000.00 $ 85.00 $ 141.00 $600 $570 $678.75 $600 $ 6,082.70 $ 6,082.70 $ 6,082.70 $ 1871.60 $ 2,339.50 0 0 0 3.5 $78.75 0 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Hunter Cranston Allison Harrison John Parker Pierre Sternberg + Ready 019 4 x fx A B C D E F G H K L M N o Q R S T T. U V w X Employee Earnings Record Name Allison Harrison Marital Status Married 3 6 Address 4 203A Pine Court Herndon, VA 20170 Fed. Withholding Allow. State Withholding Allow. 3 SSY 777-77-7777 9 10 11 12 Earnings Deductions ay Period Ending tegular Hours Worked Regular Pay Rate egular Wages Overtime Hours Worked Overtime Pay Rate wertime Wages cial Security Tax Medicare Tax oss Pay aditional Withholding Check Number 13 14 15 16 17 18 19 20 21 22 23 1st Quarter 2nd Quarter 3rd Quarter October November W/E Dec. 6 W/E Dec. 13 $ 11,960.00 $ 416.00 $ 568.10 $ 741.52 $ 173.42 $ 598.00$ 65.00 $ $ 11,960.00 $ 416.00 $ 568.10 $ 741.52 $ 173.42 $ 598.00 $ 65.00 $ $ 11960.00 $ 416.00 $ 568.10 $ 741.52 $ 173.42 $ 598.00 $ 65.00 $ $ 3,680.00 $ 128.00 $ 174.80 $ 228.16 $ 66.70 $ 66.70 $ 184.00 $ 20.00 $ $ 4,600.00 $ 160.00 $ 218.50 $ 285.20 $ 53.36 $ 230,00 $ 25.00 $ $ 9,397.96 $ 9,397.96 $ 9,397.96 $ 2,878.34 $ 3,627.94 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Hunter Cranston Allison Harrison John Parker Pierre Sternberg + Ready B2 X fx Employee Earnings Record A B D EF G H L M N 0 P R S U V w 1 Employee Earnings Record Name John Parker Marital Status Single 3 6 Address 212 Tradition Lane Herndon, VA 20170 1 1 Fed. Withholding Allow. State Withholding Allow. 1 SSU 444-44-4444 9 10 11 12 Earnings Deductions ay Period Ending egular Hours Worked Regular Pay Rate Overtime Hours Worked tegular Wages Overtime Pay Rate Overtime Wages eral Withholding Tax State Withholding Tax hal Withholding ocial Security Tax Gross Pay Medicare Tax 13 14 15 16 17 18 19 20 21 22 23 1st Quarter 2nd Quarter 3rd Quarter October November W/E Dec. 6 W/E Dec 13 W/E Dec. 20 W/E Dec. 27 Total $ 50,750.05 $ 10,929.36 $ 2,537.47 $ 3,146.52 $ 735.93 $ $ 50,750.05 $ 10,929.36 $ 2,537.47$ 3,146.52 $ $ 735.93 $ $ 50,750.05 $ 10,929.36 $ 2,537 47$ 1,946.76 $ 735.93 $ $ 15,615.40$ 3,362.88 $ 780.76 $ $ 226.44 $ $ 19,519.25$ 4,203.60 $ 975.95 $ $ 283.05$ $3.903.85 $848.86 $195.19 $ $56.61 $ $3,903.85 $848.86 $195.19 $ $56.61 $ $3.903.85 $848.86 $195.19 $ $56.61 $ $3,903.85 $848.86 $195.19 $ $56.61 $ $ 260.00 $ $ 260.00 $ $ 260.00 $ $ 80.00 $ $ 100.00 $ $20 $20 $20 $20 $ 33.140.77 $ 33,140.77 $ 34 34053 $ 11 165 32 $ 13,956.65 $2,783.19 $2,783.19 $2,783.19 $2,783.19 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Hunter Cranston Allison Harrison John Parker Pierre Sternberg + Ready Y1 fx A B D E F G G H 1 K L M N o P R s T U V w X Employee Earnings Record 2 3 4 Name Pierre Sternberg Marital Status Married 6 Address 2 41 Seward Blvd. Herndon, VA 20170 Fed. Withholding Allow. State Withholding Allow. 2 SSY 9. 10 11 12 333-33-3333 Earnings Deductions ay Period Ending lar Hours Worked egular Pay Rate egular Wages Overtime Hours Worked Overtime Pay Rate vertime Wages deral Withholding Tax ate Withholding Tax oss pay ocial Security Tax itable Contribution edicare Tax Check Number 13 14 15 16 17 18 19 20 21 22 23 1st Quarter 2nd Quarter 3rd Quarter October November W/E Dec. 6 W/E Dec. 13 W/E Dec. 20 W/E Dec. 27 $ $ $ $ $ 2,153.85 $ $ $ $ $ $ 224.36 $ $ $ $ $ 106.62 $ $ $ $ $ 133.54 $ $ $ $ $ 31.23 $ $ $ $ $ $ $ $ $ 21.54 $ $ $ $ $ $ $ $ $ $ $ 1,636.56 25 26 27 28 29 30 31 32 33 34 35 36 37 Hunter Cranston Allison Harrison John Parker Pierre Sternberg + Ready 226 Payroll Accounting Chapter 7: Comprehensive Projects --Paper Based Vers One-Month Project NOTE! Templates needed to complete these exercises, including one containing year-to-date payroll data, are included in the Student Exercise Files download for this course. Ellipses Corp. is a small business that operates in Herndon, VA. The company is located at 20 Period Lane, Herndon, VA 20170. Its federal Employer Identification Number is 77-7777777, and its president, who signs all tax forms, is John Parker (telephone #571-555-0073). The cornpany does not wish to name a third-party designee on forms During 2019 four individuals are employed by Ellipses Corp. These employees are as follows: State W/H Allowances Marital Status Federal W/H Allowances Social Security # Married 2 Name Address 2 111-11-1111 Married 3 Hunter Cranston 85 Southern Road Herndon, VA 20170 4 777-77-7777 Allison Harrison 203A Pine Court Herndon, VA 20170 1 Single 1 444-44-4444 1929.410 1,421.34 11, 18:32 Herndon, VA 20170 6,510084 John Parker 212 Tradition Lane Married 2 2 333-33-3333 Pierre Sternberg 41 Seward Boulevard Herndon, VA 20170 Note that Pierre Sternberg was hired in November, and his first day of work was Monday, November 25. Additionally, due to an economic downturn, Allison Harrison was laid off in mid-December, with her last day of work on Friday, December 13. All employees of Ellipses Corp. work a regular 40-hour workweek (thus all hours worked over 40 in a given week are overtime hours), receive overtime pay at a rate of 1.5 times the regular wage rate, and are paid Weekly) on Friday for the current week (which runs from Saturday through Friday, although employees never work on weekends). The SUTA tax rate applicable to Ellipses Corp. is 3.1%, while the SUTA wage base in Virginia is ($8,000. Earnings and voluntary deduction information for each of the four employees is as follows: Regular Wage Rate Annual Salary Weekly 401(k) Deduction Weekly Charitable Contribution Name S5 6% of gross pay N/A $15/hour Hunter Cranston $5 N/A 5% of gross pay $23/hour Allison Harrison N/A $20 $203,000.20 N/A John Parker N/A 1% of gross pay $112,000.20 N/A Pierre Sternberg The first 11 months of the year have passed, and all payroll-related activity has been properly accounted for as of 11/30/2019. Payroll data for each of the four employees for the first three quarters of the year, as well as for the months of October and November, is as follows: Hunter Cranston Gross Earnings Federal Income Tax State Social Income Tax Security Tax Medicare Tax 401(k) Deduction Charitable Cont. Period $7,800 $221 $366,60 $483.60 $113.10 $468 $65 1st quarter $7,800 $221 $366.60 5483.60 $113.10 $65 $468 2nd quarter $7,800 $221 $366.60 $483.60 $113.10 $468 $65 3rd quarter $2,400 $68 $112.80 $148.80 $34.80 $144 $20 October $3,000 $85 $141 S186 $43.50 $180 $25 November Allison Harrison Gross Earnings Federal Income Tax State Social Income Tax Security Tax Medicare 401(k) Tax Deduction Charitable Cont. Period $65 $598 $416 $11,960 $568.10 $741.52 $173.42 1st quarter $65 $ 173.42 $598 $11.960 $416 $568.10 $741.52 2nd quarter $598 $65 $ 173.42 $416 $568.10 $741.52 $11,960 3rd quarter $184 $20 $53.36 $174.80 $228.16 October $3,680 $128 $230 $25 $66.70 $160 $285.20 $4,600 $218.50 November John Parker Charitable Cont. 401(k) Deduction Gross Earnings State Income Tax Federal Income Tax Social Medicare Security Tax Tax Period $0 $260 $735.93 $3,146.52 $2,537.47 $10,929.36 $50,750.05 1st quarter SO $260 $735.93 $3,146.52 $2,537.47 $50,750.05 $10,929.36 $260 2nd quarter SO $735.93 $1,946.76 $10.929.36 $2,537.47 $50,750.05 3rd quarter $80 $0 $226.44 $780.76 SO $3,362.88 October $100 $0 $15,615.40 $19,519,25 $283.05 $975.95 SO $4,203.60 November Payroll ACCO 401(k) Deduction charitable Medicare Tax Cont Pierre Sternberg Social Security Tax SO SO State Income Tax Gross Earnings 50 Federal Income Tax Period 50 SO SO SO SO SO 50 $0 1st quarter SO $0 so SO 2nd quarter SO 50 50 SO SO SO SO 50 $0 3rd quarter SO $21.54 So SO $31.23 October SO SO $133,54 $106.62 5224.36 November $2,153.85 Note that all tax payments and filings are made on the due date. Based on the data provided here, you will complete the following: 1. Establish an employee earnings record for each of the company's four employees. Complete the top portion of each record. 2. Establish and complete the payroll register for each weekly pay period during December. When calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using method only when necessary, Note that as of December 7, Hunter Cranston requests that his federal withholding allowances increase from two to three (Ellipses Corp. makes this change) . Additionally, for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the the applicable state's withholding tables. Payroll checks are remitted to the employees in the same orders (Cranston, Harrison, Parker, Sternberg) each pay period and are written from a bank account that is used solely for these payments. The first payroll check written in December is check #762. Note that all charitable contributions are deemed to be made on the final day of each pay period. The following information will be required for the completion of these records for the two employees who are compensated via an hourly wage: Weekly Hours Worked Weekly Start Date Hunter Cranston Allison Harrison 40 37 November 30 41 December 7 38 43.5 0 December 14 December 21 40 0 WARNING! The above dates are weekly start dates. Refer to a calendar to determine the weekly end dates and associated pay dates. Keep in mind that tax liability and payment amounts are determined based on the weekly pay dates. 3. Complete the employee earnings records for December for each of the four employees. Divide the voluntary deductions from the payroll register appropriately across the associated columns within the employee earnings records. If directed to do so by your instructor, record the necessary journal entries for each pay period. Three Month Project 229 14. Complete Form 941 for the 4th quarter. Note that based on the lookback period, the company is a monthly depositor. Assume that all necessary deposits were made on a timely basis and that the employer made also filed by Ellipses Corp., you will not complete these. If directed to do so by your instructor, record the deposits equal to the total amount owed for the quarter. Although Virginia quarterly state payroll forms are necessary journal entries associated with Form 941 (including those required for any tax payments made). NOTE! Recall from the Form 941 Rounding Considerations section that quarter- and year-end tax figures should not be calculated based on the total taxable earnings for the respective quarter or year Instead, to avoid rounding discrepancies, tax figures within Part 2 of Form 941 should be determined for each employee by adding the individual taxes across each pay period. 5. Complete Form 940 for Ellipses Corp. Note that FUTA payments are made only when required (i.e., if the employer is permitted to postpone the payment of these taxes, it will do so until a point in time when payment must be remitted). If directed to do so by your instructor, record the necessary journal entry associated with Form 940. wages Kalculate total SUTA tax owed by the employer . Although Ellipses Corp. will file state forms in which this figure is reported, you are required to calculate only the total amount owed for the year. Complete Copy A of Form W-2 for each of the four employees. State wages were the same as federal subject to federal withholding tax for each of the four employees , and the state identification number for Ellipses Corp. is the same as its federal Employer Identification Number. 8. Complete Form W-3 for Ellipses Corp. Note that the company files the paper version of the form and sele None apply" in the Kind of Employer section. B2 4 x fx Employee Earnings Record c D E F G H L M N o P R S T U V w X B 2 4 Name Employee Earnings Record Hunter Cranston Marital Status Married 6 Address 2 (until Dec 6; as of Dec 7 this increases to 3) 85 Southern Road Herndon, VA 20170 Fed. Withholding Allow. State Withholding Allow. 2 111-11-1111 10 SSU 11 12 Earnings Deductions egular Pay Rate Regular Wages ertime Pay Rate wertime Wages deral Withholding Tax Vithholding Tax Gross Pay Social Security Tax Medicare Tax 0 0 o 0 13 14 1st Quarter 15 2nd Quarter 16 3rd Quarter 17 October 18 November 19 W/E Dec. 6 20 W/E Dec. 13 21 W/E Dec. 20 22 W/E Dec. 27 23 520 520 520 200 160 40 38 40 40 0 $15 $15 $15 $15 $15 $15 $15 $15 $15 $7,800 $7 800 $7800 $2,400 $3,000 $600 $750 $600 $600 $22.50 $22.50 $22.50 $22.50 $22.50 $22.50 $22.50 $22.50 $22.50 $ 483.60 $ 113.10 $ 468.00 $ 65.00 $ $ 483.60 $ 113.10 $ 468.00 S 65.00 $ $ 483.60 $ 113.10 $ 468.00 $ 65.00 $ $ 148.80$ 34.80$ 144.00 $ 20.00 $ $ 186.00 $ 43.50 $ 180.00 $ 25.00 $ $ 7.800.00 $ 221.00 $ 366.60 $ 7,800.00 $ 221.00 $366.60 $ 7,800.00 $ 221.00 $ 366.60 $ 2,400.00 $ 68,00 $ 112.80 $ 3.000.00 $ 85.00 $ 141.00 $600 $570 $678.75 $600 $ 6,082.70 $ 6,082.70 $ 6,082.70 $ 1871.60 $ 2,339.50 0 0 0 3.5 $78.75 0 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Hunter Cranston Allison Harrison John Parker Pierre Sternberg + Ready 019 4 x fx A B C D E F G H K L M N o Q R S T T. U V w X Employee Earnings Record Name Allison Harrison Marital Status Married 3 6 Address 4 203A Pine Court Herndon, VA 20170 Fed. Withholding Allow. State Withholding Allow. 3 SSY 777-77-7777 9 10 11 12 Earnings Deductions ay Period Ending tegular Hours Worked Regular Pay Rate egular Wages Overtime Hours Worked Overtime Pay Rate wertime Wages cial Security Tax Medicare Tax oss Pay aditional Withholding Check Number 13 14 15 16 17 18 19 20 21 22 23 1st Quarter 2nd Quarter 3rd Quarter October November W/E Dec. 6 W/E Dec. 13 $ 11,960.00 $ 416.00 $ 568.10 $ 741.52 $ 173.42 $ 598.00$ 65.00 $ $ 11,960.00 $ 416.00 $ 568.10 $ 741.52 $ 173.42 $ 598.00 $ 65.00 $ $ 11960.00 $ 416.00 $ 568.10 $ 741.52 $ 173.42 $ 598.00 $ 65.00 $ $ 3,680.00 $ 128.00 $ 174.80 $ 228.16 $ 66.70 $ 66.70 $ 184.00 $ 20.00 $ $ 4,600.00 $ 160.00 $ 218.50 $ 285.20 $ 53.36 $ 230,00 $ 25.00 $ $ 9,397.96 $ 9,397.96 $ 9,397.96 $ 2,878.34 $ 3,627.94 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Hunter Cranston Allison Harrison John Parker Pierre Sternberg + Ready B2 X fx Employee Earnings Record A B D EF G H L M N 0 P R S U V w 1 Employee Earnings Record Name John Parker Marital Status Single 3 6 Address 212 Tradition Lane Herndon, VA 20170 1 1 Fed. Withholding Allow. State Withholding Allow. 1 SSU 444-44-4444 9 10 11 12 Earnings Deductions ay Period Ending egular Hours Worked Regular Pay Rate Overtime Hours Worked tegular Wages Overtime Pay Rate Overtime Wages eral Withholding Tax State Withholding Tax hal Withholding ocial Security Tax Gross Pay Medicare Tax 13 14 15 16 17 18 19 20 21 22 23 1st Quarter 2nd Quarter 3rd Quarter October November W/E Dec. 6 W/E Dec 13 W/E Dec. 20 W/E Dec. 27 Total $ 50,750.05 $ 10,929.36 $ 2,537.47 $ 3,146.52 $ 735.93 $ $ 50,750.05 $ 10,929.36 $ 2,537.47$ 3,146.52 $ $ 735.93 $ $ 50,750.05 $ 10,929.36 $ 2,537 47$ 1,946.76 $ 735.93 $ $ 15,615.40$ 3,362.88 $ 780.76 $ $ 226.44 $ $ 19,519.25$ 4,203.60 $ 975.95 $ $ 283.05$ $3.903.85 $848.86 $195.19 $ $56.61 $ $3,903.85 $848.86 $195.19 $ $56.61 $ $3.903.85 $848.86 $195.19 $ $56.61 $ $3,903.85 $848.86 $195.19 $ $56.61 $ $ 260.00 $ $ 260.00 $ $ 260.00 $ $ 80.00 $ $ 100.00 $ $20 $20 $20 $20 $ 33.140.77 $ 33,140.77 $ 34 34053 $ 11 165 32 $ 13,956.65 $2,783.19 $2,783.19 $2,783.19 $2,783.19 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Hunter Cranston Allison Harrison John Parker Pierre Sternberg + Ready Y1 fx A B D E F G G H 1 K L M N o P R s T U V w X Employee Earnings Record 2 3 4 Name Pierre Sternberg Marital Status Married 6 Address 2 41 Seward Blvd. Herndon, VA 20170 Fed. Withholding Allow. State Withholding Allow. 2 SSY 9. 10 11 12 333-33-3333 Earnings Deductions ay Period Ending lar Hours Worked egular Pay Rate egular Wages Overtime Hours Worked Overtime Pay Rate vertime Wages deral Withholding Tax ate Withholding Tax oss pay ocial Security Tax itable Contribution edicare Tax Check Number 13 14 15 16 17 18 19 20 21 22 23 1st Quarter 2nd Quarter 3rd Quarter October November W/E Dec. 6 W/E Dec. 13 W/E Dec. 20 W/E Dec. 27 $ $ $ $ $ 2,153.85 $ $ $ $ $ $ 224.36 $ $ $ $ $ 106.62 $ $ $ $ $ 133.54 $ $ $ $ $ 31.23 $ $ $ $ $ $ $ $ $ 21.54 $ $ $ $ $ $ $ $ $ $ $ 1,636.56 25 26 27 28 29 30 31 32 33 34 35 36 37 Hunter Cranston Allison Harrison John Parker Pierre Sternberg + Ready