The QuickBooks Sync: A One-Way Push
A one-way push of vendors, items and purchase orders into QuickBooks Online. What that is genuinely worth, what it is not, and why "syncs with your books" is the phrase to interrogate hardest on any integrations page — including ours.
The word "sync" does more work on integrations pages than any other word in software marketing. It can mean a nightly two-way reconciliation of two ledgers. It can mean a button that pushes a list of names in one direction. Both are described identically, and the gap between them is a quarter of somebody's time.
Ours is closer to the second. Here is exactly what it does, so you can judge whether it is worth the setup.
What moves, and which way
The QuickBooks Online connection
Record Direction and trigger
Vendors Pushed out, on request — all of them or one at a time
Items Pushed out, on request
Purchase orders Pushed out, on request
Anything at all Never pulled back in
The connection itself OAuth against Intuit, with tokens held per organisation
One direction, on demand. There is no nightly schedule and nothing is read back from QuickBooks, so a change made in QuickBooks does not appear here and never will through this connector. Treat it as a way of populating your books, not of keeping two systems in agreement.
A note on our own copy
The connector's summary in the product describes syncing "vendors, items, invoices and purchase orders". Invoices are not among what the sync actually pushes — vendors, items and purchase orders are. We have left this note here rather than quietly correcting the page, because a reader deciding on the basis of that line deserves to know which of the two statements was checked against code.
What this is genuinely useful for
Good fit
You already run QuickBooks and your accountant lives in it
Getting supplier and item records in without re-keying them saves real hours at setup, and pushing purchase orders across means your accountant can see committed spend without asking you for a list.
Good fit
One-off population at go-live
Arguably the best use. Push once, cleanly, at the start, rather than treating it as a running process.
Poor fit
You want one set of books, continuously current
This will not do that. Without a pull direction or a schedule, two systems will diverge, and the divergence is invisible until somebody reconciles by hand.
Poor fit
You want QuickBooks to be the operational system
Wrong shape entirely. Stock movements, receiving, approvals and counts stay here; the accounting package is downstream of them, and no amount of syncing changes which system is doing the work.
The larger point about accounting integrations
This system posts double entry from every business flow — a sale posts revenue and cost of goods, a stock receipt posts to inventory, an expense posts to the expense account and to bank or payables. What it does not have is a manual journal entry, which is why it is a book of operational record rather than a statutory book of account. That distinction is worked through in chart of accounts and opening balances.
Which means the honest architecture for most Kenyan SMEs is two systems with a stated boundary: operations here, statutory accounts with the accountant, and a monthly handover of agreed figures. An accounting connector helps with that handover. It does not remove the boundary, and a vendor implying that it does is selling you a reconciliation you will still be doing by hand in month six.
Where the boundary actually sits
Here
Operational record, posting as things happen
- Stock movements, receiving, counts and adjustments with reasons.
- Requisitions, approvals, purchase orders and committed spend.
- Sales, POS, invoices, and eTIMS filing where applicable.
- Double entry generated by each of those, with a reference back to the document.
The accountant
Statutory book of account
- Accruals, prepayments, deferrals and depreciation.
- Correcting journals and closing entries.
- A numbered statutory chart, if the jurisdiction requires one.
- The final statements and the filings.
What crosses each month
- Agreed figures out of the reports, in an agreed format, on an agreed day.
- Suppliers, items and purchase orders, if you use the connector, so they are not re-keyed.
- Nothing back. Decide this explicitly, because assuming otherwise is where the drift starts.
Setting it up
Four steps and one habit
- Connect through OAuth — you sign in to Intuit and approve. Nothing to paste, and the tokens are held for your organisation.
- Push vendors first, then items, then purchase orders. Check the first ten records that arrive in QuickBooks before pushing the rest.
- Watch for duplicates. A vendor that already exists in QuickBooks under a slightly different name will not be recognised as the same one.
- Decide who owns each record type going forward, and write it down. Two systems both allowed to create suppliers will produce two supplier lists.
- The habit: if you push periodically, do it on a day of the month rather than when someone remembers. On-demand syncing without a rhythm is on-demand syncing that happened twice.
What AWRA OpsHub does today
- OAuth connection to QuickBooks Online with per-organisation tokens and a sync log.
- Push of vendors — in bulk or one record at a time.
- Push of items.
- Push of purchase orders.
- Connect and disconnect from the integrations settings.
What it does not do
- Nothing is pulled back from QuickBooks. It is one direction only.
- No scheduled sync. It runs when somebody presses the button.
- No customer invoice push, despite the connector summary mentioning invoices.
- No payments, journals, chart-of-accounts alignment or tax-code mapping.
- No duplicate detection against records that already exist in QuickBooks under a different name.
- No other accounting package — no Sage, no Xero, no Tally, no Zoho Books.
Our take
Worth doing once at go-live to avoid re-keying suppliers, items and orders, and worth being clear-eyed about afterwards: it is a one-way push on a button, not a way to keep two systems in agreement. Interrogate the word "sync" everywhere you meet it — direction, trigger, and what happens to a record that already exists at the other end. The answers separate an integration from a logo.
Push once, cleanly, at the start
An OAuth connection to QuickBooks Online with a one-way push of vendors, items and purchase orders — described by direction and trigger, so you can judge it rather than assume it.
See plans & pricingFrequently asked questions
What does the QuickBooks integration sync?
Vendors, items and purchase orders, pushed out to QuickBooks Online on request. Nothing is pulled back, and there is no scheduled sync — it runs when somebody presses the button. The connection itself is OAuth against Intuit with tokens held for your organisation.
Are customer invoices pushed to QuickBooks?
No. The connector's in-product summary mentions invoices, but what the sync actually pushes is vendors, items and purchase orders. We have said so here rather than quietly editing the page, because anyone deciding on the basis of that line deserves to know which statement was checked against the code.
Will this give us one continuously current set of books?
No. Without a pull direction or a schedule, the two systems will diverge, and the divergence is invisible until somebody reconciles by hand. The honest architecture is two systems with a stated boundary — operational record here, statutory accounts with your accountant, and a monthly handover of agreed figures. A connector helps with the handover; it does not remove the boundary.
Will it create duplicate suppliers?
It can. A vendor that already exists in QuickBooks under a slightly different name will not be recognised as the same record. Push the first ten and check them before pushing the rest, and decide explicitly which system is allowed to create suppliers going forward — two systems with that permission will produce two supplier lists.
Which other accounting packages are supported?
None. QuickBooks Online is the only accounting integration — there is no Sage, Xero, Tally or Zoho Books connector. For those, the handover is reports out of here in an agreed format on an agreed day, which is what most SMEs in this market do regardless of the connector.
