Guide

JobTread and QuickBooks Online sync: what syncs and how to set it up

Which records move between JobTread and QuickBooks Online, which way they move, and the setup choices that decide whether your job costs tie out.

Short answer: JobTread pushes finalized invoices and bills to QuickBooks Online and keeps their status in sync both ways. Customers, jobs, vendors, payments, credits, time entries and files also move, and your cost codes map to QuickBooks products and services. That mapping decides where income and costs land on your P&L, so set it up before the first document syncs.

Why the setup matters more than the connection

Connecting JobTread to QuickBooks Online takes a few minutes. The choices you make right after that decide whether your books show true cost by house or a pile of costs in one default account. Our team sees the same three problems over and over: cost codes that were never mapped, duplicate customers and vendors, and payments recorded twice because both systems were used to pay the same bill. Every fact below about how the sync works comes from JobTread's own help pages, listed under Sources. Check them again before you change settings, because vendors update integrations often.

What syncs, and which way

JobTread's QuickBooks Online Workflow page lists how each record maps. In plain terms:

  • Customers and jobs. When a document or time entry becomes pending or approved, JobTread looks for a matching customer in QuickBooks Online. If it finds none, it builds the customer from the JobTread account name, with the location and the job as sub-customers. Jobs can also map to classes.
  • Vendors. When a bill is created, JobTread looks for a vendor with a matching name and creates one if none exists.
  • Customer invoices. Created in JobTread, copied to QuickBooks Online. A void in either system voids the other. A payment in either system marks the invoice paid, including partial payments. JobTread's workflow table shows edits made after the first push are not synced either way.
  • Vendor bills. Created in JobTread, copied to QuickBooks Online. Bills created in QuickBooks Online come back to JobTread only if "Push Vendor Bills" is turned on and the bill date is after the "Created After" date in your settings. Changing the job on a bill in QuickBooks Online does not sync back unless the expense and payment are deleted in JobTread.
  • Payments. A payment applied to a document in either system creates a copy in the other.
  • Credits and refunds. Customer credits, refunds and vendor credits sync both ways when "Sync Credits" is on. Vendor refunds go to QuickBooks Online as credit card credits only.
  • Time entries. Approved time goes to the QuickBooks Online weekly timesheet (not QuickBooks Time), and only for employees you have mapped.
  • Files. With "Sync Files" on, attachments on synced invoices, bills, refunds and credits move both ways.

JobTread says invoices and bills are pushed once they are sent or marked pending in JobTread. Documents created before you connected sit in an Unsynced Records tab, where you can push them one at a time or all at once.

Want your JobTread sync reviewed and tied out to QuickBooks? Request a Relationship Assessment.

Cost code mapping decides your P&L

This is the step that matters most for job costing. JobTread maps each cost code to a QuickBooks Online product or service, and each product or service carries the income and expense accounts that the line posts to. JobTread's setup page says a default product or service is required to sync invoices, a default expense product or service is required to sync bills, and any cost code you forget to map falls to that default. A default is a safety net, not a plan. If half your bills post to the default, your cost of sales by account is wrong even though every house total looks right.

Before you map, settle your cost code list and chart of accounts. Our cost codes guide and builder chart of accounts show a clean starting point. JobTread also lets you map by cost code and cost type together, so labor and materials under the same code can post to different accounts.

Setup steps, in order

  1. Clean up QuickBooks Online first. Merge duplicate customers and vendors and remove colons from names. JobTread notes QuickBooks Online does not allow a colon in customer, vendor or location names.
  2. Decide how a house appears in QuickBooks Online. Sub-customer, project or class. QuickBooks Online projects need the Plus or Advanced plan and project tracking turned on. JobTread's workflow page says projects must be created by hand in QuickBooks Online before you link them, because of QuickBooks API limits.
  3. Import customers and vendors into JobTread from QuickBooks Online so names match exactly. JobTread recommends this to avoid duplicates.
  4. Connect through Settings, then Integrations, in JobTread.
  5. Map every cost code on the Products/Services Mapping tab, and set the defaults.
  6. Set payment accounts. A default Deposit To account for invoice payments and a Withdraw From account for bill payments. If you take card or bank payments through JobTread's processors, set the processing deposit and fee accounts too.
  7. Turn on classes only if you already use them, and set the QuickBooks Online class setting JobTread asks for.
  8. Choose your toggles (Sync Files, Sync Credits, Pull Expenses) on purpose, and write down who enters what.

Decide who enters what

Most sync problems are workflow problems. Pick one home for each document. A common split for custom builders: bills and invoices start in JobTread, payments are recorded in one place only, and credit card charges are entered in QuickBooks Online and pulled into the job with Pull Expenses. JobTread explains that pulled expenses become a paid bill named Expense, matched to your budget by code and type, and land in an Uncategorized group if no match is found. Review that group every month.

Monthly checks

  • Nothing left in Unsynced Records at month end.
  • Nothing posted to the default product or service.
  • No duplicate customers, vendors or houses created since last month.
  • Cost to date for each house matches between the two systems. Our tie-out guide walks through it.

How we help

Our team sets up or repairs the JobTread and QuickBooks Online connection, maps cost codes to your chart of accounts, cleans up duplicates and ties every house out 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 and QuickBooks integration, pricing or request a Relationship Assessment.

Sources

Common questions

What syncs between JobTread and QuickBooks Online?

Customers, jobs, vendors, invoices, bills, payments, credits and refunds, approved time entries and file attachments. Cost codes map to QuickBooks Online products and services.

Is the JobTread QuickBooks sync two-way?

Partly. Invoices and bills are pushed from JobTread, while payments, voids, credits and attachments sync both ways. Bills created in QuickBooks Online come back only if Push Vendor Bills is on.

Why are my JobTread costs landing in one account in QuickBooks Online?

Usually because cost codes were not mapped and fell to the default product or service. Map every cost code, and by cost type if you need labor and materials split.

Does JobTread create QuickBooks Online projects?

JobTread's help page says projects must be created by hand in QuickBooks Online before linking, because of QuickBooks API limits. Otherwise it creates customers with sub-customers.

Which QuickBooks Online plan works best with JobTread?

JobTread names QuickBooks Online Plus as its preferred plan. Projects also need Plus or Advanced.

Can you set up or fix our JobTread and QuickBooks Online sync?

Yes. Our team maps cost codes, cleans duplicates and ties every house out each month.

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.