← Back to all posts

eBay Managed Payments Accounting: A Complete Guide

How eBay Managed Payments Changed Seller Accounting

When eBay transitioned from PayPal to its own Managed Payments system, it fundamentally changed how sellers receive money and how bookkeepers track it. Previously, PayPal was the payment processor: you could reconcile from your PayPal transaction history. Now, eBay handles everything — payment processing, fee collection, refunds, and payouts — in a single consolidated system.

For bookkeepers, this means the eBay transaction report is now your primary source document for eBay accounting. It contains every sale, fee, refund, and payout in one file. Understanding this report is essential for accurate financial reporting.

The good news: eBay's report is well-structured. The challenge: eBay's fee structure is more complex than most sellers realize, with multiple fee components per transaction that need to be broken out for proper accounting.

Anatomy of an eBay Transaction Report

Want to skip the manual work?

Upload your settlement file — no login required. SettleBooks parses it and generates a balanced journal entry in under 60 seconds.

Try the free Settlement Summary Viewer →

eBay's transaction report (downloadable from Seller Hub) is a CSV file with these key columns:

  • Transaction creation date: When the transaction occurred
  • Type: The transaction type (Order, Refund, Payout, Non-sale charge, Shipping label, etc.)
  • Order number: Links related transactions (sale, fees, refund) together
  • Net amount: The net effect on your eBay balance
  • Gross transaction amount: The full sale price or refund amount
  • Total fees: Sum of all eBay fees for this transaction
  • Payout ID: Groups transactions into a specific bank payout
  • Payout date: When the payout was sent to your bank

Each row represents a single event. A typical sale generates one row for the order and the fees are embedded in the Total fees column. Refunds, shipping labels, and other charges appear as separate rows.

Grouping by Payout

The most important concept for bookkeeping: group transactions by Payout ID. Each payout represents a discrete bank deposit. Your journal entry should correspond to one payout, not one order or one day.

Filter the report by Payout ID to isolate all transactions included in a specific bank deposit. The sum of all Net amounts for that Payout ID should equal the deposit amount in your bank account.

eBay Fee Types Every Bookkeeper Should Know

eBay's fee structure has multiple components that bookkeepers need to categorize correctly. Here's a complete breakdown:

Final Value Fee — Fixed

A flat per-transaction fee charged on every sale. Currently $0.30 per order in most categories. This appears as part of the Total fees column.

Accounting treatment: Debit to "eBay Final Value Fees" or "Marketplace Fees"

Final Value Fee — Variable

A percentage of the total sale amount (including shipping). The rate varies by category, typically 3% to 15%, with most categories at 13.25%.

Accounting treatment: Same account as the fixed portion — they're both components of eBay's take rate.

International Fee

An additional 1.65% fee on sales to international buyers. This applies on top of the standard Final Value Fee.

Accounting treatment: Debit to "eBay International Fees" or group with Final Value Fees. Breaking it out separately helps sellers evaluate whether international sales are profitable.

Promoted Listings Fee

If you use eBay Promoted Listings Standard (cost-per-sale advertising), the ad fee is charged as a percentage of the sale price when the item sells through an ad click.

Accounting treatment: Debit to "eBay Advertising" or "Marketing Expense" — keep separate from marketplace fees for ROAS analysis.

Fee Type Typical Rate Accounting Category
Final Value Fee (Fixed) $0.30/order Marketplace Fees
Final Value Fee (Variable) 3-15% of sale Marketplace Fees
International Fee 1.65% of sale Marketplace Fees or International Fees
Promoted Listings 2-20% of sale (seller-set) Marketing & Advertising
Shipping Labels Varies Shipping Expense
Dispute Fee $20/dispute Dispute Expense or Marketplace Fees
Regulatory Operating Fee ~0.3-0.5% Marketplace Fees

Shipping Labels

If you purchase USPS, UPS, or FedEx labels through eBay, the label cost is deducted from your eBay balance.

Accounting treatment: Debit to "Shipping Labels" or "Shipping Expense"

Dispute Fees

When a buyer opens an Item Not Received or Item Not As Described case that you lose, eBay charges a dispute fee (typically $20).

Accounting treatment: Debit to "Dispute Fees" or group with marketplace fees.

Regulatory Operating Fee

In some jurisdictions, eBay passes along a small regulatory operating fee to offset compliance costs.

Accounting treatment: Group with Final Value Fees unless you need granular tracking.

Building a Journal Entry from an eBay Payout

Let's walk through a concrete example. Suppose Payout #12345 contains:

  • 15 orders totaling $2,850.00 gross
  • Final Value Fees (fixed + variable): -$398.25
  • International fees on 3 orders: -$14.12
  • 2 Promoted Listings fees: -$18.50
  • 1 shipping label: -$8.75
  • 1 refund: -$45.00 (with $5.96 fee credit)
  • Net payout: $2,371.34

Your journal entry:

Account Debit Credit
Checking Account (Bank) $2,371.34
eBay Final Value Fees $398.25
eBay International Fees $14.12
eBay Advertising $18.50
Shipping Expense $8.75
Refunds Issued $45.00
Refund Fee Credits $5.96
Product Sales $2,850.00
Totals $2,855.96 $2,855.96

The entry balances. The bank debit ($2,371.34) matches the actual deposit to your bank account, which you can verify on your bank statement.

Understanding Refund Fee Credits

When a buyer receives a refund, eBay credits back a portion of the Final Value Fee. This is important to capture — it reduces your effective fee expense. In the journal entry above, the $5.96 credit offsets the fees, keeping your totals balanced.

