QuickBooks Payroll Tip-Tracking Employee Advance/Loan Repayments
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.
Earlier 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.
- From the Lists menu -> choose Payroll Item List
- Click the Payroll Item button (lower left of the window) -> choose New
- Select the radio button next to Custom Setup -> and then click the Next button
- Select the radio button next to Deduction -> then click the Next button
- 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
- 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
- On the Tax Tracking Type window -> select None -> click Continue
- On the Taxes window -> no tax items should have a check mark next to them -> click Next
- On the Calculate based on Quantity window -> select the radio button for Neither -> click Next
- On the Gross vs. net window -> select the radio button for gross pay -> click Next
- 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
- From the Employee Center -> Employees tab -> select and edit the employees record -> Payroll and Compensation Info
- 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
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.
3 Responses to QuickBooks Payroll Tip-Tracking Employee Advance/Loan Repayments
Leave a Reply
- The Great Debate – QuickBooks Desktop vs. QuickBooks Online
- Business Apps Shouldn’t Be THAT Hard to Use – Free Webinar
- QuickBooks 2015- The Good, Bad and Ugly, Part 1
- “Overstating” the Importance of Cost Reporting-Free Webinar
- QuickBooks 2015 Announced – Important System Requirements
- How do Amazon Merchants Reconcile in QuickBooks? Webinar
- Happy 14th Birthday Sunburst Software Solutions, Inc.
- Simple Controls You Can Put Into Place to Discourage Fraud
- Business Susceptibility to Theft and White Collar Crime – Are You a Target?
- Warning Signs & Red Flags of Fraud – Are Your Employees Stealing From You?
- Is Managing QuickBooks Purchase Orders Driving You Insane?
- Free Webinar-Identify and Safeguard Against Business Fraud
- Technology is Changing How We Submit Certified Payroll Reports
- Ask Me Anything – 10 Common Questions about Certified Payroll
- Are Your QuickBooks Payroll & Certified Payroll Processes Efficient?
- QuickBooks Tip: How to find “Notes” after an Upgrade
- QuickBooks Timely Payroll Alerts, Updates & Issues for 2013 Payroll Tax Returns
- QuickBooks Tip: How to Calculate Over/Under Billings
- Happy Holiday’s to you!
- Employee Reimbursements-Accountable vs Non-Accountable Plans
- Using Account Numbers in Your QuickBooks Chart of Accounts
- Straight from the IRS - Social Security Tax Reduced to 4.2%
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- QuickBooks 2013 Upgrade Do's, Don'ts & Frequent Questions
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- QuickBooks 2012 - Frequently Asked Questions About Upgrading
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- QuickBooks Tip - Determing Cost of Goods Sold
- QuickBooks for Contractors Tip – Advanced Progress Invoicing
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- QuickBooks Tip - Child Support Garnishments
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- QuickBooks Tip-Creating a Functional Payroll Liabilities Section
- New FHWA-1391 & 1392 Annual EEO Forms For Highway Contractors
- QuickBooks Tip: Important Facts About Items Left as Billable
- QuickBooks 2012 Announced
- Frequently Asked Questions - California Prevailing Wage
- QuickBooks 2012 - Best Practices & Tips for Installing an Upgrade