The question is the Appendix A in the 2014 Edition of Bieg and Toland ( payroll accounting) , but you are following chapter 7 guildlines as well. I have attached both documents into one.
Chapter 7 October9, 20-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 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-1 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 employee 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 employees 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, included 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 1) Ferguson, James C Weekly Rate Hourly Rate $1,125.00 $28.13 2) Ford, Catherine L 450.00 11.25 3) Mann, Dewey W 675.00 16.88 4) O' Neill, Joseph T 1,153.85 28.85 5) Russell, Virginia A 3435.00 8.63 6) Sokowski, Thomas 1,025.00 25.63 7) Williams, Ruth V 611.54 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 ay 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. 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 on page 7-50complete the information worksheet needed for the first semimonthly period of October. The company's Pennsylvania account number is 146-3-3300, its EIN is 00-0000660, its filing password is GBPCOM, and its telephone number is (215) 5559559. Appendix A October 23 Payroll Step 3: Enter and post the October 20 transaction required to record the deposit of the Pennsylvania state income taxes withheld from the October 9 payroll Step:2 Enter the following payroll transactions. Do deduct Group ins- do deduct Union dues for the appropriate employees- don not deduct Simple Plan (which is the same as Simple Contributions Payable). Note: Be sure to enter the correct Group insurance amount for each employee ( the default amounts that appear are carried over from the opening balances). Also, since the union dues entered in the previous payroll are assumed by the computer to be the same for future pay periods, it will not be necessary to enter these amounts again. However, it is a good idea to verify that they are the same as those in the payroll transaction below. Employee Number Union Dues Employee Name Salary/ Reg.Hrs Overtime@Time One and half 4 Overtime@ Double Group Ins 100 Bonno, Anthony Victor 80 $16.50 $8.00 110 Ferguson, James Claude reg.salary $26.50 120 Ford, Catherine Louise reg.salary $10.50 130 Mann, Dewey Wilson reg.salary $15.90 140 O'Neill, Joseph Tyler reg.salary $27.00 150 Russell, Virginia Aloise reg.salary 160 Ryan, Norman Allen 80 170 Sokowski, Thomas James reg.salary $24.00 180 Sen 72 $6.30 190 Williams, Ruth Virginia reg.salary $14.40 $8.10 8 $16.80 $8.00 Step :5 Display the payroll report Step6: Generate and post the journal entry for the current payroll Step 7: Generate and post the journal entry for the employer's payroll taxes. Step 8: Enter and Post the October 23 general Journal entry to record the deposit of cash for the total net amount owed to employees in the payroll cash amount Step 9: Display the journal report 10/10/-- through 10/23/-Step 10: Display the journal ledger report. Step 11; Generate a labor distribution graph. Note: The graph depicts the distribution of the gross amount wages paid to each salaries expense amount for the current month ( sum of the data from the October9 and October 23 payrolls)
