An eBay seller can ask an AI useful questions about profit once the payout data is broken into its parts and each part sits on the item that caused it: sale amount, final value fee, ad fee, shipping label, international charge, refund, and the item's own cost. The catch that is specific to eBay is inventory. A seller of repeatable SKUs gets the same analysis an Amazon seller gets. A seller of used, refurbished, or one-off items gets a different and narrower analysis, because half of what an AI does with sales data assumes the same product will sell again. The payout's contents, a worked example of each inventory type, and the point where the AI stops follow.
eBay's help pages describe managed payments this way: selling fees and other costs are deducted automatically, proceeds show as processing funds and then as available for payout, usually within one to two days of the buyer's payment, and payouts run daily by default or on a weekly, biweekly, or monthly schedule the seller chooses. Every payout has a payout ID, and the Payments tab in Seller Hub tracks them.
The charges deducted before the payout, per eBay's selling fees page:
The reconciliation of those parts to the deposit is covered in eBay to Xero: managed payments, fees, and reconciliation. The point for analysis is that the fee percentages apply to a base that includes shipping and tax, so the effective fee on the item price is higher than the headline rate.
Illustrative numbers. Take a seller of power tools who sells refurbished one-off units and a line of new replacement battery packs.
The one-off: a refurbished cordless drill kit. Sold at $189 with $12 shipping charged, 8 percent sales tax collected on $201, so the total amount of the sale is $217.08. Promoted at a 6 percent ad rate. Shipping label cost $14.50. The drill came from a 20-unit auction lot bought for $1,900, so $95 per unit, and took $18 of parts and labor to refurbish. Within the 250 free listings, so no insertion fee.
Now the lot. Three of the 20 units were beyond repair. The real acquisition cost per sellable unit is $1,900 divided by 17, or $111.76, and the drill's net falls to $13.80. Whether the lot was a good buy depends on all 17 sales, and that question has no SKU: it has a lot ID and 17 different items at 17 different prices.
The repeatable SKU: a new battery pack. 400 units a month at $42.99 with free shipping, 8 percent tax, so a total sale amount of $46.43 each. Promoted at 4 percent. Label $6.20. Landed cost $21.00.
Same seller, similar margin rate, and two completely different analytical objects. The battery has velocity, a reorder point, a fee history by month, and a price test worth running. The drill has one sale.
An international sale of the drill. A Canadian buyer without eBay International Shipping adds the 1.65 percent international fee, $3.58 on the total, and the net drops to $26.98. If the sale had been on another eBay site in another currency, the 3 percent conversion charge would apply to the converted proceeds as well.
On the battery pack, everything. Crunch, the analytics AI inside ConnectBooks, reads reconciled eBay data alongside Amazon, Shopify, Walmart, and TikTok Shop, and answers questions about profit, margins, advertising, inventory, fees, and cash flow. Ask which eBay SKUs' ad fees rose faster than their sales over the last quarter and it works its chain: what changed across sales, pricing, ads, fees, returns, and margins; over the periods named; on which SKUs; why; and what to do. The battery's 4 percent ad rate against its 16.8 percent margin is a live question every month, and the inventory tracking layer gives it a reorder view as well.
On the drill, less. The reconciled data still has the sale, the fees, the label, and, if the seller recorded it, the allocated lot cost and refurb cost on the item. So the AI can answer: what was the margin on refurbished drills as a group this quarter; which auction lots, by lot ID, returned the most per dollar spent; how much the international fee cost across all cross-border sales; whether promoted one-offs sold at higher net than unpromoted ones. Those are category, lot, and channel questions, and they work because the seller tagged each item with a lot and a category.
That layer of data comes from ConnectBooks reconciling eBay payouts into QuickBooks or Xero at the transaction level, with final value fees, ad fees, refunds, labels, and international charges posted against the item that caused them.
One-off inventory breaks SKU analysis. Week-over-week comparison of a product that sold once is meaningless, and there is no velocity to project. The AI can group by category, condition, or lot, and it can compare this quarter's refurbished drills to last quarter's, but the unit of analysis is the group, and the group is only as good as the tags you gave each item.
It cannot value an item you did not cost. If the drill went into the books at zero because the lot was expensed on purchase, the sale looks like $125.56 of profit, and every lot looks brilliant. Allocated lot cost per sellable unit, entered per item, is the price of admission.
It cannot estimate resale price or condition. Whether a used item was under-priced is a judgment about a market the books do not contain.
It cannot see Seller Hub. Listing quality, seller level, and the service metrics that add a percentage to final value fees for below-standard accounts, per eBay's fees page, live in eBay's dashboards. The AI sees the fee that resulted.
It takes no action. It does not change an ad rate, relist an item, or file a fee credit request. It reports what it found and what it would do, and Seller Hub stays with you.
If most of what you sell is repeatable, treat eBay like any other channel and ask the questions you would ask of Amazon. If most of it is one-off, tag every item with a lot and a category before you ask anything, because those tags are the only handles an analyst will have.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
