eBay Managed Payments payouts to Xero
Upload the eBay Managed Payments payout or settlement report and download two things: a bank-style file of the individual lines, and a payout journal that splits each payout into gross sales, fees, refunds, chargebacks and net so the bank line reconciles in Xero.
First 5 pages free. No card, no account until you download.
| Description | Account | Debit | Credit |
|---|---|---|---|
| Gross sales | 200 | 1,000.00 | |
| eBay Managed Payments processing fees | 404 | 29.50 | |
| Refunds | 200 | 50.00 | |
| Net payout to bank | 090 | 920.50 |
Where the report is in eBay Managed Payments
Payments > Reports > Transaction report (CSV) and payout details.
How eBay Managed Payments fees work
Payouts are net of final value fees and ad fees, listed per order.
Posting it in Xero
Xero's Stripe feed only records fees automatically for invoices paid through Xero. For everything else you post the payout journal yourself; PayoutParse produces it in Xero's manual journal CSV format (Accounting > Manual journals > Import). The journal PayoutParse produces uses Sales, Fees and a bank clearing line per payout; change the account codes in the file to match your chart of accounts before importing.
The check
For each payout, gross less fees less refunds less chargebacks plus adjustments must equal the printed net. If it doesn't, the file is marked needs review and is not charged.
Other software
eBay Managed Payments to QuickBooks Online, eBay Managed Payments to Sage Accounting, eBay Managed Payments to FreeAgent.