This task I need help with is for accounting in Quickbooks.

May I have step by step instructions on how to complete this task? An image of the final Excel sheet results would be helpful. The code just means the level of the employee e.g., Field worker, office worker. Use code 8810 for office workers, others I would use 0042.

Salary: $8,904.00 Hourly: $13,159.00 OT: $263.25

Thank you!

September Questions 1. Prepare Excel report of wages for workers compensation audit: 1/1/19 through 9/30/2019. List total gross wages by employee for audit period; calculate total for all 3 employees. List wages by types: office and field wages; calculate total for both types. Make sure the total per employee list equals the total per type list. Wages are reported by type because the workers comp rates are different for office versus field labor; list the workers comp codes per the WI Workers Comp Code Manual, choose best fit. All of Mary's wages should be classified as office here. September Questions 1. Prepare Excel report of wages for workers compensation audit: 1/1/19 through 9/30/2019. List total gross wages by employee for audit period; calculate total for all 3 employees. List wages by types: office and field wages; calculate total for both types. Make sure the total per employee list equals the total per type list. Wages are reported by type because the workers comp rates are different for office versus field labor; list the workers comp codes per the WI Workers Comp Code Manual, choose best fit. All of Mary's wages should be classified as office here