Setting up and tracking Union Fringe Benefits in QuickBooks can be a fairly straightforward task, after all Union Fringes are just a specified hourly dollar amount that the company pays to the Union on behalf of the employee.
Union fringes often consist of contributions to Vacation/Holiday, Health & Welfare, Pension, Training, and sometimes Travel & Subsistence, Savings, or Fund Administration. Depending upon the Union that you are dealing with, some of the fringe benefits could be subject to payroll taxes, while others are not.
Most of the time fringes are calculated and paid based on the number of hours the employee works on the jobsite, occasionally, however, they are a based on a percentage of gross pay.
Regardless of how they are paid (based on an hourly amount or a percentage of gross) or if they are taxable or not; in QuickBooks, each of these specific types of hourly fringe benefits should be set up in the Payroll Item List as Company Contribution items.
Now that you know some basic information about Union Fringe Benefits and how you would track them in QuickBooks, let’s take it a step further and explore some of the more complex issues.
Not every employee will have the same fringe benefit package or the same fringe benefit rates. This is where it becomes more complex. So before you begin setting things up in QuickBooks; take the time to plan things out and ask yourself these questions:
- Do my employees ALWAYS perform work under the same Work Classification/pay rate/fringe rate combination?
- Is the Work Classification/pay rate/fringe rate combination the same for all the jobs that employees work on?
- Is the Work Classification/pay rate/fringe rate combination the same for each of our employees?
Below are basic setup instructions if ALL of your employees fall under a single Work Classification/pay rate/fringe rate combination, nothing changes from job to job. In QuickBooks:
- You create company contribution items for each specific fringe benefit.
- Check the “Track expenses by job” option in the item setup.
- Create or choose the Union from the Vendor List.
- Assign appropriate Payroll Liabilities account, personally I like to create a Sub-Item of Payroll Liabilities called Union Fringes, and then create Sub-Items under that for each fringe item – it just makes it easy to see what your liability for each fringe item is at any given time.
- Assign the appropriate Expense or Cost of Goods Sold Account to record the company payments; personally I like to create a Sub-Account of Cost of Goods Sold called Union Fringes.
- Choose the applicable Tax Tracking Type, based on the information you’ve received from the Union Hall.
- If a specific fringe benefit is subject to payroll taxes, check which taxes are to be calculated on the Taxes window
- Select how the calculations are to be be performed. If the fringe rate is paid on all straight time and overtime hours worked, choose “Calculate this item based on hours”.
- Enter the hourly rate for the benefit item and make sure that the Annual Limit option is NOT checked (by default QuickBooks always has this option selected.
- Edit employee records and add the fringe benefit company contribution items to the Payroll & Compensation Information tab in the Additions, Deductions and Company Contributions section.
- When you create paychecks, QuickBooks automatically calculates the amounts for each employee.
Use the instructions above as a guideline for your QuickBooks setup.
A reader wrote to ask the following question:
We were just awarded a contract with the Department of Defense and have to pay our employees “prevailing wage” and submit certified payroll reports. I called Intuit Support to ask them about prevailing wage, certified payroll, and how to track the fringe benefits; they weren’t very helpful – they just told me that QuickBooks can produce the certified payroll report…….can you help me understand all this?
Answer:
Ok, let’s start with some basics:
- The Davis-Bacon Act of 1931 (a Federal Law) set wage rate requirements on government funded construction projects.
- All contractors & subcontractors who perform work on these public works projects, that have a value of $2,000.00 or more, are required to submit a certified payroll report on a weekly basis.
Prevailing Wage(s) rates are comparable to hourly wages PLUS hourly fringe benefit rates for the area in which the construction project is located in, type of construction it is, and the type of work employees are doing – carpenter, laborer, equipment operator, etc. Prevailing Wage Rates are found in the Contract Package and each employee must be classified and paid accordingly – these rates are often times higher than the hourly rate that you normally pay your employees.
A certified payroll report is a specially formatted payroll report, consisting of two pages:
- Certified Payroll Report – this contains information about who worked on the job, how much you paid them, etc.
- Statement of Compliance – this contains certain legal language and requires the original signature of a company official who is signing the document under penalty of perjury.
In your case, you will be required to file the U. S. Department of Labor Form WH-347 Certified Payroll Report, however, because this is a Department of Defense job – you will need to submit their Statement of Compliance (even though it has an expiration date of June 30, 2000).
Paying and tracking prevailing wage fringe benefits gets quite complicated, as they can be:
- paid to a Union on behalf of the employee
- paid to a bona-fide fringe benefit plan on behalf of the employee
- paid in cash to the employee
- or, a portion of the total hourly fringe benefit amount can be split between payments to a bona-fide plan with the balance in cash to the employee
Request our FREE 27 page eBook – 4 Ways Contractors Pay Prevailing Wage Fringe Benefits
Intuit was partially correct, QuickBooks does have an alternate/substitute Certified Payroll Report built into it – however, it is only available if you have an Enhanced Payroll Subscription AND you are using QuickBooks Premier (any flavor – Contractor, Accountant, etc) 2009 or 2010 OR Enterprise 9.0 and 10.0; but it is very different than the Federal WH-347 form.
What Intuit didn’t tell you – is that these prevailing wage projects require more than just the submission of a certified payroll reports, you may also be required to:
- submit EEOC/Work Utilization reports on a weekly, monthly or annually
- submit ARRA (American Recovery & Reinvestment Act) reports on a monthly basis
- generate Fringe Benefit Statements on a monthly basis (if you are paying the fringe benefits to the Union or a bona-fide plan)
- electronically file your certified payroll reports using Labor Compliance programs such as LCPtracker, TRS Consultants, Elation Systems, and others.
Watch a brief 10-minute video demonstrating how Certified Payroll Solution interfaces with QuickBooks to generate these reports.























