MN qurately unemp. report T001 not showing correct amount

[Former Member]

Hi Expets,

FOR MN state in the quartely unemp. report the

6. TOTAL GROSS WAGES PAID DRUING THE QUARTER (tax form filed t001) is not showing right amount. It should include employee gross pay, medical wage types, FSA.. but not 401k wage type. In my case it is also including 401k amount.

Where can i check if 401k is part of this tax form field T001?

Appreciate your input.

Thanks

[Former Member · Accepted solution]

First go to table V_T51T8-find your T001 Tax form field. Get the Tax form group assigned to Tax form field T001.

Then go to table V_51TA_B and see which wage type is assigned to your Tax form group and make the necessary changes.

Arti

[Former Member · Accepted solution]

Hi Arti,

Thanks for the response.

The tax form group assigend to T001 tax form field is 0E10. But i dont see any wage type assigned to this group in V_51T0_B.

Not sure how the system is calling the wage types.

Suggest me.

Thanks

[Former Member · Accepted solution]

I see /610 wt assgined to Tax form group 0E10 for tax field T001.

[Former Member · Accepted solution]

I think this is right. Most of the states in United States requires you to report /610 WT. So if your earning WT is checked to cumulate to /102 then it will be used.

Arti

[Former Member · Accepted solution]

Hi Arti,

Yes, most of the United states are required to report /610 WT in quarterly unemp. tax report. According to what i view, i see some wrong calculation happening for MN /610 WT , i compared this with other states and they look fine. even in the configuration if i try to make any corrections to this WT it will impact other state changes too which i dont not want.

Does any body else having this issue?

Appreciate your help.

Thank you.

[Former Member · Accepted solution]

Did you try to reconcile it with Payroll reconcliation report? How do you know it is a wrong calculation?

Do the reconciliation based on total employee view in payroll reconciliation report. Take the numbers from both (tax reporter and payroll recon) on spreadsheet and find out the discrepancy.

Arti

[Former Member · Accepted solution]

Hi Arti,

I did the Payroll reconcliation report and compared it with tax repot result. Both of them look same.

According to our Payroll business analyst, it is showing wrong calculation as 401k amount is include in the MN /610 state calculation. But for the MN /610 fedral it is showing correct amount.

Ex: /610 TB ER Unemployment Tax 01 1,516.75

/610 TB ER Unemployment Tax 02 1,451.37

Both the above amounts are different.

Do you have any idea where in system we def. what wage type includes in /610 calcuation.

Appreciate your help.

Thank you

[Former Member · Accepted solution]

I have few questions to you.

1. What is the amount from EE's payroll results for that quarter? 516.75 or 451.37?

2. Check the tax authority or tax level for tax form field T001. Keep it blank.

3. Is there error or warning in log manager when you run form?

4. Is it happening for all employees?

Arti

[Former Member · Accepted solution]

In the employees payresult log, /610 01 1516.75

/610 02 1451.37

and this is same even in the payroll reconcilation report.

2. No tax authority and tax level is assigned for tax form field T001. It is blank.

3. No error or warning message are in the log manger.

4. We just have one employee in MN state is he is the only one who is having the problem. But for other states we don't see this problem.

[Former Member · Accepted solution]

Again two things for you:

1. Check OSS note 1361552.

2. Check payroll results of the employee with earning wage type. Check their PRCL 71 and cumulation type 2 401(k) Wages.

Arti

[Former Member · Accepted solution]

Hi Arti

Note 1361552 refers to version ECC 6 which we are not on. Ours is 5.0 We checked the PCL 71 for 401k wage and it is cumulaiton type L. As 401k is a pre tax wage type i assume it should not be 2. Even if i make change on this it will impact even other states for who it is working fine.

I assume it might have to do something with the tax combo.

Thank you.

[ted_dinh · Accepted solution]

If I understand correctly, MN Unemploment is reporting correctly; the problem is within payroll (ie. /610 ytd for MN in cluster is including 401K wt) . If you don't want 401K wage to be included in /610 for MN, you can re-configure tax model for MN , resident/work = 'U', tax class = 'L' (pclass 71 for your 401K wage) to point to a different tax type combo now (i.e. include all tax types currently in the existing type combo excluding tax type '10').

[Former Member · Accepted solution]

Yes, you are correct and that is what i did. I had create a new tax combo and assigned it to my tax model. Now the results are looking fine. Thanks for check in. Points are added both to you and arti.

Thank you.