QBOConverter

PayPal activity to QuickBooks — monthly summaries, verified against your balance

Drop in the activity download CSV from PayPal — get back a QuickBooks-ready .QBO (Web Connect) file.

Drag & drop your PayPal activity CSV here

or

Your report is parsed in memory and immediately discarded — never stored, never logged.

How it works

1

Download the activity

PayPal → Activity → Download (or Reports → Activity download) → pick the date range → format CSV → Create Report. Both the current and the pre-2020 "Download History" layouts are recognized automatically.

2

Check the match

Each month shows one summary line, and the file-level line proves the books: activity − withdrawals = ending balance, checked against the Balance column row by row (the file lists newest first — the chain is walked oldest-first).

3

Export & import

Download QBO, CSV, or XLSX and import into QuickBooks in a couple of clicks. Summary lines are dated on the last day of the month, like a bank statement.

What goes into each line

One month becomes 2–5 booked lines:

The four buckets

Sales — payments received at gross (shopping-cart, website, eCheck, subscription payments…). Refunds — refunds and chargebacks at gross. Fees — PayPal processing fees (stored negative: Net = Gross + Fee), including the partial fee giveback on refunds and the $15 chargeback fee. Other — currency conversions and similar non-P&L movements. "General Withdrawal" rows are transfers to your own bank — they are never booked as income or expense, only used for the balance cross-check.

Frequently asked questions

Which PayPal file exactly does this page take?

The Activity download CSV (Activity → Download, or Reports → Activity download). Both header layouts are sniffed automatically: the current one (with "Balance Impact") and the pre-2020 Download History one (with "Time Zone"). Simplified exports that rename Gross to "Amount" work too.

Why not just import every PayPal row into QuickBooks?

Row-level PayPal imports double-count: the money lands in your bank as one lump withdrawal, while the register fills with per-payment rows that match nothing. Monthly summaries book the same income and fees with a few lines — and because withdrawals are excluded, nothing is booked twice when you also import the bank side.

What does the file-level check actually prove?

PayPal's Balance column is the account balance after each row. Walking it oldest-first, opening balance + every row's Net = ending balance must hold for every single row. If the export is truncated (a missing day in the middle), the chain breaks and you get a warning — so a green ✓ means the file is complete and the monthly totals are whole.

What do I get for free, and what does the license add?

Parsing and the full preview are free, always. Free export covers the first 25 summary rows — enough to prove the totals end-to-end. A one-time $1.99 license exports all months for 7 days — no subscription, nothing to cancel.

My PayPal dates are MM/DD/YYYY — is DD/MM supported?

The parser reads US-style MM/DD/YYYY, which is what US PayPal accounts export. If your account is set to a DD/MM region, check the preview dates before exporting — a day/month swap is easy to spot (months above 12 are impossible, so most rows simply fail to parse and get flagged).

Is my activity file uploaded anywhere?

Yes — the report text goes over an encrypted connection to the parser, which runs in memory and discards it the moment your result comes back. Nothing is written to disk, a database, or logs. If a parse ever fails, one masked structural digest (every letter and digit replaced — no readable content) may be kept to fix the parser. Details in the Privacy Policy.

I already paid but lost my license key — what do I do?

Your license key is shown on your Gumroad receipt, which was sent to your inbox right after purchase — search for "Gumroad" and open that receipt to copy the key. Then use the "Enter license key" link in the top navigation to reactivate unlimited exports.