PayPal will hand you a CSV, a tab file, a legacy QuickBooks IIF, or a Quicken QIF. It has never handed anyone a .QBO Web Connect file. Upload the PayPal statement or activity report here and get a real QBO that QuickBooks Online and QuickBooks Desktop both import. Start free, no credit card.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Upload the PayPal PDF statement or activity report to BankXLSX and choose QBO as the download format. PayPal itself offers no QBO download: its activity report comes as CSV, tab-separated, a QuickBooks IIF file for US accounts, or a Quicken QIF. None of those is a Web Connect file, and QuickBooks Online cannot read IIF at all. The converted QBO imports into the PayPal account in QuickBooks the same way a bank download does, for any period PayPal ever recorded.
PayPal keeps seven years of history and hands you every format except the one QuickBooks actually wants for a bank feed import.
The Activity Download report comes in CSV, tab-separated, QuickBooks IIF (US accounts only), and Quicken QIF. Web Connect is not on the menu, and it never has been. If your accountant asked for a QBO, PayPal has no way to give you one.
IIF is a legacy Desktop-only format. QuickBooks Online cannot import it. Even in Desktop it posts entries directly rather than dropping them into the For Review queue, so bank rules, matching, and the duplicate check never run on them.
Connect to PayPal 2.0 lets you pick a start date up to about 90 days in the past. The older PayPal Connector app reaches further, up to around two years, but reconnecting an existing account cannot go back earlier than six months. Which app you happen to be on decides how much of your year appears.
PayPal generates activity reports for any period inside the last seven years, twelve months at a time. So the record exists in full. It just arrives in a format QuickBooks will not accept as a feed import.
PayPal takes its fee before the money lands, so a 100 dollar sale deposits as something less. Book only the net and your revenue is understated and the expense is invisible. The gross, the fee, and the net all have to survive the trip.
The PayPal connectors are QuickBooks Online products. Desktop shops are left with the IIF file or a manual entry, which is exactly why a converted Web Connect file matters here.
Upload the PayPal statement or report and get a valid Web Connect file, for any period, with the fee kept as its own line.
You get an actual .qbo with the structure QuickBooks expects, the only format QuickBooks Desktop Web Connect accepts and the cleanest one for an Online upload.
A statement carries no sync window with it. Convert January when it is July, or rebuild two years for a cleanup, without fighting the connector app you happen to have.
The PayPal fee stays its own line rather than being netted into the sale, so revenue books at gross and the processing fee books as the expense it is.
Refunds, chargebacks, and dispute holds come across with the right sign, so the PayPal balance in QuickBooks tracks the balance PayPal shows.
Transfers out to your bank stay intact as their own transactions, which is what lets you match the PayPal withdrawal to the deposit on the bank side.
256-bit encryption in transit, and you can delete your uploaded files whenever you want.
No software to install and no credit card to start.
Sign in at paypal.com, open Activity, then Statements and Reports, and save the monthly statement PDF or run an activity report for the period you need. A statement a client forwarded works just as well. Drag it into the box above.
Tip: Reports run twelve months at a time, up to seven years back.
Once the transactions are read, pick QBO as the download format. QFX, OFX, CSV, and Excel sit next to it.
Tip: Pick QFX if the target is Quicken.
QuickBooks Online: Transactions, Bank transactions, Upload from file. Desktop: File, Utilities, Import, Web Connect Files. Select the PayPal account, which most books set up as a bank account rather than a credit card.
Tip: One account per file.
PayPal sits in the middle of a lot of small US businesses: it is the checkout, the invoice payer, and the place client money lands before it reaches the bank. That makes it a bookkeeping problem, because the money that arrives in the bank is already net of fees and refunds, and the story of what actually happened lives only in PayPal.
The client sends the PayPal statement, not the password. Convert whatever period you were handed and post it correctly without waiting on access you may never get.
Sales, invoices, refunds, and the fee on each. The bank sees one lump withdrawal, so the detail has to come from PayPal itself.
The sync will not backfill the year you are rebuilding. Converted statements will, month by month, as far back as PayPal keeps them.
There is no PayPal app for Desktop. Web Connect is the supported route in, and a converted statement is a proper Web Connect file.
Yes, and there are four routes in, which is exactly why the answer feels confusing. QuickBooks Online has two different PayPal apps with two different history limits. PayPal itself offers a legacy IIF download that only Desktop reads. And a converted statement produces a Web Connect .QBO that either version imports. The route you pick decides how much history you get and whether the fee survives as its own line, so it is worth knowing what each one actually reaches before you start a cleanup.
| Path | File or method | History reach | Works with QuickBooks Desktop? |
|---|---|---|---|
| Connect to PayPal 2.0 | Live app sync | Start date up to about 90 days back | No |
| PayPal Connector by QuickBooks | Live app sync | Up to about two years at first setup, six months on a reconnect | No |
| PayPal activity download | CSV, TAB, IIF (US only), QIF | Seven years, twelve months per report | IIF only, and it bypasses the review queue |
| Converted PayPal statement | A real .QBO Web Connect file | Any period PayPal recorded | Yes |
The pattern is the same one that shows up at every bank: the live connection owns the current month, and everything behind it has to arrive as a file. PayPal just makes it sharper, because its own file formats stop at a Desktop-only relic from the 1990s.
No. PayPal offers its Activity Download report in CSV, tab-separated, QuickBooks IIF for US accounts, and Quicken QIF. There is no Web Connect option anywhere in the export menu. That is the single fact behind most of the frustration on this topic, because QuickBooks Desktop imports bank activity through Web Connect files, and QuickBooks Online treats a QBO upload as the cleanest file it takes. PayPal produces neither, so conversion is not a shortcut here. It is the only way to produce the file.
Because IIF was never a banking format. It is Intuit Interchange Format, a Desktop-only text format built for moving lists and journal entries, and QuickBooks Online cannot open it at all. When Desktop does take one, the entries post straight into the register instead of arriving in the For Review queue, which means your bank rules never fire, nothing gets matched against existing transactions, and the duplicate protection a Web Connect import gives you is simply absent. It is the difference between filing transactions and importing a bank feed.
Book the sale at gross and the fee as an expense. PayPal deducts its cut before the money reaches your balance, so a 100 dollar sale might land as 96.51. If you record only what landed, your revenue is understated by the fee and your processing cost never appears on the profit and loss, which quietly distorts margin all year. 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.
This is where most PayPal books go wrong. When you move money from PayPal to your checking account, one transaction appears on each side, and they are the same money. Treat the PayPal account as a real bank account in QuickBooks, import the PayPal activity into it, and then match the withdrawal against the deposit that shows up on the bank feed, exactly as you would a transfer between two bank accounts. If instead you post the bank deposit as income, you have now booked the same revenue twice, once through PayPal and once through the bank, and the cleanup at year end is painful. The same logic applies to a Stripe payout or a Square deposit.
Duplicates happen when a live sync and a converted file overlap. Open the PayPal account register, find the oldest transaction the app brought in, and end your converted file the day before it. Load history behind the sync, never on top of it. If you are rebuilding a busy year of sales, check how many transactions QuickBooks accepts at once first, because a QuickBooks Online upload caps at 1,000 lines and a year of PayPal sales clears that easily.
The same upload produces more than a QuickBooks file. Take XLSX or CSV instead with the PayPal statement to Excel converter when you want to sort and total a year for a tax return, and the background on the raw exports is in exporting a PayPal statement to CSV or Excel. The step-by-step version of this page is how to import PayPal transactions into QuickBooks. For checking and savings, the bank statement to QBO converter covers the same ground, and if the 90-day wall is what sent you here, why QuickBooks only imports 90 days of transactions explains what each connection type reaches.
If you already pulled the PayPal CSV and simply need it in Web Connect form, a dedicated CSV to QBO converter does that one job. When statements from several institutions are all heading into the same QuickBooks file, a purpose-built bank statement to QuickBooks converter runs the PDF to QBO workflow across all of them.
Yes, through four different routes. QuickBooks Online offers Connect to PayPal 2.0 and the older PayPal Connector app, PayPal itself offers a Desktop-only IIF download, and a converted statement gives you a Web Connect .QBO that both QuickBooks Online and QuickBooks Desktop import. The routes differ mainly in how far back they reach.
No. PayPal's Activity Download report comes as CSV, tab-separated, QuickBooks IIF for US accounts, or Quicken QIF. Web Connect is not offered anywhere in PayPal's export menu, so the only way to get a .QBO out of a PayPal statement is to convert it.
It depends which app you have. Connect to PayPal 2.0 lets you choose a start date roughly 90 days back. The PayPal Connector by QuickBooks reaches about two years at first setup, but a reconnection cannot go earlier than six months. Anything older has to come in as a converted file.
Not with the PayPal apps, which are QuickBooks Online products. Desktop takes a Web Connect .qbo file under File, Utilities, Import, Web Connect Files. Convert the PayPal statement to QBO and import it into the PayPal account you set up as a bank account.
Book the sale at its gross amount and the PayPal fee as a separate expense, not the net that landed in your balance. Recording only the net understates revenue and hides the processing cost. A converted statement keeps the payment and the fee on separate lines so both post correctly.
A bank account. PayPal holds a balance, receives deposits, and sends withdrawals, so it behaves like a checking account in your books. Setting it up that way is also what lets you match the PayPal withdrawal against the deposit on your real bank feed as a transfer.
Usually because fees were netted instead of booked, or because a withdrawal to the bank was recorded as income on the bank side and never matched as a transfer. Both errors are what a full statement import prevents, since every fee, refund, and withdrawal arrives as its own line.
The same statement as XLSX or CSV instead.
The other processor QuickBooks only half connects to.
The processor whose only Desktop file is a legacy IIF.
The store platform whose sync stops at one year.
Convert any bank statement to a QBO file.
Every QuickBooks import path, and the limits on each.
Z tej samej rodziny narzędzi
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
