Why doesn't my eBay payout match my eBay sales in QuickBooks Online?

Because eBay deducts final value fees, per-order fees, Promoted Listings charges, shipping labels, and refunds before the payout, and because the payout window cuts off part way through your accounting period. Record gross order earnings, book each deduction to its own account, and route the net through an eBay clearing account. The payout then matches the clearing balance rather than your sales, which is the correct relationship.

Do Promoted Listings fees need their own account in QuickBooks Online?

Yes, an advertising expense account of their own, and a class per channel if your plan includes class tracking. Promoted Listings is taken out of your funds rather than billed to you, so with no dedicated account it hides inside commission and your ad spend appears to be zero. You cannot answer whether promoted orders earn back their ad rate from a number that is buried in fees.

Is the eBay payout report enough to close the books?

Not on its own. The payout report tells you what was swept to your bank, not what you sold. Two orders on the same day can land in different payouts, and fees, refunds, label purchases, and holds all move the number. The transaction report grouped by type is the closing document; the payout report is the proof the cash arrived.

How is sales tax handled on eBay orders?

In most US states eBay collects and remits as a marketplace facilitator, so the tax never becomes your liability and must not sit in revenue. Route it through a pass-through account that nets to zero. Where you have your own nexus and sell off eBay as well, the tax you collect yourself is a real liability and belongs in a separate account entirely.

Does QuickBooks Online import marketplace settlements natively?

No. QBO can pull the deposit in through the bank feed, and there are app-store connectors aimed at smaller sellers, but the bank feed only ever sees one net number. Nothing in QBO itself splits a settlement into commission, fulfilment fees, advertising, refunds, reimbursements, and reserve. That split has to be produced from the settlement file before it reaches the ledger.

Should I use a journal entry or individual sales receipts in QuickBooks Online?

Journal entries, once you are past a few hundred orders a month. Sales receipts per order fill the file with transactions QBO has to scan on every report, and performance degrades in a way you cannot undo without a file rebuild. A summarized journal per settlement period keeps reporting fast, and per-SKU detail belongs in a subledger where you can query it properly anyway.

Integrations

eBay QuickBooks Online integration, reconciled to the penny

BeanHawk turns every eBay payout into a clean, summarized QuickBooks Online journal: sales, fees, refunds, and taxes mapped to the right accounts, reconciled against the deposit that actually hit your bank.

Why eBay books break in QuickBooks Online

•eBay Managed Payments payouts net out final value fees, per-order fees, ad fees, and refunds, and each needs its own account rather than a lump 'eBay income' line.
•eBay collects and remits sales tax as a marketplace facilitator in most states, so keep it out of revenue.
•Promoted Listings fees vary per order and deserve their own expense line if you want the truth about margin.

How the integration works

1
Connect eBay
Secure, read-only authorization in about 60 seconds. Multiple accounts and marketplaces supported.
2
Connect QuickBooks Online
OAuth connection with professional default account mappings you (or your accountant) can adjust.
3
Review the first journal
BeanHawk parses each payout line by line and builds one summarized journal that must balance to the penny, or it will not post.
4
Reconcile in one click
The net deposit lands in a clearing account that matches your bank feed exactly. Every eBay payout, accounted for.

Where each eBay payout line belongs in QuickBooks Online

On the payout	Account	Why it matters
Order earnings (item price)	Revenue: product sales	eBay reports order earnings gross, then deducts. Recording the payout instead of the order value understates sales by the exact amount of every fee, which is the number you most need to see.
Buyer-paid shipping	Revenue: shipping income	eBay charges final value fee on shipping too. If shipping income is buried inside product sales you cannot compare it against label cost, and free shipping listings quietly subsidise themselves out of your margin.
Final value fee (percentage component)	Cost of sales: marketplace commission	It varies by category, so it belongs on a per-order cost line rather than in overhead. Averaged across the business it hides the categories where the commission has eaten the whole spread.
Per-order fixed fee	Cost of sales: marketplace transaction fees	A flat charge per order punishes low-price items hardest. Merged with the percentage fee you lose the ability to see that a cheap SKU is unprofitable purely on order count.
Promoted Listings fees (ad rate charged on sale, or per click on the campaign types that bill that way)	Operating expense: advertising	Ad cost sits inside the payout deduction, so it never appears as a payment you make. Without its own account there is no way to test whether promoted orders earn more than they cost.
eBay shipping labels bought through the platform	Cost of sales: shipping and postage	Labels are deducted from your funds, not billed to a card. Left unmapped, postage looks like a smaller cost than it is and shipping margin reads as pure profit.
Refunds and buyer cancellations	Contra-revenue: refunds and returns	Netting refunds against sales erases return rate by category, which on eBay is the earliest signal that a listing description or a condition grade is misleading buyers.
Dispute and chargeback fees, plus cases lost through the payment dispute process	Operating expense: payment disputes	These are not returns and they are not commission. Kept separate they show whether your dispute rate is a nuisance or a real cost, and they support any case you make to eBay about a pattern.
On-hold funds and processing balances	Balance sheet: eBay clearing (asset)	Money earned but not paid out is an asset, not a timing mystery. Without a clearing account the payout will never tie to the orders it came from and the difference gets written off as noise.
Marketplace facilitator sales tax collected by eBay	Pass-through tax account that nets to zero	It never belonged to you. In revenue it overstates the top line, and it can trigger questions from a state you have no filing obligation in.

How a month actually closes on eBay

eBay pays on a schedule you choose in Seller Hub, commonly daily or weekly, and the payout batches whatever orders and deductions fell inside the cut-off window. That means a payout is not a period, it is a sweep. Closing the month means working from the transaction report for the month, then explaining the payouts, rather than adding up payouts and hoping.

