PayPal Statement PDF to OFX, QFX and QIF: PayPal to Quicken Converter

What file formats does PayPal export?

PayPal offers five. The Activity Download report is available as PDF, CSV, TAB, IIF and QIF, where IIF is described as the QuickBooks format and is limited to US accounts, and QIF is described as the Quicken format and is limited to USD. Monthly statements are separate and come as PDF or CSV. There is no OFX and no QFX anywhere in that list.

Two limits sit on top of the formats. Any single report can cover a maximum range of twelve months, drawn from up to seven years of history, and CSV or TAB reports are capped at 50,000 records, after which the report is split across multiple files and packaged as a ZIP.

How do I download a PayPal statement?

Open the PayPal reports area and go to the monthly statements list, then click Request next to the month you want and download the PDF once it has been generated. Statements become available any time after the 2nd of the following month, and in some countries PayPal generates them automatically as a PDF by the 10th.

Keep an eye on the retention window while you are there. PayPal gives access to two years of historical monthly statements and twelve custom statements from the reporting portal. Activity data itself stretches back seven years, but you pull that as a report rather than as a statement, and a report request covers at most twelve months at a time.

Can I import PayPal transactions into Quicken?

Not with the file PayPal gives you, in most cases. PayPal Quicken export is a QIF, and Quicken states that QIF import is not available for checking, savings or credit card accounts. It supports QIF for asset, liability and cash accounts, which is not where a PayPal balance normally lives.

The file Quicken actually wants for a bank or credit card account is a QFX, imported through File then File Import then Web Connect File. Since PayPal does not produce a QFX, converting the statement PDF into one is the route that works. The convert a bank statement to Quicken page walks through the import itself, and the QIF file format page explains why the format behaves the way it does.

Can I import PayPal into QuickBooks Online?

Not using the IIF that PayPal offers. IIF is a QuickBooks Desktop format, and QuickBooks Online imports CSV, XLS or XLSX and Google Sheets natively rather than IIF. QuickBooks Desktop is the other way around: its Web Connect importer reads QBO files only, and will not take a QFX or a QIF.

So the format you need depends entirely on which QuickBooks you run, and PayPal offers neither of the two that would work. Our guide to importing a bank statement into QuickBooks sets out the exact route for each version, including the row and file size limits QuickBooks Online enforces on uploads.

How far back can I get PayPal transactions?

Seven years for activity reports and two years for monthly statements. That gap is the single most useful thing to know before you start a cleanup, because the neat monthly statement most people want is the one that expires first.

The practical move is to request every month you might need while it is still inside the two year window and save the PDFs somewhere durable. A saved PDF stays convertible long after PayPal stops regenerating it, which is exactly the situation this converter is built for.

Does a PayPal statement include pending transactions?

No. PayPal states that monthly statements include only transactions that affect your balance, and specifically excludes uncaptured authorizations, pending eChecks and unresolved disputes. The statement gives you beginning and ending balances, total debits and credits, and the balance affecting activity in between.

This is why a statement and the balance on screen so often disagree, and it is a feature rather than a fault. Reconcile to the statement ending balance and the two will line up. Reconcile to the live balance and you will chase a difference that resolves itself a few days later.

Should I export OFX, QFX or CSV from a PayPal statement?

Export OFX or QFX when the account will be imported more than once, or when date ranges might overlap. Both formats give every transaction a FITID, a unique identifier the receiving program stores, so a month that has already been imported is recognized instead of added a second time. QFX is the Intuit variant of OFX and is what Quicken expects.

Export CSV for a one time load, a review pass, or software that maps columns during import. It is the easiest format to eyeball before anything is written into your books, and for a period that has never been imported there is nothing for duplicate protection to guard against. The tradeoff is that CSV carries no transaction ID, so a second import of the same period will double it.

Why does my PayPal import create duplicate transactions?

Because the file you imported carried no transaction identifier. CSV, TAB, QIF and IIF all describe a transaction without giving it a unique ID, so the receiving program has no way to tell a row it has already seen from a genuinely new one. Import an overlapping month and the overlap is added twice.

OFX and QFX solve this at the file level. Every transaction carries a FITID, the program stores it, and the second import of the same period is matched and skipped. If you are converting a run of monthly PayPal statements where the boundaries might overlap, exporting OFX or QFX rather than CSV is the difference between a clean register and an afternoon of deletions.

Can I convert several PayPal statements at once?

Yes. Up to 50 files can be uploaded in a single batch, and statements belonging to the same account can be merged before extraction so a folder of monthly PDFs comes back as one continuous file rather than twelve separate imports.

That matters more with PayPal than with a bank, because PayPal reports are capped at twelve months per request and monthly statements arrive one month at a time. Rebuilding a multi year picture means handling a stack of PDFs, and the bulk statement converter page covers how the merge behaves and what to check afterwards.