PayPal CSV to QBO Converter
Turn a PayPal activity download into a QBO file for QuickBooks. The converter recognizes PayPal's columns, uses the net amount after fees, and leaves out lines that don't change your balance.
Drop your bank file here or choose a file
CSV, Excel, QBO, QFX, OFX or QIF · stays on your device
No signup. Your file never leaves your computer. Works in your browser.
How to convert a PayPal CSV to QBO
- Download your PayPal activity as CSV In PayPal, open Activity, select the Download icon, choose Custom and the activity download, then pick the dates and CSV.
- Drop the file into the converter The converter recognizes PayPal's columns, even when you added or removed optional ones, and shows "PayPal activity" next to the file.
- Check the transactions Each line uses the Net amount (after PayPal's fee) and PayPal's transaction ID. Lines marked Memo under Balance Impact, such as holds, are left out and listed under skipped rows.
- Choose QBO and the bank PayPal isn't in Intuit's bank lists, so keep the widely compatible option and import into your PayPal account in QuickBooks.
- Download the QBO file Click Download QBO file and import it. The steps appear right after the download.
How to import the QBO file into QuickBooks
These steps follow Intuit's current help pages. Back up your company file first; Intuit notes that an import can't be undone.
QuickBooks Desktop for Windows
- Sign in to your Intuit account Intuit requires you to be signed in inside QuickBooks Desktop to import .qbo files.
- Open the import Choose Banking › Bank Feeds › Import Web Connect Files, select the .qbo file and click Open.
- Choose the account Choose Use an existing account if the account is already in QuickBooks, or Create a new QuickBooks account. Click Continue, then OK.
- Add the transactions Review them in the Bank Feeds Center and add them.
If the import fails, Intuit's fixes include switching to Classic Mode: Banking › Bank Feeds › Change Bank Feeds Mode.
QuickBooks Desktop for Mac
- Open the import Choose Banking › Downloaded Transactions › Import File.
- Pick the file Select the .qbo file.
- Choose the account If QuickBooks asks, pick the matching account under Store in the QuickBooks Account, then click Continue and OK.
QuickBooks Online
- Open Bank transactions Choose All apps › Accounting › Bank transactions. Older menus start at Banking or Transactions.
- Choose Upload from file Select the account's tile if you see one, open Link account and choose Upload from file.
- Pick the file and the account Select the .qbo file and click Continue. Choose the account in the QuickBooks account list and click Continue.
- Import Select the transactions to import, click Continue, then Yes and Done.
Intuit's limits for one upload: 350 KB per file and up to 1,000 lines.
Downloading your PayPal activity
PayPal’s help describes the download like this: go to Activity, select the Download icon, choose Custom, choose the activity download report, follow the prompts for the date range and the CSV format, and select Download when the file is ready. PayPal notes that large reports can take a while to prepare.
PayPal’s CSV columns
PayPal’s documentation lists the columns of the activity download. Some are always included and some you can turn on or off:
| Column | Used for |
|---|---|
| Date | The transaction date |
| Name | The description (the other party) |
| Type | The memo, for example Express Checkout Payment or General Withdrawal |
| Gross, Fee, Net | Net becomes the amount |
| Transaction ID | The transaction’s ID in the QBO file |
| Balance Impact | Debit, Credit or Memo; Memo lines are left out |
Because you can change the optional columns, the converter recognizes a PayPal file by the columns PayPal always includes (Date, Time, TimeZone, Name, Type, Status, Currency, Gross, Fee, Net and Transaction ID), not by the whole header row.
PayPal in QuickBooks
PayPal isn’t a bank in Intuit’s bank lists, so the QBO file uses the widely compatible bank ID. Import it into the account you keep for PayPal in QuickBooks; when you move money from PayPal to your bank, that line shows as money out of PayPal.
Supported banks and file layouts
Any bank's CSV or Excel file
The converter finds the header row (even below bank names and account summaries), matches columns by name and by content, and handles one signed amount column, separate debit and credit columns, or an amount with a DR/CR column. Dates like 01/05/2026, 2026-01-05 and Jan 5, 2026 and amounts like (1,234.56) or 1234.56- are all read.
Known layouts, picked automatically
- American Express card · Date, Description, Card Member, Account #, Amount, … 8 more
- Apple Card · Transaction Date, Clearing Date, Description, Merchant, Category, … 3 more
- Bank of America checking or savings · Date, Description, Amount, Running Bal.
- Bank of America credit card · Posted Date, Reference Number, Payee, Address, Amount
- Barclays credit card · Transaction Date, Description, Category, Amount
- Capital One 360 checking or savings · Account Number, Transaction Description, Transaction Date, Transaction Type, Transaction Amount, Balance
- Capital One credit card · Transaction Date, Posted Date, Card No., Description, Category, … 2 more
- Charles Schwab Bank checking · Date, Status, Type, CheckNumber, Description, … 3 more
- Charles Schwab Bank checking (older layout) · Date, Type, Check #, Description, Withdrawal (-), … 2 more
- Chase checking · Details, Posting Date, Description, Amount, Type, … 2 more
- Chase credit card · Transaction Date, Post Date, Description, Category, Type, … 2 more
- Citi credit card · Status, Date, Description, Debit, Credit
- Discover card · Trans. Date, Post Date, Description, Amount, Category
- Mercury transactions · Date (UTC), Description, Amount, Status, Source Account, … 9 more
- PayPal activity · Date, Time, TimeZone, Name, Type, … 11 more
- PNC checking or savings · Transaction Date, Transaction Description, Amount, Balance
- SoFi checking or savings · Date, Description, Type, Amount, Current balance, Status
- Square transactions · Date, Time, Time Zone, Gross Sales, Discounts, … 44 more
- Stripe balance report · balance_transaction_id, created_utc, available_on_utc, currency, gross, … 4 more
- USAA checking or savings · Date, Description, Original Description, Category, Amount, Status
- Venmo statement · ID, Datetime, Type, Status, Note, … 16 more
- Wells Fargo · 5 columns, no header row
Each layout was checked against the bank's own help pages or real sample files. If your bank changes its layout, the converter still reads the file by its column names.
Common problems and fixes
- Some PayPal lines are missing
- Lines whose Balance Impact is Memo (for example authorizations and holds) don't change your PayPal balance, so they are left out. Show skipped rows lists them.
- A line has no name
- PayPal leaves Name empty on some lines, such as withdrawals to your bank. The converter uses PayPal's transaction type (for example "General Withdrawal") as the description.
- The file has more than one currency
- The converter reads amounts as they are and doesn't convert currencies. If your PayPal file mixes currencies, check the Currency column in the CSV and remove the lines in other currencies first.
- The dates are day first
- PayPal writes dates in your account's country format. US accounts use MM/DD/YYYY; for others, choose the date order when the converter asks.
Gross vs Net in a PayPal file
| Gross | Net (used here) | |
|---|---|---|
| What it is | The full payment amount | The payment minus PayPal's fee |
| Matches your PayPal balance | No, fees are separate | Yes |
| Fee shown separately | In the Fee column | Already taken off |
Frequently asked questions
How do I convert a PayPal CSV to QBO?
Download your activity as CSV from PayPal, drop it into the converter above, check the transactions, keep QBO and download.
Why does the converter use the Net amount?
Net is what actually moved in your PayPal balance after fees, so the QBO file matches your balance. The Gross and Fee columns stay in your CSV if you need them.
Does PayPal offer QuickBooks files itself?
PayPal's help lists Quicken and QuickBooks formats among its download options, as well as CSV. Use PayPal's file if it works for you; convert the CSV when you want to check and edit the lines first.
How much history can I download?
PayPal's developer documentation says activity downloads go back up to seven years, with up to 12 months per report and up to 50,000 lines per CSV file.
Are PayPal's transaction IDs kept?
Yes. Each line's PayPal transaction ID becomes its ID in the QBO file, so QuickBooks can skip lines it has already imported.
Is my PayPal file uploaded?
No. It is read and converted in your browser and never leaves your computer.
Related tools
Last updated · EmproIT