Pull the eBay transaction report for the full month and group it by transaction type: order, fee, refund, dispute, shipping label, payout. Every one of those types maps to a different account. Summarize per type per month, post one balanced journal, and let the payouts clear the eBay clearing account as they land.

New accounts, accounts with a recent policy issue, and some high-value listings get funds held. Held money still belongs to you and still needs to be on the balance sheet. At month end the eBay clearing balance should equal on-hold funds plus processing funds plus any orders earned after the last payout cut-off. If it does not, look at holds first, because they are the most common cause.

Refunds on eBay usually come with a fee credit attached, and the credit does not always land in the same period as the refund. Book each side to its own account rather than netting them, then accept that a month can show a fee credit with no matching refund and the next month can show the reverse. Trying to force them into the same period is how people end up restating a closed month.

Some sellers are billed through a separate seller invoice rather than having every fee deducted from the payout, and that arrangement varies by account and has changed over time. Check how your own account is set up before you assume every fee is inside the payout. If fees are invoiced, they need their own bill in the ledger and they must not be double counted against the payout deductions.

The closing check is that gross order earnings, minus fees, minus refunds, minus label costs, plus or minus held funds, equals the sum of payouts received. Where a month straddles a payout window, the leftover sits in clearing and rolls forward. A clearing balance that trends upward month after month is the sign that something is being recorded twice.

What QuickBooks Online does well, and where it needs help

BeanHawk posts into QuickBooks Online as a summarized Journal Entry per settlement period rather than as individual sales receipts. A QBO journal entry carries one date and has to balance to the penny, so we date it at the period end, put the settlement identifier in the memo, and keep SKU-level detail in our own subledger. That keeps QBO fast and keeps an auditor able to trace any number back to a source document.

The step people get wrong is the bank feed. When the marketplace deposit appears in QBO, it must be matched to the entry already sitting in the clearing account, never added. Clicking Add creates a second income transaction and doubles revenue for that deposit. If your revenue looks roughly twice what you expect, this is almost always the cause, and the fix is to find the added transactions and undo them rather than to adjust the journal.

Class and location tracking, which is how most sellers separate channels inside one company file, is available on the higher QuickBooks Online plans rather than every plan, and Intuit has changed plan naming and inclusions over time. Check what your current subscription includes. If classes are not available to you, the workable alternative is a separate set of income and fee accounts per channel: uglier in the chart of accounts, but it works on any plan and it reports cleanly.

QuickBooks Online's built-in inventory uses FIFO and has no native landed cost handling, so freight, duty, and prep costs cannot be pushed into unit cost inside QBO itself. High-volume sellers usually stop fighting this and keep perpetual SKU valuation in a subledger, posting a periodic inventory and cost of goods sold journal instead. That is the approach BeanHawk takes, which is also why our journals stay small enough for QBO to handle at scale.

Automated Sales Tax in QBO is built for tax you collect and owe. Marketplace facilitator tax is neither, so routing it through the sales tax module invites QBO to include it in a liability you do not have. Send facilitator tax to a pass-through account that nets to zero within the same journal, and keep your own nexus tax, if any, in the sales tax module where it belongs.

One reporting quirk worth knowing before you panic: journal entries are accrual transactions, so a cash-basis profit and loss in QBO can present summarized marketplace journals in ways that look wrong at first glance. Run the accrual view when checking a settlement, and reconcile the clearing account rather than reading the bank balance, since the clearing account is where the timing difference is supposed to live.

Frequently asked questions

Why doesn't my eBay payout match my eBay sales in QuickBooks Online?: Because eBay deducts final value fees, per-order fees, Promoted Listings charges, shipping labels, and refunds before the payout, and because the payout window cuts off part way through your accounting period. Record gross order earnings, book each deduction to its own account, and route the net through an eBay clearing account. The payout then matches the clearing balance rather than your sales, which is the correct relationship.
Do Promoted Listings fees need their own account in QuickBooks Online?: Yes, an advertising expense account of their own, and a class per channel if your plan includes class tracking. Promoted Listings is taken out of your funds rather than billed to you, so with no dedicated account it hides inside commission and your ad spend appears to be zero. You cannot answer whether promoted orders earn back their ad rate from a number that is buried in fees.
Is the eBay payout report enough to close the books?: Not on its own. The payout report tells you what was swept to your bank, not what you sold. Two orders on the same day can land in different payouts, and fees, refunds, label purchases, and holds all move the number. The transaction report grouped by type is the closing document; the payout report is the proof the cash arrived.
How is sales tax handled on eBay orders?: In most US states eBay collects and remits as a marketplace facilitator, so the tax never becomes your liability and must not sit in revenue. Route it through a pass-through account that nets to zero. Where you have your own nexus and sell off eBay as well, the tax you collect yourself is a real liability and belongs in a separate account entirely.
Does QuickBooks Online import marketplace settlements natively?: No. QBO can pull the deposit in through the bank feed, and there are app-store connectors aimed at smaller sellers, but the bank feed only ever sees one net number. Nothing in QBO itself splits a settlement into commission, fulfilment fees, advertising, refunds, reimbursements, and reserve. That split has to be produced from the settlement file before it reaches the ledger.
Should I use a journal entry or individual sales receipts in QuickBooks Online?: Journal entries, once you are past a few hundred orders a month. Sales receipts per order fill the file with transactions QBO has to scan on every report, and performance degrades in a way you cannot undo without a file rebuild. A summarized journal per settlement period keeps reporting fast, and per-SKU detail belongs in a subledger where you can query it properly anyway.

Connect eBay to QuickBooks Online free

Start with the free reimbursement audit, then flat all-channel pricing from $19/mo. No per-channel fees.

Also see: Amazon + QuickBooks Online · Amazon + Xero · eBay + Xero · Shopify + QuickBooks Online · all guides