Import PayPal Activity Into
QuickBooks — Free Converter

Why PayPal CSV Exports Need Conversion for QuickBooks

PayPal's Activity Download exports transaction data in a format designed for PayPal's own reporting ecosystem, not for accounting software like QuickBooks. While the CSV format is technically standard, the data structure creates several compatibility issues when importing into QuickBooks. The export includes dozens of non-payment transaction types (bank transfers, currency conversions, holds, and authorization events) that clutter your QuickBooks registers. Date formats vary by account locale — US accounts use MM/DD/YYYY while European accounts use DD/MM/YYYY, and QuickBooks always expects MM/DD/YYYY. Fees are in a separate column rather than being split into individual journal entries that QuickBooks can categorize. Without conversion, you're stuck manually filtering rows, reformatting dates, and reconciling fees — a tedious process that doesn't scale for high-volume PayPal merchants.

Common PayPal Import Errors

When attempting to import a raw PayPal Activity Download CSV into QuickBooks, users commonly encounter these issues:

• “Date format not recognized” — QuickBooks rejects DD/MM/YYYY dates from European PayPal accounts. It requires MM/DD/YYYY format and will refuse to import any file containing dates it can't parse.
• Duplicate or inflated totals — PayPal exports include non-payment rows like “General Withdrawal”, “Bank Deposit to PP Account”, and “Currency Conversion” that are internal banking operations. Importing these alongside actual payments creates duplicate entries and inflates your revenue or expense totals.
• Fee reconciliation issues — PayPal provides Gross, Fee, and Net as separate columns, but QuickBooks expects a single Amount column. If you import the Gross amount, your bank deposit (which is the Net amount) won't match, making reconciliation impossible without manual adjustments.
• Column mapping confusion — PayPal's 27-column export format includes fields like “From Email Address”, “Payment Source”, and “Reference Txn ID” that have no equivalent in the QuickBooks import template. QuickBooks only needs Date, Description, and Amount (or Credit/Debit for Desktop).

How the Converter Fixes These Issues

The PayPal to QuickBooks Converter addresses every compatibility gap between PayPal's export format and QuickBooks' import requirements:

• Transaction type filtering — Automatically excludes non-payment rows (General Withdrawal, Currency Conversion, Hold on Available Balance, Bank Deposit, Temporary Hold) and keeps only actual payment transactions (Express Checkout, Web Accept, Recurring, Subscription, Mobile, and Shopping Cart payments). You can toggle this filtering off if needed.
• Locale-aware date handling — The converter analyzes your date column to detect whether dates use MM/DD/YYYY (US) or DD/MM/YYYY (European) format. All dates are then normalized to MM/DD/YYYY, which is the format QuickBooks expects across all versions.
• Fee splitting — Each PayPal processing fee is extracted from the Fee column and added as a separate negative line item. This creates trackable expense entries so you can categorize fees under “Payment Processing Fees” in your chart of accounts.
• Column mapping — PayPal's 27 columns are condensed into the exact headers QuickBooks requires. QBO and Self-Employed get Date/Description/Amount; Desktop gets Date/Description/Credit/Debit. The description is built from Name, Item Title, and Invoice Number.

How to Export Your Activity from PayPal

Follow these steps to download your PayPal transaction history as a CSV file:

1. Log into your PayPal account at paypal.com.
2. Navigate to Activity from the top navigation bar. For business accounts, go to Reports → Activity Download.
3. Select your desired date range. PayPal allows exports of up to 3 years of history. For large ranges, consider exporting in monthly or quarterly batches.
4. Choose “CSV” (or “Comma Delimited - All Activity”) as the file format.
5. Click Download. The file will be saved as a CSV with all transaction columns including Date, Name, Type, Status, Gross, Fee, Net, and email addresses.

Importing into QuickBooks Online

After converting your PayPal CSV, follow these steps to import into QuickBooks Online:

1. Log into QuickBooks Online and navigate to Banking from the left sidebar.
2. Click Upload transactions (or “Link account” → “Upload from file” if this is your first import).
3. Select the converted CSV file from your computer.
4. QuickBooks will display a column mapping preview — verify that Date, Description, and Amount are mapped correctly.
5. Choose the QuickBooks account to import into (e.g., “PayPal” or “Payment Processing”).
6. Click Import to complete the process. Transactions will appear in the “For Review” tab.

Tip: Create separate accounts for “PayPal Sales” and “PayPal Fees” if you split fees during conversion.

Importing into QuickBooks Desktop

For QuickBooks Desktop (Pro, Premier, or Enterprise), use the Web Connect import method:

1. Open QuickBooks Desktop and go to File → Utilities → Import → Web Connect Files.
2. Browse to and select your converted file.
3. QuickBooks will prompt you to select the account for the imported transactions.
4. Click Continue to import. Transactions will appear in the bank register for review.

After import, verify that PayPal transaction type filtering excluded non-payment items like currency conversions and holds.

Alternatively, you can use our CSV to IIF Converter to generate an IIF file, which can be imported via File → Utilities → Import → IIF Files.

