PayPal payments not matching in QuickBooks Online
The usual cause is arithmetic: PayPal pays you the net amount after fees, while your invoice or sales receipt shows the gross amount, so QuickBooks finds no transaction with the same value and never offers a match. The fix is to match the payment to the invoice and resolve the difference as a fee, rather than lowering your price to what arrived.
Why Match never appears
QuickBooks suggests matches by amount and date. A 100 invoice and a 96.80 feed line do not look like the same event to it. The gap widens when one payout bundles several sales, when a refund nets against the batch, when currency conversion moves the value, or when the payment sits outside the date window QuickBooks searches. In each case the money is right there; the numbers just do not line up.
How to match a payment that will not match
- Open the bank line and click Find match to search manually. Widen the date range first; matches outside the default window are common.
- Select the invoice or sales receipt the payment belongs to. The totals will not agree yet.
- Use Resolve difference and add a line for the PayPal fee to your processing fees expense account, so gross income minus fee equals the net line.
- For bundled payouts, tick every sale inside the batch, then resolve the remaining difference as the combined fees.
- If the transaction was already added as a duplicate, exclude the copy first; QuickBooks will not offer a match to money it thinks is already recorded. The duplicates guide covers the cleanup.
Where the manual fix breaks down
Resolving one payment takes a minute. Resolving a month of bundled payouts, each with its own fees and the odd refund, is an afternoon, and it resets every month. It is the single most reported PayPal complaint in QuickBooks forums, and it is the reason LedgerBridge exists.