Native IIF Format
Output is ready for QuickBooks Desktop import - no conversion needed.
Enter your email to receive a sign-in link
Convert PayPal Activity Download to QuickBooks Desktop IIF format with automatic fee tracking. Works with QB Pro, Premier, and Enterprise.
Free preview — then from $5. Save with bundles.Activity → All Reports → Activity download → Download CSV
Upload Activity Download CSV and choose IIF File format
Review converted data, download Quickbooks Desktop-ready file
File → Utilities → Import → IIF Files → Select File
Output is in QuickBooks Desktop IIF format — ready to import directly, no manual reformatting needed.
How Paypal Transactions fields map to Quickbooks Desktop Iif
| Paypal Transactions | Source Value | Quickbooks Desktop Iif | Target Value | Note | |
|---|---|---|---|---|---|
Date |
01/15/2025 |
→ | DATE |
01/15/2025
|
Transaction date |
Transaction ID |
9AB12345CD678901E |
→ | DOCNUM |
9AB12345CD678901E
|
Document/reference number |
Net |
97.10 |
→ | AMOUNT (TRNS) |
|
Net amount to PayPal account |
Gross |
100.00 |
→ | AMOUNT (SPL1) |
|
Gross amount to income/expense |
Fee |
-2.90 |
→ | AMOUNT (SPL2) |
|
Fee amount to expense account |
Name |
John Smith |
→ | NAME |
John Smith
|
Payee/customer name |
Each PayPal transaction becomes TRNS/SPL/ENDTRNS block
Single row with Gross, Fee, Net amounts
Date,
Transaction ID,
Gross,
Fee,
Net
Hierarchical TRNS/SPL structure for QuickBooks Desktop
QuickBooks Pro, Premier, and Enterprise versions from 2020-2025 all support IIF import. The file menu location is: File → Utilities → Import → IIF Files.
After import, run the Profit & Loss report and check your PayPal bank account register. The register should show the imported transactions with the correct dates and amounts.
Yes, PayPal exports automatically include processing fees and refunds as separate transactions, which import as negative amounts in QuickBooks Desktop.
Output is ready for QuickBooks Desktop import - no conversion needed.
Gross/Fee/Net split into balanced transaction blocks. All amounts sum to zero.
Compatible with QuickBooks Pro, Premier, and Enterprise (2020-2025).
Payments, refunds, and transfers automatically mapped to appropriate QuickBooks types.
Upload → Preview → Download. No API, no sync, no waiting.
Every transaction balances correctly. IIF validation built-in.
Issues you might encounter when importing Activity Download data to IIF File - and how we solve them
QuickBooks can't find account in Chart of Accounts
ACCNT: 'PayPal Account' (doesn't exist)
ACCNT: 'Checking' (matches QB)
Create accounts in QB first or use matching names
Edit account names in tool options before converting
IIF requires all AMOUNTs to sum to zero
TRNS: 97.10, SPL: -100.00 (gap of 2.90)
TRNS: 97.10, SPL1: -100.00, SPL2: 2.90 (balances)
Fee split ensures amounts balance correctly
Our converter automatically creates balanced entries
No server round-trips. Your PayPal → QuickBooks Desktop data is processed entirely in the browser tab.
The moment you close the page, all PayPal → QuickBooks Desktop data is wiped from browser memory. No traces left.
Meets GDPR requirements by design — no data processing on external servers, ever.
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
All available data flows from Paypal to Quickbooks Desktop
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus
SpreadsheetBroccoli