Accounting software for eBay sellers: how to compare connectors, sync and reports

By the Dropizon team Published 9 min read Tools and Comparisons
eBay logo

In short

The right accounting software for eBay sellers is the package your connector feeds cleanly. Compare connectors on three things: whether they post gross sales, fees, refunds and payouts separately; whether they sync summaries per payout or every order; and whether each payout reconciles to your bank. Then check the reports your UK or US tax return needs.

Key takeaways

  • The connector that feeds your accounting software matters more than the package itself.
  • eBay payouts are net of fees, so book gross sales and fees separately and reconcile through a clearing account.
  • Summary sync suits steady single-site stores; order-level sync suits higher volume, several currencies or per-order profit tracking.
  • UK thresholds such as the £1,000 trading allowance and the £90,000 VAT test, and the US Form 1099-K, are measured on income or payments, not net payouts.
  • Test any connector on one past month and reconcile every payout before you commit.

What should accounting software for eBay sellers do?

Good accounting software for eBay sellers turns eBay's sales, fees, refunds and payouts into bookkeeping entries that match your bank statement. It then produces the reports your tax return needs. For most sellers the accounting package matters less than the connector that feeds it, so that is where to spend your comparison time.

A connector is the integration, built in or bought separately, that reads your eBay data and posts it into your accounting software. Two connectors can feed the same package and give you very different books.

Whatever you choose, it should capture these items separately:

  • Gross sales: the item price the buyer paid, before any deductions.
  • Postage charged: what the buyer paid you for delivery, kept apart from what delivery cost you.
  • eBay fees: final value fees, listing fees and optional upgrades, ideally by type.
  • Advertising fees: Promoted Listings charges, which come out of the same payouts.
  • Refunds and returns: full and partial, linked back to the original sale.
  • Taxes eBay collects: these pass through your transaction report but are not your income.
  • Payouts: the net amount that reaches your bank, plus any amounts held back.
  • Currency conversion: if you sell on more than one eBay site or to overseas buyers.

If a connector lumps all of this into one sales figure, your profit may look right while your turnover, fee totals and tax figures are wrong.

How do you get eBay data into accounting software?

There are three common routes. All of them start from the same source: eBay's own transaction records, which you can download from the Payments area of Seller Hub. Our guide to Seller Hub features most sellers miss shows where the reports sit.

MethodWhat gets postedSuitsWatch for
Manual export and importWhatever you key in or import from eBay's transaction reportLow volume, one eBay siteTime each month, typing errors, missed refunds
Summary connectorOne journal per payout or per day, split into sales, fees and refundsSteady volume where you do not need order detail in the ledgerHarder to trace a single order; costs matched in bulk
Order-level connectorOne entry per order, refund and feeHigher volume, profit per order, several sites or currenciesA crowded ledger, more to review, errors on edited orders

A spreadsheet can work at the start, and there is a point where it stops being worth your time. We cover that trade-off in spreadsheet vs software for eBay listings, and the same logic applies to your books.

Summary sync or order-level sync: which suits your store?

Sync describes how often, and at what level of detail, the connector copies data across. Summary sync posts totals. Order-level sync posts every transaction.

When summary sync is enough

If you sell a modest number of items each month on one eBay site, a summary per payout is usually easier to work with. Your ledger stays readable, and each journal matches one bank deposit. Keep eBay's transaction report as the detailed record behind each summary.

When you need order-level detail

Order-level sync helps when you want profit per order, when you sell in more than one currency, or when refunds and returns are frequent. It also helps when each sale has its own purchase cost, as it does when you buy stock after an order comes in. The trade-off is volume: thousands of entries a month need rules and regular review, or errors pile up unnoticed.

Check how the connector handles changes

Orders change after they are posted. A buyer cancels, a partial refund goes out, or an ad fee is charged days later. Ask whether the connector updates the original entry, posts an adjustment, or ignores the change. Adjustments are easier to audit than silent edits.

How do you reconcile an eBay payout with your books?

Reconciling means proving that what your books say you earned matches what reached your bank. With eBay this is where most errors show up, because a payout is a net figure: eBay takes its fees and other charges before the money is paid to you.

The cleanest method uses a clearing account: a holding account in your books where gross sales go in and fees, refunds and charges come out, until the payout moves the balance into your bank account. If the clearing account does not return to zero after each payout, something is missing.

Example (hypothetical numbers): suppose a buyer pays £30.00 for an item plus £3.99 postage, a total sale amount of £33.99. For the arithmetic only, assume a hypothetical selling fee of 13% of the total and a Promoted Listings ad rate of 5%. These are not eBay's actual rates. Business seller fees vary by category, so check the current figures on eBay's selling fees page. Suppose the item cost you £20.00.

LineAmount
Total sale amount (item plus postage)£33.99
Hypothetical selling fee (13%)minus £4.42
Hypothetical ad fee (5%)minus £1.70
Net payout to your bank£27.87
Item costminus £20.00
Profit before other costs£7.87

If you book only the £27.87 payout as income, your sales are understated by £6.12 and your fees disappear from the accounts. Profit looks the same, but turnover is wrong, and tax thresholds are tested against turnover or gross income, not what is left after eBay's deductions.

