Connect QuickBooks Online
Authorize a QuickBooks Online connection, schedule an incremental sync into reviewed imports, push approved AP bills and payments, and fix common connection problems.
Partly in the app today. Items marked Planned are not built yet.
On this page
QuickBooks Online connects to company Accounting as an ERP connection. A sync reads QuickBooks and stages ordinary accounting imports; nothing posts until a second user reviews and applies them. If you turn on pushes, posted AP bills and bill payments you approve are created in QuickBooks; nothing else is ever written there.
Set it up
- Open Accounting > Imports > ERP connections. You need the manage integrations permission.
- Under Add a connection, choose the entity, QuickBooks Online — live API, a name, and optionally the QuickBooks company (realm) id and a cut-over date for open bills.
- Select Authorize with QuickBooks on the new connection, sign in to QuickBooks and approve access for the company.
- Back on ERP connections, select Sync now.
If you entered a realm id, QuickBooks must return that same company, or the authorization is refused. os.construction confirms the company with QuickBooks before saving anything.
What syncs
| QuickBooks | Lands as |
|---|---|
| Chart of accounts | A staged chart-of-accounts import |
| Vendors | A staged vendor import |
| Open bills as of the cut-over date (with retainage from the accounts you name) | A staged open AP import |
Running a sync again with unchanged data returns the same staged imports and creates nothing twice. Review, map and apply each import as described in Accounting imports and integrations.
Permissions and data
- Only users with the manage integrations permission can authorize, reauthorize, sync or disconnect.
- The QuickBooks tokens are stored encrypted on the connection and are never shown in the app or returned by the API.
- Disconnect revokes the authorization at QuickBooks and removes it here. Staged and applied imports stay.
Troubleshooting
- Needs authorization: the connection has no stored authorization, or QuickBooks rejected it (for example after 100 days without use, or after someone disconnected the app in QuickBooks). Select Authorize with QuickBooks again.
- “That QuickBooks company does not match”: you signed in to a different QuickBooks company than the realm id on the connection. Sign in to the right company, or add a new connection.
- “Not set up on this server yet”: the QuickBooks app is not configured on this deployment. Contact support.
- Sync errors appear in the Error inbox on the same page with the record that failed.
Scheduled incremental sync (preview)
After the connection is authorized, a company admin can give it a sync profile from Company > Connections > Syncs > Set up sync.
| Resource | What a run does |
|---|---|
| Vendors, customers, chart of accounts, products and services | Reads only what changed in QuickBooks since the last run (QuickBooks change data capture; the first run, or a run after 30 days offline, reads everything). New records stage as ordinary imports for review and two-person apply. |
| Classes, and customer jobs | Kept for the mappings below; nothing is imported. |
| A record that already exists here and changed or was deleted in QuickBooks | Goes to the sync’s review queue. It is never applied automatically: update the record here if you want the change, then dismiss the item. |
Choose a schedule (every hour, every 6 hours, daily, or manual), pause or resume it, and use Run now at any time. The sync page shows every run with its counts, the records that failed (with Retry), and the review queue.
Push AP bills and payments (preview)
Turn on Push AP bills and Push bill payments, choose a direction that includes pushing, and set Push from: only posted bills and payments dated on or after that day are offered.
- Each candidate appears in the review queue. A user with the manage integrations permission approves it.
- The next run creates the bill (or payment) in QuickBooks once. A retry never creates a second copy.
- If something is missing, the item is Blocked with the reason, for example a vendor or GL account that has no QuickBooks match. Map it under Mappings and approve again.
- QuickBooks Online has no draft or unposted bills, so nothing is sent before approval.
- Existing QuickBooks records are never changed or deleted, and dates on or before the QuickBooks closing date are refused.
- If QuickBooks already has a bill with the same number for that vendor, the item asks you to link to it instead of creating a duplicate.
- A bill that withholds retainage needs the QuickBooks retainage payable account id in the sync settings. Payments with a discount or backup withholding are not pushed; record those in QuickBooks yourself.
- Vendors imported from QuickBooks and accounts with the same number are matched automatically. Map projects to QuickBooks customers or jobs, and cost codes to classes, if you want them on the pushed lines.
Keep exploring
Related across os.construction
- DocsAccounts PayableSubcontractor-ready AP: a bill capture inbox and vendor portal, retainage, lien waiver and COI payment holds, joint checks, NACHA, positive pay, virtual cards, remittance advice and 1099 outputs.
- DocsAccounting imports and integrationsImport opening balances, open AP/AR, journals, master data and payroll YTD, and connect QuickBooks Online, through one reviewed company accounting workflow.
- GlossaryTrial balanceA list of every account's debit or credit balance at a date; total debits equal total credits.
- GlossaryControl accountA general ledger account whose balance must equal the total of a subledger, such as accounts payable or accounts receivable.
- BlogWhy construction needs an operating system, not another appMost contractors don't have a software problem. They have a seams problem: the same number lives in five systems and none of them agree. The fix is a shared record, not another tool.
- BlogYour first accounting cycle: setup, transactions and closeA practical learning path through the Accounting module's apps, with the people, evidence and review gates needed from opening balances to month-end.
Was this helpful?
Run it on your own project.
Start a 14-day free trial. Want a say in what ships next? Join the founding program.
14-day free trial. Pricing for paid plans isn't set yet. Talk to us. Already have an account? Sign in →