PayPal Fee Accounting Best Practices

Properly tracking PayPal processing fees is essential for accurate financial reporting. Here are the recommended practices:

• Create a dedicated expense category — Set up a “Payment Processing Fees” account under Expenses in your chart of accounts. This keeps PayPal fees separate from bank fees and other transaction costs.
• Use fee splitting for automatic journal entries — Enable the fee splitting option in the converter to generate separate line items for each processing fee. This eliminates manual fee entry and ensures every charge is captured accurately.
• Reconcile net deposits against bank statements — PayPal settles payments as net amounts (gross payment minus processing fee). When reconciling, match your bank deposits against the net amounts. The sum of fee line items should account for the difference between gross and net totals.
• Track PayPal vs. Stripe fees separately — If you accept payments through multiple processors, create sub-accounts under “Payment Processing Fees” for each provider. This gives you visibility into which processor costs more and helps with fee negotiations.
• Review currency conversion fees — For international transactions, PayPal may charge additional currency conversion fees on top of the standard processing fee. These appear as separate “Currency Conversion” rows in the export and are excluded by the type filter. If you need to track these, disable type filtering and look for those rows in your output.

Looking for a complete guide to PayPal bookkeeping? Read our PayPal Accounting Guide — covering fee structures for personal vs. business accounts, multi-currency transaction handling, dispute and chargeback accounting, and 1099-K tax reporting requirements.

Related Free Accounting Tools

The PayPal to QuickBooks Converter is part of our complete suite of free QuickBooks conversion tools:

• CSV to QBO Converter — Convert cleaned bank CSVs into Web Connect (.qbo) files for QuickBooks Online and Desktop.
• CSV to IIF Converter — Convert CSVs into Intuit Interchange Format (.iif) for QuickBooks Desktop import.
• Bank CSV Cleaner — Clean and normalize messy bank CSV exports before importing into QuickBooks.
• Stripe to QuickBooks Converter — Convert Stripe payment exports into QuickBooks-compatible format with fee splitting.
• QBO to IIF Converter — Convert existing QBO files to IIF format when you need to switch import methods.
• IIF to QBO Converter — Convert IIF files into QBO format for QuickBooks Online compatibility.
• IIF File Viewer — Inspect and validate IIF files before importing them into QuickBooks Desktop.
• Chart of Accounts Generator — Generate a customized chart of accounts for your QuickBooks company file.
• Square to QuickBooks Converter — Convert Square POS transaction exports with tip splitting and daily aggregation.
• Amazon to QuickBooks Converter — Convert Amazon Seller settlement reports with order aggregation and FBA fee categorization.
• Shopify to QuickBooks Converter — Convert Shopify payout exports with chargeback handling and multi-currency support.
• PDF to QBO Converter — Convert PDF bank statements to QBO, CSV, or IIF format.
• OFX to QBO Converter — Convert OFX bank statement files to QuickBooks Web Connect QBO format.
• QFX to QBO Converter — Convert Quicken QFX files to QuickBooks QBO format for seamless migration.
• QBO to CSV Converter — Export QBO transaction files to clean CSV spreadsheets for Excel and Google Sheets.
• OFX to CSV Converter — Convert OFX bank files to CSV format for spreadsheet analysis.
• OFX to IIF Converter — Convert OFX bank statements directly to QuickBooks Desktop IIF format.
• CSV to OFX Converter — Transform bank CSV exports into standard OFX format for financial software.
• QIF to QBO Converter — Upgrade legacy Quicken QIF files to modern QuickBooks QBO format.
• QBO to PDF Converter — Generate professional PDF bank statements from QBO transaction files.
• MT940 to QBO Converter — Convert SWIFT MT940 European bank statements to QuickBooks QBO format.
• QIF to CSV Converter — Convert legacy Quicken QIF files to clean CSV spreadsheets for analysis.
• QIF to IIF Converter — Convert Quicken QIF files directly to QuickBooks Desktop IIF format.
• IIF to CSV Converter — Export QuickBooks Desktop IIF files to CSV for spreadsheet analysis.
• QBO to OFX Converter — Convert QuickBooks QBO files to standard OFX format for other financial software.
• MT940 to CSV Converter — Convert SWIFT MT940 European bank statements to CSV spreadsheets.
• QBO File Viewer — Preview and inspect QBO Web Connect files before importing into QuickBooks.
• OFX File Viewer — Preview and inspect OFX bank statement files in a readable format.
• XLSX to QBO Converter — Convert Excel spreadsheets directly to QuickBooks Web Connect QBO format.
• Etsy to QuickBooks Converter — Convert Etsy shop payment exports into QuickBooks-compatible format.
• Duplicate Transaction Detector — Scan QuickBooks files to find and flag duplicate transactions before import.
• Import Troubleshooter — Diagnose and fix common QuickBooks file import errors automatically.
• File Format Detector — Identify unknown financial file formats and get conversion recommendations.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 bank statements to QuickBooks QBO format.