Payroll final project Payroll final project Question You are required to complete and submit for grading, the parts you began work on in Unit 8. Unit 9 will contain separate Dropboxes for parts 3-6. View the Final Project details from the icon below. . View the for using the computerized payroll software. Appendix A of the Payroll Accounting textbook contains the instructions for using the software. There is also a User’s Guide in Doc Sharing and on the textbook website. You will use Appendix A to complete Parts 3-6 of the project. Directions for Submitting Your Final Project Parts 3-6 Before you submit your project, you should save your work on your computer in a location and with a name that you will remember. Make sure your project is in the appropriate format then, when you are ready, you may submit on the Dropbox page. In Unit 9 you will submit parts 3-6 of the Final Project, there is a separate Dropbox for each part. ID: AB122-09-07-FP Final Project Parts 1 and 2 In Unit 8 you will be completing Parts 1-2 of the Final Project. Each part will be submitted separately for grading and you will complete the payroll register, the employee earnings record, the journal entries and post to the general ledger for each part as required. Parts 1 and 2 of the project will be completed manually using the template provided. View the Final Project details from the icon below. . . Directions for Submitting Your Final Project Parts 1 and 2 Unit 8 will contain Dropboxes for parts 1-2, and Unit 9 will contain Dropboxes for parts 3-6. Before you submit your project, you should save your work on your computer in a location and with a name that you will remember. Make sure your project is in the appropriate format), then, when you are ready, you may submit to the Final Project Part 1 and Final Project Part 2 Dropboxes. Unit 8 & 9 Project Instructions In Units 8 & 9 you are working on completing the final project for the class. Chapter 7 of the text is a comprehensive Payroll Project that should be completed by students 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 Register, 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. Appendix A of the text contains the instructions for using the Computerized Payroll software. You will use pages A1?A14. 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 200 points; the final project will be broken down into six (6) parts as follows: Parts 1 and 2 will be completed manually using the Template in Excel, you will upload the template file to the dropbox for grading. Parts 3?6 will be completed using the Computerized Payroll Accounting software which can be do Parts 1 and 2 will be completed manually using the Template in Excel, you will upload the template file to the dropbox for grading. Parts 3?6 will be completed using the Computerized Payroll Accounting software which can be downloaded from the Unit 9 Assignment link. You will upload the saved payroll file to the dropbox for grading. The October 9 payroll has been completed for you in the template. You will see the Payroll Register, 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 (30 points) November 20th on pages A10?A11. Part 4 (30 points) December 4th on page A12. Part 5 (30 points) December 14th on page A13. Part 6 (30 points) December 18th on pages A13?A14. Units 8 and 9 [122: Payroll Accounting] Start by Downloading the template from Doc Sharing?you should be using the template called: Final Project Template 2012 ? This template is color coded by Project Part, the Payroll register and the journal match by color ? You will complete the work on pages 7?1 through 7?19 (January 15th transaction) and the February 1st journal entries. ? VERY IMPORTANT!!!!!! ? Read everything carefully?begin on page 7?2. ? Pages 7?2 through 7?6 give the company information and the employee details ? Read and trace the transactions for the October 9th Payroll that has been done for you (pages 7?7 through 7?10) ? If you have questions?ask sooner rather than later, and attach your template s that I can see where you are. ? Take your time and start early. ? For each part of the payroll project you should complete the Journal, General Ledger, Payroll Register, 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. ? You have payrolls for the following dates: ? October 9 (this one has been done for you) Complete manually using the template ? October 23 ? November 6 ? November 13 Complete using the Computerized Payroll software ? November 20 ? December 4 ? December 14 ? December 18 ? In between the Payrolls are Journal entries that should be completed. The order to complete the work Units 8 and 9 [122: Payroll Accounting] 1. Complete the Payroll first 2. Transfer the individual employee payroll data to the employee earnings record 3. Complete the General Journal ? Be sure that when it says a deposit was made that you record it in the journal 4. 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?2, Unit 9 consists of Parts 3?6. There is a separate dropbox for each part. Some check figures For Part 1 and 2 to assist you: October 9 (this one has been done for you) ? Total Earnings: $14,162.77 ? Net Pay: $ 11,358.12 October 23 ? Total Earnings: $14,484.69 ? Net Pay: $ 11,438.17 November 6 ? Total Earnings: $ 14,130.48 ? Net Pay: $ 11,194.94 November 13 ? Total Earnings: $ 2,079.32 ? Net Pay: $ 1,456.26 For Unit 9, Parts 3?6 Note: The computerized portion of this project may produce amounts that differ slightly due to computer rounding, so these are the check figures for the computerized work in Appendix A. Units 8 and 9 [122: Payroll Accounting] Suggestion: Check your journal entry amounts against the check figures before you post the entry, that way you can go back and correct the payroll and then generate the entry again before posting. October 9 ? Gross Pay: $14,162.77 ? Net Pay: $ 11,349.02 October 23 ? Gross Pay: $14,484.67 ? Net Pay: $ 11,426.56 November 6 ? Gross Pay: $ 14,130.48 ? Net Pay: $ 11,186.84 November 13 ? Gross Pay: $ 2,079.32 ? Net Pay: $ 1,453.80 November 20 ? Gross Pay: $ 12,640.23 ? Net Pay: $ 8,502.54 December 4 ? Gross Pay: $ 14,431.09 ? Net Pay: $ 10,021.70 December 14 ? Gross Pay: $ 1,425.16 ? Net Pay: $ 1,334.80 December 18 ? Gross Pay: $ 74,922.49 ? Net Pay: $ 40,733.80