Transcript Document

DV for Tax Module 5
Wage Item Validation
7/18/2015
1
Introduction
 Wage
item validation (WIV) is the process
by which the Data Validator verifies that
the wage record transaction counts on the
ETA581 report are accurate
 In this training you will learn the tasks
outlined in Module 5 and how to
implement them
7/18/2015
2
Agenda










Overview
Identify Modes of Data Capture
Select Samples from Each Mode
Recount Wage Items
Review wage items for completeness
Verify duplicates and corrections are not counted
Enter Information on Wage Item Validation Worksheet
Submit and Save Wage Item Validation Results
Follow Up on Wage Item Validation Errors
Review
7/18/2015
3
Overview

WIV involves recounting small samples of wage
items, comparing these recounts to what was
reported on the ETA581, and computing the
percentage of difference. Module 5 outlines the
tasks to complete, but does not indicate
specifically how to carry out these tasks. This
training will show how to complete each task in
order to satisfy the requirements of Module 5.
7/18/2015
4
Task 1
Identify Modes of Data Capture

How does your state receive wage item information from
employers?


Web, CD, FTP, Fax, Email, Form, etc
How are they processed?



If paper, how are they data entered?
If batch processed, is recount of single batch possible?
Are there front end edits?
• SSN errors
• Missing wages
• Missing names


How are corrections handled to prevent duplicates?
How is 581 count obtained?


Built as sums from each batch
Snapshot at the quarter end
7/18/2015
5
Task 2
 Set

up worksheet in DV Software
One row for each mode
7/18/2015
6
Task 3
Select Sample from Each Mode
 From


each mode:
Pick a batch or set of reports that contain at
least 150 items
Randomly select 150 of them
• Each item should contain at least:



Name, SSN, and wages for the quarter
Divide the 150 into stage 1 of 50 and stage 2
of 100 records
Set up a worksheet to track results
7/18/2015
7
Task 3
Enter ETA 581 Count for each
Batch
 On
the Wage Verification Worksheet enter
the count from the ETA581 in the “581
Count for Batch” column
7/18/2015
8
Task 4
Recount Wage Items

Manually recount the number of wage items in
each of the batches for each mode

To be a “countable” wage item - must include:

Name or SSN for employee, name or EAN for employer, wage
dollar amount (records with zero dollar amount are NOT
counted)

Make sure each record is counted only once
 Corrected wage items
• only counted if not included previously
• Do not count the original and the correction, just one or the
other
7/18/2015
9
Task 4a
 Review

and compare Stage 1 records
Count how many are complete records
• Contain Name, SSN and Wages >0
• Enter recount on DV software worksheet
7/18/2015
10
Task 4b

Obtain the system count for these same records
 If count based on cumulating wage items



How many of the records would your system have
counted
May need to review wage history files to determine
which ones were counted
If based on Snapshot

Obtain an extract of wage items included in your
sample (same EAN and SSN )
7/18/2015
11
Task 4c
 Review



erroneous records
How many duplicates?
How many incomplete records?
How many corrections were counted
incorrectly?
7/18/2015
12
Task 4d
 Determine
if Stage 2 Review is needed
based on error findings for each mode:



=0 Pass, Mode is complete
=1-3, Review remaining 100 items
=>4, Fails
• Review of the remaining 100 is not necessary
however, it may give insight for corrections
7/18/2015
13
Task 5
Enter Record on WIV Worksheet
 On
the WIV Worksheet, enter the total
number of valid wage items in the
“Recount for Batch” column

Research any errors and enter the number of
errors in each of the categories
7/18/2015
14
Task 6
 DV
Software determines percent
difference




PASS – Stage 1 with no errors
PASS – Stage 2 with 6 or less errors
FAIL – Stage 1 with 4 or more errors
FAIL – Stage 2 with 7 or more errors
7/18/2015
15
Task 7

Before submitting your results, add any
comments you may have by clicking on the “Add
Comments” button at the bottom of the
worksheet


After entering comments, click “Save”
Submit by clicking on “Transmit” button at the
bottom of the worksheet



Transmit only after all modes are completed
Must be submitted by June 10
Use the browsers File/Save As option to save a copy
for your records
7/18/2015
16
Task 8
Follow Up on Wage Item Validation
Errors
 If



errors were identified:
Establish reasons for miscounts
Correct any other errors
Discuss with programmer or person
responsible for Wage Item processing
• Are errors caused by the use of this processing
mode?
• Are these errors affecting other reports?
7/18/2015
17
In Review
The data validator’s implementation of the tasks
in Module 5 ensure that the wage item
transactions processed in the report quarter are
accurately reported.
 Researching and correcting errors caused by
the use of any particular mode of processing can
result in less errors occurring in the future.
 There should be 6 or less errors to pass.


(The WIV software is not computing this correctly at
this time)
7/18/2015
18