QuickBooks Ecommerce Integration for Online Sellers

A QuickBooks ecommerce integration moves marketplace sales, fees, refunds and sales tax into your ledger so you stop typing them in. Intuit publishes free first-party connectors for all four big US channels, Shopify, Amazon, eBay and Etsy, and each is included with a paid QuickBooks Online plan rather than sold separately. All four post at the order level, which is what makes them free and also what breaks reconciliation once volume climbs. Paid connectors such as A2X (from $29 a month per channel) and Synder (from $65 a month) exist to fix that one specific problem, and below a few hundred orders a month you do not have it yet.

Most articles about connecting QuickBooks to an online store are published by companies that sell the paid connector. That is worth knowing before you read any of them, including the parts of this one where we recommend paying. The order the decision should be made in is: ledger first, free connector second, paid connector only when a specific and measurable problem shows up. Our overview of ecommerce accounting software lays out the full stack; this piece is about the connector layer on its own.

What a QuickBooks ecommerce integration actually does

Without one, a marketplace payout arrives in your bank feed as a single net deposit. QuickBooks sees $4,182.60 and nothing else. It has no idea that the figure represents $5,411 of sales, minus $712 in commission and processing, minus $340 of refunds, minus $176 held back in reserve.

An integration reverses that flattening. It reads the platform side of the transaction and posts the parts: gross sales to a revenue account, commission and processing to an expense account, refunds as contra revenue, sales tax collected to a liability, shipping income where it belongs. What you get is a set of entries whose net equals the deposit, which means the bank reconciliation completes and your revenue figure is the real one.

That last point is not cosmetic. Platforms report GROSS on the 1099-K. If your books are built from net deposits, your reported receipts come in lower than the form the IRS already holds, by exactly the total of fees you never recorded. Those fees are deductible, but only if they exist somewhere in your ledger.

The four connectors Intuit publishes, and what each one costs

These are Intuit apps rather than third-party listings in the app store, and none of them carries a separate subscription. If you already pay for QuickBooks Online, you already own the one for your channel.

Note the last row carefully, because it is the setup mistake we see most often. QuickBooks Online Solopreneur sits below Simple Start at around $20 a month and looks like the sensible cheap entry point for a one-person shop. It cannot link an Etsy shop. A seller who picks Solopreneur on price has to move up to Simple Start at $38 before the connector is even visible, so the $18 they saved was never real.

Does Shopify integrate with QuickBooks?

Yes, directly and at no extra cost. The Shopify Connector by Intuit is a first-party app included with any paid QuickBooks Online subscription, and it is recommended by Intuit and by Shopify. It syncs sales transactions, refunds, Shopify Payments payouts, processing fees, sales tax broken out by jurisdiction, customers and inventory quantities, and it carries several thousand reviews at roughly 4.8 stars.

Its documented limitation is that it focuses on order-level syncing rather than payout-level reconciliation. For a store doing a couple of hundred orders a month that distinction is academic. Past that it is the whole ballgame, which is the subject of the next section. If you want the step-by-step version with the journal entry written out, we covered it in how to record Shopify sales in QuickBooks.

Order level versus settlement level, which is the only thing that matters

Every free connector in that table posts at the order level. Each sale becomes its own transaction in QuickBooks, roughly as it happens.

Your bank statement does not work that way. A payout is a settlement: a batch of orders, refunds, fees and adjustments the platform closed out and paid as one lump. So you end up with books built from orders and a bank feed built from settlements, and the two never agree without someone reaching in and forcing them to.

At 50 orders a month that reconciliation is fifteen minutes and mildly annoying. At 3,000 orders a month it is an unexplained variance that grows every period and eventually gets written off to a suspense account, which is the point at which your profit figure stops meaning anything. Undetected discrepancies are commonly estimated at 2% to 4% of transaction volume for sellers who never check, though that figure comes from industry commentary rather than a vendor disclosure, so treat it as a directional warning.

Amazon shows the shift most clearly. The older Amazon integration for QuickBooks worked from settlement reports, which Amazon publishes roughly every fourteen days. The current app posts order-level transactions instead. If you only want sales appearing promptly, that reads as an upgrade. If you reconcile, it went backwards, and sellers who migrated lost something they did not know they had.

When to pay for A2X, Synder or Link My Books

The trigger is order volume, not a feature you are missing. Somewhere past a few hundred orders a month on a channel, the monthly cleanup the free connector leaves behind costs more in your time or your bookkeeper's hours than the subscription does.

The per-channel detail in the A2X row changes the arithmetic more than anything else in this article. Shopify plus Etsy is two subscriptions. Three channels is roughly $87 a month, which is the point where Synder's single metered subscription starts winning on price despite the higher sticker. A2X was Xero's 2025 US Small Business App of the Year and sits near 4.9 out of 5 across around 318 G2 reviews, so this is a comparison between two good products rather than a warning about one.

Link My Books needs a caveat rather than a recommendation. It does the same settlement-summary job as A2X and does it well, but the vendor publishes no named tiers and no fixed prices at all. Its pricing page is a calculator, and the calculator renders in pounds. Every US dollar figure you have read for Link My Books in a comparison table is somebody's currency conversion of a calculator output. Get the number from the vendor.

Reconcile to the payout date, not the order date

One habit prevents most of the pain, whichever connector you end up on. Filter by payout or settlement date, never by order or transaction date, and match deposit by deposit.

Every marketplace reporting screen defaults to the wrong one. Amazon settlement reports sit under Reports, then Payments, then All Statements, one per disbursement period of roughly fourteen days, with about three years of history retained; Amazon's date range reports are keyed to order date and only go back to January 1, 2025, so reconciling against those will send you chasing a difference that does not exist. Shopify publishes a payout reconciliation report under Finance, then Documents, PDF export only, with a three-day data delay. eBay's transaction report in Seller Hub itemizes every fee and credit as CSV. The channel-by-channel walkthrough lives on our payout reconciliation page.

What to do when your channel has no connector

The four Intuit apps cover the marketplaces most US sellers use, and the paid connectors add Walmart, TikTok Shop, WooCommerce, Square and a handful more. Sell somewhere outside that list, run a subscription billing system, or take money through a regional processor, and you are back to CSV exports and a monthly journal entry you write yourself.

At that point the job stops being an accounting decision and becomes a plumbing one: read an API or a scheduled export, reshape the rows, and land them somewhere your ledger can consume. Sellers who go this route usually reach for a general data integration platform rather than waiting for a bookkeeping vendor to build the channel, and it is often faster than it sounds because a settlement export is a small, well-structured file. Whatever you build, keep the same rule: one summarized entry per payout, posted to the period the payout covers.

A sensible order to do this in

Start with the ledger, because everything else feeds it and switching later is genuinely painful. QuickBooks Online Simple Start at $38 a month is the common landing spot, and it is worth noting that QuickBooks raised prices for renewals on or after August 1, 2026, moving Essentials to $85, Plus to $140 and Advanced to $340 while holding Simple Start at $38.

Install the free first-party connector for your channel next and run it for two full months. Then look at one number: how long month-end reconciliation actually took you. If it was under half an hour, you are done and you should stop shopping. If it consistently ran into an afternoon, or your bookkeeper started itemizing it on an invoice, buy the paid connector for that channel and stop worrying about the $29.

What none of this tells you is which channel is actually worth selling on, because a ledger reports on the business as a whole rather than per source. That is a separate question, and one our multi-platform income tracker was built to answer.