Kaplan AC122 Payroll final project
Welcome to your Homework Assistance video for Units 8 and 9. In Units 8 & 9 you are working on completing the final project for the class. In this video, you will be reviewing the steps required for this project.
Chapter 7 of the text is a comprehensive Payroll Project that should be completed by you to demonstrate understanding of the material covered in Chapters 1-6. For each part of the payroll project you should complete the Journal, General Ledger, Payroll ter, and the Employee Earnings Record as applicable. When completing the Payrolls, complete the payroll register first, then transfer each employee’s amounts to the Employee Earnings Record, then complete the Journal entries applicable to the payroll, and then post to the general ledger.
Each Part of the project will be submitted separately for grading, you will submit the entire template, and the instructor will grade each part separately and award points based on completion and correctness. Be sure to look at the feedback provided by the instructor for corrections that may affect your ending balances.
The Final Project is worth 210 points; the final project will be broken down into six (6) parts as follows:
The October 9 payroll has been completed for you in the template. You will see the Payroll ter, and Journal in the template, this is color coded light green.
Part 1 (40 points) October 20th – November 4th on pages 7-11 and 7-12 in the template this is color coded yellow. Use Journal page 42.
Part 2 (40 points) November 6th - 18th on pages 7-12, 7-13 and 7-14 in the template this is color coded blue. Use Journal page 43.
Part 3 (25 points) November 20th and 30th on pages 7-14, 7-15 and 7-16 in the template this is color coded dark pink. Use Journal page 44.
Part 4 (35 points) December 3rd- 4th on pages 7-16 in the template this is color coded orange. Use Journal page 45. Part 5 (40 points) December 9th – 15th on page 7-17, in the template this is color coded tan. Use Journal page 46.
Part 6 (30 points) December 18th – February 1st on pages 7-17 through 7-20, in the template this is color coded Blue. Use Journal page 47.
Start by Downloading the template from Doc Sharing-you should be using the template called: Final Project Template 2012
q This template is color coded by Project Part, the Payroll register and the journal match by color
q You will complete the work on pages 7-1 through 7-19 (January 15th transaction) and the February 1st journal entries.
Page 1 of 3
Unit 8 & 9
[122: Payroll Accounting]
q VERY IMPORTANT!
q Read everything carefully-begin on page 7-2.
q Pages 7-2 through 7-6 give the company information and the employee details
q Read and trace the transactions for the October 9th Payroll that has been done for you (pages 7-7 through 7-10)
q If you have questions-ask sooner rather than later, and attach your template s that I can see where you are.
q Take your time and start early.
q For each part of the payroll project you should complete the Journal, General Ledger, Payroll ter, and the Employee Earnings Record as applicable. When completing the Payrolls, complete the payroll register first, then transfer each employee’s amounts to the Employee Earnings Record, then complete the Journal entries applicable to the payroll, and then post to the general ledger.
q You have payrolls for the following dates:
q October 9 (this one has been done for you)
q October 23
q November 6
q November 13
q November 20
q December 4
q December 14
q December 18
q In between the Payrolls are Journal entries that should be completed.
The order to complete the work
1. Complete the Payroll first
2. Transfer the individual employee payroll data to the employee earnings record
- Complete the General Journal
? Be sure that when it says a deposit was made that you record it in the journal
- Post to the General Ledger
? Each Part of the project will be submitted separately for grading, you will submit the entire template, and the instructor will grade each part separately and award points based on completion and correctness. Be sure to look at the feedback provided by the instructor for corrections that may affect your ending balances.
Unit 8 consists of Parts 1-3, Unit 9 consists of Parts 4-6. There is a separate Dropbox for each part.
Some check figures to assist you:
October 9 (this one has been done for you)
Page 2 of 3
Unit 8 & 9 [122: Payroll Accounting]
? Total Earnings: $14,162.77
? Net Pay: $ 11,058.80
October 23
? Total Earnings: $14,484.69
? Net Pay: $ 11,131.63 November 6
? Total Earnings: $ 14,130.48
? Net Pay: $ 10,897.23 November 13
? Total Earnings: $ 2,079.32
? Net Pay: $ 1,412.13 November 20
? Total Earnings: $ 12,640.23
? Net Pay: $ 8,240.91 December 4
? Total Earnings: $ 14,431.09
? Net Pay: $ 9,722.77 December 14
? Total Earnings: $ 1,425.16
? Net Pay: $ 1,306.30 December 18
? Total Earnings: $ 74,922.49
? Net Pay: $ 39,367.66
The template has built in formulas to calculate some of the amounts, you will have some rounding, so if you are off by a few pennies, do not spend a lot of time looking for it, your instructor has been notified to give credit for rounding error in net pay of .10 or less.
Feel free to e-mail your instructor or post questions (not answers) in the virtual office about this recording.
-
Rating:
/5
Solution: Kaplan AC122 Payroll final project