PayPal transactions duplicated in QuickBooks Online
Duplicate PayPal transactions in QuickBooks Online almost always mean the same money arrived through two feeds: once from the PayPal connection as the sale, and once from your bank feed as the payout that moved the money to your bank. QuickBooks does not know the two lines describe one event, so each feed adds its own copy and your income is overstated.
Why it happens
When PayPal is connected to QuickBooks Online, every sale lands in the PayPal account register. When you later withdraw your balance, your bank feed downloads that payout as a fresh deposit. If you click Add on the bank line, QuickBooks records new income on top of the sales it already imported. Nothing is technically broken: both feeds are reporting honestly, but nobody told QuickBooks they overlap.
The fix: match the payout, never add it
- Treat the PayPal account in QuickBooks as the owner of the sales. Sales income should be recorded once, there.
- When the payout appears in your bank feed, click Match, not Add. Match links the bank line to the transfer QuickBooks already knows about instead of creating new income.
- If QuickBooks does not offer a match, record the payout as a transfer from the PayPal account to your bank account, then match the bank line to that transfer.
- To clean up existing duplicates, open the bank register, find the added copies of PayPal payouts, and delete or exclude them. Then re-match the bank lines properly. Run a profit and loss report before and after so you can see the overstated income come back down.
Where the manual fix breaks down
Match works when one payout maps to one transfer. It gets harder when PayPal batches several sales into one payout, when refunds land in the middle of a batch, or when a payout crosses a month end. Those cases need the payout broken apart by hand, and they are the reason many businesses quietly stop reconciling their PayPal account at all.