QuickBooks Payroll, when properly set up, is capable of tracking and including the cost of your General Liability Insurance; as well as many of the other things that costly construction software does automatically – with a little more effort on your part and without the big price tag.
Tracking General Liability Insurance, when it is based on gross payroll, and getting those costs into Job Costing Reports is vital for many businesses, especially the construction industry.
NOTE: The best time to implement this procedure is when your General Liability Insurance Policy period starts.
The following instructions will allow you to track your General Liability Insurance costs when it is based on gross payroll and get those costs into your job costing reports without making complex journal entries. It will also help you be aware of how much your premium payment will be so that you aren’t in for an unwelcome surprise when the bill comes in or your policy is audited.
QuickBooks Setup for accruing the cost of General Liability Insurance
Example:
In our example general liability insurance is calculated at $6.36 per $1,000.00 in wages for field workers – realize that each type of work that you perform could very well have a different experience rate (just like Worker’s Comp).
Step 1:
Come up with a rate per $100 in wages so this can be calculated for each employee with each paycheck, if paychecks are usually less than $1,000.00 per employee per week.
- $1,000.00 divided by 10 = $100.00
- $6.36 divided by 10 = $0.636
If your policy has different experience rates for different work or employee classifications you’ll want to determine this cost for each different rate.
Step 2:
Create an Other Current Liability Account on your Chart of Accounts to track your Accrued General Liability Insurance. From the Lists menu –> choose Chart of Accounts –> click the Account button at the lower left –> click New –> select the radio button next to Other Account Types and choose Other Current Liability from the drop down menu.
Right click on the image to elarge it.
Click the Continue button and add the details for the account.
Right click on the image to elarge it.
Click Save & Close.
Step 3:
Create the Cost of Good Sold and/or Overhead accounts to track the expense to the company. A Cost of Goods Sold account would be used for field workers and an Expense Account for Overhead and Office workers. From the Lists menu –> choose Chart of Accounts –> click the Account button at the lower left –> click New –> select the radio button next to Other Account Types and choose Cost of Goods Sold from the drop down menu – OR – click the radio button next to Expense.
Right click on the image to elarge it.
Click Save & Close.
Step 4:
Create Company Contribution Payroll Items to track the costs while running payroll. From the Lists menu –> choose Payroll Item List –> click the Payroll Item button at the lower left –> choose New –> select Custom Setup –> click Next –> click Company Contribution –> click Next –> type in the name for this item and select the Track Expenses by Job option –> click Next –> choose your General Liability Insurance Carrier –> from the Liability Account drop down select the account you created in Step 2 –> from the Expense account drop down select the account you created in Step 3.
Right click on the image to elarge it.
Click Next –> Tax tracking type should be set to None –> click Next –> Taxes window should have no tax types checked –> click Next –> Calculate based on quantity window select the radio button to Calculate this item based on quantity –> click Next –> Default rate and limit window, enter the amount that you calculated in Step 1 and make sure that the This is an annual limit option is NOT checked. Click Finish.
Step 5:
Add the company contribution item(s) to Employee Defaults so all new employees who are hired will automatically have this item automatically included in their employee records.
From the Edit menu –> choose Preferences –> select Payroll & Employees –> click on the Company Preferences tab –> click the Employee Defaults button –> click into the Item Name column of the Additions, Deductions and Company Contribution section and select the item(s) you created in Step 4.
Step 6:
Add the company contribution item(s) to existing Employee Records in order to calculate your accrued liability when processing payroll.
From the Employee Center, edit each employee record going to the Payroll & Compensation tab –> click into the Item Name column of the Additions, Deductions and Company Contribution section and select the item(s) you created in Step 4.
Calculating General Liability Insurance Costs When Running Payroll
When running payroll you’ll want to open (view) the detail of each employees paycheck –> determine gross payroll ($280.00 + $1,120.00 = $1,400.00 – per the sample paycheck below) –> take total gross and divide it by 100 (1,400.00 divided by 100 = 14) –> enter 14 in the Quantity column next to the company contribution item and click Enter. QuickBooks will then calculate the General Liability Insurance for this employee and display that amount in the Company Summary section.
Right click on the image to elarge it.
By implementing and following this procedure your General Liability Insurance will be included in your Payroll Summary Reports, Profit & Loss, and Profit & Loss by Job Reports. Additionally, your accrued liability will be displayed on Balance Sheet Reports and can be viewed at any time simply by viewing your Chart of Accounts List.
One final note; when it’s time to pay your General Liability Insurance policy premium you will cut the check using the payroll Pay Liabilities function – DO NOT USE the Write Checks feature.
A reader wrote to ask the following question:
I have a vendor (subcontractor) whose general liability insurance expired. In QuickBooks I was able to produce a check for them. How do I QuickBooks to notify me that their insurance has expired?
Answer:
Unlike some of the more costly construction specific software programs out there, QuickBooks wasn’t designed to prevent us from generating a check to a Vendor/Subcontractor whose General Liability or Worker’s Compensation insurance has expired.
The QuickBooks Premier (or Enterprise) Contractor edition does have a “section” in the Additional Info tab of the Vendor Record where you can enter an expiration date for both Worker’s Comp and General Liability insurance – and if you enter dates in these fields you will get a warning when using a vendor whose insurance has expired – however, it will not prevent you from writing the check, entering the bill, or creating a purchase order.
In other versions of QuickBooks Pro, Premier, or Enterprise; you can create “Custom Fields” to use in the Vendor record – but they will not produce even a warning.
There are several things that you can do – but none of them will automatically “warn” you before the Subcontractors insurance does expire OR prevent you from writing them a check after it has expired.
One thing that you can do is have your Vendors/Subcontractors request a Certificate of Insurance from their insurance company, listing you as a Certificate Holder. That way you receive a Certificate showing the policy period AND you would also be notified if the coverage was canceled or if it expired.
Even having access to this information directly from the Vendors insurance agent isn’t enough if you don’t have a policy and/or procedure in place for tracking this.
While QuickBooks won’t do anything automatically for you, it will provide you with tools (date tracking, report generation, letter creation, Reminders, and To Do Notes) to implement a good system for tracking this information.
Request our FREE eBook – “QuickBooks Tips & Techniques – Setting Up & Tracking Subcontractors Worker’s Comp Insurance”.
This FREE 13-page eBook will provide you with complete instructions for setting up and maintaining a system for tracking expiration dates of Subcontractors Worker’s Comp AND General Liability Insurance.
