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 offers both. Customer matching, SKU line items, payment gateway routing, and correct tax treatment included.
| Order | Customer | Items | Payment | Amount | Xero |
|---|---|---|---|---|---|
| #5842 | James P. | 3 SKUs | Shopify Pay | £38.40 | INV-1024 |
| #5843 | Sarah M. | 1 SKU | PayPal | £16.40 | INV-1025 |
| #5844 | Alex R. | 3 SKUs | Stripe | £52.20 | INV-1026 |
| #5845 | David K. | 2 SKUs | Shopify Pay | £28.80 | INV-1027 |
| #5846 | Emma W. | 4 SKUs | Shopify Pay | £64.80 | INV-1028 |
"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.
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 a capability few accounting tools offer.
Per-Payout
One Xero invoice per Shopify payout period. Simple, clean, fast.
| Sales Revenue | VAT 20% | £8,920 |
| Shipping Income | ZERO | £412 |
| Refunds | VAT 20% | −£212 |
| Shopify Fees | INPUT2 | −£288 |
| Net | £8,832 | |
- One invoice per weekly payout
- Aggregate sales, refunds, fees, shipping
- Bank reconciliation matches exactly
- Best for high-volume DTC stores
Per-Order
One Xero invoice per Shopify order. Customer detail. SKU lines. Payment routing.
| SP-BC-100ML | Beard Cream × 2 | £22.40 |
| SP-SH-250ML | Shampoo × 1 | £13.80 |
| Shipping | £3.99 | |
| VAT (20%) | £8.07 | |
| Total | £48.26 | |
- One invoice per order
- Customer matching by name and email
- SKU line items linked to Xero items
- Payment gateway routing per invoice
- Best for B2B, customer P&L, high-touch stores
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
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
+£642.40
+£621.78
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
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.