PayoutParse

eBay Managed Payments payouts to FreeAgent

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 FreeAgent.

First 5 pages free. No card, no account until you download.

payoutparse.com/app/job/example
Example payout journal, synthetic figures. Account codes are editable in the file.
DescriptionAccountDebitCredit
Gross sales2001,000.00
eBay Managed Payments processing fees40429.50
Refunds20050.00
Net payout to bank090920.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 FreeAgent

FreeAgent imports a 3 column CSV (date, amount, description). The payout split is provided as a separate journal CSV. 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 Xero, eBay Managed Payments to QuickBooks Online, eBay Managed Payments to Sage Accounting.