BooksReady

Convert a PayPal activity CSV to QuickBooks Online

In short: PayPal's activity download has separate Gross, Fee and Net columns, date and time in separate columns, three rows for a currency conversion, and holds that never change your balance. QuickBooks Online imports bank CSV files with exactly 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one header row and one date format throughout. Drop the file below. It is converted on your device and never uploaded.

Convert your file

PayPal to QuickBooks Online (CSV)

Download.CSV from PayPal Activity > Download

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

One email when it ships. The address is used for nothing else. Details.

1. Export the file from PayPal

  1. Sign in to PayPal on a computer and open Activity.
  2. Click the Download icon (or go to Reports > Activity download).
  3. Choose a date range of up to 12 months and the CSV format.
  4. Pick "Balance affecting" transactions if you are offered the choice.
  5. Download the file (large reports are emailed) and upload it here.

Why a raw PayPal export fails in QuickBooks Online

Imported raw, QuickBooks Online makes you choose a single amount column. Gross overstates the money that reached PayPal, Net hides the fees, and holds and memo rows slip in as if they were real money.

QuickBooks Online maps the first row as column names and expects every following row to be a transaction. Extra header lines, balance and total rows, currency symbols, and cells that contain only zero are common reasons an upload fails or imports wrong amounts.

What is unusual about the PayPal file

  • Columns can be added or removed in PayPal, so we read them by name.
  • Date and number formats follow your PayPal country (for example 01/31/2025 and 1,234.56 in the US, 31/01/2025 and 1.234,56 in Europe).
  • Fees are negative and Net is Gross plus Fee.
  • A purchase in another currency appears as three rows (the payment and two "General Currency Conversion" rows); each currency is its own balance.
  • Holds and their releases, and "Memo" rows, do not change your balance and are left out.
  • The file may start with an invisible byte-order mark.
  • Headers are translated if your PayPal is not in English; switch to English before downloading.

What QuickBooks Online requires

  • Columns exactly Date, Description, Amount.
  • Money in is positive, money out is negative; no currency symbols or thousands separators.
  • One date format for the whole file.
  • Up to 1,000 rows and 350 KB per upload (we split bigger files).

2. Before and after

Before: the PayPal activity CSV as downloaded

"Date","Time","TimeZone","Name","Type","Status","Currency","Gross","Fee","Net","From Email Address","To Email Address","Transaction ID","Shipping A...
"03/30/2025","18:22:05","PDT","","General Withdrawal","Completed","USD","-1,000.00","0.00","-1,000.00","seller@example.com","","9WD00000TEST0010","...
"03/28/2025","09:01:12","PDT","Sample Hosting Co","PreApproved Payment Bill User Payment","Completed","EUR","-20.00","0.00","-20.00","","","9WD0000...
"03/28/2025","09:01:12","PDT","","General Currency Conversion","Completed","USD","-21.84","0.00","-21.84","","","9WD00000TEST0008","","","","","","...
"03/28/2025","09:01:12","PDT","","General Currency Conversion","Completed","EUR","20.00","0.00","20.00","","","9WD00000TEST0007","","","","","","",...
"03/20/2025","14:10:00","PDT","Casey Buyerperson","Payment Refund","Completed","USD","-50.00","1.20","-48.80","","casey@example.com","9WD00000TEST0...
"03/18/2025","11:00:00","PDT","Sample Hardware Store","Account Hold for Open Authorization","Pending","USD","-1.58","0.00","-1.58","","","9WD00000T...
"03/18/2025","11:05:00","PDT","Sample Hardware Store","Reversal of General Account Hold","Completed","USD","1.58","0.00","1.58","","","9WD00000TEST...
"03/12/2025","8:15:30","PDT","Casey Buyerperson","Shopping Cart Item","Completed","USD","50.00","0.00","50.00","","","9WD00000TEST0003","","","Prin...

After: what QuickBooks Online receives

After: paypal-2025-03-02-to-2025-03-30-quickbooks-3col.csv
DateDescriptionAmount
03/02/2025Riley Clientname - MONTHLY - 1 for the first 2 Months, then 6.99 / Month1250.00
03/02/2025Fee: Riley Clientname - MONTHLY - 1 for the first 2 Months, then 6.99 / Month-46.73
03/12/2025Casey Buyerperson - Print, 8x10 "Sunset"50.00
03/12/2025Fee: Casey Buyerperson - Print, 8x10 "Sunset"-2.24
03/20/2025Casey Buyerperson - Payment Refund-50.00
03/20/2025Fee: Casey Buyerperson - Payment Refund1.20

Synthetic sample data that follows the real export layout, not a real account. The "after" output was produced from it by the same converter this page runs.

3. Import the converted file into QuickBooks Online

  1. Go to Transactions > Bank transactions > Link account (or Update) > Upload from file.
  2. Choose this CSV and the account to put it in.
  3. Map the columns: Date to Date, Description to Description, Amount to Amount (one column).
  4. Pick the date format MM/dd/yyyy (or the one you chose here) and confirm that the first row is a header.
  5. Review the transactions under For review.

Questions

Should I download "Balance affecting" or "All transactions"?
Pick balance affecting if you are offered the choice. Either way, the converter leaves out holds, their releases and Memo rows, because they do not change your PayPal balance.
Should I choose 3 columns or 4 columns?
Both import the same transactions. The 3-column file has one signed Amount, negative for money out. The 4-column file splits money in (Credit) and money out (Debit) and leaves the unused side blank, which is what Intuit asks for. Use 3 columns unless your accountant prefers the other; switch "To" in the converter to get the 4-column file.
How are PayPal fees handled?
By default each payment is written as the gross amount plus a separate fee line, so the fee can go to a merchant fees expense account and the running balance still matches PayPal. Choose "Net amount only" in the options for one line per payment.
Why does QuickBooks reject my file as too large?
Intuit documents a limit of 350 KB and 1,000 lines per manual upload in QuickBooks Online. When your converted file is bigger, the converter also gives you numbered parts that each fit; upload them one after another.

Other ways to convert PayPal

Other exports to QuickBooks Online (CSV)

Common import problems