User Support Forum

I have the pleasure of going through my first WC audit. I ran a few reports but can't seem to figure out which report will get me the results he is requesting:

1. Gross Wages, Overtime Wages, and Severance (if any) for all employees during the audit period. The payroll for the audit period should be based on the check dates that fall during the audit period. The state and workers compensation code and department/duties should be shown by each employee's name. Providing this information in columns on an Excel Spreadsheet will benefit the audit process on larger audits but is not required. (I will have to add the codes later because they are not included on my employee info)
2. The total pre-tax medical wages (Sec 125, Cafe Plan, etc.) must be provided for the audit period (if any). This information is needed to reconcile your wages to Medicare Wages (line 5c) on your 941 forms.

Can you point me in the right direction?

Thanks in advance

whfpc wrote:I have the pleasure of going through my first WC audit. I ran a few reports but can't seem to figure out which report will get me the results he is requesting:

1. Gross Wages, Overtime Wages, and Severance (if any) for all employees during the audit period. The payroll for the audit period should be based on the check dates that fall during the audit period. The state and workers compensation code and department/duties should be shown by each employee's name. Providing this information in columns on an Excel Spreadsheet will benefit the audit process on larger audits but is not required. (I will have to add the codes later because they are not included on my employee info)
2. The total pre-tax medical wages (Sec 125, Cafe Plan, etc.) must be provided for the audit period (if any). This information is needed to reconcile your wages to Medicare Wages (line 5c) on your 941 forms.

Can you point me in the right direction?

Thanks in advance

FWIW ... the only information you can get from Powerchurch would be the payroll. I'd use the Wage and Hour report as it does break down hourly wages by regular and overtime. It also provides a list of all income items for the period selected. I'm assuming last year, but you can select a custom period.

Does this help ?

That is the report I printed, it does not show the insurance amounts withheld, I am assuming I can just look up any employee for them while they are here and they will be able to balance to the w's?

whfpc wrote:That is the report I printed, it does not show the insurance amounts withheld, I am assuming I can just look up any employee for them while they are here and they will be able to balance to the w's?

Not knowing how you have your system setup, I am going to assume these amounts withheld are standard deduction pay items. If so, they should appear on the Item Summary report, and you should check the Print Summary by Employee box.

that's it!!!!! Thanks for everything.

Robin