Shopify and PayPal bookkeeping without double counting
Shopify can record the order while PayPal records the payment, fee, refund and transfer. Importing both sources without a clear design can duplicate sales or leave processor balances unexplained.
Assign one source of truth to each accounting fact. Shopify is usually the source for the order. PayPal is the source for how that payment moved through the processor.
What each platform knows
Shopify
- Orders and line items
- Discounts and shipping
- Taxes recorded on the order
- Refund activity initiated in the store
- The payment method used
PayPal
- Payment settlement
- Processor fees
- Holds and releases
- Disputes and reversals
- Transfers to and from the bank
Where double counting begins
A common mistake is to import a Shopify order as revenue and then import the full PayPal receipt as another sale. When PayPal later transfers money to the bank, that transfer may be categorized as revenue a third time.
The cleaner pattern is to record the order once, direct the PayPal payment into a PayPal clearing or balance account, record the fee and other processor activity there, and treat the bank movement as a transfer.
A practical flow
- Record the Shopify order once. Preserve the intended breakdown for sales, discounts, shipping and taxes.
- Post the payment to PayPal clearing. The customer payment increases the processor balance rather than the bank.
- Post the PayPal fee. The fee reduces the processor balance and is mapped to the intended expense account.
- Handle refunds and disputes. Connect them to the original activity without creating a second sale.
- Record bank transfers. Moving cash from PayPal to the bank is a balance-sheet transfer.
- Reconcile the PayPal ending balance. Holds, unsettled activity and currency balances should explain what remains.
Questions to answer before automating
- Are all PayPal receipts tied to Shopify orders, or are there other sales sources?
- Does PayPal hold more than one currency?
- Are refunds initiated in Shopify, PayPal, or both?
- Are PayPal fees recorded from the processor or estimated elsewhere?
- Does your accounting platform receive both order-level and processor-level data?
PayPal's Disbursement Reconciliation Report is designed to connect payouts received in the bank with the payments, refunds and other transactions contributing to each payout. The useful automation pattern is to preserve those relationships while sending only genuine exceptions for review.
Concerned your Shopify and PayPal sales are duplicated?
Describe your current integrations and what does not match. We will review the likely flow without asking for credentials.
Request a free payout assessment →Official reference
This guide is general educational information, not accounting or tax advice.