QuickBooks Online for Ecommerce Sellers: The Complete Setup Guide

Say Amazon deposits $8,412.37 into your bank account, while your seller dashboard says you sold $11,950 that period. QuickBooks Online sees one number (the deposit), and if you book it as 'sales,' you have just understated revenue, hidden thousands of dollars in fees, and made your margins look better than they are. Multiply that across a year of settlements and your books are fiction.

This is the core problem with QuickBooks for ecommerce: QBO is excellent general-purpose accounting software, but it has no native concept of a marketplace settlement. The deposit that hits your bank is sales, minus referral fees, minus FBA fees, minus refunds, plus reimbursements, plus sales tax the marketplace collected and remitted on your behalf, all netted into one line. This guide covers how to set QuickBooks Online up so every one of those pieces lands in the right account.

What QuickBooks Online is, and which plan sellers actually need

QuickBooks Online (QBO) is Intuit's cloud accounting software: a general ledger, bank feeds, invoicing, reporting, and a large app ecosystem. It is the default choice for US small businesses, which means nearly every accountant, bookkeeper, and ecommerce connector supports it. That network effect alone is a strong reason to choose it over more obscure quickbooks accounting software alternatives. If your accountant already lives in QBO, staying there and adding the right ecommerce accounting layer on top usually beats switching ledgers.

Intuit changes pricing and plan names periodically, and a QuickBooks Online price increase has landed regularly in recent years, so treat any numbers you see as approximate and check Intuit's current pricing page before you buy. As a rough orientation, plans have historically run from around $35 per month at the entry tier to a few hundred per month at the top tier. What matters more than price is features by tier.

• •Simple Start: single user, basic ledger. Workable only for very small, single-channel sellers.
• •Essentials: adds bills and multiple users. Still no inventory tracking.
• •Plus: the practical floor for most ecommerce sellers. Adds class/location tracking (useful for tagging channels) and QBO's basic inventory module.
• •Advanced: more users, custom reporting, revenue recognition. Usually only needed at meaningful scale or with complex reporting requirements.

Why marketplace deposits break naive QuickBooks bookkeeping

When a customer buys from your Shopify store via a clean payment processor, the accounting is fairly simple. Marketplaces are different. Amazon, for example, holds your money and pays out on a settlement cycle, and each settlement nets together dozens of transaction types. Referral fees alone typically run 8-15% of the sale price depending on category, and that is before FBA fulfillment fees, storage fees, advertising deductions, refunds, and chargebacks.

Here is a simplified, illustrative settlement: $11,950 in product sales, minus $1,793 in referral fees (15% in this example category), minus $1,420 in FBA fees, minus $480 in refunds, plus $155 in reimbursements for lost inventory, equals an $8,412 deposit. If you book the deposit as revenue, your P&L shows $8,412 in sales and $0 in fees. Your real gross revenue is $11,950 and your real selling costs are over $3,200. Every margin decision you make off those books (pricing, ad spend, which SKUs to kill) is now based on wrong numbers.

The fix is structural, not heroic bookkeeping: a clearing account plus summarized settlement journals.

The seller-grade setup: clearing account + summarized settlement journals

A clearing account is a holding account on your balance sheet (set it up as a bank-type account in QBO, named something like 'Amazon Clearing'). It represents money Amazon owes you that hasn't been deposited yet. Every settlement gets posted to QBO as one summarized journal entry that breaks the settlement into its components (gross sales, refunds, referral fees, FBA fees, ad spend, reimbursements, marketplace-collected sales tax), with the net amount landing in the clearing account.

When the actual deposit hits your bank feed, you match it against the clearing account. The clearing balance returns to zero (or near zero), which is itself a built-in audit check: if the clearing account drifts, something was missed or double-posted.

Why summarized journals instead of importing every order? Because pushing thousands of individual orders into QuickBooks Online bloats the file, slows reports, makes reconciliation harder, and adds zero accounting value. Your ledger needs accurate totals by category and period; your order-level detail belongs in the marketplace reports and your analytics tools, not your general ledger. One journal per settlement (or per month per channel) keeps QBO fast and your accountant sane.

A clean QuickBooks Online setup for sellers, step by step

Here is the sequence that produces books an ecommerce-literate accountant will sign off on. Do these in order; the chart of accounts has to exist before the journals can post to it.

Multi-channel sellers: one ledger, one clearing account per channel

Selling on Amazon plus Shopify plus eBay doesn't change the architecture. It repeats it. Each channel gets its own clearing account, its own income account (or class), and its own settlement or payout journal. Shopify payouts net out processing fees and refunds much like Amazon settlements do, just with fewer line types; eBay's payouts bundle final value fees, ad fees, and refunds the same way; a QuickBooks Etsy integration handles the same shape again with Etsy's listing and transaction fees. The pattern is identical: journal the payout components, net to the channel's clearing account, match the deposit.

What you get in return is the report that actually matters: a P&L by channel. Run it and you'll know whether eBay is a profit center or a habit, and whether Shopify's lower fees actually survive its higher ad spend. Sellers who blend everything into one income line can't answer either question, and they routinely misprice or over-advertise on their weakest channel for years without noticing.

Sales tax in QuickBooks for ecommerce: mostly not what you think

US marketplace facilitator laws mean that for marketplace orders, Amazon and similar platforms generally collect and remit sales tax themselves in states with those laws. That tax still flows through your settlement reports, which trips up a lot of sellers: it is not your revenue and not your liability. In your settlement journal, marketplace-collected tax should net to zero (recorded as collected and remitted by the facilitator), so it never inflates your sales or sits as a phantom liability in QBO.

