Deposit Rules for Glo-Brite Paint Company The FICA taxes and FIT taxes must be deposited on or before the 15th of the month following the month in w Federal taxes were withheld. Since Glo-Brite is a new employer and has no tax liabilities during the lookback period, company is subject to the monthly deposit rule. Since the state income taxes withheld total $1,000 or more each quarter, the company must remit the withh Pennsylvania semimonthly. The taxes must be remitted within three banking days after the semimonthly periods ending o and the last day of the month. Since the city income taxes withheld are more than $350 but less than $16,000 each month, the company is Philadelphia the monthly rule. The city income taxes withheld during the month must be remitted by the 15th day of the month. Deposit Rules October 9, 20-- Net Paid $12,291.11 No. 1 The first payroll in October covered the two workweeks that ended on September 26 and October 3. This payroll transaction has been entered for you in the payroll register, the employees' earnings records, the general journal, and the general ledger. By reviewing the calculations of the wages and deductions in the payroll register and the posting of the information to the employees' earnings records, you can see the procedure to be followed each payday. Wages and salaries are paid by issuing special payroll checks. When the bank on which they are drawn receives such checks, they will be charged against the payroll cash account. Observe the following rules in computing earnings each pay period: 1. Do not make any deduction from an employee's earnings if the employee loses less than 15 minutes of time in any day. Time lost that exceeds 15 minutes is rounded to the nearest quarter-hour and deducted. If the time lost by an employee is not to be deducted, the time clerk will make a notation to that effect on the Time Clerk's Report. 2. In completing the time record columns of the payroll register for all workers, you should place an 8 in the day column for each full day worked (refer to page PR-2 at the end of the book). If an employee works less than a full day, show the actual hours for which the employee will be paid. 3. In the case of an employee who begins work during a pay period, compute the earnings by paying the employees their weekly rate for any full week worked. For any partial week, compute the earnings for that week by multiplying the hours worked by the hourly rate of pay. 4. If time lost is to be deducted from a salaried employee's pay, the employee's pay must be determined by multiplying the actual hours worked for that week by the hourly rate. If hours are missed but no pay is deducted, include those hours in the Time Record columns on the payroll register. The following schedule shows the weekly and hourly wage rates of the salaried employees: Employee Ferguson, James C. Ford, Catherine L. Mann, Dewey W. O'Neill, Joseph T. Russell, Virginia A. Sokowski, Thomas J. Williams, Ruth V. Weekly Rate $1,125.00 610.00 675.00 1,153.85 600.00 1,025.00 611.54 Hourly Rate $28.13 15.25 16.88 28.85 15.00 25.63 15.29 5. Plant workers (Bonno and Ryan), other than supervisors, are employed on an hourly basis. Compute the wages by multiplying the number of hours worked during the pay period by the employee's hourly rate. 6. The information needed and the sequence of steps that are completed for the payroll are presented in the following discussion. The time clerk prepared Time Clerk's Report Nos. 38 and 39 from the time cards used by the employees for these workweeks. In as much as the president, sales manager, sales representatives, and supervisors do not ring in and out on the time clock, their records are not included in the time clerks report, but their salaries must be included in the payroll. 1 The following schedule shows the hourly wage rates of the three hourly employees used in preparing the payroll register for the payday on October 9. Employee Bonno, Anthony V. Ryan, Norman A. Student Pay Points Hourly Rate $17.60 18.00 14.00 Tax calculations are to be taken to three decimal places and then rounded to two places. 2 The entry required for each employee is recorded in the payroll register. The names of all employees are listed in alphabetical order, including yours as \"Student.\" The fold-out payroll register forms needed to complete this project are bound at the back of the book (pages PR-2, PR-3, and PR-4). No deduction has been made for the time lost by Williams. Thus, the total number of hours (80) for which payment was made is recorded in the Regular Earnings Hours column of the payroll register. However, a notation of the time lost (D) was made in the Time Record column. When posting to Williams's earnings record, 80 hours is recorded in the Regular Earnings Hours column (no deduction for the time lost). Pay Points-Use tax tables for biweekly payroll period. In computing the federal income taxes to be withheld, the wage-bracket tables in Tax Table B at the back of the book were used (pages T-5 to T-14). Each payday, $8 was deducted from the earnings of the two plant workers for union dues (Bonno and Ryan). Payroll check numbers were assigned beginning with check no. 672. In the Labor Cost Distribution columns at the extreme right of the payroll register, each employee's gross earnings were recorded in the column that identifies the department in which the employee regularly works. The totals of the Labor Cost Distribution columns provide the amounts to be charged to the appropriate salary and wage expense accounts and aid department managers and supervisors in comparing the actual labor costs with the budgeted amounts. Once the net pay of each employee was computed, all the amount columns in the payroll register were footed, proved, and ruled. 3 An entry was made in the journal transferring from the regular cash account to the payroll cash account the amount of the check issued to Payroll to cover the net amount of the payroll; next, the entry was posted. 4 Information from the payroll register was posted to the employees' earnings records (see Employees' Earnings Records). Note that when posting the deductions for each employee, a column has been provided in the earnings record for recording each deduction for FICA (OASDI and HI), FIT, SIT, SUTA, and CIT. All other deductions for each employee are to be totaled and recorded as one amount in the Other Deductions column. Subsidiary ledgers are maintained for Group Insurance Premiums Collected and Union Dues Withheld. Thus, any question about the amounts withheld from an employee's earnings may be answered by referring to the appropriate subsidiary ledger. In this project, your work will not involve any recording in or reference to the subsidiary ledgers. 5 The proper journal entry recorded salaries, wages, taxes, and the net amount of cash paid from the totals of the payroll register. The journal entry to record the payroll for the first pay in the fourth quarter appears below and in the general journal. Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes PayableOASDI FICA Taxes PayableHI Employees FIT Payable Employees SIT Payable Employees SUTA Payable 2,307.69 4,651.08 3,600.00 4,898.00 958.33 224.14 882.00 474.55 9.25 Employees CIT Payable Union Dues Payable Payroll Cash 601.39 16.00 12,291.11 The amounts charged the salary and wage expense accounts were obtained from the totals of the Labor Cost Distribution columns in the payroll register. The salaries and wages were charged as follows: FICA Taxes PayableOASDI and FICA Taxes PayableHI were credited for $958.33 and $224.14, respectively, the amounts deducted from employees' wages. Employees FIT Payable, Employees SIT Payable, Employees SUTA Payable, Employees CIT Payable, and Union Dues Payable were credited for the total amount withheld for each kind of deduction from employees' wages. In subsequent payroll transactions, Group Insurance Premiums Collected will be credited for the amounts withheld from employees' wages for this type of deduction. Finally, Payroll Cash was credited for the sum of the net amounts paid all employees. 6 The payroll taxes for this pay were then recorded in the general journal as follows: Payroll Taxes FICA Taxes PayableOASDI FICA Taxes PayableHI FUTA Taxes Payable SUTA Taxes PayableEmployer 1,381.61 958.32 224.12 22.91 176.26 Payroll Taxes was debited for the sum of the employer's FICA, FUTA, and SUTA taxes. The taxable earnings used in computing each of these payroll taxes were obtained from the appropriate column totals of the payroll register. Note that only part of Ford's wages are taxable ($700 out of $1,220 gross pay) for FUTA ($7,000 limit). The computation of the debit to Payroll Taxes was: FICA Taxes PayableOASDI was credited for $958.32, the amount of the liability for the employer's portion of the tax. FICA Taxes PayableHI was credited for $224.12, the amount of the liability for the employer's share of this tax. FUTA Taxes Payable was credited for the amount of the tax on the employer for federal unemployment purposes ($22.91). SUTA Taxes PayableEmployer was credited for $176.26, which is the amount of the contribution required of the employer under the state unemployment compensation law. 7 The journal entries were posted to the proper ledger accounts. October 15 This is the day on which the deposits of FICA and FIT taxes and the city of Philadelphia income taxes for the September payrolls are due. However, in order to concentrate on the fourth-quarter payrolls, we will assume that the deposits for the third quarter and the appropriate entries were already completed. October 20 No. 2 On this date, Glo-Brite Paint Company must deposit the Pennsylvania state income taxes withheld from the October 9 payroll. The deposit rule states that if the employer expects the aggregate amount withheld each quarter to be $1,000 or more, the employer must pay the withheld tax semimonthly. The tax must be remitted within three banking days after the close of the semimonthly periods ending on the 15th and the last day of the month. 1 Prepare the journal entry to record the deposit of the taxes, and post to the appropriate ledger accounts. 2 Pennsylvania has eliminated the filing of paper forms (replaced by telefile or online filing). The information needed to telefile is listed in Employee's Earnings Record complete the information worksheet needed for the first semimonthly period of October. The company's Pennsylvania employer account number is 000-0-3300, its EIN is 000000660, its filing password is GBPCOM, and its telephone number is (215) 555-9559. October 23 No. 3 Prepare the payroll for the last pay period of October from Time Clerk's Report Nos. 40 and 41. The proper procedure in recording the payroll follows: 1 Complete the payroll register. Net Paid $12,352.34 In as much as only a portion of the payroll register sheet was used in recording the October 9 payroll, the October 23 payroll should be recorded on the same sheet to save space. On the first blank ruled line after the October 9 payroll, insert \"Payday October 23 For Period Ending October 17, 20--.\" On the following lines, record the payroll information for the last pay date of October. When recording succeeding payrolls, continue to conserve space by recording two payrolls on each separate payroll register sheet. Pay Points- Even though they are not on the time clerk's report, remember to pay the president, sales manager, sales representatives, and supervisors. The workers in the plant (Bonno and Ryan) are paid time and a half for any hours worked over eight each workday and for work on Saturdays and are paid twice the regular hourly rate for work on Sundays or holidays. With this pay period, the cumulative earnings of several employees exceed the taxable income base set up by FUTA and SUTA. This factor must be considered in preparing the payroll register and in computing the employer's payroll taxes. Refer to each employee's earnings record to see the amount of cumulative earnings. 2 Make the entry transferring from Cash to Payroll Cash the net amount of the total payroll, and post. 3 Post the required information from the payroll register to each employee's earnings record. 4 Record in the journal the salaries, wages, taxes withheld, group insurance premiums collected, union dues withheld, and net amount paid, and post to the proper ledger accounts. Pay Points-The employees' Pennsylvania State Unemployment Tax (SUTA) is calculated (0.0006) on the total wages of each employee. There is no taxable wage limit on the employees' portion of the tax. The entry required to record the October 23 payroll is the same as that to record the October 9 payroll, except it is necessary to record the liability for the amount withheld from the employees' wages to pay their part of the group insurance premium. The amount withheld should be recorded as a credit to Group Insurance Premiums Collected. 5 Record in the journal the employer's payroll taxes and the liabilities created; post to the appropriate ledger accounts. November 4 Pay Points-Be sure to deduct 30 premium for each $1,000 of group insurance carried by each employee (last payday of each month). No. 4 Deposit with the state of Pennsylvania the amount of state income taxes withheld from the October 23 payroll and complete information worksheet. No. 5 Virginia Russell completed a new Form W-4, changing the number of withholding allowances to 2. Change Russell's earnings record (her marital status has not changed). No. 6 Thomas J. Sokowski completed a new Form W-4, showing that his marital status changed to single and that the number of withholding allowances remains at 2. Change Sokowski's earnings record accordingly. No. 7 Dewey Mann completed a new Form W-4, leaving his marital status as married but dropping the number of withholding allowances to 0. Change Mann's earnings record accordingly. November 6 Net Paid $12,157.52 No. 8 Pay the treasurer of the union the amount of union dues withheld during the month of October. Pay Points-Make changes in November 6 pay. Refer to Nos. 5, 6, and 7. No. 9 Prepare the payroll for the first pay period in November from Time Clerk's Report Nos. 42 and 43 and record the paychecks issued to all employees. Record this payroll at the top of the second payroll register sheet. Note: Virginia Russell worked only 38 hours in the week ending October 24. Therefore, compute her pay for that week by multiplying 38 by $15.00 (her hourly rate). Ruth Williams worked only 39 hours in the week ending October 24. Therefore, compute her pay for that week by multiplying 39 by $15.29 (her hourly rate). Also, record the employer's payroll taxes. November 13 Net Paid $ 1,491.86 No. 10 Because of her excessive tardiness and absenteeism during the year, the company discharged Ruth Williams today. For the week ending November 7, she was late a total of six hours; and for this week, she missed two full days and was late two hours on another day. In lieu of two weeks' notice, Williams was given two full weeks' pay ($1,223.08). Along with her dismissal pay ($1,223.08), she was paid for the week ending November 7 (34 hours, or $519.86) and the days worked this current week (22 hours, or $336.38). The total pay for the two partial weeks is $856.24. 1 Record a separate payroll register (on one line) to show Williams's total earnings, deductions, and net pay. The two weeks' dismissal pay is subject to all payroll taxes. Include dismissal pay with the total earnings but do not show the hours in the Time Record columns. Use the tax table for the biweekly payroll period for the total gross pay ($2,079.32) of Williams. Pay Points-Prepare a Wage and Tax Statement, Form W-2, to be given to Williams. The deduction for group insurance premiums is $14.40. In the Time Record column, make a note of Williams's discharge as of this date. Indicate the payroll check number used to prepare the final check for Williams. When posting to the earnings record, make a notation of Williams's discharge on this date. 2 Prepare the journal entries to transfer the net cash and to record Williams's final pay and the employer's payroll taxes. Post to the ledger accounts. 3 Use the blank Form W-2. Box \"a\" should be left blank, since Glo-Brite Paint Company does not use a control number to identify individual Forms W-2. November 16 No. 11 Electronically deposit the amount of FICA taxes and federal income taxes for the October payrolls and complete the Federal Deposit Information Worksheet. Since the company is subject to the monthly deposit rule, the deposit is due on the 15th of the following month. See the deposit requirements explained in Deposit Requirements (Nonagricultural Workers). November 15 is a Sunday; therefore, the deposit is to be made on the next business day. Prepare the journal entry to record the deposit of the taxes, and post to the appropriate ledger accounts. Pay Points-On all tax and deposit forms requiring a signature, use Joseph O'Neill's name. No. 12 Since Glo-Brite Paint Company withholds the city of Philadelphia income tax, you must deposit the taxes with the Department of Revenue. The deposit rule that affects Glo-Brite Paint Company states that if the withheld taxes are between $350 and $16,000 per month, the company must deposit the tax monthly by the 15th of the following month. The withheld taxes for the October payrolls were $1,215.29. 1 Prepare the journal entry to record the deposit of the taxes, and post to the appropriate ledger accounts. 2 Complete the Philadelphia Employer's Return of Tax Withheld coupon (Monthly Wage Tax). November 17 No. 13 Prepare an employee's earnings record for Beth Anne Woods, a new employee who began work today, Tuesday. Woods is single and claims one withholding allowance. She is employed as a programmer at a monthly salary of $2,600. Address, 8102 Franklin Court, Philadelphia, PA 19105-0915. Telephone, 555-1128. Social Security No. 000-00-1587. She is eligible for group insurance coverage of $47,000 immediately, although her first deduction for group insurance will not be made until December 18. Department: Office Weekly rate: $600.00 Hourly rate: $15.00 November 18 No. 14 Deposit with the state of Pennsylvania the amount of state income taxes withheld from the November 6 and 13 (Ruth Williams) payrolls and complete the information worksheet. November 20 Net Paid $9,407.78 No. 15 With this pay, the company has decided to offer employees a Savings Incentive Match Plan for Employees (SIMPLE Retirement Plan). Most of the employees opted to wait until the start of the following year to participate. However, the following employees have decided to take part in the plan for the remaining pay periods of the year. James Ferguson: Dewey Mann: Joseph O'Neill: Norman Ryan: $500 contribution per pay period $250 contribution per pay period $700 contribution per pay period $200 contribution per pay period The contributions are to be deducted from the participating employee's pay and are excluded from the employee's income for federal income tax purposes. The other payroll taxes still apply. On the payroll registers and the earnings record, use the blank column under \"Deductions\" for these contributions. Use the term \"SIMPLE\" as the new heading for this deduction column (on both the payroll register and employee's earnings record). Use the account in the general ledger for SIMPLE Contributions Payableaccount no. 29. The company must match these contributions dollar for dollar, up to 3 percent of the employee's compensation. These payments will be processed through the Accounts Payable Department. Pay Points Remember to deduct the premiums on the group insurance for each employee. Prepare the payroll for the last pay period of November from Time Clerk's Report Nos. 44 and 45, and record the paychecks issued all employees. Also, record the employer's payroll taxes. Pay Points-The new wage rates are effective for the December 4 payroll. No. 16 Salary increases of $30 per week, effective for the two weeks covered in the December 4 payroll, are given to Catherine L. Ford and Virginia A. Russell. The group insurance coverage for Ford will be increased to $50,000; for Russell, it will be increased to $49,000. Update the employees' earnings records accordingly. The new wage rates are listed below. Employee Ford, Catherine L. Russell, Virginia A. Weekly Rate $640.00 630.00 Hourly Rate $16.00 15.75 November 30 No. 17 Prepare an employee's earnings record for Paul Winston Young, the president's nephew, who began work today. Young is single and claims one withholding allowance. He is training as a field sales representative in the city where the home office is located. His beginning salary is $2,730 per month. Address, 7936 Holmes Drive, Philadelphia, PA 19107-6107. Telephone, 555-2096. Social Security No. 000-00-6057. Young is eligible for group insurance coverage of $49,000. Department: Sales Weekly rate: $630.00 Hourly rate: $15.75 December 3 No. 18 Deposit with the state of Pennsylvania the amount of state income taxes withheld from the November 20 payroll using General Ledger balance for Account No. 25 and complete the information worksheet. December 4 Net Paid $10,948.37 No. 19 Prepare the payroll for the first biweekly pay period of December from Time Clerk's Report Nos. 46 and 47, and record the paychecks issued all employees. Record this payroll at the top of the third payroll register sheet. Note: Thursday, November 26, is a paid holiday for all workers. Also, record the employer's payroll taxes. No. 20 Anthony V. Bonno reports the birth of a son and completes an amended Form W-4, showing his total withholding allowances to be five. Change his earnings record accordingly, effective with the December 18 pay. No. 21 Both Anthony Bonno and Norman Ryan have been notified that their union dues will increase to $9 per pay, starting with the last pay period of the year. Reflect these increases in the December 18 pay and show the changes on their earnings records. December 9 No. 22 Pay the treasurer of the union the amount of union dues withheld during the month of November. December 11 Pay Points-This final pay is not subject to withholding for FIT, SIT, or CIT purposes. No. 23 The Payroll Department was informed that Virginia A. Russell died in an automobile accident on her way home from work Thursday, December 10. December 14 Net Paid $2,194.72 No. 24 1 Make a separate entry (on one line) in the payroll register to record the issuance of a check payable to the Estate of Virginia A. Russell. This check covers Russell's work for the weeks ending December 5 and 12 ($1,134.00) plus her accrued vacation pay ($1,260.00). Do not show the vacation hours in the Time Record columns on the payroll register, but include them in the Total Earnings column. Russell's final biweekly pay for time worked and the vacation pay are subject to FICA, FUTA, and SUTA (employer and employee) taxes. Since Russell's cumulative earnings have surpassed the taxable earnings figures established by FUTA and SUTA, there will not be any unemployment tax on the employer. The deduction for group insurance premiums is $14.70. 2 Make a notation of Russell's death in the payroll register and on her earnings record. Pay Points-Prepare a Wage and Tax Statement, Form W-2, which will be given to the executor of the estate along with the final paycheck. 3 Prepare journal entries to transfer the net pay and to record Russell's final pay and the employer's payroll taxes. Post to the ledger accounts. 4 Include the final gross pay ($2,394.00) in Boxes 3 and 5, but not in Boxes 1, 16, and 18. Use the blank Form W-2. In addition, the last wage payment and vacation pay must be reported on Form 1099MISC. A Form 1096 must also be completed. These forms will be completed in February before their due date. (See Transaction Nos. 41 and 42.) December 15 No. 25 Electronically deposit the amount of FICA taxes and federal income taxes for the November payrolls and complete the Federal Deposit Information Worksheet. No. 26 Deposit with the city of Philadelphia the amount of city income taxes withheld from the November payrolls. December 18 Net Paid $47,650.34 No. 27 Deposit with the state of Pennsylvania the amount of state income taxes withheld from the December 4 payroll and complete the information worksheet. No. 28 Glo-Brite has been notified by the insurance company that there will be no premium charge for the month of December on the policy for Virginia Russell. Prepare the entry for the check made payable to the estate of Virginia A. Russell for the amount that was withheld for insurance from her December 14 pay. No. 29 Prepare an employee's earnings record for Richard Lloyd Zimmerman, who was employed today as time clerk to take the place left vacant by the death of Virginia A. Russell last week. His beginning salary is $2,600 per month. Address, 900 South Clark Street, Philadelphia, PA 19195-6247. Telephone, 555-2104. Social Security No. 000-001502. Zimmerman is married and claims one withholding allowance. Zimmerman is eligible for group insurance coverage of $47,000, although no deduction for group insurance premiums will be made until the last payday in January. Department: Office Weekly rate: $600.00 Hourly rate: $15.00 No. 30 Prepare the payroll for the latter pay of December from Time Clerk's Report Nos. 48 and 49 and record the paychecks issued all employees. Also, record the employer's payroll taxes. Effective with this pay, O'Neill completed a new Form W-4, changing his total withholding allowances to four. Previously, he had claimed fewer allowances than he had been using on his tax return. Change his earnings record accordingly. Pay Points-Remember to deduct the premiums on the group insurance for each employee. In this pay, the president of the company, Joseph O'Neill, is paid his annual bonus. This does not affect O'Neill's insurance coverage, which is based on regular pay. This year, his bonus is $75,000. For withholding purposes, the bonus is considered a supplemental payment and is added to his gross pay, and the aggregate amount is taxed. For this pay, O'Neill has increased his SIMPLE deduction to $4,000. To determine the federal income tax, use the Table of Allowance Values along with Tax Table A (pages T-2 to T4). In calculating the tax, do not round the aggregate to the nearest earnings dollar. In this pay, O'Neill has reached the OASDI ceiling. To calculate O'Neill's OASDI tax, multiply the OASDI ceiling of $128,400 by 6.2 percent and then subtract the year-todate OASDI taxes withheld up to this pay. (Use O'Neill's Employee Earnings Record to view his year-to-date OASDI tax withheld). Note: After posting the information for this last pay to the employees' earnings records, calculate and enter the quarterly and yearly totals on each earnings record Note: This completes the project insofar as recording the payroll transactions for the last quarter is concerned. The following additional transactions are given to illustrate different types of transactions arising in connection with the accounting for payrolls and payroll taxes. Record these transactions in the journal, but do not post to the ledger. January 6 No. 31 Deposit with the state of Pennsylvania the amount of state income taxes withheld from the December 18 payroll and complete the information worksheet. January 8 No. 32 Pay the treasurer of the union the amount of union dues withheld during the month of December. January 15 No. 33 Electronically deposit the amount of FICA taxes and federal income taxes for the December payrolls, and complete the Federal Deposit Information Worksheet. No. 34 Deposit with the city of Philadelphia the amount of city income taxes withheld from the December payrolls. February 1 No. 35 Prepare Form 941, Employer's Quarterly Federal Tax Return, with respect to wages paid during the last calendar quarter. Transaction No. 35 contain a blank Form 941. The information needed in preparing the return should be obtained from the ledger accounts, payroll registers, employees' earnings records, and Federal Tax Deposit forms. Form 941 and all forms that follow are to be signed by the president of the company, Joseph T. O'Neill. No. 361 Complete Form 940, Employer's Federal Unemployment (FUTA) Tax Return, using the blank forms reproduced. Also, complete the Federal Deposit Information Worksheet, using the blank form reproduced. 1. Total wages for the first three quarters was $142,224.57. FUTA taxable wages for the first three quarters was $65,490.00. 2. FUTA tax liability by quarter: 1st quarter$204.53 2nd quarter$105.25 3rd quarter$83.16 3. The first FUTA deposit is now due. 4. Journalize the entry to record the electronic deposit for the FUTA tax liability. No. 37 1 Prepare Form UC-2, Employer's Report for Unemployment CompensationFourth Quarter, using the blank form reproduced. In Pennsylvania, a credit week is any calendar week during the quarter in which the employee earned at least $50 (without regard to when paid). The maximum number of credit weeks in a quarter is 13. The telephone number of the company is (215) 555-9559. All other information needed in preparing the form can be obtained from the ledger accounts, the payroll registers, and the employees' earnings records. 2 Journalize the entry to record the payment of the taxes for the fourth quarter. No. 38 Complete Form W-2, Wage and Tax Statement, for each current employee, using the blank statements reproduced. Use each employee's earnings record to obtain the information needed to complete the forms. The two plant workers (Bonno and Ryan) have had $121.00 in union dues withheld during the year. In addition to union dues withheld, include the Pennsylvania State Unemployment Tax (SUTA) withheld in Box 14. No. 39 Complete Form W-3, Transmittal of Wage and Tax Statements, using the blank form reproduced. Use the information on all Forms W-2 to complete this form. No. 40 Complete Pennsylvania Form REV-1667, W-2 Transmittal, using the blank form reproduced. Use the information on Forms W-2 to complete this report. The wages paid and the Pennsylvania tax withheld for the first three quarters are: 1st $34,088.75 $1,046.52 2nd $45,535.62 $1,397.94 3rd $62,600.20 $1,921.83 No. 41 Complete Form 1099-MISC, Miscellaneous Income, for the payment to the estate of Virginia A. Russell. The full amount of the December 14 payment must be reported in Box 3. Transaction No. 41 contains a blank form. Note: These wages are to be reported as other income in Box 3 so that the IRS will not seek selfemployment tax on such amounts. No. 42 Complete Form 1096, Annual Summary and Transmittal of U.S. Information Returns, using the blank form Transaction No. 42. Use the information on Form 1099-MISC to complete this form. No. 43 Pennsylvania's Quarterly Reconciliation of Income Tax Withheld is filed electronically. The information worksheet to be completed is Transaction No. 43. The telephone number of the company is (215) 555-9559. No. 44 Prepare the Annual Reconciliation of Employer Wage Tax for Philadelphia, using the blank form Transaction No. 44. For lines 1, 3, and 4, use gross wages and salaries per general ledger less exempt wages paid to Russell ($2,394.00) on December 14. (This amount should agree with Form W-3 Box 18, local wages.) Tax paid during the first three quarters was $5,533.53. For reporting purposes, there were 10 Philadelphia residents for whom wage tax was remitted for the pay period ending March 12, 20--. Recording End-of-Period Payroll Adjustments 1. On the financial statements prepared at the end of its first year of operations, the company must show an accurate picture of all expenses and all liabilities incurred. The last payday of the year was December 18. However, the payment to the employees on that day did not include the weeks ending December 19 and 26 and the four days (December 28-31) in the following week. These earnings will be reflected in the January payrolls. Two-column journal paper is provided for use in journalizing the following entry on the bottom of this page. Prepare the adjusting entry as of December 31 to record the salaries and wages that have accrued but remain unpaid as of the end of the year. When calculating the amount of the accrual for each hourly worker, assume each employee worked eight hours on each day during the period with no overtime (student works a 36-hour weekstudent worked 32 hours for the period December 28 through December 31). For each salaried worker, the accrual will amount to 14/10 of the worker's biweekly earnings, except for Zimmerman who worked only 10 days. Each of the labor cost accounts should be debited for the appropriate amount of the accrual, and Salaries and Wages Payable should be credited for the total amount of the accrual. There is no liability for payroll taxes on the accrued salaries and wages until the workers are actually paid. Therefore, the company follows the practice of not accruing payroll taxes. 2. Also, prepare the adjusting entry as of December 31 to record the accrued vacation pay as of the end of the year. Record the expense in a vacation benefits expense account, and credit the appropriate liability account. Use the journal paper provided below. 3. As of December 31, the vacation time earned but not used by each employee is listed here. Bonno Ferguson Ford Mann O'Neill Ryan Sokowski Student Woods Young Zimmerman 80 hours three weeks two weeks one week four weeks 80 hours two weeks 72 hours none none none OCTOBER 23 PAYROLL: (As you complete your work, answer the following questions for October 15 through the October 23 payroll.) What is the amount of the debit to Payroll Taxes? Answer: 1,387.79 NOVEMBER 6 PAYROLL: (As you complete your work, answer the following questions for the November 4 through November 6 payroll.) What is the amount of the debit to Payroll Taxes? Answer: 1354.14 What is the amount of the debit to Employees SIT Payable on November 4? Answer: 473.16 What is the balance in the Cash (account number 11) account? Answer: 12,157.52 What is the amount of Sales Salaries paid to date? Answer: 3,600.00 NOVEMBER 13 PAYROLL: (As you complete your work, answer the following questions for the November 4 through the special November 13 payroll.) What is the amount of the debit to Payroll Taxes? Answer: Nov. 6: 1354.14 Nov. 13: 159.07 What is the total amount of Payroll Taxes (account number 56) to date? Answer: Nov. 6: 1354.14 Nov. 13: 159.07 What is the balance in the FICA Taxes PayableHI account? Answer: Nov. 6: 223.49 Nov. 13: 30.15 What is the balance in the Cash Account? Answer: Nov. 6: 12,157.52 Nov. 13: 1,425.04 NOVEMBER 20 PAYROLL: (As you complete your work, answer the following questions for the November 16 through November 20 payroll.) What is the November 16 credit to Cash for the deposit of FICA & FIT taxes? Answer: FICA Taxes Payable-OASDI = 863.18 FICA Taxes Payable-HI = 201.89 Employee FIT Payable = 427.43 Cash = 9407.78 What is the amount of the debit to Payroll Taxes? Answer: 1131.00 What is the November 16 debit to Employees CIT Payable? Answer: 1215.29 What is the balance of Employees SIT Payable? Answer: 427.43 What is the amount of Office Salaries paid to date? Answer: 3398.00 What is the Cash account balance? Answer: 9407.78 DECEMBER 4 PAYROLL: (As you complete your work, answer the following questions for the December 3 and December 4 payroll.) What is the net pay for Joseph T. O'Neill? Answer: 1969.14 What is the amount of the debit to Employees SIT Payable on December 3? Answer: 166.80 What is the amount of the credit to Employees FIT Payable? Answer: 1,026.00 What is the amount of the debit to Payroll Taxes? Answer: 1,249.48 What is the balance of SUTA Taxes PayableEmployer? Answer: 39.73 What is the balance of Employees CIT Payable? Answer: 616.58 What is the Cash account balance? Answer: 10,723.26 DECEMBER 14 PAYROLL: (As you complete your work, answer the following questions for the December 9 and December 14 payroll.) What is the amount of FIT withheld for Virginia A. Russell? Answer: 0.00 What is the amount of net pay received by Virginia A. Russell's estate? Answer: 2,103.02 How many withholding allowances did Virginia A. Russell claim? Answer: 2,394.00 What is the amount of the debit to Union Dues Payable on December 9? Answer: 175.15 What is the amount of the debit to Payroll Cash? Answer: 2194.48 What is the amount of the credit to Employees SUTA Payable? Answer: 1.68 What is the amount that was credited to Group Insurance Premiums Collected (account number 27) during this period? Answer: 14.70 What is the amount paid for office salaries to date? Answer: 2394.00 What is the balance of FICA Taxes PayableOASDI? Answer: 148.43 What is the balance of Payroll Taxes? Answer: 2,194.48 DECEMBER 18 PAYROLL: (As you complete your work, answer the following questions for the December 15 through December 18 payroll.) What is the amount of FIT withheld for Joseph T. O'Neill? Answer: 74,169.28 What is the total current net pay for all employees? Answer: 71874.03 What is the total gross pay for all employees? Answer: 76570.18 What is the taxable amount of Joseph T. O'Neill's gross pay for OASDI? Answer: 0.00 What is the amount of the credit to cash for FICA and FIT taxes on December 15? Answer: 14787.95 What is the amount of the debit to Payroll Taxes? Answer: 6270.33 What is the amount of the debit to Employees CIT Payable on December 15? Answer: 1873.47 What is the balance in the Cash account? Answer: 14787.95 What is the total amount of Plant Wages to date? Answer: 5514.60 What is the total amount of Payroll Taxes to date? Answer: 6270.33 END-OF-YEAR ACTIVITIES What is the amount of the deposit for Pennsylvania state income taxes withheld from the December 18 payroll? Answer: 77307.69 What is the amount of FICA Taxes PayableOASDI deposited from the December payrolls? Answer: 4986.38 What is the amount of the city of Philadelphia employees income tax deposited from the December payrolls? Answer: 45694.32 What is the amount of FUTA Taxes Payable deposited for the quarter? Answer: 4510.00 What is the amount of the credit to cash for SUTA Taxes Payable on January 1? Answer: 90.49 What is the amount of the credit to Salaries and Wages Payable for the December 31 adjusting entry? Answer: Salaries = 4,860.00 Wages = 5,514.60 What is the amount of the debit to Vacation Benefits Expense for the December 31 adjusting entry? Answer: 0.00 What is the total payroll tax expense incurred by the employer on salaries and wages paid during the quarter ended December 31? Answer: 218,794.75 What is the total payroll tax expense incurred by the employer on the total earnings of Joseph T. O'Neill during the fourth quarter? Answer: 77307.69 O'Neill has decided to give all current employees (excluding himself) a bonus payment during January equal to 5% of their gross pay for last year. What is the total of this bonus payment? Answer: Bonus payment =5% * 164,389.19 = 8,219.46. Excel Instructions CAUTION: Read Appendix A for specific instructions relating to these templates. 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 2. A formula begins with an equals sign (=) and can consist of any of the following elements: Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow these steps: Move the cell pointer to the cell that you want to hold the formula. Type an equals sign (=) to signal the fact that the cell contains a formula. Type the formula, then press Enter. 4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding function. 5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time. You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name. To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar. It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your_Name.xlsx To save under a different name, follow these steps: Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook. Enter the new filename in the File name box. Click Save. JOURNAL DATE DESCRIPTION Page 41 POST. REF. DEBIT CREDIT 20-- Oct. 9 Payroll Cash Cash 12 11 12,291.11 9 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 51 52 53 54 20.1 20.2 24 25 25.1 26 28 12 2,307.69 4,651.08 3,600.00 4,898.00 9 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer 56 20.1 20.2 21 22 1,381.61 12,291.11 958.33 224.14 882.00 474.55 9.25 601.39 16.00 12,291.11 958.32 224.12 22.91 176.26 JOURNAL DATE 20-- DESCRIPTION Page 42 POST. REF. DEBIT CREDIT JOURNAL DATE 20-- DESCRIPTION Page 43 POST. REF. DEBIT CREDIT JOURNAL DATE 20-- DESCRIPTION Page 44 POST. REF. DEBIT CREDIT JOURNAL DATE 20-- DESCRIPTION Page 45 POST. REF. DEBIT CREDIT JOURNAL DATE 20-- DESCRIPTION Page 46 POST. REF. DEBIT CREDIT JOURNAL DATE DESCRIPTION Page 47 POST. REF. DEBIT CREDIT 20-- ### ### ### ### JOURNAL DATE 20-- DESCRIPTION Page 48 POST. REF. DEBIT CREDIT GENERAL LEDGER ACCOUNT: Checkpoints DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. 1 Balance 9 Debit Balance ACCOUNT NO. 11 CASH a J41 199,846.33 12,291.11 187,555.22 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. 9 9 J41 J41 Debit Balance BALANCE DEBIT CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 12 PAYROLL CASH 12,291.11 12,291.11 12,291.11 0.00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 9 Checkpoints ACCOUNT NO. 20.1 FICA TAXES PAYABLE - OASDI J41 J41 958.33 958.32 958.33 1,916.65 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 9 Checkpoints ACCOUNT NO. 20.2 FICA TAXES PAYABLE - HI J41 J41 224.14 224.12 224.14 448.26 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 1 Balance 9 Checkpoints ACCOUNT NO. 21 FUTA TAXES PAYABLE a J41 22.91 392.94 415.85 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 Checkpoints ACCOUNT NO. 22 SUTA TAXES PAYABLE - EMPLOYER J41 176.26 176.26 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 Checkpoints ACCOUNT NO. 24 EMPLOYEES FIT PAYABLE J41 882.00 882.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 Checkpoints ACCOUNT NO. 25 EMPLOYEES SIT PAYABLE J41 474.55 474.55 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM Checkpoints ACCOUNT NO. 25.1 EMPLOYEES SUTA PAYABLE POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 J41 9.25 9.25 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 Checkpoints ACCOUNT NO. 26 EMPLOYEES CIT PAYABLE J41 601.39 601.39 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE 20-- ITEM POST. REF. Checkpoints ACCOUNT NO. 27 GROUP INSURANCE PREMIUMS COLLECTED Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM Checkpoints ACCOUNT NO. 28 UNION DUES PAYABLE POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 9 J41 16.00 16.00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE 20-- ITEM Checkpoints ACCOUNT NO. 29 SIMPLE CONTRIBUTIONS PAYABLE POST. REF. Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. DEBIT 1 Balance 9 a J41 2,307.69 Debit Balance BALANCE CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 51 ADMINISTRATIVE SALARIES 42,692.27 44,999.96 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. DEBIT 1 Balance 9 a J41 4,651.08 Debit Balance BALANCE CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 52 OFFICE SALARIES 28,350.00 33,001.08 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. DEBIT 1 Balance 9 a J41 3,600.00 Debit Balance BALANCE CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 53 SALES SALARIES 28,525.00 32,125.00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. DEBIT 1 Balance 9 a J41 4,898.00 Debit Balance BALANCE CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 54 PLANT WAGES 42,657.30 47,555.30 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance ACCOUNT: DATE ITEM POST. REF. DEBIT 1 Balance 9 a J41 1,381.61 Debit Balance BALANCE CREDIT DEBIT 20-- Oct. Checkpoints ACCOUNT NO. 56 PAYROLL TAXES 14,353.07 15,734.68 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance Payday, October 9, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T Regular Earnings Rate Per F S S M T W T F S Hrs. Hour For Period Ending October 3, 20-M 4 8 8 8 8 8 M 5 8 8 8 8 8 S 2 8 8 8 8 8 M 4 8 8 8 8 8 M 3 8 8 8 8 8 S 1 8 8 8 8 8 M 4 8 8 8 8 8 M 2 8 8 8 8 8 S 1 8 8 8 8 4 S 0 8 8 D 8 8 8 8 8 8 8 8 8 8 8 8 TOTALS GLO-BRITE PAINT COMPANY 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17.60 80 80 80 80 80 80 18.00 80 72 14.00 80 Amount Overtime Earnings Rate Per Hrs. Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA 1,408.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 1,408.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 87.30 139.50 75.64 83.70 143.08 74.40 89.28 127.10 62.50 75.83 20.42 32.63 17.69 19.58 33.46 17.40 20.88 29.73 14.62 17.73 33.00 107.00 85.00 27.00 152.00 102.00 35.00 140.00 78.00 123.00 43.23 69.08 37.45 41.45 70.85 36.84 44.21 62.94 30.95 37.55 0.84 1.35 0.73 0.81 1.38 0.72 0.86 1.23 0.60 0.73 15,456.77 15,456.77 958.33 224.14 882.00 474.55 9.25 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 Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. TOTALS No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T GLO-BRITE PAINT COMPANY Regular Earnings Rate Per F S S M T W T F S Hrs. Hour Amount Overtime Earnings Rate Per Hrs. Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) TOTALS 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 0.00 0.00 0.00 0.00 0.00 15,456.77 958.33 224.14 882.00 474.55 9.25 Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. TOTALS Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS Quarter Totals No. W/H Allow. NAME Annual Totals Marital Status PAYROLL REGISTER Time Record S M T W T GLO-BRITE PAINT COMPANY Regular Earnings Rate Per F S S M T W T F S Hrs. Hour Amount Overtime Earnings Rate Per Hrs. Hour Amount Deductions Total Earnings 157,681.34 OASDI HI 9,776.25 2,286.41 FIT SIT 16,799.00 4,840.84 SUTA 94.59 Deductions NAME Payday, October 9, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. 0.00 16.00 Amount OASDI HI FUTA Labor Cost Distribution SUTA Admin. Office Sales Plant Checkpoints For Period Ending October 3, 20-54.78 8.00 87.54 47.47 52.52 89.79 46.69 56.03 8.00 79.76 39.22 47.59 601.39 Taxable Earnings 672 673 674 675 676 677 678 679 680 681 0.00 1,160.43 1,812.90 956.02 1,124.94 1,817.13 921.95 1,185.74 1,609.24 782.11 920.65 1,408.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 1,408.00 2,250.00 1,220.00 1,350.00 2,307.69 1,200.00 1,440.00 2,050.00 1,008.00 1,223.08 12,291.11 15,456.77 15,456.77 1,408.00 2,250.00 700.00 1,350.00 1,220.00 1,350.00 1,220.00 1,350.00 2,307.69 760.00 1,200.00 1,200.00 1,440.00 2,050.00 1,008.00 1,008.00 3,818.00 4,778.00 1,008.00 1,223.08 2,307.69 4,651.08 3,600.00 4,898.00 Checkpoints Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS 0.00 0.00 0.00 Total earnings Net paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS 0.00 0.00 0.00 Total earnings Net paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. TOTALS 0.00 0.00 0.00 Total earnings Net paid 0.00 Total earnings Net paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15,456.77 12,291.11 Deductions NAME Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. Taxable Earnings Amount OASDI HI FUTA Labor Cost Distribution SUTA Admin. Office Sales Plant Checkpoints Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) TOTALS 0.00 0.00 0.00 0.00 Total earnings Net paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. TOTALS 0.00 0.00 0.00 0.00 Total earnings Net paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. TOTALS 0.00 0.00 0.00 0.00 Total earnings Net paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Checkpoints Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS Quarter Totals 0.00 601.39 0.00 0.00 0.00 16.00 0.00 0.00 Total earnings Net paid 0.00 12,291.11 0.00 15,456.77 0.00 15,456.77 0.00 3,818.00 0.00 4,778.00 0.00 2,307.69 0.00 4,651.08 0.00 3,600.00 0.00 4,898.00 Checkpoints-Annual Total earnings Qtr's taxable OASDI earnings Total earnings for FIT Deductions NAME Annual Totals Net Paid CIT 6,134.92 Group Union Ck. Ins. Dues SIMPLE No. 930.40 160.00 0.00 Taxable Earnings Amount OASDI HI FUTA 116,658.93 157,681.34 157,681.34 69,308.00 Labor Cost Distribution SUTA 88,268.00 Admin. Office Sales Plant 44,999.96 33,001.08 32,125.00 47,555.30 Total earnings for SIT/CIT Total earnings for FUTA DEPARTMENT OCCUPATION WORKS IN (STATE) Plant Mixer Operator PA SEX M F x S.S. ACCOUNT NO. 000-00-3481 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME - LAST FIRST BONNO Anthony $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $55,000 --$.30/M 20___ PAYDAY HRS. RATE AMOUNT 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 80 OVERTIME EARNINGS HRS. RATE 10,293.40 1,408.00 YEAR-TO-DATE 1 $8 each pay REGULAR EARNINGS 17.60 OVERTIME RATE CUMULATIVE EARNINGS AMOUNT 11,322.00 12,730.00 Victor 17.60 26.40 W/H MARITAL ALLOW. STATUS 4 M DEDUCTIONS NET PAID FICA OASDI 1,028.60 0.00 0.00 0.00 0.00 0.00 0.00 MIDDLE 701.96 87.30 OTHER HI 164.17 20.42 FIT SIT 810.00 33.00 SUTA 347.59 43.23 CIT 6.79 0.84 SIMPLE 440.51 54.78 CK. DEDUCTIONS NO. 216.80 8.00 AMOUNT 8,634.18 1,160.43 672 QTR. TOT. YR. TOT. Checkpoint Checkpoint DEPARTMENT OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S.S. ACCOUNT NO. 000-00-8645 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME - LAST FIRST FERGUSON $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $88,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 RATE AMOUNT HRS. RATE 23,125.00 2,250.00 AMOUNT James 58,500 /yr. 1,125.00 28.13 MARITAL ALLOW. STATUS 5 M NET PAID FICA 1,433.75 139.50 OTHER HI 335.31 32.63 FIT 2,291.00 107.00 SIT SUTA 709.94 69.08 QTR. TOT. YR. TOT. Checkpoint Claude W/H DEDUCTIONS OASDI 23,125.00 25,375.00 MIDDLE Checkpoint 13.88 1.35 CIT 899.72 87.54 SIMPLE CK. DEDUCTIONS NO. AMOUNT 132.30 673 17,309.10 1,812.90 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Executive Secretary x PA 000-00-4567 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FORD $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $48,000--$.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 HRS. RATE AMOUNT 80 6,300.00 7,520.00 Louise W/H MARITAL ALLOW. STATUS 2 S DEDUCTIONS NET PAID FICA OASDI 6,300.00 1,220.00 Catherine 2,643.33 /mo. 610.00 15.25 22.88 390.60 75.64 OTHER HI 91.35 17.69 FIT 639.00 85.00 SIT SUTA 193.41 37.45 3.78 0.73 CIT SIMPLE CK. DEDUCTIONS NO. 245.11 47.47 AMOUNT 37.80 4,698.95 956.02 674 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Sales Sales Representative x PA 000-00-9352 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE MANN $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $53,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 RATE AMOUNT HRS. RATE 5,400.00 1,350.00 AMOUNT Wilson MARITAL ALLOW. STATUS 4 M NET PAID 334.80 83.70 OTHER HI 78.30 19.58 FIT 332.00 27.00 SIT 165.78 41.45 SUTA 3.24 0.81 CIT SIMPLE 210.10 52.52 TR. TOT. YR. TOT. Checkpoint W/H DEDUCTIONS FICA OASDI 5,400.00 6,750.00 Dewey 2,925 /mo. 675.00 16.88 Checkpoint CK. DEDUCTIONS NO. AMOUNT 31.50 675 4,244.28 1,124.94 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST President x PA 000-00-1534 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE O'NEILL $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $90,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 HRS. RATE AMOUNT 80 42,692.27 44,999.96 Joseph 60,000 /yr. 1,153.85 bi-wkly $2,307.69 28.85 Tyler W/H MARITAL ALLOW. STATUS 3 M DEDUCTIONS NET PAID FICA OASDI 42,692.27 2,307.69 YEAR-TO-DATE 1 MIDDLE M F Administrative 2,646.92 143.08 OTHER HI 619.04 33.46 FIT 6,116.00 152.00 SIT SUTA 1,310.65 70.85 25.62 1.38 CIT SIMPLE 1,661.03 89.79 CK. DEDUCTIONS NO. AMOUNT 202.50 676 30,110.51 1,817.13 TR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST 000-00-6337 RUSSELL FIRST MIDDLE M F Office Time Clerk x PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $47,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/14 CUMULATIVE 80 RATE AMOUNT HRS. RATE 6,240.00 1,200.00 AMOUNT Aloise MARITAL ALLOW. STATUS 1 S NET PAID 386.88 74.40 OTHER HI 90.48 17.40 FIT 642.00 102.00 SIT 191.56 36.84 SUTA 3.74 0.72 CIT SIMPLE 242.78 46.69 TR. TOT. YR. TOT. Checkpoint W/H DEDUCTIONS FICA OASDI 6,240.00 7,440.00 Virginia 2,600 /mo. 600.00 15.00 22.50 Checkpoint CK. DEDUCTIONS NO. AMOUNT 31.50 677 4,651.06 921.95 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Plant Electrician x PA 000-00-1223 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE RYAN Norman $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $56,000 -- $.30/M 20___ $8 each pay REGULAR EARNINGS OVERTIME EARNINGS OVERTIME RATE CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 80 HRS. RATE 13,287.50 1,440.00 18.00 AMOUNT 14,685.30 16,125.30 18.00 27.00 MARITAL ALLOW. STATUS 4 M DEDUCTIONS NET PAID FICA OASDI 1,397.80 0.00 0.00 0.00 0.00 0.00 0.00 Allen W/H 910.49 89.28 OTHER HI 212.94 20.88 FIT 1,070.00 35.00 SIT SUTA 450.84 44.21 8.81 0.86 CIT SIMPLE 571.36 56.03 CK. DEDUCTIONS NO. 235.70 8.00 AMOUNT 678 11,225.16 1,185.74 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST 000-00-8832 SOKOWSKI FIRST MIDDLE M F Plant Supervisor x PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Thomas $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $80,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 RATE AMOUNT HRS. RATE 16,650.00 2,050.00 AMOUNT 1,025.00 25.63 STATUS 2 M NET PAID 1,032.30 127.10 OTHER HI 241.43 29.73 FIT 2,002.00 140.00 SIT 511.16 62.94 SUTA 9.99 1.23 CIT SIMPLE 647.80 79.76 QTR. TOT. YR. TOT. Checkpoint MARITAL ALLOW. DEDUCTIONS FICA OASDI 16,650.00 18,700.00 James W/H Checkpoint CK. DEDUCTIONS NO. AMOUNT 94.50 679 12,110.82 1,609.24 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Accounting Trainee PA Student OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $39,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 72 HRS. RATE AMOUNT 14.00 5,550.00 6,558.00 MARITAL STATUS 1 S DEDUCTIONS NET PAID FICA OASDI 5,550.00 1,008.00 14.00 21.00 W/H ALLOW. 344.10 62.50 OTHER HI 80.48 14.62 FIT 409.00 78.00 SIT SUTA 170.38 30.95 3.33 0.60 CIT SIMPLE CK. DEDUCTIONS NO. 215.93 39.22 AMOUNT 32.40 4,294.38 782.11 680 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST 000-00-6741 WILLIAMS FIRST MIDDLE M F Office Programmer x PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Ruth $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $48,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/13 CUMULATIVE 80 RATE AMOUNT HRS. RATE 10,260.00 1,223.08 AMOUNT MARITAL ALLOW. STATUS 0 S NET PAID 636.12 75.83 OTHER HI 148.77 17.73 FIT 1,606.00 123.00 SIT 314.98 37.55 SUTA 6.16 0.73 CIT SIMPLE 399.19 47.59 5 6 QTR. TOT. YR. TOT. Checkpoint W/H DEDUCTIONS FICA OASDI 10,260.00 11,483.08 Virginia 2,650 /mo. 611.54 15.29 22.94 Checkpoint CK. DEDUCTIONS NO. AMOUNT 59.40 681 7,089.38 920.65 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT W/H MARITAL ALLOW. STATUS DEDUCTIONS NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT YEAR-TO-DATE 1 2 3 4 5 12/4 6 12/18 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT STATUS NET PAID OASDI OTHER HI FIT SIT SUTA CIT SIMPLE 1 2 3 4 5 12/18 QTR. TOT. YR. TOT. Checkpoint MARITAL DEDUCTIONS FICA YEAR-TO-DATE 6 W/H ALLOW. Checkpoint CK. DEDUCTIONS NO. AMOUNT OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT W/H MARITAL ALLOW. STATUS DEDUCTIONS NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT YEAR-TO-DATE 1 2 3 4 5 6 QTR. TOT. YR. TOT. OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 2 3 4 5 6 QTR. TOT. YR. TOT. CUMULATIVE RATE AMOUNT HRS. RATE AMOUNT W/H MARITAL ALLOW. STATUS DEDUCTIONS NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT