Audit System Manual graphic

[ Audit System Manual- TOC ] [ Ch 1 - Introduction ] [ Ch 2 - Preparing for an Audit ] [ Ch 3 - Conducting the Audit ] [ Ch 4 - Completing the Audit Forms and Schedules ] [ Ch 5 - Audit System Screens ] [ Ch 6 - Miscellaneous ] [ Ch 7 - USDOL - Tax Performance System ] [ Ch 8 - Computer Fundamentals & Hardware ] [ Appendix ]
[ 4.1 - Audits Performed by New Hire Tax Employees ] [ 4.2 - Where to Find Audit Forms and Schedules ] [ 4.3 - Assembling the Completed Audit Work Papers ] [ 4.4 - The C-51 Field Audit Report ][ 4.5 - Schedule One (C-51E) & Schedule One (C-5G)Audit Summary ] [ 4.6 - Schedule Two (C-51F) Verification of Payroll Posting ] [ 4.7 - Schedule Three (C-51G) Search for Additional Wages ] [ 4.8 - Review Process for Audits and for the Audit Program ]

Chapter 4:  Completing the Audit Forms and Schedules


comments to: Tax Department

4.6    Schedule Two (C-51F) - Verification of Payroll Posting

[ 4.6.1 - Schedule Two Fields]

A blank copy of Schedule 2 is located in the Appendix Section of this manual.

Schedule 1 and Schedule 2 work together to verify the acknowledged payroll. The object of verifying the posting of payroll data is to make sure that wages earned by an employee were recorded correctly in all of the employer's payroll records, and then reported correctly to our Agency.

The process starts by examining the source documents for an employee's wages. Wage payments made to one employee for one quarter must be traced from a source document through the other records in the employer's payroll system. The purpose of this trace is to verify that payroll information on the source document was posted correctly to all succeeding records in the payroll system. The employee's verified quarterly wage total must then be traced to the employer's copy of the quarterly report and then finally compared to the wage amount appearing on TWC's wage record system. All record types used to verify the payroll system must be addressed in the body of Schedule 2 or in the Comments section.

If the wage amounts are different in any of the payroll records, the Accounts Examiner must investigate to see what caused the difference. The AE must trace additional payroll items from other quarters and/or from other employees in order to determine what caused the differences. After determining the reason for the variances, the Accounts Examiner must make all appropriate adjustments to the Agency's records, and discuss the problem with the employer. The Comments Section should include an explanation of any variances.

The payroll posting accuracy verification for "new" employers will include a modified procedure. This modified procedure calls for tracing the wages of an employee for one quarter from a source document (such as a canceled check, check stub, time card, etc.) to a different payroll record maintained by the employer. A trace to the employer's copy of the quarterly wage report and to the wages posted on the TWC wage system is not possible for new employers because those items do not exist. However, a trace of wage payments should be possible from a payroll source document through to the last employer record used by the Auditor to prepare the employer's quarterly reports. In cases where the only payroll record that exists is the source document, the Auditor must explain in the final audit report why the verification of the payroll posting system could not be conducted.

For converted audits, which involve obtaining an employer's delinquent quarterly reports, the payroll verification should be done using a previously reported quarter within the audit scope. If no quarters have been reported within the audit scope, the Auditor should perform the payroll verification using available records such as in the case of auditing "new" employers or explain in the audit report why the verification could not be accomplished.

Picture of Audit Work Papers Schedule Two

4.6.1   Schedule Two Fields:

EMPLOYER NAME Displays the employer's name.
AUDIT SCOPE Displays the audit period, i.e. 1/1/YY - 12/31/YY.
ACCOUNT NUMBER Displays employer's account number.
RECORD TYPES Mark the record types used to verify the employer's payroll posting system. One record MUST be a source document.
EMPLOYEE NAME Displays employee's full name.
SOCIAL SECURITY NUMBER Displays the employee's social security number.
PERIOD(S) REVIEWED Displays the quarter/year reviewed.
PAYROLL DOCUMENTS EXAMINED Program will enter the record number(s) for each the record types selected.  One record type MUST be a source document.
CHECK Enter the check numbers, if known; enter DD for direct deposit, EFT for electronic funds transfer, or cash.
GROSS Enter the gross amount of the payment. If the gross amount is not known, enter the net amount in the next column.
NET Enter the net amount of the payment if the gross amount is not known.
TOTAL Program computes the totals for the gross and net amounts of the payments.
AS REPORTED-TWC C-4 Displays the amount reported by the employer for this employee.
DIFFERENCE Program computes any difference between the audited total gross amount and what was reported for this employee by the employer.
COMMENTS Enter comments about the acknowledged payroll system.  If problems with the payroll posting system were found, identify them, and then proceed to make adjustments to correct the problem for all affected employees.   All comments will appears as “S2Cmnmt” on the C-51 Field Audit Report.

Reference: Chapter 7 – "TPS Acceptance Sample Rationale", Question #4, and Chapter 6 – "Questions from Field Offices", Questions 18 – 20 for additional information.


firstpreviousnextlastTax Menu


Texas Workforce Commission  |  Unemployment Tax

Last Revision: May 06, 2011