How to Download Your eBay Transaction Report

  1. Log in to eBay Seller Hub
  2. Navigate to Payments > Reports
  3. Select Transaction report as the report type
  4. Choose your date range (note: maximum 90 days per report)
  5. Click Download

You'll receive a CSV file with all transactions for the selected period. For bookkeeping, we recommend downloading monthly and filtering by Payout ID for each journal entry.

Important: The 90-Day Report Limit

eBay only allows downloading transaction reports for the past 90 days. If you fall behind on bookkeeping, you risk losing access to the data. Set a calendar reminder to download monthly at minimum.

Importing into Your Accounting Software

Once you've built your journal entry, you need to get it into your accounting system. The process varies by platform:

QuickBooks Online

Export your journal entry as a CSV with Date, Account, Debit, Credit, and Memo columns. Import via the journal entry import feature, or enter manually for low volume. For QuickBooks Desktop, you'll need the IIF format.

SettleBooks can export your eBay payout as a QBO-compatible CSV or IIF file.

Xero

Xero accepts manual journal imports via CSV. You'll need Narration, Date, Account Name, and Line Amount columns (positive for debits, negative for credits).

SettleBooks can format your eBay journal entry as a Xero-compatible CSV.

Sage

Sage Accounting uses a specific CSV format with Nominal Codes, Date (DD/MM/YYYY), Debit, and Credit columns. This format isn't supported by most eBay accounting tools.

SettleBooks has a dedicated Sage CSV exporter for eBay — one of the few tools that supports this format.

eBay vs. Amazon vs. Shopify: Key Accounting Differences

Understanding how eBay differs from other marketplaces helps bookkeepers who manage multi-channel sellers:

Aspect eBay Amazon FBA Shopify
Fee structure FVF (fixed + variable) + international + ads Referral + FBA + storage Payment processing only
Fee complexity Medium (4-6 fee types) High (15+ fee types) Low (1 fee type)
Payout grouping By payout ID By settlement period By payout
Report format CSV TSV (tab-separated) CSV
Report time limit 90 days Unlimited Unlimited
Payment processing Built into FVF Not included Included in fee
Refund fee handling Partial credit back Partial credit back Full credit back

Key Takeaway for Multi-Channel Bookkeepers

eBay's fee structure sits in the middle of the complexity spectrum — more complex than Shopify (which just has a processing fee) but simpler than Amazon (which has 15+ fee categories). The biggest eBay-specific challenge is the FVF split into fixed and variable components, plus the international fee surcharge.

Edge Cases and Gotchas

Hold and Release Transactions

eBay may hold payouts on new accounts or accounts with performance issues. Hold transactions reduce your available balance without an actual payout. When the hold is released, you'll see a corresponding release transaction. Don't record holds as expenses — they're timing differences, similar to Shopify reserves.

Dispute Reversals

When you win a buyer dispute, eBay reverses both the refund and the dispute fee. Make sure to capture both the refund reversal (credit to Refunds) and the fee reversal (credit to Dispute Fees).

Non-Sale Charges

eBay may charge non-sale fees like store subscription fees, insertion fees for over-limit listings, and account-level adjustments. These appear as "Non-sale charge" type transactions and should be categorized separately from per-transaction fees.

Partial Refunds

Partial refunds are common on eBay. The fee credit on a partial refund is proportional to the refund amount, not the full original fee. Make sure your calculations account for this.

Multi-Currency Sales

If you sell internationally and receive payments in foreign currencies, eBay converts to your payout currency. The conversion fee is embedded in the exchange rate rather than appearing as a separate line item. Track the effective exchange rate for your records.

Automating eBay Accounting with SettleBooks

Building eBay journal entries manually is doable but tedious, especially with the FVF split and international fee calculations. SettleBooks automates the entire process:

  1. Upload your eBay transaction report CSV
  2. Review the auto-categorized journal entry — every fee type is mapped to the correct accounting category
  3. Customize if needed — remap any category to match your chart of accounts
  4. Export in your preferred format: QBO CSV, IIF, Xero CSV, Sage CSV, or generic CSV

The tool handles all the edge cases described above: refund fee credits, dispute reversals, non-sale charges, and multi-payout reports. Upload once, download a balanced journal entry for each payout.

Try it free with your first settlement: Convert an eBay report now.

Chart of Accounts Recommendations for eBay Sellers

For most eBay sellers, we recommend these accounts:

Account Type What Goes Here
Product Sales Revenue Gross sale amounts
Shipping Revenue Revenue Buyer-paid shipping (if tracked separately)
eBay Final Value Fees Expense FVF fixed + variable + regulatory
eBay International Fees Expense International fee surcharge
eBay Advertising Expense Promoted Listings fees
Shipping Expense Expense eBay-purchased shipping labels
Refunds Issued Contra-Revenue Customer refunds
Dispute Fees Expense Lost dispute charges
Other eBay Fees Expense Catch-all for uncommon charges

If you don't need the granularity, you can combine Final Value Fees, International Fees, and Regulatory Fees into a single "eBay Marketplace Fees" account. The key is consistency — use the same accounts every period.

Summary

eBay Managed Payments has simplified the payment flow for sellers but requires bookkeepers to understand the transaction report structure and fee components. Group transactions by Payout ID, break out each fee type for proper categorization, capture refund fee credits, and verify that your journal entry balances against the bank deposit. Whether you build journal entries manually or use an automated tool, accurate eBay accounting starts with understanding what's in the report.

Ready to convert your settlement files?

Upload your Amazon, Shopify, Etsy, Walmart, eBay, TikTok Shop, or Mercari settlement report and get clean journal entries in seconds.

Try SettleBooks Free