Nanoscope Tools
Files processed in your session onlyNo account requiredOne-time purchasePrivacy & security →
Finance & Accountingwebapp

PayPal Activity to QuickBooks CSV

Turn your PayPal transaction download into a clean QBO bank import — dates, amounts, and descriptions all correctly formatted.

Use this tool — $7 per use$7 per use
Input
.csv
Output
.csv
#paypal#quickbooks#qbo#payments#csv#accounting#reconciliation

What it does

Upload a PayPal activity download (CSV). Get back a three-column CSV — Date, Description, Amount — ready to import into QuickBooks Online via Banking → Upload transactions.

The problem it solves

PayPal's activity CSV has separate columns for gross, fee, net, currency, balance, and item title. None of them map cleanly to QBO without manual reformatting. Amounts come through as strings with currency codes. Dates use PayPal's own format. This tool handles all of it.

What it handles automatically

  • Date reformatting — Converts PayPal's date format to MM/DD/YYYY
  • Amount calculation — Uses the net amount column (after PayPal fees), signed correctly
  • Currency filtering — Handles multi-currency accounts: select the currency you want to import
  • Description cleaning — Combines PayPal's Name and Item Title into a readable description

FAQ

What export should I use? In PayPal, go to Activity → Statements → Activity download. Choose "All transactions" and CSV format.

Does it handle refunds? Yes. Refunds appear as positive amounts (money back into the account) and are preserved correctly.

Does it store my data? No. Processing is entirely in your browser.

Related tools