cancel
Showing results for 
Search instead for 
Did you mean: 
HCoKP
Level 3

401k Loan Repayment incorrectly ending withholding amount

I have a client who had previously entered a 401k Loan Repayment payroll item in their QB Desktop payroll and the deduction has been working fine.  I, myself as the accountant, have checked the setup of both the Payroll Item and the Employee Specific setup and both are correct.  The payroll item has no default limit or default amounts to withhold setup in it, those are managed at the employee setup level.  In the employee setup the weekly amount is setup correctly at $107.68 and the one time limit max is setup as $4199.91.  I have also verified on the payroll summary report that this employee's YTD deductions are only $3017.17 -- meaning they still have $1182.74 remaining to pay.  However when the client goes to create a new paycheck, this employee deduction amount is calculating as ZERO.  Which is obviously incorrect. 

 

1) Any ideas why this could be happening?  If I go in and change the employee deduction limit on the item to a fake number lets say $10,000, the paycheck deduction amount of $107.68 then does calculates correctly. but when I change the deduction limit back to its actual amount $4199.91, the repayment amount ceases to calculate.  So it appears that somewhere behind the scenes the amount withheld is glitching.  This employee DID have a previous 401k Loan withholding setup under a previous separate pay item back in 2023 ("401k Loan Repay #1), but that pay item/deduction has not been used at all in 2024.  Only the item "401k Loan Repay #2 has been used in 2024.

 

2) is there any where i can see exactly how QB is calculating the computed withholding amount? Many years ago I feel like there was a keyboard shortcut like F11 or Ctl + ___ that would pull up an additional window that outlines the step by step computation from behind the scenes in QB, but for the LIFE of me I can't remember what it was.

4 Comments 4
FishingForAnswers
Level 9

401k Loan Repayment incorrectly ending withholding amount

@HCoKP  Well, this behavior does sound exactly like what you'd expect with a one-time limit payroll item that's been used in more than one year. Otherwise, raising the limit wouldn't fix the issue.

 

At the risk of asking something obvious, you don't seem to have explicitly stated that the '401k Loan Repay #2' item was not used prior to 2024. If you run a QuickReport on that specific item for the 'All' date range, do you see anything prior to 2023, especially for this particular employee?

AbegailS_
QuickBooks Team

401k Loan Repayment incorrectly ending withholding amount

I appreciate your detailed explanation of the issue with the 401k Loan Repayment deduction calculation in QuickBooks Desktop, @HCoKP. I'll share troubleshooting instructions to ensure accurate deductions in your payroll processing.

 

To start with, you can run a payroll check-up, this will help identify any discrepancies or issues with the payroll items and ensure that all settings are configured correctly to reflect the desired withholding amount accurately.

 

Here's how: 

 

  1. Create and save a backup of your company file.
  2. Go to Employees, then My Payroll Service.
  3. Choose Run Payroll Checkup.
  4. Select Data Review. 
  5. In the Review your payroll data window, select No to allow the Payroll Checkup to create wage base discrepancy adjustments.
  6. Click Continue, then Finish.

Additionally, if needed, consider processing a liability adjustment for the 401(k) loan repayment to align the Year-to-Date (YTD) amounts with the actual deductions made, thus maintaining the integrity of your financial records.

 

Furthermore, various payroll and employee reports can help you manage payroll and keep track of employee expenses in QBDT. You may want to check out this article as your reference to guide you in customizing them to get the data you need: Customize payroll and employee reports.

 

I'm here to help with any other concerns you may have about running the correct payroll in QuickBooks. Don't hesitate to leave a reply below.

HCoKP
Level 3

401k Loan Repayment incorrectly ending withholding amount

that was the issue! Client reused same payroll item in 2023 and it was accumulating the total from 2023-2024 together.  Totally my own fault for taking the client's word for it that they "just started the loan in 2024."  I usually catch dumb little things like this but guess my brain is still in vacation mode.  Thanks!

HCoKP
Level 3

401k Loan Repayment incorrectly ending withholding amount

@FishingForAnswers response/resolution above was directed for you!

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

Need to get in touch?

Contact us