Figuring out how to import PayPal into QuickBooks Online matters for any seller whose money arrives through PayPal and whose books live in QuickBooks. PayPal reports show gross sales, fees, refunds, and payouts as separate lines, while your bank feed only shows the net payout that lands in your bank account. If you record only that net deposit, your revenue is understated, your fees disappear from the profit and loss report, and refunds vanish entirely. The file-based workflow in this guide fixes that: download the PayPal activity report, convert it to a QBO file, import it into QuickBooks, and reconcile through a clearing account.
Be clear about what this workflow is and is not. It is not a live sync between PayPal and QuickBooks. Nothing posts automatically, and no tool in this guide connects to your PayPal or QuickBooks account. You export a file, review it, and import it yourself, which means you control every row that enters your books. That control is the point: PayPal data is messy enough that a blind sync can create duplicates and misclassified fees, while a reviewed file import keeps the books honest.
How to Import PayPal into QuickBooks Online: the File Route
The file route has four steps: download, convert, import, and match. Start by downloading your PayPal activity as a CSV for a single, non-overlapping period, such as one calendar month. Choose the activity report that includes transaction details, not a summary: you need gross amounts, fees, refunds, and the payout transfer lines. Save the file with a clear name, for example paypal-activity-october-2026.csv, and keep a log of the date range you downloaded so the next download starts where this one ended.
Next, convert the CSV to a QBO file with a converter that understands PayPal activity. Our free PayPal to QuickBooks converter takes a PayPal activity export and produces a QBO file you can import into QuickBooks Online yourself. Before importing, open the converted file or its preview and check the row count against the PayPal report, confirm that fees appear as separate expense lines, and confirm that refunds appear as negative sales rather than disappearing. If the counts do not match, fix the export range or the conversion settings before you import anything.
Download the Right PayPal Activity Report
The most common mistake in this workflow is downloading the wrong report. PayPal offers several views, and a summary view hides the detail QuickBooks needs. Use the activity download that lists individual transactions with their type, gross amount, fee, and net amount. Include the full month, including the first and last days, and avoid downloading a range that overlaps a previous import. Overlapping ranges are the main source of duplicate PayPal transactions in QuickBooks.
Check the payout lines in the report carefully. A payout is a transfer from PayPal to your bank, not new revenue, and it should appear as a transfer out of the PayPal clearing account, not as income. If your report shows payouts without the underlying sales, you downloaded too narrow a range: widen it to include the sales that funded the payout. If it shows sales without payouts, that is normal at month-end, because some sales will pay out next month. The clearing account, explained below, is what keeps those timing differences from looking like errors.
How to Import PayPal into QuickBooks Online Without Duplicates
Duplicates happen when the same PayPal activity enters QuickBooks twice: once through a bank feed, once through a file import, or twice through overlapping file imports. Prevent them with three rules. First, use one import path per account: if you import PayPal activity by file, do not also let a bank feed or connector import the same transactions. Second, never overlap date ranges between downloads; keep the log mentioned above and check it every time. Third, match before adding: when QuickBooks suggests a match for an imported transaction, accept the match instead of adding a second copy.
If duplicates already exist, find them before deleting anything. Sort the PayPal account register by date and amount, and look for same-date, same-amount pairs. Check whether one copy is reconciled or matched to an invoice, and keep that copy. Exclude or delete the other copy, and check the reconciliation status afterward: deleting a reconciled transaction changes the reconciled balance and may require re-reconciling the period. When in doubt, run a duplicate check first with the free QBO cleanup checker before you change anything, and read our comparison of sync routes in Does Stripe Integrate with QuickBooks Online? for the same duplicate logic applied to Stripe.
Choose the Clearing-Account Method for Payouts
The clearing account is the method that makes PayPal accounting reconcile to the penny. Create a bank-type account in QuickBooks called PayPal Clearing, or use your existing PayPal account in QuickBooks as the clearing account. Import the converted QBO file into that account, not into your main bank account. Gross sales land as income, fees land as expenses, and refunds reduce income, all inside the clearing account. The payout transfer then moves the net amount from the clearing account to your real bank account.
After a payout is matched, the clearing account should return to the balance of PayPal funds not yet paid out, which is usually a small amount at month-end. If the clearing account balance grows month after month, something is off: either payouts are not being matched, or sales are being recorded twice. A clearing balance that never returns near zero is the clearest early warning that the workflow has a leak, and it is far easier to spot than the same error spread across income and expense accounts.
Match the Payout Deposit and Reconcile
When the payout lands in your bank account, QuickBooks will show a deposit from the bank feed or from your manual entry. Match that deposit to the transfer out of the clearing account, not to a sales receipt. The amounts should agree exactly: the bank deposit equals the PayPal payout, which equals gross sales minus fees minus refunds for that payout batch, plus or minus any holds or reserves PayPal applied. If the amounts differ by the fee total, the fees were probably recorded twice or not at all; if they differ by a refund amount, a refund row is missing from the import.
Reconcile the clearing account monthly, just like a bank account. The statement for this purpose is your PayPal activity report for the month: beginning PayPal balance, plus sales, minus fees, refunds, and payouts, should equal the ending PayPal balance. When that arithmetic ties out and the bank deposit matches the payout, the month is closed. For more on the matching process in general, see our guide on how to reconcile a bank statement. If you convert PayPal exports in volume, check pricing for plans that cover more pages.
Frequently asked questions
How do I import PayPal into QuickBooks Online without a live sync?
Download the PayPal activity CSV, convert it to a QBO file with a file-based converter, and import the QBO file into QuickBooks Online yourself. You review the rows before import, and nothing connects to your PayPal or QuickBooks account.
Is the PayPal to QuickBooks converter a live integration?
No. It is a file-based converter: you upload a PayPal CSV export and download a QBO file to import yourself. There is no direct or native connection to PayPal or QuickBooks, and nothing posts without your review.
Why should I not record only the net payout?
Because the net payout hides gross sales, fees, and refunds. Recording only the net figure understates revenue, omits fee expenses, and makes refunds invisible, which distorts both tax reporting and profit margins.
What date range should each download cover?
One full month with no overlap against previous downloads. Keep a log of downloaded ranges and check it before every new download to prevent duplicates.
Start with one month, check the clearing account balance, and the routine will settle quickly. Begin from the ConvertStatement home page and try the converter free.