The tax form worksheet for form 940 for 2020 shows a difference (12,000)between Total Taxed Wages (155,000)and Total Taxable Futa Wages (143,000). It shows a positive amount showing that taxed wages was in excess of taxable FUTA wages by twice the amount of the National Paid Leave. .
The reason -the Total Taxable Futa Wages takes Total Payments to Employees (which is the amount after reducing for National Paid Leave) and subtracting National paid Leave Amounts that are in the section titled "Additional Exempt Payments based on Taxability Settings". This deducts the National Paid leave twice when determing the "total Taxable FUTA wages.
I would like to know if this is a bug in the report or if for some reason I have some option checked wrong.
My 940 form actually shows Total Employee Wages including the National Paid Leave and I am under the impression that the National Paid Leave is subject to FUTA.
Let's figure why the 940 worksheet shows a different amount, nna.
The form 940 doesn't include National Paid leave. The total taxable FUTA wages is coming from the amount in line 6 or line 3. You can run a report that shows the totals of all payroll items types.
Let me show you how:
Run a Payroll Item Listing report.
Filter the report and, in the Columns, clear everything but the Payroll Item and tax-tracking type, then print the report.
Place a checkmark next to any item that has a tax-tracking type.
Run a Payroll Summary report for the calendar year.
Click Customize Report.
Go to the Filterstab.
Under Current filter choices, select Payroll Item.
In the drop-down box in the middle, select Multiple Payroll Items. Check off all the payroll items you marked earlier.
Add together the Adjusted Gross Pay, Total Employer Taxes, and Contributions.
If any of them are incorrect, you need to modify the tax-tracking type. Here's how:
Go to the Payroll Item List.
Double-click the payroll item in question.
Select Next, until you get to Tax Tracking Type.
Correct the tracking type and click Next until you reach Finish.
This will correct the form, but if the taxability changed, run a payroll checkup to correct the taxable wage bases.
You can also override line 3 by adding the amount by adding the amount paid for National Paid Leave to Line 3 on the 940. And, the same amount in the "QuickBooks has determined" area of the interview page so all balances are correct.
I am puzzled by your sentence “The form 940 doesn’t include National Paid leave” at the beginning of your reply.
My concern is with the Tax Form Worksheet that shows 940 information and is generated from the More Payroll Reports in Excel option. It is not with the Form 940 that is filed with the IRS.
My research indicates form 940 should include National Paid Leave on Line 3 .
I ran the Payroll Summary report as you instructed and it agrees with the form 940 and does include the National Paid Leave on Line 3-Total payments to employees. That amount is $174,000 (fictitious number for demonstration purposes).
I do not think you and I are focusing on the same issue so I will be more specific.
The Tax Form Worksheet shows (fictitious numbers for demonstration purposes).
Total Payments to Employees
Exempt Payments - by Tax Tracking
Additional Exempt Payments based on Taxability Settings
Total taxed wages:
Total taxable FUTA Wages:
Difference (should be 0.00):
If you click on the Total Taxable FUTA wages the formula shows that the $143,000 is derived by (a) subtracting the $168,000 (which is an amount after subtracting $6000 National Paid Leave to employees ) and (b) subtracts the $19,000 which is shareholder medical ins and (c) again subtracts the $6000 National Paid Leave that is in “Additional exempt payments based on Taxablility Settings”.
The specific questions relate to this double subtraction for National Paid Leave on the “Total taxable FUTA wages” line of the worksheet. My research indicates National paid leave is subject to FUTA.
(1) why does the Tax Form Worksheet show total payments to Employees after reducing for the National Paid Leave (168,000) instead of the amount that the Form 940 shows on Line 3 which includes National Paid Leave (174,000)?
(2) Why is the National Paid Leave which is being shown in “additional exempt payments based on Taxability Settings” being subtracted at all on the worksheet?