cancel
Showing results for 
Search instead for 
Did you mean: 
teresak1209
Level 1

Payroll liabilities report not correct

I just finished payroll and ran (as I typically do) the Payroll Liabilities Report. However, it is not even close to being correct. For example, it shows $208 for Federal withholding where it should be around $2400. Why is this happening?

Solved
Best answer March 14, 2024

Best Answers
teresak1209
Level 1

Payroll liabilities report not correct

Thank you for the replies. I figured out the issue eventually. I typically run payroll liability reports for the pay-period, in this case 3/1 - 3/15, however I had processed one check outside of the standard group but on the same day. The answer was to run the report for the date range of 3/13 - 3/13. Not sure why QB decided to be finicky but at least the issue was resolved.

View solution in original post

4 Comments 4
Erika_K
QuickBooks Team

Payroll liabilities report not correct

Welcome to the QuickBooks Community forum, teresak. 

 

Let's explore ways to narrow this down and ensure you can accurately run your Payroll Liabilities Report. 

 

The dates of transactions are crucial in determining their inclusion in a liability report. Depending on the entry type, the transaction date or the ending date of the affected period is used to determine if a transaction will appear on a liability report.

 

We may need to expand or narrow the date range of the report to determine the source of the balance.

 

For the following examples, a report dated 5/1/2015 through 7/30/2015 will include:

 

  • Paychecks. The transaction date on paychecks is used. A paycheck dated 5/1/2015 for the pay period 4/15 - 4/30/2015 will be included. A paycheck dated 8/1/2015 for the pay period 7/15 - 7/30/2015 will not be included.
  • Employee year-to-date (YTD). The transaction date on these entries is used. The transaction date is the same as the period ending date, so any entry dated within the report range will be included.
  • Payroll liability checks. The liability period-ending date is used. A liability check dated 8/15/2015 that paid for a period ending 7/30/2015 will be included in the report. A liability check dated 5/15/2015 that paid for a period ending 4/30/2015 will not be included.
  • Prior payments. The liability period ending date is used. A prior payment dated 8/15/2015 that paid for a period ending 7/30/2015 will be included in the report. A prior payment dated 5/15/2015 that paid for a period ending 4/30/2015 will not be included.
  • Liability adjustments. The effective date of the adjustment is used. A liability adjustment dated 8/15/2015 that paid for a period ending 7/30/2015 will be included in the report. A liability adjustment dated 5/15/2015 that paid for a period ending 4/30/2015 will not be included.

 

Also, if payroll liabilities were paid through Bill Payment or Write Checks, this will not reduce your payroll liabilities and cause a balance.

 

I'll add these resources to help you with handling your employee's paycheck info: 

 

 

You can comment below, if you have additional concerns about running the Payroll Liabilities Report. Keep safe!  

BigRedConsulting
Community Champion

Payroll liabilities report not correct

Well, the report is based on your paychecks. You can double-click on any number to see the details to verify the totals. If the details look wrong, try opening a paycheck and the detail area to see them there. That might make it obvious what has happened. If (say) the taxes are mostly 0.00, that could mean you're using an out dated payroll tax table or your subscription has lapsed and so taxes stopped calculating.

BigRedConsulting
Community Champion

Payroll liabilities report not correct

@Erika_K  RE: For the following examples, a report dated 5/1/2015 through 7/30/2015 will include:

 

When you copy/paste a pat answer that is 9 years out of date, it make it rather obvious you did that - that you didn't write the answer and I'd guess didn't really read the OP's question either.

 

In any case, the OP didn't ask for a lesson on report date ranges.

teresak1209
Level 1

Payroll liabilities report not correct

Thank you for the replies. I figured out the issue eventually. I typically run payroll liability reports for the pay-period, in this case 3/1 - 3/15, however I had processed one check outside of the standard group but on the same day. The answer was to run the report for the date range of 3/13 - 3/13. Not sure why QB decided to be finicky but at least the issue was resolved.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us