A BCDEFGHIJKLMNOPQRSTU Y 2 AA 123 PAYROLL REGISTER AB AC GLO-BRITE PAINT COMPANY AD AE AF AG AH Al AJ AK AL AM AN AD AP AO AP AS A AU AV AW A NAME MTWTF 5 Fayday, October 9 For Feriad Endin 6 Bonno, A. 7 Ferguson, J. SSSSS Filing Status No. WH Allow. Time Record Regular Earnings Overtime Earnings Deductions Net Paid Taxable Earnings Labor Cost Distribution Rate Per Rate Per Total TFSHS Hour Amount Hrs Hour Amount Earings DASDI HI FIT SIT SUTA CIT Group Ins. Union Dues SIMPLE No. Ck. Amount OASDI HI FUTA SUTA Admin. Office Sales Plant MFJ NA SSSSS 80 17.60 1.408.00 1.408.00 MFJ NA 88 888 S S S88 80 2,250.00 2,250.00 87.30 20.42 139.50 32.63 34.00 43.23 0.99 53 36 8.00 127.00 69.08 158 85.28 8 Ford, C. S NA 8 8 88 8 88 SSS 80 1,220.00 1,220.00 75.64 17.69 75.00 37.45 0.85 16.21 674 9 Mann, K. MFJ NA 88 88 8 S S 888 80 1.350.00 1.350.00 83.70 19.58 28.00 4145 0.95 5117 672 1,160.70 1,408.00 1,408.00 673 1,794.93 2,250.00 2,250.00 967.13 1,220.00 1,220.00 675 1,125,15 1,350.00 1,350.00 1,350.00 1.350.00 1408.00 2,250.00 Checkpoints Total earnings: Net paid: 15.528.77: 12,508.59; 700.00 1,220.00 1,220.00 1,350.00 10 O'Neill, J. MFJ NA 8 8 8 S 8 S S S18 S SO 2.307.69 2,307.69 143.08 33.46 13100 70.85 1.62 97.46 676 1,840.22 2,307.69 2,307.69 2,307.69 11 Russell, S. S NA 8 8 SSS 8 S S 88 80 1.200.00 1.200.00 74.40 17.40 73.00 36.84 0.84 15.40 677 952.04 1,200.00 1,200.00 760.00 1,200.00 1.200.00 12 Ryan, J MFJ NA 88 SSSSS 80 18.00 1440.00 1440.00 89.28 20.88 38.00 44.21 101 54.58 8.00 678 1,184.04 1,440.00 1,440,00 13 Sokowski, T MFJ NA 8 8 88 8 S SSS 80 2.050.00 2.050.00 127.10 29.73 101.00 62.94 1.44 77.70 679 1,650.09 2,050.00 2,050.00 14 (Student) 5 NA 8 8 88 88 88 72 15.00 1080.00 1080.00 15 Williams, R. S NA 88 D88 88 SSS 80 1223 08 1.223.08 66.96 15.66 75.83 17.73 58.00 33.16 0.76 10 93 680 75.00 37.55 0.86 46.35 681 864.53 1,080.00 1,080.00 1,080.00 1,080.00 969.76 1,223.08 1,223.08 1,440.00 2,050.00 1,080.00 1,223.08 16 17 18 19 15.5287 15.528.77 962.79 225.18 740.00 476.76 10/90 598.55 TOTALS 20 Fayday, October 28, 29- For Faniad Endin 21 Bonno, A. 22 Ferguson, J. 23 Ford, C. MFJ NA MFJ NA 5 NA 24 Mann, K 25 O'Neill, J. 26 Russell, S. 27 Ryan, J 28 Sokowski, T. 29 Student] MFJ NA MFJ NA S NA MFJ NA MFJ NA S NA 30 Williams, R 5 NA 31 32 33 34 TOTALS 0.00 16.00 0,00 12,508,59 15.528.77 15.528.77 3,890.00 4,850.00 2,307.69 4,723.08 3,600.00 4,898.00 Checkpoints Total earnings Net paid: 0.00 0.00 0.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 35 Fayday, November 36 Bonno, A 20-For Period Ending October MFJ NA 37 Ferguson, J. MFJ NA 38 Ford, C. 39 Mann, K 40 O'Neill, J. 41 Russell, S. 42 Ryan, J. 43 Sokowski, T. MFJ NA S NA MFJ NA S NA MFJ NA S NA 44 (Student) S NA 45 Williams, R. S NA 46 47 4B 49 TOTALS 50 Payday, November 13 20--For Feriad Ending November 4, 20- 51 Williams, R 52 53 TOTALS S NA 54 Fayday, November 20 20-For Period Ending November 14, 20- 55 Bonno, A 56 Ferguson J. 57 Ford, C. En V MFJ NA MFJ NA SNA 0.00 0.00 0.00 10.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints Total earnings: Net paid: Checkpoints Total earnings: Net paid: Checkpoints Total earnings Net paid: 123 A BCDEFGHIJKLMNOPQRSTU PAYROLL REGISTER Time Record Regular Earnings Overtime Earings Filing Status No. W/H Allow. 4 NAME 54 Fayday, November 20 20-For Fe 55 Bonno, A. 56 Ferguson, J. 57 Ford, C. 58 Mann, K 59 O'Neill, J. 60 Russell, S. 61 Ryan, J. 62 Sokowski, T. MFJ NA MFJ NA S NA MFJ NA MFJ NA S NA MFJ NA 5 NA SM 63 [Student] 64 65 66 67 68 S NA T 27 A TI TOTALS 69 Fayday, December 4 30-For Period Ending November 70 Bonno, A. 71 Ferguson, J. 72 Ford, C 73 Mann, K 74 O'Neill, J. MFJ NA MFJ NA S NA MFJ NA MFJ NA AB AC GLO-BRITE PAINT COMPANY AD AE AF AG AH Al AJ AK AL AM AN AP AD AP AS A AU AV AM Deductions Net Paid Taxable Earnings Labor Cost Distribution Rate Per Rate Per MTW Hrs Hour Amount His Hour Amount Total Earnings Group Union Ck. DASDI HL FIT SIT SUTA CIT Ins. Dues SIMPLE No. Amount DASDI HI FUTA SUTA Admin Office Sales Plant Checkpoints Total earnings: Net paid: 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10.00 0.00|| 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints Total eamings Net paid: 75 Russell, S. S NA 76 Ryan, J. MFJ NA 77 Sokowski, T. S NA 78 (Student) S NA 79 Woods, B. S NA BD 81 82 TOTALS 0.00 0.00 0.00 10.00 0.00 10.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 83 Fayday, December 14 20-For Period Ending December 12,20- 84 Russell, S. S NA 85 86 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTALS 87 Fayday December 16 20-For Period Ending December 12, 20- BB Bonno, A 89 Ferguson, J. MFJ NA MFJ NA 90 Ford, C. S NA 91 Mann, K MEJ NA 92 D'Neill, J 93 Ryan, J. MFJ NA MFJ NA 94 Sokowski, T. S NA 95 (Student) S NA 96 Woods, B. S NA 97 Young, P S NA 98 99 100 101 TOTALS 102 103 CTR 104 YEAR Checkpoints Total earnings Net paid: Checkpoints Total earnings: Net paid: Checkpoints-Annual Total earnings: Qtr's taxable OASDI earnings: Total earnings for FIT Total earnings for SITICIT Total earnings for FUTA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.528.77 157,753.34 962.79 225.18 740.00 476.76 4,843.05 9,780.71 2,287.45 16,657.00 10.90 110.47 588.55 5,978.87 0.00 16.00 0.00 930.40 160.00 0.00 12,508.59 15,528.77 15.528.77 3.890.00 4.850.00 117.005.39 157.753.34 157.753.34 69,380.00 88.340.00 2.307.69 4.723.08 3.600.00 4.898.00
A BCDEFGHIJKLMNOPQRSTU Y 2 AA 123 PAYROLL REGISTER AB AC GLO-BRITE PAINT COMPANY AD AE AF AG AH Al AJ AK AL AM AN AD AP AO AP AS A AU AV AW A NAME MTWTF 5 Fayday, October 9 For Feriad Endin 6 Bonno, A. 7 Ferguson, J. SSSSS Filing Status No. WH Allow. Time Record Regular Earnings Overtime Earnings Deductions Net Paid Taxable Earnings Labor Cost Distribution Rate Per Rate Per Total TFSHS Hour Amount Hrs Hour Amount Earings DASDI HI FIT SIT SUTA CIT Group Ins. Union Dues SIMPLE No. Ck. Amount OASDI HI FUTA SUTA Admin. Office Sales Plant MFJ NA SSSSS 80 17.60 1.408.00 1.408.00 MFJ NA 88 888 S S S88 80 2,250.00 2,250.00 87.30 20.42 139.50 32.63 34.00 43.23 0.99 53 36 8.00 127.00 69.08 158 85.28 8 Ford, C. S NA 8 8 88 8 88 SSS 80 1,220.00 1,220.00 75.64 17.69 75.00 37.45 0.85 16.21 674 9 Mann, K. MFJ NA 88 88 8 S S 888 80 1.350.00 1.350.00 83.70 19.58 28.00 4145 0.95 5117 672 1,160.70 1,408.00 1,408.00 673 1,794.93 2,250.00 2,250.00 967.13 1,220.00 1,220.00 675 1,125,15 1,350.00 1,350.00 1,350.00 1.350.00 1408.00 2,250.00 Checkpoints Total earnings: Net paid: 15.528.77: 12,508.59; 700.00 1,220.00 1,220.00 1,350.00 10 O'Neill, J. MFJ NA 8 8 8 S 8 S S S18 S SO 2.307.69 2,307.69 143.08 33.46 13100 70.85 1.62 97.46 676 1,840.22 2,307.69 2,307.69 2,307.69 11 Russell, S. S NA 8 8 SSS 8 S S 88 80 1.200.00 1.200.00 74.40 17.40 73.00 36.84 0.84 15.40 677 952.04 1,200.00 1,200.00 760.00 1,200.00 1.200.00 12 Ryan, J MFJ NA 88 SSSSS 80 18.00 1440.00 1440.00 89.28 20.88 38.00 44.21 101 54.58 8.00 678 1,184.04 1,440.00 1,440,00 13 Sokowski, T MFJ NA 8 8 88 8 S SSS 80 2.050.00 2.050.00 127.10 29.73 101.00 62.94 1.44 77.70 679 1,650.09 2,050.00 2,050.00 14 (Student) 5 NA 8 8 88 88 88 72 15.00 1080.00 1080.00 15 Williams, R. S NA 88 D88 88 SSS 80 1223 08 1.223.08 66.96 15.66 75.83 17.73 58.00 33.16 0.76 10 93 680 75.00 37.55 0.86 46.35 681 864.53 1,080.00 1,080.00 1,080.00 1,080.00 969.76 1,223.08 1,223.08 1,440.00 2,050.00 1,080.00 1,223.08 16 17 18 19 15.5287 15.528.77 962.79 225.18 740.00 476.76 10/90 598.55 TOTALS 20 Fayday, October 28, 29- For Faniad Endin 21 Bonno, A. 22 Ferguson, J. 23 Ford, C. MFJ NA MFJ NA 5 NA 24 Mann, K 25 O'Neill, J. 26 Russell, S. 27 Ryan, J 28 Sokowski, T. 29 Student] MFJ NA MFJ NA S NA MFJ NA MFJ NA S NA 30 Williams, R 5 NA 31 32 33 34 TOTALS 0.00 16.00 0,00 12,508,59 15.528.77 15.528.77 3,890.00 4,850.00 2,307.69 4,723.08 3,600.00 4,898.00 Checkpoints Total earnings Net paid: 0.00 0.00 0.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 35 Fayday, November 36 Bonno, A 20-For Period Ending October MFJ NA 37 Ferguson, J. MFJ NA 38 Ford, C. 39 Mann, K 40 O'Neill, J. 41 Russell, S. 42 Ryan, J. 43 Sokowski, T. MFJ NA S NA MFJ NA S NA MFJ NA S NA 44 (Student) S NA 45 Williams, R. S NA 46 47 4B 49 TOTALS 50 Payday, November 13 20--For Feriad Ending November 4, 20- 51 Williams, R 52 53 TOTALS S NA 54 Fayday, November 20 20-For Period Ending November 14, 20- 55 Bonno, A 56 Ferguson J. 57 Ford, C. En V MFJ NA MFJ NA SNA 0.00 0.00 0.00 10.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints Total earnings: Net paid: Checkpoints Total earnings: Net paid: Checkpoints Total earnings Net paid: 123 A BCDEFGHIJKLMNOPQRSTU PAYROLL REGISTER Time Record Regular Earnings Overtime Earings Filing Status No. W/H Allow. 4 NAME 54 Fayday, November 20 20-For Fe 55 Bonno, A. 56 Ferguson, J. 57 Ford, C. 58 Mann, K 59 O'Neill, J. 60 Russell, S. 61 Ryan, J. 62 Sokowski, T. MFJ NA MFJ NA S NA MFJ NA MFJ NA S NA MFJ NA 5 NA SM 63 [Student] 64 65 66 67 68 S NA T 27 A TI TOTALS 69 Fayday, December 4 30-For Period Ending November 70 Bonno, A. 71 Ferguson, J. 72 Ford, C 73 Mann, K 74 O'Neill, J. MFJ NA MFJ NA S NA MFJ NA MFJ NA AB AC GLO-BRITE PAINT COMPANY AD AE AF AG AH Al AJ AK AL AM AN AP AD AP AS A AU AV AM Deductions Net Paid Taxable Earnings Labor Cost Distribution Rate Per Rate Per MTW Hrs Hour Amount His Hour Amount Total Earnings Group Union Ck. DASDI HL FIT SIT SUTA CIT Ins. Dues SIMPLE No. Amount DASDI HI FUTA SUTA Admin Office Sales Plant Checkpoints Total earnings: Net paid: 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10.00 0.00|| 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints Total eamings Net paid: 75 Russell, S. S NA 76 Ryan, J. MFJ NA 77 Sokowski, T. S NA 78 (Student) S NA 79 Woods, B. S NA BD 81 82 TOTALS 0.00 0.00 0.00 10.00 0.00 10.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 83 Fayday, December 14 20-For Period Ending December 12,20- 84 Russell, S. S NA 85 86 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTALS 87 Fayday December 16 20-For Period Ending December 12, 20- BB Bonno, A 89 Ferguson, J. MFJ NA MFJ NA 90 Ford, C. S NA 91 Mann, K MEJ NA 92 D'Neill, J 93 Ryan, J. MFJ NA MFJ NA 94 Sokowski, T. S NA 95 (Student) S NA 96 Woods, B. S NA 97 Young, P S NA 98 99 100 101 TOTALS 102 103 CTR 104 YEAR Checkpoints Total earnings Net paid: Checkpoints Total earnings: Net paid: Checkpoints-Annual Total earnings: Qtr's taxable OASDI earnings: Total earnings for FIT Total earnings for SITICIT Total earnings for FUTA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.528.77 157,753.34 962.79 225.18 740.00 476.76 4,843.05 9,780.71 2,287.45 16,657.00 10.90 110.47 588.55 5,978.87 0.00 16.00 0.00 930.40 160.00 0.00 12,508.59 15,528.77 15.528.77 3.890.00 4.850.00 117.005.39 157.753.34 157.753.34 69,380.00 88.340.00 2.307.69 4.723.08 3.600.00 4.898.00
Accounting Information Systems
11th Edition
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Chapter6: Relational Database And Sql
Section: Chapter Questions
Problem 1P: What SQL command(s) would you use to add the date on which an employee was hired to the EMPLOYEE...
Related questions
Question
The quarter begins on October 9 and ends December 18th, you are employed by Glo-Brite Paint Company. As the payroll clerk in the Accounting Department, you have been in charge of the payroll records since the company first began operations on January 5 of the current year. The company employs about 800 individuals; but for the purpose of this project, payroll records will be kept for only a dozen or so employees. By understanding the principles of payroll accounting for a few employees, you should be able to keep similar records for several hundred employees.
you will assume that the payroll records, tax reports, and deposits have been completed and filed for the first three quarters of this year. Your work will involve the processing of the payrolls for the last quarter of the year and the completion of the last quarterly and annual tax reports and forms.
Use the attached template to complete the payroll register.
- Prepare payroll registers.
- Maintain employees’ earnings records.
- Journalize and post payroll and payroll tax entries.
- Complete federal, state, and city tax deposit forms and journalize the transactions.
- Prepare various quarter-end and year-end payroll tax forms.
- Make the accrual entries for the payroll at the end of a year.
![A
BCDEFGHIJKLMNOPQRSTU
Y
2
AA
123
PAYROLL REGISTER
AB
AC
GLO-BRITE PAINT COMPANY
AD
AE
AF
AG
AH
Al
AJ
AK
AL
AM
AN
AD
AP
AO
AP
AS A
AU
AV
AW
A
NAME
MTWTF
5 Fayday, October 9 For Feriad Endin
6 Bonno, A.
7 Ferguson, J.
SSSSS
Filing Status
No. WH Allow.
Time Record
Regular Earnings Overtime Earnings
Deductions
Net Paid
Taxable Earnings
Labor Cost Distribution
Rate
Per
Rate
Per
Total
TFSHS Hour
Amount Hrs Hour Amount Earings
DASDI
HI
FIT
SIT SUTA
CIT
Group
Ins.
Union
Dues SIMPLE No.
Ck.
Amount
OASDI
HI
FUTA SUTA
Admin. Office Sales Plant
MFJ NA
SSSSS
80 17.60
1.408.00
1.408.00
MFJ NA
88
888
S S
S88
80
2,250.00
2,250.00
87.30 20.42
139.50 32.63
34.00
43.23 0.99
53 36
8.00
127.00
69.08
158
85.28
8 Ford, C.
S NA
8 8 88 8
88 SSS
80
1,220.00
1,220.00
75.64 17.69
75.00
37.45
0.85
16.21
674
9 Mann, K.
MFJ NA
88 88 8
S S
888
80
1.350.00
1.350.00
83.70 19.58
28.00
4145
0.95
5117
672 1,160.70 1,408.00 1,408.00
673 1,794.93 2,250.00 2,250.00
967.13 1,220.00 1,220.00
675 1,125,15 1,350.00 1,350.00 1,350.00 1.350.00
1408.00
2,250.00
Checkpoints
Total earnings:
Net paid:
15.528.77:
12,508.59;
700.00 1,220.00
1,220.00
1,350.00
10 O'Neill, J.
MFJ NA
8 8 8 S 8
S S
S18 S
SO
2.307.69
2,307.69
143.08 33.46
13100
70.85
1.62
97.46
676
1,840.22 2,307.69 2,307.69
2,307.69
11 Russell, S.
S NA
8 8
SSS
8 S S 88
80
1.200.00
1.200.00
74.40 17.40
73.00
36.84
0.84
15.40
677
952.04 1,200.00 1,200.00 760.00 1,200.00
1.200.00
12 Ryan, J
MFJ NA
88
SSSSS
80 18.00
1440.00
1440.00
89.28 20.88
38.00
44.21
101
54.58
8.00
678
1,184.04 1,440.00 1,440,00
13 Sokowski, T
MFJ NA
8 8
88
8 S SSS
80
2.050.00
2.050.00
127.10 29.73
101.00
62.94
1.44
77.70
679
1,650.09 2,050.00 2,050.00
14 (Student)
5
NA
8 8
88
88 88
72 15.00
1080.00
1080.00
15 Williams, R.
S
NA
88
D88
88 SSS
80
1223 08
1.223.08
66.96 15.66
75.83 17.73
58.00
33.16 0.76
10 93
680
75.00
37.55 0.86
46.35
681
864.53 1,080.00 1,080.00 1,080.00 1,080.00
969.76 1,223.08 1,223.08
1,440.00
2,050.00
1,080.00
1,223.08
16
17
18
19
15.5287
15.528.77 962.79 225.18 740.00 476.76 10/90 598.55
TOTALS
20 Fayday, October 28, 29- For Faniad Endin
21 Bonno, A.
22 Ferguson, J.
23 Ford, C.
MFJ NA
MFJ NA
5 NA
24 Mann, K
25 O'Neill, J.
26 Russell, S.
27 Ryan, J
28 Sokowski, T.
29 Student]
MFJ NA
MFJ NA
S NA
MFJ NA
MFJ NA
S NA
30 Williams, R
5
NA
31
32
33
34
TOTALS
0.00 16.00
0,00
12,508,59
15.528.77
15.528.77 3,890.00 4,850.00
2,307.69 4,723.08 3,600.00 4,898.00
Checkpoints
Total earnings
Net paid:
0.00
0.00
0.00
000
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
35 Fayday, November
36 Bonno, A
20-For Period Ending October
MFJ NA
37 Ferguson, J.
MFJ NA
38 Ford, C.
39 Mann, K
40 O'Neill, J.
41 Russell, S.
42 Ryan, J.
43 Sokowski, T.
MFJ NA
S NA
MFJ NA
S NA
MFJ NA
S NA
44 (Student)
S NA
45 Williams, R.
S
NA
46
47
4B
49
TOTALS
50 Payday, November 13 20--For Feriad Ending November 4, 20-
51 Williams, R
52
53
TOTALS
S
NA
54 Fayday, November 20 20-For Period Ending November 14, 20-
55 Bonno, A
56 Ferguson J.
57 Ford, C.
En V
MFJ NA
MFJ NA
SNA
0.00
0.00
0.00
10.00
000
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
000
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Checkpoints
Total earnings:
Net paid:
Checkpoints
Total earnings:
Net paid:
Checkpoints
Total earnings
Net paid:](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0638e03a-dbef-4ea2-93f1-b146fd847d14%2F25c33405-5568-4fc7-97f5-351108c43dc5%2Fnst15gh_processed.jpeg&w=3840&q=75)
Transcribed Image Text:A
BCDEFGHIJKLMNOPQRSTU
Y
2
AA
123
PAYROLL REGISTER
AB
AC
GLO-BRITE PAINT COMPANY
AD
AE
AF
AG
AH
Al
AJ
AK
AL
AM
AN
AD
AP
AO
AP
AS A
AU
AV
AW
A
NAME
MTWTF
5 Fayday, October 9 For Feriad Endin
6 Bonno, A.
7 Ferguson, J.
SSSSS
Filing Status
No. WH Allow.
Time Record
Regular Earnings Overtime Earnings
Deductions
Net Paid
Taxable Earnings
Labor Cost Distribution
Rate
Per
Rate
Per
Total
TFSHS Hour
Amount Hrs Hour Amount Earings
DASDI
HI
FIT
SIT SUTA
CIT
Group
Ins.
Union
Dues SIMPLE No.
Ck.
Amount
OASDI
HI
FUTA SUTA
Admin. Office Sales Plant
MFJ NA
SSSSS
80 17.60
1.408.00
1.408.00
MFJ NA
88
888
S S
S88
80
2,250.00
2,250.00
87.30 20.42
139.50 32.63
34.00
43.23 0.99
53 36
8.00
127.00
69.08
158
85.28
8 Ford, C.
S NA
8 8 88 8
88 SSS
80
1,220.00
1,220.00
75.64 17.69
75.00
37.45
0.85
16.21
674
9 Mann, K.
MFJ NA
88 88 8
S S
888
80
1.350.00
1.350.00
83.70 19.58
28.00
4145
0.95
5117
672 1,160.70 1,408.00 1,408.00
673 1,794.93 2,250.00 2,250.00
967.13 1,220.00 1,220.00
675 1,125,15 1,350.00 1,350.00 1,350.00 1.350.00
1408.00
2,250.00
Checkpoints
Total earnings:
Net paid:
15.528.77:
12,508.59;
700.00 1,220.00
1,220.00
1,350.00
10 O'Neill, J.
MFJ NA
8 8 8 S 8
S S
S18 S
SO
2.307.69
2,307.69
143.08 33.46
13100
70.85
1.62
97.46
676
1,840.22 2,307.69 2,307.69
2,307.69
11 Russell, S.
S NA
8 8
SSS
8 S S 88
80
1.200.00
1.200.00
74.40 17.40
73.00
36.84
0.84
15.40
677
952.04 1,200.00 1,200.00 760.00 1,200.00
1.200.00
12 Ryan, J
MFJ NA
88
SSSSS
80 18.00
1440.00
1440.00
89.28 20.88
38.00
44.21
101
54.58
8.00
678
1,184.04 1,440.00 1,440,00
13 Sokowski, T
MFJ NA
8 8
88
8 S SSS
80
2.050.00
2.050.00
127.10 29.73
101.00
62.94
1.44
77.70
679
1,650.09 2,050.00 2,050.00
14 (Student)
5
NA
8 8
88
88 88
72 15.00
1080.00
1080.00
15 Williams, R.
S
NA
88
D88
88 SSS
80
1223 08
1.223.08
66.96 15.66
75.83 17.73
58.00
33.16 0.76
10 93
680
75.00
37.55 0.86
46.35
681
864.53 1,080.00 1,080.00 1,080.00 1,080.00
969.76 1,223.08 1,223.08
1,440.00
2,050.00
1,080.00
1,223.08
16
17
18
19
15.5287
15.528.77 962.79 225.18 740.00 476.76 10/90 598.55
TOTALS
20 Fayday, October 28, 29- For Faniad Endin
21 Bonno, A.
22 Ferguson, J.
23 Ford, C.
MFJ NA
MFJ NA
5 NA
24 Mann, K
25 O'Neill, J.
26 Russell, S.
27 Ryan, J
28 Sokowski, T.
29 Student]
MFJ NA
MFJ NA
S NA
MFJ NA
MFJ NA
S NA
30 Williams, R
5
NA
31
32
33
34
TOTALS
0.00 16.00
0,00
12,508,59
15.528.77
15.528.77 3,890.00 4,850.00
2,307.69 4,723.08 3,600.00 4,898.00
Checkpoints
Total earnings
Net paid:
0.00
0.00
0.00
000
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
35 Fayday, November
36 Bonno, A
20-For Period Ending October
MFJ NA
37 Ferguson, J.
MFJ NA
38 Ford, C.
39 Mann, K
40 O'Neill, J.
41 Russell, S.
42 Ryan, J.
43 Sokowski, T.
MFJ NA
S NA
MFJ NA
S NA
MFJ NA
S NA
44 (Student)
S NA
45 Williams, R.
S
NA
46
47
4B
49
TOTALS
50 Payday, November 13 20--For Feriad Ending November 4, 20-
51 Williams, R
52
53
TOTALS
S
NA
54 Fayday, November 20 20-For Period Ending November 14, 20-
55 Bonno, A
56 Ferguson J.
57 Ford, C.
En V
MFJ NA
MFJ NA
SNA
0.00
0.00
0.00
10.00
000
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
000
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Checkpoints
Total earnings:
Net paid:
Checkpoints
Total earnings:
Net paid:
Checkpoints
Total earnings
Net paid:
![123
A
BCDEFGHIJKLMNOPQRSTU
PAYROLL REGISTER
Time Record
Regular Earnings Overtime Earings
Filing Status
No. W/H Allow.
4
NAME
54 Fayday, November 20 20-For Fe
55 Bonno, A.
56 Ferguson, J.
57 Ford, C.
58 Mann, K
59 O'Neill, J.
60 Russell, S.
61 Ryan, J.
62 Sokowski, T.
MFJ NA
MFJ NA
S NA
MFJ NA
MFJ NA
S NA
MFJ NA
5 NA
SM
63 [Student]
64
65
66
67
68
S NA
T
27 A
TI
TOTALS
69 Fayday, December 4 30-For Period Ending November
70 Bonno, A.
71 Ferguson, J.
72 Ford, C
73 Mann, K
74 O'Neill, J.
MFJ NA
MFJ NA
S NA
MFJ NA
MFJ NA
AB
AC
GLO-BRITE PAINT COMPANY
AD
AE
AF
AG
AH
Al
AJ
AK
AL
AM
AN
AP
AD
AP
AS A
AU
AV
AM
Deductions
Net Paid
Taxable Earnings
Labor Cost Distribution
Rate
Per
Rate
Per
MTW
Hrs Hour Amount His Hour Amount
Total
Earnings
Group Union
Ck.
DASDI
HL
FIT
SIT SUTA CIT
Ins.
Dues SIMPLE No. Amount
DASDI
HI
FUTA SUTA Admin
Office Sales Plant
Checkpoints
Total earnings:
Net paid:
0.00
0.00
0.00
0.00
0.00
0.00
0.00 10.00
0.00||
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Checkpoints
Total eamings
Net paid:
75 Russell, S.
S NA
76 Ryan, J.
MFJ NA
77 Sokowski, T.
S
NA
78 (Student)
S
NA
79 Woods, B.
S
NA
BD
81
82
TOTALS
0.00
0.00
0.00
10.00
0.00
10.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
83 Fayday, December 14 20-For Period Ending December 12,20-
84 Russell, S.
S NA
85
86
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTALS
87 Fayday December 16 20-For Period Ending December 12, 20-
BB Bonno, A
89 Ferguson, J.
MFJ NA
MFJ NA
90 Ford, C.
S NA
91 Mann, K
MEJ NA
92 D'Neill, J
93 Ryan, J.
MFJ NA
MFJ NA
94 Sokowski, T.
S NA
95 (Student)
S NA
96 Woods, B.
S
NA
97 Young, P
S
NA
98
99
100
101
TOTALS
102
103 CTR
104 YEAR
Checkpoints
Total earnings
Net paid:
Checkpoints
Total earnings:
Net paid:
Checkpoints-Annual
Total earnings:
Qtr's taxable OASDI earnings:
Total earnings for FIT
Total earnings for SITICIT
Total earnings for FUTA
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
15.528.77
157,753.34
962.79 225.18 740.00 476.76
4,843.05
9,780.71 2,287.45 16,657.00
10.90
110.47
588.55
5,978.87
0.00
16.00
0.00
930.40
160.00
0.00
12,508.59 15,528.77 15.528.77 3.890.00 4.850.00
117.005.39 157.753.34 157.753.34 69,380.00 88.340.00
2.307.69 4.723.08 3.600.00 4.898.00](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0638e03a-dbef-4ea2-93f1-b146fd847d14%2F25c33405-5568-4fc7-97f5-351108c43dc5%2Fyiieyc_processed.jpeg&w=3840&q=75)
Transcribed Image Text:123
A
BCDEFGHIJKLMNOPQRSTU
PAYROLL REGISTER
Time Record
Regular Earnings Overtime Earings
Filing Status
No. W/H Allow.
4
NAME
54 Fayday, November 20 20-For Fe
55 Bonno, A.
56 Ferguson, J.
57 Ford, C.
58 Mann, K
59 O'Neill, J.
60 Russell, S.
61 Ryan, J.
62 Sokowski, T.
MFJ NA
MFJ NA
S NA
MFJ NA
MFJ NA
S NA
MFJ NA
5 NA
SM
63 [Student]
64
65
66
67
68
S NA
T
27 A
TI
TOTALS
69 Fayday, December 4 30-For Period Ending November
70 Bonno, A.
71 Ferguson, J.
72 Ford, C
73 Mann, K
74 O'Neill, J.
MFJ NA
MFJ NA
S NA
MFJ NA
MFJ NA
AB
AC
GLO-BRITE PAINT COMPANY
AD
AE
AF
AG
AH
Al
AJ
AK
AL
AM
AN
AP
AD
AP
AS A
AU
AV
AM
Deductions
Net Paid
Taxable Earnings
Labor Cost Distribution
Rate
Per
Rate
Per
MTW
Hrs Hour Amount His Hour Amount
Total
Earnings
Group Union
Ck.
DASDI
HL
FIT
SIT SUTA CIT
Ins.
Dues SIMPLE No. Amount
DASDI
HI
FUTA SUTA Admin
Office Sales Plant
Checkpoints
Total earnings:
Net paid:
0.00
0.00
0.00
0.00
0.00
0.00
0.00 10.00
0.00||
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Checkpoints
Total eamings
Net paid:
75 Russell, S.
S NA
76 Ryan, J.
MFJ NA
77 Sokowski, T.
S
NA
78 (Student)
S
NA
79 Woods, B.
S
NA
BD
81
82
TOTALS
0.00
0.00
0.00
10.00
0.00
10.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
83 Fayday, December 14 20-For Period Ending December 12,20-
84 Russell, S.
S NA
85
86
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTALS
87 Fayday December 16 20-For Period Ending December 12, 20-
BB Bonno, A
89 Ferguson, J.
MFJ NA
MFJ NA
90 Ford, C.
S NA
91 Mann, K
MEJ NA
92 D'Neill, J
93 Ryan, J.
MFJ NA
MFJ NA
94 Sokowski, T.
S NA
95 (Student)
S NA
96 Woods, B.
S
NA
97 Young, P
S
NA
98
99
100
101
TOTALS
102
103 CTR
104 YEAR
Checkpoints
Total earnings
Net paid:
Checkpoints
Total earnings:
Net paid:
Checkpoints-Annual
Total earnings:
Qtr's taxable OASDI earnings:
Total earnings for FIT
Total earnings for SITICIT
Total earnings for FUTA
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
15.528.77
157,753.34
962.79 225.18 740.00 476.76
4,843.05
9,780.71 2,287.45 16,657.00
10.90
110.47
588.55
5,978.87
0.00
16.00
0.00
930.40
160.00
0.00
12,508.59 15,528.77 15.528.77 3.890.00 4.850.00
117.005.39 157.753.34 157.753.34 69,380.00 88.340.00
2.307.69 4.723.08 3.600.00 4.898.00
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Accounting Information Systems
Finance
ISBN:
9781337552127
Author:
Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Accounting Information Systems
Finance
ISBN:
9781337552127
Author:
Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