Two details catch sellers out. First, eBay calculates general Promoted Listings fees on the total sale amount, including item price, postage and taxes, at the ad rate in effect at the time of sale (eBay's Promoted Listings help). Second, on eBay UK the seller currency conversion charge is 2.5%, rising to 2.75% from 1 December 2026. That charge should post as a cost, not as a reduction in sales. For more on fee arithmetic, see our eBay fee calculator guide.

Which reports do UK and US eBay sellers need for tax?

Your accounting software should give you a profit and loss report, a sales total for the tax year and a list of fees and costs by type. Which totals matter depends on where you are.

UK sellers on eBay.co.uk

  • Trading allowance and Self Assessment: individuals have a trading allowance of up to £1,000 a year of trading income. If gross trading income for a tax year is over £1,000, you must register for Self Assessment by 5 October following that tax year (gov.uk trading allowance guidance).
  • VAT: you must register if VAT taxable turnover for the last 12 months goes over £90,000, or if you expect it to go over £90,000 in the next 30 days alone (gov.uk: when to register for VAT). A rolling 12-month turnover report makes this easy to watch.
  • Making Tax Digital for Income Tax: sole traders must use it from 6 April 2026 if qualifying income in 2024 to 2025 was over £50,000, from 6 April 2027 if it was over £30,000 in 2025 to 2026, and from 6 April 2028 if it was over £20,000 in 2026 to 2027. If you fall in, your software must work with it (gov.uk Making Tax Digital guidance).
  • Platform reporting: eBay may report your details and income to HMRC. A seller of goods is not reported if they made fewer than 30 sales and received 2,000 euros (about £1,700) or less in the year (gov.uk reporting rules for digital platforms). Your own totals should be able to explain what eBay reports.

If you buy items to resell, eBay UK says you must register as a business seller, which also means showing business contact details and a returns policy (eBay's business seller policy).

US sellers on eBay.com

The IRS says online marketplaces must file Form 1099-K when a seller's payments exceed $20,000 in more than 200 transactions. A platform may send a 1099-K below that threshold, and you must report income whether or not you receive one (IRS: understanding your Form 1099-K). Pick software that lets you tie the figure on the form back to your eBay transaction report, because it may not match your net payouts.

Tax treatment depends on your circumstances, so check your own situation with HMRC, the IRS or a qualified accountant. Software organises the numbers; it does not decide how they are taxed.

How should you record Amazon purchases and other costs?

Cost of goods is what you paid for the items you sold. Each eBay sale needs a matching purchase record, and any later refund from the supplier needs recording too.

One rule to be clear about first. eBay allows dropshipping where you fulfil orders directly from a wholesale supplier. Listing an item on eBay and then buying it from another retailer or marketplace, such as Amazon, that ships directly to your buyer is not allowed under eBay's drop shipping policy (eBay.com version), and eBay may remove listings, issue warnings, restrict activity or suspend the account. Whatever your supplier, you stay responsible for delivery within the time stated in your listing and for the buyer's satisfaction. Any Amazon purchase is made under Amazon's Conditions of Use and Sale, so read them.

For the books, the practical points are:

  • Keep a receipt or order confirmation for every purchase, with the eBay order number stored alongside it.
  • Record supplier refunds and eBay buyer refunds as separate entries; they rarely land on the same day.
  • Post postage you pay, packaging and software subscriptions to their own cost categories.
  • Use one payment card per business where you can, so bank feeds match purchases cleanly.

Tools in your workflow should not muddy these records. Dropizon, for example, never handles money from your buyers, holds no stock and ships nothing: eBay pays you as normal and any supplier order sits in your own account. How Dropizon works explains the model.

What should you ask before choosing a connector?

  1. Does it support every eBay site you sell on, such as eBay.co.uk and eBay.com, and each currency?
  2. Does it split fees by type, including Promoted Listings fees, or post one fee line?
  3. How does it treat partial refunds, cancellations and fees charged after the sale?
  4. Does it keep taxes collected by eBay out of your income?
  5. Does it post through a clearing account so each payout reconciles to zero?
  6. How far back can it import, and can you re-run a month if something went wrong?
  7. If you are a UK seller who must use Making Tax Digital, does your accounting package support it?
  8. Can your accountant get access, or a clean export, without extra work?
  9. What happens to synced data if you cancel the connector?

Then test it. Connect one past month, run the sync and reconcile every payout in that month against your bank. A connector that cannot balance one month will not balance twelve.

What to do next

  • Download last month's transaction report from Seller Hub and note total sales, fees, refunds and payouts.
  • Set up a clearing account for each eBay site or currency you sell in.
  • Shortlist two connectors and put the questions above to each vendor.
  • Trial both on the same past month and keep the one that reconciles with fewer manual fixes.
  • Match every sale with its purchase record before the month closes.
  • Set a monthly reminder to reconcile payouts and check rolling turnover against the thresholds that apply to you.

Frequently asked questions

Do I need a separate connector for each eBay account?

Ask the vendor how it handles more than one eBay account or site before you buy. Whatever it supports, keep a separate clearing account for each eBay account and currency. That way each payout can be checked against its own balance and errors do not hide in a combined total.

What happens if a connector posts the same payout twice?

Your clearing account will no longer return to zero, which is the quickest sign of a duplicate. Find the repeated entries, delete or reverse one set and check that the bank match is still correct. Then ask the vendor why it happened, because duplicates usually point to a sync setting or a re-import.

Is a spreadsheet enough for bookkeeping on a small eBay store?

It can be at low volume, as long as you record sales, fees, refunds and payouts as separate columns and reconcile each payout. The cost is your time and the risk of typing errors. Once reconciling takes hours each month, a connector usually pays for itself in time saved.

Do I need to register as a business seller on eBay UK to use accounting software?

No, accounting software works whether or not you are registered as a business seller. The two questions are separate. eBay UK says you must register as a business seller if you buy items to resell, so check that rule for your own selling activity.

How long should I keep eBay transaction reports and receipts?

Keep them for at least as long as the tax authority that applies to you requires. HMRC and the IRS both publish record keeping guidance on their websites. Store eBay reports and supplier receipts together so either can be checked against the other later.