How do you prepare an Excel report of wages for workers compensation audit in Quickbooks? I would like step-by-step instructions, please.

For Mary, I would use code 8810, others I would use 0042.

Thank you!

Here is a sample of a worker's comp audit from another state. Do you know how to format a report in Quickbooks?

Below is a sample payroll report: Audit Period: Report must include payroll data for the audited time period State Worked Section 125 Contributions (CA OAM Overtime (OT) Gross Wages Company Code Severance GHB MA 6HB 6HB 6HB MA You can provide payroll in a manner that complimerits your payrol system For example, payroll may be reported for the entire audit period, by quarter or by year when the audit period overlaps years. 828 Entity Employee ABC Company Employee Name 1 ABC Company Employee Name 2 ABC Company Employee Name 3 ABC Company Employee Narkos BCD Company Emerge lame 6 BCD Company Proyee nie? BCD or Enployee Name cougaty Employee Narne 9 Bon Company Employee Name 10 BCD Company Employee Name 11 BCD Company Employee Name 12 Job Title Facilities Maintenance Technician Environmental Health & Safety Officer Lead Facildes Maint Technician Sr. Facilities Manager Account Manager St. Account Manager Sr Field Service Engineer Area Business Manager Executive Technical Sales Rep Sr. Field Service Engineer Technical Sales Representative Brief description of duties (if not clear from the job title) Clean up in offices and warehouse OSHA Compliance Manages maintenance techs Manages maintenance staff Visits with clients at their sites Visits with clients at their sites Works in the office Visits with clients at the sites Manages tech sales staff Works at customer sites Technical assistance via phone 32S 895 828 RRRRR The payroll suppled must show payrol for the entire audit period Below is a sample payroll report: Audit Period: Report must include payroll data for the audited time period State Worked Section 125 Contributions (CA OAM Overtime (OT) Gross Wages Company Code Severance GHB MA 6HB 6HB 6HB MA You can provide payroll in a manner that complimerits your payrol system For example, payroll may be reported for the entire audit period, by quarter or by year when the audit period overlaps years. 828 Entity Employee ABC Company Employee Name 1 ABC Company Employee Name 2 ABC Company Employee Name 3 ABC Company Employee Narkos BCD Company Emerge lame 6 BCD Company Proyee nie? BCD or Enployee Name cougaty Employee Narne 9 Bon Company Employee Name 10 BCD Company Employee Name 11 BCD Company Employee Name 12 Job Title Facilities Maintenance Technician Environmental Health & Safety Officer Lead Facildes Maint Technician Sr. Facilities Manager Account Manager St. Account Manager Sr Field Service Engineer Area Business Manager Executive Technical Sales Rep Sr. Field Service Engineer Technical Sales Representative Brief description of duties (if not clear from the job title) Clean up in offices and warehouse OSHA Compliance Manages maintenance techs Manages maintenance staff Visits with clients at their sites Visits with clients at their sites Works in the office Visits with clients at the sites Manages tech sales staff Works at customer sites Technical assistance via phone 32S 895 828 RRRRR The payroll suppled must show payrol for the entire audit period