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.
Intuit changes pricing and plan names periodically, 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.
See what Amazon owes you — free
Connect your seller account and get a free reimbursement audit. No credit card, keep 100% of what you recover.
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.
- 1
Pick the right plan
Plus is the practical floor for most sellers (channel tracking, inventory module). Verify current tiers and pricing with Intuit before subscribing.
- 2
Build a seller chart of accounts
Separate income accounts per channel; expense accounts for referral fees, fulfillment fees, storage, advertising; contra-revenue for refunds; an other-income account for reimbursements.
- 3
Create clearing accounts
One bank-type clearing account per marketplace or payment processor (Amazon Clearing, Shopify Clearing, etc.).
- 4
Post summarized settlement journals
One journal per settlement that splits gross sales, fees, refunds, tax, and reimbursements, netting to the clearing account. Use a connector or do it manually from settlement reports.
- 5
Match deposits and reconcile
Match each bank deposit to the clearing account, confirm clearing returns to ~zero, then reconcile bank and clearing accounts monthly.
- 6
Handle inventory and COGS outside the order flow
Record COGS via monthly inventory valuation (perpetual or periodic), not per-order line items in QBO.
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. BeanHawk does both sides — it posts summarized settlement journals to QBO and Xero with flat all-channel pricing from $19/mo, maintains perpetual SKU-level inventory valuation with a PO and landed-cost engine, and runs a free FBA reimbursement audit (no card required, and you keep 100% of recoveries).
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.