What we do
Tools
Industries
Department
How we workLet's talk →
Home/Reconcile PayPal in QuickBooks to the Statement
PayPal + QuickBooks reconciliation

Reconcile PayPal in QuickBooks the Way You Reconcile a Bank: Against PayPal's Own Statement

The PayPal account in QuickBooks says one balance and PayPal says another. Treat PayPal as the bank it behaves like: once a month, reconcile the PayPal account in QuickBooks to the ending balance on PayPal's monthly statement. When the difference won't reach zero, the cause is usually something that changed PayPal's balance without an entry in QuickBooks, such as a reversed payment, a fee that never posted, or a balance from before the app's start date.

What a PayPal month is made of

PayPal's statement starts where last month ended and lists everything that moved the balance. QuickBooks has to hold the same lines.

Example · one month in a PayPal business account
Opening balance on last month's statement $1,240.00
Payments received (Sales and invoice payments, gross) $6,850.00
PayPal fees (Your fee account) − $231.40
Refunds to customers − $310.00
Payment reversed in a dispute (Often the line with no QuickBooks entry) − $145.00
Withdrawals to checking (Transfers, not expenses) − $6,000.00
Ending balance on this month's statement $1,403.60

If QuickBooks shows $1,548.60 for the PayPal account, it's $145.00 high, the exact size of the reversal. A difference that matches one line on the statement is the quickest kind to find. One that matches nothing usually means several small fees, or an opening balance that was never entered.

Reconciling the PayPal account at month end

  1. 1

    Empty the PayPal review queue first

    Integration transactions PayPal Payments For Review

    Add or exclude everything dated in the month. Intuit's help says a sale's fee only posts once the sale is added or matched, so anything left waiting here is missing from both income and fees.

  2. 2

    Get PayPal's monthly statement

    Download it from your PayPal business account and note the ending balance and the last day it covers. Reconcile to that, not to the balance on PayPal's home screen, which keeps moving.

  3. 3

    Open Reconcile and pick the PayPal account

    Settings ⚙ Reconcile

    Choose the PayPal bank account the app created, enter the statement's ending balance and date, and start.

  4. 4

    Tick each line against the statement

    Payments, fees, refunds and withdrawals each appear on PayPal's statement. A withdrawal shows in QuickBooks as a transfer out of the PayPal account. Tick it there, and match its other half in the checking account's bank feed.

  5. 5

    Track down the difference instead of accepting it

    If you finish with a difference, QuickBooks offers to post an adjustment. Leave that alone and look for statement lines with nothing ticked against them: reversals, dispute fees, purchases paid from the PayPal balance, currency conversions. Enter what's missing, then finish.

    Watch for: the first month after connecting. The app only reached back to its start date, so the balance before that has to be entered once, or every month carries the same gap.

Why the PayPal account still won't tie out

Each one changes PayPal's balance without a matching entry in QuickBooks.

The opening balance was never entered

How you'll know: Every month is off by the same amount: what sat in PayPal on the app's start date.

Fix: Enter that balance once, dated the day before the start date, against the account your accountant prefers. Opening balance equity explains the usual default.

A dispute or chargeback pulled money back

How you'll know: The statement shows a reversal, and sometimes a fee, that QuickBooks has no entry for.

Fix: Record the reversal against the sale's income or your refunds account and the fee in your fee account. If the case is later decided in your favor and PayPal returns the money, record that too.

Bills paid from the PayPal balance

How you'll know: A software subscription or supplier was paid straight out of PayPal, and only the sales side was imported.

Fix: Enter those as expenses from the PayPal account. Purchases funded from a linked bank or card are a different case: Intuit records those as transfers, which need matching, not a second expense.

Money held in another currency

How you'll know: PayPal keeps a euro or pound balance beside the dollar one, and the converted amounts don't line up.

Fix: Intuit says the Connect to PayPal app doesn't support multi-currency, so those conversions are booked by hand. Our PayPal QuickBooks integration page covers that gap.

The withdrawal was added as income

How you'll know: The checking account reconciles, but income is high by the amount moved out of PayPal.

Fix: Undo the deposit in Banking and match it to the transfer the app recorded. Connecting PayPal to QuickBooks shows the setting that prevents it.

What this looks like in practice

Shopify retailer

Shopify to QuickBooks sync

A retailer's Shopify sales synced into QuickBooks as one number a day, and every month someone spent half a day working out why a payout didn't match. We rebuilt the sync to itemize by product category, use real product costs, and match each payout to the orders, fees and refunds behind it. The half-day reconciliation became a five-minute check.
Let's talk

PayPal months that close without a mystery adjustment

n-frames builds the posting for the PayPal events a sales import misses: reversals, dispute fees, returned funds and spending from the PayPal balance, read from PayPal's transaction records and booked to the accounts your accountant already uses. There's no charge for the quote.

PayPal reversals in the books →

Reconciling PayPal: what the app covers and what it leaves

PayPal already syncs with QuickBooks, so why does the PayPal account still need reconciling?

Intuit's Connect to PayPal app brings in sales, fees, refunds and transfers to your bank. A sync isn't proof the books agree, though. Reconciling against PayPal's statement is what shows a reversal, a stray fee or an untouched review queue. Treat it like any bank account and reconcile it monthly.

Does reconciling PayPal work the same in Xero instead of QuickBooks?

Largely. Xero connects PayPal as its own bank account, and you reconcile it to PayPal's statement just as you would in QuickBooks, with withdrawals treated as transfers. n-frames builds the reversal and dispute posting for Xero as well.

What about PayPal disputes and chargebacks in QuickBooks?

Book each one when PayPal takes the money, not when the case closes: the reversal against income or refunds, and any dispute fee in your fee account. That's the work n-frames automates, reading each dispute and reversal from PayPal's records and posting the matching entries to QuickBooks.

Is the quote for PayPal reconciliation work really free, with no obligation?

Yes. We look at how money moves through your PayPal account and which lines keep breaking the reconciliation, then send a price. Nothing is built unless you choose to go ahead.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.