paypal · quickbooks · xero · multi-currency

PayPal → QuickBooks or Xero

Free PayPal CSV converter. Splits gross / fee / net into clean accounting rows, handles multi-currency, deduplicates refunds and reversals, and outputs QuickBooks-ready QBO or Xero-ready CSV.

Browser-side
Customer names, emails, and addresses stay on your device.
Gross / fee split
Each PayPal row becomes one income row + one fee row, ready to reconcile.
Multi-currency
One output file per currency — exactly how QuickBooks and Xero want it.

What gets normalized

Payment + fee split
Each completed payment becomes two rows: Sales income (gross) and PayPal fees (fee). Net matches your PayPal balance change exactly.
Refunds & reversals
Negative gross + positive fee refund. Reconciles cleanly with the original sale.
Currency conversions
PayPal's internal FX (e.g. EUR → USD) becomes a transfer pair so neither balance double-counts.
Skipped no-ops
Authorisations, temporary holds, and pending balance moves are filtered out — they don't affect your books.
Buyer / invoice ID kept
Memo column preserves the buyer name, transaction ID, and invoice number for AR matching.
Subscription handling
Recurring subscription receipts are tagged with the subscription ID for easy categorisation.

Related tools

FAQ

Why is PayPal's native CSV so hard to import?+

PayPal exports gross amount, fee, and net amount on the same row — but QuickBooks and Xero expect a single transaction amount per row. The fix is to split each PayPal transaction into two rows: one for the gross payment and one for the PayPal fee, posted to a Bank Fees expense account.

Does this work with PayPal Business CSV?+

Yes. The PayPal Business activity download (Reports → Statements → Activity download → CSV) is the canonical input. Personal PayPal activity CSV also works.

QuickBooks Online or Desktop?+

Both. Pick CSV output for QuickBooks Online (Banking → Upload from file) or QBO output for QuickBooks Desktop (File → Import → Web Connect).

Does it handle multi-currency?+

Yes. PayPal multi-currency CSVs are split per currency — each currency becomes its own output file, since QuickBooks and Xero require single-currency bank feeds.

Is my PayPal CSV uploaded?+

No. Parsing and conversion run entirely in your browser. PayPal CSVs contain customer names, emails, and addresses — keeping them local is the safer default.