PayoutParse

PayPal payouts to Xero

Upload the PayPal 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.

PayPal payout (sample)synthetic
  1. 01/06Gross sales1000.00
  2. 01/06PayPal fees-29.50
  3. 02/06Refunds-50.00
  5. Movements920.50
  6. Total920.50
  7. Statement920.50
Agrees with statement3 lines

Where the report is in PayPal

Activity > Statements > monthly statement (PDF) or the Activity download (CSV).

How PayPal fees work

PayPal shows Gross, Fee and Net per transaction. Withdrawals to the bank appear as separate lines.

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

PayPal to QuickBooks Online, PayPal to Sage Accounting, PayPal to FreeAgent.