941 error on database with combined 941 and 943 employees

[braathwaate]

I have a company with both 941 and 943 employees. Normally, such as when I ran the 1st quarter with an earlier paywindow version, lines 2, 5a and 5c are all the same, and match the total I get from running the employer totals report on those employees. However, the 2nd quarter with version 10.0.23, line 2 does not match and none of the lines match the number I get from the employer totals report.

[Paul Mayer]

If you are referring to the 941 Form, the only employees that show up on it are the regular employees as the payroll transactions marked as Agricultural employees are excluded and they show up on the 943 at the end of the year. All employees wages show up on the Employer Totals Report.

Because of this read the information for Item 17 in the help file at this page:

http://zpay.com/pw-online-help/module_10_1.htm?mw=MjMw&st=MQ==&sct=MzI5&ms=AAA=#id_01A87140_17

It's too late for this year but think about following the bold text instructions next year as it simplifies things.

[Paul Mayer]

The 941 is the audit form and if it is off, most likely you've done something wrong with one or more things for the non-agriculture worker. This FAQ describes things that cause a problem:

http://zpay.com/vbulletin/showthread.php?3274-941-Form-Numbers-Do-Not-Match-Employer-Totals-Report

It would be best to review all transactions to find the problem and delete and redo them correctly.

[braathwaate]

I narrowed down the problem to a handful of transactions for a 943 employee. I verified the problem by deleting 943 employee transactions in a database copy and noting the impact on the 941 form. Next I tried deleting the transaction and recreating the transaction, but the 941 report still erroneously picked up the 943 employee transaction in its totals. I triple checked that this employee was a 943 employee and triple checked the transaction. I could not find anyway to prevent the 941 form from picking up this 943 employee transaction. Next I made two copies of the database, and painstakingly deleted all the 941 employee transactions out of one and the 943 transactions out of the other. With the 943 employee transactions separated out of the 941 employee database, the 941 form now works correctly and matches the employers totals report. The employer totals report reports the same value on the old combined database (for the 941 employee code range) and on the new separated 941 database.