How to import a PayPal CSV into QuickBooks Online

QuickBooks Online rejects a raw PayPal export on the first try, every time. Here's exactly why, how to fix it yourself in a spreadsheet, and the one-click shortcut if you'd rather skip it.

Why QuickBooks Online rejects it

PayPal's export ("Balance Affecting Payments") includes columns like Date, Time, Name, Type, Status, Currency, Gross, Fee, Net, and email addresses — often a dozen or more. QuickBooks Online's bank-import tool only accepts a strict 3-column format: Date, Description, Amount. Anything else in the file and it rejects the whole upload rather than guessing which columns to use.

Option 1: Fix it by hand

Free, but tedious if you do it every month.

  1. In PayPal, go to Activity → Statements → Download, and export your transactions as CSV for the date range you need.
  2. Open the file in Excel or Google Sheets.
  3. Add a new column for Description, combining the Name and Type columns for each row (e.g. "Jane Miller Express Checkout Payment").
  4. Reformat every date in the Date column to MM/DD/YYYY if it isn't already.
  5. Use the Net column as your Amount — not Gross. Net is what actually moved in or out of your balance after PayPal's fee.
  6. Delete every other column so only Date, Description, and Amount remain, in that order, with those exact headers in row 1.
  7. Strip any $ signs or thousands-separator commas from the Amount column — QBO's importer chokes on both.
  8. Save the file as CSV (UTF-8 encoding).
  9. If you have more than ~1,000 transactions, split the file into smaller date ranges before importing — QBO's importer has a practical row limit.
  10. In QuickBooks Online, go to Banking → Upload transactions and import the file.

Option 2: Skip the manual work

Web App

PayPal to QuickBooks

Upload your raw PayPal export, get back a QuickBooks-ready CSV in seconds — dates, descriptions, and Net amounts handled automatically.

From $14
Try it

Frequently asked questions

Why does QuickBooks Online reject a PayPal CSV export?
PayPal's export has far more columns than QBO's bank-import format expects. QBO wants exactly Date, Description, and Amount — nothing else — so it rejects the file rather than guessing which columns matter.

Which PayPal column is the real transaction amount?
Use Net, not Gross. Gross is the amount before PayPal's fee is deducted; Net is what actually hit your balance.

What date format does QuickBooks Online need?
MM/DD/YYYY. PayPal sometimes exports dates in a different order depending on your account region.

Is there a row limit for QuickBooks Online CSV imports?
Stay under roughly 1,000–1,500 transactions per file. Split larger exports by date range.

← Back to DigitalBuilds.org