PayPal to QuickBooks Desktop — CSV to IIF Converter
PayPal activity downloads include gross, fee, and net amounts for every transaction. This converter turns that CSV into QuickBooks Desktop import lines with the deposit, the fee, and the income split correctly.
Runs in your browser — your file never leaves your computer
- 1Load
- 2Map
- 3Review
- 4Download
What this tool accepts
A spreadsheet of transactions, written as balanced check and deposit blocks in a tab-delimited IIF file.
Files
CSV, XLS, or XLSX from your bank or payment processor
Columns
- Date — required — any common date shape
- Description — required — becomes the memo, and the payee if you opt in
- Amount — required — signed in/out, or use Debit + Credit columns
- Fee — optional — splits processor fees to their own account
Output
.iif · tab-delimited !TRNS/!SPL blocks, balanced to zero, dates as MM/DD/YYYY.
Then import in QuickBooks Desktop: File → Utilities → Import → Import IIF Files
How to use this file in QuickBooks Desktop
Work on a backup. Run File → Back Up Company first; imports are easiest to undo on a copy of the company file.
- In PayPal, go to Activity → Statements → Activity download and export the CSV for your date range.
- Load the CSV here — the PayPal preset maps Net to the bank amount, Fee to the fee column, and Date to the date.
- Enter your exact QuickBooks bank account name, a category account (such as Sales), and your fee account.
- Download the .iif and import it in QuickBooks Desktop: File → Utilities → Import → Import IIF Files.
- Verify a few transactions and compare totals against the PayPal balance report.
Import path: File → Utilities → Import → Import IIF Files