Direct channels are different. On your own Shopify or website sales, you may be the one collecting and owing tax depending on where you have nexus. QBO's sales tax features and third-party tax tools handle the filing side; your job in the ledger is simply to keep marketplace-remitted tax separate from tax you actually owe. Rules vary by state and change, so confirm your nexus footprint with a tax professional rather than assuming.

What QuickBooks Online can't do alone for marketplace sellers

QBO will not fetch settlement reports, classify Amazon's dozens of fee types, build the journals, or track whether Amazon actually deposited what the settlement said. Its inventory module assumes you buy and sell from your own warehouse; it has no idea about FBA inbound shipments, inventory lost in fulfillment centers, or landed cost from overseas purchase orders.

The reimbursement side has gotten less forgiving, which raises the stakes on tracking it. As of October 23, 2024, Amazon cut the claim window for FBA fulfillment-center losses to 60 days, a far tighter deadline than sellers were used to. Since November 1, 2024, Amazon auto-reimburses many lost-inventory cases in the US, but as of March 31, 2025, reimbursements are valued at your manufacturing or sourcing cost (Amazon's own estimate unless you supply your costs), excluding your margin and fees. Translation: claims expire fast, auto-payouts use Amazon's guess at your cost, and nobody is checking the math unless you are.

This is the gap a connector fills: automated, summarized settlement journals posted to QuickBooks Online, plus the marketplace-specific layers QBO lacks.

Choosing a connector: how to connect Amazon, Shopify, and eBay to QuickBooks

In practice, quickbooks for amazon sellers means QBO plus a connector, because nobody should hand-build settlement journals past their first few months. The market has a few established options. A2X pioneered the summarized-journal approach, and a2x quickbooks setups are common in accountant practices; Link My Books is a strong UK/EU-flavored alternative; BeanHawk covers the same settlement-to-journal core with flat all-channel pricing from $19/mo and adds what the others treat as separate problems: perpetual SKU-level inventory valuation with a PO and landed-cost engine, plus a free FBA reimbursement audit (no card required, you keep 100% of recoveries).

Whichever you evaluate, judge an amazon quickbooks integration on four tests. Does it post summarized journals rather than order-level spam? Does it map every fee type to your chart of accounts, editable by you? Does it net marketplace-collected tax to zero automatically? And does it verify settlements against actual bank deposits? A connector failing any of these will quietly rebuild the mess you were trying to escape.

The same logic extends across channels. A shopify quickbooks integration should journal each payout with processing fees and refunds broken out, and when you integrate eBay with QuickBooks, that ebay quickbooks integration should do the same for final value fees and ad fees. Be skeptical of any QuickBooks Shopify sync that pushes individual orders across instead; that's the order-level spam problem wearing a different label. Prefer one tool handling all your channels into one ledger over three single-channel tools with three different account mappings; consistency is what makes the channel P&L comparable. One honest caveat: if you run a single channel at low volume, a monthly manual journal from the settlement report takes about twenty minutes and costs nothing. Connectors earn their fee when volume, channels, or fee complexity grow past what you'll reliably do by hand.

The rest of QBO: bills, purchase orders, budgets, and apps

Settlements are the hard part, but a seller's file still has ordinary accounting in it, and one distinction trips people up constantly. QuickBooks Online expense vs bill: an Expense records money that's already gone (a card charge, a bank payment), while a Bill records something you owe and will pay later, which then lands in Accounts Payable and on your aging report. Use Bills for supplier invoices with terms, Expenses for anything already paid. Get it backwards and your payables are wrong in both directions. Once you're running enough supplier invoices to need approvals, a Bill.com integration with QuickBooks Online is the usual next step; it routes approvals and pays, then syncs both the bill and the payment back into QBO.

Purchase orders matter more for inventory sellers than for the average QBO user. A PO in QuickBooks Online is non-posting until you receive against it, so it's a record of intent rather than an expense, which is fine for tracking what's on the water. Where it falls short is landed cost: neither QBO nor the QuickBooks Desktop purchase order flow will spread freight, duty, and prep across the units on a shipment for you. If landed cost drives your COGS, and on imported goods it always does, plan on purchase order software feeding QuickBooks rather than relying on the built-in PO.

Three more things worth knowing before you go add-on shopping. Budget vs actual in QuickBooks Online is built in: set a budget by account and class, then run the Budget vs Actuals report to see how a channel is tracking against plan. Payroll is a paid add-on rather than part of the ledger subscription, and Intuit migrated its standalone payroll customers into the QuickBooks product, so the Intuit Online Payroll vs QuickBooks Payroll question is mostly historical now. QuickBooks Online integrations live in Intuit's app marketplace, and Intuit-approved QuickBooks Online apps are vetted for the sync working, not for whether they suit an inventory business, so test any of the QuickBooks Online inventory apps against your own SKUs before you commit. If an accountant manages your file, ask about wholesale billing too: QuickBooks Online wholesale pricing runs your subscription through their practice at a discount that usually beats retail.

The five mistakes that ruin seller books in QBO

If you inherit a messy QuickBooks file from a generalist bookkeeper, the damage almost always traces back to one of these.

• •Booking deposits as revenue: understates sales, hides fees, distorts every margin metric.
• •Importing individual orders into QBO: bloated file, slow reports, reconciliation pain, no added accuracy.
• •Counting marketplace-collected sales tax as income or as your liability: it is the facilitator's to remit in most states.
• •Skipping the clearing account: deposits get force-matched to whatever looks close, and errors compound silently.
• •Ignoring COGS until tax time: without monthly inventory valuation, your P&L is meaningless for eleven months of the year.