QuickBooks PayPal Integration for Shopify and WooCommerce Stores

LedgerPort journal cover: PayPal in QuickBooks, booked once. A receipt for the PayPal account showing sales, fees, transfers, refunds and disputes, with one source per sale

Connecting PayPal to QuickBooks is the easy part. Booking each sale once is the job.


Your WooCommerce store already sends orders to QuickBooks Online, including the ones customers paid for with PayPal. What's missing is PayPal's fees. So you do the sensible thing and connect PayPal to QuickBooks as well.

The PayPal feed fills up with every PayPal sale from the last few months. Each one sits in the For Review tab with an Add button, and you work down the list clicking it.

A month later your bookkeeper calls. PayPal revenue for the quarter is roughly double what PayPal says you sold. The PayPal account in QuickBooks shows thousands of dollars more than your actual PayPal balance. Every PayPal sale is in the books twice: once from the store sync, and once from the feed.

Neither tool failed. Each one did its job. The problem was the belief that set them up: PayPal needs its own integration, so connect PayPal to QuickBooks and the PayPal side is handled.

A QuickBooks PayPal integration is only safe once you've made one decision about where each PayPal sale comes from. Before that, you need to know where your PayPal money actually lands. For a lot of US Shopify stores, the answer has changed.


First, Find Out Where Your PayPal Money Lands

How PayPal and QuickBooks should fit together depends on where PayPal pays you.

Your store Where PayPal sales settle What that means in QuickBooks
US Shopify store on Shopify Payments Inside your Shopify Payments payouts, via PayPal Wallet Book them like your other Shopify Payments sales
WooCommerce store using PayPal Payments Your PayPal business account PayPal is its own account in QuickBooks
Shopify store outside the US using PayPal Express Checkout Your PayPal account Treat it like the WooCommerce case

The first row is the one that catches people. As of November 2026, Shopify's help center says PayPal Express Checkout "isn't available to merchants in France or the United States." US stores offer PayPal through Shopify Payments instead. A lot of older advice about PayPal on Shopify was written before that change, and it no longer applies to US stores.


US Shopify Stores: PayPal Is Part of Your Shopify Payments Payouts

If you're a US Shopify store on Shopify Payments, PayPal reaches your customers through PayPal Wallet. Shopify's PayPal Wallet page is specific about what that means:

  • There's no separate PayPal option. "PayPal can only be integrated through the Shopify Payments Wallet."
  • PayPal sales are paid out with everything else. "PayPal Wallet transactions are bundled with your Shopify Payments transactions and paid out to your preferred bank account."
  • You can still see them separately in Shopify. PayPal Wallet payouts appear in the Payouts section of your Shopify admin, where you can filter by payment method. Shopify says the fees are shown in the Payments section of your admin.
  • Venmo works the same way. "Venmo is automatically available as a payment method in your PayPal Wallet."

So in QuickBooks, a PayPal sale on your store is booked like a card sale. The order posts, and the Shopify Payments payout it belongs to clears it. Nothing PayPal-specific needs syncing. If you haven't set up payout clearing yet, our Shopify payout reconciliation guide walks through it.

Don't connect a PayPal feed for these sales. It wouldn't help anyway. Intuit's own PayPal connector says that "at this time, PayPal transactions originating from Shopify can't be imported."

One leftover case: if your store used PayPal Express Checkout before switching to PayPal Wallet, refunds and disputes on those older orders are still handled in PayPal. Shopify says you need to keep a balance in that PayPal account "for up to 180 days after activating the PayPal Wallet." Keep a PayPal account in QuickBooks for that leftover activity until it winds down, and nothing else.

In LedgerPort, Shopify payment gateways map to QuickBooks clearing accounts under Sync Config › Payments. Payout journals with fee handling are on the Scale and Enterprise plans. Because PayPal Wallet sales arrive inside your Shopify Payments deposits, they're reconciled with those deposits. You can see how Shopify orders sync to QuickBooks Online for the full picture.


WooCommerce Stores: Treat PayPal as Its Own Account

On WooCommerce, PayPal works differently. With the WooCommerce PayPal Payments extension, WooCommerce says "funds settle instantly into your PayPal business account." That PayPal balance is money you hold, so it needs its own account in QuickBooks.

