How to tie out Buildertrend or JobTread job costs to QuickBooks Online each month
A monthly check that the job cost your project managers see matches the books your lender and CPA see.
Short answer: After the books close, compare cost to date for each house in Buildertrend or JobTread with the same house's project in QuickBooks Online, on the same date and the same cash or accrual basis. Every difference should trace to a named transaction, such as an unsynced bill, a cost entered only in QuickBooks, a wrong job or a timing gap.
Why the two numbers drift
Most builders we meet run two systems. Project managers live in Buildertrend or JobTread, where the budget, purchase orders and bills sit by cost code. The bookkeeper lives in QuickBooks Online, where bank feeds, card charges, payroll and month-end entries land. The integration moves a lot of data between them, but not everything, and not always the same way. Without a monthly check, the job cost report in the field and the numbers in the books slowly stop agreeing, and nobody knows which one to trust.
This guide is the step-by-step version of the tie-out we describe in Buildertrend and QuickBooks integration for builders. If you are still choosing between the two tools, see Buildertrend vs JobTread.
What has to be linked first
A tie-out only works if both systems use the same keys:
- One job equals one project. Buildertrend links each job to a QuickBooks customer, sub-customer or project. JobTread maps jobs to customers or projects, and can also map them to classes.
- One cost code equals one product or service. Both tools map cost codes to QuickBooks products and services, and each product or service carries the expense account the cost lands in.
- Vendors match in both systems.
If cost codes are not mapped, costs can still reach QuickBooks but land on a default item. Smith and Co, a JobTread consultant, suggests a catch-all uncategorized product or service so those costs are easy to find and recode.
Want your software and QuickBooks tied out every month? Request a Relationship Assessment.
The monthly tie-out, step by step
- Close QuickBooks Online first. Bank and card accounts reconciled, bills entered, accruals posted. See the month-end close checklist.
- Match the basis. Buildertrend calculates actual costs from your accounting method setting. On accrual, open and paid bills count. On cash, only paid bills count. Run the QuickBooks side on the same basis, or every open bill becomes a false difference.
- Pull the QuickBooks number by house. Use the project's profitability report, or a transaction detail report filtered to the project, cost lines only, through month end.
- Pull the software number by house. In Buildertrend, the actual costs column of the Job Costing Budget. In JobTread, the job's actual cost total. Use the same cutoff date.
- Compare house by house. Houses that agree are done. For houses that do not, compare by cost code to find where the gap sits.
- Name every difference. Each one should trace to a transaction and a fix. Leave nothing as unexplained.
The usual causes, and the fix for each
- A bill that never went to QuickBooks. In Buildertrend, a bill saved without Send to QuickBooks checked stays in Buildertrend until someone sends it from the Bills list. Fix: send it, then check the date.
- A cost entered only in QuickBooks. A card charge or check that is not coded to the project and a product or service will not show on the job in either tool. In Buildertrend, QuickBooks costs only reach the budget when "Include costs entered in QuickBooks in the budget" is on for the job. Fix: code the line to the project and item, and turn the setting on where you want it.
- The same cost twice. A bill pushed from the software and a bank feed transaction added as a new expense instead of matched to it. Buildertrend's guidance is to match bills in the bank feed and remove bank rules that auto-create cost of goods sold expenses. Fix: delete the duplicate expense and match the payment to the bill.
- Edits made in two places. Buildertrend notes that once a bill is edited in QuickBooks, later edits in Buildertrend will not sync to it. Fix: pick one place to edit bills after they sync, and correct the other side by hand.
- Wrong job or wrong code. The bill reached QuickBooks on the wrong house or item. Fix: correct it in the system where you edit bills, then confirm both sides moved.
- Payments and credits. Buildertrend does not mark a bill paid until it is fully paid in QuickBooks, which matters on a cash basis. Its negative bills create vendor credits, which cannot be matched to a card refund in the bank feed. Fix: record card refunds as a credit card credit from the feed.
- Labor. Time entries in the field tool are hours at a rate. Payroll in QuickBooks carries actual wages, taxes and benefits. Expect a difference and handle it with a monthly labor burden entry. See labor burden.
- Entries that live only in the books. Accruals, reclasses and loan interest posted by journal entry are real costs that may not appear in the field tool. List them as known reconciling items each month.
Write it down
Keep a one-page tie-out per month: house, software actual, QuickBooks actual, difference, each explained item and the unexplained remainder, which should be zero. Attach it to the close. When a lender or CPA asks why the job cost report and the financial statements disagree, that page is the answer.
A SAMPLE tie-out (made-up numbers)
SAMPLE only. One house at month end, accrual basis. Buildertrend actual costs: $412,300. QuickBooks project cost: $420,450. Difference: $8,150, with QuickBooks higher.
- A $3,900 lumber bill was entered in Buildertrend but never sent to QuickBooks. Fix: send it. QuickBooks rises to $424,350.
- An $8,000 window deposit is in QuickBooks twice, once from the synced bill and once from the bank feed. Fix: delete the duplicate expense and match the payment. QuickBooks drops to $416,350.
- A $1,450 card charge was coded in QuickBooks to the project and item, but this job does not include QuickBooks costs in the budget. Fix: turn the setting on. Buildertrend rises to $413,750.
- A $2,600 labor burden journal entry lives only in QuickBooks. Known reconciling item.
After the fixes, the only difference left is the $2,600 labor burden entry, which is listed and expected.
When it is too far apart to tie out
If a house is off by more than you can trace in an hour, the mapping or the history is usually the problem, not one bill. That is a cleanup project before it is a monthly routine. See QuickBooks and Buildertrend cleanup.
How we help
Our team ties out Buildertrend or JobTread to QuickBooks Online for every open house in the monthly close, fixes the causes at the source and keeps the tie-out page with your reports. 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 construction bookkeeping, cleanup, pricing or request a Relationship Assessment.
Sources
- Buildertrend, QuickBooks Online Integration overview
- Buildertrend, Managing bills and expenses (Advanced QuickBooks Online integration)
- Buildertrend, QuickBooks FAQs
- Buildertrend, Job Costing Budget overview
- Buildertrend, Job Costing Budget columns (Client Portal FAQs)
- JobTread, QuickBooks Online integration
- Smith and Co, Day 4: Integrate with QuickBooks (JobTread setup)
- Intuit, How to use project profitability reports
Common questions
Why does Buildertrend job cost not match QuickBooks?
Usually a bill that was not sent, a cost entered only in QuickBooks without the project and item, a duplicate from the bank feed, a wrong job, or a cash vs accrual mismatch.
How often should I reconcile Buildertrend or JobTread to QuickBooks Online?
Monthly, after the books close, for every open house. Large houses or messy months may need a mid-month check too.
Should I compare totals or cost codes?
Start with totals by house. Only drill into cost codes for houses that do not agree.
Do costs entered in QuickBooks show up in Buildertrend?
They can. The job must have the setting to include QuickBooks costs turned on, and the cost must be coded to the linked project and a product or service.
Will the two ever match exactly?
Often not, because some entries only live in the books, such as labor burden or accruals. The goal is that every difference is named and expected.
Can you do this tie-out for us?
Yes. Our team does it for every open house as part of the monthly close and fixes the causes at the source.
Related
- Buildertrend and QuickBooks integration
- JobTread or CoConstruct to QuickBooks Online
- Buildertrend vs JobTread
- QuickBooks and Buildertrend cleanup
- Construction bookkeeping
- Glossary: Job cost tie-out
- Request a Relationship Assessment
- Do builders need QuickBooks with Buildertrend or JobTread?
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.