Guide

Buildertrend and QuickBooks Online sync settings: what syncs and which way

The Buildertrend accounting settings that decide when bills and invoices reach QuickBooks Online, what comes back and how your job costing budget fills in.

Short answer: Buildertrend pushes bills, invoices, credit memos and approved time to QuickBooks Online, and payments recorded in QuickBooks mark them paid in Buildertrend. Costs entered in QuickBooks flow back to the Job Costing Budget when they use your mapped products and services and the job's linked customer or project. Your sync settings decide when each push happens.

Why do Buildertrend and QuickBooks Online job costs not match?

Job costs usually do not match because a cost is not coded to a mapped QuickBooks product or service, sits on a different QuickBooks customer or project than the linked job, was entered in both systems, or is on a different accounting method. Fix the mapping and linking, pick one place to enter bills, and compare both job reports monthly.

SymptomLikely causeWhat to check
A cost is missing from the Buildertrend budgetCoded to an account only, not a mapped product or serviceItem details on the QuickBooks bill
A cost shows on the wrong houseDifferent linked customer or projectThe job's linked QuickBooks customer or project
A cost appears twiceEntered in both Buildertrend and QuickBooksOne entry point for bills
Totals differ by a timing amountCash and accrual set differentlyThe budget's accounting method setting

Why the settings matter

Our Buildertrend and QuickBooks integration guide covers the big decisions: one job per QuickBooks project, one cost code list and one place to enter bills. This guide goes one level down, to the settings on the Accounting page in Buildertrend's Company Settings. They decide when a bill shows up in QuickBooks Online, whether an edit follows it and whether costs entered in QuickBooks ever reach the job costing budget. Every point below comes from Buildertrend's own help pages, listed under Sources. Buildertrend changes its integration from time to time, so check those pages before you change a setting. Buildertrend notes that only the admin who set up the connection can change the default accounting options.

What moves, and which way

  • Jobs to customers. Each Buildertrend job links to a QuickBooks customer, sub-customer or project. With "Link jobs to accounting during job creation by default" on, Buildertrend creates the record for you using your preferred type, but only if a client is on the job.
  • Subs and vendors. Linked to QuickBooks vendors, and optionally created in QuickBooks when you add them in Buildertrend.
  • Bills. Buildertrend to QuickBooks, posted to the accounts payable account you choose. The cost code on each line picks the QuickBooks product or service, the sub picks the vendor and the job picks the customer or project.
  • Invoices and credit memos. Buildertrend to QuickBooks, either automatically when released to the client or manually from the invoice. Progress invoices follow the same logic.
  • Payments. Buildertrend's FAQ says a bill must be fully paid in QuickBooks before Buildertrend marks it paid. Partial payments do not change the status. Offline payments recorded in Buildertrend do not sync, so they must also be recorded in QuickBooks.
  • QuickBooks costs. QuickBooks to Buildertrend. With "Import costs entered in QuickBooks to the budget" on for a job, bills, checks, expenses, vendor credits and credit card credits from QuickBooks can fill the Actuals column of the Job Costing Budget.
  • Time. Approved Time Clock shifts become QuickBooks time activities if that setting is on. Internal users must be linked to employees, and Buildertrend will not create employees in QuickBooks.
  • Classes and locations. Buildertrend's FAQ says it does not link to them. Add them in QuickBooks after the push if you use them.

Not sure your sync settings are right? We review them in The Margin Review. Request a Relationship Assessment.

Bill sync timing: the setting that causes the most confusion

With "Sync bills to QuickBooks" on, "Sync bills automatically when" offers four choices:

  • Saved to job. Bills sync as soon as they are saved, with a checkbox you can clear on a single bill.
  • Status is ready for payment. Bills sync once approved for payment, with no checkbox on the bill.
  • Status is paid. Bills sync when paid, along with eligible online or scheduled payments.
  • Manually on each bill. Nothing syncs until someone sends it.

For job costing in the books, earlier is usually better. If bills only sync when paid, QuickBooks Online shows no payable for work that is done and approved, so job cost, accounts payable and any WIP schedule built from the books run behind. If you use Ready for payment or Paid for approval control, know that your month-end QuickBooks numbers will miss approved but unsynced bills, and accrue them or sync them before you close.

