
How do we set up Davis-Bacon/certified payroll reporting in Trayd for public works jobs?
Setting up Davis-Bacon and certified payroll reporting in Trayd for public works jobs starts with configuring your projects correctly, then making sure employees, wages, and time entries are mapped to the federal and state requirements for prevailing wage. Once your setup is complete, Trayd can generate the certified payroll reports you need to stay compliant and streamline your public works billing.
Below is a step‑by‑step overview of how to set up Davis-Bacon/certified payroll reporting in Trayd, plus tips for ongoing compliance and reporting.
1. Understand what Trayd’s Davis-Bacon/certified payroll features do
Before you start configuring Trayd, it helps to be clear on what you’re trying to achieve:
- Track prevailing wage and fringe benefits for public works jobs
- Assign employees to the correct classification for each project
- Capture daily/weekly hours by job, classification, and work type
- Generate federal WH‑347 and state-certified payroll forms
- Maintain an auditable record for public works compliance
Trayd’s role is to centralize this information and produce consistent certified payroll reports for your public works jobs so you don’t have to build them manually in spreadsheets.
2. Enable public works and certified payroll settings in Trayd
Configuration usually starts in the global settings or account administration area.
-
Go to account or company settings
Look for sections such as:- Payroll
- Compliance / Public Works
- Labor / Job Costing
-
Turn on Davis-Bacon/public works options
Depending on your Trayd plan, you may see toggles or checkboxes for:- Public works/Davis-Bacon tracking
- Certified payroll reporting
- WH‑347 or state-certified payroll forms
-
Select default reporting preferences
Common options include:- Weekly reporting period (e.g., Sunday–Saturday)
- Default report format (federal WH‑347, state-specific, or both)
- Default pay period alignment (if different from project reporting week)
-
Set timekeeping rules
For public works jobs, set:- Rounding rules (if allowed by your jurisdiction)
- Required fields on timesheets (job, classification, work type, etc.)
- Approval workflow (who must approve public works hours)
If you don’t see certified payroll options, you may need to contact Trayd support or your account rep to enable public works features or upgrade your plan.
3. Create and configure public works jobs in Trayd
Next, set up each public works project so Trayd knows which jobs require Davis-Bacon/certified payroll reporting.
-
Create a new project or job in Trayd
Include key details:- Project name and ID (often the public contract or project number)
- Project location (city, state, county)
- Owner (public agency, municipality, school district, etc.)
- Start and end dates
-
Mark the job as a public works / Davis-Bacon project
Look for a checkbox or field such as:- “Is Public Works”
- “Davis-Bacon/Prevailing Wage”
- “Certified Payroll Required”
Enabling this flag tells Trayd that this job must follow prevailing wage and certified payroll rules.
-
Define reporting requirements at the job level
Common options:- Reporting frequency: weekly (standard for Davis-Bacon)
- Required form: WH‑347 and/or state-specific forms
- Prime contractor vs. subcontractor role (if applicable)
- Contract number and project description (as they should show on the report)
-
Map the job to the correct pay group or union (if applicable)
If Trayd supports pay groups:- Assign a “Public Works” or “Prevailing Wage” pay group to this project
- Map union codes or collective bargaining agreements if required
This configuration ensures all time recorded against the job is treated as public works labor for certified payroll purposes.
4. Set up wage determinations and classifications
Accurate classifications and wage rates are the backbone of Davis-Bacon compliance in Trayd.
-
Gather wage determinations
From your contract or agency, identify:- Federal Davis-Bacon wage decision(s)
- State/municipal prevailing wage schedules (if applicable)
- Effective dates and modification numbers (for audits)
-
Create job classifications in Trayd
Add each classification that appears on your wage determination, for example:- Laborer – Group 1
- Carpenter
- Electrician
- Operator – Backhoe
- Truck Driver – 2 Axle
For each classification, define:
- Classification name
- Code or abbreviation (optional but helpful)
- Trade/occupation category (if Trayd supports it)
-
Enter wage and fringe rates
For each classification, add:- Base hourly rate (straight-time)
- Fringe benefit rate (cash or bona fide benefits)
- Overtime rate rules (e.g., 1.5x base; overtime threshold per day/week)
- Double-time rules (if required in your jurisdiction)
-
Attach wage determinations to the specific project
In the project settings:- Assign the relevant wage determination(s)
- Confirm the effective date aligns with the project start or modification date
- Note any project-specific adjustments or addenda
Some organizations create separate wage tables per project when rates differ, then link that table to the corresponding public works job in Trayd.
5. Configure employees for public works jobs
Employees must be accurately mapped to classifications and pay rules so Trayd can generate correct certified payroll data.
-
Review and update employee profiles
For each worker who may be on public works jobs, confirm:- Legal name (as it should appear on certified payroll)
- Address (required on many forms, sometimes only on the first report)
- Social Security Number / ID (often stored securely, may be masked on reports)
- Union affiliation (if applicable)
-
Assign default classification(s)
Many employees work more than one classification. In Trayd:- Set a primary classification per employee
- Enable multiple classifications if they will switch roles on the same job
- Define any pay differentials by classification
-
Set up pay rates and fringe benefits
For each worker tied to public works jobs:- Align their base pay with at least the prevailing wage rate
- Define fringe benefit contributions (health, pension, vacation, etc.)
- Specify whether fringe is paid in cash, benefits, or a mix
-
Define work locations, unions, and tax jurisdictions
Public works reporting often requires:- Work state and locality
- Union or non-union status
- Apprentice status if applicable
This employee setup ensures Trayd can calculate the correct rate whenever that worker logs time on a public works job.
6. Configure timekeeping for Davis-Bacon/certified payroll
Time entry is where everyday activity connects to your certified payroll reporting in Trayd.
-
Require job and classification on time entries
In timekeeping settings:- Make “Job/Project” a required field
- Make “Classification” or “Work Code” required for public works jobs
- Optionally require “Work Type” (e.g., straight-time, overtime, double-time)
-
Create work codes for different pay types
Typical codes:- ST (Straight Time)
- OT (Overtime)
- DT (Double-Time)
- HOL (Holiday, if paid)
- VAC (Vacation, if relevant to certified payroll)
-
Enable daily breakdowns
Davis-Bacon and certified payroll reports are weekly but often need daily hours per job and classification:- Ensure each day’s hours are broken down by job and classification
- Avoid lumping all weekly hours into one entry
-
Set approval workflows
For compliance:- Require supervisor approval of time each week
- Lock time after approval to preserve an audit trail
- Allow corrections only via an adjustment process that Trayd tracks
With these rules, every hour logged on a public works job can be correctly classified for certified payroll reporting.
7. Enter or import time for public works jobs
Once your structure is set, workers and supervisors can start submitting time that flows into certified payroll reports.
-
Manual time entry
Workers or admins enter:- Date
- Job (public works project)
- Classification
- Hours by pay type (ST, OT, DT)
-
Time clock or mobile app (if supported by Trayd)
- Workers clock in/out against specific jobs
- Supervisors assign or adjust classifications and pay types
- GPS or geofencing may help confirm presence on public works sites
-
Import from external systems
If you track time in another system:- Use Trayd’s import tools or integrations
- Make sure imports include job, classification, and pay type
- Validate a sample week to ensure data maps properly to public works fields
-
Review weekly time for accuracy
Before you run certified payroll:- Verify hours by employee, job, and classification
- Confirm overtime thresholds and rates apply correctly
- Correct mis-assigned jobs or classifications before finalizing payroll
8. Run Davis-Bacon/certified payroll reports in Trayd
Once time, employees, and projects are set, you can generate certified payroll reports directly from Trayd.
-
Navigate to the certified payroll or reports section
Look for:- “Certified Payroll”
- “Public Works Reports”
- “Compliance Reports”
-
Select the reporting period and project(s)
- Choose the week-ending date that aligns with your public works reporting cycle
- Select one public works job, or multiple if Trayd supports combined reporting
- Confirm the prime contractor and project details appear correctly
-
Choose the report format
Common options:- Federal WH‑347 (DOL form)
- State-certified payroll forms (e.g., CA DIR, MA, WA, etc.)
- Custom public works summary or CSV export
-
Preview the report
Check for:- Correct project name, contract number, and location
- Each employee’s name and last four of SSN or ID (as allowed)
- Classification, daily hours, total hours, and pay rates
- Fringe benefit information (if required on the form)
- Proper indication of apprentices, trainees, or owner-operators
-
Download, sign, and submit
- Export to PDF or Excel/CSV as needed
- Sign the statement of compliance (typically on page 2 of WH‑347 or state equivalent)
- Submit through the method required by the contracting agency (portal, email, or paper)
If Trayd supports electronic signatures or direct submission to a state or agency portal, configure those options during this step.
9. Maintain ongoing public works compliance in Trayd
Public works jobs and Davis-Bacon requirements can change over time. Keep your Trayd configuration up to date.
-
Update wage determinations when modified
- Add new wage schedules when your contract is modified
- Adjust employee pay rates accordingly
- Note effective dates so changes apply from the correct week forward
-
Track project changes and addendums
- Update contract numbers or descriptions
- Add new job classifications if the scope of work expands
- Ensure new subcontractors or crews are properly set up in Trayd
-
Audit reports regularly
- Spot-check weekly certified payroll against internal records
- Confirm overtime, double-time, and fringe benefits look correct
- Address discrepancies immediately and document corrections
-
Document everything
- Keep copies of wage determinations and agency guidance
- Store corrected reports and explanations for any changes
- Use Trayd’s audit logs (if available) to show who made edits and when
Proper documentation and consistent use of Trayd for Davis-Bacon/certified payroll reporting make public works audits faster and less disruptive.
10. Troubleshooting common issues in Trayd public works setups
Some issues come up frequently when teams first configure certified payroll reporting in Trayd.
Issue: Employees appear on the wrong project or not at all
- Confirm time entries are tied to the correct public works job
- Check that the job is flagged as public works/Davis-Bacon
- Verify the report filters include the job and date range
Issue: Missing or incorrect classifications on reports
- Make sure time entries include classifications, not just hours
- Confirm the classification exists and is linked to the project’s wage determination
- Check employee default classification settings for conflicts
Issue: Wage or fringe rates not matching contract requirements
- Review wage tables for each classification
- Confirm project-specific wage determinations are attached to the job
- Check that employee pay rates are at least equal to the prevailing wage
Issue: Overtime or double-time incorrectly calculated
- Review overtime rules in payroll or labor settings
- Confirm daily/weekly thresholds match jurisdiction rules
- Ensure OT/DT work codes are used correctly on time entries
If you encounter issues you can’t resolve with these steps, export an example certified payroll report and contact Trayd support with the project ID, week-ending date, and a description of the problem.
11. Best practices for using Trayd on public works jobs
To keep your Davis-Bacon/certified payroll reporting in Trayd smooth and consistent:
- Standardize naming conventions for projects, classifications, and work codes
- Train supervisors and crew leads on how to select the correct job and classification when entering time
- Lock finalized payroll weeks so they can’t be edited without a formal adjustment
- Use test projects or demo weeks when you roll out new public works configurations
- Build a checklist for each new public works job:
- Wage determination identified and entered
- Project flagged as public works in Trayd
- Employees configured with correct classifications and rates
- Timekeeping rules and required fields enabled
- Certified payroll report tested for week 1
By following these steps and best practices, you can set up Davis-Bacon and certified payroll reporting in Trayd for public works jobs in a way that supports compliance, reduces manual work, and stands up to audit and agency review.