Sage 100

PR v4.4. Client decided to enter an employee twice (different employee numbers). Each number has earnings. When we printed the W-2's in Aatrix, this was caught and we combined the records for both employees (yes, they did it twice). Now I am trying to electronically file the information with Sage's e-filing and the output file is ignoring the duplicate records. So I modified the tax summary for the record that was picked up and reran the electronic file, still no change. Does anyone know what has to be done (run a utility) to correct or what the name of the file that Sage's electronic program is pulling from?

If it's the same as Aatrix uses, it's PR_40 and PR_41

Might be easier to have Aatrix do the electronic filing for you, it would have the correct information.

PR_40 and PR_41?

Well, PR_40 has 10K detail lines so it appears to be every check. Can't figure out pr_41 yet, but I don't think that is it either. Might be bernie's suggestion or just submit electronically and have them send in paper corrections......

Epilogue - Change the first record to be the numbers you desire, delete the second record from PR3. For good measure, delete the duplicate employee from PR1. Then compare totals only to discover you are still off some. Print the w-2's to a PDF, search the PDF for the difference. Get lucky. Discover that this employee only received one check for insurance refund from the prior year. Negative deduction check does not calculate gross earnings amount, thus the YTD gross earnings amount is zero. The electronic reporting program does not generate a detail record if gross earnings is zero. Reported this bug five years ago. Still not fixed. Urgh! All is good in w-2 land now.....