Edits after the push

"Allow bill edits to sync to QuickBooks" lets a change in Buildertrend follow a bill that is already in QuickBooks. Buildertrend lists two exceptions. A fully paid bill cannot be edited in Buildertrend unless the payment is removed in QuickBooks. And once a bill is edited in QuickBooks, Buildertrend treats that as the latest version and stops sending its own changes. Pick one place for corrections. We suggest Buildertrend for cost code and job changes, so both systems agree.

Getting QuickBooks costs into the budget

Card charges, checks and payroll costs usually start in QuickBooks Online. Buildertrend's troubleshooting page says they only reach the Job Costing Budget when they are itemized with products and services (Item details, not Category details), the product or service is mapped to a cost code, the expense is coded to the customer or project the job is linked to and, on cash basis, the expense is fully paid. A cost coded only to an expense account never reaches the budget. See getting credit card charges to the right house.

Cash or accrual on the budget

Buildertrend reads the accounting method set in QuickBooks when you connect and lets you change how the budget reports actual costs. Keep it the same as the basis your lender and CPA see. If the two differ, every open bill becomes a false difference in your monthly tie-out.

Billable bills and open book jobs

Buildertrend's FAQ says invoicing in Buildertrend does not close billable expenses in QuickBooks, and recommends not creating billable expenses in QuickBooks if you invoice from Buildertrend. The "mark QuickBooks bills as billable to client" default is meant for builders who run open book jobs and do not use Buildertrend invoicing. Pick one billing path. See our cost-plus open book reporting guide.

Product and service setup in QuickBooks

Buildertrend's troubleshooting page says bills fail to push if the product or service is not marked as purchased from a vendor with an expense account, and invoices fail if it is not marked as sold with an income account. Duplicate bill or invoice numbers and dates in a closed period also block a push. Set both accounts on every product or service you map.

Our settings checklist

  1. Every cost code mapped to a product or service with both accounts set.
  2. Every active job linked to one customer, sub-customer or project.
  3. Every sub and vendor linked, with no duplicates in QuickBooks.
  4. A bill sync timing you chose on purpose, and an accrual step at month end if bills sync late.
  5. One place for bill edits and one billing path.
  6. Import of QuickBooks costs turned on, with card charges itemized to products and services.
  7. The same cash or accrual basis in both systems.

How we help

Our team reviews these settings, fixes mapping and duplicates, and ties every house out between Buildertrend and QuickBooks Online each 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 QuickBooks and Buildertrend or JobTread cleanup, construction bookkeeping, Buildertrend vs JobTread, pricing or request a Relationship Assessment.

Sources

Common questions

When do Buildertrend bills sync to QuickBooks Online?

It depends on your setting: when saved to a job, when ready for payment, when paid, or manually on each bill. You choose it under Company Settings, then Accounting.

Do QuickBooks payments sync back to Buildertrend?

A bill must be fully paid in QuickBooks before Buildertrend marks it paid. Partial payments do not change the status, and offline payments in Buildertrend do not sync to QuickBooks.

Why aren't my QuickBooks expenses in the Buildertrend budget?

They must use mapped products and services, not category details, be coded to the linked customer or project, and on cash basis be fully paid. Import of QuickBooks costs must be on for the job.

Does Buildertrend sync classes to QuickBooks Online?

No. Buildertrend's FAQ says it does not link to classes or locations. You can add them in QuickBooks after the push.

Can I edit a bill after it syncs?

Yes, if bill edits sync is on, unless the bill is fully paid or was already edited in QuickBooks. Then QuickBooks keeps the latest version.

Can you fix our Buildertrend and QuickBooks Online settings?

Yes. Our team reviews the settings, fixes mapping and duplicates, and ties every house out each month.

Why do Buildertrend and QuickBooks Online job costs not match?

Job costs usually do not match because a cost is not coded to a mapped QuickBooks product or service, sits on a different QuickBooks customer or project than the linked job, was entered in both systems, or is on a different accounting method. Fix the mapping and linking, pick one place to enter bills, and compare both job reports monthly.

Related

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.