LedgerPortConvert a PayPal CSV to QBO
Download your PayPal transactions as CSV, drop the file below, and get a QBO file QuickBooks can import. The file is converted in your browser and never uploaded.
Confirming your payment…
Your licence key. Keep it: it unlocks your other computers, and it is printed on your invoice.
Your file is read on this device. It is never uploaded.
| File | Transactions | Status |
|---|
More than one account? Give each its own number, and reuse it every time, so your software files each statement under the right account.
More file details (optional)
These only label the file. The default bank ID 3000 is one QuickBooks recognises; you still choose your real account during import.
Columns (change these if the preview looks wrong)
| Date | Description | Amount |
|---|
Not reading your file correctly? Send us the column names
Your pass has ended. Lifetime keeps you going for good, and the pass you bought is deducted from its price.
Your 10 free documents have been used. Unlock this file, and every file after it:
Pay with CardApple PayGoogle PayLink
14-day refund if it does not work with your file. Secure checkout by Stripe: card, Apple Pay or Google Pay, with an invoice by email. Your file stays open here while you pay.
Buying for a team? Firm plans start at 3 users, at $69 per user a year.
Your licence
- Never uploaded. The file is converted on your device; it works with the internet off.
- See it before you pay. Every transaction is previewed for free.
- 10 documents free. No card, no account, no key.
- 14-day refund if it does not work with your file.
Getting the CSV from PayPal
Sign in on the PayPal website, open the account, and look for the option to download or export activity. Choose the date range you need and pick CSV (sometimes labelled "Spreadsheet" or "Excel CSV") as the file type. Mobile apps often lack this option, so use a desktop browser.
How the PayPal file is read
PayPal activity exports have many columns, including Date, Time, Name, Type, Status, Currency, Gross, Fee, Net and Balance.
- The Net column is used as the amount, so each sale arrives with PayPal's fee already taken off and the total matches your PayPal balance.
- Rows with no name, such as withdrawals to your bank, are named after their Type column.
- If you would rather record gross sales and fees separately, open Columns and set Amount to Gross.
- Export one currency at a time; a QBO file holds a single currency.
Importing the QBO file
QuickBooks Desktop: choose File → Utilities → Import → Web Connect Files, select the file, and pick the account. QuickBooks Online: go to Transactions → Bank transactions, open the menu next to Link account, and choose Upload from file. The import guide has the full steps, and there is a page on fixing import errors.
Need a different output? The same file converts to QFX for Quicken, OFX or QIF.
Questions and answers
Does PayPal see or approve this?
No. LedgerPort is an independent tool and is not affiliated with PayPal. It only reads the file you downloaded, on your own device.
What if my export looks different from the one described?
Banks change their exports from time to time. The converter works from the column names and the data rather than a fixed template, and you can reassign any column in the Columns panel.
Is it free?
Your first 10 documents are free, whatever their size, with no card and no licence key. After that, plans start at $9. See pricing.