Fee Splitting
Optional mode to create separate expense rows for PayPal fees - essential for tax deductions.
Enter your email to receive a sign-in link
Transform PayPal transaction history into QuickBooks-ready bank statements. Track PayPal income and fees in QuickBooks with automatic format conversion.
Free preview — then from $5. Save with bundles.Activity → All Reports → Activity download → Download CSV
Upload Activity Download CSV and choose Bank Transaction CSV (3-Column) format
Review converted data, download Quickbooks Online-ready file
Banking → Select Account → Upload from Computer → Import CSV
Output is in QuickBooks 3-Column Bank CSV format — ready to import directly, no manual reformatting needed.
Yes, if you want to track PayPal fees separately as business expenses for tax deductions. Fee split mode creates two rows per transaction: the gross income and the fee expense. This matches real-world accounting where fees are legitimate business expenses. Use net mode only if you prefer simple one-row-per-transaction tracking.
Log into PayPal Business → Reports → Activity Download → Select 'Customize download fields' → Choose date range → Download CSV. You can export up to 12 months at a time, with maximum 7 years of history available.
PayPal withdrawals to your bank will appear in both PayPal export and bank feed. Import PayPal transactions to a 'PayPal Clearing' account in QuickBooks, then record transfers as movements between PayPal and Bank accounts to avoid duplication.
Issues you might encounter when importing Activity Download data to Bank Transaction CSV (3-Column) - and how we solve them
PayPal export contains transactions in different currencies
USD, EUR, GBP in same file
Filter for USD only
QuickBooks requires single currency per account
Use currency filter or export by currency separately
File contains non-Completed transactions
Status: Pending
Status: Completed (filtered)
Enable 'Completed only' filter (default on)
Processor filters non-Completed by default
QuickBooks requires consistent MM/DD/YYYY format
01/15/2025, 1/5/2025 (mixed)
01/15/2025 (consistent)
Processor normalizes all dates to MM/DD/YYYY
Automatic - dates standardized during conversion
How Paypal Transactions fields map to Quickbooks Online Bank Transaction
| Paypal Transactions | Source Value | Quickbooks Online Bank Transaction | Target Value | Note | |
|---|---|---|---|---|---|
Date |
01/15/2025 |
→ | Date |
01/15/2025
|
Format to MM/DD/YYYY |
Net |
97.10 |
→ | Amount |
97.10
|
Net amount after fees (or Gross if fee-split mode) |
Fee |
-2.90 |
→ | Amount |
-2.90
|
Separate fee row (if fee-split mode enabled) |
Optional mode to create separate expense rows for PayPal fees - essential for tax deductions.
Automatically formats dates to MM/DD/YYYY as required by QuickBooks.
Combines transaction type, counterparty name, and notes for clear transaction records.
Filter multi-currency exports to match your QuickBooks account currency requirements.
Excludes pending, reversed, or refunded transactions by default.
All processing happens locally. Your PayPal data never leaves your computer.
Each PayPal transaction can become 1-2 rows (depending on fee-split mode)
Payment, refund, or withdrawal with fees
Date,
Gross,
Fee,
Net,
Name,
Type
Net-only or Gross+Fee split
Your PayPal → QuickBooks files stay on your device. Processing happens client-side, nothing leaves your machine.
Your PayPal → QuickBooks files are never cached, logged, or stored anywhere. Every session is ephemeral.
Designed for data sovereignty. No third-party trackers or analytics touch your PayPal → QuickBooks files.
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
All available data flows from Paypal to Quickbooks Online
Date → JournalDate
Transaction ID → JournalNo
Gross → Credits
Date → Date
Net → Amount
Name + Type → Description
This platform pair is available in 2 other hubs
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus
SpreadsheetBroccoli