Overview Amazon Shopify Walmart soon eBay soon Etsy soon For Accountants All Features vs A2X vs Link My Books Pricing
Ceendesis Accounting · Shopify

Your Shopify payout is a payment. Not a bookkeeping document. We turn it into one.

Per-payout posting for simplicity or per-order posting for full order-level accounting — Ceendesis is the only tool that offers both. Customer matching, SKU line items, payment gateway routing, and correct tax treatment included.

accounting.ceendesis.com/connections/shopify
Shopify · seven-potions.myshopify.com
Connected · Per-order mode · Last sync 1h 22m ago
Latest payout — SHO-0410View detail →
Sales
£8,920
Refunds
−£212
Fees
−£288
Net Payout
£8,420
Orders → Xero invoices (per-order mode)
OrderCustomerItemsPaymentAmountXero
#5842James P.3 SKUsShopify Pay£38.40INV-1024
#5843Sarah M.1 SKUPayPal£16.40INV-1025
#5844Alex R.3 SKUsStripe£52.20INV-1026
#5845David K.2 SKUsShopify Pay£28.80INV-1027
#5846Emma W.4 SKUsShopify Pay£64.80INV-1028
The Shopify problem

"Shopify paid me £10,850. My sales were £12,400. The difference is buried."

Shopify pools every order, refund, chargeback, and processing fee into a single payout. The payout that lands in your bank doesn't match what you sold — and translating it into correct Xero bookkeeping takes more time than anyone wants to admit.

Payouts blend everything together.

Sales from 300 orders, refunds from last week, chargebacks from two months ago, processing fees, balance adjustments — all pooled into one number that lands in your bank. The breakdown exists but extracting it correctly into Xero is the hard part.

One weekly invoice tells you nothing about your customers.

Most accounting tools post the entire payout as a single Xero invoice. You can't see customer-level revenue. You can't run B2B AR reports. You can't analyse profitability by customer segment. The data is lost the moment it's blended.

Payment gateways don't all land in the same bank.

Shopify Payments to your current account. PayPal to your PayPal balance. Stripe to your Stripe account. Posting one merged invoice means your Xero bank reconciliation can't possibly match reality.

Holding periods break your bank reconciliation.

Shopify holds funds for days before paying out. Posting orders the moment they happen means your Xero shows revenue that hasn't actually arrived in your bank yet. Bank reconciliation fails. You waste an hour figuring out why.

Two ways to post Shopify

Per-payout or per-order. You decide. Switch any time.

Most ecommerce accounting tools support per-payout posting only. Ceendesis supports both — and per-order posting is the unique capability you'll only find here.

Mode 1

Per-Payout

One Xero invoice per Shopify payout period. Simple, clean, fast.

SHO-0410 → INV-1024 (Xero)
Sales RevenueVAT 20%£8,920
Shipping IncomeZERO£412
RefundsVAT 20%−£212
Shopify FeesINPUT2−£288
Net£8,832
  • One invoice per weekly payout
  • Aggregate sales, refunds, fees, shipping
  • Bank reconciliation matches exactly
  • Best for high-volume DTC stores
Shopify-specific features

Built for every Shopify configuration.

Payment gateway routing — PayPal in Xero, Stripe in Xero, each in the right place.

Configure separate Xero bank accounts per payment method. Shopify Payments to your current account. PayPal to your PayPal account. Stripe to your Stripe account. Other gateways to a configurable catch-all. Your Xero bank reconciliation matches reality because the source of funds is recorded correctly.

  • Shopify Payments → main bank account
  • PayPal orders → PayPal Xero account
  • Stripe payments → Stripe Xero account
  • Other gateways → configurable catch-all
  • Per-order routing in per-order mode; per-gateway summary in per-payout mode
Payment Gateway Settings
💳 Shopify Payments
→ 090 · Main Bank Account
💰 PayPal
→ 091 · PayPal Account
Stripe
→ 092 · Stripe Account
🎁 Gift Card
→ 280 · Gift Card Liability
📦 Other
→ 099 · Other Payments

Holding account support — funds tracked through the clearing cycle.

Shopify holds funds for days before paying out. Enable holding account support and Ceendesis posts orders to a clearing account when they arrive. When Shopify actually pays out the net, a Xero bank transfer moves the funds to your main account. Your bank reconciliation matches reality.

  • Orders post to clearing account at order time
  • Bank transfer when Shopify pays out
  • Net difference (fees, refunds) reconciled at payout time
  • Standard Xero bank reconciliation works first try
Funds Flow — Last 7 Days
Apr 8 — 14 orders posted
280 · Shopify Clearing
+£642.40
Apr 10 — Shopify payout arrived (net of fees)
090 · Main Bank
+£621.78
Difference (£20.62) → 422 · Shopify Fees

Customer matching — choose how Shopify customers map to Xero contacts.

Three modes for handling customers in per-order posting. All orders to one shared contact (clean and simple). Unique per order (customer name and email matched in Xero). Or fallback name (use a default unless the order has a customer).

  • Same customer: "Shopify Sales" — clean and simple
  • Unique per order: Match or create Xero contact by name + email
  • Fallback name: Default contact unless order has a customer
Customer Matching
Mode: Unique per order
JP
James P.
james.p@example.com · 4 orders YTD
Matched
SM
Sarah M.
sarah.m@example.com · 1 order YTD
New contact
AR
Alex R.
alex@example.com · 12 orders YTD
Matched
2Posting modes — per-payout / per-order
5Payment gateway routes
3Customer matching modes
6hAuto-sync cycle

Your Shopify payout should already be in Xero.

Whether you want simple per-payout invoicing or full order-level accounting with customer matching and payment gateway routing, Ceendesis handles it. Connect your store and every payout posts before you think to check.