Can a Xero bank rule just code my eBay payouts for me?

It can, and it is one of the worst things you can do to these books. A rule that sends every eBay deposit to a sales account records the net as revenue, which understates sales by the entire fee load and makes final value fees, ad fees, and refunds vanish. Delete the rule, post a manual journal from the transaction report, and match the deposit against the eBay clearing account instead.

How do eBay's on-hold funds show up in Xero?

They sit in your eBay clearing account as an asset until they are released. The money is earned and it is not in the bank, which is exactly what a clearing account is for. At month end the clearing balance should equal on-hold funds plus processing funds plus orders earned after the last payout cut-off. Holds are the first thing to check when that balance will not agree.

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.

Can Xero connect to a marketplace and code the fees on its own?

Not on its own. Xero's bank feed brings in the deposit as a single line, and connector apps vary widely in how much of a settlement they break out. Xero has no way to know that a deposit contains commission, advertising, refunds, and a reserve movement. Something has to parse the settlement file and hand Xero a balanced manual journal, then you match the deposit against the clearing account.

Do I actually need tracking categories in Xero for one sales channel?

If you sell on one channel and nothing else, separate accounts are simpler and you can skip tracking entirely. Tracking earns its place the moment you add a second channel or a second region, because it lets you run a profit and loss per channel without duplicating the chart of accounts. Just remember you only get two categories, so spend the first one on the dimension you will report on most.

Integrations

eBay Xero integration, reconciled to the penny

BeanHawk turns every eBay payout into a clean, summarized Xero 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 Xero

•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 Xero
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 Xero

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 Xero does well, and where it needs help

Xero calls the posting mechanism a Manual Journal, and it behaves differently from a QuickBooks journal entry in ways that matter. Manual journals can be saved as drafts for review before posting, they can be set to auto-reverse on a chosen date, and they carry a 'show journal on cash basis reports' option that changes whether the entry appears in cash-basis reporting. BeanHawk posts a summarized manual journal per settlement period with the settlement reference in the narration.

Tracking categories are Xero's answer to segmenting by channel, and the constraint is specific: an organisation gets two tracking categories, each with a capped number of options (Xero has adjusted the option limit over time, so check the current figure). Spend one on Channel and think hard before committing the second, because there is no third. Sellers who use both on channel and marketplace region find they have nothing left for department or brand later.

Bank reconciliation in Xero pushes you toward Find and Match, and that is exactly what a marketplace deposit needs: match it against the clearing account transaction the manual journal created. The danger is bank rules. A rule that auto-codes anything from Amazon or Shopify straight to a sales account will happily book net deposits as revenue forever, understating sales and erasing every fee. If you already have such a rule, delete it before connecting anything.

Xero has no native landed cost function, and its inventory uses average cost rather than FIFO. Tracked inventory items in Xero also come with limits that multi-channel sellers hit quickly. The practical answer is the same one that works in QuickBooks: keep perpetual SKU-level valuation in a subledger, push freight and duty into unit cost there, and post a periodic summarized inventory and cost of goods sold journal into Xero.

Xero's plans cap how many invoices, bills, and in some cases bank transactions you can process per month, and plan names and limits have changed by region and over time. Manual journals are not usually the binding constraint, but if you also invoice wholesale customers out of Xero, the cap can be. Multi-currency is another plan-dependent feature and it matters directly if you sell across marketplaces in more than one currency, so confirm your plan before designing the chart of accounts around it.

For a cross-border seller, set up one clearing account per currency and let Xero handle the revaluation rather than converting everything by hand. Xero will post unrealised gains and losses on foreign currency balances at period end, which means your clearing account balance moves for reasons that have nothing to do with the marketplace. Knowing that in advance saves an afternoon of hunting for a difference that is working exactly as designed.

Frequently asked questions

Can a Xero bank rule just code my eBay payouts for me?: It can, and it is one of the worst things you can do to these books. A rule that sends every eBay deposit to a sales account records the net as revenue, which understates sales by the entire fee load and makes final value fees, ad fees, and refunds vanish. Delete the rule, post a manual journal from the transaction report, and match the deposit against the eBay clearing account instead.
How do eBay's on-hold funds show up in Xero?: They sit in your eBay clearing account as an asset until they are released. The money is earned and it is not in the bank, which is exactly what a clearing account is for. At month end the clearing balance should equal on-hold funds plus processing funds plus orders earned after the last payout cut-off. Holds are the first thing to check when that balance will not agree.
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.
Can Xero connect to a marketplace and code the fees on its own?: Not on its own. Xero's bank feed brings in the deposit as a single line, and connector apps vary widely in how much of a settlement they break out. Xero has no way to know that a deposit contains commission, advertising, refunds, and a reserve movement. Something has to parse the settlement file and hand Xero a balanced manual journal, then you match the deposit against the clearing account.
Do I actually need tracking categories in Xero for one sales channel?: If you sell on one channel and nothing else, separate accounts are simpler and you can skip tracking entirely. Tracking earns its place the moment you add a second channel or a second region, because it lets you run a profit and loss per channel without duplicating the chart of accounts. Just remember you only get two categories, so spend the first one on the dimension you will report on most.

Connect eBay to Xero 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 + QuickBooks Online · Shopify + QuickBooks Online · all guides