Esc

↑↓ move↵ openIndex · Pagefind
Admin and security / Connect QuickBooks Online

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.

Preview

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

  1. Open Accounting > Imports > ERP connections. You need the manage integrations permission.
  2. 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.
  3. Select Authorize with QuickBooks on the new connection, sign in to QuickBooks and approve access for the company.
  4. 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.

  1. Each candidate appears in the review queue. A user with the manage integrations permission approves it.
  2. The next run creates the bill (or payment) in QuickBooks once. A retry never creates a second copy.
  3. 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

Run it on your own project.

Start a 14-day free trial. Want a say in what ships next? Join the founding program.

Your role (optional)

14-day free trial. Pricing for paid plans isn't set yet. Talk to us. Already have an account? Sign in →

Ask the OS

Reading this page

Ask anything about this page. Answers use what you're reading as context.

Suggested

    AI · may be imperfect · sample data where shown

    Open file