If you connect Intuit's PayPal connection (more on that below), it creates this account for you. Intuit's help pages describe it as separate from your bank account and "automatically created for you upon setup." If you're not using the connection, create the account yourself. Our e-commerce chart of accounts template shows where it sits, next to a PayPal Fees expense account.

Three things move that PayPal balance:

  1. Sales come in. That's the gross amount the customer paid.
  2. Fees go out. PayPal takes its fee from the balance.
  3. Transfers go to the bank. Money moves from PayPal to your bank account.

Refunds and disputes also move the balance. We'll come to those.

Here's the catch: your store and PayPal know different halves of the story. A WooCommerce order knows the items, the tax and the customer. WooCommerce's PayPal Payments docs say each PayPal-paid order shows the PayPal Transaction ID in its order notes or PayPal transaction data. The docs don't mention fees being shown on the order. Fees are known on PayPal's side, where every transaction carries a gross amount, a fee and a net amount.

So the job is to combine the two halves without counting the sale twice. The rest of the WooCommerce setup (customers, products, tax) is in our WooCommerce QuickBooks sync guide.


The One Rule: Each PayPal Sale Gets One Source

Every PayPal sale should enter QuickBooks from exactly one place. You have two sound ways to set that up.

Setup Where the sale comes from What the PayPal feed is for
A Your store sync Matching the sale, then fees and transfers
B Intuit's PayPal connection Everything. The store sync skips PayPal

Setup A: the store sync posts the sale, and the PayPal feed matches it

Choose this if you want order detail (items, sales tax, customer) in QuickBooks for PayPal orders, like every other order.

1. Send PayPal orders to the PayPal account. In your sync tool, point the PayPal gateway at the PayPal account in QuickBooks. In LedgerPort, open the WooCommerce Payments tab. Each gateway your store uses has an Enabled switch, Refund enabled, a Clearing account and a Payment method. Set the PayPal gateway's clearing account to your PayPal account in QuickBooks. Then, on the Orders tab under Payment & Billing, you can set Payment ref number source to the gateway Transaction ID. Every QuickBooks sale then carries PayPal's ID, which makes matching much easier. The sync configuration doc lists every setting.

2. Match, don't add. In Intuit's PayPal feed, each PayPal sale should be matched to the sale your store sync already created. Intuit expects this. Its connector page says that when you receive transactions that are already in QuickBooks, "you'll match the transaction with one already in QuickBooks, which helps prevent duplication." Intuit's FAQ also says that for sales, "fee amounts are obtained from PayPal and will be added when you match or add a transaction." So matching brings in the fee without adding the sale again.

3. Turn off automatic recording. Intuit's connector page says "you can choose whether or not you want PayPal to record your transactions automatically." For Setup A, leave that off. Also check for bank rules on the PayPal account that might auto-add sales. Either one would quietly recreate the opening story.

4. Test on a few days of orders first. Matching depends on amounts and dates lining up. The usual reasons a sale won't match are a different date, a partial refund, or a currency conversion. Intuit's FAQ says Connect to PayPal "does not support multi-currency (Currency Conversion) transactions and reconciliation." Once a few days match cleanly, you can trust the routine.

Setup B: the PayPal feed posts the sale, and the store sync skips PayPal

Choose this if you get only a few PayPal orders and don't need order-level detail for them.

In LedgerPort, turn off Enabled for the PayPal gateway on the WooCommerce Payments tab, so PayPal orders aren't synced. Then let Intuit's PayPal connection record PayPal sales, fees and transfers.

The trade-off is that QuickBooks gets PayPal's view of the sale, not your store's order lines. Intuit's connector page says unmatched items "will appear as 'PayPal Sales' on the sales receipt line details." For a handful of orders that's fine. For a busy PayPal channel, you'll usually want Setup A.

Never both

The double-count in the opening story happened because both the store sync and the PayPal feed were adding PayPal sales. Pick A or B, and write down which one you chose so the next person doing the books knows.

