by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks Payroll Tip-Tracking Employee Advance/Loan Repayments

Print Friendly

Tracking employee advance or loan repayments can easily become part of your normal QuickBooks payroll function and is a must for companies that do have a policy that allows giving employees advances/loans for personal reasons.

paychecksEarlier this week, in our post QuickBooks Payroll Tip – Tracking Employee Advances or Loans, we discussed three different ways in which to record an advance or loan that was given to an employee.  Today we will discuss how to track repayment of that loan through an agreed upon payroll deduction that will continue until the loan is paid in full by the employee.

Create a payroll deduction item to record the loan repayment

If your payroll item list doesn’t currently have a payroll deduction item to record loan repayments, you will need to add one.

  1. From the Lists menu -> choose Payroll Item List
  2. Click the Payroll Item button (lower left of the window) -> choose New
  3. Select the radio button next to Custom Setup -> and then click the Next button
  4. Select the radio button next to Deduction -> then click the Next button
  5. On the Name  used in paychecks and payroll reports window -> enter the name of the deduction item (I recommend using the loan date and employee name) -> click the Next button
  6. On the Agency for employee-paid liability window you don’t need to enter an agency name since the money will be going to your own company -> from the Liability Account (employee-paid) drop down menu you want to select the Other Current Asset account that you created to record the loan – do not select an actual Payroll Liability account here -> click Next
  7. On the Tax Tracking Type window -> select None -> click Continue
  8. On the Taxes window -> no tax items should have a check mark next to them -> click Next
  9. On the Calculate based on Quantity window -> select the radio button for Neither -> click Next
  10. On the Gross vs. net window -> select the radio button for gross pay -> click Next
  11. On the Default rate and limit window -> both should be set to 0.00 -> uncheck the This is an annual limit option -> click Finish

Add the loan repayment deduction item to the employee record

  1. From the Employee Center -> Employees tab -> select and edit the employees record -> Payroll and Compensation Info
  2. Click into the first blank row of the Item column of the Additions, Deductions and Company Contributions section -> from the drop down list -> select the loan repayment item -> in the Amount column enter the agreed upon weekly amount that the employee wants deducted from his paychecks -> in the Limit column enter the total amount that the employee was loaned
employee loan deduction

Right click on the image to enlarge it

The next time that you run your payroll, the loan payment amount will be deducted from the employees paycheck AND the loan balance will be reduced by the same amount.

ALTERNATIVE METHOD

Sometimes an employee will opt to repay the loan with cash or a personal check by some agreed upon date in the future, instead of through a payroll deduction.  In this situation, when the employee gives you his payment – either in full or partially – you will record the receipt through the Record/Make Deposits window.  Select the Vendor/Other Name List entry in the Received From column -> in the From Account drop down, choose the Other Current Asset Employee Loan Receivable account -> enter other details and proceed with the deposit as usual.

employee loan repayment with personal funds

Right click on the image to enlarge it.

 

3 Responses to QuickBooks Payroll Tip-Tracking Employee Advance/Loan Repayments

Leave a Reply

About Your Host:

Nancy Smyth, Certified QuickBooks ProAdvisor

Nancy Smyth, Sunburst Software Solutions, Inc.
QuickBooks Construction & Payroll Expert


I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.


QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Search…….
Loading
Stay updated!

Sign up to receive our latest QuickBooks Tips, Tricks & News via email:


Enter your email address:

Delivered by FeedBurner


We promise NOT to sell, rent, or otherwise distribute your name and email address!

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour live webinar - $89.00 per person. Click here for more info.

certified payroll requirements webinar
QuickBooks Training

Frustrated with QuickBooks?

QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

QuickBooks Time Tracking


Save 10%/FREE 14-day trial!


QuickBooks Time Tracker