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
- Log in to eBay Seller Hub
- Navigate to Payments > Reports
- Select Transaction report as the report type
- Choose your date range (note: maximum 90 days per report)
- 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:
- Upload your eBay transaction report CSV
- Review the auto-categorized journal entry — every fee type is mapped to the correct accounting category
- Customize if needed — remap any category to match your chart of accounts
- 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.