# Convert PayPal CSV to QuickBooks (.QBO)

_Canonical: https://qbomaker.com/banks/paypal.html_

PayPal does not produce a QuickBooks Web Connect (.QBO) file. From the Reports area you can download an Activity Download report as a CSV, and that file is what you convert here. PayPal CSVs are notorious for being wide and a little fiddly, so it helps to know what you are looking at before you map columns.The PayPal export splits every payment into three money columns: Gross, Fee, and Net. Gross is the full amount, Fee is what PayPal kept, and Net is what actually hit your balance. For reconciliation, the Net column is usually what you want, because it matches the balance change. There is also a Balance Impact field that marks whether a row is a credit, a debit, or just a memo. Memo rows (like authorizations that never settled) should be left out so they do not clutter QuickBooks.When you export, choose Balance affecting transactions and the CSV format, and pick a date range up to twelve months at a time. Then bring the file here, map the Date column and the Net amount column, and download a .QBO that imports like a normal bank feed. If you would rather have fees booked as their own line, handle that with QuickBooks rules after import.

## Steps

1. Export your transactions from PayPal online banking as CSV or Excel.
2. Open the QBO Maker converter and drop the file in.
3. Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
4. Choose .QBO as the output and click download.
5. In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.

**Does PayPal give me a .QBO or .OFX file?**
No. PayPal exports an Activity Download report in CSV. To get a file QuickBooks Desktop can read, convert that CSV to .QBO with QBO Maker. The conversion runs in your browser.

**Should I import Gross or Net amounts?**
Map the Net column. Net is the amount that actually changed your PayPal balance, so it reconciles cleanly. If you import Gross and the Fee column separately, your totals will be off.

**How do I keep memo and pending rows out of QuickBooks?**
When you export, select Balance affecting transactions only. You can also filter out rows where Balance Impact is Memo in your spreadsheet before converting.

**Is any PayPal data uploaded during conversion?**
No. The whole conversion happens locally in your browser, so your PayPal CSV never leaves your computer. Convert your PayPal CSV now.

---
Convert free at https://qbomaker.com/#tool, runs entirely in your browser.