Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
July 16, 2020
Question

941 Schedule B liability line item doesn't match payroll summary

  • July 16, 2020
  • 1 reply
  • 35 views

I am working on Q2 2020 form 941.  The tax liability showing on Schedule B month 1, tenth of the month does not match what it should be per the payroll summary for that day.  The difference appears to be our COVID sick leave wages however there is still a difference of over $500.  

 

1. How do I find out where the number on Schedule B is coming from?  Is it supposed to subtract the COVID credit?

 

2. The bulk of the COVID wages we paid were in month 3 so it seems weird that it would be subtracting it in month 1.  

 

Any help would be greatly appreciated.  

1 reply

Level 8
July 16, 2020

Thanks for posting to the Community, @jennrobe.

 

Let me share some insights on how to view the 941 Schedule B liability line item.

 

QuickBooks is adding the tax liability showing on Schedule B for the total taxes accrued each day on paychecks for Federal Withholding, Medicare Employee, Medicare Company, Social Security Employee, and Social Security Company. It doesn't suppose to differ the COVID 19 credit.

 

You can run the Payroll Summary report and customize it to show the Payroll item for Federal Withholding, Medicare Company, Medicare Employee, Social Security Company, and Social Security Employee to show the amounts in Schedule B (Line 16).

 

Here's how:

  1. Go to Reports, select Employees & Payroll, then select Payroll Summary.
  2. Select Customize Report, then select the Display tab.
  3. Select Last Calendar Quarter from the Dates dropdown list.
  4. In the Display columns by dropdown list, select Month, then clear the Hours and Rate checkboxes.
  5. Select the Filters tab.
  6. Choose the Payroll Item in the Filter dropdown list, and then choose Selected payroll items in the Payroll Items dropdown list.
  7. In the Payroll Item window, select Federal Withholding, Medicare Company, Medicare Employee, Social Security Company, and Social Security Employee. Clear any other selected items, then select OK.
  8. Select OK to return to the Payroll Summary report.
  9. Ignoring any negative signs, add up each column's amounts for Federal Withholding, Medicare Company, Medicare Employee, Social Security Company, and Social Security Employee taxes. The totals should correspond to the amounts in Month 1, Month 2, Month 3, and "Total liability for quarter" of line 16.
  10. You can double-click any of the numbers on the report to see what transactions contribute to their amounts.

 

The bulk of the COVID wages you paid for from the first to third month should total the amounts in Line 13e.

 

This way, I'd suggest consulting a tax accountant to help you with the amounts.

 

I'll be adding this article as your source to know more details about how QuickBooks populates the lines on Form 941: How QuickBooks Populates The 941. It includes links on how QuickBooks fill the other forms.

 

Feel free to ask questions below if you need clarifications. I'll keep my notifications open. Take care!

jennrobeAuthor
July 16, 2020

I ran the report and I am now 100 percent certain that Schedule B liability amounts are being reduced by COVID credits.  I was able to reconcile to the penny.  

 

Is this the proper treatment to carry the credit back to the beginning of the quarter?

July 31, 2020

Did you ever find an answer on this?  I have the same problem.

 

I don't think the credit for qualified sick and family leave wages is booking correctly to the COA.  The instructions for setting up the National Paid Leave payroll items said to use the COVID19 expense account for both the liability and expense side of the transaction.  I don't think this is right.  That's why the credit is not going to the Schedule B (I think).

 

ANYBODY????