A note on Intuit's PayPal connection. Intuit's current help pages describe it under two names, "Connect to PayPal" and "PayPal Connector by QuickBooks." The two pages differ on details such as how much history it imports, so follow the Intuit article that matches what you see in your own QuickBooks company. Intuit's pages tag both for QuickBooks Online Simple Start through Advanced. Only admins or accountants can connect it.


Recording PayPal Fees and Transfers Without a Connector

You don't have to use Intuit's connection. PayPal's activity download exports your transactions as a CSV with Gross, Fee, Net and Transaction ID columns.

With that file, a monthly routine covers the PayPal side:

  • Fees: one entry moving the month's total fees from the PayPal account to your PayPal Fees expense account.
  • Transfers: each withdrawal recorded as a transfer from the PayPal account to your bank account. It's a transfer, not income.

If you set LedgerPort's payment reference to the PayPal Transaction ID, each row in PayPal's file lines up with a sale already in QuickBooks. That makes the monthly check quick.

Whichever route you take, the sale itself still comes from one place only.


PayPal Refunds and Disputes

Refunds reduce the PayPal balance the same way sales increase it. In LedgerPort, the Refund enabled setting on each WooCommerce gateway syncs refunds made through that gateway, so a PayPal refund posts against the PayPal account. Our guide to refunds and returns accounting covers how they should read in the books.

Disputes come out of the PayPal balance before anyone books them, and they're easy to miss. Treat them as their own line in the month-end check. Our guide to chargebacks and disputes walks through the entries.


The Month-End Check: Your PayPal Account Equals Your PayPal Balance

Here's the test that tells you the setup is working. At month-end, reconcile the PayPal account in QuickBooks against PayPal's ending balance for the month.

PayPal's balance report covers "all payment activity, including sales, refunds, disputes, fees, and withdrawals," so it has everything you need to explain a gap. A difference almost always comes from one of three things:

  • A fee that wasn't recorded.
  • A transfer that wasn't recorded.
  • A sale that went in twice.

The third one is the opening story. If your QuickBooks PayPal balance is higher than PayPal's by roughly the month's PayPal sales, you've found it.

For US Shopify stores on Shopify Payments, there's no separate PayPal balance to tie out. The check happens on your Shopify Payments payouts instead.


FAQ

Does QuickBooks Online connect to PayPal?

Yes. Intuit offers a PayPal connection that brings PayPal transactions into QuickBooks Online for review, and its help pages list Simple Start, Essentials, Plus and Advanced. Use it for fees and transfers, and decide whether it or your store sync records the sales. Never let both record them.

Why don't my Shopify PayPal sales show up in Intuit's PayPal connection?

Intuit says that, at this time, PayPal transactions originating from Shopify can't be imported. In the US, Shopify pays out PayPal Wallet sales together with your Shopify Payments payouts, so they're reconciled there.

Do I need a PayPal clearing account in QuickBooks?

For WooCommerce and other stores that hold a PayPal balance, yes: one account in QuickBooks that mirrors that balance. For US Shopify stores on Shopify Payments, PayPal sales clear through the same account as your other Shopify Payments sales.


Book It Once

PayPal isn't hard to book. It's easy to book twice.

Find out where your PayPal money lands. If you're a US Shopify store, PayPal is already part of your Shopify Payments payouts. If you're on WooCommerce, give PayPal its own account and pick one source for each sale. Then let PayPal's side handle the parts your store can't see: fees and transfers. At month-end, the PayPal account in QuickBooks should equal your PayPal balance.

Try Setup A before you rely on it. On LedgerPort's Free plan, set the PayPal gateway's clearing account to your PayPal account in QuickBooks and push a few days of real PayPal orders. Then match them against the PayPal feed before you turn anything on automatically. The Free plan covers 1 storefront and up to 30 orders a month, and no credit card is required.

Start free with LedgerPort →

Deciding which gateways to offer in the first place? Here's Shopify Payments vs Stripe vs PayPal on fees and accounting.

Stop Manual Data Entry Forever

Connect your store to QuickBooks in 15 minutes and let LedgerPort handle the rest.

Start Free See pricing →

Let’s Connect:

Automate Your E-commerce Accounting Today

Connect your Shopify or WooCommerce store to QuickBooks in under 15 minutes — no coding required.

14-day money-back guarantee · Free plan available