How to Import PayPal Transactions into QuickBooks

Short answer: There are four ways into QuickBooks, and they differ mainly in how far back they reach. Connect to PayPal 2.0 syncs from a start date about 90 days back. The older PayPal Connector app reaches roughly two years at first setup, but only six months on a reconnect. PayPal's own download gives you CSV, tab, a Desktop-only IIF, or a Quicken QIF, and never a .QBO. Converting the statement to a Web Connect .QBO file is the one route with no date window and the only one QuickBooks Desktop properly supports.

Almost every question about PayPal and QuickBooks is really a question about history. The sync works fine for the current month. It falls apart the moment you are cleaning up last year, closing books for a client who never connected anything, or moving a business onto QuickBooks Desktop. This walks through each path, what it covers, and the two bookkeeping errors that cause most PayPal messes.

Can you import PayPal transactions into QuickBooks?

Yes. QuickBooks Online has two PayPal apps, PayPal itself offers file downloads, and any PayPal statement can be converted into a Web Connect file that both QuickBooks Online and QuickBooks Desktop import. What you cannot do is get a .QBO file out of PayPal directly. That format simply is not in PayPal's export menu, which is the root of most of the confusion on this topic.

What each PayPal path to QuickBooks actually reaches

Method 1: connect PayPal to QuickBooks Online

If your account is open and you only need the current period, use the app. In QuickBooks Online, go to Apps, search for PayPal, and connect. During setup you are asked for a start date for historical transactions, and this is the moment that decides everything. On Connect to PayPal 2.0 the earliest date you can pick is roughly 90 days back. Miss that dialog and you get the default, which is less.

Reconnecting an account that was already linked is worse: the reconnect flow will not let you choose a date earlier than six months. So if a feed broke in January and you noticed in July, the gap does not fill itself in. It has to be uploaded.

Method 2: the PayPal download, and why IIF disappoints

In PayPal, open Activity, then Statements and Reports, and run an Activity Download report. You can generate reports for any period inside the last seven years, twelve months at a time, in CSV, tab-separated, QuickBooks IIF for US accounts, or Quicken QIF. Reports over 50,000 records get split across several files in a ZIP.

The IIF option looks like the answer and is not. IIF is Intuit Interchange Format, a Desktop-only text format designed for moving lists and journal entries around, and QuickBooks Online cannot open it at all. Even in Desktop, an IIF posts entries straight into the register instead of landing in the For Review queue, so your bank rules never fire, nothing is matched against existing transactions, and the duplicate protection a Web Connect import gives you is simply not there. It files transactions. It does not import a bank feed.

Method 3: convert the statement to a QBO file

This is the route with no date window and no app dependency. Download the PayPal statement PDF or the activity report for the period you need, convert it to a .QBO Web Connect file, and import that. It works for any month PayPal ever recorded, for an account you no longer have a login for, and for QuickBooks Desktop, which has no PayPal app at all.

In QuickBooks Online: Transactions, Bank transactions, Upload from file. In Desktop: File, Utilities, Import, Web Connect Files. Point either one at the PayPal account in your chart of accounts. Set that account up as a bank account, not a credit card, which matters for the next section.

How do I record PayPal fees in QuickBooks?

Book the sale at gross and the fee as a separate expense. PayPal takes its cut before the money reaches your balance, so a 100 dollar sale may show as 96.51. Recording only the 96.51 understates your revenue by the fee and leaves the processing cost off your profit and loss entirely, which quietly distorts your margin for the whole year and makes your 1099-K reconciliation harder than it needs to be, because the 1099-K reports gross.

A converted statement keeps the payment and the fee as separate lines, so the gross posts to income, the fee posts to merchant fees, and the net matches the balance PayPal shows. If you are working from a spreadsheet instead, keep the gross and fee columns apart rather than importing only the net.

Matching the PayPal withdrawal to the bank deposit

Here is the error that creates most PayPal cleanups. When you move money from PayPal to your checking account, that single movement appears twice: as a withdrawal in PayPal and as a deposit in the bank. If PayPal is set up as a bank account in QuickBooks and its activity is imported, you match those two as a transfer and everything ties.

If instead you post the bank deposit to income, you have booked the same revenue twice, once when the customer paid through PayPal and once when the money arrived at the bank. Sales look inflated, the PayPal balance never reconciles, and untangling it at year end takes hours. Treat PayPal as an account, not as a customer.

Avoiding duplicates when a sync is already running

Load history behind the sync, never on top of it. Open the PayPal register, find the oldest transaction the app brought in, and end your converted file the day before that date. QuickBooks does try to catch duplicates on a Web Connect import, but it matches on amount, date, and reference, so a reworded description or a posting date that shifted by a day will slip through. A busy year of PayPal sales will also run into the QuickBooks Online cap of 1,000 transactions per uploaded file, so split the year by month or quarter before you start.

PayPal to QuickBooks: a working order of operations

1. Set PayPal up as a bank account in your chart of accounts.
2. Connect the app if the account is open, and note the oldest date it pulled in.
3. Pull statements or activity reports for every earlier period you need, one month or one quarter at a time.
4. Convert each to QBO and upload it, stopping the day before the sync's oldest transaction.
5. Categorize sales at gross, fees to merchant fees, refunds against income.
6. Match every PayPal withdrawal to its bank deposit as a transfer.
7. Reconcile the PayPal account against the closing balance on each monthly statement.

That last step is the one people skip, and it is the only one that proves the rest was right. The closing balance on the PayPal statement is the number your QuickBooks PayPal account should show on that date. If it does not, something was netted, double counted, or missed.

What about Stripe, Square, and the bank itself?

The same shape repeats across every payment platform: a live sync with a short memory, exports in a format the accounting software does not really want, and fees netted out of the deposit. Square exports CSV only and its sync reaches about 18 months. Banks are stricter still, since QuickBooks itself will not download transactions older than 90 days through any bank connection, which is Intuit's rule rather than your bank's. When several institutions all have to land in one QuickBooks file, a purpose-built statement to QuickBooks converter runs the same workflow across all of them at once.

If you would rather have the year in a spreadsheet than in QuickBooks, the PayPal statement to Excel converter produces XLSX or CSV from the same upload, and exporting a PayPal statement to CSV or Excel covers what the raw PayPal exports do and do not include.

Last updated July 2026.