1 / 18

DV for Tax Module 5

DV for Tax Module 5. Wage Item Validation. 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

jenn
Download Presentation

DV for Tax Module 5

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DV for Tax Module 5 Wage Item Validation

  2. 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

  3. 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

  4. 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.

  5. 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

  6. Task 2 • Set up worksheet in DV Software • One row for each mode

  7. Task 3Select 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

  8. Task 3Enter ETA 581 Count for each Batch • On the Wage Verification Worksheet enter the count from the ETA581 in the “581 Count for Batch” column

  9. Task 4Recount 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

  10. 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

  11. 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 )

  12. Task 4c • Review erroneous records • How many duplicates? • How many incomplete records? • How many corrections were counted incorrectly?

  13. 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

  14. Task 5Enter 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

  15. 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

  16. 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

  17. Task 8Follow 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?

  18. 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)

More Related