QuickBooks Online Integration

How to connect QuickBooks Online, exactly what comes across into your Seayora books, what does not, and how the connection is kept and ended — with Seayora’s non-affiliation with Intuit made clear.

If you keep your books in QuickBooks Online, you can connect it to Seayora and bring the books across: the chart of accounts, your customers, vendors and items, everything still open, and — if you choose — every past transaction. The import is one-way and runs only when you choose to. Separately, a contractor can choose to have new customers, products & services, quotes and invoices made in Seayora created in QuickBooks too — see Keeping Seayora in step with Jobber, QuickBooks and other software. Until you turn that on, Seayora reads from QuickBooks and writes nothing back.

Connecting

Open Accounting → QuickBooks migration (on the website, or under Accounting in the Seayora app) and choose Connect to QuickBooks. You sign in at Intuit and approve access there; Seayora never sees your QuickBooks password. On a phone the Intuit page opens in a browser window and you come back to the app when it is done.

What comes across

  • The chart of accounts, sub-accounts and their parents included. Two sub-accounts with the same name under different parents (Utilities → Gas and Vehicle → Gas) stay two accounts.
  • Customers, vendors and items — inactive ones too, marked inactive, so an old invoice or a past transaction still has the right name on it. A vendor keeps the last four digits of its tax ID and its payment terms; a customer QuickBooks marks as not taxable keeps its resale or exemption number.
  • Classes and locations, by their full names.
  • Every open invoice and unpaid bill, at its remaining balance. A document in another currency comes across at its value in your home currency.
  • Customer credits: open credit memos and customer payments not yet applied to an invoice.
  • Every account balance, from QuickBooks’s own trial balance for this fiscal year to date, on an accrual basis.
  • With “Include past transactions”: the whole general ledger, transaction by transaction, from the first transaction in the company file.

What does not come across

Estimates, purchase orders and time entries are not imported. The preview counts how many your company file holds, so you can see what stays behind and copy over anything you still need. Product categories and bundles in QuickBooks are groupings rather than things you sell, so they are not created as items. Attachments, bank feed rules and recurring templates stay in QuickBooks.

Accounts Receivable and Payable will match QuickBooks

QuickBooks’s Accounts Receivable is often more than its open invoices minus its credits — a journal entry, or an amount that belongs to no single invoice. Seayora posts the open invoices and credits one by one, then carries any remaining difference as one line in the opening entry, so Accounts Receivable opens at exactly the figure QuickBooks shows. Accounts Payable works the same way, where the difference is usually vendor credits. The preview tells you each difference before you import, and the result says what was carried.

Past transactions are checked before they are written

When you include past transactions, Seayora reads the ledger a quarter at a time, then adds up every balance-sheet account and compares the total with QuickBooks’s own trial balance. If a period could not be read, or the totals do not agree, the preview says which accounts and the import is refused rather than opening your books wrong. Try again, or import with opening balances only.

Running it again

Every record that comes across remembers the QuickBooks record it came from, so running the import again later adds only what is new. Nothing is added twice. If a QuickBooks invoice number is already used by an invoice you raised in Seayora, the imported one comes across with a QB- prefix rather than being dropped, and the result names it.

How the connection is kept

Intuit gives Seayora a pair of access tokens when you connect. Both are stored encrypted, used only when you run a preview or an import, and renewed automatically. Intuit ends a connection that goes 100 days without use, or that you disconnect from inside QuickBooks; Seayora then says “QuickBooks needs you to connect again” instead of failing, and nothing in your books changes.

Disconnecting

Disconnect revokes Seayora’s access at Intuit as well as deleting the tokens here. Everything already imported stays in your books. If Intuit does not confirm the revocation, Seayora tells you, and you can remove Seayora from your connected apps in QuickBooks yourself.

Verify and back up

Treat the first import as a draft to reconcile. Compare Seayora’s trial balance with QuickBooks’s for the same date, spot-check customers, vendors and open invoices, and keep your own QuickBooks backup until you are satisfied. Seayora is not liable for data loss, mismapping or discrepancies.

Independence from Intuit

Seayora is an independent company and is not affiliated with, endorsed by, or sponsored by Intuit Inc. “Intuit,” “QuickBooks,” and “QuickBooks Online” are trademarks of Intuit Inc. Your QuickBooks use remains governed by Intuit’s terms and privacy policy.

Which system is the source of truth

Decide which day Seayora becomes your system of record, and enter new transactions there from that day. Entering the same invoice in both systems is the most common source of duplicates after a migration.

Frequently asked questions

Is a QuickBooks subscription required to connect?

Yes — you need an active QuickBooks Online company of your own to authorize the connection. Seayora connects to your existing subscription; it doesn’t provide QuickBooks itself.

Does it run automatically?

No. Nothing is read from QuickBooks until you press Pull & preview or Import, and nothing is written into your books until you confirm the import.

Does Seayora change anything in QuickBooks?

Not unless you ask it to. The import only reads. If a contractor turns on Out of Seayora for QuickBooks under Keep in step, Seayora creates the new customers, products & services, quotes and invoices made in Seayora in QuickBooks — it never edits or deletes anything that is already there.

How long does a pull take?

Lists and open balances usually take under a minute. Past transactions are read a quarter at a time, so a company file with many years of history can take several minutes. QuickBooks limits how fast its data can be read, and Seayora waits and retries when it is asked to slow down.

Does the integration work with QuickBooks Desktop?

QuickBooks Desktop has no online connection, so you export from it instead: upload a .IIF file, or a CSV of each list and report, on the same QuickBooks migration screen. See Migrating Your QuickBooks Data.

Related guides

Related features and guides

Explore Seayora