Getting Buildertrend and JobTread time clock hours into QuickBooks Online
Your crew clocks in on the jobsite app. Here is how those hours reach the right house in QuickBooks Online, why labor cost sometimes shows up twice or not at all, and a monthly check that catches it.
Short answer: Buildertrend and JobTread both send approved time clock entries to QuickBooks Online as time activities. Each app user must be linked to a QuickBooks employee, and each job should be linked to a customer or project, or the hours arrive without a house. The labor cost then depends on which method your QuickBooks projects use.
Labor missing from your houses in QuickBooks? Our team can trace it. Request a Relationship Assessment.
What moves, and when
| Buildertrend | JobTread | |
|---|---|---|
| What syncs | Approved Time Clock shifts become QuickBooks time activities | Approved time entries become QuickBooks time activities |
| When | Automatically on approval if "Create a new QuickBooks time activity from a Time Clock shift when approved" is on; otherwise Send to QuickBooks on each shift, or in bulk from the Time Clock dashboard | Automatically once approved. A JobTread setup walkthrough by Smith and Co says you set a sync start date under Settings, Integrations, Employee Mapping |
| Employees | Each internal user must be linked to a QuickBooks employee. Buildertrend does not create employees in QuickBooks | Only users mapped to a QuickBooks employee sync |
| House | Comes from the job's link to a QuickBooks customer, sub-customer or project. Buildertrend can push time even when the job is not linked | The job maps to a QuickBooks customer or project |
| Cost code | Maps to a QuickBooks product or service | Maps to a QuickBooks product or service |
| Where it lands | Time Entry or Weekly Timesheets, depending on your QuickBooks account and payroll subscription | Weekly timesheet time activities, not the QuickBooks Time app |
Both tools push time one way, from the field app to QuickBooks Online. Changing an hour in QuickBooks does not change the app, so make corrections where the time started.
Set it up once, in this order
- Create every field employee in QuickBooks Online first. Buildertrend's setup guide says it will not create them for you, and JobTread only syncs mapped users.
- Link every job to its customer or project before anyone clocks in on it. See Buildertrend sync settings or JobTread sync setup.
- Map labor cost codes to products or services that point at your labor account in cost of construction, so labor lands in the right place on the P&L.
- Set up a general or shop job for PTO, holidays, training and shop time, so those hours do not land on the last house someone worked.
- Decide on billable. Buildertrend lets you mark shifts billable before sending. If you invoice from Buildertrend or JobTread, leave time non-billable in QuickBooks so unbilled time does not pile up on customers there.
Hours are not dollars
A time activity is hours. How those hours become labor cost on a QuickBooks Online project depends on a setting most builders never look at. Intuit's help describes two methods:
- Payroll expenses. Actual wages and employer costs from payroll. They only post to the project after payroll runs. If your payroll runs outside QuickBooks, you enter it yourself to payroll expense accounts.
- Hourly cost rates. Hours times a fully burdened rate per employee, set in Projects. They show right away, but Intuit warns they apply only to time tracked after the rate is set.
The switch between the two in a project changes every project, not just that one. Intuit also notes that the project profitability report uses payroll expenses, while the Time Activity tab and the time cost by employee report use only hourly costs. That is why two QuickBooks screens can show different labor for the same house. For how to build the rate, see labor burden in builder job costing; for reading the report, see the project profitability report.
Four ways labor goes wrong
- Hours with no house. Buildertrend's troubleshooting guide says time can push without a customer or project if the job was not linked. Fix it by editing the time activity in QuickBooks, or delete it, fix the job link and push again.
- Hours that never arrive. An employee who is not mapped, or a JobTread sync start date set too late, leaves hours in the field app only. Buildertrend's guide also points to unmapped cost codes and users when shifts will not push.
- Rates set after the fact. Hourly cost rates entered in March do not cost January's hours.
- Labor counted twice. If payroll is posted to each house by journal entry and hourly costs are also feeding the job report you use, the house carries labor twice. Pick one source for labor cost on each report and write it down.
A monthly labor check
- Approved hours in Buildertrend or JobTread for the month equal hours in QuickBooks Online for the same dates.
- No time activities with a blank customer or project.
- PTO and shop hours sit on the general job, not a house.
- Labor cost by house ties to the payroll register for the period, within the burden you expect.
- Field app job cost and QuickBooks agree for labor. Our tie-out guide covers the rest of the costs.
We do not run payroll. Your payroll provider handles pay, withholding and payroll taxes. Our part is making sure the cost of your crew lands on the right house.
How we help
Our team maps employees, jobs and labor cost codes, fixes hours that arrived without a house, and ties labor by house to your payroll every month. Our founder reviews every close. We quote a flat monthly price for each builder, starting at $1,500 a month, with typical engagements between $2,500 and $8,500 a month. Start with a $1,500 Margin Review for written findings. See job costing, construction bookkeeping, pricing or request a Relationship Assessment.
Sources
- Buildertrend Help, QuickBooks Online and Intuit Enterprise Suite Integration Overview (pushing Time Clock entries)
- Buildertrend Help, QuickBooks Online Initial Setup (Time Clock option, linking internal users to employees)
- Buildertrend Help, QuickBooks Troubleshooting Guide (time entries that will not push or arrive without a customer or project)
- JobTread, QuickBooks Online Integration (time entries to time activities)
- JobTread Help, QuickBooks Online Workflow
- JobTread, Time Tracking (approved hours pushed to QuickBooks time activities)
- Smith and Co, Day 4: Integrate with QuickBooks (JobTread employee mapping and sync start date)
- Intuit, Track hourly labor costs and profitability by project in QuickBooks Online
Common questions
Does Buildertrend time clock sync to QuickBooks Online?
Yes. Approved shifts become QuickBooks time activities, automatically if the time clock setting is on, or by Send to QuickBooks on each shift or in bulk.
Does JobTread sync time to QuickBooks Time?
No. JobTread pushes approved time entries to QuickBooks Online time activities, and only for users mapped to QuickBooks employees.
Why did my hours arrive in QuickBooks without a customer or project?
The job was probably not linked to a QuickBooks customer, sub-customer or project. Edit the time activity, or delete it, fix the link and push it again.
Why does QuickBooks show different labor cost on different project screens?
Projects can use payroll expenses or hourly cost rates. Intuit notes some views use only hourly costs, while the project profitability report uses payroll expenses.
Should I mark synced time billable in QuickBooks?
Only if you invoice that time from QuickBooks. If you invoice from Buildertrend or JobTread, leaving it non-billable avoids unbilled time piling up on customers.
Do you run payroll?
No. Your payroll provider handles pay and payroll taxes. We make sure labor cost lands on the right house and ties to payroll.
Related
- Buildertrend and QuickBooks integration
- Buildertrend and QuickBooks Online sync settings
- JobTread and QuickBooks Online sync
- Labor burden in builder job costing
- QuickBooks Online project profitability report
- Tying out Buildertrend or JobTread to QuickBooks Online
- Glossary: labor burden
- QuickBooks and Buildertrend cleanup service
By John Mos, Founder. Updated . We do not give tax or legal advice. Please ask your CPA or attorney.
See where your margin goes, house by house.
Tell us about your homes and your books. If we are a fit, we start with a $1,500 Margin Review: written findings and a fixed quote in 10 business days, credited to your onboarding fee if you sign up.