Why job costs can differ between Buildertrend and QuickBooks
Owners often say the job cost in Buildertrend does not match the one in QuickBooks. On a recent build we verified the Buildertrend records in detail. We did not have a QuickBooks job-cost report for the same dates, so what follows are reasons the two can disagree, not a reconciliation.
Three stood out.
The same work can appear as an order and as a bill
We traced one approved trade order to the bills paid against it. The amounts matched to the dollar. If a report adds the Buildertrend commitment to the accounting expense, that work is counted twice.
Labor can move the forecast before it is approved
Between two exports, one job's committed and projected cost rose on a single cost code. We traced the increase to time-clock hours that had not been approved yet. Buildertrend counts unapproved shifts as committed cost, so the forecast had already moved.
We could not establish when that payroll reached QuickBooks. If it arrives later, the two systems show different costs for the same week.
Filtering to the original budget can hide real costs
In one snapshot, several thousand job cost-code rows had actual costs against an original budget of zero. A report that starts from the originally budgeted items leaves that spending out.
I would check which rows each report includes before looking for missing transactions.
Where to look first
- Is one report showing committed cost and the other actual cost?
- Are unapproved hours included on one side and not the other?
- Does either report drop cost codes that had no original budget?
- Are both reports for the same date?
Reference: Buildertrend's Job Costing Budget overview (opens in a new tab)
If you would rather have this built for you, I do it for building and remodeling firms. It starts with a small fixed-price review.