AutoSave On Payroll Register_202... • Saved V Search File Home Insert Page Layout Formulas Data Review View Help ☐ Comments ✓ Share Arial ✓ 10 General Conditional Formatting ✓ Insert M > B I ✓ Α Α %9 Format as Table Delete Paste ←0 .00 ✓ ✓ .00 0 Cell Styles ☑ Font Alignment ☑ Number N Styles Format Cells Add-ins Analyze Data Editing Add-ins Clipboard AE38 A B 11 12 FOR PERIOD ENDING fx C D F F G H | J K L M N ○ P Q R S T U V W PAYROLL REGISTER X Y Z AA AE AC AD AE AF AG AH AI AJ AK AL AM AN AC AP AG AR AS AT BM January 8, 20- 13 14 REGULAR EARNINGS OVERTIME EARNINGS DEDUCTIONS NET PAY TAXABLE EARNINGS 15 16 17 EMPLOYEE OW. WORKE TOTAL FICA RATE PER RATE PER HOUR AMOUNT HOUR AMOUNT EARNINGS OASDI HI FIT SIT 18 11 Carson, Fran M. S 40 $17.50 700.00 $26.25 700.00 43.40 10.15 SUTA 25.82 CIT SIMPLE 20.00 GROUP HEALTH CHECK INSURANCE INSURANCE NO. 313 AMOUNT OASDI HI FUTA SUTA 700.00 700.00 700.00 700.00 19 12 Wilson, William A. S 40 $17.25 690.00 8 $25.88 207.04 897.04 55.62 13.01 50.00 314 897.04 897.04 897.04 897.04 20 13 Utley, Harry T. MFJ 37 1/2 $18.10 678.75 $27.15 678.75 42.08 9.84 40.00 315 678.75 678.75 678.75 678.75 21 21 Fife, Lawrence R. MFJ 40 $17.90 716.00 6 $26.85 161.10 877.10 54.38 12.72 50.00 316 877.10 877.10 877.10 877.10 22 22 Smith, Lucy K. S 40 $19.75 790.00 $29.63 790.00 48.98 11.46 20.00 317 790.00 790.00 790.00 790.00 23 31 Fay, Gretchen R. MFJ 41 1/4 515.00 1.25 $19.32 24.15 539.15 33.43 7.82 40.00 318 539.15 539.15 539.15 539.15 24 32 Robey, Glenda B. MFJ 40 623.08 $23.37 623.08 38.63 9.03 50.00 319 623.08 623.08 623.08 623.08 25 33 Schork, Thomas K. S 40 773.08 $29.00 773.08 47.93 11.21 60.00 320 773.08 773.08 773.08 773.08 26 51 Hardy, Barbara T. MFJ 44 579.23 4 $21.72 86.88 666.11 41.30 9.66 30.00 321 666.11 666.11 666.11 666.11 27 99 Kipley, Carson C. MFJ 40 1,000.00 $37.50 28 Totals 7,065.14 479.17 1.000.00 7,544.31 62.00 14.50 80.00 322 1,000.00 1,000.00 1,000.00 1,000.00 467.75 109.40 440.00 7,544.31 7.544.31 7,544.31 7,544.31 29 30 31 JOURNAL 32 33 DATE DESCRIPTION DEBIT CREDIT 34 20- 35 Jan. 12 Wages and Salaries 7,544.31 Net FUTA Taxable Earnings 7,544.31 Net Rate FUTA Tax 36 37 FICA Taxes Payable - OASDI FICA Taxes Payable - HI 467.75 109.40 SUTA 7,544.31 0.036890 SUTA Tax 278.31 38 Employees FIT Payable ☐ 39 Employees SIT Payable 40 41 42 Employees SUTA Payable Employees CIT Payable SIMPLE Deductions Payable 440.00 43 44 45 46 47 12 48 49 50 51 52 53 14 54 Group Insurance Premiums Collected Health Insurance Premiums Collected Salaries Payable Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable Salaries Payable Cash 55 66 Excel Instructions Accessibility: Investigate Continuing Problem-A Ready EO Type here to search + - W (8) 4) 12:45 PM 10/23/2024 + 50%
1. In the appropriate columns of your payroll register, record the filing status for each
employee using the information provided.
2. Record the payroll deductions for the SIMPLE plan that the employer has established for
participating employees. All of the employees are participating, and their weekly
contributions are listed below. The tax deferral on these deductions applies only to the
federal income tax.
3. Record the amount of federal income taxes using the wage-bracket method and standard
withholding.
4. Record the state income taxes on the gross weekly earnings for each employee. The rate
is 3.07% for the state of Pennsylvania.
5. Record the city income taxes on the gross weekly earnings of each employee. The rate is
3% for the city of Pittsburgh residents.
Time Card
No.
Filing
Status
No. of Withholding
Allowances
SIMPLE
Deductions
11 S N/A $20
12 S N/A 50
13 MFJ N/A 40
21 MFJ N/A 50
22 S N/A 20
31 MFJ N/A 40
32 MFJ N/A 50
33 S N/A 60
51 MFJ N/A 30
99 MFJ N/A 80
I need your help with the values that should be entered in all the blank boxes in the deductions plus the formulas that were applied.
Thank you.
the SUTA deduction column—employees pay 0.06% on total gross pay. You will now compute the
employer’s liability for unemployment taxes (FUTA and SUTA) for the pay of January 14. These
computations will be used at the end of Chapter 6 in recording the payroll tax entries.
To compute the employer’s liability for unemployment taxes, proceed as follows:
1. Enter each employee’s gross earnings in the Taxable Earnings—FUTA and SUTA
columns.
2. Total the Taxable Earnings—FUTA and SUTA columns.
3. At the bottom of your payroll register, compute the following:
1. Net FUTA tax. Since this is the first pay period of the year, none of the
employees are near the $7,000 ceiling; therefore, each employee’s gross
earnings is subject to the FUTA tax.
2. SUTA tax. Since Kipley Company is a new employer, Pennsylvania has assigned
the company a contribution rate of 3.689% on the first $10,000 of each
employee’s earnings. Employees pay 0.06% on total gross pay.
Note: Retain your partially completed payroll register for use at the end of Chapter 6.
Step by step
Solved in 2 steps with 2 images