WooCommerce, Shopify and BigCommerce to Xero accounting workflows. Book a demo
PayPal reconciliation

Give WooCommerce PayPal activity its own reconciliation trail in Xero

PayPal should remain identifiable from the moment an order is paid through to the movement of funds and refunds. A dedicated treatment makes it easier to explain why the PayPal balance, bank transfer and WooCommerce sales totals are not identical on the same day.

Keep the trail separate

PayPal is a payment channel, not the sales account

WooCommerce supplies the order and the PayPal payment method. ClearCommerce can map that method to a dedicated Xero clearing account while sales and VAT continue to post to their proper accounts.

  • Identify PayPal-paid orders in the source data
  • Keep refunds linked to the original ecommerce reference
  • Separate PayPal clearing from card-gateway clearing
  • Retain Xero export history for duplicate-safe retries
ClearCommerce payment clearing mapping screen

Why the PayPal balance can be useful

Money may remain in the PayPal account before it is transferred to the bank. If the accounting workflow jumps directly from WooCommerce revenue to the bank feed, that timing difference is difficult to explain. A separate clearing balance provides the bridge.

Refunds should move through the same story

A PayPal refund can reduce the payment-channel balance after the original sales day. Recording the refund as its own dated accounting event keeps the later reconciliation understandable.

Do not copy Stripe assumptions automatically

Both methods may use clearing accounts, but the business can choose different account codes and operational checks for PayPal. Payment handling is configured per method rather than embedded in WooCommerce logic.

How the trail holds together

From checkout to PayPal balance in four linked records

1. Order captured

WooCommerce records the order with PayPal as the payment method and stores the transaction reference.

2. Source data imported

ClearCommerce keeps the PayPal reference attached to the order rather than folding it into a generic "card" bucket.

3. Mapped to a PayPal clearing account

The export profile routes PayPal orders to their own Xero account, separate from Stripe or bank transfers.

4. Matched against the payout

When PayPal transfers funds to the bank, the clearing account balance explains the gap between gross sales and net cash.

Questions people ask

FAQs

Why keep PayPal separate from other WooCommerce payment methods?

PayPal settles on its own schedule and deducts its own fees, so a shared clearing account with Stripe or card payments makes the balance harder to explain during reconciliation.

Does ClearCommerce handle PayPal refunds?

Yes. Refund source data is imported alongside the original order so a refund can be traced back to the PayPal transaction it relates to.

What if a WooCommerce order used PayPal but was later cancelled?

Cancelled or unpaid PayPal orders can be excluded from the export profile so only captured, paid activity reaches the Xero clearing account.

Want PayPal separated cleanly from your other gateways?

We can review a sample day and show the mapping before you authorise a Xero export.

Book a demo